AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
2.9K members online now
2.9K members online now
For questions related to Google Shopping and Merchant Center. Learn to optimize your Shopping ads
Guide Me
star_border
Reply

CSV example of using "cutom lable 0-4" in Google Products Feed

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi.

 

I want to use custom label in my feed (CSV format) but i am confused.

 

My actual feed format is (IT IS EDITABLE): https://docs.google.com/spreadsheets/d/1MqD-5_-5gDMkRXgvDUSTMPUtQc-wMWtnUNEm-2w2BuU/edit?usp=sharing

 

How can i use multiple value per product?
I need to use separately feed for custom labels?

Witch is the right .csv format (if you can share a example).

 

Many many thanks.

2 Expert replyverified_user

Re: CSV example of using "cutom lable 0-4" in Google Products Feed

[ Edited ]
Top Contributor
# 2
Top Contributor

(1) for two values, simply add two custom label attributes --

for example, custom_label_0 and custom_label_1
(2) no; a separate feed is not needed;
(3) .csv is not supported for the merchant-center --
for a spreadsheet, or google-sheet, simply
add a new column, with the attribute name.

 

simply add a column, labeled:
custom_label_0

 

a separate feed is not needed -- use the same feed for all

physical inventory items submitted, for up to 100,000 items.

 

google does not support csv files -- the spreadsheet must be

either saved as tab-delimited or registered as a google-sheet.

 

only one, single, value is allowed per custom-label attribute.

 

up to 1,000 different values may be added for
the entire inventory, for each custom-label.

 

custom-labels are mainly used to create sets of products;
for example, a single label for all low-margin items --
with a custom-label value of low-margin, on all such items;
that way, all low-margin items can be bid on as a set/group.

 

with 1000 values allowed, per label, 1000 sets may be created --

1,000 sets should be more than enough for most all use-cases.

 

if a single item is in multiple sets, then simply
add the other custom-label attributes/columns; e.g.
custom_label_1
custom_label_2
custom_label_3
custom_label_4

for example, if an item is in the set of all low-margin
items and also in the set of all summer-sale items.

 

importantly perhaps, google does not support csv files --

the file must be either a google-sheet or tab-delimited.

 

as an aside, a best-practice is to use a mix of both
numbers and letters for id -- not just a number; e.g.
abc123
id should be permanently assigned to a physical item.

 

see also
https://support.google.com/merchants/answer/7052112#custom_label

https://support.google.com/merchants/answer/160567
https://support.google.com/merchants/answer/6324473

CSV example of using "cutom lable 0-4" in Google Products Feed

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Many many Thanks.

 

I understand about adding labels, but, how can i add up to 1,000 different values for each custom-label?

 

I need additional feed for this? 

 

I added custom label but how to Create up to 1,000 unique labels for each custom label attribute?

 

Thnak you.

CSV example of using "cutom lable 0-4" in Google Products Feed

[ Edited ]
Top Contributor
# 4
Top Contributor

I think you misunderstood.

 

Each custom label cell can only have 1 value.

 

So if you have 5 products with 5 unique custom label values, it counts towards the total 1000 unique labels for the given custom label level.

 

For example, you can have 100 products, with 50 unique values, etc...

 

You can not have 1 product with 1000 custom label values. You can only have up to 5 separate as followed

 

custom label 0

custom label 1

custom label 2

custom label 3

custom label 4

 

You just add the columns in your primary feed and add the values in the cells of that given product.

 

More info regarding custom labels can be found here: https://support.google.com/merchants/answer/6324473

 

Hope this helps.

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’

CSV example of using "cutom lable 0-4" in Google Products Feed

[ Edited ]
Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

OK. Thank you Emmanuel.

 

But how can i Create up to 1,000 unique labels for each custom label attribute?

 

I just don't know how to add values for custom_label_0 for ex.

 

My example:

  • Custom_label_0: price (values: $9-$49 / $50-$99 / $100-$199 / $200 )
  • Custom_label_1: margin (values: 20% / 21%-30% / 50%)

Thank you.

CSV example of using "cutom lable 0-4" in Google Products Feed

Top Contributor
# 6
Top Contributor

Your misunderstanding the concept of custom labels.

 

Each value you submit ie a cell value, is 1 unique label.

 

So your submitted value highlighted in bold, is 1 custom label. $9-$49 / $50-$99 / $100-$199 / $200 

 

adding dashes, hyphens, commas etc.. do not create unique values. It is viewed as 1 value. Do not get confused with requirements with regards to color, material, pattern etc....

 

So to explain with two examples, the below examples are both 1 unique label value each, bringing it to a total of 2 unique total account level values.

 

$9-$49 / $50-$99 / $100-$199 / $200

 

$9-$49

 

You can not add more than one value per custom label.

 

 

Hope this helps.

 

 

Twitter | Linkedin | Community Profile | Shopping Feed Tips From FeedArmy
Did you find any helpful responses or answers to your query? If yes, please click on ‘Accept As Solution’

CSV example of using "cutom lable 0-4" in Google Products Feed

[ Edited ]
Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

Thank you Emmanuel.

 

And also thank you for your video tutorial: https://feedarmy.com/kb/google-shopping-custom-labels-for-adwords/

 

P.S. I know that on google documentation CSV format is not supported, but, in my case, file extension is .CSV and i can send you a copy.

I sync it trough FTP with GMC.