RE: using or operator in gaql query

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi,

Thank you for reaching out to the Google Ads API support team.

I would like to inform you that 'OR' operator is not supported in GAQL query. I 
would recommend that you refer to GAQL Grammar and Query Structure guides for 
more information.

Hope this helps. If you have any more queries, please feel free to get back to 
us.
This message is in relation to case "ref:!00D1U01174p.!5004Q02vEPI3:ref" 
(ADR-00260497)

Thanks,

Google Ads API Team


Register for the upcoming workshop: Performance Max and the Google Ads API!

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/6AW5B0SHJXOW002b0Rh7o3Rl26RSOWrUAxUw%40sfdc.net.

Using OR Operator in GAQL Query

[Cantare John]

Hello Google Ads API Community,

I am working on a GAQL query and need to include an OR condition in the 
WHERE clause. My query looks like this:

SELECT
  search_term_view.resource_name,
  campaign.id,
  metrics.clicks,
  metrics.conversions,
FROM
  search_term_view
WHERE
  campaign.id IN ('x')
  AND segments.date = '2024-01-01'
  AND (metrics.clicks > 0 OR metrics.conversions > 0)

However, I am receiving an error indicating that the query is not valid. I 
want to confirm if using the OR operator in the WHERE clause is supported 
in GAQL, and if so, what the correct syntax would be.

Is it possible to use the OR operator in a GAQL query? If so, can you 
provide guidance or examples on the correct usage?

Thank you for your assistance!



-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/824b6de0-74be-43f5-bdad-ea3a3054adf0n%40googlegroups.com.

Google Ads API - GAQL Query Failing

[Ismael De Freitas]

Hello,

I need to get "ad_group.ad.id" field into the query below, currently this 
is failing.

Do you know any other fields that may contain this information that I could 
potentially extract from once I have queried it?

SELECT 
customer.descriptive_name,
customer.id,
campaign.id, 
campaign.name, 
ad_group.id, 
ad_group.name,

ad_group_criterion.criterion_id,
ad_group_criterion.url_custom_parameters, 
ad_group_criterion.keyword.text,
campaign.start_date,
campaign.end_date
FROM ad_group_criterion


Thank you for your 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 
"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/d4435c3a-881f-404e-ad44-c8096986064en%40googlegroups.com.

Re: Fields missing in GAQl query builder

[Edvard Adamenko]

вт, 24 окт. 2023 г., 05:51 teambs :

> Dear
>
> we observed that some fields mentioned in resource name pages or missing
> from GAQl query builder
>
> e.g.
> For Keyword view the following metric
>  metrics.current_model_attributed_conversions_from_interactions_rate
> is mentioned in Documentation but missing in GAQL query builder
>
> *Documentation URL Ref*
>
> https://developers.google.com/google-ads/api/fields/v15/keyword_view#metrics.current_model_attributed_conversions_from_interactions_rate
>
>
> When we requested it in our request WE GOT a 400 error
>
> Is this metric available or not?
>
> --
> --
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> 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/eaadf1ac-2902-4aa0-9e47-94857e31e6a3n%40googlegroups.com
> <https://groups.google.com/d/msgid/adwords-api/eaadf1ac-2902-4aa0-9e47-94857e31e6a3n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/CAE5kkWw0KTJV%3Do_H%2BL96O%3DHT5Q5wWc9j4ZUSA5-Q_svnxWqT_A%40mail.gmail.com.

Fields missing in GAQl query builder

[teambs]

Dear

we observed that some fields mentioned in resource name pages or missing 
from GAQl query builder

e.g. 
For Keyword view the following metric
 metrics.current_model_attributed_conversions_from_interactions_rate
is mentioned in Documentation but missing in GAQL query builder

*Documentation URL Ref*
https://developers.google.com/google-ads/api/fields/v15/keyword_view#metrics.current_model_attributed_conversions_from_interactions_rate


When we requested it in our request WE GOT a 400 error 

Is this metric available or not?

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/eaadf1ac-2902-4aa0-9e47-94857e31e6a3n%40googlegroups.com.

Your next GAQL query search result can be "one search" away

[Zeyuan Gu]

Hey all, we've been working on Adzviser  for over 6 
months (YT demo ). We aim to enable the 
non-technical marketers to quickly search their marketing data like they 
would on Google Search, inspired by ChatGPT. The theory is that dashboards 
built on Google Looker Studio or Tableau don't offer enough flexibility so 
it could take marketers time to build one-off data reports to validate 
their hypothesis and answer their clients' questions. You can think of 
Adzviser as a chatbot interface that bubbles up your marketing data for 
you. Here is a one-page playbook 

 that 
