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