User Lists and Offline User Data Job metrics

[Daniel Vasilan]

We are building a POC in order to see how we can use Offline User Data jobs to manage User Lists for Customer Match (Python, google-ads library).

We didn't find in the docs or google groups answers on how to get execution time metrics from Google API on:

- duration, start and end date of the offline jobs executions. We can see the current status, but not when it finished, so we cannot measure the duration and adapt our strategies based on it.

- number of processed/matched records

- un-match statistics (# of not matched records / reason type).

We can see a match rate, but we don't understand why Google is not offering but very few information on this process, not even some basic ones, vital for the user processes improvement

 

If the above information is actually available, let us know where we can find it.

GAQL is preferable, but other API endpoint or even UI can help.

Thanks!

[Google Ads API Forum Advisor]

Hi,

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

By reviewing your concern, I understand that you are looking for guidance on how to retrieve the execution time metrics and other fields from the offline_user_data_job resource. Kindly note that for retrieving the status of your job that has been executed, I would recommend you to kindly refer to the below GAQL query:

SELECT offline_user_data_job.customer_match_user_list_metadata.user_list, offline_user_data_job.external_id,offline_user_data_job.failure_reason,offline_user_data_job.id,offline_user_data_job.operation_metadata.match_rate_range,offline_user_data_job.resource_name,offline_user_data_job.status,offline_user_data_job.store_sales_metadata.loyalty_fraction,offline_user_data_job.store_sales_metadata.third_party_metadata.advertiser_upload_date_time,offline_user_data_job.store_sales_metadata.third_party_metadata.bridge_map_version_id,offline_user_data_job.store_sales_metadata.third_party_metadata.partner_id,offline_user_data_job.store_sales_metadata.third_party_metadata.partner_match_fraction,offline_user_data_job.store_sales_metadata.third_party_metadata.valid_transaction_fraction,offline_user_data_job.store_sales_metadata.third_party_metadata.partner_upload_fraction,offline_user_data_job.store_sales_metadata.transaction_upload_fraction,offline_user_data_job.type, offline_user_data_job.operation_metadata.match_rate_range FROM offline_user_data_job WHERE offline_user_data_job.id={offline_user_data_job.id}

Could you kindly confirm if you are able to retrieve the execution time metrics and other fields from the Google Ads UI? If yes, kindly provide us the UI screenshot of the Google Ads account (with visible customer ID) and also highlight the fields and metrics that you are trying to retrieve via the API.

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02rytex:ref"

Thanks,
 

Google Ads API Team

[Daniel Vasilan]

Hi,

Your reply contains a GAQL on the offline_user_data_job with all the fields.

Can you extract me the field(s) which are showing me the duration and/or end date(time) of the job ?

We don't see any field for this purpose

Thanks

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

By reviewing your concern, I understand that you are looking for guidance on how to retrieve the duration and end date(time) of fields from the job.

I would recommend that you reach out to the Google Ads Product Support team to check whether the Duration, startDate and endDate fields of the offline jobs are available in the Google Ads UI or not.

[Daniel Vasilan]

This information is not present in the UI.

And I understand from your answers that it cannot be retrieved using APIs/GAQL, neither.

I'm sure this information is internally stored by Google (start/ end metadata for processes is something really basic in any system), 

so I would like to see it exposed. 

My two cents: Probably Google doesn't want to expose jobs durations because these offline jobs runs for ages and these metrics would make this "performance" official

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

Kindly note that I will raise a request for these metrics to become available in the Google Ads API, however this is subject for review. So, I cannot provide a scheduled timeline for their availability in the API. I would recommend you to follow our Blog Post and Release Notes for future updates.