explains what type of questions could be answered with Adzviser.

We've currently only integrated with Google Ads, as we expect to integrate 
FB next.

Your feedback will be what drives us to build more helpful and powerful 
tools for marketers. Our believe is that marketers deserve a tool that 
helps them understand whatever the hell is going on with their clients' 
campaigns WITHOUT ANY engineering.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/0f75f572-e079-4c62-b71a-9e111fe95374n%40googlegroups.com.

RE: GAQL query is working for predefined date ranges but not for custom date range

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Roy,

You have now reached the Google Ads API Forum. We hope you are doing well today.

Thank you for your clarification and providing information regarding Google Ads 
API. Could you please confirm if you still need support from us? Also, from the 
initial response that you mentioned that you encountered an error. With this, 
could you please the complete API logs within the format of request and 
response logs with the request ID that generated on your end where we can see 
the error?

If you haven't yet, logging can be enabled by navigating to the Client 
libraries > Your client library (ex. Java) > Logging documentation, which you 
can access from this link. I ask this so that we can provide accurate 
recommendations here.

For security purposes, you can provide it via the Reply privately to author 
option. If this option is not available, then send it instead on this email 
address googleadsapi-supp...@google.com.

Best regards,

Google Ads API Team
ref:_00D1U1174p._5004Q2jZDCV: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 
"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/kbWYU0RRI9XY00cARCMtCQTZ6iAQhakiHsFg%40sfdc.net.

Re: GAQL query is working for predefined date ranges but not for custom date range

[Roy Steves]

Found the list of current values: 
https://developers.google.com/google-ads/api/docs/query/date-ranges

And the reason that the documentation said that "DURING" was deprecated was 
that it was describing the sunset of the independent clause, but it's been 
replaced with an operator.

So, it's like "during" used to be a sibling to WHERE (like sort order and 
group by in SQL), but now it's part of the WHERE clause itself.  That 
change is documented here:
https://developers.google.com/google-ads/api/docs/migration/querying

Relevant excerpt: "Date filtering is different. There is no longer a DURING 
clause; 
instead, DURING is an operator that can be used in WHERE clauses. Filter 
the field date using the DURING clause for the same functionality as the 
DURING clause in AWQL."


On Monday, March 13, 2023 at 1:37:48 PM UTC-7 Roy Steves wrote:

> Maybe there wasn't at the time, but there sure is now.
>
> There is according to the examples here:  
>
> https://developers.google.com/google-ads/api/docs/query/overview#querying_for_segments
>
> I haven't found the list of acceptable values yet, so maybe that 
> documentation is out of date, but it is for the current version of the API.
>
> This validated, for example:
> SELECT
>   campaign.id,
>   campaign.name,
>   campaign.status,
>   metrics.impressions,
>   segments.date
> FROM campaign
> WHERE campaign.status = 'PAUSED'
>   AND metrics.impressions > 1000
>   AND segments.date during LAST_30_DAYS
> ORDER BY campaign.id
>
> On Tuesday, July 26, 2022 at 2:33:19 PM UTC-7 charlesb...@gmail.com wrote:
>
>> Hi,
>>
>> There's no "DURING" with GAQL.
>>
>> Try the GAQL query validator.
>>
>> On Tuesday, 26 July 2022 at 14:51:03 UTC-5 hema21...@gmail.com wrote:
>>
>>> Hi Team
>>>
>>> I'm trying to get the data based on  the date range. The following query 
>>> is working fine if I'm specifying the predefined date ranges like 
>>> LAST_MONTH, LAST_7_DAYS. But, giving an error while trying to give the 
>>> custom date ranges for "segments.date" . Could you pls let me know what is 
>>> causing the issue and if you can provide the working query for the below 
>>> example with custom date range will really help. TIA!
>>>
>>>
>>> curl -f --request POST "
>>> https://googleads.googleapis.com/v11/customers/3659251597/googleAds:searchStream";
>>>  
>>> --header "login-customer-id:4382929747 <(438)%20292-9747>" --header 
>>> "Content-Type: application/json" --header 'developer-token: ${dev_token}' 
>>> --header 'Authorization: Bearer '${access_token}'' --data '{ "query": 
>>> "select metrics.clicks, segments.device, segments.day_of_week, 
>>> segments.month_of_year FROM campaign WHERE metrics.clicks > 0 AND 
>>> segments.date DURING LAST_MONTH LIMIT 10" }'
>>>
>>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/78f03167-7509-4c4e-b585-5aee48c93b58n%40googlegroups.com.

