Supermetrics brings data from more than 100 data sources — including Facebook Ads, Google Analytics 4, HubSpot, and more — together into your reporting platforms.
Read on to learn how Supermetrics works and start automating your data.
Connect your data
Supermetrics acts as a data pipeline, pulling information from all your different sources and sending it to places like Google Sheets, Looker Studio (formerly Data Studio), Excel, and even cloud storage platforms like BigQuery and Snowflake.
Supermetrics does this by tapping into each data source's API. You tell us which accounts to use, what data you want, and where you want it to go, and Supermetrics takes care of the rest.
Want to learn more? Check out our connection guides to see how to connect your data sources to Supermetrics from the Supermetrics Hub or your data destination.
For available fields, take a look at the field list documentation for each connector.
Connect your accounts, easily
When connecting to a data soruce, you'll select the specific data source accounts you want to pull data from. Whether it's "accounts" in Facebook Ads, "properties" in Google Analytics 4, or "profiles" in Instagram Insights — Supermetrics calls them data source accounts to keep things simple.
You'll need a Google or Microsoft account to log in to Supermetrics, but you can use any data source account to build your reports. Just make sure the accounts have the data you want and that you have the access you need to get the data — our connection guides tell you in detail what's required for each data source connector.
Ready to learn more? See how to easily manage your data source accounts and your Supermetrics subscriptions and teams.
Share the connection with your team
Collaboration among teams is at the heart of Supermetrics. A group of Supermetrics license users is called a team, and it means the users who use the same Supermetrics subscription to report data on the reporting tools their subscription includes. Note that the number of team members will depend on your Supermetrics package.
To make things even easier, teammates can share data source connections. One person can connect to a data source and share the connection with the whole team!
Build reports that work for you
With a query, you tell Supermetrics exactly which data you want. Supermetrics will pull the metrics and dimensions from your selected data source into your reporting tool. Your task is to define the date ranges, campaigns, accounts, and other details to use in the report. Use as many queries as you want — in a single report!
Best of all, you can connect multiple data sources and query their data in one single report. Explore our report building guides and start building queries with confidence.
Automate your reports
Once you've set up your reports, Supermetrics can automatically update and share them with anyone who needs to see your reporting.
You can also set up alerts for data warehouse destinations, Google Sheets, and Excel and be notified by email, on Slack, or on Teams channel.
Google Sheets and Excel
If you're using Google Sheets or Excel, use scheduled reports to automatically send copies of your up-to-date reports to any email inbox.
- How to create and manage scheduled reports in Google Sheets
- How to set up scheduled report triggers in Excel
Looker Studio and Power BI
Looker Studio allows you to schedule any report to be delivered by email, including reports you build with Supermetrics. Learn more about scheduled email delivery.
In Power BI, you can set up scheduled refreshes for your data.
Manage and shape your data with transformation features
Supermetrics allows you to transform your data in a couple of different ways. That means your team can create rules, structure, and data foundation that feed directly into your custom dashboards, structured reports, and data flows that align with your goals right out of the box.
- With custom fields, you can edit and/or manage existing fields or create entirely new ones. This feature allows you to scale your manual operations and ensure every report adheres to your data governance policies.
- With data blending, you can combine multiple data sources together and get a holistic picture of your performance.
There are various use cases for these features. You can, for example, combine custom fields and data blending to create a ROAS report.
Ready to get started?
Follow these guides to get started with the data destination of your choice!