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

Google Adwords Bulk Upload Error

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm trying to upload the Google adwords in bulk, but received the following messages:

 

  • The value 'Google Search' in column 'Campaign type' is invalid.
  • The value 'Manual CPC' in column 'Bid strategy type' is invalid.

This row is not formatted properly.    No change --    --    --    
Unable to determine the entity-type of this row. Make sure to only provide fields for columns that are appropriate for the entity.

 

I'm following the guidelines here:

 

https://support.google.com/adwords/editor/answer/57747

 

Did Google updated this list?

 

Please help me how to fix it.

 

thanks!

1 Expert replyverified_user

Re: Google Adwords Bulk Upload Error

Google Employee
# 2
Google Employee
Could you show a sample of the data you are trying to import?

The documentation for Campaign Type is wrong; we'll get it updated. It confuses two separate columns. One is Campaign Type with possible values of

Search Network Only
Search Network with Display Select
Display Network Only
Shopping
Display Network Only-Mobile app installs
Video

The other is Networks, which is a semicolon-separated list of one or more of these tokens: Google Search;Search Partners;Search;Display;YouTube Search;YouTube Videos;Video Parnters. Not all combinations are meaningful, and those that are, are mostly redundant with Campaign Type (but not entirely - Search Partners and the three video campaign-related options can only be specified in Networks).

It's a bit of a mess, quite frankly; it exists mostly for historical reasons. Anyway, in your case you probably want Search Network Only in Campaign Type, and not use Networks.

Manual CPC should be a valid value for Bid Strategy Type column. To tell more, I'd need to see the actual data.

Re: Google Adwords Bulk Upload Error

Participant ✭ ☆ ☆
# 3
Participant ✭ ☆ ☆
Hi Vita,

I will recommend to upload your campaign step by step if you are getting error during uploading all campaign, ad groups, keywords, ads and campaign setting.

Step 1 - Upload Keywords first with

Campaign / Ad Groups / Keywords / Match Type / Max CPC

Text Ads

Campaign / Ad Groups / Headline / D1 / D2 / Display URL / Final URL / Mobile URL

After that you can change the campaign setting and ad groups level biding method, Target location, if you are uploading display campaign then you can also upload banner ads in Ad Groups.

I always upload my campaign as per the given steps.

Please let us know if you have any query.

Thanks,
Anand

Re: Google Adwords Bulk Upload Error

Google Employee
# 4
Google Employee
I'd like to add - the easiest way to figure out how to format your data for import in Editor is as follows: set up a sample campaign in Editor manually just the way you would like your real campaigns to be, then export it to CSV and eyeball the result. This would generally give you a good idea how various features are represented.

Re: Google Adwords Bulk Upload Error

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hello,

 

I'm also trying do to a bulk upload because it takes to much time to make so many specific ads using a browser.
I downloaded an example file from here:
https://support.google.com/adwords/editor/answer/56368?hl=en
(clicked on the "sample CSV file" link)

The file gives errors which I am trying to fix to understand the correct syntax.

I still get an error at the first line:
"The value 'Search Network Only' in column 'Campaign type' is invalid."
Campaign type doesn't seem to work with anything. I tried Search, Google Search and Search Network Only.

 

I uploaded my .csv file here:

http://www.filedropper.com/test_130

 

Any help is appreciated. I am a bit disappointed that google's documentation is broken.

 

Kind regards,

Marius

 

Re: Google Adwords Bulk Upload Error

Google Employee
# 6
Google Employee
Strange. Your file works just fine for me (except that "Sitelink text" column is not recognized; it should be "Link text"; we'd need to fix the sample). 'Search Network Only' is in fact a valid value for 'Campaign type' column; it should be recognized, and it is for me.

Could you share a screenshot of the final page of the import dialog, the one with imported entity counts and the error messages?

Re: Google Adwords Bulk Upload Error

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭
Ohh, very strange then.

I have uploaded a word document where I paste all the errors.
http://www.filedropper.com/bulkuploadsresult

I am trying to do this online at https://adwords.google.com which should mean that I am using the latest version of AdWords as it is a web based application not windows executable. I am using a "...@yahoo.com" e-mail to log into the account instead of a "...@gmail.com" email (it is because I use the business owner's e-mail address to do his work). I'll try uploading it on my own AdWords account when I get home. Now I need to go to work (I'm GMT +0).

Kind regards,
Marius

Re: Google Adwords Bulk Upload Error

Google Employee
# 8
Google Employee
Ah, I think I understand the source of the confusion now. It appears that you are *not*, in fact, using AdWords Editor (a desktop application for managing your AdWords accounts; https://www.google.com/adwordseditor/ ), but are instead using bulk upload feature of the online interface. The same is likely true of @vita, the original poster.

The documentation both of you are looking at is for Editor (the tell-tale sign is /editor/ part of the URL). For better or worse (probably for worse), bulk upload is designed and implemented independently, by a separate team of people, with no reference to Editor's design. Any similarities between the two formats are accidental.

This is the documentation for bulk upload feature: https://support.google.com/adwords/answer/2477116 .

Re: Google Adwords Bulk Upload Error

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭
Ohh, I see...
Thanks very much for clearing it up.

Kind regards,
Marius