Re: GAQL query is working for predefined date ranges but not for custom date range

[Roy Steves]

Maybe there wasn't at the time, but there sure is now.

There is according to the examples here:  
https://developers.google.com/google-ads/api/docs/query/overview#querying_for_segments

I haven't found the list of acceptable values yet, so maybe that 
documentation is out of date, but it is for the current version of the API.

This validated, for example:
SELECT
  campaign.id,
  campaign.name,
  campaign.status,
  metrics.impressions,
  segments.date
FROM campaign
WHERE campaign.status = 'PAUSED'
  AND metrics.impressions > 1000
  AND segments.date during LAST_30_DAYS
ORDER BY campaign.id

On Tuesday, July 26, 2022 at 2:33:19 PM UTC-7 charlesb...@gmail.com wrote:

> Hi,
>
> There's no "DURING" with GAQL.
>
> Try the GAQL query validator.
>
> On Tuesday, 26 July 2022 at 14:51:03 UTC-5 hema21...@gmail.com wrote:
>
>> Hi Team
>>
>> I'm trying to get the data based on  the date range. The following query 
>> is working fine if I'm specifying the predefined date ranges like 
>> LAST_MONTH, LAST_7_DAYS. But, giving an error while trying to give the 
>> custom date ranges for "segments.date" . Could you pls let me know what is 
>> causing the issue and if you can provide the working query for the below 
>> example with custom date range will really help. TIA!
>>
>>
>> curl -f --request POST "
>> https://googleads.googleapis.com/v11/customers/3659251597/googleAds:searchStream";
>>  
>> --header "login-customer-id:4382929747 <(438)%20292-9747>" --header 
>> "Content-Type: application/json" --header 'developer-token: ${dev_token}' 
>> --header 'Authorization: Bearer '${access_token}'' --data '{ "query": 
>> "select metrics.clicks, segments.device, segments.day_of_week, 
>> segments.month_of_year FROM campaign WHERE metrics.clicks > 0 AND 
>> segments.date DURING LAST_MONTH LIMIT 10" }'
>>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/08ec4906-76ce-478f-90e2-a1a3185c55aan%40googlegroups.com.

RE: campaign.labels does not return labels in GAQL query

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Hamza,

To assist you, could you send us a 'DEBUG' log level request and response log 
of raw API communications of the report that doesn't show the expected labels?

The request and response appears similar to the JSON Mappings in our REST 
documentation with additional headers and information such as request Id. Here 
are logging instructions for our Java, .NET, PHP, Python, Ruby and Perl Ads API 
Client Libraries.

If you are using our REST interface then the full multi line curl command line 
is a request log and adding curl command line option '-i' will also generate a 
response log.

You may send the requested information via "Reply to author" or via 
googleadsapi-supp...@google.com with a link to this forum post added to the new 
thread.

Regards,

Aryeh
Google Ads API Team
ref:_00D1U1174p._5004Q2dHqo0: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 
"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/RMFs80RG5EZL00vJwVJCQsRXuJ86b6rx6qsw%40sfdc.net.

campaign.labels does not return labels in GAQL query

[Hamza Ansari]

I have been trying to retrieve a list of campaigns using the below GAQL 
query but it does not return labels of the campaigns. 

'SELECT campaign.id, campaign.name, campaign.status, 
campaign_budget.amount_micros, campaign.labels, metrics.cost_micros FROM 
campaign WHERE campaign.status IN ("ENABLED","PAUSED") AND segments.date 
DURING TODAY'

I wanted to know if is it a bug or if there is any other way arround?
 Thanks for your 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 
"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/51b0636e-08df-460e-ad09-6c422cce1f06n%40googlegroups.com.

Re: GAQL query is working for predefined date ranges but not for custom date range

[charlesb...@gmail.com]

Hi,

There's no "DURING" with GAQL.

Try the GAQL query validator.

On Tuesday, 26 July 2022 at 14:51:03 UTC-5 hema21...@gmail.com wrote:

