Supermetrics

• Changes to Supermetrics pricing in 2021
• Supermetrics for Google Sheets - Changes in pricing, data sources and scheduled refreshing taking place on 28th of October 2019

Data Sources

• Pinterest Introduces Business Access for Account Management
• Facebook Ads Historical Data Adjustments - May 24th, 2021
• Facebook Ads and iOS 14: What You Need to Know
• What You Need to Know About Google Analytics 4 Properties
• Microsoft Advertising to Enforce Multi-factor Authentication - April 2021

Impactful Data Source API Changes

• Google Ad Manager/DFP v202011 Deprecation
• Microsoft Advertising Authentication Update - June 16th, 2021
• Searchmetrics Date Parameter Change - June 17th, 2021
• Facebook Ads Conversion Window Adjustment - June 29th, 2021

Getting started

• List of authentication guides per data source
• How to re-authenticate an Excel connector
• How to re-authenticate a Data Studio connector
• How to re-authenticate a Google Sheets connector
• How to re-authenticate a Supermetrics API connector

View all (7)

Common Errors

• Error: "Authentication failed" & "You need to re-authenticate at X and then run the query again."
• Authentication-, HTTP- or Script errors
• Error: "No accounts found" & "No accounts found or the service is not enabled for this user."
• Error: "It seems you tried to log in with a user that does not have (data source) enabled. Please try again with another user account."
• Google Data Studio - This Was a Reauthorization Request for User X But You Logged in as User Y

View all (11)

Troubleshooting

• General Data Source Access Requirements
• Forcing a Refresh for Account Data
• How Can I Remove My Account From the Data Studio Connectors?
• How to Renew Tokens - Login Management in Team Site
• How to Completely Remove a Data Source from Microsoft Excel

View all (9)

Getting Started

• First steps: Getting the Supermetrics sidebar into Google Sheets
• Logging in to data sources for Google Sheets
• How to run queries in Google Sheets
• Using report templates with Google Sheets
• Setting up triggers for Google Sheets

View all (9)

Frequently Asked Questions (FAQ)

• Which data sources can I access with Supermetrics for Google Docs/Sheets, and will you be adding more?
• I'm logged into Google Sheets with one Google Account, but for Supermetrics, I want to log in to a Data Source with a different Google Account. How do I do this?
• What does the "Show all time values" setting do?
• Can I See/Edit All of the Queries That I've Created?
• How can I delete queries? I've cleared the data but it keeps reappearing when I press Refresh.

View all (15)

Troubleshooting

