Supermetrics

• Supermetrics for Google Sheets - Changes in pricing, data sources and scheduled refreshing taking place on 28th of October 2019
• Data Grabber connection issues with Mac
• Authentication-, HTTP- or Script errors
• **RESOLVED** Google Analytics Error: We are unable to process your query at the moment.

Data Sources

• Facebook Ads Issue - 12th of December 2019
• Known Issue With Facebook Insights - Unknown Get Request
• Amazon Ads (Vendor Central) Issue - 21-03-2019
• Facebook failed to return data for your query - Known Issue with Facebook Service

Impactful Data Source API Changes

• Date Field Changes for Twitter Ads Feb 2020
• Google Ad Manager/DFP v201902 Deprecation
• Facebook Ads API Upgrade and Field Deprecation in November 2019

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?
• What does the "Show all time values" setting do?
• What does the "Combine new results with old" setting do?
• Can I See/Edit All of the Queries That I've Created?

View all (16)

Troubleshooting

• 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 (')
• Unaligned Data, Unexpected Values, Changes Not Showing, and Other Issues Due to Duplicate Queries

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
• Query Placement and How to Move Queries

View all (9)

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

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

Frequently Asked Questions (FAQ)

• Data Studio User Restrictions / "You're Not Allowed to Run Queries With This License"
• Can I Use Multiple Accounts in the Same Data Source?
• How Can I Remove My Account From the Data Studio Connectors?
• How Do I Access Team Management for Data Studio?
• What Does "Number of Accounts Per Data Source" Mean?

View all (12)

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
• This Was a Reauthorization Request for User X But You Logged in as User Y

View all (8)

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 Supermetrics Into Your Excel File)
• How to Log Into Data Source?
• How to Configure an Example Query With Supermetrics for Excel
• Do you have ready made templates?

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
• 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
• 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
• 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

Getting Started

• First Steps with Supermetrics API
• Using the Query Builder for Supermetrics API

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?
• 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?
• 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)

Account Management

• Where can I find my Account Management page?
• Can I Change My User ID for Supermetrics?
• How Can I Renew/Extend My License?
• How can I upgrade my license from Pro to Super Pro level?
• How to Assign Users to Your Data Studio License

View all (6)

Payments / Invoices

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

View all (6)

Team Management Tool

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

View all (8)

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

Adobe Analytics

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

AdRoll

• AdRoll - Getting started with Supermetrics for Google Sheets

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

Databases

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

Facebook Ads

• Getting "No Data" With Reach and Other Unique Metrics With Filters
• 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

View all (13)

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'

Google Ads

• Google Ads Error: AuthorizationError.CUSTOMER_NOT_ACTIVE
• Google Ads Error: USER_PERMISSION_DENIED: User xxx Doesn't Have Permissions for Account
• Google Ads Discrepancies with Top Impression Share Metrics

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 Analytics Error: USER_PERMISSION_DENIED
• Google Analytics User and Event Data Missing After X Months

Google BigQuery

• Invalid Table Name: Try Using Standard SQL (Sheets)

Google 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 Campaign Manager enabled
• Date Range Limitations on Floodlight Data (Google Campaign Manager)

Google Display & Video 360

• 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?

Google My Business

• 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

Google Search Console

• Using the 'Brand Keywords' Option
• Discrepancies in Google Search Console results

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

Instagram Insights

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

View all (6)

LinkedIn Ads

• Expired Token and Authentication Errors for LinkedIn Ads/Pages
• LinkedIn Ads failure "Member does not have author access to view UserGeneratedContent"
• LinkedIn Ads Failure: The Request Returns Too Much Data
• How to Query for Specific Conversions in LinkedIn Ads
• Discrepancies With LinkedIn Ads Demographic Dimensions

LinkedIn Company Pages

• Discrepancies with LinkedIn Company Pages Results

MailChimp

• Incompatible fields: IllegalDimensionMetricCombinationException (MailChimp)
• MailChimp Known Issue: List Growth History Returns 0 For Some Months
• Discrepancies in MailChimp's Own Reporting UI

Microsoft Advertising

• Labels Are Missing or Outdated
• How to Query for Specific Conversions in Microsoft Advertising

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

Outbrain Amplify

• How to Connect with Outbrain Amplify

Pinterest

• Getting Started - Pinterest Public Data Connector

Quora Ads

