Import - Export
| 4:55 pm on Jul 9, 2007 (gmt 0)|
I'm using Google's Adwords Editor and finding it difficult to import new adgroups.
I've read the help files and it seems to be possible but I can't work it out. I get told it's an invalid file format.
Here's what I have been doing:
File > Export to CSV > Export whole account
Then I add my new terms in the exported file in exactly the same format as the existing groups
Then I try
File > Import account snapshot
I am aware that snapshot has it's own format (ie, not csv) but I can't see any other import options.
Please tell me what I am doing wrong.
| 6:51 pm on Jul 9, 2007 (gmt 0)|
You should use the following in order to update/upload campaign/adgroup/keyword,
Data --> Add/Update Multiple Keywords
Data --> Add/Update Multiple Sites
Data --> Add Multiple Text Ads
Data --> Add/Update Multiple Adgroups
You can find everything in "Data" Tab.
| 3:23 pm on Jul 10, 2007 (gmt 0)|
I tried this option and it seems only to allow limited data - ie not all the headline and decscription detail. I don't even really see the point of this method. Are you supposed to add the basics here and the finish it off elsewhere in adwords?
I am thinking more along the lines of adding a large number of adgroups in the same format as others I have originally set up. Is this possible through adwords?
[edited by: Dorian at 3:24 pm (utc) on July 10, 2007]
| 4:06 pm on Jul 10, 2007 (gmt 0)|
You cannot upload anything in the format that you download.
You need to format the spreadsheet to match the format in the Upload field. For instance, if you need to upload a bunch of keywords into many campaigns the the spreadsheet must contain the following,
Campaign, Adgroup, Keyword, Match Type, CPC, Keyword URL.
As soon as you are ready with the format you need to copy everything from the excel file excluding the HEADLINES and then paste it in the blank field (Data --> Add/Update Multiple Keywrods). Remember to select the second radio button if your keywords contains different campaign names and adgroup names.
| 8:38 pm on Jul 10, 2007 (gmt 0)|
To import using AdWords Editor, you must be on the tab of the type of content you are trying to import. You CAN'T import a new adgroup, its ads and keywords all at the SAME time. In this case you would first import all the new adgroups using "Add/Update Multiple Ad Groups", then your keywords (or text ads) on that tab using "Make Multiple Changes", etc.
If you are adding ads or keywords that belong to multiple ad groups and campaigns, make sure to choose that radio button before pasting in your columns of new data.
As already mentioned, each type of import has a slightly different format for the columns. It shows you an example in the box before you paste in your info.
The Import funtion under the FILE menu is only used for importing archived data, not new data. This is usually used to move your local unposted data to a new machine, or a way of keeping your old structure/campaigns safe by making backups.
Hope that helps.