Hey, Thanks to both Oliver and the Google Team for this. I see the query you've provided shifts the role of filtration onto Google, likely reducing the amount of data significantly. Nice solution there :)
One follow up question. I find myself confused by all the different statuses between ads, adgroups, and campaigns. Here's what I'm working with: ad_group_ad.policy_summary.approval_status <https://developers.google.com/google-ads/api/fields/v13/ad_group_ad#ad_group_ad.policy_summary.approval_status> ad_group_ad.policy_summary.review_status <https://developers.google.com/google-ads/api/fields/v13/ad_group_ad#ad_group_ad.policy_summary.review_status> ad_group_ad.status <https://developers.google.com/google-ads/api/fields/v13/ad_group_ad#ad_group_ad.status> ad_group.status <https://developers.google.com/google-ads/api/fields/v13/ad_group#ad_group.status> campaign.primary_status <https://developers.google.com/google-ads/api/fields/v13/campaign#campaign.primary_status> campaign.serving_status <https://developers.google.com/google-ads/api/fields/v13/campaign#campaign.serving_status> campaign.status <https://developers.google.com/google-ads/api/fields/v13/campaign#campaign.status> I can't seem to figure out how to use these statuses together, which statuses are needed and which aren't. My team wants a report that provides the following information (daily): # of new ads, # of ads under review, # of ads reviewed but not approved or disapproved yet, # of ads approved but paused, # of ads approved and serving, # of ads ended, # of ads disapproved, # of removed ads I can handle tracking the data on my end in a database. Can you help me decipher those statuses so that I can count the number of ads in each stage of the ad lifecycle? On Tuesday, June 13, 2023 at 1:20:00 AM UTC-7 Google Ads API Forum Advisor wrote: > Hello Chad, > > Thanks for getting back to us. > > Please note that the API and UI mimic each other’s behavior, if you are > unable to find the data in the UI, it would not be available in the API. As > Oliver said “The API does not give any historical metadata about statuses. > The only way to achieve what you want is exactly what you described in your > last message.” With regards to what you described in your previous message > on how you’d go about obtaining these data, please refer to this sample > GAQL query below. > > > SELECT > segments.date, > ad_group_ad.ad.name, > ad_group_ad.ad.id, > metrics.impressions > FROM ad_group_ad > WHERE > segments.date BETWEEN 'YYYYMMDD' AND 'YYYYMMDD' > AND *metrics.impressions > 0 * > > The data queried would be segmented by each day and only showing data for > impressions that are more than 0. > > I hope this information helps you. > This message is in relation to case "ref:_00D1U1174p._5004Q2lwDrZ:ref" > > Thanks, > > [image: Google Logo] Google Ads API Team > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/819a535f-4c6e-4710-a0b3-608907d91483n%40googlegroups.com.