Have you experienced any discrepancies when querying two or more Hub Accounts? Don't worry, here's the reason why, and how to fix it.
There are some metrics with special behavior that cannot be added up together to get a total, such as Users from Google Analytics, or Frequency and Reach from different connectors.
As these metrics cannot be summed up, when you select more than one Hub Account in one query with those metrics, it can lead to discrepancies because the result comes from an incorrect sum.
How to solve the discrepancy
Solving this discrepancy is very simple. You have two options:
Add Account dimension
Add the Hub Account dimension from the Dataslayer group or the Account / Account name dimension from the selected data source.
The Dataslayer Hub Account dimension will show you the email(s) you are logged into that connector, in case you have several accounts associated with the same email, add the Account / Account name dimension of the selected data source.
Sample using Reach and Frequency metrics from Facebook Ads in Google Sheets
Individual query
The other option is to make an individual query for each account since these metrics cannot be added to show a total from different Hub Accounts.
As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!