Hello, I've made some progress since the last email. Feel free to disregard it and I'll just update the thread.I've moved the questions still in need of help to the bottom of this email. For reference, I was able to get the data I wanted with the following query (extra stuff in here too):
SELECT ad_group_ad.ad.id, ad_group_ad.ad.name, ad_group_ad.ad_group, ad_group_ad.status, ad_group_ad.policy_summary.review_status, ad_group_ad.policy_summary.approval_status, ad_group_ad.policy_summary.policy_topic_entries, ad_group.id, ad_group.name, ad_group.campaign, ad_group.status, campaign.id, campaign.name, campaign.status, campaign.serving_status, campaign.primary_status, campaign.primary_status_reasons FROM ad_group_ad One thing I didn't see that would be nice is something like "last served date" or "last impression date" at the ad level, to get a sense for when the ad was last used. Is there another way to figure out when an ad was last used? Also is there any way to check what previous states of an ad were, at a given time? I'm interested in a time series analysis of statuses at the ad level. Thanks! On Friday, June 2, 2023 at 9:41:47 AM UTC-7 Chad Wood wrote: > Hello, hope all is well > > I would like to reproduce the following report with the API (screenshot at > bottom). > Disregarding the dates, how can I structure my query to receive the > 0. `Ad ID`, > 1. `Approval Reasons`, > 2. `Ad State`, and > 3. `Ad Status` ? > > Second, is there any way to get the historic states/statuses/reasons of > the ads? If an ad is removed today, can I see what its status was > yesterday? Lastly, is there a maximum amount of time before I can no longer > see historic states of ads? > > Thanks! > > [image: Report-editor-Google-Ads.png] > > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/9196e6a3-bae9-4b40-869b-b05d17120e7an%40googlegroups.com.
