I have a query to download information for Expanded Text Ads, which used to work fine until two days ago. Since then, I get the following error, telling me that "Enum field only accepts integer or enum value name".
I investigated the issue and found that for some ads I can download the information without problem, and for others not - but I couldnt find a common pattern.
Could you help me, to see if I need to update the query, or to pre-filter some values that might cause the error?
$query =
"SELECT "
. "customer.descriptive_name, "
. "customer.currency_code, "
. "customer.time_zone, "
. "campaign.campaign_budget, "
. "campaign.start_date, "
. "campaign.end_date, "
. "campaign.serving_status, "
. "campaign.status, "
. "campaign.url_custom_parameters, "
. "ad_group.status, "
. "ad_group.url_custom_parameters, "
. "ad_group_ad.ad.type, "
. "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.final_urls, "
. "ad_group_ad.ad.url_custom_parameters, "
. "ad_group_ad.policy_summary, "
. "ad_group_ad.status, "
. "metrics.impressions, "
. "metrics.clicks, "
. "metrics.cost_micros, "
. "metrics.all_conversions, "
. "metrics.all_conversions_value, "
. "metrics.average_position, "
. "metrics.absolute_top_impression_percentage, "
. "metrics.top_impression_percentage, "
. "metrics.conversions, "
. "metrics.conversions_value "
. "FROM ad_group_ad "
. "WHERE segments.date DURING LAST_7_DAYS"
. " AND ad_group_ad.status = 'ENABLED'"
. " AND ad_group_ad.ad.type = 'EXPANDED_TEXT_AD'"
. " AND campaign.status = 'ENABLED'"
;