I think I found the issue. Sometimes, I use the Google Ads Report Editor (from the UI) as a sandbox zone for building proof of concept reports. Then I will download the data as CSV and work with that.
It seems my query resulted in ~2million rows, but the downloads csv only contains ~200000 rows (16.4MB). So for whatever reason, the UI just silently doesn't download all the data. I'll try querying the API directly for the data. Hopefully it works. On Thursday, June 1, 2023 at 4:02:45 PM UTC-7 Chad Wood wrote: > I count the number of ads in each day, and it fluctuates. > Some days are higher than others, so it must be possible for an ad to > leave the REMOVED state. > > What happens to ads when they are no longer REMOVED? Where'd they go? > > On Thursday, June 1, 2023 at 3:58:35 PM UTC-7 Chad Wood wrote: > >> Hello, I just have a question regarding the API and how it handles >> REMOVED ads. >> It seems REMOVED ads can not be recovered. >> >> So if I remove an ad, and then I query for a record of my REMOVED ads >> every day, how many days with the ad I removed continue to show up as a >> REMOVED ad? >> >> (example): >> SELECT >> segments.date, >> ad_group_ad.ad.id >> FROM ad_group_ad >> WHERE >> ad_group_ad.status = 'REMOVED' >> >> What's the expected behavior here? If I removed an ad 10 years ago, will >> it show up as a REMOVED ad today in 2023? Is it cumulative? >> If not, what rules does it follow? >> >> >> Ref: https://support.google.com/google-ads/answer/1722131?hl=en >> Removed: Inactive because you removed it. Removing a campaign >> permanently deletes it. You cannot resume a campaign after you remove it. >> >> Ref: https://developers.google.com/google-ads/api/fields/v13/ad_group_ad >> ad_group_ad.status >> Field description: The status of the ad. >> Category: ATTRIBUTE >> Data Type: ENUM ( ENABLED, PAUSED, REMOVED, UNKNOWN) >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/4a270f02-b4cf-4c76-ab20-9057f948e58an%40googlegroups.com.
