shopping performance report, CategoryL1, CategoryL2, CategoryL3, CategoryL4 and CategoryL5 fields

50 views

Skip to first unread message

Golnoush Lotfi

unread,

Aug 21, 2019, 12:50:02 PM8/21/19

to AdWords API and Google Ads API Forum

In shopping performance report the following attributes return string:

CategoryL1, CategoryL2, CategoryL3, CategoryL4 and CategoryL5

While the equivalent fields in Google ads return RESOURCE_NAME:

(segments.product_custom_attribute0,segments.product_custom_attribute1,segments.product_custom_attribute2,segments.product_custom_attribute3,segments.product_custom_attribute4).

We are using these five fields in our report. So, in order to get the same results as Adwords, we have to call ProductBiddingCategoryConstantServiceClient, using these RESOURCE_NAMEs and get localized_name. Which means 5 more calls for each row of report to have the same result as Adwords.

I was wondering, if there is any other efficient way, to get the same result?

Thanks,

Golnoush

Google Ads API Forum Advisor Prod

unread,

Aug 22, 2019, 4:34:26 PM8/22/19

to golnous...@gmail.com, adwor...@googlegroups.com

Hi Golnoush,

Thank you for reaching support. You could get the values for the required fields using the product_bidding_category_constant resource in Google Ads API. Please find below the sample query to get the product bidding category constant name and the category level along with the resource name:
SELECT product_bidding_category_constant.localized_name, product_bidding_category_constant.resource_name, product_bidding_category_constant.level FROM product_bidding_category_constant LIMIT 100
Additionally, please refer to this code sample to get the set of product bidding categories. Let us know if you need additional information.

Regards,
Nikisha Patel, Google Ads API Team