GAQL running on an MCC doesn't show a campaign

Hi, I've tried to run this GAQL on an MCC, but didn't get any rows. *ads-script:* campaignIds query =SELECT customer.id, campaign.resource_name, campaign.name FROM campaign WHERE campaign.id IN ("123456"); _rowsToMap(accountToCampaignsMap, AdsApp.report(query, REPORTING_OPTIONS)); }

How can I use "as" syntax in GAQL?

Hello How can I use "as" syntax in GAQL? ``` SELECT HourOfDay as col1, DayOfWeek, Clicks, Impressions, Conversions, Cost FROM ACCOUNT_PERFORMANCE_REPORT DURING 20211009,20211009 ``` Thanks! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdev

Re: One of the conditions in the query is invalid

Fixed. On Sunday, October 10, 2021 at 1:12:32 AM UTC+3 EladB wrote: > Hello, > I have followed the official code [from][1]: > > [![enter image description here][2]][2] > > > [1]: > https://developers.google.com/google-ads/scripts/docs/solutions/account-summary > [2]: https://i.stack.imgur.co

One of the conditions in the query is invalid

Hello, I have followed the official code [from][1]: [![enter image description here][2]][2] [1]: https://developers.google.com/google-ads/scripts/docs/solutions/account-summary [2]: https://i.stack.imgur.com/LddU5.png But Ads-script editor in GAds says my query is invalid: var today = A

Specified type 'google_ads_failure' does not exist in Google Ads API v8

Hello, I have two issues: I'm calling G-Ads API to bulk remove ads ([code](https://github.com/google/bowling-compliance-ads-remover/blob/main/src/main.py#L440)) 1) I get a partial error 2) And the code fails to parse it (taken form the official [website]( https://developers.google.com/google-

Re: Duplicate GAds account automation

Just saw this can be done manually with the Editor. https://www.webmasterworld.com/google_adwords/3541656.htm https://lucidgen.com/en/how-to-copy-google-ads-campaign/ Is there an automatic option with the Editor? Is there an automatic option without the Editor? On Thursday, September 30, 2021 a

Duplicate GAds account automation

Hello, Is there an automated way to duplicate an existing GAds account (create new account & copy an existing account structure into the new one) ? I have Googled a bit but haven't found such an API (

How to bulk remove ads with Google Ads API?

Hi I saw this [code][1] for bulk creating ad groups. I want to write similar code for bulk removing ads. Is my modification correct? def build_ad_removal_sync_operation(customer_id, campaign_id, ad_id): resource_name = serviceWrapper.ad_group_ad_service.ad_group_ad_path(customer_id,

Re: Bulk remove ads

Thanks, please allow me to dive deeper to my question: *Google Ads API: batch-processing vs bulk mutates* I want to remove a few ads in one server request. What is the difference between: - batch-processing (only async?) - bulk mutates (only sync, shorter code?) I have tried both ways an

Bulk remove ads

Hi I saw this example on how to remove a single ad. https://developers.google.com/google-ads/api/docs/samples/remove-ad I've tried to send a list of operation for bulk removing ads, but it didn't work (it's hard to reproduce as I don't have many live ads). What's the max bulk size for removal?

FaultMessage: Internal error encountered.

We're trying to call this method in parallel (MCC with 3 suc-accounts): *remove_disapproved_ads_for_account* code: with futures.ThreadPoolExecutor() as executor: results = executor.map( lambda account_item: remove_disapproved_ads_for_account(account_item), account

Ads API to get headline+description of different ad types

Hi esteemed, I want to audit the mandatory fields of a few ads from different types (text ads, extended-text ads, responsive text ads). How would you do this (python 3.8 compatible)? I see my select clause should fetch a few fields. How would you switch case the ad type while making sure my co

Cannot fetch more AdWords entities from iterator

Hi, 1) Is there any way to bypass this limit ? 2) Does Ads API (REST) does

API for scheduled auto appealing ads

Hi, I want to remove all my disapproved apps. Is there an API for appealing disapproved ads? Thanks -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this messa

What's the ads-script equivalent for "all disapproved apps" GAds-API?

I want to get all my disapproved apps, and remove them. 1) I saw this sample code: https://developers.google.com/google-ads/api/docs/samples/get-all-disapproved-ads#python What runtime env should execute this? (It has to be app engine or similar? because for ads-script I have a web integral run

"conversion action" report

Hi I was trying to call the suggested report API (based on this sample ), but I get an error message: var query = "SELECT conversion_action.firebase_settings.event_name, conversion_action.status, convers

GAds report API for "campaign tracking"

One of my clients is looking for GAds report API that brings "campaign tracking". I searched via the "report API " search box, but haven't found it. Do you know where it hides? Thanks -- -- =~=~=~=~=~=~=~=~

Which url to call AdWords and BigQuery from ads script ( w/ a service account)

Hi, I want to write an Ads-script to call GoogleAds url nad BQ url using a service account. I saw this code. Are my urls to the GAds and BQ api correct? Thanks! = // Natural Language API Sentiment URL var url = 'https://language.googleapis.com/v1beta1/documents: