Zero Impression Data for Corrections

[Ryan Whitten]

Hi there, 

I know in the Google Ads API zero impression rows will be filtered out if 
you segment by date. However we have been seeing rows with zeros for all 
metrics, including impressions, come in when segmenting by date. 

We are actually looking to get the zero impression rows to handle the case 
where data is corrected after delivery (e.g. there was 1 impression on date 
X deemed to be invalid, so it gets adjusted to 0 several days later). This 
allows us to update the data stored in our own system and ensure the 
delivery numbers are accurate.

How does the API handle this case of corrected/adjusted data and returning 
the zero impression rows? Is there logic in place to return zero rows in 
this scenario, and that is why we do get some zero rows returned? 

Example query:

SELECT segments.date, segments.device, ad_group_ad.ad.id, campaign.id, 
ad_group.id, metrics.active_view_cpm, metrics.active_view_ctr, 
metrics.active_view_impressions, metrics.active_view_measurability, 
metrics.active_view_measurable_cost_micros, 
metrics.active_view_measurable_impressions, 
metrics.active_view_viewability, metrics.all_conversions, 
metrics.all_conversions_value, metrics.clicks, metrics.conversions, 
metrics.conversions_value, metrics.cost_micros, 
metrics.cross_device_conversions, metrics.engagements, metrics.impressions, 
metrics.interactions, metrics.interaction_event_types, 
metrics.video_quartile_100_rate, metrics.video_quartile_25_rate, 
metrics.video_quartile_50_rate, metrics.video_quartile_75_rate, 
metrics.video_views, metrics.view_through_conversions  
FROM ad_group_ad 
WHERE segments.date BETWEEN '2019-10-01' AND '2019-10-07'


Thanks!
Ryan 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/e3553caa-e3c1-416e-a953-dc203a03f44a%40googlegroups.com.

Re: Zero Impression Data for Corrections

[Ryan Whitten]

Hi there, 

Thanks for your reply. We are using that same report query I posted and 
occasionally get zero impression rows returned. Since we want the zeroes 
that part is not a big deal for us, just the inconsistency is. 

What is the best way to request this as a product feature? We would really 
like the ability to ask for zero impression data much like the old AdWords 
API. Without it, we can never have the latest corrected data unless we 
request one day at a time and remove the segments. Requesting one day at a 
time really decreases performance so we are without a great solution in the 
Google Ads API. 

Thanks,
Ryan 

On Thursday, November 14, 2019 at 3:49:10 PM UTC-5, adsapiforumadvisor 
wrote:
>
> Hi Ryan,
>
> Thank you for reaching the support. As mentioned in this 
> 
>  
> guide, zero impressions are always excluded when segmenting a report. If 
> you are still getting the zero impressions data, could you please confirm 
> if you are using the shared report query while generating the reports via 
> API? If not, could you please share the complete report query along with 
> the client customer id and the report files generated via API for me to 
> take a look into this further? For your other concern, it is not possible 
> to include zero impressions when you use segmentation in the report query. 
> The API request call will return the impressions present in the UI for the 
> corrected data or adjusted data, if zero, this will be excluded from the 
> reports generated via API. Let us know if you need any further 
> clarifications.
>
> PS: Please use *Reply privately to author* option while sharing the 
> details.
>
> Regards,
> Nikisha Patel, Google Ads API Team
>
>
> ref:_00D1U1174p._5001UJamO6:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/da454464-49a2-4ebc-a09a-39384c4e44cc%40googlegroups.com.

Headline & Description Fields Missing for Video Discovery Ads

[Ryan Whitten]

Hi there, 

We traditionally got headline, description_1, and description_2 fields for 
video discovery ads via the AD_PERFORMANCE_REPORT in the AdWords API. We 
are now trying to get the same data in the Google Ads API and cannot get 
any results for video discovery ads. 

Should these fields be returning values for video discovery ads, or is 
there another type we should be using?  I can only find TrueViewInstream 
references in the docs (e.g. 
ad_group_ad.ad.video_ad.in_stream.companion_banner), nothing for video 
discovery. 

ad.text_ad.description_1
ad.text_ad.description_2
ad.text_ad.headline

Thanks,
Ryan 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/eb7349b2-180f-43dd-9535-1c6a53253cfb%40googlegroups.com.

Re: Google Ads API - Placement Detail Incomplete data

[Ryan Whitten]

Hi, sorry for reviving an old topic but I have a related question. If the 
only metrics that are included for placements are the ones in the metrics 
dropdown for detail_placement_view, why does the migration guide suggest 
that you can query many more metrics? Do you need to join another resource 
type? 
https://developers.google.com/google-ads/api/docs/migration/reports#url_performance
 

Thanks,
Ryan 

