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

Extra quotation marks appearing in product title

Follower ✭ ✭ ✭
# 1
Follower ✭ ✭ ✭

My product title includes a dimension, e.g., 9" Nails. When I create the feed in Excel, that is how I enter the title, but when I save the file with a .txt extension, extra quotation marks appear and the title gets converted to "9"" Nails". And that is how it appears in my ads. How should I enter the data in Excel so the extra quotation marks don't get added?

 

Thank you.

1 Expert replyverified_user
Marked as Best Answer.
Solution
Accepted by topic author onbeta
September 2015

Re: Extra quotation marks appearing in product title

[ Edited ]
Top Contributor
# 2
Top Contributor

 

a few possibilities --

(1) simply spell-out the information for clarity (9 inch);

(2) use char(34) to insert the double-quote;

(3) escape the double-quote with a double-quote;

(4) use a macro to encapsulate the text.

 

that said, this is a better question for an excel forum.

 

as an aside, be certain to check the raw .txt file after re-saving

against the use-quoted-fields settings for the registered feed.

 

Re: Extra quotation marks appearing in product title

Follower ✭ ✭ ✭
# 3
Follower ✭ ✭ ✭
Thanks, Celebird. I thought of spelling it out, but that adds 3 unnecessary characters and further truncates the product name displayed in AdWords. I've seen other advertisers using the inch symbol in their feeds without any problems, so there must be a way to do it.

I appreciate the "quoted fields" settings tip. Google itself uses the example of "12" Teflon Frying Pan" in its explanation: https://support.google.com/merchants/answer/160037?hl=en

I clicked "yes" for "use quoted fields" and hopefully that will work. Thanks!

Re: Extra quotation marks appearing in product title

[ Edited ]
Top Contributor
# 4
Top Contributor

first, you're welcome.

importantly, do not use microsoft special quotes
or other similar symbols when submitting data --
that can cause other unexpected issues.

yes, use-quoted-field settings helps if the
data is quoted using plain (u.s. ascii) text.