You need to create your data blends on the Supermetrics Hub before they can be used in destinations. Learn more about how the data blending feature works.
Follow these instructions to use your blends in Google Sheets, Looker Studio, Excel, and Query Manager (Supermetrics API). Data blending is currently not available in our data warehouse destinations or in monday.com.
If you're interested in the data blending feature, contact us.
Instructions
- Navigate to Extensions → Supermetrics → Launch sidebar to open Supermetrics.
- Click Create new query.
- Under Data source, select Data Blending.
- Select a connection.
- Under Available blends, select a data blend.
- Select metrics and dimensions.
- Click Get Data to Table.
- In Looker Studio, click Add data.
- Select the Data Blending data source by Supermetrics.
- Select a team, and click Next.
- Select a data blend.
- In the pane's top right, click Connect.
- Click Create report.
- Click Add to report.
- Click Data → Show Supermetrics to open the sidebar.
- Under Data source, select Data blending.
- Select a connection.
- Under Available blends, select a data blend.
- Select metrics and dimensions.
- Click Get data.
- On the Supermetrics Hub, go to Transform → Query Manager.
- Select Data Blending as the data source.
- Select a connection.
- Under Available blends, select a data blend.
- Select metrics and dimensions.
- Click Run.