Video Targetting Keywords - availability in reports

48 views
Skip to first unread message

Oksana Sulyma

unread,
Jul 17, 2018, 10:24:44 AM7/17/18
to AdWords API and Google Ads API Forum
Hi dear Adwords API support! I really need direction in the next question.
In Adwords UI we see Video Targeting -> Keywords available:

When I pull Display Keyword Performance Report I get much bigger statistic then I see in UI.
I wonder if there is a way to get the same statistic then in UI Video Targeting -> Keywords.
May be I can use some filter based on AdNetworkType1?
I'll appreciate any information on this.
Thanks,
Oksana

Bharani Cherukuri (AdWords API Team)

unread,
Jul 17, 2018, 4:59:35 PM7/17/18
to AdWords API and Google Ads API Forum
Hi Oksana, 

I was able to pull the Display Keyword Performance Report for LAST_MONTH and see that the Performance metrics are matching with the web interface. Here is my report query:

SELECT CampaignId, CampaignName, Clicks, Conversions, Impressions, Cost, Criteria FROM DISPLAY_KEYWORD_PERFORMANCE_REPORT DURING LAST_MONTH

The stats for the keyword (outdoor adventure clothing) is the same both in the API and the UI. Could you share us the report query for which you're experiencing the discrepancy so I can take a look? 

Thanks,
Bharani, AdWords API Team

Oksana

unread,
Jul 18, 2018, 7:43:33 AM7/18/18
to adwor...@googlegroups.com

Thanks for looking at this Bharani!

Here is UI screenshot our client provided to us - see attach. The client id = xxxxxxxx - Ski Barn, date range is June 2018.

Here is report that I get from Adwords API for the first keyword from screenshot = 'outdoor adventure clothing'.

In report we see summary Impressions equal to 66,675, while on client's screenshot we see Impressions = 13,335.


My request XML is:

<reportDefinition xmlns="https://adwords.google.com/api/adwords/cm/v201802">
            <selector>
            <fields>CampaignId</fields>
<fields>AdGroupId</fields>
<fields>Criteria</fields>
<fields>Id</fields>
<fields>AdNetworkType1</fields>
<fields>ClickType</fields>
<fields>Device</fields>
<fields>CriteriaDestinationUrl</fields>
<fields>Status</fields>
<fields>CpcBid</fields>
<fields>CpmBid</fields>
<fields>CpcBidSource</fields>
<fields>CpmBidSource</fields>
<fields>Date</fields>
<fields>ActiveViewImpressions</fields>
<fields>Clicks</fields>
<fields>ConversionValue</fields>
<fields>Conversions</fields>
<fields>Cost</fields>
<fields>Impressions</fields>
<fields>FinalUrls</fields>
<fields>GmailForwards</fields>
<fields>GmailSaves</fields>
<fields>GmailSecondaryClicks</fields>
<fields>CpvBid</fields>
<fields>CpvBidSource</fields>
<fields>FinalAppUrls</fields>
<fields>FinalMobileUrls</fields>
<fields>IsNegative</fields>
<fields>IsRestrict</fields>
<fields>ActiveViewMeasurableImpressions</fields>
<fields>ActiveViewMeasurableCost</fields>
<fields>AllConversions</fields>
<fields>AllConversionValue</fields>
<fields>CrossDeviceConversions</fields>
<fields>Interactions</fields>

            <predicates>
<field>AdGroupId</field>
<operator>IN</operator>
<values>55423292558</values>
<values>52919639423</values>
</predicates>
<predicates>
<field>Criteria</field>
<operator>IN</operator>
<values>outdoor adventure clothing</values>
</predicates>

            <dateRange>
<min>20180601</min><max>20180630</max></dateRange>
            </selector>
            <reportName>Adwords Display Keyword List</reportName>
            <reportType>DISPLAY_KEYWORD_PERFORMANCE_REPORT</reportType>
            <dateRangeType>CUSTOM_DATE</dateRangeType>
            <downloadFormat>CSV</downloadFormat>
            </reportDefinition>

We are interested exactly in explanation for this report with all the fields mentioned as this is what works for our clients.

Could you please advice, don't know why Impressions in Report are bigger then in UI.

Thank you,

Oksana

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to a topic in the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-api/c7UJv27GwFQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/f4f81a83-d647-4a73-b77b-f26badc152f0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

image-2018-07-16-14-17-06-944.png

Oksana

unread,
Jul 18, 2018, 7:44:40 AM7/18/18
to adwor...@googlegroups.com

Sorry forgot to attach the report I get - here it is.

DisplayKeywords_for_9166488348_from_2018-06-01_to_2018-06-30(1).csv

Bharani Cherukuri (AdWords API Team)

unread,
Jul 18, 2018, 2:11:28 PM7/18/18
to AdWords API and Google Ads API Forum
Hi Oksana, 

Thank you for sharing the details. I edited your previous post to mask the client customer ID. This said, the Display Keyword Performance report includes all Display Network and YouTube Network statistics aggregated at the keyword level, one row per keyword. If other segment fields are used, you may get more than one row per keyword. In this case, the report query involves multiple segment fields which explains the increase in the impressions count. On the other hand, if you pull the data with the report query given below this will return the impressions for this criteria as 13,335. 

SELECT CampaignId, CampaignName, Clicks, Conversions, Impressions, Cost, Criteria FROM DISPLAY_KEYWORD_PERFORMANCE_REPORT DURING LAST_MONTH

Hope this addressed your question. Let me know if you have any other questions. 

Regards,
Bharani, AdWords API Team

Oksana

unread,
Jul 19, 2018, 7:40:14 AM7/19/18
to adwor...@googlegroups.com

Thanks Bharani!

I think I'm clear with the answer you've provided. But I'll let you know if our client brings up some questions which I won't be able to answer :)

Thanks again for looking at this!

Oksana

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to

For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to a topic in the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-api/c7UJv27GwFQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-api...@googlegroups.com.

Bharani Cherukuri (AdWords API Team)

unread,
Jul 19, 2018, 8:42:35 AM7/19/18
to AdWords API and Google Ads API Forum
Hi Oksana, 

Sure, feel free to write back to us if you have any other follow-up questions. I will be happy to assist you. 
Reply all
Reply to author
Forward
0 new messages