Skip to main content
Sellforte MMM schemas for Supermetrics S3 integration
M
Written by Mikko Ervasti
Updated over a year ago

Below you'll find schemas, and included queries for each data source. Build the Supermetrics data transfers to Sellforte's S3 according to these specs. Choose the data sources you are using! 😊

Google Analytics -schema

Query name

Metrics

Split by

Google Analytics Session

Sessions, Users, Transactions, Transaction revenue, Item revenue,Item quantity

Date, Account ID, Account name, Web property ID, Web property name, Country, User type, Source & medium, Channel group, Campaign ID, Campaign

Google Analytics Order

Transaction revenue, Transaction shipping, Transaction tax

Date, Account ID, Account name, Web property ID, Web property name, Country, User type, Source & medium, Channel group, Transaction ID, Campaign ID, Campaign

Google Analytics Item

Item revenue, Item quantity

Date, Account ID, Account name, Web property ID, Web property name, Transaction ID, Product SKU, Product name, Product Brand, Product Category Level 1, Product Category Level 2, Product Coupon Code, Currency code

Google Analytics 4 -schema

Query name

Metrics

Split by

Google Analytics 4 Session

Sessions, Total users, Purchases, Revenue, Item revenue, Item purchase quantity

Date, GA4 property ID, GA4 property, Country, New vs returning, Session source / medium, Session default channel grouping, Session campaign ID, Session campaign name

Google Analytics 4 Order

Revenue, Shipping amount, Tax amount

Date, GA4 property ID, GA4 property, Country, New vs returning, Session source / medium, Session default channel grouping, Transaction ID, Session campaign ID, Session campaign name

Google Analytics 4 Item

Item revenue, Item purchase quantity

Date, GA4 property ID, GA4 property, Transaction ID, Item ID, Item name, Item variant, Item brand, Item category, Item category 2, Item promotion name

Google Ads -schema

Query name

Metrics

Split by

Google Ads Metrics

Cost, Cost (EUR), Cost (GBP), Cost (USD), Impressions, Clicks, Conversions, Total conversion value, Return on ad spend (ROAS), All conversions, All conversion value, Impression share, Search exact match impression share, Absolute top impression percentage, Top impression percentage, Available impressions, Lost impressions due to budget, Lost impressions due to rank, Search click share, Video views, Watch 100% views, Interactions

Date, Account ID, Account, Campaign ID, Campaign name, Advertising channel type, Advertising channel sub-type, Campaign labels, Bidding strategy type, Bidding strategy, Currency code

Google Ads Country

Cost, Cost (EUR), Cost (GBP), Cost (USD), Impressions, Clicks, Conversions, Total conversion value, Return on ad spend (ROAS), All conversions, All conversion value

Date, Account ID, Account, Campaign ID, Campaign name, Advertising channel type, Advertising channel sub-type, Country, Currency code

Google Ads Ad Group

Cost, Cost (EUR), Cost (GBP), Cost (USD), Impressions, Clicks, Conversions, Total conversion value, Return on ad spend (ROAS), All conversions, All conversion value

Date, Account ID, Account, Campaign ID, Campaign name, Advertising channel type, Advertising channel sub-type, Ad group ID, Ad group name, Ad group type, Max CPA (1-per-click), Max CPC, Campaign labels, Ad group labels, Currency code

Facebook Ads -schema

Query name

Metrics

Split by

Facebook Ads Metrics

Cost, Cost (EUR), Cost (GBP), Cost (USD), Impressions, Link clicks, Website purchases, Website purchases conversion value, Website purchase ROAS (return on advertising spend), Video play actions, Video watches at 100%

Date, Account ID, Account name, Campaign ID, Campaign name, Ad set ID, Ad set name, Ad set tags, Publisher platform, Targeting country location, Placement, Campaign objective, Campaign buying type, Campaign tags, Attribution setting, Currency

Facebook Ads Country

Cost, Cost (EUR), Cost (GBP), Cost (USD), Impressions, Link clicks, Website purchases, Website purchases conversion value, Website purchase ROAS (return on advertising spend), Video play actions, Video watches at 100%

Date, Account ID, Account name, Campaign ID, Campaign name, Ad set ID, Ad set name, Ad set tags, Targeting country location, Campaign objective, Campaign buying type, Campaign tags, Attribution setting, Country, Currency

Microsoft Advertising (Bing) -schema

Coming soon!

Query name

Metrics

Split by

Microsoft Advertising Country

Microsoft Advertising Metrics

Microsoft Advertising Ad Group

TikTok Ads -schema

Query name

Metrics

Split by

TikTok Ads Metrics

Cost, Cost (EUR), Cost (GBP), Cost (USD), Impressions, Clicks, Conversions, Total complete payment value, Complete payment ROAS, Complete payment ROAS (onsite), Video views, Video views at 100%, 6-second video views, 2-second video views, Total page views (onsite), Total place an order value, Total checkout value

Date, Advertiser ID, Advertiser name, Campaign type, Campaign ID, Campaign name, Ad group ID, Ad group name, Campaign objective type, Optimization goal, Bid method, Bidding strategy, Bid, Deep bid type, Placement type, Currency

TikTok Ads Country

Cost, Cost (EUR), Cost (GBP), Cost (USD), Impressions, Clicks

Date, Advertiser ID, Advertiser name, Campaign type, Campaign ID, Campaign name, Ad group ID, Ad group name, Campaign objective type, Optimization goal, Bid method, Bidding strategy, Bid, Deep bid type, Placement type, Country, Currency

Snapchat Marketing -schema

Query name

Metrics

Split by

Snapchat Marketing Metrics

Cost, Cost (EUR), Cost (GBP), Cost (USD), Paid impressions, Ad clicks, Purchases, Purchases value, ROAS, Swipes, Video views, Video completions

Date, Ad account ID, Ad account name, Campaign ID, Campaign name, Ad squad ID, Ad squad name, Campaign objective, Ad squad type, Ad squad optimization goal, Buy type, Ad squad billing event, Ad squad placement, Country, Ad account currency

Pinterest Ads -schema

Coming soon!

Query name

Metrics

Split by

Pinterest Ads Metrics

LinkedIn Ads -schema

Coming soon!

Query name

Metrics

Split by

LinkedIn Ads Metrics

LinkedIn Ads Country Daily

LinkedIn Ads Country Monthly

Google Search Ads 360 -schema

Coming soon!

Query name

Metrics

Split by

Google Search Ads 360 Ad Group

Google Search Ads 360 Metrics

Google Campaign Manager 360 -schema

Query name

Metrics

Split by

Google Campaign Manager 360 Metrics

Cost Per Activity, Cost Per Click, DBM Cost (Account Currency), Impressions, Clicks, Total Conversions, Total Revenue, Video Views, Video Completions

Date, Account ID, Account, Country, Campaign, Campaign ID, Advertiser Group, Placement

Klaviyo -schema

Coming soon!

Query name

Metrics

Split by

Klaviyo Country

Klaviyo Metrics

Did this answer your question?