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 <https://developers.google.com/google-ads/api/docs/migration/mapping> 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 -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com 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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ac0723d3-496b-48ab-a2f9-fc74a02e5f61n%40googlegroups.com.
