Open navigation

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:

  • Google Ads
  • Google Analytics
  • Google Analytics 4
  • Microsoft Advertising


To activate this feature, open the Supermetrics sidebar and find the query using these data sources. Scroll down to the Select accounts section (labeled Select properties in Google Analytics 4) 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.