how to extract segments.product_brand column

[digitalreachpremium premium]

i try to extract segments.product_brand column with campaign , ad group , ad group ad etc, but getting the error message " PROHIBITED_SEGMENT_IN_SELECT_OR_WHERE_CLAUSE", under which resource i can extract   segments.product_brand data

[Google Ads API Forum Advisor]

Hi,

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

I would like to inform you that you cannot get the segments.product_brand field with the campaign, ad_group and ad_group_ad resources as they do not support it. It appears that you can get segments.product_brand field only with the shopping_performance_view resource. I would recommend that you refer to this Google Ads Query builder to build your query using the shopping_performance_view resource.

Hope this helps. If you have any more queries, please feel free to get back to us.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tP82m:ref" (ADR-00231290)

Thanks,
 

Google Ads API Team