Supermetrics

• Data Grabber connection issues with Mac
• Authentication-, HTTP- or Script errors

Data Sources

• Amazon Ads (Vendor Central) Issue - 21-03-2019
• **Resolved** Known Issue With Facebook Insights - Unknown Get Request
• Facebook failed to return data for your query - Known Issue with Facebook Service
• LinkedIn Pages Updates to API V2 - Requires Re-authentication and Possible Report Changes
• DoubleClick and AdWords Rebranding to Match Google

Impactful Data Source API Changes

• Google Ad Manager/DFP v201805 Deprecation
• Facebook Ads Metrics Deprecation in April

Getting Started

• First steps (getting Supermetrics Sidebar in to your Google Sheets)
• Logging into Data Sources for Google Sheets (Step-by-Step)
• How to create a reporting dashboard
• Do you have any templates for easy setup?
• Upgrade trial/free license to paid subscription

View all (6)

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 Docs with one Google Account, but for Supermetrics, I want to log in to Google Analytics with a different Google Account. How do I do this?
• How does the tool determine where to place the data on query refresh? How can I move queries?
• What does the "Filter referral spam" setting do?
• What does the "Show all time values" setting do?

View all (18)

Troubleshooting

• I get "Authentication expired: Refreshing token failed" or "Query failed: Trial expired" -messages. What to do?
• Your License is Being Used Simultaneously in X Browsers / By Multiple Users
• Reporting Templates' Updates and Troubleshooting Tips (From Google Sheets to Data Studio)
• Why Are My Comparison Period Values Blank?
• Queries are Returning Dates With Apostrophe Characters (')

Tips & Tricks

• 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
• Custom dynamic date range in Google Sheets

Missing metrics or dimension

• Google Analytics metrics missing from Supermetrics
• Google Ads metrics missing from Supermetrics
• Facebook Insights metrics missing from Supermetrics
• Twitter Ads metrics missing from Supermetrics
• Youtube metrics missing from Supermetrics

Triggers/Scheduled Refresh

• Can I schedule my reports to be refreshed or emailed at specific intervals?
• The triggers I added don't work.
• I've added triggers to refresh my queries every hour, but they don't work.
• Sender IP address for report scheduled e-mails
• My triggers are delayed for hours or they do not fire at all

View all (9)

Getting Started

• Adding and authorizing Supermetrics connectors in Google Data Studio
• Editing data source fields
• Edit data source field descriptions
• How to create a time series chart
• How to create a pie chart

View all (6)

Frequently Asked Questions (FAQ)

• Can I Use Multiple Accounts in the Same Data Source?
• How Can I Remove My Account From the Data Studio Connectors?
• Can I purchase more accounts for my license?
• How Do I Access Team Management for Data Studio?
• What Does "Number of Ad Accounts Per Ad Network" Mean?

View all (11)

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 (7)

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 (6)

Getting Started

• First Steps (Getting Supermetrics Into Your Excel File)
• How to Log Into Data Source?
• How to Configure an Example Query With Supermetrics for Excel

Frequently Asked Questions

• Can I Schedule Queries to Refresh Automatically (Excel)?
• How do I Re-Authenticate an Excel Connector?

Tips & Tricks

• How to Copy Queries for Excel

Troubleshooting

• Your Administrator Has Not Installed Web Add-ins for Your Organization

Getting Started

• First Steps (Getting Supermetrics Into Your BigQuery Project)
• How to Configure a Data Transfer in BigQuery
• How to Schedule a Backfill Data Transfer for BigQuery
• Visualizing Your BigQuery Data in Data Studio

Frequently Asked Questions

• How Does Licensing Work for Supermetrics for BigQuery?

Troubleshooting

• How to Monitor Your Daily BigQuery Transfers

Tableau

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

MS PowerBI

• Known Issues and Limitations with PowerBI

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?
• Error: Unable to refresh your token. It may not be valid anymore.

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?

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.
• Can I change the user ID associated with my license?
• 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?

View all (13)

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)

Account Management

• Where can I find my Account Management page?
• Can I change my User ID for Supermetrics?
• How can I upgrade my license from Pro to Super Pro level?
• Can I add more than one Google Account for one license in Supermetrics for Google Drive?