• Your License is Being Used Simultaneously in X Browsers / By Multiple Users
• Why Are My Comparison Period Values Blank?
• Query failed: ScriptError. Try using Google Sheets logged in with just one Google account.
• Queries are Returning Dates With Apostrophe Characters (')
• Unaligned Data, Unexpected Values, Changes Not Showing, and Other Issues Due to Duplicate Queries

View all (7)

Tips & Tricks

• How to modify or edit a query
• I need to change the date formatting in my results
• I have "null" results that I would like to appear as number zeroes (0)
• Refreshing License Info
• Adding All Accounts to Your Query

View all (11)

Triggers/Scheduled Refresh

• Can I schedule reports to be refreshed or emailed automatically?
• The triggers I added don't work.
• Get a notification if triggered queries fail during refresh
• Managing triggers for Google Sheets
• Transferring triggers from one user to another

View all (12)

Getting Started

• Adding and authorizing Supermetrics connectors in Google Data Studio
• Creating a report and charts with Google Data Studio
• List of getting started guides per data source
• Using report templates with Google Data Studio
• Editing data source fields

View all (7)

Frequently Asked Questions (FAQ)

• Can I Use Multiple Accounts in the Same Data Source?
• How Do I Access Team Management for Data Studio?
• How do I Refresh Fields/Update a Connector?
• Understanding Permissions for Data Studio Reporting
• Can I Add Multiple User Accounts to the Same Data Source?

View all (7)

Troubleshooting

• Community connector error: You are using the free version of Supermetrics for Data Studio
• Troubleshooting for Paid Channel Mix Template
• Scorecard showing error
• Troubleshooting No Data Found Errors
• Summary Row Shows Wrong Values When Using a Filter

View all (9)

Tips & Tricks

• Scheduled Email Delivery of Reports for Data Studio
• Converting Null Values to Zero
• Using DS Data Blending Feature With Supermetrics
• Copying Data Studio Report and Data Source Files
• How to Add Images/Creatives to Your Report from URL Fields

View all (7)

Getting Started

• First Steps: Getting the Supermetrics sidebar into Excel
• Logging in to data sources for Excel
• How to run queries in Excel
• List of getting started guides per data source
• Setting up triggers for Excel

View all (7)

Frequently Asked Questions

• Can I Schedule Queries to Refresh Automatically (Excel)?

Tips & Tricks

• How to Copy Queries for Excel
• Query placement and how to move queries in Excel
• Using Cell References to Dynamically Update the Query (Excel)
• How to export queries from Google Sheets to Excel
• Advanced Settings for Excel

Troubleshooting

• Your Administrator Has Not Installed Web Add-ins for Your Organization
• We Can't Load This Add-In Because We Couldn't Connect to the Catalog
• Clearing the Excel Application Cache
• 'No queries found' error in Excel
• Why can't I save the file to OneDrive when scheduling triggers

Getting Started

• First Steps: Getting Supermetrics into your BigQuery project
• How to configure a data transfer in BigQuery
• Access requirements to configure a data transfer in Big Query
• Creating a BigQuery dataset for your data transfer
• Scheduling a backfill data transfer for BigQuery

View all (6)

Frequently Asked Questions

• How Does Licensing Work for Supermetrics for BigQuery?
• How to create a custom schema?
• How to use pre-built schemas as a template?

Tips & Tricks

• How to delete multiple BigQuery tables

Troubleshooting

• CSV Table Encountered Too Many Errors, Giving Up
• I'm getting error when setting refresh window for BQ transfers
• How to escalate a BigQuery transfer issue to Supermetrics support
• How to edit a BigQuery transfer

Getting Started

• How to configure a data destination
• How to configure a data transfer
• Creating a data transfer: Filling Instructions
• How to schedule a data backfill
• How to monitor your daily data transfers

Snowflake Data Warehouse

• Creating a destination: Prerequisites for Snowflake
• Creating a destination: Filling Instructions for Snowflake
• IP Whitelisting for Supermetrics for Snowflake
• Roles and privileges for Supermetrics for Snowflake

Azure Storage Container

• Creating a destination: Prerequisites for Azure Storage Container
• Creating a destination: Filling instructions for Azure Storage Container

Amazon S3 Bucket

• Creating a destination: Prerequisites for Amazon S3 Bucket
• Creating a destination: Filling instructions for Amazon S3 Bucket

Google Cloud Storage Bucket

• Creating a destination: Prerequisites for GCS Bucket
• Creating a destination: Filling Instructions for GCS Bucket

Azure Synapse

• Creating a destination: Prerequisites for Azure Synapse
• Creating a destination: Filling instructions for Azure Synapse

Troubleshooting

• Error "Confirm logout: Cannot execute query"
• Error "User X does not have storage objects get access to the Google Cloud Storage object."

Getting Started

• First Steps with the Supermetrics API
• Using the Query Manager
• How to store queries and create query groups

Tableau

• Connecting to Tableau with Supermetrics API
• Report Scheduling with Tableau

Microsoft Power BI

• Connecting to Power BI with Supermetrics API
• Known Issues and Limitations with Power BI

Other

• Connecting to Qlik Sense with Supermetrics API

Getting Started

• Logging in to Supermetrics Uploader (for Trial and paid versions)
• What data does the tool upload to Google Analytics?
• I just scheduled an upload. When will I see the data in Google Analytics?
• Where in Google Analytics is the data displayed?

Troubleshooting

• I can't schedule an upload, because whichever Google Analytics webproperty I select, the tool returns an "No custom data sources found" error.
• I've had an upload running successfully for some time, but now I get an "invalid credentials" error. What's wrong?

Frequently asked question (FAQ)

• I've already uploaded data into Google Analytics using another upload tool. Will Supermetrics Uploader overwrite this data?
• What does Supermetrics Uploader do with my data?
• Do I need to provide my Google Account login credentials to the tool?
• Will you be adding automatic daily uploads for other data sources?
• How Do I Upload Historical Data with Supermetrics Uploader?

Getting Started

• First steps (getting Data Grabber ready)

Troubleshooting

• I've purchased a license, but when logging in, I get an error saying my trial period has expired
• Why doesn't anything happen when I press the "Log into Google Analytics" button?
• 60k Row limit in old Data Grabber versions
• I get an error when trying to log in to the Google Webmaster Tools Module, even though I'm sure my credentials are correct.
• Why don't the dropdown menus work when I use Supermetrics Data Grabber on my Mac? They close so quickly I can't select anything. / I can't scroll down to select all metrics.

View all (6)

Frequently Asked Questions

• When I open the file, Excel shows an error message describing unreadable content, and notifies that is has removed Visual Basic for Applications (VBA). None of the buttons work.
• How do I refresh a report to cover a new date range?
• What are the definitions of the metrics and dimensions that Supermetrics Data Grabber makes available?
• How can I get separate metrics for paid and organic search traffic?
• Can I include several advanced segments in the same report?

View all (12)

Getting Started

• First steps with Supermetrics Functions
• Parameter reference

Troubleshooting

• Why does Excel slow down when I use the functions?
• Why do I get the #NAME error?
• Why do I get the "Fetching data failed" error?
• Why do I get the #VALUE error?
• Why do I get errors about rate limits or timeouts when using the functions in Google Sheets?

Frequently asked questions

• How do I make the results span several cells? When I enter a function, I get a value to just one cell.
• How can I add a button that updates all the functions I've placed?
• How do I get the function to return more rows/columns?
• How do I use the functions when connecting via a proxy server?
• How can I use the functions in an existing workbook I have?

View all (6)

Purchasing, Payments & Invoices

• How to purchase a new license
• Is it possible to add new data sources to my existing old license? (For licenses bought before March 28th/June 15th 2021)
• How can I modify an existing license? (For licenses bought after March 28th/June 15th 2021)
• Can I Migrate a License from the Old Pricing Model to the New Model?
• Where Can I Find and Modify My Invoices?

View all (12)

Account Management

• Can I Change My User ID for Supermetrics?
• How Can I Renew/Extend My License?
• How can I upgrade my license?
• What Does "Number of Accounts Per Data Source" Mean?
• List of data sources - Account definitions

View all (8)

Team Management Tool

• Team Management Basics
• License Management
• Viewing Your Account Usage
• Merging Teams in Team Management
• Changing User Roles in Team Management

View all (6)

General Issues

• Daily Query Quotas
• Can't Be Calculated, Would Require Summing Deduplicated Values
• These Metrics and Dimensions Can't Be Fetched Together / Incompatible Fields
• Requesting Missing Metrics and Dimensions
• Can I Convert My Ad Spend Into Another Currency?

View all (6)

Ad Data + Google Analytics

• How to Authenticate/Re-authenticate Ad Data + Google Analytics in Google Data Studio
• Getting started with Ad Data + Google Analytics
• Blending data with Ad Data + Google Analytics

Adform

• How to Authenticate/Re-authenticate Adform in Google Sheets, Google Data Studio & Microsoft Excel

Adobe Analytics

• How to Authenticate/Re-authenticate Adobe Analytics & Adobe Analytics 2.0 in Google Sheets, Google Data Studio & Microsoft Excel
• Custom Metrics and Dimensions Are Missing
• How to Connect to Adobe Analytics with Service Account

AdRoll

• How to Authenticate/Re-authenticate AdRoll in Google Sheets, Google Data Studio & Microsoft Excel
• AdRoll - Getting started with Supermetrics for Google Sheets

Ahrefs

• Getting Started - Ahrefs
• How to Authenticate/Re-authenticate Ahrefs in Google Sheets, Google Data Studio & Microsoft Excel
• Ahrefs report types and quota limitations

Apple App Store / iTunes

• How to Authenticate/Re-authenticate Apple App Store / iTunes in Google Sheets, Google Data Studio & Microsoft Excel

Apple Search Ads

• How to Authenticate Apple Search Ads in Google Sheets, Google Data Studio & Microsoft Excel

Azure Synapse

• Accessing Azure Synapse

Bing Webmaster Tools

• How to Authenticate/Re-authenticate Bing Webmaster Tools in Google Sheets, Google Data Studio & Microsoft Excel

CallRail

• Getting Started with CallRail - Google Sheets, Google Data Studio and Microsoft Excel
• How to Authenticate/Re-authenticate CallRail in Google Sheets, Google Data Studio & Microsoft Excel

Criteo

• Getting Started with Criteo - Google Sheets, Google Data Studio and Microsoft Excel
• How to Authenticate/Re-authenticate Criteo in Google Sheets & Microsoft Excel
• Getting Started with Criteo - Data Warehouse, Cloud Storage, BigQuery & API
• Accessing Criteo
• Discrepancies with Criteo Results

Custom JSON/CSV

• Custom JSON/CSV connector for Data Studio
• Upload CSV files from your Google Drive to Data Studio with Custom JSON/CSV
• Enabling Date Placeholders for Custom JSON/CSV in Data Studio
• Size Limitations for JSON Requests
• Sample Use Cases - How to use Custom JSON/CSV connector

View all (8)

Databases

• IP Whitelist List for Database Connections
• Connecting to MySQL database with Supermetrics for Google Sheets

Facebook Ads

• Getting Started with Facebook Ads - Google Sheets, Google Data Studio & Microsoft Excel
• How to Authenticate/Re-authenticate Facebook Ads in Google Sheets, Google Data Studio & Microsoft Excel
• Getting Started with Facebook Ads - Data Warehouse, Cloud Storage, BigQuery & API
• Getting "null" or "No Data" With Reach and Other Unique Metrics With Filters
• Facebook Ads Adjustments to Store Traffic Ads

View all (21)

Facebook Ad Library

• How to Authenticate/Re-authenticate Facebook Ad Library in Google Sheets, Google Data Studio & Microsoft Excel
• Facebook Ad Library - Account verification and developer app creation

Facebook Audience Network

• How to Connect with Facebook Audience Network

Facebook Insights

• Getting Started with Facebook Insights - Google Sheets, Google Data Studio and Microsoft Excel
• How to Authenticate/Re-authenticate Facebook Insights in Google Sheets, Google Data Studio & Microsoft Excel
• Getting Started with Facebook Insights - Data Warehouse, Cloud Storage, BigQuery & API
• Facebook Page is Missing From List
• Discrepancies with Facebook Insights Results

View all (10)

Facebook Public Data

• Getting Started - Facebook Public Data Connector
• How to Authenticate/Re-authenticate Facebook Public Data in Google Sheets, Google Data Studio & Microsoft Excel
• Page Name is Correct but Still Getting 'No Data'

Google Ads

• Getting Started - Google Ads
• How to Authenticate/Re-authenticate Google Ads in Google Sheets, Google Data Studio & Microsoft Excel
• Google Ads Error: AuthorizationError.CUSTOMER_NOT_ACTIVE
• Google Ads Error: USER_PERMISSION_DENIED: User xxx Doesn't Have Permissions for Account
• Google Ads "Ad Type" Field Behavior Change - May 12th, 2021

View all (13)

Google Ad Manager

• How to Authenticate/Re-authenticate Google Ad Manager in Google Sheets, Google Data Studio & Microsoft Excel
• It seems you tried to log in with a Google Account that does not have Google Ad Manager enabled
• Google Ad Manager Revenue Behavior Change

Google Analytics

• Getting Started with Google Analytics - Google Sheets, Google Data Studio and Microsoft Excel
• How to Authenticate/Re-authenticate Google Analytics in Google Sheets, Google Data Studio & Excel
• Getting Started with Google Analytics - Data Warehouse, Cloud Storage, BigQuery & API
• Discrepancies in Google Analytics Results
• Does Supermetrics Support Custom Metrics/Dimensions in Google Analytics?

View all (10)

Google Analytics 4

• Getting Started with Google Analytics 4 - Google Sheets, Google Data Studio and Microsoft Excel
• How to Authenticate/Re-authenticate Google Analytics 4 in Google Sheets, Google Data Studio & Microsoft Excel

Google AdSense

• How to Authenticate/Re-authenticate Google AdSense in Google Sheets, Google Data Studio & Excel

Google BigQuery

• How to Authenticate/Re-authenticate Google BigQuery in Google Sheets & Google Data Studio
• Invalid Table Name: Try Using Standard SQL (Sheets)

Google Campaign Manager

• How to Authenticate/Re-authenticate Google Campaign Manager in Google Sheets, Google Data Studio & Microsoft Excel
• Query Getting Stuck/Time Outs When Using Floodlight Variables
• It seems you tried to log in with a user that does not have Google Campaign Manager enabled
• Date Range Limitations on Floodlight Data (Google Campaign Manager)

Google Display & Video 360

• Getting Started - Google Display & Video 360
• How to Authenticate/Re-authenticate Google Display & Video 360 in Google Sheets, Google Data Studio & Microsoft Excel
• It seems you tried to log in with a Google Account that does not have Google Display & Video 360 enabled
• Backend Errors and Account List Load Timeouts for Display & Video 360
• Can I Select Specific Advertisers Under a DV360 Profile?

View all (6)

Google My Business

• How to Authenticate/Re-authenticate Google My Business in Google Sheets, Google Data Studio & Microsoft Excel
• Local Post API is Disabled for This Location
• Locations Are Missing From the List
• One of the Selected Locations Does Not Exist Anymore or You Do Not Have Access to It
• Google My Business Data Delays

View all (6)

Google Search Ads 360

• How to Authenticate/Re-authenticate Google Search Ads 360 in Google Sheets, Google Data Studio & Microsoft Excel

Google Search Console

• How to Authenticate/Re-authenticate Google Search Console in Google Sheets, Google Data Studio & Microsoft Excel
• Using the 'Brand Keywords' Option
• Discrepancies in Google Search Console results
• Filtering issues in Google Search Console
• Discrepancy correction for Google Search Console queries

View all (9)

HubSpot

• How to get started with HubSpot? (Google Sheets)
• How to get started with HubSpot? (Data Studio)
• How to get started with HubSpot? (Microsoft Excel)
• How to Monitor Your HubSpot Import Status
• Can I Use HubSpot Custom Properties?

View all (8)

Instagram Insights

• Getting Started - Instagram Insights
• How to Authenticate/Re-authenticate Instagram Insights in Google Sheets, Google Data Studio & Microsoft Excel
• Getting Started with Instagram Insights - Data Warehouse, Cloud Storage, BigQuery & API
• Unable to See Instagram Account After Logging In
• How to Reset the Business Integration for Instagram Insights & Instagram Public Data

View all (11)

Instagram Public Data

• Getting Started - Instagram Public Data
• How to Authenticate/Re-authenticate Instagram Public Data in Google Sheets, Google Data Studio & Microsoft Excel

Klaviyo

• How to Authenticate/Re-authenticate Klaviyo in Google Sheets, Google Data Studio & Microsoft Excel
• Discrepancies with Klaviyo results - Campaigns, flows & subscriber data
• Discrepancies with Klaviyo results - Open rate/click rate & order attribution

LinkedIn Ads

• Getting Started with LinkedIn Ads - Google Sheets, Google Data Studio & Microsoft Excel
• How to Authenticate/Re-authenticate LinkedIn Ads in Google Sheets, Google Data Studio & Microsoft Excel
• Getting Started with LinkedIn Ads - Data Warehouse, Cloud Storage, BigQuery & API
• LinkedIn Ad Account/LinkedIn Company Page is missing from the list
• LinkedIn Ads failure "Member does not have author access to view UserGeneratedContent"

View all (10)

LinkedIn Company Pages

• Getting Started - LinkedIn Company Pages
• How to Authenticate/Re-authenticate LinkedIn Company Pages in Google Sheets, Google Data Studio & Microsoft Excel
• Discrepancies with LinkedIn Company Pages Results
• LinkedIn Ad Account/LinkedIn Company Page is missing from the list

MailChimp

• Getting Started - Mailchimp
• How to Authenticate/Re-authenticate Mailchimp in Google Sheets, Google Data Studio & Microsoft Excel
• Incompatible fields: IllegalDimensionMetricCombinationException (MailChimp)
• MailChimp Known Issue: List Growth History Returns 0 For Some Months
• Discrepancies in MailChimp's Own Reporting UI

View all (6)

Microsoft Advertising

• Getting Started with Microsoft Advertising - Google Sheets, Google Data Studio and Microsoft Excel
• How to Authenticate/Re-authenticate Microsoft Advertising in Google Sheets, Google Data Studio & Microsoft Excel
• Getting Started with Microsoft Advertising - Data Warehouse, Cloud Storage, BigQuery & API
• Labels Are Missing or Outdated
• How to Query for Specific Conversions in Microsoft Advertising

View all (6)

Moz

• How to Authenticate/Re-authenticate Moz in Google Sheets & Google Data Studio
• How can I fetch Moz data using my own credentials?
• How can I fetch more than 200 rows of Moz data? How can I avoid Moz quota issues?
• Moz Error: Data Fetch Failed: 403 Permission Denied

Netvisor

• How to Authenticate/Re-authenticate Netvisor in Google Sheets, Google Data Studio & Microsoft Excel

Outbrain Amplify

• How to Authenticate/Re-authenticate Outbrain Amplify in Google Sheets, Google Data Studio & Microsoft Excel
• How to Connect with Outbrain Amplify

Optimizely

• How to Authenticate/Re-authenticate Optimizely in Google Sheets, Google Data Studio & Microsoft Excel

PayPal

• How to Authenticate/Re-authenticate PayPal in Google Sheets & Microsoft Excel

Pinterest Ads

• Getting Started - Pinterest Ads
• How to Authenticate/Re-authenticate Pinterest Ads in Google Sheets, Google Data Studio & Microsoft Excel
• Discrepancies in Pinterest Ads
• Can I Set a Custom Attribution Window for Pinterest Ads?

Pinterest Organic

• Getting Started - Pinterest Organic
• How to Authenticate/Re-authenticate Pinterest Organic in Google Sheets, Google Data Studio & Microsoft Excel

Pinterest Public Data

• Getting Started - Pinterest Public Data Connector
• How to Authenticate/Re-authenticate Pinterest Public Data in Google Sheets, Google Data Studio & Microsoft Excel

Quora Ads

• How to Authenticate/Re-authenticate Quora Ads in Google Sheets, Google Data Studio & Microsoft Excel
• Querying Conversion Types in Quora Ads

Reddit Public Data

• How to Authenticate/Re-authenticate Reddit Public Data in Google Sheets, Google Data Studio & Microsoft Excel

Salesforce

• Getting Started - Salesforce
• How to Authenticate/Re-authenticate Salesforce in Google Sheets, Google Data Studio & Microsoft Excel
• Troubleshooting Permissions Issues with Salesforce
• Salesforce Advanced Date Settings
• Salesforce: Frequently asked questions (FAQ)

View all (6)

Salesforce Marketing Cloud

• How to Authenticate/Re-authenticate Salesforce Marketing Cloud in Google Sheets, Google Data Studio & Microsoft Excel

Searchmetrics

• How to Authenticate/Re-authenticate Searchmetrics in Google Sheets, Google Data Studio & Microsoft Excel
• How to Connect to Searchmetrics

SEMrush Analytics

• Getting Started - SEMrush Analytics
• How to Authenticate/Re-authenticate SEMRush Analytics in Google Sheets, Google Data Studio & Microsoft Excel
• Special Formatting Requirement for "Domain vs. Domain" Query Type
• Using the 'Display Date' Option for SEMrush Analytics
• SEMRush API units

SEMrush Projects

• How to Authenticate/Re-authenticate SEMRush Projects in Google Sheets & Google Data Studio
• SEMrush Project Use Case - Position Tracking, Keyword Ranking

Snapchat Marketing

• Getting Started - Snapchat Marketing
• How to Authenticate/Re-authenticate Snapchat Marketing in Google Sheets, Google Data Studio & Microsoft Excel
• How to set a custom attribution window for Snapchat Marketing
• Discrepancies with Snapchat Marketing Results

Snowflake

• Getting Started - Snowflake
• How to Authenticate/Re-authenticate Snowflake in Google Sheets, Data Studio & Microsoft Excel
• How to Get Data from Snowflake to Data Studio

Shopify

• Getting Started - Shopify
• How to Authenticate/Re-authenticate Shopify in Google Sheets, Google Data Studio & Microsoft Excel
• How to login to a Shopify Store as a Partner?
• I’m getting 403 Forbidden -error when authenticating to a Shopify Store
• I'm getting Authentication failed-error after re-authenticating Shopify

View all (9)

StackAdapt

• Getting Started - StackAdapt
• How to Authenticate/Re-authenticate StackAdapt in Google Sheets, Google Data Studio & Microsoft Excel
• StackAdapt - Unique Impression Discrepancies

Stripe

• How to Authenticate/Re-authenticate Stripe in Google Sheets, Google Data Studio & Microsoft Excel

Taboola

• How to Authenticate/Re-authenticate Taboola in Google Sheets, Google Data Studio & Microsoft Excel

The Trade Desk

• Getting Started with The Trade Desk - Google Sheets, Google Data Studio and Microsoft Excel
• How to Authenticate/Re-authenticate The Trade Desk in Google Sheets, Google Data Studio & Microsoft Excel

TikTok Ads

• Getting Started - TikTok Ads
• How to Authenticate/Re-authenticate TikTok Ads in Google Sheets, Google Data Studio & Microsoft Excel

Tumblr Public Data

• How to Authenticate/Re-authenticate Tumblr Public Data in Google Sheets, Google Data Studio & Microsoft Excel

Twitter Ads

• Getting Started with Twitter Ads - Google Sheets, Google Data Studio and Microsoft Excel
• How to Authenticate/Re-authenticate Twitter Ads in Google Sheets, Google Data Studio & Microsoft Excel
• Getting Started with Twitter Ads - Data Warehouse, Cloud Storage, BigQuery & API
• Twitter Audience Network data discrepancy
• This User Does Not Have Permission to Read Campaign Data

View all (7)

Twitter Premium

• Getting Started - Twitter Premium
• How to Authenticate/Re-authenticate Twitter Premium in Google Sheets, Google Data Studio & Microsoft Excel
• Discrepancies with Twitter Premium Results
• Twitter Premium limitations and rate limits

Twitter Public Data

• Getting Started - Twitter Public Data Connector
• How to Authenticate/Re-authenticate Twitter Public Data in Google Sheets, Google Data Studio & Microsoft Excel
• Twitter Public Data Limitation for Country
• Discrepancies with Fetching User Tweets (Twitter Public Data)
• Twitter Public Data Error - "Profile(s) not found"

Verizon Media DSP

• Getting Started - Verizon Media DSP
• How to Connect with Verizon Media DSP
• How to Authenticate/Re-authenticate Verizon Media DSP in Google Sheets, Google Data Studio & Microsoft Excel

Verizon Media Native Ads

• How to Authenticate/Re-authenticate Verizon Media Native Ads in Google Sheets, Google Data Studio & Microsoft Excel
• Campaign Name Can't Be Fetched With Conversion Value

Vimeo Public Data

• How to Authenticate/Re-authenticate Vimeo Public Data in Google Sheets, Google Data Studio & Microsoft Excel

Yandex Direct

• How to Authenticate/Re-authenticate Yandex Direct in Google Sheets, Google Data Studio & Microsoft Excel

Yandex Metrica

• How to Authenticate/Re-authenticate Yandex Metrica in Google Sheets, Google Data Studio & Microsoft Excel

YouTube

• Getting Started - YouTube
• How to Authenticate/Re-authenticate YouTube in Google Sheets, Google Data Studio & Microsoft Excel
• I cannot see all YouTube accounts and/or videos
• Youtube Results Missing For Today or Yesterday
• Discrepancies with YouTube results

Adform

• Adform Updates April 2021
• Adform Updates June 2020
• Adform Updates Aug. 2019
• Adform Updates April 2019
• Adform Updates Jan. 2019

View all (8)

Adobe Analytics v1

• Adobe Analytics v1 Updates Feb. 2020

Adobe Analytics 2.0

• Adobe Analytics 2.0 Updates May 2020

AdRoll

• AdRoll Updates April 2020
• AdRoll Updates March 2020
• AdRoll Updates May 2019
• AdRoll Updates Sept. 2018

Ad Data + Google Analytics (DS ONLY)

• Ad Data + GA Updates Aug. 2018
• Ad Data + GA Updates Oct. 2018

Apple Search Ads

• Apple Search Ads Updates May 2021
• Apple Search Ads Updates April 2021

CallRail

• CallRail Updates May 2021

Criteo

• Criteo Updates March 2021
• Criteo Updates Aug. 2020
• Criteo Updates Feb. 2019

Facebook Ads

• Facebook Ads Updates June 2021
• Facebook Ads Updates May 2021
• Facebook Ads Updates April 2021
• Facebook Ads Updates March 2021
• Facebook Ads Updates Feb. 2021

View all (27)

Facebook Insights

• Facebook Insights Updates Feb. 2021
• Facebook Insights Updates Jan. 2021
• Facebook Insights Updates Oct. 2020
• Facebook Insights Updates June 2020
• Facebook Insights Updates Feb. 2020

View all (14)

Facebook Public Data

• Facebook Public Data Updates Feb. 2021
• Facebook Public Data Updates Oct. 2020
• Facebook Public Data Updates Jan. 2020
• Facebook Public Data Updates May 2019
• Facebook Public Data Updates March 2018

Google Ads

• Google Ads Updates May 2021
• Google Ads Updates March 2021
• Google Ads Updates Jan. 2021
• Google Ads Updates Oct. 2020
• Google Ads Updates June 2020

View all (18)

Google AdSense

• Google AdSense Updates Aug. 2020
• Google AdSense Updates Mar. 2019

Google Ad Manager

• Google Ad Manager Updates June 2021
• Google Ad Manager Updates April 2021
• Google Ad Manager Updates Jan. 2021
• Google Ad Manager Updates Oct. 2020
• Google Ad Manager Updates July 2020

View all (20)

Google Analytics

• Google Analytics Updates March 2021
• Google Analytics Updates Feb. 2021
• Google Analytics Updates Jan. 2021
• Google Analytics Updates Sept. 2020
• Google Analytics Updates May 2020

View all (11)

Google Analytics 4

• Google Analytics 4 Updates March 2021
• Google Analytics 4 Updates Feb. 2021

Google Campaign Manager

• Google Campaign Manager Updates Feb. 2021
• Google Campaign Manager Updates Feb. 2020
• Google Campaign Manager Updates Aug. 2019
• Google Campaign Manager Updates May 2019
• Google Campaign Manager Updates Mar. 2019

View all (8)

Google Display & Video 360

• Google Display & Video 360 Updates Aug 2020
• Google Display & Video 360 Updates May 2020
• Google Display & Video 360 Updates Dec. 2019
• Google Display & Video 360 Updates Nov. 2019
• Google Display & Video 360 Updates July 2019

View all (9)

Google My Business

• Google My Business Updates Jan. 2021
• Google My Business Updates March 2020
• Google My Business Updates Dec. 2019
• Google My Business Updates Jan. 2019
• Google My Business Updates Dec. 2018

View all (6)

Google Search Ads 360

• Google Search Ads 360 Updates April 2021
• Google Search Ads 360 Updates March 2020
• Google Search Ads 360 Updates May 2019

Google Search Console

• Google Search Console Updates April 2021
• Google Search Console Updates Jan. 2021
• Google Search Console Updates Feb. 2019
• 16 Months of Data Now Added 20-06-2018

HubSpot

• HubSpot Updates April 2021
• HubSpot Updates March 2021
• HubSpot Updates Feb. 2021
• Hubspot Updates July 2020
• HubSpot Updates June 2020

View all (12)

Instagram Insights

• Instagram Insights Updates April 2021
• Instagram Insights Updates March 2021
• Instagram Insights Updates Oct. 2020
• Instagram Insights Updates July 2019
• Instagram Insights Updates May 2019

View all (6)

Instagram Public Data

• Instagram Public Data Updates March 2021
• Instagram Public Data Updates Dec. 2020

LinkedIn Ads

• LinkedIn Ads Updates May 2021
• LinkedIn Ads Updates April 2021
• LinkedIn Ads Updates Dec. 2020
• LinkedIn Ads Updates Nov. 2020
• LinkedIn Ads Updates Oct. 2020

View all (15)

LinkedIn Pages

• LinkedIn Pages Updates Oct. 2020
• LinkedIn Pages Updates Feb. 2020
• LinkedIn Pages Updates Jan. 2020
• LinkedIn Pages Updates Nov. 2019
• LinkedIn Pages Updates Feb. 2019

View all (6)

MailChimp

• MailChimp Updates April 2020
• MailChimp Updates March 2020
• MailChimp Updates Nov. 2019

Microsoft Advertising

• Microsoft Advertising Updates June 2021
• Microsoft Advertising Updates Jan. 2021
• Microsoft Advertising Updates March 2020
• Microsoft Advertising Updates June 2019
• Microsoft Advertising Updates May 2019

View all (8)

Moz

• Moz Updates May 2018

Outbrain Amplify

• Outbrain Amplify Updates April 2020

Pinterest Ads

• Pinterest Ads Updates May 2021
• Pinterest Ads Updates Dec. 2020
• Pinterest Ads Updates April 2020
• Pinterest Ads Updates March 2020
• Pinterest Ads Updates Feb. 2020

View all (6)

Pinterest Organic

• Pinterest Organic Updates May 2021
• Pinterest Organic Updates Jan. 2021

Public Data / Simple Connectors

• Public Data Connectors Updates Dec. 2018

Quora Ads

• Quora Ads Updates March 2020
• Quora Ads Updates May 2019
• Quora Ads Updates Apr. 2019

Reddit

• Reddit Updates June 2018

Salesforce

• Salesforce Updates May 2021
• Salesforce Updates March 2021
• Salesforce Updates Feb. 2021
• Salesforce Updates Nov. 2020
• Salesforce Updates May 2020

View all (6)

Searchmetrics

• Searchmetrics Updates June 2021
• Searchmetrics Updates Feb. 2021
• Searchmetrics Updates Jan. 2021
• Searchmetrics Updates Dec. 2020
• Searchmetrics Updates Nov. 2019

View all (7)

SEMrush Analytics

• SEMrush Analytics Updates Jan. 2021
• SEMrush Analytics Updates March 2020
• SEMrush Analytics Updates Jan. 2020
• SEMrush Analytics Updates Aug. 2018
• SEMrush Analytics Updates April 2018

Shopify

• Shopify Updates June 2021
• Shopify Updates Jan. 2021
• Shopify Updates Oct. 2020
• Shopify Updates April 2020

Snapchat Marketing

• Snapchat Marketing Updates June 2021
• Snapchat Marketing Updates June 2020
• Snapchat Marketing Updates March 2020
• Snapchat Marketing Updates Feb. 2020

Snowflake (Data Source)

• Snowflake Updates June 2021

Stripe

• Stripe Updates Dec. 2020

Taboola

• Taboola Updates March 2020
• Taboola Updates Jan. 2020

TikTok Ads

• TikTok Ads Updates April 2021
• TikTok Ads Updates March 2021
• TikTok Ads Updates Feb. 2021

Twitter Ads

• Twitter Ads Updates May 2021
• Twitter Ads Updates March 2021
• Twitter Ads Updates Feb. 2021
• Twitter Ads Updates Jan. 2021
• Twitter Ads Updates Oct. 2020

View all (16)

Twitter Premium

• Twitter Premium Updates June 2021
• Twitter Premium Updates May 2020

Verizon Media DSP

• Verizon Media DSP Updates April 2021

Verizon Media Native Ads

• Verizon Media Native Ads Updates Jan. 2021
• Verizon Media Native Ads Updates March 2020
• Verizon Media Native Ads Updates April 2018

Yandex Direct

• Yandex Direct Updates April 2019
• Yandex Direct Updates Jan. 2019
• Yandex Direct Updates Aug. 2019

Yandex Metrica

• Yandex Metrica Updates May 2020
• Yandex Metrica Updates March 2020
• Yandex Metrica Updates Oct. 2019

YouTube

• YouTube Updates March 2021
• YouTube Updates Feb. 2021
• YouTube Updates June 2020
• YouTube Updates Feb. 2020
• YouTube Updates Jan. 2020

View all (6)

Frequently Asked Questions

• Which Supermetrics products are legacy products?
• What are the alternatives for legacy products?
• How long will the products be supported after the sunset date?