Skip to content

Supermetrics Google Sheets

supermetrics google sheets

Supermetrics for Google Sheets is the number 1 tool for automating online reporting through a Google sheets plug-in.

For those who are familiar with Excel and Power Point reports, this tool will help you to generate automatic updates online without the tedious task of exporting data or downloading it and doing the task manually. All through a Google account.

Supermetrics is a Google sheets add-on that allows you to obtain different indicators, metrics and dimensions from the main marketing platforms of the market. All the information is obtained in tables, which can be modified and moved to build dashboards and fully customized reports.

📊Which platforms connects with Supermetrics for Google sheets?

This is the list of platforms from which you can obtain indicators through Supermetrics for Google sheets:

  • Adform
  • Adobe Analytics
  • Adobe Analytics 2.0
  • Adroll
  • Ahrefs
  • Apple App Store / iTunes
  • Apple Search Ads
  • Azure Synapse
  • Bing Services
  • Bing Webmaster Tools
  • CallRail
  • Criteo
  • Custom JSON/CSV
  • Database
  • Facebook Ad Library
  • Facebook Ads
  • Facebook Audience Network
  • Facebook Insights
  • Facebook Public Data
  • Google Ad Manager
  • Google Ads
  • Google Adsense
  • Google Analytics
  • Google Analytics 4
  • Google Big Query
  • Google Campaign Manager
  • Google Display & Video 360
  • Google My Business
  • Google Search Console
  • Google Sheets
  • Google Trends
  • Hubspot
  • Instagram Insights
  • Instagram Public Data
  • Klaviyo
  • LinkedIn Ads
  • LinkedIn Company Pages
  • Mailchimp
  • Microsoft Advertising (Bing)
  • MOZ
  • Netvisor
  • Optimizely
  • Outbrain Amplify
  • PayPal
  • Pinterest Ads
  • Pinterest Organic
  • Pinterest Public Data
  • Quora Ads
  • Reddit Public Data
  • Salesforce
  • Salesforce Marketing Cloud
  • Searchmetrics
  • SEMrush Analytics
  • SEMrush Projects
  • Shopify
  • Snapchat Marketing
  • Snowflake
  • StackAdapt
  • Stripe
  • Taboola
  • The Trade Desk
  • TikTok Ads
  • Tumblr Public Data
  • Twitter Ads
  • Twitter Premium
  • Twitter Public Data
  • Utilities
  • Verizon Media DSP
  • Verizon Media Native Ads
  • VKontakte Public Data
  • Yandex.Direct
  • Yandex.Metrica
  • YouTube

More from Supermetrics supermetrics logo Google Sheets

Click Here to claim your FREE trial!

💬What information can you get from Supermetrics Google sheets?

According to the platform you choose, Supermetrics will show you all the metrics and dimensions it has access to. If you are immersed in media, you should know them, they are those that you handle every day to build your reports; for example, in metrics we find new followers, clicks, impressions, interactions, reach, sessions, etc. In dimensions we find dates, advertising platforms, traffic sources, ad groups and many more.

☑️Advantages and disadvantages of Supermetrics for Google Sheets

✔️Advantages Supermetrics Google Sheets

  • No more .csv file downloads from advertising and organic platforms.
  • No more building tedious files every day, week, month, etc, in .ppt and .xsl.
  • Save time of downloading files, and use it for analysis and a real good reporting and recommendations.
  • Don’t pay for complex tools that you can’t customize and always depend on a third party to do you the “favor” of helping you.
  • Create your own dashboards and share them to whoever you need, you choose the privacy and you only need a Google account, access to the platforms and Supermetrics.
  • Build your own customized dashboards for tracking indicators and generate flash reports of what happens with your campaigns.

⛔Disadvantages Supermetrics Google Sheets

📈Using Supermetrics for Google sheets

Follow these steps to use Supermetrics Google Sheets

⚠️Required skills

  • Web analytics
  • Metrics
  • Dimensions

🔧Tools required

Estimated cost: USD 69

⏱️Duration

Estimated duration: 20 minutes

  1. Data collection

    1. Open the Supermetrics for Google Sheets add-on

      Open your Google Sheets spreadsheet. In the add-ons section, choose Supermetrics.

    2. 2. Data source

      Enter the platform from which you wish to extract data in “Data Source”.

    3. 3. Account

      Select the page or account from which you want to extract the information.

    4. 4. Data range

      Choose the date range within which you want to extract the information.

    5. 5. Metrics

      Select the metrics of your interest to build the table.

    6. 6. Dimensions

      Select the dimensions of your interest to build the table. Here you can select the dimensions in rows or columns.

    7. 7. Filters

      If you want to make a filter; for example, campaigns, ads, publication or similar, you can configure it in this step.

    8. 8. Getting data

      Click on the blue button “Get Data to Table”.

      You can now view your table created in Google sheets without having to download anything from .csv or move it to Excel.

  2. Automatic update

    1. 1. Schedule

      At the top of the add-in, you will find the “Schedule” tab, when you click on it, the “Schedule refresh & emailing” option is displayed, click on it.

    2. 2. Configure activator

      In this section you can choose how often you want to update your data, which days, what time and even if you want to receive an email with the notification with the status of each update.

🔮Results

Voilà! You now have tables that are automatically updated every day (week, or month) at a specific time.

More from Supermetrics supermetrics logo Google Sheets

Click Here to claim your FREE trial!

Resumen
Nombre del artículo
Supermetrics Google Sheets
Descripción
Supermetrics for Google Sheets is the number 1 tool for those who want to automate their online reporting through a Google sheets add-on.
Autor
Publisher Name
Datareporte
Publisher Logo

Leave a Reply

Your email address will not be published. Required fields are marked *