RE: landing_page_view ignore products urls

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Serhii,

Thanks for reaching out to the Google Ads API Team. I hope you are doing well 
today.

With regards to your concern, as shown in your screenshot provided, you may use 
the landing_page_view reporting 
(https://developers.google.com/google-ads/api/fields/v14/landing_page_view) and 
try it in our landing_page_view_query_builder 
(https://developers.google.com/google-ads/api/fields/v14/landing_page_view_query_builder)
 , then validate using the query_validator 
(https://developers.google.com/google-ads/api/fields/v14/query_validator). See 
sample query below for reference.

SELECT landing_page_view.resource_name, landing_page_view.unexpanded_final_url, 
ad_group.campaign, ad_group.id, ad_group.name, ad_group.resource_name FROM 
landing_page_view

On the other hand, if you are referring to the “expanded final url” the, you 
may use the expanded_landing_page_view 
(https://developers.google.com/google-ads/api/fields/v14/expanded_landing_page_view)
 and try it in our expanded_landing_page_view_query_builder 
(https://developers.google.com/google-ads/api/fields/v14/expanded_landing_page_view_query_builder).
 See sample query below for reference.

SELECT expanded_landing_page_view.expanded_final_url, 
expanded_landing_page_view.resource_name, ad_group.campaign, ad_group.id, 
ad_group.name, ad_group.resource_name FROM expanded_landing_page_view

However, you may also provide us an uncropped screenshot from Google Ads UI 
with date filter, for us to further check and validate the information, and for 
us to provide accurate recommendations.

Have a great day.

This message is in relation to case "ref:_00D1U1174p._5004Q2oAABu:ref"

Thanks,

Google Ads API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/BpGyE0S0BDJ200Hjy_KxQ_Q2el4Z6SWVr8Wg%40sfdc.net.

landing_page_view ignore products urls

[Serhii Kusyi]

Hi,

how can I get all expanded urls from dynamic remarketing campaign with 
products feed, because I get urls with main page only, but campaign shows 
product in GDN

[image: 12212.png]

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/712e5d5c-cbfb-4780-b1da-be2b70556060n%40googlegroups.com.

Requesting landing_page_view report returns '500 Internal Error'

['Julius Fechner' via Google Ads API and AdWords API Forum]

Hello,

we're running into an issue with Google Ads where when we request data from 
the 'landing_page_view' report we get an 'Internal Service' error. This is 
true even for seemingly any query. It has been occurring for the past 3 
days to our knowledge. Is there a known outage for this service? I have not 
been able to find anything on the GA status dashboard.

Kind regards,
Julius

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/daf9e88f-f056-4fb2-8bab-26c3fde9f04en%40googlegroups.com.

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

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Nelson,

Thank you for getting back to us. I hope you are doing well today.

We appreciate your patience with this concern. Upon checking your account in 
our end, I can see that there is discrepancy encountered here. With this, allow 
me to raise this to the rest of our team. We will provide updates once 
available.

Regards,

Darwin
Google Ads API Team
ref:_00D1U1174p._5004Q2h3nbv:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/1-jwX0ROAELA00AXXQBnlNTw2-IckqH0I0fA%40sfdc.net.

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

[Nelson Brochado]

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 where only 
*one 
of the metrics* is zero (i.e. impressions), where the others may not be 
zero, which may not be desirable. I'm developing this simple application, 
where I would give the possibility to the user to select whether to add or 
not this constraint. 

So, I would like to know

1. *Why* can't I reproduce the UI report *without* the impressions > 0? Is 
this a bug in the Google Ads API?
2. And, if I can reproduce the UI report *without* this constraint, how can 
I do it?

Thank you.

On Tuesday, January 10, 2023 at 11:30:36 AM UTC+1 adsapi wrote:

> Hi Nelson,
>
> Thank you for getting back to our team.
>
> We really understand your situation. However,  kindly note that to produce 
> a more useful report, you can explicitly exclude zero metrics. Please see 
> this zero metrics guide 
>  
> for more information.
>
> Regards,
> [image: Google Logo] 
> Carmela 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2h3nbv:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/75817238-76f6-425e-8636-210a22bd0c60n%40googlegroups.com.

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

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Nelson,

Thank you for getting back to our team.

We really understand your situation. However,  kindly note that to produce a 
more useful report, you can explicitly exclude zero metrics. Please see this 
zero metrics guide for more information.

Regards,

Carmela
Google Ads API Team
ref:_00D1U1174p._5004Q2h3nbv:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/DtU490RO9MII00AwD673aRTKq6w36vNFcy0w%40sfdc.net.

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

[Nelson Brochado]

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 or segments may segment the data, but 
this also happens in the UI. So, I suppose that there must be a way to 
reproduce exactly the UI report without having this constraint. 

Thanks.
On Tuesday, January 10, 2023 at 7:45:58 AM UTC+1 adsapi wrote:

> Hi Nelson,
>
> Thank you for the reply.
>
> Please note that when adding some segments, the metrics in the summary row 
> may decrease or increase, and upon checking it, I can see that you have 
> selected segments fields. Please note that ad_group 
> <https://developers.google.com/google-ads/api/fields/v12/ad_group> and 
> campaign 
> <https://developers.google.com/google-ads/api/fields/v12/campaign> are 
> segmenting resources of landing_page_view 
> <https://developers.google.com/google-ads/api/fields/v12/landing_page_view>. 
> Upon replicating it on my end, I can see that it has matched results when 
> you remove the segments field both in the UI and API or if you filter the 
> impressions greater to 0. You may try the sample below query to check it 
> with your end:
>
> *“SELECT landing_page_view.resource_name, 
> landing_page_view.unexpanded_final_url, campaign.id <http://campaign.id>, 
> campaign.name <http://campaign.name>, ad_group.name <http://ad_group.name>, 
> ad_group.id <http://ad_group.id>, campaign.status, ad_group.status, 
> metrics.speed_score, metrics.mobile_friendly_clicks_percentage, 
> metrics.clicks, metrics.impressions, metrics.ctr FROM landing_page_view 
> WHERE segments.date BETWEEN '2022-10-01' AND '2022-11-12' AND 
> ad_group.status = 'ENABLED' AND campaign.status = 'ENABLED' and 
> metrics.impressions>0 ","return_total_results_count" : true*
>
> Best regards,
> [image: Google Logo] 
> Heidi 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2h3nbv:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/c872de24-a663-4e7b-b6e2-ac2b928cbc24n%40googlegroups.com.

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

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Nelson,

Thank you for the reply.

Please note that when adding some segments, the metrics in the summary row may 
decrease or increase, and upon checking it, I can see that you have selected 
segments fields. Please note that ad_group and campaign are segmenting 
resources of landing_page_view. Upon replicating it on my end, I can see that 
it has matched results when you remove the segments field both in the UI and 
API or if you filter the impressions greater to 0. You may try the sample below 
query to check it with your end:

“SELECT landing_page_view.resource_name, 
landing_page_view.unexpanded_final_url, campaign.id, campaign.name, 
ad_group.name, ad_group.id, campaign.status, ad_group.status, 
metrics.speed_score, metrics.mobile_friendly_clicks_percentage, metrics.clicks, 
metrics.impressions, metrics.ctr FROM landing_page_view WHERE segments.date 
BETWEEN '2022-10-01' AND '2022-11-12' AND ad_group.status = 'ENABLED' AND 
campaign.status = 'ENABLED' and metrics.impressions>0 
","return_total_results_count" : true

Best regards,

Heidi
Google Ads API Team
ref:_00D1U1174p._5004Q2h3nbv:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/oaRvj0RO9C40009n0Tpyh4RoS0Js5FQtcLUA%40sfdc.net.

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

[Nelson Brochado]

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 difference between the API and UI reports/data?*  To 
> investigate the issue further, could you please provide the complete 
> request 
> 
>  and response 
> 
>  logs, 
> with the request-id 
> ?
>  
> If you haven't yet, logging can be enabled by navigating to the Client 
> libraries > Your client library (ex. Java) > Logging documentation, which 
> you can access from this link 
> .
>
> *2. What does the API do that the UI doesn't and vice-versa (for this 
> specific report)?* Could you please provide full screen screenshot of the 
> UI of what you are looking for?
>
>
> *3. What should I change in my query in order to reproduce exactly the UI 
> report above? *
>I can confirm here your query is correct.
>
> You can provide it via Reply privately to author option. If this option is 
> not available, you may send the details directly to our 
> googleadsa...@google.com 
> 
>  alias 
> instead. 
>
> Thanks, 
> [image: Google Logo] 
> Nirmita 
> Google Ads API Team 
>   
>
> ref:_00D1U1174p._5004Q2h3nbv:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/8ef4d95d-526b-4281-8cd0-832846f19865n%40googlegroups.com.

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

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Nelson,

Thank you for reaching out to the Google Ads API support team.

1. Why is there a difference between the API and UI reports/data? To 
investigate the issue further, could you please provide the complete request 
and response logs, with the request-id? If you haven't yet, logging can be 
enabled by navigating to the Client libraries > Your client library (ex. Java) 
> Logging documentation, which you can access from this link.

2. What does the API do that the UI doesn't and vice-versa (for this specific 
report)? Could you please provide full screen screenshot of the UI of what you 
are looking for?

3. What should I change in my query in order to reproduce exactly the UI report 
above?
I can confirm here your query is correct.

You can provide it via Reply privately to author option. If this option is not 
available, you may send the details directly to our 
googleadsapi-supp...@google.com alias instead.

Thanks,

Nirmita
Google Ads API Team
ref:_00D1U1174p._5004Q2h3nbv:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/lUe8a0RMZX5200haJ2ocbeTfqBrHXvkxOnEQ%40sfdc.net.

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

[Nelson Brochado]

I forgot to mention that, before comparing the API and UI reports, I am 
dropping all rows where the metrics are all zero. This makes the API report 
still have 7491 rows (so the API doesn't return, at least in this case, 
rows where all metrics are zero), while the UI reports now has 7458 rows. 
Note 7491 - 7458 = 33, hence the 33 rows in the API report that are not 
found in the UI report. In fact, these 33 rows do not have all metrics 
equal to zero. In particular, it seems that the clicks are not equal to 
zero, but all other metrics are.

On Friday, December 16, 2022 at 1:44:30 PM 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, because this is 
> my assumption.
>
> Unfortunately, I was not yet able to fully reproduce this UI (with Google 
> Ads API v12) with the following query
>
> SELECT
> landing_page_view.unexpanded_final_url,
> campaign.name,
> campaign.status,
> ad_group.name,
> ad_group.status,
> metrics.speed_score,
> metrics.mobile_friendly_clicks_percentage,
> metrics.clicks,
> metrics.impressions,
> metrics.ctr
> FROM landing_page_view
> WHERE
> segments.date BETWEEN '2022-10-01' AND '2022-11-12'
> AND
> campaign.status = ENABLED
> AND
> ad_group.status = ENABLED
>
> I get *7491* rows, which are the same number of rows I find in the UI 
> report (see the screenshot). However, after having compared the 2 data 
> frames (I'm using pandas), it seems that there are *33* rows returned by 
> the API that are not found in the UI report, and I can't really explain why.
>
> So, here are my questions
>
> *1. Why is there a difference between the API and UI reports/data?* 
>
> *2. What does the API do that the UI doesn't and vice-versa (for this 
> specific report)? *
>
> *3. What should I change in my query in order to reproduce exactly the UI 
> report above?*
>
> The only advice given in the Google Ads API documentation 
> <https://developers.google.com/google-ads/api/docs/reporting/uireports> 
> that I found regarding possible differences is that the UI implicitly 
> filters REMOVED campaigns and so we should also ignore them, but, as you 
> can see above, I am only selecting ENABLED campaigns, so this is not the 
> problem.
>
> Note: if I use an older GAD API version (specifically, v11), I get even 
> more different results, with the same query. I get many fewer rows. *Why 
> is that?*
>
> Thanks for all the help.
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/126c918e-6c77-4b2c-832b-bf6cb106c5d8n%40googlegroups.com.

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

[Nelson Brochado]

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 fully reproduce this UI (with Google 
Ads API v12) with the following query

SELECT
landing_page_view.unexpanded_final_url,
campaign.name,
campaign.status,
ad_group.name,
ad_group.status,
metrics.speed_score,
metrics.mobile_friendly_clicks_percentage,
metrics.clicks,
metrics.impressions,
metrics.ctr
FROM landing_page_view
WHERE
segments.date BETWEEN '2022-10-01' AND '2022-11-12'
AND
campaign.status = ENABLED
AND
ad_group.status = ENABLED

I get *7491* rows, which are the same number of rows I find in the UI 
report (see the screenshot). However, after having compared the 2 data 
frames (I'm using pandas), it seems that there are *33* rows returned by 
the API that are not found in the UI report, and I can't really explain why.

So, here are my questions

*1. Why is there a difference between the API and UI reports/data?* 

*2. What does the API do that the UI doesn't and vice-versa (for this 
specific report)? *

*3. What should I change in my query in order to reproduce exactly the UI 
report above?*

The only advice given in the Google Ads API documentation 
<https://developers.google.com/google-ads/api/docs/reporting/uireports> 
that I found regarding possible differences is that the UI implicitly 
filters REMOVED campaigns and so we should also ignore them, but, as you 
can see above, I am only selecting ENABLED campaigns, so this is not the 
problem.

Note: if I use an older GAD API version (specifically, v11), I get even 
more different results, with the same query. I get many fewer rows. *Why is 
that?*

Thanks for all the help.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/57b0981e-73ed-434c-afbf-3f42caefdbe2n%40googlegroups.com.

RE: Performance Max campaign data not returned from 'landing_page_view'

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hello Kyle,

Thanks for reaching out to the Google Ads API support. Unfortunately, the query 
you shared, over there most of the fields are not a valid field in the SELECT 
clause when “landing_page_view” is the resource in the FROM clause. Fields in 
the SELECT must be 'Selectable'. Feel free to use the Google Ads Query Builder 
for the query validation.

Could you please confirm if you are looking for Performance Max campaigns 
reporting via API? If yes then you can use GoogleAdsService.SearchStream to 
retrieve attributes and performance metrics for Performance Max campaigns 
reporting FROM campaign resource. Let me know if you have any questions.

Best regards,

Jakeia Sabrina
Google Ads API Team
ref:_00D1U1174p._5004Q2XjQDU:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/bbCeP0R805JY00cccEjQshQFyjgT1j3WyU3A%40sfdc.net.

Performance Max campaign data not returned from 'landing_page_view'

[Kyle Tremblay]

Hi,

I am trying to pull campaign-level data from 'landing_page_view', but the 
attached query is not retuning any records for Performance Max campaigns, 
despite the data existing in the Google Ads interface (Landing Pages 
report). 

I did not see anything in the documentation suggesting this data is not 
available through the API. This issue occurs when using v9 and v10 of the 
Google Ads API.

Please advise. 

Thanks,
Kyle

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/da4099d0-4368-4cb6-adc2-3a44056e0232n%40googlegroups.com.
SELECT
segments.date,
landing_page_view.unexpanded_final_url,
campaign.id,
campaign.name,
campaign.status,
ad_group.id,
ad_group.name,
ad_group.status,
campaign.advertising_channel_type,
segments.device,
metrics.impressions,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,
metrics.conversions_value
FROM landing_page_view
where segments.date between '"""+self.api_start_date+"""' and 
'"""+self.api_end_date+"""'"""

RE: landing_page_view

[Google Ads API Forum Advisor Prod]

Hi Artur,

Thanks for reaching out. In order for us to further investigate the issue you 
encountered, could you please send us the customer id and the complete GAQL 
query you used via the Reply privately to author option?

Thanks and regards,
Xiaoming, Google Ads API Team
ref:_00D1U1174p._5001UOECXr:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/6F2CK0Q2BBII00qTr98G6dTduCRUS2klWHfQ%40sfdc.net.

landing_page_view

[Artur Shalumov]

I try to get cost_micros, impressions and clicks from landing_page_view,
but i get only cost_micros, another fields = 0. In report on google`s page
i see all measures. What is the reason and how to get right values?

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/CAJN%2BFX%2BXQdoHK5_YcP8OxdAGBqEdpbM2iikXSkoNy0xR%3DBLtRw%40mail.gmail.com.

RE: landing_page_view returns invalid resource name

[Google Ads API Forum Advisor Prod]

Hi,

My name is Pierrick and I work as a Developer Advocate for Ads API.

The fix should now be live, could you give it a try?

Feel free to come back to us if any further concerns regarding this.

Regards,
Pierrick, Ads API Team
ref:_00D1U1174p._5001U8LImO:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/QysEs0Q0YR130015_pUf5zQSCIuQ3Ny2QaBw%40sfdc.net.

RE: landing_page_view returns invalid resource name

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for contacting support. Our team is already aware of this issue and 
working on to fix it. We'll get back to you as soon as we hear back from them. 
Let us know if you need any additional information.

Regards,
Nikisha Patel, Google Ads API Team
ref:_00D1U1174p._5001U8LImO:ref

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/mh02U0PUP6ON00EAoqk02gQD2fpyjsG95-vw%40sfdc.net.

landing_page_view returns invalid resource name

[Zhi]

I am using the Ads API, and trying to get the landing_page_view stats, with 
query: 

SELECT landing_page_view.unexpanded_final_url FROM landing_page_view

The results it returns contains some rows with resource_name like 
"customers/1106282/landingPageViews/-87415204586156" which has a 
'-' in the id part. And when I use this resource_name to query the item, an 
exception raised.

SELECT landing_page_view.unexpanded_final_url FROM landing_page_view WHERE 
landing_page_view.resource_name = 
"customers/110625/landingPageViews/-87415204586156"

Exception: "\'-87415204586156\' part of the resource name is invalid."

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/737e55a2-85df-4f4e-80a9-c6830a4fefb5%40googlegroups.com.