Hi Dave,
Anash was able to provide me with the following answer, and it works!
YOUTUBE_CHANNEL is a placement criterion, so managed_placement_view should
give you the data you need. The following query should work.
SELECT metrics.active_view_viewability, metrics.average_cpm, " +
"metrics.average_cpv, metrics.cost_micros,
metrics.impressions, " +
"metrics.video_quartile_25_rate,
metrics.video_quartile_50_rate, " +
"metrics.video_quartile_75_rate,
metrics.video_quartile_100_rate, " +
"metrics.video_view_rate, metrics.video_views FROM
managed_placement_view " +
"WHERE ad_group_criterion.type = 'YOUTUBE_CHANNEL' and
ad_group.id = 61856865793
Best,
Michael Xue
On Thursday, April 4, 2019 at 4:34:05 AM UTC-4, googleadsapi-forumadvisor
wrote:
>
> Hi Michael,
>
> Thank you for reaching out. Unfortunately, The CRITERIA_PERFORMANCE_REPORT
> from AdWords API has no exact equivalent in Google Ads API. For your
> concern about the GAQL returning 0 rows as opposed to the AWQL returning
> 3800 rows, I would need to check this with the team. I will get back to you
> as soon as we gather all the information needed to help you with this
> concern.
>
> Regards,
> Dave Paurillo
> Google Ads API Team
>
>
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> Also find us on our blog and discussion group:
> https://ads-developers.googleblog.com/search/label/google_ads_api
> https://developers.google.com/adwords/api/community/
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
>
> 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
> <https://support.google.com/google-ads/contact/survey_transactional?caseid=1-1567000026135&hl=en&ctx=1>
>
> 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 04/04/19 00:14:44 [email protected] <javascript:> wrote:
>
> Hi,
>
> We're in the process of migrating from Adwords API to Google Ads API. One
> issue we had was mapping the CRITERIA_PERFORMANCE_REPORT query to its
> equivalent in Google Ads query. Here's a sample query we run in AWQL:
> SELECT ActiveViewViewability, AverageCpm, AverageCpv, Cost, Impressions,
> VideoQuartile25Rate, VideoQuartile50Rate, VideoQuartile75Rate,
> VideoQuartile100Rate, VideoViewRate, VideoViews
> FROM CRITERIA_PERFORMANCE_REPORT
> WHERE CriteriaType='YOUTUBE_CHANNEL' AND AdGroupId=61856865793
>
> This is our best guess at the equivalent query in Google Ads:
> SELECT metrics.active_view_viewability, metrics.average_cpm, metrics.
> average_cpv, metrics.cost_micros, metrics.impressions, metrics.
> video_quartile_25_rate, metrics.video_quartile_50_rate, metrics.
> video_quartile_75_rate, metrics.video_quartile_100_rate, metrics.
> video_view_rate, metrics.video_views
> FROM ad_group_audience_view
> WHERE ad_group_criterion.type='YOUTUBE_CHANNEL'
> AND ad_group.id=61856865793
>
> However, the original AWQL returns around 3800 rows, but the new GAQL
> query returns 0 rows. Can you confirm that this is indeed the correct
> mapping? Thanks in advance.
>
> Best,
> Michael Xue
>
> --
> --
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> 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 [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> 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 [email protected].
> 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/4f256271-7025-472a-b924-3c1d007e8840%40googlegroups.com
>
> <https://groups.google.com/d/msgid/adwords-api/4f256271-7025-472a-b924-3c1d007e8840%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> 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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
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/92585592-efb7-46dc-a8c0-15ec756c1322%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