On Thursday, May 16, 2019 at 5:47:49 AM UTC-4, googleadsapi-forumadvisor 
wrote:
>
> Hi Jessie,
>
> Currently, the only available metrics that can be retrieved from the 
> detail_placement_view 
> 
>  are 
> the ones included in the link's *metrics* dropdown. For now, you may 
> follow our blog  for updates.
>
> Thanks and regards,
> Peter
> Google Ads API Team
>
> Was your question answered? Please rate your experience with us by taking 
> a short survey.
> If not -- reply to this email and tell us what else we can do to help.
>
> Take Survey 
> 
>
> Also find us on our blog and discussion group:
> http://googleadsdeveloper.blogspot.com/search/label/adwords_api
> https://developers.google.com/adwords/api/community/
> On 05/16/19 07:28:07 jessie...@3qdigital.com  wrote:
>
> Hi,
>
> I'm building an application (using Google ads library) that will retrieve 
> data from detail_placement_view table. Unfortunately, the api doesn't 
> return all the columns data for View rate, Avg. CPV and Cost (screenshot 
> below) which opposite to UI that does return the required information. Is 
> there a way on how to retrieve the data for the columns below?
>
> [image: cols.JPG]
>
>
>
>
>
> Thanks,
> Jessie
>
> -- 
> -- 
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> 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 adwords-api@googlegroups.com
> To unsubscribe from this group, send email to
> adwords-api+unsubscr...@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 the Google Groups 
> "AdWords API and Google Ads API Forum" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to adwords-api+unsubscr...@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/f78a60bf-576f-44e5-94b9-a256e91c6cb2%40googlegroups.com
>  
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/972469e0-84f8-40a1-b4a4-e608acce8f73%40googlegroups.com.

Re: Google Ads API - Placement Detail Incomplete data

[Ryan Whitten]

Hi, 

Thank you. I did have trouble accessing other metrics listed on the 
migration guide but not on the view page. Should the view be more accurate 
than the migration guide, or is the view not feature complete yet? I don't 
have the error handy but it essentially said the requested metric was not 
valid for the detail_placement_view. 

Thanks,
Ryan 

On Friday, July 5, 2019 at 6:58:14 AM UTC-4, adsapiforumadvisor wrote:
>
> Hi Ryan,
>
> No worries as the thread itself isn't too old. :)
>
> Also, thank you for your observation. Regarding this, you may follow the 
> migration 
> guide 
>  for 
> now in the event that the view's documentation appear to be incomplete. 
> Allow me as well to file a request to have the documentation updated.
>
> Please note, however, that there is no guarantee as to when the updates 
> may be applied. You can follow our blog 
>  and our release notes 
>  for 
> updates.
>
> Thanks and regards,
> Peter
> Google Ads API Team
>
> ref:_00D1U1174p._5001UCb3UA:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/87d18ae0-0459-4f51-a4d8-60e09fc071ba%40googlegroups.com.

Re: Google Ads API - Placement Detail Incomplete data

[Ryan Whitten]

Hi Bharani, 

Thanks for your help. Here is an example query and the error I get. Note 
that the query works if I remove `metrics.engagements` from the requested 
fields. Engagements is listed in the migration guide for URL Performance 
Report, but not listed as a metric for the detail_placement_view. 

Query:

query = ('SELECT detail_placement_view.display_name, 
detail_placement_view.group_placement_target_url, '
 'detail_placement_view.placement, 
detail_placement_view.placement_type, '
 'detail_placement_view.resource_name, '
 'detail_placement_view.target_url, campaign.id, ad_group.id, '
 'metrics.clicks, metrics.impressions, metrics.video_views, 
metrics.engagements '
 'FROM detail_placement_view '
 'WHERE segments.date DURING LAST_7_DAYS')

response = self.service.search(self.account_id_ext, query, page_size=50)




Error message:
{
  error_code {
query_error: PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE
  }
  message: "Cannot select or filter on the following metrics: 
\'engagements\'(could not support requested resources: 
\'DETAIL_PLACEMENT_VIEW\', \'DETAIL_PLACEMENT_VIEW\'), since metric is 
incompatible with the resource in the FROM clause or other selected 
segmenting resources."
}

Thanks,
Ryan

On Tuesday, July 9, 2019 at 1:36:36 PM UTC-4, adsapiforumadvisor wrote:
>
> Hello Ryan, 
>
> I'm Peter's colleague addressing your concern on his behalf. The migration 
> guide should be helpful to find the equivalent Google Ads API report 
> fields. The reporting data can be pulled using the Views directly or they 
> can be pulled through the Criteria reports. If you could share more 
> context(error logs, report query) on the error that you are receiving it 
> will help check this further. 
>
> Thanks,
> Bharani, Google Ads API Team
>
> ref:_00D1U1174p._5001UCb3UA:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/cb043c4f-d5be-48c0-9851-9b2f36fefaa7%40googlegroups.com.

Re: Google Ads API - Placement Detail Incomplete data

[Ryan Whitten]

Hi Josh, 

Thank you, that did the trick! I had been using the same migration guide 
before v2 came out and didn't see the announcement about v2. It's great 
that the issue has been resolved in v2. 

Thanks,
Ryan 

On Tuesday, July 9, 2019 at 10:19:32 PM UTC-4, adsapiforumadvisor wrote:
>
> Hi Ryan,
>
> Are you using v1 or v2 of the API? I ask because I just confirmed that the 
> query you provided fails in v1, but succeeds in v2.
>
> Regarding the migration guide, we update that with each new version of the 
> API, so if you are comparing that guide to the API Fields in the reference 
> section, you'll want to use the section under the latest version 
> 
>  
> . However, if you see any inconsistencies or issues with the documents, 
> please do not hesitate to let us know.
>
> Thanks,
> Josh, Google Ads API Team
>
> ref:_00D1U1174p._5001UCb3UA:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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 the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/00a3c150-6b3b-4353-aa7a-9ce6cd243829%40googlegroups.com.