Hello, just following back up. I'll summarize my questions below: 1. Is there any way to figure out when an ad was last used?(*last serve date*, *last impression date*, *...*?) 2. Is there any way to check what previous states of an ad were, at a given time? (historic ad states?)
On Friday, June 2, 2023 at 1:54:06 PM UTC-7 Chad Wood wrote: > 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/3c64489d-093d-4f5e-bbff-592e01153134n%40googlegroups.com.
