RestApi Ad Performance Missing data

[DWH Api]

Hi,

we are currently migrating from Google Adwords to Google Ads.
We assumed the GoogleAds-data and GoogleAdwords-data should match. This is not the case.

Example:
We replaced the AdPerformanceReport with the resource ad_group_ad.
There are different number of records per customer and day. Furthermore we do not get any data for some customers, e.g. 1650614931.
There are not filters set in the source except for dates.
Could you please help in this case?

We send the following query
query=SELECT ad_group_ad.ad.gmail_ad.marketing_image,customer.descriptive_name,metrics.value_per_conversion,metrics.gmail_saves,segments.quarter,metrics.clicks,metrics.active_view_cpm,ad_group_ad.ad.text_ad.headline,metrics.active_view_viewability,ad_group_ad.ad.system_managed_resource_source,metrics.interaction_rate,metrics.cost_per_conversion,campaign.name,ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image,ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text_color,ad_group_ad.ad.legacy_responsive_display_ad.short_headline,metrics.average_cpm,metrics.active_view_measurability,metrics.all_conversions,metrics.active_view_impressions,ad_group_ad.ad.legacy_responsive_display_ad.marketing_image,ad_group_ad.ad.legacy_responsive_display_ad.description,metrics.active_view_measurable_impressions,ad_group_ad.ad.expanded_text_ad.headline_part2,metrics.gmail_forwards,ad_group_ad.ad.added_by_google_ads,ad_group_ad.ad.display_url,ad_group_ad.ad.legacy_responsive_display_ad.logo_image,ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image,ad_group_ad.ad.legacy_responsive_display_ad.accent_color,ad_group_ad.ad.legacy_responsive_display_ad.format_setting,metrics.conversions,ad_group_ad.ad.gmail_ad.header_image,ad_group_ad.ad.image_ad.image_url,metrics.impressions,ad_group.status,campaign.base_campaign,ad_group_ad.ad.image_ad.name,ad_group_ad.ad.id,ad_group_ad.ad.legacy_responsive_display_ad.price_prefix,ad_group.base_ad_group,ad_group_ad.ad.final_url_suffix,metrics.all_conversions_from_interactions_rate,ad_group_ad.ad.final_mobile_urls,customer.time_zone,ad_group_ad.ad.gmail_ad.teaser.description,ad_group_ad.ad.gmail_ad.teaser.logo_image,metrics.active_view_measurable_cost_micros,metrics.value_per_current_model_attributed_conversion,metrics.cost_per_all_conversions,ad_group_ad.ad.legacy_responsive_display_ad.promo_text,ad_group_ad.ad.text_ad.description1,segments.ad_network_type,campaign.status,ad_group_ad.ad.device_preference,segments.week,ad_group_ad.ad.legacy_responsive_display_ad.long_headline,metrics.average_cost,ad_group_ad.ad.text_ad.description2,ad_group.id,ad_group_ad.ad.final_urls,customer.currency_code,ad_group_ad.ad.call_ad.phone_number,segments.year,ad_group_ad.ad.expanded_text_ad.path1,ad_group_ad.ad.expanded_text_ad.headline_part1,ad_group_ad.ad.type,ad_group_ad.ad.gmail_ad.teaser.business_name,metrics.current_model_attributed_conversions_value,ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text,ad_group_ad.policy_summary.review_status,metrics.active_view_ctr,metrics.cost_per_current_model_attributed_conversion,ad_group_ad.status,ad_group.name,metrics.conversions_from_interactions_rate,ad_group_ad.ad.legacy_responsive_display_ad.business_name,ad_group_ad.ad.gmail_ad.teaser.headline,metrics.current_model_attributed_conversions,ad_group_ad.ad.image_ad.pixel_height,segments.day_of_week,metrics.interactions,segments.device,ad_group_ad.ad.tracking_url_template,metrics.all_conversions_value,ad_group_ad.ad.url_custom_parameters,ad_group_ad.ad.legacy_responsive_display_ad.main_color,metrics.average_cpc,ad_group_ad.ad.image_ad.pixel_width,metrics.value_per_all_conversions,metrics.absolute_top_impression_percentage,ad_group_ad.policy_summary.approval_status,customer.id,ad_group_ad.policy_summary.policy_topic_entries,metrics.conversions_value,metrics.top_impression_percentage,metrics.ctr,segments.keyword.ad_group_criterion,campaign.id,ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color,ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text,segments.month,segments.date,ad_group_ad.ad.gmail_ad.marketing_image_headline,metrics.gmail_secondary_clicks,ad_group_ad.ad.expanded_text_ad.path2,metrics.cost_micros FROM ad_group_ad WHERE segments.date BETWEEN '2022-03-14' AND '2022-04-19'

