Video Performance Report Bug

[Emad Aldeen Hajjar]

Hello!

I'm not getting any campgins when using report definition VIDEO_PERFORMANCE_REPORT to fetch reports for videos, and the only way to receive the correct data if I select only CampaignId field but of course this dosen't help me at all because I need the rest of feilds

<reportDefinition xmlns="https://adwords.google.com/api/adwords/cm/v201509">

<selector>

<fields>CampaignId</fields>

<fields>Clicks</fields>

<fields>VideoViews</fields>

<fields>VideoQuartile25Rate</fields>

<fields>VideoQuartile50Rate</fields>

<fields>VideoQuartile75Rate</fields>

<fields>VideoQuartile100Rate</fields>

<fields>AverageCpv</fields>

<fields>ConversionRate</fields>

<fields>Conversions</fields>

<fields>CostPerConversion</fields>

<predicates>

<field>CampaignId</field>

<operator>IN</operator>

<values>306630493</values>

</predicates>

<dateRange>

<min>20151101</min>

<max>20151108</max>

</dateRange>

</selector>

<reportName>Video Report</reportName>

<reportType>VIDEO_PERFORMANCE_REPORT</reportType>

<dateRangeType>CUSTOM_DATE</dateRangeType>

<downloadFormat>GZIPPED_XML</downloadFormat>

</reportDefinition>

Thanks for your help!

[Michael Cloonan (AdWords API Team)]

Hello,

I just ran some tests on my end and confirmed that this is happening. I have reported the issue to engineering and I'll let you know when I hears something back.

Regards,

Mike, AdWords API Team

[Michael Cloonan (AdWords API Team)]

Hello,

Did you happen to be using the Ruby client library? I found an issue in that library that will be fixed in the next release, where this header was misspelled.

Regards,

Mike, AdWords API Team

On Monday, November 9, 2015 at 12:51:27 PM UTC-5, Emad Aldeen Hajjar wrote:

[Emad Aldeen Hajjar]

Hey Michael,

No, I got this issue in PHP client library.

[Emad Aldeen Hajjar]

I tried googleads-php-lib-v6.5.0 and I'm getting the same issue.

[Thanet Knack Praneenararat (AdWords API Team)]

Hi Emad,

Have you tried setting includeZeroImpressions to true in the header of report definition request?

This guide might be useful to you as well.

It seems your campaign got no statistics during that date period though.

Best,

Thanet, AdWords API Team

[PABLO DE ASSIS]

Hello,

I am get a very weird bug right now that seems related. Some campaings are showing zero results on API v201509, while on the Adwords panel they show results. 

Then, when I try to use the v201603 api version, I get even weirder results. For AdGroupName I receive "X-OLD: Google Internal Only 1" (while they should be "Ampla Rosinha (In-Stream)") and the results are also empty.

And those results only appear if I put includeZeroImpressions to true (on v201509 I dont need to set this). Otherwise the report comes just null. No errors, at all, just nothing.

Here is a debug of my call:

$selector = Selector Object
(
    [fields] => Array
        (
            [0] => AdGroupName
            [1] => VideoViews
            [2] => VideoViewRate
            [3] => AverageCpv
            [4] => Impressions
            [5] => Clicks
            [6] => Cost
            [7] => Ctr
            [8] => VideoQuartile25Rate
            [9] => VideoQuartile50Rate
            [10] => VideoQuartile75Rate
            [11] => VideoQuartile100Rate
        )

    [predicates] => Array
        (
            [0] => Predicate Object
                (
                    [field] => CampaignId
                    [operator] => EQUALS
                    [values] => 342828084
                )

            [1] => Predicate Object
                (
                    [field] => AdGroupId
                    [operator] => EQUALS
                    [values] => 24182302164
                )

        )

    [dateRange] => 
    [ordering] => 
    [paging] => 
)

$videoData = <?xml version='1.0' encoding='UTF-8' standalone='yes'?><report><table><row adGroup='X-OLD: Google Internal Only 1' views='0' viewRate='0.00%' avgCPV='0' impressions='0' clicks='0' cost='0' ctr='0.00%' videoPlayedTo25='0.00%' videoPlayedTo50='0.00%' videoPlayedTo75='0.00%' videoPlayedTo100='0.00%'/></table></report>

$xmlVideo = SimpleXMLElement Object
(
    [table] => SimpleXMLElement Object
        (
            [row] => SimpleXMLElement Object
                (
                    [@attributes] => Array
                        (
                            [adGroup] => X-OLD: Google Internal Only 1
                            [views] => 0
                            [viewRate] => 0.00%
                            [avgCPV] => 0
                            [impressions] => 0
                            [clicks] => 0
                            [cost] => 0
                            [ctr] => 0.00%
                            [videoPlayedTo25] => 0.00%
                            [videoPlayedTo50] => 0.00%
                            [videoPlayedTo75] => 0.00%
                            [videoPlayedTo100] => 0.00%
                        )

                )

        )

)

I am using the latest PHP client library.

Tks in advance.

Pablo

[PABLO DE ASSIS]

Digging deeper, it looks like the api is delivering non existent adgroups when we call the report with includeZeroImpressions=true.

Weird.

[Thanet Knack Praneenararat (AdWords API Team)]

Hi Pablo,

In the past, could you use the ad group ID 24182302164 to get the ad group with the name "Ampla Rosinha (In-Stream)"?

What happens if you request a report using just one predicate to get only the campaign with ID 342828084?

Does the API return the same set of ad groups as those shown in UI when you select to show All ad groups (instead of All but removed)?

Cheers,

Thanet, AdWords API Team