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 |
|
|