I am trying to fetch info about some ads using the
GoogleAdsService from the
ad_group_ad table, but all ads returned for some of the clients don't really have any data other than the ID, name and resourceName, everything else is returned as NULL or 0, even the type is returned as UNKNOWN
The query used:
$query = "SELECT ad_group_ad.ad.type,
campaign.id, ad_group_ad.ad.gmail_ad.teaser.logo_image,
ad_group_ad.ad.gmail_ad.teaser.headline, ad_group_ad.ad.gmail_ad.teaser.description,
ad_group_ad.ad.gmail_ad.teaser.business_name, ad_group_ad.ad.gmail_ad.product_videos,
ad_group_ad.ad.gmail_ad.product_images, ad_group_ad.ad.gmail_ad.marketing_image_headline,
ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.url_collection_id,
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.text,
ad_group_ad.ad.gmail_ad.marketing_image_description, ad_group_ad.ad.gmail_ad.marketing_image,
ad_group_ad.ad.gmail_ad.header_image,
ad_group_ad.ad.id, ad_group_ad.ad.image_ad.image_url, ad_group_ad.ad.image_ad.mime_type,
Some of the ads I am trying to fetch data for are the following:
ID: 388075524635
ResourceName: customers/9118840476/ads/388075524635
Type: UNKNOWN
*****************************************************************
ID: 388075524638
ResourceName: customers/9118840476/ads/388075524638
Type: UNKNOWN
*****************************************************************
ID: 474232013660
ResourceName: customers/9118840476/ads/474232013660
Type: UNKNOWN
*****************************************************************