Re: Bulk Download - Google Ads API

2021-03-23 Thread 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

Re: Bulk Download - Google Ads API

2021-03-23 Thread 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' ,

Re: Bulk Download - Google Ads API

2021-03-10 Thread 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 -- -- =~=~=~

Re: Bulk Download - Google Ads API

2021-03-09 Thread 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

Re: Bulk Download - Google Ads API

2021-02-03 Thread 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

Re: Bulk Download - Google Ads API

2021-02-02 Thread 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

Re: Bulk Download - Google Ads API

2021-01-19 Thread 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,

Re: Bulk Download - Google Ads API

2021-01-19 Thread 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 chec

Re: Bulk Download - Google Ads API

2021-01-19 Thread 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 t

RE: Bulk Download - Google Ads API

2021-01-05 Thread 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

Bulk Download - Google Ads API

2021-01-05 Thread 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