> Hi Team
>
> I'm trying to get the data based on  the date range. The following query 
> is working fine if I'm specifying the predefined date ranges like 
> LAST_MONTH, LAST_7_DAYS. But, giving an error while trying to give the 
> custom date ranges for "segments.date" . Could you pls let me know what is 
> causing the issue and if you can provide the working query for the below 
> example with custom date range will really help. TIA!
>
>
> curl -f --request POST "
> https://googleads.googleapis.com/v11/customers/3659251597/googleAds:searchStream";
>  
> --header "login-customer-id:4382929747 <(438)%20292-9747>" --header 
> "Content-Type: application/json" --header 'developer-token: ${dev_token}' 
> --header 'Authorization: Bearer '${access_token}'' --data '{ "query": 
> "select metrics.clicks, segments.device, segments.day_of_week, 
> segments.month_of_year FROM campaign WHERE metrics.clicks > 0 AND 
> segments.date DURING LAST_MONTH LIMIT 10" }'
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/87391868-438d-4c39-89bd-7c837f95c10dn%40googlegroups.com.

GAQL query is working for predefined date ranges but not for custom date range

[Hema Sai Mamidi]

Hi Team

I'm trying to get the data based on  the date range. The following query is 
working fine if I'm specifying the predefined date ranges like LAST_MONTH, 
LAST_7_DAYS. But, giving an error while trying to give the custom date 
ranges for "segments.date" . Could you pls let me know what is causing the 
issue and if you can provide the working query for the below example with 
custom date range will really help. TIA!


curl -f --request POST 
"https://googleads.googleapis.com/v11/customers/3659251597/googleAds:searchStream";
 
--header "login-customer-id:4382929747" --header "Content-Type: 
application/json" --header 'developer-token: ${dev_token}' --header 
'Authorization: Bearer '${access_token}'' --data '{ "query": "select 
metrics.clicks, segments.device, segments.day_of_week, 
segments.month_of_year FROM campaign WHERE metrics.clicks > 0 AND 
segments.date DURING LAST_MONTH LIMIT 10" }'

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/7763f292-051a-4c16-98b7-577da3f78eb0n%40googlegroups.com.

GAQL Query For Distinct Resource Names?

[Pete Lavetsky (AdWords API Guru)]

Hi all,

Does the Distinct concept exist in GAQL when not segmenting by date or 
similar?

For instance, if we had an account that had 100,000 CALL AdGroup 
Extensions, we could run this query to get all the ad_group resource names 
but it performs slowly because it's examining each 
ad_group_extension_setting record:

SELECT ad_group_extension_setting.ad_group FROM ad_group_extension_setting 
WHERE ad_group_extension_setting.extension_type = 'CALL' ORDER BY 
ad_group_extension_setting.extension_type DESC

What I really want is:

SELECT distinct( ad_group_extension_setting.ad_group ) FROM 
ad_group_extension_setting WHERE ad_group_extension_setting.extension_type 
= 'CALL'

and I would want hat 2nd query to be very performant.

Is it possible to query for distinct resource_names?

Thanks
Pete

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/ec40af54-e222-49a5-af9a-2b637ffb94f3n%40googlegroups.com.

[ADS API v9] GAQL query account budget is different with Google Ads.

[PJ SUN]

in the Google Ads my account budget spend is  22232.13 ,  remaining account 
budget is  370.54 . but GAQL query result is different . so how can I get 
the correct remaining account budget ?

Google Ads:
[image: GoogleAds.png]

GAQL Query:
[image: GoogleAdsApi.png]

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/795f0848-98d8-4495-b8c7-94e40cfb13ddn%40googlegroups.com.

GAQL query doubt

[FMore]

Hi 

I am trying to get a list of keywords that had impressions yesterday except 
campaigns that add the string foo in campaignName (examples: foo Campaign, 
foobar Campaign, Foobar Campaign)

SELECT
ad_group_criterion.criterion_id,
ad_group_criterion.keyword.text,
ad_group_criterion.status,
ad_group_criterion.labels,
ad_group.name,
ad_group.id,
campaign.name,
campaign.id,
metrics.impressions,
metrics.cost_per_conversion,
ad_group_criterion.effective_cpc_bid_micros,
FROM keyword_view
WHERE segments.date DURING YESTERDAY  
AND metrics.impressions>0
AND campaign.name NOT IN  ('foo')

How can achieve this?

Thanks,

Filipe

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/7cca18c5-0a46-4782-bbdd-f68ec954a9f0n%40googlegroups.com.

Re: GAQL query - get campaigns with advertising_channel_sub_type not set

[Google Ads API Forum Advisor Prod]

Hi Ales,

Thank you for returning back to us.

There is a value in campaign.advertising_channel_sub_type field field which 
will be returned when advertising channel sub-type is not specified in a 
campaign, and this value is UNSPECIFIED. With this, I would suggest filtering 
the said field with UNSPECIFIED value and by using != (not equal) operation and 
try to generate report again.