Unfortunately, the result is empty.
fieldMask=adGroupAd.ad.gmailAd.marketingImage,customer.descriptiveName,metrics.valuePerConversion,metrics.gmailSaves,segments.quarter,metrics.clicks,metrics.activeViewCpm,adGroupAd.ad.textAd.headline,metrics.activeViewViewability,adGroupAd.ad.systemManagedResourceSource,metrics.interactionRate,metrics.costPerConversion,campaign.name,adGroupAd.ad.legacyResponsiveDisplayAd.squareLogoImage,adGroupAd.ad.gmailAd.marketingImageDisplayCallToAction.textColor,adGroupAd.ad.legacyResponsiveDisplayAd.shortHeadline,metrics.averageCpm,metrics.activeViewMeasurability,metrics.allConversions,metrics.activeViewImpressions,adGroupAd.ad.legacyResponsiveDisplayAd.marketingImage,adGroupAd.ad.legacyResponsiveDisplayAd.description,metrics.activeViewMeasurableImpressions,adGroupAd.ad.expandedTextAd.headlinePart2,metrics.gmailForwards,adGroupAd.ad.addedByGoogleAds,adGroupAd.ad.displayUrl,adGroupAd.ad.legacyResponsiveDisplayAd.logoImage,adGroupAd.ad.legacyResponsiveDisplayAd.squareMarketingImage,adGroupAd.ad.legacyResponsiveDisplayAd.accentColor,adGroupAd.ad.legacyResponsiveDisplayAd.formatSetting,metrics.conversions,adGroupAd.ad.gmailAd.headerImage,adGroupAd.ad.imageAd.imageUrl,metrics.impressions,adGroup.status,campaign.baseCampaign,adGroupAd.ad.imageAd.name,adGroupAd.ad.id,adGroupAd.ad.legacyResponsiveDisplayAd.pricePrefix,adGroup.baseAdGroup,adGroupAd.ad.finalUrlSuffix,metrics.allConversionsFromInteractionsRate,adGroupAd.ad.finalMobileUrls,customer.timeZone,adGroupAd.ad.gmailAd.teaser.description,adGroupAd.ad.gmailAd.teaser.logoImage,metrics.activeViewMeasurableCostMicros,metrics.valuePerCurrentModelAttributedConversion,metrics.costPerAllConversions,adGroupAd.ad.legacyResponsiveDisplayAd.promoText,adGroupAd.ad.textAd.description1,segments.adNetworkType,campaign.status,adGroupAd.ad.devicePreference,segments.week,adGroupAd.ad.legacyResponsiveDisplayAd.longHeadline,metrics.averageCost,adGroupAd.ad.textAd.description2,adGroup.id,adGroupAd.ad.finalUrls,customer.currencyCode,adGroupAd.ad.callAd.phoneNumber,segments.year,adGroupAd.ad.expandedTextAd.path1,adGroupAd.ad.expandedTextAd.headlinePart1,adGroupAd.ad.type,adGroupAd.ad.gmailAd.teaser.businessName,metrics.currentModelAttributedConversionsValue,adGroupAd.ad.legacyResponsiveDisplayAd.callToActionText,adGroupAd.policySummary.reviewStatus,metrics.activeViewCtr,metrics.costPerCurrentModelAttributedConversion,adGroupAd.status,adGroup.name,metrics.conversionsFromInteractionsRate,adGroupAd.ad.legacyResponsiveDisplayAd.businessName,adGroupAd.ad.gmailAd.teaser.headline,metrics.currentModelAttributedConversions,adGroupAd.ad.imageAd.pixelHeight,segments.dayOfWeek,metrics.interactions,segments.device,adGroupAd.ad.trackingUrlTemplate,metrics.allConversionsValue,adGroupAd.ad.urlCustomParameters,adGroupAd.ad.legacyResponsiveDisplayAd.mainColor,metrics.averageCpc,adGroupAd.ad.imageAd.pixelWidth,metrics.valuePerAllConversions,metrics.absoluteTopImpressionPercentage,adGroupAd.policySummary.approvalStatus,customer.id,adGroupAd.policySummary.policyTopicEntries,metrics.conversionsValue,metrics.topImpressionPercentage,metrics.ctr,segments.keyword.adGroupCriterion,campaign.id,adGroupAd.ad.legacyResponsiveDisplayAd.allowFlexibleColor,adGroupAd.ad.gmailAd.marketingImageDisplayCallToAction.text,segments.month,segments.date,adGroupAd.ad.gmailAd.marketingImageHeadline,metrics.gmailSecondaryClicks,adGroupAd.ad.expandedTextAd.path2,metrics.costMicros
 
