Re: Bulk Download - Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Harshi,

The query that you provided appears to be correct and it return the search 
keywords only on the said report type. With this, could you clarify if you 
encountered any issues with the lastest GAQL of the report?

In addition, if you are looking for the report type dedicated for keywords 
only, then I would suggest using the keyword_view and include the 
ad_group_criterion.negative as filter of the report to get search keywords only 
and to not include negative keywords.

Regards,

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

Re: Bulk Download - Google Ads API

[Harshi Manju]

How do we get only Search keywords and ignore negative keywords from 
*ad_group_criterion 
*service?

I've used like this:
SELECT 
ad_group_criterion.criterion_id,ad_group_criterion.keyword.text,ad_group_criterion.status
 FROM 
ad_group_criterion where ad_group_criterion.status NOT IN ('UNKNOWN' 
,'REMOVED') and ad_group_criterion.negative=true

I would need only Search Keywords. I tried different ways, but count is not 
matching
On Wednesday, March 10, 2021 at 9:33:08 PM UTC+5:30 adsapiforumadvisor 
wrote:

> Hi Harshi,
>
> Thank you for reaching out. You could add ad_group_criterion.negative 
> 
>  in 
> your query to check whether the keyword is excluded (`true`) or 
> targeted(`false`). 
>
>
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>
>  
> [image: Google Logo] 
> Xiaoming 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2AHc6C: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/59a7efe2-7046-48c9-8401-c50666094d05n%40googlegroups.com.

Re: Bulk Download - Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Harshi,

Thank you for reaching out. You could add ad_group_criterion.negative in your 
query to check whether the keyword is excluded (`true`) or targeted(`false`).

Thanks and regards,
Xiaoming, Google Ads API Team


Xiaoming
Google Ads API Team
ref:_00D1U1174p._5004Q2AHc6C: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/Unh410QPRGKW00n16zI3lCSaewkvHKFaYrMQ%40sfdc.net.

Re: Bulk Download - Google Ads API

[Harshi Manju]

Hi, Currently I'm fetching only keywords(Including search, display, video, 
negative keywords) from my account. 
1. How do we differentiate all different types of keywords(Is it like 
Is_negative = 1 for negative keywords)
I was confusing on how to write GAQL query for this?
Please help me with the GAQL.

  String query = "SELECT 
ad_group_criterion.criterion_id,ad_group_criterion.keyword.text,ad_group_criterion.status
 
"
+ "FROM ad_group_criterion where 
ad_group_criterion.status NOT IN ('UNKNOWN' ,'REMOVED')"; 
 

On Wednesday, February 3, 2021 at 9:19:12 PM UTC+5:30 adsapiforumadvisor 
wrote:

> Hi Harshi,
>
> Thank you for reaching out. You could query the 
> ad_group_criterion.criterion_id 
> ,
>  
> ad_group_criterion.keyword.text 
> 
>  
> and ad_group_criterion.status 
> 
>  
> from the ad_group_criterion 
>  
> resource to fetch the keyword_id, keyword_name and keyword_status.
>
>
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>  
>
> [image: Google Logo] 
> Xiaoming 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2AHc6C: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/1b3fbc1e-f909-4073-96d1-78b422cc09a2n%40googlegroups.com.

Re: Bulk Download - Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Harshi,

Thank you for reaching out. You could query the 
ad_group_criterion.criterion_id, ad_group_criterion.keyword.text and 
ad_group_criterion.status from the ad_group_criterion resource to fetch the 
keyword_id, keyword_name and keyword_status.

Thanks and regards,
Xiaoming, Google Ads API Team

Xiaoming
Google Ads API Team
ref:_00D1U1174p._5004Q2AHc6C: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/gs4ew0QNYMLJ00M7u59OkOSzKXzefMrwt_tQ%40sfdc.net.

Re: Bulk Download - Google Ads API

[Harshi Manju]

Hi Google Team,

How can we get the data keyword structure? Could you please send  the GAQL 
query.
I need the keyword_id, keyword_name, keyword_status in the GAQL query. 
I was confusing for the keyword and was able to get the GAQL query for 
Campaign, AdGroup. Below is the reference

For Campaign: SELECT campaign.id, campaign.name , campaign.status FROM 
campaign ORDER BY campaign.id
For AdGroup: SELECT ad_group.id, ad_group.name , ad_group.status FROM 
ad_group where ad_group.status != 'REMOVED'

On Wednesday, January 20, 2021 at 2:30:52 AM UTC+5:30 adsapiforumadvisor 
wrote:

> Hi Harshi,
>
> Thank you for reaching out. Please find my response to your questions 
> below:
>  
>
>1. 
>
>You could specify a date range with 380 days difference by setting a 
>predicate such as segments.date BETWEEN '2018-01-01' AND '2019-01-31'in 
> the 
>WHERE clause.
>2. 
>
>To get the whole account hierarchy and objects, you could give it a 
>try to query the account by using the get request 
>. 
> 
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>
>
> ref:_00D1U1174p._5004Q2AHc6C: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/38313c0d-82b3-40c3-abae-93f37be26ba1n%40googlegroups.com.

