Re: Is there some documentation on the LIKE operator?

ement-sqls-like-operator-in-google-bigquery/, which also contains other useful info. On Thursday, March 16, 2023 at 10:53:26 AM UTC+1 Nelson Brochado wrote: > Hi. > > I've never used the LIKE operator to filter the content of a query. I > think that's what I need, but I&#

Re: GAQL: Filtering on FinalUrls containing some text

I'm also having a similar problem. It seems we cannot filter URLs by substrings. For example, if I wanted all rows that contain URLs with substrings ".com" or "/en/", it seems I can't do it, or am I wrong? I would be happy to be wrong, because I need to do this and it would be nice if I don't h

Is there some documentation on the LIKE operator?

Hi. I've never used the LIKE operator to filter the content of a query. I think that's what I need, but I'm not sure because I can't find a documentation page that describes it well with examples. Here we have some info, b

Re: What's the difference between landing_page_view.unexpanded_final_url and ad_group_ad.ad.final_urls?

Hi. I understand that, depending on the resource level, we may get different results. However, in this case, we're talking about fetching "final URLs" from the landing_page_view and the ad_group_ad resource. I guess my question then boils down to: what is the resource level of the landing_pag

What's the difference between landing_page_view.unexpanded_final_url and ad_group_ad.ad.final_urls?

Hi. I have a few questions, although my main question is in the title. The landing_page_view.unexpanded_final_url is described (in the docs) as follows *The advertiser-specified final URL.* while ad_group_ad.ad.final_

Re: Why would the API return the average CPV multiplied by 1 million?

e-ads/api/fields/v10/account_budget>, for example, mentions that certain amounts are specified in micros, but I'd like to know if all currency metrics are specified in micros. On Friday, January 13, 2023 at 5:21:53 PM UTC+1 Nelson Brochado wrote: > Hello. > > I was

Why would the API return the average CPV multiplied by 1 million?

Hello. I was trying to fetch all metrics that can be fetched with paid_organic_search_term_view . I also fetch the attribute paid_organic_search_term_view.search_term

Re: Why doesn't the Google Ads API support the "organic CTR" metric?

Hi. Thanks for the answer. I've requested this feature to the product team via the link you provided. Hopefully, if it makes sense, they will support it. Cheers On Thursday, January 12, 2023 at 2:05:51 AM UTC+1 adsapi wrote: > Hi Nelson, > > Thank you for reaching out to us. > > Since you sa

Re: Why doesn't the Google Ads API support the "organic CTR" metric?

Hi. Thanks for the answer. I am referring to a metric, which we could call "organic CTR", which would be computed as "organic clicks / organic impressions". I assume that the existing CTR is computed as "paid clicks / paid impressions". In fact, the description is *The number of clicks your a

Can the paid_organic_search_term_view allow you to fetch the metrics "Impr. Top %", "Bounce Rate", "conversions" and "cost micros"?

Hi. My question is in the title. It seems that paid_organic_search_term_view doesn't currently allow you to fetch these metrics, which are metrics associated *only* with the paid ads (if I understand correc

Why doesn't the Google Ads API support the "organic CTR" metric?

Hi. I've just come across paid_organic_search_term_view , which, at first glance, would seem to be the view I need, given that I need to create a report that combines paid and organic (Search Console) data.

Does the paid_organic_search_term_view allow you to get the organic average position?

Hi. I've just come across paid_organic_search_term_view , which, at first glance, would seem to be the view I need, given that I need to create a report that combines paid and organic (Search Console) data.

Why doesn't the paid_organic_search_term_view allow you to a page/URL column?

Hi. I've just come across paid_organic_search_term_view , which, at first glance, would seem to be the view I need, given that I need to create a report that combines paid and organic (Search Console) data.

Re: What are the possible reasons why I cannot reproduce a UI report, which, in theory, can be reproduced with the landing_page_view?

Hi. Thanks. I understand that, in many if not most cases, people may not want to consider rows where *all metrics* are zero. By default, the API does not return these rows and, in my code, I also exclude them by default (just in case the API changed). However, you're asking me to exclude rows

Re: What are the possible reasons why I cannot reproduce a UI report, which, in theory, can be reproduced with the landing_page_view?

Thanks for the answer. If I select only rows where impressions are greater than zero, then, yes, the API and UI data seem to match. But can't we also find a way to remove this constraint? What if I would also like to select rows where impressions are zero? I understand that certain resources

Re: What are the possible reasons why I cannot reproduce a UI report, which, in theory, can be reproduced with the landing_page_view?

Hi. Can you please confirm that you have received my message with the request and response info (as you requested)? Thanks. On Friday, December 16, 2022 at 7:10:33 PM UTC+1 adsapi wrote: > Hi Nelson, > > Thank you for reaching out to the Google Ads API support team. > > *1. Why is there a differ

Is it possible that we get different results if we use a service account as opposed to a user account?

Hi. My question is in the title. I'm currently observing this weird behaviour. Specifically, in the second setup, I get more rows in the report. Is this a known issue? These are my two setups. First setup. Account ID = X Login customer ID = Y, where Y is a manager account that has access to X

Re: Why doesn't the Google Ads API support filtering ad_group_criterion.quality_info.post_click_quality_score by UNSPECIFIED?

I think you provided an answer to another question here: https://groups.google.com/g/adwords-api/c/eLhowu16x3s. I still need to provide an answer (request and response) to you there. So, could you please answer this new question? On Monday, December 19, 2022 at 5:05:01 PM UTC+1 adsapi wrote: >

