Checking for coupon code abuse using ChatGPT and MESA
To check for coupon code abuse, set up a workflow that triggers on order creation and saves order information to Mesa data store. Then, run a query to group data by day, comparing total price spent on orders and total discounts for each day.
Use the GPT-4 API to analyze the results and determine if the most recent day's discount rate is higher than usual. If the answer is "yes," an email will be triggered to notify you of potential coupon code abuse, allowing you to take appropriate action.
🔗 Install Templates