Are you a Google Analytics enthusiast?
More SEO Content
Using Microsoft Excel To Manage Keywords
Posted 02 October 2003 - 12:54 PM
I like to use Excel to keep track of keywords for PPC campaigns. Each keyword in its own cell, row. When it comes time to cut and paste them over to Google, I run into a problem. How can I automatically encapsulate all my keywords in quotes? This is for "phrase matching" purposes. Doing it by hand is a major pain in the arse. Is their an easy way to do this?? I have searched high and low, and can't seem to find it, if it exists.
The only thing I can think of would be to create a script that formats the cell using regular expressions to add the quotes on either end of each cell. Of course I am not even sure how to get started doing this in Excel, so I would probably have to take my keyword list and run it through a vbscript application. Arg!
Posted 02 October 2003 - 01:09 PM
Posted 02 October 2003 - 01:14 PM
Posted 02 October 2003 - 01:21 PM
Posted 02 October 2003 - 01:23 PM
Posted 02 October 2003 - 02:30 PM
Posted 02 October 2003 - 06:53 PM
I agree with you...I use the exporting to CSV tactic as well.
Posted 04 October 2003 - 01:16 PM
Have you tried saving the file as a text file seperating with comma's?
Posted 04 October 2003 - 04:54 PM
For example, if you have:
and hit 'create permutations' it spits out:
search engine optimisation
optmisation search engine
"search engine optimisation"
"optimisation search engine"
[search engine optimisation]
[optimisation search engine]
In a list you can then copy and paste into Excel or straight into adwords. It's very useful for longer lists.
Still requires some manual editing (of course), but it certainly saves a lot of effort.
To create the initial list in Excel, you merely place each element in a cell, and then save as a csv file. For the example above, search engine would be in one field and optimisation in the next. If you had search and engine in separate cells, then it would also produce engine optimisation search - which you wouldn't want to use (well, probably not).
Would anyone else find this useful if we were to put it on our site for anyone to access?
Posted 10 October 2003 - 06:28 PM
Yes, I would like to see it. I think this is a great idea for a few keywords, but could get out of hand with 20 or so. Am I right?
[Would anyone else find this useful if we were to put it on our site for anyone to access?]
Posted 03 November 2003 - 08:49 AM
1. If you are an expert in MS Visual Basic it is like a piece of cake.
2. If you are not then all you need is to record a macro (seen in Tools ->Macro) and use it. If you are interested in programming then you can edit the macro and see whats the code inside it.
Other options you know it .
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users