Create a ticket Your tickets
Welcome
Login Start free trial
  1. Home
  2. Solution home
  3. Data sources
  4. Google Ads
Open navigation

Google Ads: Permissions troubleshooting guide

Supermetrics Support Site Team
Modified on: Wed, 18 Dec, 2024 at 3:20 PM

If you’re using Google Ads in any destination and any of your accounts are inactive, you might see these error messages:

  • Authorization error: customer not active ID
  • User permission denied: user A does not have permissions for account B
  • GoogleAdsFailure: AuthorizationError.CUSTOMER_NOT_ENABLED
  • The following Google Ads account is no longer available

Google Accounts can be deactivated because they haven’t been active in 15 months, or they’ve been deactivated manually. When an account is deactivated, the API can no longer access it, and so it encounters an error when you run a query.


Visit Google’s help center to learn how to reactivate an account.


Instructions

Solution 1: Exclude invalid accounts from your query

With this option selected, any Supermetrics query skips these types of errors and pulls data for active accounts automatically, even if some of the accounts in the query aren’t active. 


Once you’ve added this option to a query, it will continue to work until you remove it.


Google Sheets
  1. Open the Supermetrics sidebar.
  2. Select a Google Ads query and click the pencil icon to edit it.
  3. Go to Options. 
  4. Click the checkbox next to Exclude invalid accounts.
Looker Studio (formerly Data Studio)
  1. Click any report element that pulls data from Google Ads, or create a new element with Google Ads as its data source.
  2. Click the data source edit icon  in the sidebar.
  3. Click Edit connection.
  4. Scroll down and click the checkbox next to Exclude invalid accounts.
  5. Click Reconnect.
  6. Click Apply.
  7. Click Done to save your new settings.
Excel
  1. Open the Supermetrics sidebar.
  2. Select the Google Ads query on the spreadsheet.
  3. Click Modify.
  4. Go to Options. 
  5. Click the checkbox next to Exclude invalid accounts.
Power BI
  1. Go to the Power BI query list on the Supermetrics Hub.
  2. Select the Google Ads query to modify.
  3. Select the connection to use.
  4. Click Options.
  5. Click the checkbox next to Exclude invalid accounts.
Data warehouses and cloud storage platforms
  1. Go to Transfers on the Supermetrics Hub.
  2. Find the Google Ads transfer you want to modify.
  3. In the 3-dot menu, select Edit.
  4. Click the checkbox next to Exclude invalid accounts.
  5. Click Save.
BigQuery (marketplace)
  1. Log in to BigQuery. 
  2. From the BigQuery sidebar, select Data transfers.
  3. Select the Google Ads transfer you want to modify.
  4. Click Edit. 
  5. Under Third party connections, click Change configuration.
  6. Click Continue.
  7. Click the checkbox next to Exclude invalid accounts.
  8. Click Submit.
  9. Close the popup.
  10. Click Save.
The Supermetrics API
  1. On the Supermetrics Hub, go to API.
  2. Select the Google Ads data source.
  3. Go to Options.
  4. Click the checkbox next to Exclude invalid accounts.
  5. Run the query.
Data blending
  1. On the Supermetrics Hub, go to Transform → Data blending.
  2. Select a blend with a Google Ads data source.
  3. In the Blend setup view, click the 3-dot icon next to the Google Ads data source, and click Edit configuration.
  4. Click Show advanced settings. 
  5. Check the checkbox next to Exclude invalid accounts.
  6. Click Done and Next step to move on with the blend setup, and click Save changes.


Solution 2: Remove deactivated account

Google Sheets
  1. Open the Supermetrics sidebar.
  2. Select a Google Ads query and click the pencil icon to edit it.
  3. Click Select accounts.
  4. Remove the deactivated account.
Looker Studio
  1. Click any report element that pulls data from Google Ads, or create a new element with Google Ads as its data source.
  2. Click the data source edit icon  in the sidebar.
  3. Click Edit connection.
  4. Scroll down to Select accounts.
  5. Uncheck the box next to the deactivated account.
  6. Click Reconnect.
  7. Click Apply.
  8. Click Done to save your new settings.
Excel
  1. Open the Supermetrics sidebar.
  2. Select the Google Ads query on the spreadsheet.
  3. Click Modify.
  4. Click Select accounts.
  5. Remove the deactivated account.
Power BI
  1. Go to the Power BI query list on the Supermetrics Hub.
  2. Select the Google Ads query to modify.
  3. Select the connection to use.
  4. Click Select accounts.
  5. Remove the deactivated account.
Data warehouses and cloud storage platforms
  1. Go to Transfers on the Supermetrics Hub.
  2. Find the Google Ads transfer you want to modify.
  3. In the 3-dot menu, select Edit.
  4. Remove the deactivated account.
  5. Click Save.
BigQuery (marketplace)
  1. From the BigQuery sidebar, select Data transfers.
  2. Select the Google Ads transfer you want to modify.
  3. Click Edit.
  4. Click Third party connections.
  5. Remove the deactivated account.
  6. Click Submit.
  7. Close the popup.
  8. Click Save.
The Supermetrics API
  1. On the Supermetrics Hub, go to API.
  2. Select the Google Ads data source.
  3. Under the Query tab, click Select account.
  4. Remove the deactivated account.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.