Let me know how it goes after trying the provided suggestion.

Regards,

Ernie John Blanca Tacata
Google Ads API Team
ref:_00D1U1174p._5004Q2BbfhK: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/aK_JD0QPHDO400b2NXhLb-QVWuiUoVMqsoIQ%40sfdc.net.

Re: GAQL query - get campaigns with advertising_channel_sub_type not set

[Ales Sturala]

Hi Peter,

Do you have by any chance any update on this topic?


Best, 
 Ales

On Friday, 29 January 2021 at 11:54:18 UTC+1 Ales Sturala wrote:

> Hi Peter,
>
> I read the documentation already before and tested different options with 
> no luck. Query grammar only gives you syntactical options but not 
> semantical so it doesn't say which operators are valid for which fields. I 
> tested *IS NULL *and couple of other approaches but I had no luck getting 
> only rows where *advertising_channel_sub_type *is not set.
>
> Also I guess that the *NOT IN* operator shouldn't implicitly exclude NULL 
> values.
>
> If you would manage to do such a query please let me know. For now we will 
> load all the data from the API and do additional filtering in the backend.
>
>
> Best,
>  Ales
>
>
> On Friday, 29 January 2021 at 08:37:34 UTC+1 adsapiforumadvisor wrote:
>
>> Hi Ales,
>>
>> You can refer to our Query grammar 
>>  guide 
>> to know more on what operators you can use, depending on your reporting 
>> requirement.
>>
>> Regarding your question about the advertising_channel_sub_type if the 
>> value is not set, you can try and use the *IS NULL* operator. I hope 
>> this helps.
>>
>> Best regards,
>>
>> [image: Google Logo] 
>> Peter Laurence Napa Oliquino 
>> Google Ads API Team 
>>   
>>
>> ref:_00D1U1174p._5004Q2BbfhK: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/2cc2358b-48e6-45f8-8be3-8bc68eb2d1adn%40googlegroups.com.

Re: GAQL query - get campaigns with advertising_channel_sub_type not set

[Ales Sturala]

Hi Peter,

I read the documentation already before and tested different options with 
no luck. Query grammar only gives you syntactical options but not 
semantical so it doesn't say which operators are valid for which fields. I 
tested *IS NULL *and couple of other approaches but I had no luck getting 
only rows where *advertising_channel_sub_type *is not set.

Also I guess that the *NOT IN* operator shouldn't implicitly exclude NULL 
values.

If you would manage to do such a query please let me know. For now we will 
load all the data from the API and do additional filtering in the backend.


Best,
 Ales


On Friday, 29 January 2021 at 08:37:34 UTC+1 adsapiforumadvisor wrote:

> Hi Ales,
>
> You can refer to our Query grammar 
>  guide 
> to know more on what operators you can use, depending on your reporting 
> requirement.
>
> Regarding your question about the advertising_channel_sub_type if the 
> value is not set, you can try and use the *IS NULL* operator. I hope this 
> helps.
>
> Best regards,
>
> [image: Google Logo] 
> Peter Laurence Napa Oliquino 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2BbfhK: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/cd1400c0-9d80-4909-af7b-fc1cb80eaf2fn%40googlegroups.com.

RE: GAQL query - get campaigns with advertising_channel_sub_type not set

[Google Ads API Forum Advisor Prod]

Hi Ales,

You can refer to our Query grammar guide to know more on what operators you can 
use, depending on your reporting requirement.

Regarding your question about the advertising_channel_sub_type if the value is 
not set, you can try and use the IS NULL operator. I hope this helps.

Best regards,

Peter Laurence Napa Oliquino
Google Ads API Team
ref:_00D1U1174p._5004Q2BbfhK: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/qo0uN0QNOQI800qjlndqAkSGC-lgChPxzJ-Q%40sfdc.net.

GAQL query - get campaigns with advertising_channel_sub_type not set

[Ales Sturala]

Hello,

I am trying to make a GAQL query for campaigns *of* specific advertising 
channel type *and excluding* all campaigns where advertising channel type 
is set.


While this query returns many campaigns where majority *doesn't *have 
advertising channel subtype set:

SELECT
metrics.clicks, campaign.advertising_channel_type, 
campaign.advertising_channel_sub_type
FROM campaign


Then this query *doesn't* return any campaigns at all. Expected is that it 
will return all those campaigns of SEARCH and SHOPPING without advertising 
channel subtype set:

SELECT
metrics.clicks, campaign.advertising_channel_type, 
campaign.advertising_channel_sub_type
FROM campaign
WHERE campaign.advertising_channel_sub_type NOT IN (
  'SEARCH_EXPRESS',
  'DISPLAY_EXPRESS',  
  'DISPLAY_SMART_CAMPAIGN',
  'SHOPPING_SMART_ADS'
   /* and all the other advertising sub channel types */
)

Is there a way to query for all campaigns where 
*advertising_channel_sub_type* is NULL/EMPTY/NOT SET?


Best,
 Ales

-- 

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/cf2f9b91-6e78-4c12-9cea-b7ff9bf3b55en%40googlegroups.com.

Re: GAQL query

[Akif Çakırmelik]

Thanks  adsapiforumadvisor  
7 Ekim 2020 Çarşamba tarihinde saat 23:12:51 UTC+3 itibarıyla 
adsapiforumadvisor şunları yazdı:

> Hi Akif,
>
> Thank you for reaching out. There is no such report in the Google Ads API 
> that you can use to query metrics for all sub accounts in the manager 
> account. The workaround is to query the customer.id 
> ,
>  
> customer.descriptive_name 
> 
>  
> and metrics.cost_micros 
> 
>  
> from the customer 
>  
> resource for a specific child account.
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>
>
> [image: Google Logo] 
> Xiaoming 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q25ZroQ: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/ed2e8e52-bab7-452a-beef-8584e5601604n%40googlegroups.com.

RE: GAQL query

[Google Ads API Forum Advisor Prod]

Hi Akif,

Thank you for reaching out. There is no such report in the Google Ads API that 
you can use to query metrics for all sub accounts in the manager account. The 
workaround is to query the customer.id, customer.descriptive_name and 
metrics.cost_micros from the customer resource for a specific child account.

Thanks and regards,
Xiaoming, Google Ads API Team



Xiaoming
Google Ads API Team
ref:_00D1U1174p._5004Q25ZroQ: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/Y8oEA0QHULGQ00_Ncu2lIaT_qarImsD1-3pQ%40sfdc.net.

GAQL query

[Akif Çakırmelik]

Hello to everyone. Which GAQL query should I use to get the id, name and 
total cost of all subaccounts in the manager account?

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/6e930ffd-c508-4297-9ad8-91385a4766d1n%40googlegroups.com.

RE: [Google Ads API] GAQL query selecting from ad_group_criterion_simulation only works for some accounts, other accounts return empty result, no error - same accounts on Adwords API all work fine

[Google Ads API Forum Advisor Prod]

Hi Robert,

Unfortunately I don't know exactly when those simulations will be added to the 
API but I checked with the team and they are actively being worked on and are a 
high priority, so it should hopefully be soon.

Once they're added the announcement will be made on our developer blog, so be 
sure to keep an eye on that page.

Best,
Ben, Google Ads API Team
ref:_00D1U1174p._5001UAq8xI: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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/Vsjr70PRV6IJ00Bf_ds7ETTiW-1bEvj6x89A%40sfdc.net.
For more options, visit https://groups.google.com/d/optout.

Re: [Google Ads API] GAQL query selecting from ad_group_criterion_simulation only works for some accounts, other accounts return empty result, no error - same accounts on Adwords API all work fine

[Robert Heise]

Hi Ben,

thanks for investigating. Yes, the accounts are basically shopping only - 
and exactly for those (i.e. product partitions) I'd be interested in the 
simulations.

Can you give more details which upcoming release (and especially when) will 
contain shopping-related simulations?

Thanks,

Robert

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/b2a9ace5-7dd5-49da-b2cb-75e4ad1ce10a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [Google Ads API] GAQL query selecting from ad_group_criterion_simulation only works for some accounts, other accounts return empty result, no error - same accounts on Adwords API all work fine

[Google Ads API Forum Advisor Prod]

Thanks Robert,

I think I may know what the issue is now. The API does not yet support 
simulations for shopping-related entities. That functionality will be 
introduced in an upcoming release. I took another glance at the two accounts 
that are returning empty results and it appears that most of the campaigns and 
ad groups are shopping related. Would you expect those accounts to return any 
non-shopping related simulations?

Thanks,
Ben, Google Ads API Team
ref:_00D1U1174p._5001UAq8xI: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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/d46st0PRUUDC00J9oMbu-jT7Orm0pwrysX2A%40sfdc.net.
For more options, visit https://groups.google.com/d/optout.

