Hi, I execute this query with google-ads-ruby:
SELECT
ad_group.id,
ad_group.name,
ad_group.status,
ad_group_ad.ad.id,
ad_group_ad.status,
campaign.id,
campaign.name,
campaign.status,
customer.currency_code,
customer.descriptive_name,
customer.id,
customer.time_zone,
video.channel_id,
video.duration_millis,
video.id,
video.title,
metrics.all_conversions,
metrics.all_conversions_from_interactions_rate,
metrics.all_conversions_value,
metrics.average_cpm,
metrics.average_cpv,
metrics.clicks,
metrics.conversions,
metrics.conversions_value,
metrics.cost_micros,
metrics.cost_per_all_conversions,
metrics.cost_per_conversion,
metrics.cross_device_conversions,
metrics.ctr,
metrics.engagement_rate,
metrics.engagements,
metrics.impressions,
metrics.value_per_all_conversions,
metrics.video_quartile_p100_rate,
metrics.video_quartile_p25_rate,
metrics.video_quartile_p50_rate,
metrics.video_quartile_p75_rate,
metrics.video_view_rate,
metrics.video_views,
metrics.view_through_conversions,
segments.ad_network_type
FROM
video
WHERE
segments.ad_network_type IN ('CONTENT', 'MIXED', 'SEARCH',
'SEARCH_PARTNERS', 'UNKNOWN', 'YOUTUBE_SEARCH', 'YOUTUBE_WATCH')
AND
segments.date DURING LAST_30_DAYS
and I got this error:
13:Internal error encountered..
debug_error_string:{"created":"@1603706505.702929000","description":"Error
received from peer ipv4:
...","file":"src/core/lib/surface/call.cc","file_line":1062,"grpc_message":"Internal
error encountered.","grpc_status":13} (GRPC::Internal)
What I found was removing 'SEARCH' or 'SEARCH_PARTNERS' from the WHERE
clause worked. I want to know why and I also want to know what is 'SEARCH'
and what is 'SEARCH_PARTNERS'.
Thank you.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/9f685ac9-1c6c-48c7-95f8-580d013882den%40googlegroups.com.
