Skip to main content

Exporting MMM Data to Data Warehouse

O
Written by Oskari Raunio
Updated yesterday

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

Email

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

Did this answer your question?