Hi, according to the Google Ads API guides, I can get default Ads overview screen in the UI by the query statement below:
SELECT 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.final_urls,
ad_group_ad.ad.expanded_text_ad.description,
ad_group_ad.ad.expanded_text_ad.description2,
campaign.name,
ad_group.name,
ad_group_ad.policy_summary.approval_status,
ad_group_ad.ad.type,
metrics.clicks,
metrics.impressions,
metrics.ctr,
metrics.average_cpc,
metrics.cost_micros
FROM ad_group_ad
WHERE segments.date DURING LAST_7_DAYS
AND ad_group_ad.status != 'REMOVED'
I think this field [ad_group_ad.policy_summary.approval_status] corresponds to the status in the UI.
Below is the possible values of this field [ad_group_ad.policy_summary.approval_status]:
APPROVED
APPROVED_LIMITED
AREA_OF_INTEREST_ONLY
DISAPPROVED
UNKNOWN
UNSPECIFIED
The values of status in the UI are as follows:
Eligible
Eligible(Limited)
Not eligible
Paused
Removed
How do we map these values of [ad_group_ad.policy_summary.approval_status] by invoking Google ADS api to the value of status on the page?