Exporting promo code data helps you measure campaign performance, track redemptions, and analyse customer behaviour. Deliverit Studio lets you extract a detailed Excel file with historical promo code statistics.
Step-by-Step Guide
Log in to Deliverit Studio
- Sign in with an admin account that has permission to view promo code reports.
Open the Promo Code (Promocode) Section
- From the left-hand menu, click Promocode (or Promotions) to view your list of promo campaigns.
Click the Export Button
- At the top-right of the Promo Code page, click Export. Deliverit Studio will generate an Excel file containing the selected promo code data.
Download / Open the Excel File
- Once the extract is complete, download and open the Excel file to review the exported records.
Save & Back Up the Export
- Store the file in your reports folder (or cloud storage) and keep a backup if you’ll use the data for audits or long-term analysis.
Here’s a quick overview to help you understand what each column stands for.
- promotionalCode / singlePromoCode — This is the actual code customers type in at checkout to claim their discount or offer.
- campaignName — The name you gave to the promotion. It helps you identify which promo campaign the code belongs to.
- startDate / startTime — Shows the exact date and time when the promo started or became active.
- expireDate / endTime — Shows the date and time when the promo ended or stopped working.
- daysAvailable — Lists the days of the week when the promo could be used, such as Monday to Friday or weekends only.
- Minimum Order — The lowest total amount a customer needs to spend for the promo to apply.
- total redemptions — Indicates how many times the promo has been used in total by all customers.
- Redeemed — Tells you whether a specific promo entry has been used. “True” means it was redeemed, while “False” means it hasn’t been used yet.
- isExpired — Shows whether the promo has already expired. “True” means it’s no longer active, and “False” means it’s still valid.
- When it expired — A note or record showing the date and time the promo officially expired.
- tablePLU / pickupPLU / deliveryPLU — These are the unique item codes linked to table, pickup, or delivery orders included in the promotion.
Exporting promo code data regularly helps you spot trends, measure ROI, and optimise future promotions. If you need further assistance, please contact our Application Support team or visit our Knowledge Base for more detailed Help Guides.