How to fetch "User list name" & "segments.date"

[Aarthi Ilangovan]

I am using a similar query like below for migrating Audience performance report : 

"SELECT customer.id, campaign.id,  user_list.name   FROM campaign_audience_view WHERE customer.id=<customer_id> AND segments.date DURING  LAST_30_DAYS "

I am getting the error that user_list and date fields are incompatible. I know that they are mentioned incompatible in https://developers.google.com/google-ads/api/fields/v10/ad_group_audience_view_query_builder. 

But it doesn't make sense. How am I supposed to fetch the user_list data based on date information? 

[Google Ads API Forum Advisor]

Hi Aarthi,

Thank you for posting your concern.

To answer your concern, I would suggest using the campaign_criterion.display_name field instead or adding it in the campaign_audience_view query as it can also get the user list name and to address the issue.

Let me know if you have further questions.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2bd8E5:ref

[Aarthi Ilangovan]

Thanks for the reply. 

When I used query migration tool this field was not returned. Please fix it. 

Regards

[Google Ads API Forum Advisor]

Hi Aarthi,

Thank you for reaching out to us.

For our team to further investigate the issue you are encountering, could you please provide to us the complete API logs(request and response with request-id ) generated on your end so our team can further check it?

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2bd8E5:ref

[Aarthi Ilangovan]

Hi, 

I used the suggested field campaign_criterion.display_name,  but I can see only uservertical and boomuserlist. How to fetch the exact userlist name like Apparel & Accessories, Autos & Vehicles etc. 

thanks

On Wednesday, June 8, 2022 at 3:58:03 AM UTC+2 adsapi wrote:

[Google Ads API Forum Advisor]

Hi Aarthi,

Thank you for the reply. Could you confirm if you really want to get a userlist name? I asked this because the criterion is the user's interests. With this, if you indeed want to get a user interest name then you can use this user_interest report including the user_interest.name.

Best regards,

Jinky Google Ads API Team

ref:_00D1U1174p._5004Q2bd8E5:ref

[Aarthi Ilangovan]

I want to fetch the below columns : 

customer id 

campaign id 

user list name 

day 

bid modifier 

is restrict 

Previously used to fetch all these columns from single report : Audience performance report 

When I used query migration tool , it suggests :  campaign_audience_view 

I am using instead of user list name , campaign_criterion.display_name as suggested. But it does not give user list name but only values like "uservertical:" and "boomuserlist:"

How to fetch all the above columns I mentioned above from a single report like before. 

[Google Ads API Forum Advisor]

Hello Aarthi,

Thanks for replying back to us. The resource name has been changed to the following mapping from the AdWords API reports to the corresponding Google Ads API resources.
With regards to your concern, the AUDIENCE_PERFORMANCE_REPORT details can be found in the Google Ads API from the “campaign_audience_view”, “ad_group_audience_view” reports.

Hope this information helps. Feel free to let us know if you have any further questions.

Best Regards,

Jakeia Google Ads API Team

 

ref:_00D1U1174p._5004Q2bd8E5:ref

[Google Ads API Forum Advisor]

Hi Aarthi,

Thank you for providing more details to your concern. To further check the issue, would you be able to provide the complete request and response logs with request ID and request header generated on your end for the report that is using the campaign_criterion.display_name and for the report that is using user_list.name?

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2bd8E5:ref