Raw data and data blending offer extra flexibility if you're building or optimizing complex Supermetrics queries in Google Sheets.
Data blending helps to combine data from several queries into one set of results, while raw data can product data in a variety of formats. Both processes use Google Sheets functions.
Sometimes a query can’t produce data in the format you need. You might want to combine fields or arrange the data in a way that isn’t possible in a query. A “raw data” sheet helps with this by getting the data in one place.
- Set up your query with the "Combine new results with old" setting enabled.
- Set a scheduled refresh to update your query, with any frequency.
- In a new tab, create the report you need.
- Reference the data in the "raw data" sheet.
This is also a good way to combine data from multiple data sources. Gather the raw data from each data source into its own tab, and combine the data on a separate tab. Learn more about data blending below.
Google Sheets functions can help you combine data from several Supermetrics queries.
Use one or many raw data sheets to gather all the data you need before you start blending. Also, decide which fields you want to combine or just have in your actual report.
You can use data reference to another sheet by typing the sheet name and the data location:
=Sheet1!A1 or ='Sheet number two'!B4.
You can also get data from another Google Sheets file if you prefer keeping things separate.
Learn more about the full range of functions available in Google Sheets in Google's documentation. Other useful functions you might want to take a look at are VLOOKUP, HLOOKUP, INDEX, and MATCH.