Why doesn't the Google Ads API support filtering ad_group_criterion.quality_info.post_click_quality_score by UNSPECIFIED?

Hi. The documentation for v12 says that the UNSPECIFIED option is available for the ad_group_criterion.quality_info.post_click_quality_score metric. In fact, I

Re: What is the difference between ad_group_ad.ad.final_urls and ad_group_criterion.final_urls?

think I should ask this question to the Google Ads team. I've also read this <https://instapage.com/blog/adwords-final-url> and this <https://support.google.com/google-ads/answer/6080568?hl=en> articles. Thanks a lot. On Saturday, December 17, 2022 at 1:20:28 PM UTC+1 Ne

Re: What is the difference between ad_group_ad.ad.final_urls and ad_group_criterion.final_urls?

ed to the final URLs of the keyword (that made the ad to be served)? Is this the relationship between ad_group_criterion.final_urls and ad_group_ad.ad.final_urls, or is there something more?* On Saturday, December 17, 2022 at 1:05:17 PM UTC+1 Nelson Brochado wrote: > Hi Peter. > > Thank

Re: What is the difference between ad_group_ad.ad.final_urls and ad_group_criterion.final_urls?

Hi Peter. Thanks for pointing me to that article. I understand why URLs are associated with ads. However, I don't understand why they are associated with ad group criteria, which is a concept that exists only in the Google Ads API. Or do criteria also exist in Google Ads? So, could you pleas

Re: Why is the "creative quality score" (aka ad relevance) associated with an ad group criterion?

Alright, thanks for all the help. If "the API only mirrors what is available in the Google Ads UI", then what kind of UI reports could we reproduce with ad_group_criterion.quality_info.creative_quality_score

What is the difference between ad_group_ad.ad.final_urls and ad_group_criterion.final_urls?

Hello. My understanding is that an *ad group criterion* can be applied to an *ad group* and, in the Google Ads API, we can have criteria of type "keyword".The concept of "ad group criteria" doesn't seem to exist in Google Ads but just in the API. So, my conclusion is that we can say that we ha

Re: What are the possible reasons why I cannot reproduce a UI report, which, in theory, can be reproduced with the landing_page_view?

UTC+1 Nelson Brochado wrote: > Hi guys. > > I'm trying to reproduce the following Google Ads UI report. > > [image: mobile.png] > > In theory, as far as I understand, this report can be reproduced with the > landing_page_view. Please, correct me if I am wrong here

Re: Why is the "creative quality score" (aka ad relevance) associated with an ad group criterion?

Hi Peter, I've reached out to the Google Ads Team. I was told that the "ad relevance" may be different for each ad in the same ad group, so my assumption that all ads in the same ad group have the same "ad relevance" is wrong. If that's correct, then what exactly does ad_group_criterion.qualit

What are the possible reasons why I cannot reproduce a UI report, which, in theory, can be reproduced with the landing_page_view?

Hi guys. I'm trying to reproduce the following Google Ads UI report. [image: mobile.png] In theory, as far as I understand, this report can be reproduced with the landing_page_view. Please, correct me if I am wrong here, because this is my assumption. Unfortunately, I was not yet able to full

Re: How do we get all fields associated with the column "Ad" in the UI report?

Hi, thanks for the answer, but here I am not asking about the "ad relevance", which I asked e.g. here https://groups.google.com/g/adwords-api/c/ullCSDCk4bY, but about how to get the attributes associated with the "Ad" column in a UI report (e.g. headlines) using the Google Ads API. Please, see

How do we get all fields associated with the column "Ad" in the UI report?

Hi. The column "Ad" in a UI report in Google Ads actually contains a lot of information and fields. In fact, if we download a UI report as a CSV file, we will get many more columns than what we specified in the UI report: these columns are exactly the fields that I've just mentioned, for exampl

Re: Why is the "creative quality score" (aka ad relevance) associated with an ad group criterion?

Hi Matt. Thanks for your answer. But can you clarify why the quality score is measured at the keyword level? Is it because this quality score depends on the keyword that triggered the ad to be served? Why is it called "ad relevance"? It seems to me that this property/metric may even be shared

Why is the "creative quality score" (aka ad relevance) associated with an ad group criterion?

Hello. My question is in the title, but let me elaborate on why I am asking it. If an ad group criterion is some kind of filter that we apply to an ad group (so I suppose that each ad in that ad group also "inherits" this criterion/filter) and if the "ad relevance

Re: How to get the ad relevant for each ad?

*so I assume this is possible in the Google Ads API On Thursday, December 8, 2022 at 5:19:27 PM UTC+1 Nelson Brochado wrote: > What would be the query to get the *ad relevance* > <https://support.google.com/google-ads/answer/6167118> (which is a metric > used to calculate the qua

How to get the ad relevant for each ad?

What would be the query to get the *ad relevance* (which is a metric used to calculate the quality score) for each ad? So, I want to get the data segmented by ad (and also ad_group and campaign). I've tried to look into the documentation

What do these UI columns in the Google Ads Reporting page correspond to in the GADs API?

Hello. Currently, I'm trying to reproduce a report that was created in the Google Ads interface using the Google Ads API. This is not my ultimately goal, but it's necessary in order to check that I get the data that I see in the UI using the API. In particular, I've been trying to map the colu

How can I retrieve the exact "search keyword" UI column data using the Google Ads API?

Hello. Currently, I'm trying to reproduce a report that was created in the Google Ads interface using the Google Ads API. This is not my ultimately goal, but it's necessary in order to check that I get the data that I see in the UI using the API. In particular, I've been trying to map the colu