Modeled MMM data can be exported from Sellforte to the client's data warehouse, such as Snowflake or BigQuery. This enables clients to directly leverage Sellforte data in their internal dashboards and for other use cases. Data export occurs once daily to a location defined with the client. The data is exported in the tables described below:
Media dimension table
Defines possible media filters and media groupings in the web-UI.
| uuid_media | media_group | media_channel | media_role | campaign_type |
0 | 101 | TV | TV4 | Brand | Brand |
1 | 102 | Search | Google Ads | Brand | Always-on |
2 | 103 | Social | Meta | Brand | Brand |
3 | 104 | Social | Meta | Tactical | Offer |
4 | 105 | Own | Tactical | Offer |
Media investments and metrics
Describes media investment time series and optionally other media metrics for each media grouping.
Raw Metrics: These are the exact values directly from the data source, without any adjustments.
| date | uuid_media | media_investment |
0 | 2025-01-01 | 101 | 8000.0 |
1 | 2025-01-01 | 102 | 316.4 |
2 | 2025-01-01 | 103 | 0.0 |
3 | 2025-01-01 | 104 | 123.4 |
4 | 2025-01-01 | 105 | 0.0 |
Sales dimension table
Defines possible sales filters and sales groupings in the web-UI.
| uuid_sales | sales_channel | product_category1 | product_category2 |
0 | 201 | Store | Men's fashion | Shirts |
1 | 202 | Store | Men's fashion | Trousers |
2 | 203 | Online | Men's fashion | Underwear |
3 | 204 | Online | Men's fashion | Nightwear |
4 | 205 | Online | Men's fashion | Sports |
Base sales
Describes base sales time-series for each sales grouping.
Backtraced Metrics: These metrics include future uplifts from a media campaign, which are attributed back to the present day for a comprehensive view.
| date | uuid_sales | turnover | margin |
0 | 2025-01-01 | 201 | 13889.627916 | 1388.962792 |
1 | 2025-01-01 | 202 | 3251.702167 | 325.170217 |
2 | 2025-01-01 | 203 | 15667.834999 | 1566.783500 |
3 | 2025-01-01 | 204 | 12715.296613 | 1271.529661 |
4 | 2025-01-01 | 205 | 3020.111577 | 302.011158 |
Sales uplifts from promotions
Describes sales uplift time-series from promotions for each sales grouping.
Backtraced Metrics: These metrics include future uplifts from a media campaign, which are attributed back to the present day for a comprehensive view.
| date | uuid_sales | turnover | margin |
0 | 2025-01-01 | 201 | 906.342218 | 90.634222 |
1 | 2025-01-01 | 202 | 508.540740 | 50.854074 |
2 | 2025-01-01 | 203 | 308.820845 | 30.882085 |
3 | 2025-01-01 | 204 | 268.561999 | 26.856200 |
4 | 2025-01-01 | 205 | 114.233465 | 11.423346 |
Sales uplifts from media
Describes sales uplifts time series from a given media grouping to a given sales grouping.
Backtraced Metrics: These metrics include future uplifts from a media campaign, which are attributed back to the present day for a comprehensive view.
| date | uuid_media | uuid_sales | turnover | turnover_backtraced | margin | margin_backtraced |
0 | 2025-01-01 | 101 | 201 | 714.371521 | 315.808284 | 71.437152 | 31.580828 |
1 | 2025-01-01 | 101 | 202 | 59.322996 | 403.696737 | 5.932300 | 40.369674 |
2 | 2025-01-01 | 101 | 203 | 421.096302 | 776.940250 | 42.109630 | 77.694025 |
3 | 2025-01-01 | 102 | 201 | 735.094143 | 74.269548 | 73.509414 | 7.426955 |
4 | 2025-01-01 | 102 | 202 | 712.344089 | 580.173475 | 71.234409 | 58.017347 |