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.
BigQuery
- Log in to BigQuery.
- From the BigQuery sidebar, select Data transfers.
- Select the Google Ads transfer you want to modify.
- Click Edit.
- Under Third party connections, click Change configuration.
- Click Continue.
- Click the checkbox next to Exclude invalid accounts.
- Click Submit.
- Close the popup.
- Click Save.
Looker Studio (formerly Data Studio)
- Click any report element that pulls data from Google Ads, or create a new element with Google Ads as its data source.
- Click the data source edit icon
in the sidebar. - Click EDIT CONNECTION.
- Scroll down and click the checkbox next to Exclude invalid accounts.
- Click RECONNECT.
- Click Apply.
- Click DONE to save your new settings.
Excel
- Open the Supermetrics sidebar.
- Under Data source, select Google Ads.
- Click Options, and select Exclude invalid accounts from the dropdown.
- Click Add option.
Google Sheets
- Open the Supermetrics sidebar.
- Under Data source, select Google Ads.
- Navigate to Options.
- Click the checkbox next to Exclude invalid accounts.
Other data warehouses and cloud storage platforms
- Go to Transfers on the Supermetrics Hub.
- Find the Google Ads transfer you want to modify.
- In the 3-dot menu, select Edit.
- Click the checkbox next to Exclude invalid accounts.
- Click Save.
The Supermetrics API
- Open the Supermetrics Query Manager.
- Select the Google Ads data source.
- Click Options.
- Click the checkbox next to Exclude invalid accounts.
- Run the query.
Solution 2: Remove deactivated account
BigQuery
- From the BigQuery sidebar, select Data transfers.
- Select the Google Ads transfer you want to modify.
- Click Edit.
- Click Third party connections.
- Remove the deactivated account.
- Click Submit.
- Close the popup.
- Click Save.
Looker Studio
- Click any report element that pulls data from Google Ads, or create a new element with Google Ads as its data source.
- Click the data source edit icon in the sidebar.
- Click EDIT CONNECTION.
- Scroll down to Select accounts.
- Uncheck the box next to the deactivated account.
- Click Reconnect.
- Click Apply.
- Click DONE to save your new settings.
Excel
- Open the Supermetrics sidebar.
- Under Data source, select Google Ads.
- Click Select accounts.
- Remove the deactivated account.
Google Sheets
- Open the SupermetricsQueries tab.
If this is hidden, navigate to Extensions → Supermetrics → Manage queries. - Find the row with the impacted query.
- Scroll to the Accounts/Views column.
- Remove the deactivated account.
Other data warehouses and cloud storage platforms
- Go to Transfers on the Supermetrics Hub.
- Find the Google Ads transfer you want to modify.
- In the 3-dot menu, select Edit.
- Remove the deactivated account.
- Click Save.
The Supermetrics API
- Open the Supermetrics Query Manager.
- Select the Google Ads data source.
- Under the Query tab, click Select account.
- Remove the deactivated account.