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
4.8K members online now
4.8K 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
1 ACCEPTED SOLUTION

Accepted Solutions
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.

 

View solution in original post

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.