Payments / Invoices

• How can I cancel my Supermetrics subscription?
• Payment options
• Where Can I Find and Modify My Invoices?
• How Do I Enable/Disable Auto-Renewal?
• What to Do if My Credit Card Was Declined?

View all (6)

Team Management Tool

• Team Management for Data Studio
• License Management
• Forcing a Refresh for Account Data
• Viewing Your Account Usage
• Merging Teams in Team Management

View all (7)

General Issues

• This Action is Not Supported When You Are Logged in to Multiple Accounts
• Not All Accounts/Segments/Custom Fields/Labels Are Showing in the Product
• General Data Source Access Requirements
• Daily query quotas
• Can't Be Calculated, Would Require Summing Deduplicated Values

View all (6)

Adobe Analytics

• Connecting to Adobe Analytics
• Custom Metrics and Dimensions Are Missing

AdRoll

• AdRoll - Getting started with Supermetrics for Google Sheets

Amazon Ads

• Amazon Ads Error: The Start Date Must Be Within Last 60 Days

Bing Ads

• Labels Are Missing or Outdated

Criteo

• 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

Databases

• IP Whitelist List for Database Connections

Google Ads

• Discrepancies in calculated Google Ads metrics when using dimension filter in Data Studio
• Google Ads Error: AuthorizationError.CUSTOMER_NOT_ACTIVE
• Google Ads Error: USER_PERMISSION_DENIED: User xxx Doesn't Have Permissions for Account

Google Ad Manager

• It seems you tried to log in with a Google Account that does not have Google Ad Manager enabled

Google Analytics

• Discrepancies in Google Analytics Results
• Does Supermetrics Support Custom Metrics/Dimensions in Google Analytics?

Google Display & Video 360 (Bid Manager)

• It seems you tried to log in with a Google Account that does not have Google Display & Video 360 (Bid Manager) enabled

Google Display & Video 360 (Campaign Manager)

• Query Getting Stuck/Time Outs When Using Floodlight Variables
• It seems you tried to log in with a user that does not have Google Display & Video 360 (Campaign Manager) enabled

Google My Business

• Local Post API is Disabled for This Location
• Locations Are Missing From the List

Google Search Console

• "Account fetch error: No Search console sites found"
• Using the 'Brand Keywords' Option
• Discrepancies in Google Search Console results

Facebook Ads

• Can I set a custom conversion window for Facebook Ads metrics?
• How to Query for Facebook Ads Custom Conversions
• How to Get Cost Per Conversion for Facebook Custom Conversions (Data Studio)
• I am getting error message : Error validating access token: The user is enrolled in a blocking, logged-in checkpoint
• Discrepancies in Data Studio When Using a Filter

View all (10)

Facebook Insights

• Facebook Page is Missing From List
• Discrepancies with Facebook Insights Results
• [FIXED] Facebook - Post level discrepancies
• How Do I Get the Count of Posts in Data Studio?
• Insights Restrictions for Pages With Under 100 Likes

View all (7)

Facebook Public Data

• Getting Started - Facebook Public Data Connector
• Page Name is Correct but Still Getting 'No Data'

Instagram Insights

• Unable to See Instagram Account After Logging In
• Instagram Public Data Errors (decreased query limit and disabled endpoints)
• Known Issues with Instagram Story Insights
• Instagram Insights Failure (Error Validating Access token: Session Has Expired)

LinkedIn Ads

• Expired Token and Authentication Errors for LinkedIn Ads/Pages
• Combining Certain LinkedIn Ads Dimensions Causes Query Not to Return Data

MailChimp

• Incompatible fields: IllegalDimensionMetricCombinationException
• MailChimp Known Issue: List Growth History Returns 0 For Some Months

Moz

• 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

SEMRush

• Support for SEMrush Projects API (includes position tracking)
• Getting Started - SEMrush Analytics
• Special Formatting Requirement for "Domain vs. Domain" Query Type
• Using the 'Display Date' Option for SEMrush Analytics
• SEMRush API units

Twitter Ads

• Twitter data discrepancy
• This User Does Not Have Permission to Read Campaign Data
• Twitter Ads Error: Expect Time to Be Midnight in the Account's Local Timezone
• Twitter Ads Account Fetch Error: User xxxx is Not Authorized to Make This Request
• How to Query Twitter Ads for Ad Groups

