I guess I can give my use case. We have tens of thousands of ads on your platform. Recently, several hundred were taken offline. I want to do an analysis into these, but I can't find an elegant way to isolate them programmatically.
I guess one way would be to query for the number of impressions every ad got on every single day we've had an account in Google Ads, then I can filter those down to only records where impressions is greater than 1, and finally use the existence of a record as evidence that the ad was active on any given day in the datasets index. That's a very heavy process though. I'll be working with tens of millions of rows of data (a row per ad per day). On Wednesday, June 7, 2023 at 7:29:03 AM UTC-7 Chad Wood wrote: > Hi, I dont have a screenshot of the data in the UI. I'm just wondering if > it's possible to utilize any metric / dimension for the purpose. Right now, > I don't see any way to differentiate between ads that haven't been served > in 10 years versus ads there were served 2 days ago. > > I checked, and it looks like the answer is no. > > On Tuesday, June 6, 2023 at 1:56:42 PM UTC-7 Google Ads API Forum Advisor > wrote: > >> Hi Chad, >> >> Thanks for reaching out to the Google Ads API Team. I hope you are doing >> well today. >> >> With regards to your 1st concern from your 1st email, thank you for >> confirming that the issue has been resolved on your end. We highly >> appreciate your shared information. >> >> Moving forward to your another email that concerns *“last serve date, >> last impression date and historic ad states”, *could you please provide >> us with Google Ads UI uncropped screenshot? For us to provide accurate >> information and recommendations. >> >> *Please note that Google Ads API mirrors the Google Ads UI. Meaning by >> using the Google Ads API, you can get and manage the data that you are >> seeing in the UI.* >> >> On the other hand, if this is related to the same report type, you may >> use the *ad_group_ad reporting* to check on you end the available >> resources, fields, segments, and metrics ( >> https://developers.google.com/google-ads/api/fields/v13/ad_group_ad_query_builder >> ). >> >> Have a great day. >> >> 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/c77cf976-214a-47e9-9006-6741b797f2c0n%40googlegroups.com.
