If you’re using Google Ads in any destination and any of your accounts are inactive, you might see this error message:
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.
Solution 1: Add EXCLUDE_INVALID_ACCOUNTS to your query
Any Supermetrics query that includes EXCLUDE_INVALID_ACCOUNTS will skip these types of errors and pull data for active accounts automatically, even if some of the accounts in the query aren’t active.
Once you’ve added this to a query, it works until you remove it.
Solution 2: Remove a deactivated account
In Google Sheets, open the SupermetricsQueries tab (if this is hidden, navigate to Add-ons, then click Supermetrics, then Manage queries). Find the row with the impacted query, scroll to the Accounts/Views column, and remove the deactivated account.
In Google Data Studio, open the main configuration settings for the Google Ads data source, uncheck the box next to the deactivated account to remove it from the query.