Query regarding Adwords API SQL Call.

Hello, I am executing the below SQL query to fetch the list of Campaigns. "SELECT campaign.id, campaign.name, campaign.status, campaign.serving_status, campaign.campaign_budget, campaign.start_date, campaign.end_date FROM campaign ORDER BY campaign.id" Currently it is returning campaigns which

RE: Query regarding Adwords API SQL Call.

Hi Bikram, Thank you for reaching out to us. I would recommend that you use the Google Ads Query Builder and Query Validator tools for constructing queries. Upon checking, It is valid to filter only "ENABLED" and "PAUSED" campaigns. Below is an example query to filter it from the above tools :

Re: Query regarding Adwords API SQL Call.

Thanks a lot. Really appreciate the input. The Query Validator is very helpful. On Sun, Apr 3, 2022 at 10:34 PM Google Ads API Forum Advisor wrote: > Hi Bikram, > > Thank you for reaching out to us. > > I would recommend that you use the Google Ads Query Builder >

Re: Query regarding Adwords API SQL Call.

Hello, I am trying to fetch the budget amount of the campaign using the Ad Query. Earlier I was using the "Amount" field of the campaign with AdWords api. In the new Google Ad api I am using the "campaign_budget.amount_micros" field based on the documentation (https://developers.google.com/goo

Re: Query regarding Adwords API SQL Call.

Hello Bikram, Thanks for reaching out to the Google Ads API Forum. Could you please provide us with the complete request and response logs with request ID and request header generated on your end, so that our team may take a closer look at the issue you’re experiencing. If you haven’t enabled t