Twitter Public Data

• Getting Started - Twitter Public Data Connector
• Twitter Public Data Limitation for Country

YouTube

• I cannot see all YouTube accounts and/or videos

Adform

• Adform Updates Jan. 2019
• Adform Updates Dec. 2018
• Adform Updates Sept. 2018
• Adform Updates May 2018

AdRoll

• AdRoll Updates Sept. 2018

Ad Data + Google Analytics (DS ONLY)

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

Amazon Ads

• Amazon Ads Updates Feb. 2019
• Amazon Ads Updates Jan. 2019
• Amazon Ads Updates Dec. 2018
• Amazon Ads Updates Oct. 2018

Bing Ads

• Bing Ads Updates Dec. 2018
• Bing Ads Updates May 2018
• Bing Ads Updates March 2018

Criteo

• Criteo Updates Feb. 2019

Facebook Ads

• Facebook Ads Updates April 2019
• Facebook Ads Updates Sept. 2018
• Facebook Ads Updates Aug. 2018
• Facebook Ads Updates July 2018
• Facebook Ads Updates June 2018

View all (9)

Facebook Insights

• Facebook Insights Updates Feb. 2019
• Facebook Insights Updates Jan. 2019
• Facebook Insights Updates Nov. 2018
• Facebook Insights Updates Oct. 2018
• Facebook Insights Updates July 2018

View all (7)

Facebook Public Data

• Facebook Public Data Updates March 2018

Google Ads

• Google Ads Updates Feb. 2019
• Google Ads Updates Jan. 2019
• Google Ads Updates Oct. 2018
• Google Ads Updates Sept. 2018
• Google Ads Updates April 2018

View all (6)

Google AdSense

• Google AdSense Updates Mar. 2019

Google Ad Manager

• Google Ads Manager Updates April 2019
• Google Ads Manager Updates Mar. 2019
• Google Ads Manager Updates Feb. 2019
• Google Ad Manager Updates Jan. 2019
• Google Ad Manager Updates Nov. 2018

View all (8)

Google Analytics

• Google Analytics Updates April 2019

Google Display & Video 360 (Bid Manager)

• Google Display & Video 360 (Bid Manager) Updates Mar. 2019
• Google Display & Video 360 (Bid Manager) Updates Oct. 2018
• Google Display & Video 360 (Bid Manager) Updates July 2018

Google Display & Video 360 (Campaign Manager)

• Google Display & Video 360 (Camp. Manager) Updates Mar. 2019
• Google Display & Video 360 (Camp. Manager) Updates Jan. 2019
• Google Display & Video 360 (Camp. Manager) Updates Oct. 2018
• Google Display & Video 360 (Camp. Manager) Updates Aug. 2018

Google My Business

• Google My Business Updates Jan. 2019
• Google My Business Updates Dec. 2018
• Google My Business Updates June 2018

Google Search Console

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

Instagram Insights

• Instagram Insights Updates Feb. 2019

LinkedIn Ads

• LinkedIn Ads Updates April 2019
• LinkedIn Ads Updates Feb. 2019
• LinkedIn Ads Updates Oct. 2018
• LinkedIn Ads Updates April 2018
• LinkedIn Ads Updates Feb. 2018

LinkedIn Pages

• LinkedIn Pages Updates Feb. 2019
• LinkedIn Pages Updates Nov. 2018

Moz

• Moz Updates May 2018

Public Data / Simple Connectors

• Public Data Connectors Updates Dec. 2018

Quora Ads

• Quora Ads Updates Apr. 2019

Reddit

• Reddit Updates June 2018

Seachmetrics

• Searchmetrics Updates Nov. 2018

SEMRush

• SEMRush Analytics Updates Aug. 2018
• SEMRush Analytics Updates April 2018

Twitter Ads

• Twitter Ads Updates Jan. 2019
• Twitter Ads Updates Nov. 2018
• Twitter Ads Updates June 2018

Yahoo Gemini

• Yahoo Gemini Updates April 2018

Yandex Direct

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

YouTube

• YouTube Updates June 2018