"Total" text overwrites metric total in performance report summaries

[Tiana S.]

Hi guys,

We're noticing some odd behavior fetching data from the AdWords Reporting API.

When fetching data, the "Total" text returned seems to be overwriting the actual total of the first requested field.
So take for example the following query:

SELECT VideoQuartile100Rate FROM VIDEO_PERFORMANCE_REPORT WHERE Impressions > 0 DURING 20140101,20171231

When requesting that, the following data is returned:

Video played to 100%
24.28%
20.55%
Total

And when fetching two fields:

SELECT VideoQuartile100Rate,VideoQuartile25Rate FROM VIDEO_PERFORMANCE_REPORT WHERE Impressions > 0 DURING 20140101,20171231

We get the following:

Video played to 100%,Video played to 25%
24.28%,40.16%
20.55%,37.97%
Total,38.42%

After checking the interface, we confirmed the total returned is the total for Video played to 25%:

So this indicates the "Total" text is actually overwriting the total for Video played to 100%.

Just wondering if this is known and by design or a bug in the API.

Thanks!

[Dhanya Sundararaju (AdWords API Team)]

Hi Tiana,

This is a known issue. You are right that the 'Total' text is overwriting the total for video played for 25%. To overcome this, you can include an attribute from the Video Performance Report as your first column which will not need to display a total.

Regards,
Dhanya, Adwords API Team