Re: Bulk Download - Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Harshi,

Thank you for reaching out. Please find my response to your questions below:

You could specify a date range with 380 days difference by setting a predicate 
such as segments.date BETWEEN '2018-01-01' AND '2019-01-31'in the WHERE clause.

To get the whole account hierarchy and objects, you could give it a try to 
query the account by using the get request.


Thanks and regards,
Xiaoming, Google Ads API Team
ref:_00D1U1174p._5004Q2AHc6C: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/RjZTZ0QN791200ItBEzSrITtWpuvo54HcUbQ%40sfdc.net.

Re: Bulk Download - Google Ads API

[Harshi Manju]

1. How can we get the stats data for the last 380 days in one go? If no, 
let me know if there is any alternate solution.
FYI, I referred to this article 
https://developers.google.com/google-ads/api/docs/query/grammar

2.  I assume  we can get the multiple accounts in one go,  Just wanted to 
check there anyway to get the entire account structure for one specific 
account(Campaigns > adgroups > keywords > ads) within one request?

On Tuesday, January 19, 2021 at 5:18:18 PM UTC+5:30 Harshi Manju wrote:

> Hi, 
>
> How can we get the stats data for 380 days?
> FYI, I referred to this article 
> https://developers.google.com/google-ads/api/docs/query/grammar
>
> On Wednesday, January 6, 2021 at 3:23:39 AM UTC+5:30 adsapiforumadvisor 
> wrote:
>
>> Hi Harshi,
>>
>> Thank you for reaching out. Please find my response to your questions 
>> below:
>>  
>>
>>1. 
>>
>>You could use BatchJobService 
>>
>> 
>>  
>>to perform batches of operations on multiple services without 
>> synchronously 
>>waiting for the operations to complete. This way, you would be able to 
>> bulk 
>>download various entities in your Google Ads account asynchronously. 
>> Please 
>>refer to this guide 
>>
>> 
>>  
>>for more information on Batch Processing.
>> 
>>2. 
>>
>>In Google Ads API, you could download a set of reports from a list of 
>>accounts in parallel by using this sample code 
>>
>> 
>>  
>>with GAQL 
>>. 
>>
>>   
>>
>> Thanks and regards,
>> Xiaoming, Google Ads API Team
>>
>>  
>> [image: Google Logo] 
>> Xiaoming 
>> Google Ads API Team 
>>   
>>
>> ref:_00D1U1174p._5004Q2AHc6C: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/48517c77-df8e-4285-ac83-6eb8e959853cn%40googlegroups.com.

Re: Bulk Download - Google Ads API

[Harshi Manju]

Hi, 

How can we get the stats data for 380 days?
FYI, I referred to this article 
https://developers.google.com/google-ads/api/docs/query/grammar

On Wednesday, January 6, 2021 at 3:23:39 AM UTC+5:30 adsapiforumadvisor 
wrote:

> Hi Harshi,
>
> Thank you for reaching out. Please find my response to your questions 
> below:
>  
>
>1. 
>
>You could use BatchJobService 
>
> 
>  
>to perform batches of operations on multiple services without 
> synchronously 
>waiting for the operations to complete. This way, you would be able to 
> bulk 
>download various entities in your Google Ads account asynchronously. 
> Please 
>refer to this guide 
>
>  
>for more information on Batch Processing.
> 
>2. 
>
>In Google Ads API, you could download a set of reports from a list of 
>accounts in parallel by using this sample code 
>
> 
>  
>with GAQL 
>. 
>
>   
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>
>  
> [image: Google Logo] 
> Xiaoming 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2AHc6C: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/304de92f-9531-4adf-bb63-8423e7f0b93fn%40googlegroups.com.

RE: Bulk Download - Google Ads API

[Google Ads API Forum Advisor Prod]

Hi Harshi,

Thank you for reaching out. Please find my response to your questions below:

You could use BatchJobService to perform batches of operations on multiple 
services without synchronously waiting for the operations to complete. This 
way, you would be able to bulk download various entities in your Google Ads 
account asynchronously. Please refer to this guide for more information on 
Batch Processing.

In Google Ads API, you could download a set of reports from a list of accounts 
in parallel by using this sample code with GAQL.


Thanks and regards,
Xiaoming, Google Ads API Team


Xiaoming
Google Ads API Team
ref:_00D1U1174p._5004Q2AHc6C: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/PyFtV0QMHE4E00bG2TKgrlQGamZLsEUx1buw%40sfdc.net.

Bulk Download - Google Ads API

[Harshi Manju]

Hi there, how to fetch data from google ads API. 

Here are my questions.
1.Is there any way to bulk download all the campaign structure and stats 
(Including adgroups, keywords, ads), or should we send each request 
separately to get the response in the object form?
2. Also,  Is there anyway like aw-reporting for 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 
"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/b4dd07a9-22d5-4167-8558-689d0b37e7afn%40googlegroups.com.