E-commerce Price Change Event Logs
This dataset records granular, time-stamped logs of price updates, promotion triggers, and inventory changes for online retail products, enabling dynamic pricing analysis and campaign ROI measurement. It is structured for easy integration with analytics platforms and supports detailed tracking of product, promotion, and inventory events across multiple sales channels.
Sample rows
preview · 8 of 200 rows · all 18 columns| event_idstring | promotion_typestring | roi_estimatefloat | currencystring | event_timestampdatetime | product_idstring | skustring | event_typestring | old_pricefloat | new_pricefloat | promotion_idstring | promotion_valuefloat | inventory_level_beforeinteger | inventory_level_afterinteger | channelstring | user_idstring | campaign_idstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EVT-000001 | blank | blank | USD | 2024-03-04T09:42:18Z | PROD-00011 | SKU-CHR-0024 | price_update | 249.99 | 239.99 | blank | blank | 120 | 120 | web | user_4631 | blank | Adjusted price in line with competitor trends. |
| EVT-000002 | discount | 0.18 | blank | 2024-03-04T10:13:45Z | PROD-00017 | SKU-LPT-0097 | promotion_trigger | blank | blank | PROMO-1033 | 10 | 46 | 46 | mobile | user_9917 | CMP-4022196 | 10% discount activated for weekend sale event. |
| EVT-000003 | blank | blank | blank | 2024-03-04T11:25:09Z | PROD-00005 | SKU-SHO-0301 | inventory_correlation | blank | blank | blank | blank | 520 | 485 | marketplace | user_4820 | blank | Inventory decreased due to bulk order fulfillment. |
| EVT-000004 | blank | blank | USD | 2024-03-04T13:07:29Z | PROD-00012 | SKU-CHR-0025 | price_update | 399.95 | 419.95 | blank | blank | 60 | 60 | web | user_7264 | blank | Price increased for new model launch. |
| EVT-000005 | flash_sale | 0.25 | blank | 2024-03-04T15:34:17Z | PROD-00014 | SKU-DRS-0086 | promotion_trigger | blank | blank | PROMO-1045 | 50 | 200 | 200 | web | user_8841 | CMP-4022201 | Flash sale triggered for limited SKUs. |
| EVT-000006 | blank | blank | EUR | 2024-03-04T08:12:55Z | PROD-00008 | SKU-TBL-0212 | price_update | 89.99 | 84.99 | blank | blank | 305 | 305 | marketplace | user_2748 | blank | Seasonal markdown applied before spring promotion. |
| EVT-000007 | blank | blank | blank | 2024-03-04T14:39:02Z | PROD-00003 | SKU-BAG-0345 | inventory_correlation | blank | blank | blank | blank | 55 | 54 | web | user_5132 | blank | Single unit sold; inventory adjusted. |
| EVT-000008 | bundle | 0.29 | blank | 2024-03-04T16:17:41Z | PROD-00015 | SKU-TOP-0192 | promotion_trigger | blank | blank | PROMO-1057 | 20 | 115 | 115 | mobile | user_3672 | CMP-4022208 | Bundle offer applied to product and accessories. |
| EVT-000009 | blank | blank | blank | 2024-03-04T18:55:24Z | PROD-00009 | SKU-TBL-0288 | inventory_correlation | blank | blank | blank | blank | 320 | 315 | marketplace | user_5883 | blank | Stock adjusted post shipment. |
| EVT-000010 | blank | blank | USD | 2024-03-05T09:23:36Z | PROD-00007 | SKU-SHO-0318 | price_update | 49.99 | 44.99 | blank | blank | 610 | 610 | web | user_1010 | blank | Price dropped following customer feedback. |
| EVT-000011 | discount | 0.21 | blank | 2024-03-05T10:48:55Z | PROD-00018 | SKU-LPT-0111 | promotion_trigger | blank | blank | PROMO-1060 | 15 | 38 | 38 | web | user_7712 | CMP-4022213 | Discount applied for new customer acquisition. |
| EVT-000012 | blank | blank | USD | 2024-03-05T13:02:20Z | PROD-00016 | SKU-TOP-0201 | price_update | 29.99 | 32.99 | blank | blank | 205 | 205 | mobile | user_3549 | blank | Minor price increase for new colorways. |
| EVT-000013 | blank | blank | blank | 2024-03-05T15:16:44Z | PROD-00001 | SKU-BAG-0341 | inventory_correlation | blank | blank | blank | blank | 120 | 118 | web | user_2486 | blank | Two units reserved for scheduled pickup. |
| EVT-000014 | blank | blank | EUR | 2024-03-05T16:51:33Z | PROD-00002 | SKU-BAG-0342 | price_update | 79.99 | 77.99 | blank | blank | 78 | 78 | marketplace | user_3530 | blank | Price adjusted for regional VAT compliance. |
| EVT-000015 | other | 0.13 | blank | 2024-03-05T18:22:04Z | PROD-00013 | SKU-DRS-0087 | promotion_trigger | blank | blank | PROMO-1072 | 5 | 75 | 75 | mobile | user_4015 | CMP-4022219 | Special loyalty promotion triggered. |
| EVT-000016 | blank | blank | blank | 2024-03-06T09:07:16Z | PROD-00004 | SKU-SHO-0307 | inventory_correlation | blank | blank | blank | blank | 422 | 420 | marketplace | user_7120 | blank | System reconciliation after daily audit. |
| EVT-000017 | blank | blank | USD | 2024-03-06T10:31:29Z | PROD-00019 | SKU-LPT-0116 | price_update | 999.99 | 959.99 | blank | blank | 11 | 11 | web | user_8356 | blank | Price reduced for aging inventory clearance. |
| EVT-000018 | flash_sale | 0.5 | blank | 2024-03-06T12:44:18Z | PROD-00010 | SKU-TBL-0299 | promotion_trigger | blank | blank | PROMO-1088 | 100 | 3 | 3 | web | user_2290 | CMP-4022222 | Flash sale on seasonal overstock. |
| EVT-000019 | blank | blank | blank | 2024-03-06T13:55:37Z | PROD-00006 | SKU-SHO-0303 | inventory_correlation | blank | blank | blank | blank | 900 | 890 | marketplace | user_9035 | blank | Bulk shipment fulfilled for B2B customer. |
| EVT-000020 | blank | blank | USD | 2024-03-06T15:23:40Z | PROD-00020 | SKU-LPT-0128 | price_update | 1299.99 | 1279.99 | blank | blank | 8 | 8 | mobile | user_6734 | blank | High-end laptop price adjusted in line with market. |
What the 200 rows show
from the 200-row sampleFlash_
- 0.22median roi_
estimate - 3event types
- 4channels
- 65.0median old_
price - 59.0median new_
price - 20.0median promotion_
value
Median 0.22, from 0.09 to 0.50.
- string 11
- integer 2
- float 4
- datetime 1
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
event_id | string | Unique identifier for each price change event log entryunique | EVT-000001 |
product_id | string | Unique identifier for the product affected by the event | PROD-00011 |
sku | string | Stock Keeping Unit for the productoptional | SKU-CHR-0024 |
event_type | string | Type of event: price_update, promotion_trigger, inventory_correlation3 values | price_update |
promotion_id | string | Identifier for the triggered promotion (if applicable)optional | PROMO-1033 |
promotion_type | string | Type of promotion triggered (e.g., discount, bundle, flash_sale)discount · bundle · flash_sale · other · optional | discount |
currency | string | Currency code for price fields (ISO 4217 format)5 currencies · optional | USD |
channel | string | Sales channel where the event occurred (e.g., web, mobile, marketplace)web · mobile · marketplace · other · optional | web |
user_id | string | Identifier for the user or system who initiated the eventoptional | user_4631 |
campaign_id | string | Identifier for the marketing campaign associated with the event (if any)optional | CMP-4022196 |
notes | string | Additional notes or comments about the eventoptional | UK region price lowered. |
| Numbers 6 columns | |||
old_price | float | Previous price of the product before the event0 or more · optional | 249.99 |
new_price | float | Updated price of the product after the event0 or more · optional | 239.99 |
promotion_value | float | Value of the promotion (e.g., discount amount or percentage)0 or more · optional | 10 |
inventory_level_before | integer | Product inventory level before the event0 or more · optional | 120 |
inventory_level_after | integer | Product inventory level after the event0 or more · optional | 120 |
roi_estimate | float | Estimated ROI for the campaign or price change (if applicable)optional | 0.18 |
| Dates and times 1 column | |||
event_timestamp | datetime | Date and time when the event occurred | 2024-03-04T09:42:18Z |
Use it for
An e-commerce dashboard
Roi_
estimate by promotion_ type and a breakdown of currency. Excel, Power BI or Tableau. Why do the 17 flash_
sale rows have a mean roi_ estimate of 0.36? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Events200EVT-000001—EVT-0000020.18discountEVT-000003—
A software demo
Believable events with event_
timestamp, product_ id and sku to fill a screen in front of a buyer.
blueprint · e-commerce-price-change-event-logs
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 18 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.
- Product ID and category mapping
- Price change event timestamp
- Flag promotional triggers
- Correlate with inventory levels
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
- e-commerce-price-change-event-logs