REMOVED user_list is not returned when queried

[vla...@gmail.com]

If the user_List is Enabled it is returned, if it is Removed it's not returned

Query:

`SELECT user_list.name, user_list.resource_name, user_list.rule_based_user_list.expression_rule_user_list.rule.rule_type, user_list.rule_based_user_list.expression_rule_user_list.rule.rule_item_groups, user_list.rule_based_user_list.prepopulation_status FROM user_list WHERE user_list.name='{userListName}'`

This is important for me because when I try to create a list with the name that already exists (but removed), the mutate `Create` operation throws an error. But when I try to retrieve it by its name, it's not found.

Please help.

[Google Ads API Forum Advisor Prod]

Hello,

Removed entities do not return in reports by default. You will need to add a condition to include them explicitly. 

Regards,
Anthony
Google Ads API Team

Anthony Google Ads API Team

ref:_00D1U1174p._5004Q23wUwz:ref

[vla...@gmail.com]

Great, what is the condition?

[vla...@gmail.com]

I tried `user_list.account_user_list_status IN ('ENABLED','DISABLED')`, that didn't help.

[Google Ads API Forum Advisor Prod]

Hi,

Please add a condition for the field user_list.membership_status. 

[vla...@gmail.com]

Sorry, still nothing. I included user_list.membership_status='CLOSED' and it returned nothing. Also tried  user_list.membership_status IN ('OPEN', 'CLOSED' ), same result.

[vla...@gmail.com]

To add, I am not sure the membership_status is relevant here. In the UI I can have enabled audiences with both Open and Closed membership status. The same goes for removed audiences - some have membership status as Open and some as Closed.

[Google Ads API Forum Advisor Prod]

Hello,

Unfortunately, there is no field to give you the status of enabled and removed audiences. I've created a feature request on your behalf. Please follow our blog for updates.