Why do I have discrepancies in reports of different types and different tables?
Connector: Google Ads
We’ve answered the most common questions about data discrepancy in our Google Ads connector.
Why do I have different total counts of campaign IDs when comparing the
The AdWords API provides different sets of campaign types for different types of reports. For example, the
CAMPAIGN_STATS table is based on Google’s
Campaign Performance Report, which includes App Campaign data. However, the
CAMPAIGN_HISTORY table is a metadata table which does not include App Campaigns (or Video Campaigns too) due to limitations of the AdWords API.
As a result, you may have a different number of campaign IDs (and associated stats) when you compare these two tables.
Why are some cost and impression counts in my Google Ads connector schema different from what they are in my Google Dashboard?link
In some cases, including dimensions (segments) in your reports can increase or decrease values for cost and impressions in your data.
For example, adding the
ClickType dimension to
Ad Performance Report can cause double counting for metric fields. See Google’s AdWords API documentation for more information.
Furthermore, make sure that you do not compare data between reports of different types for the same reasons - data for a
Url Performance Report in the Google Dashboard may not exactly match data in your
Final Url Report destination table.
Why are the cost and impression counts of an Ad Performance Report in my Google Ads connector schema different from what they are in the other reports of the same connector?link
Check the dimensions (segments/fields) of your Ad Performance Report.
If you’ve selected
IsNegative, the data in the report may not match the data in the other reports.
Campaigns of some types (e.g., Discovery campaigns) may not contain specific criteria. When you try to segment the data by
CriterionId, the AdWords API returns only the rows where it identified the allowed
CriterionId values, and filters out everything else.