Supermetrics Complete Guide: Everything You Need to Know

What is Supermetrics?

Supermetrics is an API (Application Programming Interface) software that connects two programs. It connects data from different marketing platforms, such as Google Analytics, Facebook, PPC, and SEO tools, and loads it into a data warehouse.

• Data warehouse is a cloud-based storage system that allows businesses to consolidate data from multiple platforms and use it for analysis or reporting. Supermetrics supports the most popular data warehousing tools, including Google BigQuery, Snowflake, and Microsoft Azure Synapse.

Supermetrics eliminates the painstaking job of data exporting and modification, which is traditionally done manually in Excel or Google Sheets.

On the other end of the pipeline, Supermetrics helps teams quickly create engaging reports on consolidated data.

With Supermetrics, data extraction and transformation are automated, so teams have more time to focus on analysis and delivering results.

Supermetrics for data transfer

Supermetrics allows you to import any KPIs and dimensions from a range of marketing platforms and load it to your reporting, data visualization, data warehousing, or business application.

Source

To move data, you need access to the destinations. Note that Supermetrics doesn’t provide this access and needs read/write access to your data storage or BI tool before data transfer.

To run a data transfer with Supermetrics, you need to

1. Create a destination in your data warehouse or other cloud storage platform.
2. Create a transfer to move data from a data source to the destination. You can schedule the transfer to run automatically daily, weekly, or monthly. A single transfer is processed in less than 6 hours.
3. Run a backfill to import a batch of historical data to the destination. There are limitations on the time range for the backfill, which depends on the individual data sources and license you have.

Once you complete the initial setup, you can monitor the status of your transfers and get automatic email alerts for any possible errors.

Supermetrics provides standard denormalized schemas for the data sources that you can use. You have options to define queries by modifying the schema with Supermetrics Query Manager.

Supermetrics for online marketing reporting

Supermetrics is also a popular solution for creating marketing data reports with data from diverse sources. Supermetrics currently has connectors for around 70 digital marketing data sources, but you may run into a wall if you want to create a dashboard.

Supermetrics doesn’t have a data visualization feature. You can import the metrics but don’t have the means to report on them.

To visualize your data, you need to export it from Supermetrics to another analytics tool like Looker Studio (formerly Google Data Studio) or Tableau.

Most users prefer to use Looker Studio as a Supermetrics data visualization tool because it’s free and supports a range of data sources from both Google Cloud Platform and non-Google data (Semrush, Shopify, etc.)

Looker Studio is a versatile platform that allows you to start with a blank canvas and build any type of report.

1. Open Looker Studio and log in
2. Go to Create Report to display a new canvas
3. Click My data sources to find data sets you’ve already built using Supermetrics. Choose the one you want to use and hit Add.
4. A new report blank will open, and you can begin adding your charts.
5. Select Add a chart from the upper menu to add new elements to the report.

You can add filters and adjust data ranges, sources, products, categories, and so on.

Every time you refresh the browser window, your data will also update.

As you can’t aggregate and visualize data in a single tool, Supermetrics might not be the best choice for creating marketing reports.

Supermetrics connectors & integrations

Supermetrics helps businesses integrate data from more than 100 sales and marketing platforms with a range of reporting and analytics tools.

Most connectors supported by Supermetrics fall into one of the following categories

• Paid advertising — Facebook Ads, Google Ads, Amazon Ads, and TikTok Ads.
• Web analytics — Google Analytics, Google Analytics 4, and Adobe Analytics
• Mobile and app analytics — Facebook Audience Network and Apple Public Data
• Social media — Facebook, Instagram, and Twitter
• SEO tools — Google Search Console, Google My Business, and Ahrefs
• Ecommerce platforms — Shopify, Klaviyo, and Stripe
• Email automation — Mailchimp
• Sales — HubSpot, Salesforce, and CallRail

In addition, Supermetrics is constantly developing new data integrations. Users can even submit a request for a new connector or check the roadmap to see if the connector they’re looking for is already under development.

