Google Ads API - Placement Detail Incomplete data

[Jessie]

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?

Thanks,

Jessie

[googleadsapi...@google.com]

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/

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 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+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/f78a60bf-576f-44e5-94b9-a256e91c6cb2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[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/

[Google Ads API Forum Advisor Prod]

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

[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 

[Google Ads API Forum Advisor Prod]

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

[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

[Google Ads API Forum Advisor Prod]

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

[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