How to use Supermetrics add-on for Google Sheets

How to use Supermetrics

Supermetrics add-on is a paid service that will help you tie in all of your efforts and improve outcomes. It is a cloud-based software you can use for reporting, monitoring, and analyzing your digital metrics. Gathering all of your digital data is time-consuming and tedious. It can certainly take a long time to gather and crunch the numbers from all of your social media accounts and advertising platforms.

On top of gathering the data, you need to store it somewhere, and then create reports to show your team or your clients. Not only do you or your employees need to do these tasks, but you also need to do them right! Yikes. 

Supermetrics removes some of these tasks from your workflow by automating data import, storage, and reporting. If you learn how to use Supermetrics with Google Sheets, you can use Google’s unique sharing features to automate the way internal and external people can view, comment on, or edit the data and reports.

New to the tool? Our Supermetrics overview covers its features, pricing, and alternatives.

So What Kind Of Data Are We Talking About?

Supermetrics can integrate with more than 100 data sources! So whether you are pulling from social media platforms, advertising services, or even your own databases, Supermetrics has you covered!

Just a Few of the Sources That the Supermetrics Add-on Can Connect to:

• AdSense
• Bing Ads
• DoubleClick (all)
• Facebook Ads and Insights
• Google Ads, Analytics, BigQuery, My Business, Search Console and, Google+
• Instagram
• LinkedIn
• MailChimp
• Moz
• Optimizely
• Pinterest
• Reddit
• Searchmetrics
• SEMrush
• Stripe
• Tumblr
• Twitter
• Vimeo
• Databases: MySQL, Oracle, Google Cloud SQL, SQL Server, PostgreSQL, MariaDB, Redshift

Who is Using Supermetrics?

Unlike many types of software, which are ideal for either small or enterprise sized businesses, Supermetrics is great for companies of all sizes. This add-on is used by marketing agencies who want to provide reports to their clients, and by companies of all sizes that have their own marketing department.

What Kind of Reporting Does Supermetrics Provide?

What is really neat about this add-on is that there is so much flexibility in the kind of insights you can gain using this tool!

There are many options out there for reporting using Google Sheets, but not many can offer the kind of simple customization that Supermetrics does.

Visualizing advanced data metrics like cross-channel reporting and multi-account budget pacing can significantly transform your business.

• Cross-channel reporting allows you to see the big picture of what’s happening across all of your digital accounts to really compare what is working and where you can improve.
• Budget-pacing, whether for single accounts or across multiple accounts, is a super valuable metric to track to ensure that your dollars are going to the right place and are actually making their mark on your campaigns.

This kind of reporting is really valuable when you are managing accounts for other people. New clients can feel nervous handing over huge budgets for advertising and marketing. With Supermetrics you can provide reports that contain both value content and visual appeal so they can easily understand the effectiveness of your campaigns.

How to Access the SuperMetrics Add-on

It is really simple to get add-ons for Sheets! The fastest way to install the SuperMetrics add-on is to click this link that will take you directly to the web store.

Simply click the Install button and the add-on will be added to your Google Sheets account.

Alternatively, you can get the add-on by following these steps:

1. Open a spreadsheet

2. Click the add-ons button in the navigation menu

3. Click the Get add-ons button

4. A window will pop up for you to browse

5. Type “Supermetrics” in the search box.

6. Click the Free button to get the add-on.

How to Get Started Using the Add-on

Now that you have added it to your Google Sheets, it’s time to get started using it. Click Add-ons → Supermetrics → Launch.

.

The Supermetrics toolbar will launch on the right side of your spreadsheet. Simply click on any of the logo buttons to connect any of your accounts to your Google Sheets. For this demo, I am connecting it to my Twitter account. Using the sidebar, you can run queries related to any of your accounts.

Next, I will insert a template onto my spreadsheet from the sidebar. Supermetrics offers over 100 templates that you can use out of the box or customize, or, as you advance, simply create custom templates from scratch. I am going to run a social media conversation template using “Sheetgo” as the keyword.

How to use Supermetrics add-on for Google Sheets

Within a few minutes, Supermetrics has gathered data from the web and provided a detailed report about who is mentioning us around various social media platforms. These are just a few of the basic things you can do with Supermetrics. The options and insights are nearly limitless, and you will need to tailor your solution to you. Supermetrics offers great guidance from within the add-on, and also on their forum and solutions page.

Using the add-on, you might need to get data from all sorts of different channels, into different spreadsheets. Of course, this doesn’t help if you want to easily create reports from this data. Therefore, it is valuable to centralize all this data into a single master dashboard. All of this is possible with  Sheetgo, simply by merging all of your spreadsheets together.