We selected the fields based on Google's migration mapping for “Ad Performance”
Resource mappings  |  Google Ads API  |  Google Developers

If we now reduce the fields we get a result. E.g. we reduce to only “ad_group_ad” fields.
query=SELECT ad_group_ad.ad.gmail_ad.marketing_image,customer.descriptive_name,metrics.value_per_conversion,metrics.gmail_saves,metrics.clicks,metrics.active_view_cpm,ad_group_ad.ad.text_ad.headline,metrics.active_view_viewability,ad_group_ad.ad.system_managed_resource_source,metrics.interaction_rate,metrics.cost_per_conversion,campaign.name,ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image,ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text_color,ad_group_ad.ad.legacy_responsive_display_ad.short_headline,metrics.average_cpm,metrics.active_view_measurability,metrics.all_conversions,metrics.active_view_impressions,ad_group_ad.ad.legacy_responsive_display_ad.marketing_image,ad_group_ad.ad.legacy_responsive_display_ad.description,metrics.active_view_measurable_impressions,ad_group_ad.ad.expanded_text_ad.headline_part2,metrics.gmail_forwards,ad_group_ad.ad.added_by_google_ads,ad_group_ad.ad.display_url,ad_group_ad.ad.legacy_responsive_display_ad.logo_image,ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image,ad_group_ad.ad.legacy_responsive_display_ad.accent_color,ad_group_ad.ad.legacy_responsive_display_ad.format_setting,metrics.conversions,ad_group_ad.ad.gmail_ad.header_image,ad_group_ad.ad.image_ad.image_url,metrics.impressions,ad_group.status,campaign.base_campaign,ad_group_ad.ad.image_ad.name,ad_group_ad.ad.id,ad_group_ad.ad.legacy_responsive_display_ad.price_prefix,ad_group.base_ad_group,ad_group_ad.ad.final_url_suffix,metrics.all_conversions_from_interactions_rate,ad_group_ad.ad.final_mobile_urls,customer.time_zone,ad_group_ad.ad.gmail_ad.teaser.description,ad_group_ad.ad.gmail_ad.teaser.logo_image,metrics.active_view_measurable_cost_micros,metrics.value_per_current_model_attributed_conversion,metrics.cost_per_all_conversions,ad_group_ad.ad.legacy_responsive_display_ad.promo_text,ad_group_ad.ad.text_ad.description1,campaign.status,ad_group_ad.ad.device_preference,ad_group_ad.ad.legacy_responsive_display_ad.long_headline,metrics.average_cost,ad_group_ad.ad.text_ad.description2,ad_group.id,ad_group_ad.ad.final_urls,customer.currency_code,ad_group_ad.ad.call_ad.phone_number,ad_group_ad.ad.expanded_text_ad.path1,ad_group_ad.ad.expanded_text_ad.headline_part1,ad_group_ad.ad.type,ad_group_ad.ad.gmail_ad.teaser.business_name,metrics.current_model_attributed_conversions_value,ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text,ad_group_ad.policy_summary.review_status,metrics.active_view_ctr,metrics.cost_per_current_model_attributed_conversion,ad_group_ad.status,ad_group.name,metrics.conversions_from_interactions_rate,ad_group_ad.ad.legacy_responsive_display_ad.business_name,ad_group_ad.ad.gmail_ad.teaser.headline,metrics.current_model_attributed_conversions,ad_group_ad.ad.image_ad.pixel_height,metrics.interactions,ad_group_ad.ad.tracking_url_template,metrics.all_conversions_value,ad_group_ad.ad.url_custom_parameters,ad_group_ad.ad.legacy_responsive_display_ad.main_color,metrics.average_cpc,ad_group_ad.ad.image_ad.pixel_width,metrics.value_per_all_conversions,metrics.absolute_top_impression_percentage,ad_group_ad.policy_summary.approval_status,customer.id,ad_group_ad.policy_summary.policy_topic_entries,metrics.conversions_value,metrics.top_impression_percentage,metrics.ctr,campaign.id,ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color,ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text,ad_group_ad.ad.gmail_ad.marketing_image_headline,metrics.gmail_secondary_clicks,ad_group_ad.ad.expanded_text_ad.path2,metrics.cost_micros FROM ad_group_ad WHERE segments.date BETWEEN '2022-03-14' AND '2022-04-19'

