AdWords
5K members online now
For issues or questions regarding logging in, account access, or account security
Guide Me
star_border
Reply

Expanded Text CSV Import Error Ambiguous row type?

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm on OSX, Adwords Editor 11.5.7.

Trying to do my first big import of new expanded text ads - I usually do csv imports for ad changes so I like to think I have some idea what I'm doing....but I can't figure this out.

Put the csv together, making sure to use the correct headers as per https://support.google.com/adwords/editor/answer/57747

Every single row shows up as "Ambiguous row type" in the import tool. I've tried copy/pasting as well, and the import screen recognizes my headers and looks good...but I get the same errors.

Here's what I've got for headers:

|| Campaign || Ad Group || Headline 1 || Headline 2 || Description || Path 1 || Path 2 || Final URL || Status || Label || Device Preference ||

I'm really stumped here, any ideas?

2 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Dave W
August 2016

Re: Expanded Text CSV Import Error Ambiguous row type?

Google Employee
# 4
Google Employee
There's no device preference for ETA. Drop this column and it should work. I confirmed on the your account.

View solution in original post

Re: Expanded Text CSV Import Error Ambiguous row type?

Google Employee
# 2
Google Employee
It should be Labels (plural), not Label (singular). "Label" makes it look like a shared label (editable via Shared Library) - hence the ambiguity.

Re: Expanded Text CSV Import Error Ambiguous row type?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Igor - thanks. Tried making that change but still seeing the same error.

Got rid of all of the rows except the first couple. Still getting the error. I put the file in a google sheet here: https://docs.google.com/spreadsheets/d/18Ewcy3oA6w2xbeULbOzxoKNQW0_B_0SJDPYCf383_3E/edit?usp=sharing

I really appreciate your help getting to the bottom of this - thanks!
Marked as Best Answer.
Solution
Accepted by topic author Dave W
August 2016

Re: Expanded Text CSV Import Error Ambiguous row type?

Google Employee
# 4
Google Employee
There's no device preference for ETA. Drop this column and it should work. I confirmed on the your account.

Re: Expanded Text CSV Import Error Ambiguous row type?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭
Thanks so much - all working and uploaded!

Expanded Text CSV Import Error Ambiguous row type?

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

So Adwords Editor doesn't support my own column header? 

I'm using Adwords Editor 12.1 on mac, and there is a "Ambiguous row type" error when I add my own column header.

According to instructions (https://support.google.com/adwords/editor/answer/56368?hl=en), section 2, option 2, it should be supported?

Expanded Text CSV Import Error Ambiguous row type?

Google Employee
# 7
Google Employee

I'm not sure I understand what you are trying to do. Could you show your headers and the row of data you are trying to import?

Expanded Text CSV Import Error Ambiguous row type?

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

Thanks for the quick reply!

Besides the standard AdWords Editor column headers listed in https://support.google.com/adwords/editor/answer/57747, my file contains my own column header as shown in the file: https://docs.google.com/a/google.com/spreadsheets/d/1YmR-1GXm6x5mbSeAZJr8gblz-RGJmxX0vCeGFV5Lt-Q/edi...

 

If I remove all my own headers, the import works fine. But if I add a non-standard Adwords Editor column header, it throws the above error.

Expanded Text CSV Import Error Ambiguous row type?

Google Employee
# 9
Google Employee

"Currency" is actually a known header, used for price extensions. That's what's confusing Editor - it's not sure whether the row is supposed to represent a keyword or a price extension.

 

You could give the header some other name. Or, you could do Account > Import > Paste text, copy/paste from your spreadsheet application, and then manually flip Currency header to "Not importing" (it's the last row in the drop-down).

Expanded Text CSV Import Error Ambiguous row type?

Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭

Remove "Currency" column, then it works fine! Thanks!