No answer yet? The significance of the segments.date column seems something that should be documented better. In a different use case I now understand that there is no querying of campaign states by date - even though doing so does not give any error and simply falsely returns whatever date is queried on in the the where clause in the select column. however the query itself always returns the same information no matter on what date it is queried.
riddle me that, I would really appreciate an in depth explanation or a pointer to some documentation (couldn't find anything useful on this) Thank you! On Tuesday, September 26, 2023 at 7:59:41 AM UTC+3 Felicity Tiebel wrote: > Hi, > > I'm struggling to understand why I am getting a vastly different number of > campaigns depending on whether I add the field segments.date to the select > columns or only use segments.date in the where clause? > > From the documentation i understood that there is no need to use > segments.date in the select columns it's enough to use it in the where > clause but when i do so I get about 5 times more results. > > so this query: > > SELECT > > campaign.app_campaign_setting.app_id, > > campaign.app_campaign_setting.app_store, > > campaign.id, > > campaign.name, > > segments.date > > FROM campaign > > WHERE customer.id = account_id > > AND segments.date = date > > > gets way less result than this one: > > SELECT > > campaign.app_campaign_setting.app_id, > > campaign.app_campaign_setting.app_store, > > campaign.id, > > campaign.name > > FROM campaign > > WHERE customer.id = account_id > > AND segments.date = date > > > Can you explain to me how the presence of the segments.date column in the > select clause affects the query result? > > > Thank you! > > > Felicity > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/ceb0ec89-7a0c-4a40-b16c-8dfc99aec915n%40googlegroups.com.