The result is not empty anymore.
 
Are there dependencies between the fields that we are not aware of or why is this behavior?

Thank you.

Best Regards

Daniel Harder

[Luciano Gandini]

Hi there, 

we are having the same exact issue, we migrated to use this query for ads:
SELECT segments.date, campaign.id, campaign.name, ad_group.id, ad_group.name, segments.keyword.ad_group_criterion, ad_group_ad.ad.id, ad_group_ad.ad.type, 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.legacy_responsive_display_ad.description, ad_group_ad.ad.expanded_text_ad.description, ad_group_ad.ad.expanded_text_ad.path1, ad_group_ad.ad.expanded_text_ad.path2, ad_group_ad.ad.text_ad.description1, ad_group_ad.ad.text_ad.description2, ad_group_ad.ad.display_url, ad_group_ad.ad.image_ad.name, ad_group_ad.ad.image_ad.image_url, segments.ad_network_type, segments.device, metrics.impressions, metrics.clicks, metrics.conversions, metrics.conversions_value, metrics.cost_micros, ad_group_ad.ad.final_urls, ad_group_ad.ad.tracking_url_template, ad_group_ad.ad.url_custom_parameters, metrics.cross_device_conversions, metrics.all_conversions, metrics.all_conversions_value, ad_group_ad.ad.expanded_text_ad.description2, ad_group_ad.ad.expanded_text_ad.headline_part3
FROM ad_group_ad WHERE segments.date >= '2021-01-01' AND segments.date <= '2021-01-01'

Most other reports have similar data, but this one for one of our customers have only 1805 rows vs 3841 from adwords. (Same happens for other dates and accounts).

One particular thing i noticed for this scenario is that on the new api we are only getting Expanded text ads, while on adwords we get all these types: Expanded dynamic search ad, Expanded text ad,  Responsive display ad, Shopping ad, Image ad  and Showcase ad.

This is particular for account 6215235580.

Thanks.

Luciano Gandini.