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.
Raw data
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.
Instructions
- 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.
Data blending
Google Sheets functions can help you combine data from several Supermetrics queries.
Use one or many raw data sheets or files to gather all the data you need before you start blending. Also, decide which fields you want to combine or have as is in your actual report.
We recommend that you add the functions and formulas to a separate file and pull the data to your sheet from there.
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.
For more tips and tricks, see our blog article about how to blend data in Google Sheets.