• Querying Conversion Types in Quora Ads

Salesforce

• Troubleshooting Permissions Issues with Salesforce

Searchmetrics

• How to Connect to Searchmetrics

SEMrush Analytics

• Getting Started - SEMrush Analytics
• Special Formatting Requirement for "Domain vs. Domain" Query Type
• Using the 'Display Date' Option for SEMrush Analytics
• SEMRush API units

SEMrush Projects

• SEMrush Project Use Case - Position Tracking, Keyword Ranking

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 Premium

• Getting Started - Twitter Premium
• Discrepancies with Twitter Premium Results

Twitter Public Data

• Getting Started - Twitter Public Data Connector
• Twitter Public Data Limitation for Country
• Discrepancies with Fetching User Tweets (Twitter Public Data)
• Twitter Public Data Error - "Profile(s) not found"

YouTube

• I cannot see all YouTube accounts and/or videos
• Youtube Results Missing For Today or Yesterday

Adform

• Adform Updates Aug. 2019
• Adform Updates April 2019
• Adform Updates Jan. 2019
• Adform Updates Dec. 2018
• Adform Updates Sept. 2018

View all (6)

AdRoll

• 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

Criteo

• Criteo Updates Feb. 2019

Facebook Ads

• Facebook Ads Updates Nov. 2019
• Facebook Ads Updates Oct. 2019
• Facebook Ads Updates Aug. 2019
• Facebook Ads Updates July 2019
• Facebook Ads Updates June 2019

View all (15)

Facebook Insights

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

View all (9)

Facebook Public Data

• Facebook Public Data Updates May 2019
• Facebook Public Data Updates March 2018

Google Ads

• Google Ads Updates Aug. 2019
• Google Ads Updates June 2019
• Google Ads Updates May 2019
• Google Ads Updates Feb. 2019
• Google Ads Updates Jan. 2019

View all (9)

Google AdSense

• Google AdSense Updates Mar. 2019

Google Ad Manager

• Google Ad Manager Updates Nov. 2019
• Google Ad Manager Updates July 2019
• Google Ad Manager Updates May 2019
• Google Ad Manager Updates April 2019
• Google Ad Manager Updates Mar. 2019

View all (11)

Google Analytics

• Google Analytics Updates Aug. 2019
• Google Analytics Updates June 2019
• Google Analytics Updates May 2019
• Google Analytics Updates April 2019

Google Campaign Manager

• Google Campaign Manager Updates Aug. 2019
• Google Campaign Manager Updates May 2019
• Google Campaign Manager Updates Mar. 2019
• Google Campaign Manager Updates Jan. 2019
• Google Campaign Manager Updates Oct. 2018

View all (6)

Google Display & Video 360

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

View all (7)

Google My Business

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

Google Search Ads 360

• Google Search Ads 360 Updates May 2019

Google Search Console

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

HubSpot

• HubSpot Updates Dec. 2019
• HubSpot Updates Nov. 2019
• HubSpot Updates Oct. 2019

Instagram Insights

• Instagram Insights Updates July 2019
• Instagram Insights Updates May 2019
• Instagram Insights Updates Feb. 2019

LinkedIn Ads

• LinkedIn Ads Updates Jan. 2020
• LinkedIn Ads Updates Dec. 2019
• LinkedIn Ads Updates Nov. 2019
• LinkedIn Ads Updates Oct. 2019
• LinkedIn Ads Updates May 2019

View all (10)

LinkedIn Pages

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

MailChimp

• MailChimp Updates Nov. 2019

Microsoft Advertising

• Microsoft Advertising Updates June 2019
• Microsoft Advertising Updates May 2019
• Microsoft Advertising Updates Dec. 2018
• Microsoft Advertising Updates May 2018
• Microsoft Advertising Updates March 2018

Moz

• Moz Updates May 2018

Public Data / Simple Connectors

• Public Data Connectors Updates Dec. 2018

Quora Ads

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

Reddit

• Reddit Updates June 2018

Seachmetrics

• Searchmetrics Updates Nov. 2019
• Searchmetrics Updates May 2019
• Searchmetrics Updates Nov. 2018

SEMrush Analytics

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

Twitter Ads

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

View all (6)

Yahoo Gemini

• Yahoo Gemini 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 Oct. 2019

YouTube

• YouTube Updates Jan. 2020
• YouTube Updates June 2018