Inquiry for API and Google ads API
Kyotsu
our request
curl --location --request POST 'https://googleads.googleapis.com/v10/customers/4061742590/googleAds:search' \
--header 'Authorization: Bearer ' \
--header 'developer-token: developer_token' \
--header 'User-Agent: curl' \
--header 'Accept: application/json' \
--header 'login-customer-id: login-customer-id' \
--header 'Content-Type: application/json' \
--data-raw '{
"query": "SELECT segments.ad_network_type ,segments.date ,segments.device ,customer.id ,customer.descriptive_name ,campaign.id ,campaign.name ,campaign.labels ,ad_group.name ,ad_group.labels ,ad_group_ad.labels ,ad_group_ad.ad_group ,ad_group_ad.ad.id ,ad_group_ad.ad.name ,ad_group_ad.ad_strength ,ad_group_ad.ad.type ,ad_group_ad.ad.final_mobile_urls ,ad_group_ad.ad.final_urls ,ad_group_ad.ad.final_url_suffix ,ad_group_ad.ad.tracking_url_template ,ad_group_ad.ad.url_custom_parameters ,ad_group_ad.ad.legacy_responsive_display_ad.description ,ad_group_ad.ad.expanded_text_ad.description ,ad_group_ad.ad.text_ad.description1 ,ad_group_ad.ad.call_ad.description1 ,ad_group_ad.ad.text_ad.description2 ,ad_group_ad.ad.call_ad.description2 ,ad_group_ad.ad.device_preference ,ad_group_ad.ad.display_url ,ad_group_ad.ad.expanded_dynamic_search_ad.description ,ad_group_ad.ad.expanded_dynamic_search_ad.description2 ,ad_group_ad.ad.expanded_text_ad.description2 ,ad_group_ad.ad.expanded_text_ad.headline_part3 ,ad_group_ad.ad.text_ad.headline ,ad_group_ad.ad.expanded_text_ad.headline_part1 ,ad_group_ad.ad.expanded_text_ad.headline_part2 ,ad_group_ad.ad.image_ad.image_url ,ad_group_ad.ad.image_ad.pixel_height ,ad_group_ad.ad.image_ad.pixel_width ,ad_group_ad.ad.image_ad.mime_type ,ad_group_ad.ad.image_ad.name ,ad_group_ad.ad.legacy_responsive_display_ad.long_headline ,ad_group_ad.ad.responsive_display_ad.youtube_videos ,ad_group_ad.ad.expanded_text_ad.path1 ,ad_group_ad.ad.expanded_text_ad.path2 ,ad_group_ad.ad.responsive_search_ad.descriptions ,ad_group_ad.ad.responsive_search_ad.headlines ,ad_group_ad.ad.responsive_search_ad.path1 ,ad_group_ad.ad.responsive_search_ad.path2 ,ad_group_ad.ad.legacy_responsive_display_ad.short_headline ,ad_group_ad.ad.app_ad.descriptions ,ad_group_ad.ad.app_ad.headlines ,ad_group_ad.ad.app_ad.html5_media_bundles ,ad_group_ad.ad.app_ad.images ,ad_group_ad.ad.app_ad.mandatory_ad_text ,ad_group_ad.ad.app_ad.youtube_videos ,ad_group_ad.ad.video_ad.in_feed.description1 ,ad_group_ad.ad.video_ad.in_feed.description2 ,metrics.absolute_top_impression_percentage ,metrics.active_view_impressions ,metrics.active_view_measurable_cost_micros ,metrics.active_view_measurable_impressions ,metrics.all_conversions ,metrics.all_conversions_value ,metrics.clicks ,metrics.conversions ,metrics.conversions_value ,metrics.cost_micros ,metrics.cross_device_conversions ,metrics.current_model_attributed_conversions ,metrics.current_model_attributed_conversions_value ,metrics.engagements ,metrics.gmail_forwards ,metrics.gmail_saves ,metrics.gmail_secondary_clicks ,metrics.impressions ,metrics.interactions ,metrics.interaction_event_types ,metrics.top_impression_percentage ,metrics.video_quartile_p100_rate ,metrics.video_quartile_p25_rate ,metrics.video_quartile_p50_rate ,metrics.video_quartile_p75_rate ,metrics.video_views ,metrics.view_through_conversions ,ad_group_ad.ad.video_ad.out_stream.description ,ad_group_ad.ad.gmail_ad.teaser.description ,ad_group_ad.ad.gmail_ad.marketing_image_description ,ad_group_ad.ad.app_engagement_ad.descriptions ,ad_group_ad.ad.local_ad.descriptions ,ad_group_ad.ad.responsive_display_ad.descriptions ,ad_group_ad.ad.video_responsive_ad.descriptions FROM ad_group_ad WHERE segments.date BETWEEN '\''2022-08-13'\'' AND '\''2022-09-14'\''",
"page_token": "",
"return_total_results_count" : true
}'
response(request_id=VQq1JW_-7eAlLF4Zv-AH9w)
{
"fieldMask": "segments.adNetworkType,segments.date,segments.device,customer.id,customer.descriptiveName,campaign.id,campaign.name,campaign.labels,adGroup.name,adGroup.labels,adGroupAd.labels,adGroupAd.adGroup,adGroupAd.ad.id,adGroupAd.ad.name,adGroupAd.adStrength,adGroupAd.ad.type,adGroupAd.ad.finalMobileUrls,adGroupAd.ad.finalUrls,adGroupAd.ad.finalUrlSuffix,adGroupAd.ad.trackingUrlTemplate,adGroupAd.ad.urlCustomParameters,adGroupAd.ad.legacyResponsiveDisplayAd.description,adGroupAd.ad.expandedTextAd.description,adGroupAd.ad.textAd.description1,adGroupAd.ad.callAd.description1,adGroupAd.ad.textAd.description2,adGroupAd.ad.callAd.description2,adGroupAd.ad.devicePreference,adGroupAd.ad.displayUrl,adGroupAd.ad.expandedDynamicSearchAd.description,adGroupAd.ad.expandedDynamicSearchAd.description2,adGroupAd.ad.expandedTextAd.description2,adGroupAd.ad.expandedTextAd.headlinePart3,adGroupAd.ad.textAd.headline,adGroupAd.ad.expandedTextAd.headlinePart1,adGroupAd.ad.expandedTextAd.headlinePart2,adGroupAd.ad.imageAd.imageUrl,adGroupAd.ad.imageAd.pixelHeight,adGroupAd.ad.imageAd.pixelWidth,adGroupAd.ad.imageAd.mimeType,adGroupAd.ad.imageAd.name,adGroupAd.ad.legacyResponsiveDisplayAd.longHeadline,adGroupAd.ad.responsiveDisplayAd.youtubeVideos,adGroupAd.ad.expandedTextAd.path1,adGroupAd.ad.expandedTextAd.path2,adGroupAd.ad.responsiveSearchAd.descriptions,adGroupAd.ad.responsiveSearchAd.headlines,adGroupAd.ad.responsiveSearchAd.path1,adGroupAd.ad.responsiveSearchAd.path2,adGroupAd.ad.legacyResponsiveDisplayAd.shortHeadline,adGroupAd.ad.appAd.descriptions,adGroupAd.ad.appAd.headlines,adGroupAd.ad.appAd.html5MediaBundles,adGroupAd.ad.appAd.images,adGroupAd.ad.appAd.mandatoryAdText,adGroupAd.ad.appAd.youtubeVideos,adGroupAd.ad.videoAd.inFeed.description1,adGroupAd.ad.videoAd.inFeed.description2,metrics.absoluteTopImpressionPercentage,metrics.activeViewImpressions,metrics.activeViewMeasurableCostMicros,metrics.activeViewMeasurableImpressions,metrics.allConversions,metrics.allConversionsValue,metrics.clicks,metrics.conversions,metrics.conversionsValue,metrics.costMicros,metrics.crossDeviceConversions,metrics.currentModelAttributedConversions,metrics.currentModelAttributedConversionsValue,metrics.engagements,metrics.gmailForwards,metrics.gmailSaves,metrics.gmailSecondaryClicks,metrics.impressions,metrics.interactions,metrics.interactionEventTypes,metrics.topImpressionPercentage,metrics.videoQuartileP100Rate,metrics.videoQuartileP25Rate,metrics.videoQuartileP50Rate,metrics.videoQuartileP75Rate,metrics.videoViews,metrics.viewThroughConversions,adGroupAd.ad.videoAd.outStream.description,adGroupAd.ad.gmailAd.teaser.description,adGroupAd.ad.gmailAd.marketingImageDescription,adGroupAd.ad.appEngagementAd.descriptions,adGroupAd.ad.localAd.descriptions,adGroupAd.ad.responsiveDisplayAd.descriptions,adGroupAd.ad.videoResponsiveAd.descriptions"
}
Could you give me reason for this problem?
Thanks!
Google Ads API Forum Advisor
Hi Kyotsu,
With regards to your concern about this, "We want to ask about data response of account ID 4061742590 return empty data when we call API for these list of report data type" I understand that these account IDs are not returned (4061742590) data. Upon checking, the reason why these are not being returned by the API is because it belongs to campaigns whose sub-types are not supported. However, your account has supported campaign sub-types but these are not returned in the API response as it encounters this concept, zero metrics rows are always excluded when segmenting a report, because it did not accumulate any metrics.
I've tried removing all the metrics on your query and the data returned upon doing this. Please see the query that I used below:
"SELECT
segments.ad_network_type,
segments.device,
customer.descriptive_name,
campaign.labels,
ad_group.labels,
ad_group_ad.labels,
ad_group_ad.ad_group,
ad_group_ad.ad.id,
ad_group_ad.ad.name,
ad_group_ad.ad_strength,
ad_group_ad.ad.type,
ad_group_ad.ad.final_mobile_urls,
ad_group_ad.ad.final_urls,
ad_group_ad.ad.final_url_suffix,
ad_group_ad.ad.tracking_url_template,
ad_group_ad.ad.url_custom_parameters,
ad_group_ad.ad.legacy_responsive_display_ad.description,
ad_group_ad.ad.expanded_text_ad.description,
ad_group_ad.ad.text_ad.description1,
ad_group_ad.ad.call_ad.description1,
ad_group_ad.ad.text_ad.description2,
ad_group_ad.ad.call_ad.description2,
ad_group_ad.ad.device_preference,
ad_group_ad.ad.display_url,
ad_group_ad.ad.expanded_dynamic_search_ad.description,
ad_group_ad.ad.expanded_dynamic_search_ad.description2,
ad_group_ad.ad.expanded_text_ad.description2,
ad_group_ad.ad.expanded_text_ad.headline_part3,
ad_group_ad.ad.text_ad.headline,
ad_group_ad.ad.expanded_text_ad.headline_part1,
ad_group_ad.ad.expanded_text_ad.headline_part2,
ad_group_ad.ad.image_ad.image_url,
ad_group_ad.ad.image_ad.pixel_height,
ad_group_ad.ad.image_ad.pixel_width,
ad_group_ad.ad.image_ad.mime_type,
ad_group_ad.ad.legacy_responsive_display_ad.long_headline,
ad_group_ad.ad.responsive_display_ad.youtube_videos,
ad_group_ad.ad.expanded_text_ad.path1,
ad_group_ad.ad.expanded_text_ad.path2,
ad_group_ad.ad.responsive_search_ad.descriptions,
ad_group_ad.ad.responsive_search_ad.headlines,
ad_group_ad.ad.responsive_search_ad.path1,
ad_group_ad.ad.responsive_search_ad.path2,
ad_group_ad.ad.legacy_responsive_display_ad.short_headline,
ad_group_ad.ad.app_ad.descriptions,
ad_group_ad.ad.app_ad.headlines,
ad_group_ad.ad.app_ad.html5_media_bundles,
ad_group_ad.ad.app_ad.images,
ad_group_ad.ad.app_ad.mandatory_ad_text,
ad_group_ad.ad.app_ad.youtube_videos,
ad_group_ad.ad.video_ad.in_feed.description1,
ad_group_ad.ad.video_ad.in_feed.description2,
ad_group_ad.ad.video_ad.out_stream.description,
ad_group_ad.ad.gmail_ad.teaser.description,
ad_group_ad.ad.gmail_ad.marketing_image_description,
ad_group_ad.ad.app_engagement_ad.descriptions,
ad_group_ad.ad.local_ad.descriptions,
ad_group_ad.ad.responsive_display_ad.descriptions,
ad_group_ad.ad.video_responsive_ad.descriptions,
segments.date
FROM ad_group_ad
WHERE
segments.date BETWEEN '2022-08-13' AND '2022-09-14'"
Let me know if this query works on your end.
Regards,
|
||||||
ref:_00D1U1174p._5004Q2eOkHz:ref