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, 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.