Re: What's wrong with this query

[Dihan Cheng]

thank you!

On Thursday, July 16, 2020 at 10:32:39 AM UTC-4, adsapiforumadvisor wrote:
>
> Hi Dihan,
>
> You should give both start and end date when using the date field. If you 
> don't know the start date of your account, you can navigate to your account 
> and choose the date range All Time. It will show you the start date.
>
> Cheers,
> Anthony
> Google Ads API Team
>
> ref:_00D1U1174p._5004Q21mSY4:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/74b2aecd-7670-420f-bf5c-6d96850e7709o%40googlegroups.com.

Re: What's wrong with this query

[Dihan Cheng]

Hi Anthony,

Thanks for helping! Is it possible to include date range only with 
segments.date <= "some date" ? I want to get all the entities before 
current date, but I don't know about the starting date.

Dihan

On Thursday, July 16, 2020 at 9:10:17 AM UTC-4, adsapiforumadvisor wrote:
>
> Hello,
>
> If you are selecting the field segments.date, you should also include a date 
> range 
> . 
> Let me know if you still face issues after including this.
>
> Cheers,
> Anthony
> Google Ads API Team 
>
> ref:_00D1U1174p._5004Q21mSY4:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/2bca31e1-1b22-4c22-8ba0-7d78dd18617co%40googlegroups.com.

RE: What's wrong with this query

[Google Ads API Forum Advisor Prod]

Hello,

If you are selecting the field segments.date, you should also include a date 
range. Let me know if you still face issues after including this.

Cheers,
Anthony
Google Ads API Team
ref:_00D1U1174p._5004Q21mSY4:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/8cAk90QDKCK600wnJazRqSQeWhd9rR0_h2JQ%40sfdc.net.

Re: What's wrong with this query

[Dihan Cheng]

actually even the simplest form does not work, 

SELECT ad_group_ad.ad.id, segments.date FROM ad_group_ad

On Thursday, July 16, 2020 at 12:50:57 AM UTC-4, Dihan Cheng wrote:
>
> Hi, I'm trying to select the following fields from resource ad_group_ad , 
> it's working before I add segments.date, wondering what is wrong. I've used 
> the interactive gaql builder, the following query is valid from the builder.
> SELECT ad_group.id,ad_group.name,campaign.id,campaign.name
> ,campaign.advertising_channel_type,customer.id,ad_group_ad.ad.id,
> ad_group_ad.ad.name,ad_group_ad.status,ad_group_ad.policy_summary,ad_group_ad.ad.tracking_url_template,ad_group_ad.ad.final_url_suffix,ad_group_ad.ad.url_custom_parameters,ad_group_ad.ad.display_url,ad_group_ad.ad.final_urls,ad_group_ad.ad.final_app_urls,ad_group_ad.ad.final_mobile_urls,ad_group_ad.ad.display_url,ad_group_ad.ad.type,ad_group_ad.ad.device_preference,ad_group_ad.ad.url_collections,ad_group_ad.ad_strength,ad_group_ad.ad.text_ad.description1,ad_group_ad.ad.text_ad.description2,ad_group_ad.ad.text_ad.headline,segments.date
>  
> FROM ad_group_ad
>
> thanks for any help
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"AdWords API and Google Ads 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/027ce777-71a7-4155-a50f-3235d32a37b0o%40googlegroups.com.