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(5)
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 | Discount May/2021-ALT | P13010-ALT | 2021-06-01 | 2021-06-01 | PROMOTION-ALT | DELETE-ALT | Promotion leaflet-ALT | CG258-ALT | 2 | 4 | Midsummer campaign | 1 | 4 | 3 | ALT-HISTORICAL-002 |
| default | Discount May/2021-EDGE | P13010-EDGE | 2021-06-02 | 2021-06-02 | PROMOTION-EDGE | DELETE-EDGE | Promotion leaflet-EDGE | CG258-EDGE | 3 | 5 | Midsummer campaign | 2 | 5 | 4 | EDGE-HISTORICAL-003 |
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
default
- nameR
- Discount May/2021-ALT
- campaignRPK
- P13010-ALT
- end_dateR
- 2021-06-01
- start_dateR
- 2021-06-01
- campaign_classR
- PROMOTION-ALT
- state
- DELETE-ALT
- category
- Promotion leaflet-ALT
- campaign_group
- CG258-ALT
- reward_quantity
- 2
- multiple_quantity
- 4
- campaign_group_name
- Midsummer campaign
- price_modification_value
- 1
- maximum_purchase_quantity
- 4
- minimum_purchase_quantity
- 3
- price_modification_method_code
- ALT-HISTORICAL-002
default
- nameR
- Discount May/2021-EDGE
- campaignRPK
- P13010-EDGE
- end_dateR
- 2021-06-02
- start_dateR
- 2021-06-02
- campaign_classR
- PROMOTION-EDGE
- state
- DELETE-EDGE
- category
- Promotion leaflet-EDGE
- campaign_group
- CG258-EDGE
- reward_quantity
- 3
- multiple_quantity
- 5
- campaign_group_name
- Midsummer campaign
- price_modification_value
- 2
- maximum_purchase_quantity
- 5
- minimum_purchase_quantity
- 4
- price_modification_method_code
- EDGE-HISTORICAL-003