Google Ads API - Placement Detail Incomplete data

['Jessie' via AdWords API and Google Ads API Forum]

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.

RE: Google Ads API - Placement Detail Incomplete data

[googleadsapi-forumadvisor via AdWords API and Google Ads API Forum]

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

On 05/16/19 07:28:07 jessie.laba...@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.
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/ujqug246dg010sgb6i000t52cqw68mjcdpj74o30c1g68rj0c9g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

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

[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

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/RKb7d0PU614H00YtRZCJHQS2eqH3dx4931wA%40sfdc.net.

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

[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

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/FPRif0PUDY8J00Iw9u97p0RkqzRQfG_GKEyg%40sfdc.net.

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

[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

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/v1LMr0PUEM7V00jXClPx7eT2SGzRkgg_B5Aw%40sfdc.net.

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.