Supermetrics templates

Supermetrics offers a limited number of report templates that you can use.

But why are templates so important?

A template is a pre-made report with all the necessary information to create an engaging cross-channel or single-channel marketing report.

For example, a Google Ads report template comes pre-loaded with all the metrics, and KPIs needed to evaluate a Google Ads campaign.

You just connect your Google Ads account(s), and the report populates itself automatically.

Currently, Supermetrics offers only 11 Looker Studio templates. This means that if you need to create a quick report outside the box, you’re down to manual work.

At Whatagraph, on the other hand, we have over 100 different report templates for use cases like SEO, PPC, social media, eCommerce, and many more, that allow you to create all sorts of reports in just minutes.

Every Whatagraph report template comes with advanced metrics you need for precise reporting, such as click-through rate (CTR), bounce rate, conversion rate, number of leads, etc.

Since Supermetrics doesn’t have any templates of its own, you’re stuck with the little options that Looker Studio offers.

Supermetrics customer support

Supermetrics customer support is a pretty much self-serve venue.

Right off the bat, you have the option to choose whether you want to

• Get started
• Connect data
• Build reports
• Manage account

Each of these opens up an extensive library of written guides on different topics related to the parent topic.

If none of those guides solves your problem, or you simply don’t have time to browse through the library, you can create a ticket for the customer support team.

But if you take a look at online Supermetrics reviews, you’ll notice that most negative ones have one thing in common — they complain about its customer service.

Source

Multiple users have complained that it took several weeks to get an answer — not something you want in the midst of creating a marketing report.

If the response speed is what you’re looking for, you should try Whatagraph. Whether you contact us by live chat, email, or phone call, our customer support is on standby 20 hours a day, 5 days a week.

Whatagraph is ahead of its competitors in many areas, but customers particularly love our customer service.

Supermetrics pricing

Supermetrics offers a total of 15 pricing plans that users can pick from to meet their business needs.

The pricing is based on the destination, in other words, where you want to move your consolidated data.

This includes

• Visualization tools like Looker Studio
• Spreadsheets like Google Sheets and Excel
• Data warehouses like Google BigQuery, Snowflake, and Redshift
• Data lakes like S3 and Google Cloud Storage

With Supermetrics, you get fixed-fee pricing, so there are no surprise fees or surges in price due to added usage.

The good thing is that you always know what you’ll pay and what the package includes.

The not-so-good part is that you can only see the initial pricing plan for a couple of destinations, while the bulk of them are quote-based — you need to contact Supermetrics sales to find out.

Again, this is where the lack of native visualization can increase your costs.

For example, if you want to load data to Snowflake and visualize it in Looker Studio, you need to pay for both destinations.

Who is Supermetrics for?

Supermetrics is a good choice for smaller teams and businesses that are just starting with web analytics and need to process, store, and report on vast amounts of data from different sources. Loading data to a data warehouse and reporting through Looker Studio answers basic marketing performance questions like What happened when?

Source

Another user group is marketing agencies that handle hundreds of accounts, with each client using different data sources. Apart from data transfers and consolidation, agencies also benefit from the Supermetrics Looker Studio integration, as it greatly reduces the time and effort needed for regular client reporting.

Is Supermetrics the best data transfer and reporting tool?

Honestly, no. You can find our article on Supermetrics alternatives here.

Extracting and combining data from multiple sources has been a primary concern for small teams and large marketing agencies alike.

Supermetrics has made a massive leap by eliminating coding from the ETL process.

However, although Supermetrics has a solid base of loyal customers, other, more advanced data pipeline tools have emerged.

Whatagraph adopted the no-code approach and went a step further, simplifying data transfer to a point-and-click level.

What is more, Whatagraph has developed its proprietary reporting function from day 1.

You don’t have to use (and pay for) additional tools to create insightful reports on your business data.

If you want to try an all-in-one marketing data platform to connect, visualize, and share marketing data without third-party tools, or easily store your marketing data in BigQuery, book a demo call and find out how Whatagraph can help.