Re: [Google Ads API] GAQL query selecting from ad_group_criterion_simulation only works for some accounts, other accounts return empty result, no error - same accounts on Adwords API all work fine

[Robert Heise]

Hi Ben,

on the Adwords API we're using a request very similar to the ruby code 
documented in 
https://developers.google.com/adwords/api/docs/samples/ruby/optimization#get-a-bid-landscape-for-an-ad-group-and-criterion
 
. Try the query and get the first page - without providing AdGroup and 
CriterionId for the accounts I sent you in private. Via the Adwords API, 
all accounts return data - via the Ads API some accounts return only an 
empty result and no errors.

Regards,

Robert

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/b895fa2e-d89a-4be1-ba1c-c4c2d0f74007%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [Google Ads API] GAQL query selecting from ad_group_criterion_simulation only works for some accounts, other accounts return empty result, no error - same accounts on Adwords API all work fine

[Google Ads API Forum Advisor Prod]

Hi Robert,

Could you share the details of requests you were making with the AdWords API 
that were successful? That would help our investigation.

Thank you!
Ben, Google Ads API Team
ref:_00D1U1174p._5001UAq8xI: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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/NS-Ir0PRTKG400toBfb84HTJeMAvZNZZeCtg%40sfdc.net.
For more options, visit https://groups.google.com/d/optout.

RE: [Google Ads API] GAQL query selecting from ad_group_criterion_simulation only works for some accounts, other accounts return empty result, no error - same accounts on Adwords API all work fine

[Google Ads API Forum Advisor Prod]

Hi Robert,

Thanks for following up on this. I spent some time trying to investigate this 
and couldn't figure out why there's a discrepancy in behavior. I've filed a bug 
with the engineering team, hopefully they can't help resolve the situation 
quickly.

Best,
Ben, Google Ads API Team
ref:_00D1U1174p._5001UAq8xI: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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/pHj3i0PRTHQE00uJzffw9JR46Cl9UBIAjIkg%40sfdc.net.
For more options, visit https://groups.google.com/d/optout.

Re: [Google Ads API] GAQL query selecting from ad_group_criterion_simulation only works for some accounts, other accounts return empty result, no error - same accounts on Adwords API all work fine

[Robert Heise]

Hello Sal Teja, hello Ben,

the behavior hasn't changed, the query in the sample code above still only 
returns data for some accounts - for other accounts I'm getting an empty 
response, no errors. The Adwords API returns thousands and thousands of 
rows for the same accounts.

Can you confirm the issue and do you have any update when this issue will 
be fixed in the Google Ads API?

Regards,

Robert

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/0ba6c0a3-b2ff-42c7-94ba-9c0d9e755b95%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Google Ads API] GAQL query selecting from ad_group_criterion_simulation only works for some accounts, other accounts return empty result, no error - same accounts on Adwords API all work fine

[Robert Heise]

Hello Sal Teja,

another discrepancy I noticed is, that via the Adwords API I'm receiving 
start & end date for the last 30 days for the ad group criterion bid 
landscapes, while the response from the Google Ads API contains last 7 days 
only (for the accounts that work). You can easily check this by adding 
ad_group_criterion_simulation.start_date and end_date to the GAQL query. 
This is also another discrepancy between the Adwords and Ads API. It would 
be great to align this behavior as well across the Adwords & Ads APIs. The 
start and end date can't be filtered for for this resource, we have to live 
with what Google provides as date range.

On Adwords API we noticed the change from 7 to 30 days only recently for 
this type of data. In the documentation the date range is still described 
as "a week": 
https://developers.google.com/adwords/api/docs/reference/v201809/DataService.BidLandscape
 
. Ads API seems to follow this, Adwords API since recently doesn't...

Regards,

Robert

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/31d69937-d144-4fe5-9506-0ec62a6819d0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [Google Ads API] GAQL query selecting from ad_group_criterion_simulation only works for some accounts, other accounts return empty result, no error - same accounts on Adwords API all work fine

[googleadsapi-forumadvisor via AdWords API and Google Ads API Forum]

Hello Robert,

Could you please share the account Ids for which you are getting empty
results? Please use *reply privately to the author* option while sharing
the client customer ids.

Regards,
Sai Teja, Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
https://ads-developers.googleblog.com/search/label/google_ads_api
https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/ijlio2p6k0010uieec003mru44y6omjad1k68o30c1g68r3cd9j%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[Google Ads API] GAQL query selecting from ad_group_criterion_simulation only works for some accounts, other accounts return empty result, no error - same accounts on Adwords API all work fine

