Hi Google ads api team,
Thank you so much for your answer,
I follow your guidline, I don’t include the below filter in my query, then
my API response gives 2 results, one for the original Ad and another for
the AD_VARIATIONS as modified Ad.
*AND ad_group_ad.ad.system_managed_resource_source = 'AD_VARIATIONS'*
========================================
*1. My query as below run with Google ads api V10*
========================================
⇓
SELECT
ad_group_ad.action_items,
ad_group_ad.ad.added_by_google_ads,
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.app_engagement_ad.descriptions,
ad_group_ad.ad.app_engagement_ad.headlines,
ad_group_ad.ad.app_engagement_ad.images,
ad_group_ad.ad.app_engagement_ad.videos,
ad_group_ad.ad.app_pre_registration_ad.descriptions,
ad_group_ad.ad.app_pre_registration_ad.headlines,
ad_group_ad.ad.app_pre_registration_ad.images,
ad_group_ad.ad.app_pre_registration_ad.youtube_videos,
ad_group_ad.ad.call_ad.business_name,
ad_group_ad.ad.call_ad.call_tracked,
ad_group_ad.ad.call_ad.conversion_action,
ad_group_ad.ad.call_ad.conversion_reporting_state,
ad_group_ad.ad.call_ad.country_code,
ad_group_ad.ad.call_ad.description1,
ad_group_ad.ad.call_ad.description2,
ad_group_ad.ad.call_ad.disable_call_conversion,
ad_group_ad.ad.call_ad.headline1,
ad_group_ad.ad.call_ad.headline2,
ad_group_ad.ad.call_ad.path1,
ad_group_ad.ad.call_ad.path2,
ad_group_ad.ad.call_ad.phone_number,
ad_group_ad.ad.call_ad.phone_number_verification_url,
ad_group_ad.ad.device_preference,
ad_group_ad.ad.discovery_carousel_ad.business_name,
ad_group_ad.ad.discovery_carousel_ad.call_to_action_text,
ad_group_ad.ad.discovery_carousel_ad.carousel_cards,
ad_group_ad.ad.discovery_carousel_ad.description,
ad_group_ad.ad.discovery_carousel_ad.headline,
ad_group_ad.ad.discovery_carousel_ad.logo_image,
ad_group_ad.ad.discovery_multi_asset_ad.business_name,
ad_group_ad.ad.discovery_multi_asset_ad.call_to_action_text,
ad_group_ad.ad.discovery_multi_asset_ad.descriptions,
ad_group_ad.ad.discovery_multi_asset_ad.headlines,
ad_group_ad.ad.discovery_multi_asset_ad.lead_form_only,
ad_group_ad.ad.discovery_multi_asset_ad.logo_images,
ad_group_ad.ad.discovery_multi_asset_ad.marketing_images,
ad_group_ad.ad.discovery_multi_asset_ad.portrait_marketing_images,
ad_group_ad.ad.discovery_multi_asset_ad.square_marketing_images,
ad_group_ad.ad.display_upload_ad.display_upload_product_type,
ad_group_ad.ad.display_upload_ad.media_bundle,
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.description,
ad_group_ad.ad.expanded_text_ad.description2,
ad_group_ad.ad.expanded_text_ad.headline_part1,
ad_group_ad.ad.expanded_text_ad.headline_part2,
ad_group_ad.ad.expanded_text_ad.headline_part3,
ad_group_ad.ad.expanded_text_ad.path1,
ad_group_ad.ad.expanded_text_ad.path2,
ad_group_ad.ad.final_app_urls,
ad_group_ad.ad.final_mobile_urls,
ad_group_ad.ad.final_url_suffix,
ad_group_ad.ad.final_urls,
ad_group_ad.ad.gmail_ad.header_image,
ad_group_ad.ad.gmail_ad.marketing_image,
ad_group_ad.ad.gmail_ad.marketing_image_description,
ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text,
ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text_color,
ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.url_collection_id,
ad_group_ad.ad.gmail_ad.marketing_image_headline,
ad_group_ad.ad.gmail_ad.product_images,
ad_group_ad.ad.gmail_ad.product_videos,
ad_group_ad.ad.gmail_ad.teaser.business_name,
ad_group_ad.ad.gmail_ad.teaser.description,
ad_group_ad.ad.gmail_ad.teaser.headline,
ad_group_ad.ad.gmail_ad.teaser.logo_image,
ad_group_ad.ad.hotel_ad,
ad_group_ad.ad.id,
ad_group_ad.ad.image_ad.image_url,
ad_group_ad.ad.image_ad.mime_type,
ad_group_ad.ad.image_ad.name,
ad_group_ad.ad.image_ad.pixel_height,
ad_group_ad.ad.image_ad.pixel_width,
ad_group_ad.ad.image_ad.preview_image_url,
ad_group_ad.ad.image_ad.preview_pixel_height,
ad_group_ad.ad.image_ad.preview_pixel_width,
ad_group_ad.ad.legacy_app_install_ad,
ad_group_ad.ad.legacy_responsive_display_ad.accent_color,
ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color,
ad_group_ad.ad.legacy_responsive_display_ad.business_name,
ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text,
ad_group_ad.ad.legacy_responsive_display_ad.description,
ad_group_ad.ad.legacy_responsive_display_ad.format_setting,
ad_group_ad.ad.legacy_responsive_display_ad.logo_image,
ad_group_ad.ad.legacy_responsive_display_ad.long_headline,
ad_group_ad.ad.legacy_responsive_display_ad.main_color,
ad_group_ad.ad.legacy_responsive_display_ad.marketing_image,
ad_group_ad.ad.legacy_responsive_display_ad.price_prefix,
ad_group_ad.ad.legacy_responsive_display_ad.promo_text,
ad_group_ad.ad.legacy_responsive_display_ad.short_headline,
ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image,
ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image,
ad_group_ad.ad.local_ad.call_to_actions,
ad_group_ad.ad.local_ad.descriptions,
ad_group_ad.ad.local_ad.headlines,
ad_group_ad.ad.local_ad.logo_images,
ad_group_ad.ad.local_ad.marketing_images,
ad_group_ad.ad.local_ad.path1,
ad_group_ad.ad.local_ad.path2,
ad_group_ad.ad.local_ad.videos,
ad_group_ad.ad.name,
ad_group_ad.ad.resource_name,
ad_group_ad.ad.responsive_display_ad.accent_color,
ad_group_ad.ad.responsive_display_ad.allow_flexible_color,
ad_group_ad.ad.responsive_display_ad.business_name,
ad_group_ad.ad.responsive_display_ad.call_to_action_text,
ad_group_ad.ad.responsive_display_ad.control_spec.enable_asset_enhancements,
ad_group_ad.ad.responsive_display_ad.control_spec.enable_autogen_video,
ad_group_ad.ad.responsive_display_ad.descriptions,
ad_group_ad.ad.responsive_display_ad.format_setting,
ad_group_ad.ad.responsive_display_ad.headlines,
ad_group_ad.ad.responsive_display_ad.logo_images,
ad_group_ad.ad.responsive_display_ad.long_headline,
ad_group_ad.ad.responsive_display_ad.main_color,
ad_group_ad.ad.responsive_display_ad.marketing_images,
ad_group_ad.ad.responsive_display_ad.price_prefix,
ad_group_ad.ad.responsive_display_ad.promo_text,
ad_group_ad.ad.responsive_display_ad.square_logo_images,
ad_group_ad.ad.responsive_display_ad.square_marketing_images,
ad_group_ad.ad.responsive_display_ad.youtube_videos,
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.shopping_comparison_listing_ad.headline,
ad_group_ad.ad.shopping_product_ad,
ad_group_ad.ad.shopping_smart_ad,
ad_group_ad.ad.smart_campaign_ad.descriptions,
ad_group_ad.ad.smart_campaign_ad.headlines,
ad_group_ad.ad.system_managed_resource_source,
ad_group_ad.ad.text_ad.description1,
ad_group_ad.ad.text_ad.description2,
ad_group_ad.ad.text_ad.headline,
ad_group_ad.ad.tracking_url_template,
ad_group_ad.ad.type,
ad_group_ad.ad.url_collections,
ad_group_ad.ad.url_custom_parameters,
ad_group_ad.ad.video_ad.bumper.companion_banner.asset,
ad_group_ad.ad.video_ad.in_feed.description1,
ad_group_ad.ad.video_ad.in_feed.description2,
ad_group_ad.ad.video_ad.in_feed.headline,
ad_group_ad.ad.video_ad.in_feed.thumbnail,
ad_group_ad.ad.video_ad.in_stream.action_button_label,
ad_group_ad.ad.video_ad.in_stream.action_headline,
ad_group_ad.ad.video_ad.in_stream.companion_banner.asset,
ad_group_ad.ad.video_ad.non_skippable.action_button_label,
ad_group_ad.ad.video_ad.non_skippable.action_headline,
ad_group_ad.ad.video_ad.non_skippable.companion_banner.asset,
ad_group_ad.ad.video_ad.out_stream.description,
ad_group_ad.ad.video_ad.out_stream.headline,
ad_group_ad.ad.video_ad.video.asset,
ad_group_ad.ad.video_responsive_ad.breadcrumb1,
ad_group_ad.ad.video_responsive_ad.breadcrumb2,
ad_group_ad.ad.video_responsive_ad.call_to_actions,
ad_group_ad.ad.video_responsive_ad.companion_banners,
ad_group_ad.ad.video_responsive_ad.descriptions,
ad_group_ad.ad.video_responsive_ad.headlines,
ad_group_ad.ad.video_responsive_ad.long_headlines,
ad_group_ad.ad.video_responsive_ad.videos,
ad_group_ad.ad_group,
ad_group_ad.ad_strength,
ad_group_ad.labels,
ad_group_ad.policy_summary.approval_status,
ad_group_ad.policy_summary.policy_topic_entries,
ad_group_ad.policy_summary.review_status,
ad_group_ad.resource_name,
ad_group_ad.status
FROM
ad_group_ad
WHERE
ad_group_ad.status IN ('ENABLED', 'PAUSED')
AND ad_group.id IN (136661421074)
*==========================*
*2. Output after I run query above:*
*==========================*
*⇓*
*=============*
*2.1 Original ads*
*=============*
*⇓*
ad_group_ad {
resource_name: "customers/xxx/adGroupAds/136661421074~583446390893"
status: PAUSED
ad {
type: RESPONSIVE_SEARCH_AD
responsive_search_ad {
headlines {
text: "12"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
headlines {
text: "34"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
headlines {
text: "56"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
headlines {
text: "78"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
descriptions {
text: "90"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
descriptions {
text: "456"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
}
resource_name: "customers/xxx/ads/583446390893"
id: 583446390893
final_urls: "https://www.facebook.com/";
added_by_google_ads: false
}
policy_summary {
review_status: REVIEW_IN_PROGRESS
approval_status: UNKNOWN
}
ad_strength: PENDING
ad_group: "customers/xxx/adGroups/136661421074"
}
*=============================*
*2.2 AD_VARIATIONS as modified Ad*
*=============================*
*⇓*
ad_group_ad {
resource_name: "customers/xxx/adGroupAds/136661421074~609081688452"
status: PAUSED
ad {
type: RESPONSIVE_SEARCH_AD
responsive_search_ad {
headlines {
text: "12"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
headlines {
text: "34"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
headlines {
text: "56"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
headlines {
text: "78"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
headlines {
text: "varitant"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
descriptions {
text: "90"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
descriptions {
text: "456"
asset_performance_label: PENDING
policy_summary_info {
review_status: REVIEW_IN_PROGRESS
}
}
}
system_managed_resource_source: AD_VARIATIONS
resource_name: "customers/xxx/ads/609081688452"
id: 609081688452
final_urls: "https://www.facebook.com/";
added_by_google_ads: false
}
policy_summary {
review_status: REVIEW_IN_PROGRESS
approval_status: UNKNOWN
}
ad_strength: PENDING
ad_group: "customers/xxx/adGroups/136661421074"
}
* Note: xxx is my Google ads id, so I hide it.
======================================================================================
=> So I've just wonder, *How can I find relationship between **Original ads*
*(Section 2.1 above) and * *AD_VARIATIONS as modified Ad* * (Section 2.2
above) *? Please support me.
** P/S: I guess (maybe wrong) to find out the relationship between Orginal
ads and **AD_VARIATIONS**: *
AD_VARIATIONS have 1 field 'original_ad_id' to know that this variations
ads was created from 1 original ad that have original_ad.id
= AD_VARIATIONS.original_ad_id
but with output ads data above (Section 2.1 & section 2.2), I can't find
out this relationship.
Thank you so much
On Friday, July 15, 2022 at 11:16:08 PM UTC+7 adsapi wrote:
> Hi,
>
> Thanks for getting back to us.
>
> Kindly note that when you don’t include the below filter in your query,
> then your API response gives 2 results, one for the original Ad and another
> for the AD_VARIATIONS as modified Ad. That said, you may consider removing
> the below filter from your GAQL to get both Original Ad ID and Modified Ad
> ID in your response.
>
> *AND ad_group_ad.ad.system_managed_resource_source = 'AD_VARIATIONS'*
>
> You may use updated GAQL below:
>
>
>
> SELECT
> ad_group.id,
> ad_group_ad.ad.id,
> ad_group_ad.ad.name,
> ad_group_ad.ad.type,
> ad_group_ad.status,
> ad_group_ad.ad.device_preference,
> ad_group_ad.ad.final_app_urls,
> 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.display_url,
> ad_group_ad.ad.text_ad.headline,
> ad_group_ad.ad.text_ad.description2,
> ad_group_ad.ad.text_ad.description1,
> ad_group_ad.ad.expanded_text_ad.headline_part1,
> ad_group_ad.ad.expanded_text_ad.headline_part2,
> ad_group_ad.ad.expanded_text_ad.headline_part3,
> ad_group_ad.ad.expanded_text_ad.description,
> ad_group_ad.ad.expanded_text_ad.description2,
> ad_group_ad.ad.expanded_text_ad.path1,
> ad_group_ad.ad.expanded_text_ad.path2,
> ad_group_ad.ad.image_ad.name,
> ad_group_ad.ad.image_ad.image_url,
> ad_group_ad.ad.responsive_display_ad.accent_color,
> ad_group_ad.ad.responsive_display_ad.allow_flexible_color,
> ad_group_ad.ad.responsive_display_ad.business_name,
> ad_group_ad.ad.responsive_display_ad.call_to_action_text,
> ad_group_ad.ad.responsive_display_ad.control_spec.enable_asset_enhancements,
> ad_group_ad.ad.responsive_display_ad.control_spec.enable_autogen_video,
> ad_group_ad.ad.responsive_display_ad.descriptions,
> ad_group_ad.ad.responsive_display_ad.format_setting,
> ad_group_ad.ad.responsive_display_ad.headlines,
> ad_group_ad.ad.responsive_display_ad.logo_images,
> ad_group_ad.ad.responsive_display_ad.long_headline,
> ad_group_ad.ad.responsive_display_ad.main_color,
> ad_group_ad.ad.responsive_display_ad.marketing_images,
> ad_group_ad.ad.responsive_display_ad.price_prefix,
> ad_group_ad.ad.responsive_display_ad.promo_text,
> ad_group_ad.ad.responsive_display_ad.square_logo_images,
> ad_group_ad.ad.responsive_display_ad.square_marketing_images,
> ad_group_ad.ad.responsive_display_ad.youtube_videos,
> 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.call_ad.country_code,
> ad_group_ad.ad.call_ad.phone_number,
> ad_group_ad.ad.call_ad.business_name,
> ad_group_ad.ad.call_ad.description1,
> ad_group_ad.ad.call_ad.description2,
> ad_group_ad.ad.call_ad.phone_number_verification_url,
> ad_group_ad.ad.system_managed_resource_source
> FROM
> ad_group_ad
> WHERE
> ad_group_ad.status IN ('ENABLED', 'PAUSED')
> AND ad_group.id IN (136661421074)
>
> Let me know if this helps.
>
> Regards,
> [image: Google Logo]
> Yasar
> Google Ads API Team
>
>
> ref:_00D1U1174p._5004Q2cVXpX:ref
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/bbc7781e-a183-41c8-a67e-a20fbd14e861n%40googlegroups.com.
