How to get last update date of a Customer Match UserList? Missing last_modified_time field in V19+

[Guillaume Duplessis]

Hello everyone,

I am trying to programmatically find Customer Match lists (UserList of type CRM_BASED) that have not been updated in the last 90 days. To do this, I need to retrieve the last modification or upload date for each list.

Based on previous research and forum discussions, I understand that the recommended field for this is user_list.last_modified_time, which should be available in API versions v16 and later.

However, I am facing an issue where this field seems to be missing.

What I have tried:

1. I am using the C# Client Library, specifically targeting v19 of the API (Google.Ads.GoogleAds.V19).

2. I am running the following GAQL query:

   SQL

   SELECT customer.id, user_list.resource_name, user_list.name, user_list.type, user_list.last_modified_time FROM user_list WHERE user_list.type = 'CRM_BASED'

3. When I execute this query, the API returns the following error, which indicates the field is not recognized: Google.Ads.GoogleAds.V19.Errors.GoogleAdsException: Status(StatusCode="InvalidArgument", Detail="Request contains an invalid argument.")

I have double-checked the documentation for the UserList resource that my client library seems to be using, and I cannot see the last_modified_time field listed. I have also previously looked for the older last_upload_date_time field in CrmBasedUserListInfo and it is also missing, as expected for recent versions.

My question is:

What is the correct and current method in API v19 (or later) to get the last modification/upload timestamp for a Customer Match UserList? Has this field been moved, renamed, or is there another way to access this information?

Any help or clarification would be greatly appreciated.

Thank you.

[Google Ads API Forum Advisor]

Hi,

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

From the provided information, you are encountering an InvalidArgument error because the user_list.last_modified_time field is not available for direct querying in the Google Ads API's user_list resource. In order to assist further, can you confirm whether your requirement is possible to do from the Google Ads UI? If yes, I would request you to provide an uncropped UI screenshot of the Google Ads account (with visible customer ID) by highlighting the field which you want to retrieve through the Google Ads API so that we can assist you with a query.

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

Thanks,
 

Google Ads API Team

Feedback
How was our support today?

               
[2025-06-24 19:44:31Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01rg8TQ:ref" (ADR-00315557)