This guide applies to the following Google Ads error:
USER_PERMISSION_DENIED: user xxxxxxxxxx doesn't have permissions for account <10-digit account code>.
This error generally means that the Google user logged into Google Ads either has an expired authentication or had lost permissions to the account in Google Ads. First try re-authenticating the data source:
- Google Sheets: How do I Re-Authenticate a Google Sheets Connector?
- Data Studio: How do I Re-Authenticate a Data Studio Connector?
- Excel: How do I Re-Authenticate an Excel Connector?
- Data Grabber: Log into the module for Google Ads/Ad Words
- Functions: Use the link to log in again and generate a new token code
If the error persists after refreshing the authentication, the Google Ads user may no longer have access to the given account (the last 10-digits of the error is the account number as seen in Google Ads). Check with your administrator to make sure the user has permissions to access that ad account. If the account is no longer accessable on purpose, de-select the account/remove it from the query to clear the error.
If everything fails...
If the error still persists, go to the SupermetricsQueries sheet (if hidden, click on Add-ons-Supermetrics-Manage queries).
Find the row(s) for your Google Ads queries, delete the query ID value in that row and then scroll to the far right and delete the value under “Refresh with user account”.
Delete the query ID from the SupermetricsQueries tab on the failing queries.
After that, refresh all queries. To refresh all queries, click on Add-ons-Supermetrics-Refresh all.