[Robert Heise]

Hello,

we're currently migrating from Adwords API to Ads API and stumbled on an 
issue when trying to fetch "Ad Group Criterion Simulation" data via GAQL 
query (formerly known as ad group criterion bid landscapes in Adwords API). 
In the Adwords API we're able to fetch data for all accounts. On the Ads 
API however when we try fetching data for small accounts, it works, but for 
larger accounts we only get an empty result. There is no error shown.

I'm trying to fetch using the Java client library, version 2.0.0 which has 
been just released a few days ago 
(https://mvnrepository.com/artifact/com.google.api-ads/google-ads/2.0.0). 
See sample code below (adapted from the provided java examples for 
ad_group_criterion_simulation source):

package com.foobar.google.ads;

import com.google.ads.googleads.lib.GoogleAdsClient;
import com.google.ads.googleads.v1.errors.GoogleAdsError;
import com.google.ads.googleads.v1.errors.GoogleAdsException;
import com.google.ads.googleads.v1.services.*;

import java.io.FileNotFoundException;
import java.io.IOException;

public class GetAdGroupCriterionSimulations {

private static final int PAGE_SIZE = 1_000;

public static void main(String[] args) {
long customerId = ;

GoogleAdsClient googleAdsClient;
try {
googleAdsClient = 
GoogleAdsClient.newBuilder().fromPropertiesFile().build();
System.out.printf("Credentials: %s%n", 
googleAdsClient.getCredentials().toString());
} catch (FileNotFoundException fnfe) {
System.err.printf(
"Failed to load GoogleAdsClient configuration from file. 
Exception: %s%n", fnfe);
return;
} catch (IOException ioe) {
System.err.printf("Failed to create GoogleAdsClient. Exception: 
%s%n", ioe);
return;
}

try {
new GetAdGroupCriterionSimulations().runExample(googleAdsClient, 
customerId);
} catch (GoogleAdsException gae) {
// GoogleAdsException is the base class for most exceptions thrown 
by an API request.
// Instances of this exception have a message and a 
GoogleAdsFailure that contains a
// collection of GoogleAdsErrors that indicate the underlying 
causes of the
// GoogleAdsException.
System.err.printf(
"Request ID %s failed due to GoogleAdsException. Underlying 
errors:%n",
gae.getRequestId());
int i = 0;
for (GoogleAdsError googleAdsError : 
gae.getGoogleAdsFailure().getErrorsList()) {
System.err.printf("  Error %d: %s%n", i++, googleAdsError);
}
}
}

/**
 * Runs the example.
 *
 * @param googleAdsClient the Google Ads API client.
 * @param customerId the client customer ID.
 * @throws GoogleAdsException if an API request failed with one or more 
service errors.
 */
private void runExample(GoogleAdsClient googleAdsClient, long customerId) {
try (GoogleAdsServiceClient googleAdsServiceClient =
 
googleAdsClient.getLatestVersion().createGoogleAdsServiceClient()) {
SearchGoogleAdsRequest request =
SearchGoogleAdsRequest.newBuilder()
.setCustomerId(Long.toString(customerId))
.setPageSize(PAGE_SIZE)
.setQuery("SELECT 
ad_group_criterion_simulation.ad_group_id, 
ad_group_criterion_simulation.criterion_id FROM ad_group_criterion_simulation")
.build();
// Issues the search request.
GoogleAdsServiceClient.SearchPagedResponse searchPagedResponse = 
googleAdsServiceClient.search(request);
// Iterates over all rows in all pages and prints the requested 
field values in each row.
for (GoogleAdsRow googleAdsRow : searchPagedResponse.iterateAll()) {
System.out.printf(
"Ad group criterion simulation cpc bid point for ad 
group %s and criterion %s.%n",

googleAdsRow.getAdGroupCriterionSimulation().getAdGroupId().getValue(),

googleAdsRow.getAdGroupCriterionSimulation().getCriterionId().getValue());
}
}
}
}

Enter code here...

I can send you concrete account IDs (aka customer IDs) in private. Note, 
that adding a LIMIT to the GAQL query doesn't help either, the result is 
still empty for larger accounts. Also note, that I can successfully access 
other information from the accounts (i.e. conversion_actions), only 
ad_group_criterion_simulation doesn't work (so far).

No idea whether the issue is really linked to the account size. Also no 
idea whether the java client lib is hiding the actual error (though so far 
it was raising other errors quite well) or it i