Issue

Google Display & Video 360 impressions data is different in the source and destination.

Environment

Connector: Google Display & Video 360

Answer

There are two potential causes and resolutions:

1. There are timezone differences:

   • When you are summing your engagements data, take into account that the data we are pulling has the timezone America/New_York and offset accordingly.
   • Set the timezone in the Google report to match the default timezone of America/New_York.
2. The dimensions and metrics configured in the connector do not match the GD&V 360 UI report configuration:
   • Verify the dimensions and metrics match exactly
   • Use dimensions with * ID if you are viewing the data by ID in the GD&V 360 UI, (e.g., Line Item ID).

Cause

When Fivetran generate the report request for Google Display & Video 360, we use the default timezone America/New_York. This is defined in Google's documentation as the Canonical timezone code for report data time.

If there is a mismatch in the dimensions and metrics the data may be aggregated differently which creates discrepancies with the data synced.