How to add all accounts to a Google Sheets query

You can add all your accounts in one data source — every account the logged-in user has access to — in the query’s results.


This feature is available in:

  • Microsoft Advertising
  • Google Ads
  • Google Analytics


To activate this feature, open the Supermetrics sidebar, scroll down to the Select accounts section, and add All accounts in the account list field.


If you’re using this feature with Google Ads, you can also add EXCLUDE_INVALID_ACCOUNTS to any query. This will make sure your queries run even if your account list includes any inactive Google accounts.

Did you find it helpful? Yes No

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