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 [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/0f5f97be-f736-4ce4-85ba-df0398eff3ean%40googlegroups.com.
