Re: gaql query asset_field_type_view ,return no data..

My confusion is that I have a lot of assets under my account, but they all come up empty through gaql, which is obviously not right! GAQL query: "SELECT\ncampaign.id,\n asset_field_type_view.field_type,\n asset_field_type_view.resource_name\nFROM asset_field_type_view\n&

GAQL query asset_field_type_view ,return no data..

here is my request log: 2025-01-26T22:30:52.582+08:00 DEBUG 37451 --- [ads-jobs] [order-processing] [ault-executor-0] c.g.ads.googleads.lib.request.detail : SUCCESS REQUEST DETAIL. Request --- MethodName: google.ads.googleads.v18.services.GoogleAdsService/SearchStream Endpoint: googleads

RE: using or operator in gaql query

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 mo

Using OR Operator in GAQL Query

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

Google Ads API - GAQL Query Failing

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,

Re: Fields missing in GAQl query builder

вт, 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

Fields missing in GAQl query builder

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

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

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

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

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 e

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

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. >>

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

YS 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

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

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

campaign.labels does not return labels in GAQL query

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.stat

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

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 speci

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

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 ca

GAQL Query For Distinct Resource Names?

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_exten

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

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

GAQL query doubt

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.key

Re: GAQL query - get campaigns with advertising_channel_sub_type not set

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 UN

Re: GAQL query - get campaigns with advertising_channel_sub_type not set

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

Re: GAQL query - get campaigns with advertising_channel_sub_type not set

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 gett

RE: GAQL query - get campaigns with advertising_channel_sub_type not set

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 regar

GAQL query - get campaigns with advertising_channel_sub_type not set

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.c

Re: GAQL query

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

RE: GAQL query

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 specif

GAQL query

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

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

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

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

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, Ro

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

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 t

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

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 Criter

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

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:

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

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:_00D1U

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

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

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

heck 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

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

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 blo

[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

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