We're getting google text ads from the api this way - query below. But what we really need is the ad status ad_group_ad.ad.status, but we're not able to find that field. Is that available at the ad level?
SELECT
ad_group_ad.status,
ad_group_ad.ad.id,
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.display_url,
ad_group.id,
metrics.clicks,
metrics.impressions,
metrics.average_cpc,
metrics.conversions,
metrics.cost_micros,
metrics.ctr,
metrics.cross_device_conversions,
ad_group_ad.ad.responsive_search_ad.headlines,
ad_group_ad.ad.responsive_search_ad.descriptions,
ad_group_ad.ad.responsive_search_ad.path1,
ad_group_ad.ad.responsive_search_ad.path2
FROM ad_group_ad