Step 1: Access Query Manager and choose the wanted data source
Log in to your account in Supermetrics and use the side menu to navigate to "Transform" > "Query Manager (API)".
The following view will open, where all your connected data sources are listed. Please choose the data source you want to build the query for, for example Facebook Ads.
Step 2: Create a new MMM schema
To create and provide the best MMM solution, we want to have customer's data in several different hierarchical levels. Therefore we have MMM data schemas for each of the data sources, and each schema includes 1-3 queries.
Accordingly, please create a new schema for each of the data sources you have. Do this after accessing Query Manager by clicking "Schemas" and "+ New schema". A pop up window will open, where you will name the schema. Name it according to the data source in use, like: Facebook Ads MMM.
Step 3: Create a query
Our schemas include 1-3 queries. Please check all schemas and their respective queries and which dimensions and metrics they include: Sellforte MMM Schemas for Supermetrics S3 integration
Query Manager let's you choose all the metrics and dimensions you want to include in each of the queries. Make sure you have chosen "for Data Warehousing" before you start to build the query.
Step 3: Add the query into the respective schema
Choose all the split by dimensions and metrics according to Sellforte's MMM schema requirements. Then click "Add to schema".
A pop up window opens. Name the query according to our instructions. Choose the schema you want to add the query into.
Step 4: Finished!
Please check that your custom MMM schema for the data source includes all the same queries that are listed in our requirements.
Step 5: Continue creating the next schema for the next data source 😊
Creating these schemas requires some work in the start, but after you've done them once, you never have to touch them again! After that everything is automated. 🚀