AdWords
2.4K members online now
2.4K members online now
Dive into advanced features like Remarketing, Flexible Bid Strategies, AdWords Editor, and AdWords Scripts
Guide Me
star_border
Reply

How to separate values in csv file for Structured snippets Ad extension ?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

How to separate values for structured snippets Ad extension so that we can upload it via Adwords Editor

3 Expert replyverified_user

How to separate values in csv file for Structured snippets Ad extension ?

Google Employee
# 2
Google Employee

Each value on a new line, and the whole thing enclosed in quotes, like this:

 

My header,"My value 1

My value 2

My value 3"

 

Excel and similar applications do the right thing when you export a multi-line cell to CSV. In Excel, press Ctrl+Enter (if I recall correctly) to start a new line within the current cell.

 

In general, the easiest way to figure out how to format something for import in Editor is to set up an example manually, export it to CSV, and examine the result.

Re: How to separate values in csv file for Structured snippets Ad extension ?

Rising Star
# 3
Rising Star

Hi @Aakash G,

 

Here is the screenshot, hope it will help you.

 

structured snippet ext..jpg

 

 


Regards
Archit, AdWords Rising Star, Community Profile
Did you find any helpful responses or answers to your query ? If yes, please mark it as the ‘Best Answer.’

How to separate values in csv file for Structured snippets Ad extension ?

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

It's not working 

How to separate values in csv file for Structured snippets Ad extension ?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Not working 

How to separate values in csv file for Structured snippets Ad extension ?

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

I get a single value even after using ",", ";", ":" almost everything.

I get all values in snippet value 1 and due to increased character due to all values in single field it shows error of max character limit reached.

 

Instead of getting this 

value 1 : breakfast 

value 2 : Lunch

Value 3 : Dinner 

 

I am getting 

"Value 1: Breakfast, Lunch, Dinner"

or 

"Value 1: Breakfast: Lunch: Dinner"

or 

"Value 1: Breakfast; Lunch; Dinner"

How to separate values in csv file for Structured snippets Ad extension ?

Rising Star
# 7
Rising Star

 Hi @Aakash G,

 

In the Structured snippet header column, you can add multiple headers for the same campaign/ad group.

Note: The header must be included in the list of predefined headers by Google. Also, capitalize the first letter of each header.

 

In the structured snippet values column, add multiple values separated by semicolon(with no space).

Note: The values must be appropriate to the corresponding Header.

 

If you have any issue, you can cross check by AdWords UI. 

Firstly, create a sample structured snippet extension from the Adwords UI. Then follow the steps below:

  1. Sign in to your AdWords account at https://adwords.google.com.
  2. Click the Campaigns tab.
  3. Click the Ad extensions tab.
  4. From the Edit menu, select Download spreadsheet template.
  5. Select the format for your report.
  6. Click Download.

Regards
Archit, AdWords Rising Star, Community Profile
Did you find any helpful responses or answers to your query ? If yes, please mark it as the ‘Best Answer.’

Re: How to separate values in csv file for Structured snippets Ad extension ?

[ Edited ]
Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

can you attach a screenshot of sample file ?



How to separate values in csv file for Structured snippets Ad extension ?

[ Edited ]
Top Contributor
# 9
Top Contributor

Hi Aakash,

 

In order to upload from excel file in Editor. Can you please try this

Header     Snippet Values

Brands      Nike

                Reebok

                example3

 

Do add your campaign Name and Adgroup field column as well. I told about structured snippet. Let me know if it works? Or if you need screenshot?

 

Edit: Basically you need to add all values in single column by pressing enter(alt+enter) after each value.

 

Thanks

Neha

 

 

 

Neha Gupta, AdWordsTop Contributor Follow Me: My Blog | Twitter | Google+ | LinkedIn
Did you find any helpful responses or answers to your query ? If yes, please mark it as the ‘Best Answer’

How to separate values in csv file for Structured snippets Ad extension ?

Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭

Oh, Even by calling on AdWords toll free number, They couldn't solve it.