Difference in reports between Google Ads UI and API

[Can Kivanc]

Hi,

We want to get expanded_landing_page_view.expanded_final_url via api but number of urls that we get via api doesn't match with Google Ads ui.

Here is the query:

 SELECT
                segments.date,
                metrics.clicks,
                ad_group.status,
                campaign.status,
                campaign.end_date,
                expanded_landing_page_view.expanded_final_url,
                expanded_landing_page_view.resource_name
               
            FROM expanded_landing_page_view
           
            WHERE
                 campaign.status = 'ENABLED'
                 AND campaign.end_date >= '${LocalDate.now()}'
                 AND ad_group.status = 'ENABLED'
                 AND segments.date DURING LAST_30_DAYS  

You can see screen shot below from Google Ads Interface

The filters and the time range are the same with the query.

What might the reason for difference in #URLs being reported?

Want we want to get is all URLs that are being used in campaigns.

Thanks in advance,

Can

[Google Ads API Forum Advisor]

Hi Can,

Thanks for reaching out to Google Ads API Support.

I see that you have concerns regarding getting the expanded_landing_page_view.expanded_final_url. Can you provide the following information regarding your concern?

• Complete request and response logs with request ID generated as shown in the respective links.
• Complete screenshots (without cropping) from the Google Ads UI showing data.

We do this to check if there’s an error thrown on your side and we can further investigate. 

If you haven't enabled logging yet, it can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. For REST interface requests, you can enable logging via the curl command by using the -i flag. This will cause the tool to include the HTTP response headers in the output.

You may then send the requested logs via the Reply privately to author option. If the reply privately option is not available, you can send your logs directly to our googleadsa...@google.com alias instead.

Regards,

Google Ads API Team

ref:_00D1U1174p._5004Q2jXGox:ref