Historical campaigns
In ScopeTechnical: historical_campaigns | ID: RELEX-RA-HISTORICAL_CAMPAIGNS
Correcting historical sales (repl. and promo) and forecasting future campaigns (promo).
See how this object fits into Promotions
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 3 - Optimization Parameters
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- campaigns
Field Definitions(14)
Rules & Considerations(27)
Sample Load Data(4)
| _scenario | nameR | campaignRPK | end_dateR | start_dateR | campaign_classR | state | category | campaign_group | reward_quantity | multiple_quantity | campaign_group_name | price_modification_value | maximum_purchase_quantity | minimum_purchase_quantity | price_modification_method_code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Discount May/2021 | P13010 | 2021-05-31 | 2021-05-31 | PROMOTION | DELETE | Promotion leaflet | CG258 | 1 | 3 | Midsummer campaign | 0 | 3 | 2 | STD-HISTORICAL-001 |
default
- nameR
- Discount May/2021
- campaignRPK
- P13010
- end_dateR
- 2021-05-31
- start_dateR
- 2021-05-31
- campaign_classR
- PROMOTION
- state
- DELETE
- category
- Promotion leaflet
- campaign_group
- CG258
- reward_quantity
- 1
- multiple_quantity
- 3
- campaign_group_name
- Midsummer campaign
- price_modification_value
- 0
- maximum_purchase_quantity
- 3
- minimum_purchase_quantity
- 2
- price_modification_method_code
- STD-HISTORICAL-001