Discount Redemption Behavior Dataset

This dataset provides granular records of promotional discount redemptions in e-commerce, including customer, order, discount, and campaign details. It enables in-depth analysis of redemption patterns, campaign effectiveness, and customer segmentation to optimize future marketing strategies and drive sales growth.

  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Analyzing the effectiveness of promotional campaigns

Sample rows

preview · 8 of 85 rows · all 17 columns
redemption_idstringcustomer_segmentstringorder_total_before_discountfloatis_first_redemptionbooleancampaign_idstringcustomer_idstringdiscount_codestringdiscount_typestringdiscount_valuefloatdiscount_currencystringredemption_datetimedatetimeorder_idstringorder_total_after_discountfloatproduct_idsstringredemption_channelstringredemption_statusstringdiscount_expiry_datedate
RDM0001new85.5trueCMPG01CUST001WELCOME10percentage10blank2023-04-15T10:32:00ORD100176.95PROD001,PROD002websuccessful2023-05-01
RDM0002returning120falseCMPG02CUST002SPRING15percentage15blank2023-04-16T14:12:21ORD1002102PROD003mobile_appsuccessful2023-06-01
RDM0003VIP44.99falseCMPG03CUST003SHIPFREEfree_shipping0blank2023-04-18T09:42:07ORD100344.99PROD004,PROD005,PROD006websuccessful2023-05-10
RDM0004returning60falseCMPG04CUST004BOGO20buy_one_get_one20blank2023-04-18T16:22:33ORD100440PROD007,PROD008mobile_appsuccessful2023-05-31
RDM0005new30trueCMPG01CUST005FLAT5fixed_amount5USD2023-04-19T11:55:07ORD100525PROD009websuccessful2023-05-15
RDM0006VIP200falseCMPG05CUST006SUMMER25percentage25blank2023-04-19T16:02:18ORD1006150PROD010,PROD011websuccessful2023-07-01
RDM0007new75trueCMPG01CUST007WELCOME10percentage10blank2023-04-20T13:47:30ORD100767.5PROD012mobile_appsuccessful2023-05-01
RDM0008new95falseCMPG03CUST001SHIPFREEfree_shipping0blank2023-04-21T10:12:54ORD100895PROD002,PROD003,PROD013websuccessful2023-06-10

What the 85 rows show

from the 85-row sample

New (customer segment) stands out: 26 of its 27 rows have is_first_redemption = true, against 1 of 58 for the rest.

  • 32%is_first_redemption = true
  • 85.0median order_total_before_discount
  • 2discount currencies
  • 4discount types
  • 4redemption channels
  • 4redemption statuses
Is first redemption rate by customer_segmentis_first_redemption = true
0%50%100%0%returning0 of 3396%new26 of 274%VIP1 of 25

New (customer segment)'s mean order_total_before_discount is 59.4, against 94.8 for returning and 161.8 for VIP.

order_total_before_discount85 rows, in bands of 50
020401932158740150300order_total_before_discount →

Median 85.0, from 20.0 to 300.0.

campaign_id81 rows with a value · 4 left blank
  1. CMPG019
  2. CMPG026
  3. CMPG036
  4. CMPG046
  5. CMPG056
  6. CMP0236
  7. CMPG065
  8. CMP0194
  9. CMP0214
  10. CMP0114
17 columns by typefrom the column list below
  • string 11
  • float 3
  • date 1
  • datetime 1
  • boolean 1

Columns

17 columns in four groups
blueprint · 17 columns
columntypedescriptionexample
Text 11 columns
redemption_idstringUnique identifier for each discount redemption eventuniqueRDM0001
customer_idstringUnique identifier for the customer who redeemed the discountCUST001
discount_codestringCode of the promotional discount usedWELCOME10
discount_typestringType of discount (e.g., percentage, fixed amount, free shipping)5 valuespercentage
discount_currencystringCurrency code for the discount value (e.g., USD, EUR); empty for percentage discounts2 currencies · optionalUSD
order_idstringUnique identifier for the order associated with the redemptionORD1001
product_idsstringComma-separated list of product IDs included in the orderPROD001,PROD002
campaign_idstringIdentifier for the marketing campaign associated with the discountoptionalCMPG01
customer_segmentstringSegment or group the customer belongs to at the time of redemption (e.g., new, returning, VIP)3 segments · optionalnew
redemption_channelstringChannel through which the discount was redeemed (e.g., web, mobile app, in-store)web · mobile_app · in_store · otherweb
redemption_statusstringStatus of the redemption (e.g., successful, failed, expired, cancelled)successful · failed · expired · cancelledsuccessful
Numbers 3 columns
discount_valuefloatNumerical value of the discount (e.g., 10 for 10% or $10 off)0 or more10
order_total_before_discountfloatTotal order amount before applying the discount0 or more85.5
order_total_after_discountfloatTotal order amount after applying the discount0 or more76.95
Dates and times 2 columns
redemption_datetimedatetimeTimestamp when the discount was redeemed2023-04-15T10:32:00
discount_expiry_datedateDate when the discount code was set to expireoptional2023-05-01
True or false 1 column
is_first_redemptionbooleanIndicates if this is the customer's first time redeeming any discounttrue

Use it for

  • is first redem…32%27 of 85 rowsmean order total befo…94.8return…59.4new161.8VIP

    An e-commerce dashboard

    The is_first_redemption rate, order_total_before_discount by customer_segment and a breakdown of campaign_id. Excel, Power BI or Tableau.

  • Why do 27 of 85 rows have is_first_redemption = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable redemptions with customer_id, discount_code and discount_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset85 rows17 columns
Yours1,000 rows17 columns

blueprint · discount-redemption-behavior-dataset

Behind this dataset

Same schema. As many rows as you need.

These 85 rows came out of a blueprint — 17 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Include only completed transactions
  • Track discount code, date, and order value
  • Flag single-use versus multi-use code usage
  • Redemptions above 40% trigger success alert
  • Segment by customer group
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
discount-redemption-behavior-dataset

More in E-commerce

Browse all
Also in E-commerceShopping Cart Abandonment InsightsProduct Review DatasetE-commerce Packaging Sustainability IndexAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.