Follow these instructions to use data blends in Google Sheets, Looker Studio, Excel, data warehouse destinations, and Query Manager (the Supermetrics API). Data blending is currently not available in monday.com.
Learn more about how the data blending feature works.
If you're interested in the data blending feature, contact us.
Before you begin
You need to create your data blends on the Supermetrics Hub before they can be used in destinations.
Instructions
- Navigate to Extensions → Supermetrics → Launch sidebar to open the Supermetrics sidebar.
- 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.
If you're using data blending in Looker Studio for the first time:
- On the Supermetrics Hub, select Transform → Data blending in the left sidebar.
- Click Use your blends in destinations.
- In the popup, click Go to connector to connect the data blend connector to Looker Studio.
- In Looker Studio, select a Supermetrics team and click Next.
- Select a data blend, and click Connect.
- Click Create report, and then Add to report.
- Select metrics and dimensions.
After connecting data blending to Looker Studio, you can find the data blending data source the same way as other data sources:
- 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.
- Select metrics and dimensions.
- 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.
In Power BI, the Data Blending data source is available through the old Query Manager.
- On the Supermetrics Hub, go to Destinations → Power BI.
- Click Manage queries in the old 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 query.
- To make the query available for Power BI, click Save query.
- On the Supermetrics Hub, go to API.
- Select Data Blending as the data source.
- Select a connection.
- Under Available blends, select a data blend.
- Select metrics and dimensions.
- Click Run.
Take a look at our article on how to use data blending in data warehouse and data lake transfers.