SEARCH and SEARCH_PARTNER cannot use at the same time

[Yuichiro Honda]

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.

[Google Ads API Forum Advisor Prod]

Hi Yuichiro,

Thank you for reaching out.

You may refer below for the definition and difference of SEARCH and SEARCH_PARTNERS values :

Search (network)  
Search partners

Regarding the 'internal error' that you encountered when using both values at the same time in your query, could you provide your customer ID and the complete request and response logs that were generated when the error occurred?

You may send your reply using the Reply privately to author option.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q274d0R:ref