Does anyone know of an excel template for creating keyword combinations?
-
I am looking for an Excel template with Macros that would allow me to drop a column of keywords next to a column of modifiers and it would build out thousands of keywords with a Macro. Can anyone drop their best SEO/SEM Excel template spreadsheet links in the comments?
-
does this help you? http://textmechanic.com/Permutation-Generator.html
-
Hmmm, that's a bit more complicated. I'm sure there's a Macro out there that can do it, but I don't know one off the top of my head.
I think this can be done without a Macro but it will take a little bit of manual work. Here's what I would do:
Place your two sets of keywords in Columns A and B. Select all of Column B and cut (ctrl+x) it. Then in Cell B1, right click, select Paste Special > Transpose. Then, move Column A down one so the list starts in Cell A2.
This will create a matrix with one set of keywords in Column A and the modifiers in Row 1.
Next, in Cell B2, enter this formula:
=$A2&" "&B$1
Copy this across all cells in the matrix and you'll have 10,000 unique keywords. You will then have to remove the formulas by copying the entire sheet, right clicking in Cell A1 and selecting Past Special > Values.
Finally, you'll have to do some manual work of cutting and pasting all the separate columns into one long column of 10k keywords.
I know this isn't exactly what you're looking for, but it's the best I can think of for know. I've updated that spreadsheet example to give you a better idea of what I mean - https://docs.google.com/spreadsheet/ccc?key=0AsNfzI57aVSXdGFKME1pamRnZkJNandZWVpoVkFXZkE
Or, if you want to send your initial set of keywords to me, I wouldn't mind giving it a shot myself. Feel free to send it to tim@prontomarketing.com.
Best,
Tim
-
Hi Tim,
Thanks so much for your response. To be more clear, I would have a row of 100 keywords in column A, and 100 keywords in column B. I would like each of the 100 keywords in column A to be combined with each of the keywords in column B giving me 10,000 keywords.
-
If I'm correctly understanding your goal here, I think this can be accomplished by just using an Excel formula. You shouldn't need a Macro to combine two columns.
Place your keywords in Column A and the modifiers in Column B. Then, in Column C, enter the following formula:
=A1&" "&B1
Copy this formula down the list and it will combine the contents of the two cells separated by a space. Here's an example I put together in Google Docs: https://docs.google.com/spreadsheet/ccc?key=0AsNfzI57aVSXdGFKME1pamRnZkJNandZWVpoVkFXZkE
Hope this helps!
Tim
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
Managing negative keywords when multi ad groups trigger for same keyword
Hi Mozzers, I have a lot of ad groups - hundreds! Without negative keywords, multiple ad groups in my campaign could trigger for the same keyword. For example, a search for crm software could trigger the following ad groups: Ad group 1 (the ad group I want to trigger) - CRM Software
Paid Search Marketing | | Zoope
Ad group 2 - Best CRM Software
Ad group 3 - CRM Software Solutions
Ad group 4 - CRM Software for Small Business
etc. So I handle this situation by negative keyword matching the words 'CRM Software' in ad groups 2, 3 and 4. However, this is a very manual and laborious activity when I have 900+ keywords in my campaign, with 150+ ad groups. Does anybody know of any tools that might automate this process, or any techniques for making the process easier and more accurate? Thanks!0 -
Locate Poorly Trending Keywords in AdWords
At the campaign level I see my CTR has been suffering for the last week or two relative to the past few months. It could be a few bad actors casing the downward trend. How can I quickly and easily locate specific keywords that are trending in the wrong direction? Why filters will not work... They don't take change into account. I want to identify Keywords that were once doing well are now doing poorly. Filters will yield all keywords that are doing poorly which is not what I'm looking for. Obviously I could be missing something with filters but this is my understanding. A few other points to note... I have search partners turned on. I do not want to take this traffic into account in my analysis. I'd also like to determine if it might be an ad that's not performing as well as it once was. I assume the same method used to find poorly trending keywords can be applied to ads as well but if not, is there a solution for this?
Paid Search Marketing | | tatermarketing0 -
Negative Keyword Help
I am working on compiling a list of both broad and phrase-matched negative keywords for my AdWords campaigns, but I feel like I am encountering a problem. We offer payment gateway services and business owners often search terms including online payment gateway, Internet payment gateway, credit card payment gateway, etc to see our ads. However, we have been getting bad leads from consumers searching for terms such as online payment, online payments, online bill pay, and various other phrases regarding consumers paying their bills online. We work specifically with business owners who want to accept payments and NOT consumers who want to make payments. Here is my dilemma: If I have "online payment gateway" or [online payment gateway] as keywords as well as "online payment" or "online payments" as negative keywords, then I will be blocking business owners from seeing my ads when they search the term online payment gateway. Correct? Is there any way to get around this? Am I wrong?
Paid Search Marketing | | Instabill0 -
Adwords keyword vs exact match kw
Hi guys, I have been using an excellent script that showed me the keywords I was bidding on and the keywords they were matched on by Adwords. I was using the following script: http://www.getelastic.com/exact-keywords-google-analytics/ But I'm under the impression Google changed the way these data can be matched. I now have multiple questions: Does anyone have another script that gives me the same results? Has anyone seen an announcement on why Google has changed this? Might this js solution still be working? http://www.roirevolution.com/blog/2008/02/exact_keyword_tracking_with_gajs.php Cheers and thanks for all the suggestions! Arnout
Paid Search Marketing | | hellemans0 -
Branded & Non-Branded Keywords
Dear experts, I've setup my Branded & Non-Branded keywords in my website campaign for KanaryLuxuryWatches.com But I feel that this is not enough, I need SEOMOZ to extract the powerful and most important keywords for me then analyze it. How this can be done then? Regards, Kanary
Paid Search Marketing | | kanary0 -
PPC : Do I have to create differents Adwords account for my 2 companies?
Hello Mozers, I have 2 small companies in 2 different fields (tourism and IT). Do I have to create 2 different accounts for my Adwords campaigns? Is it the good way of proceeding? Thank you for yours answers guys, Jonathan
Paid Search Marketing | | JonathanLeplang0 -
Keyword Domains for PPC
I have a client who wants to buy a lot of long domains with keywords in them, for example, thesandiegopetstore.com (this is fictional) and then set up a PPC landing page for each. They think that when someone types in "san diego pet store" that their domain will be listed high and then they will get a lot of traffic. My concern is that they will own a lot of domains for their company and I thought Google is getting pretty adamant about companies not having a lot of domains, and I thought that keyword domains are not as effective as they used to be -- that branding is more important now. Also, I think the domains they've picked target very competitive keywords and that perhaps they will get a lot unqualified traffic and will still have to pay for the clicks. What do you think? What is the best way to set up PPC landing pages?
Paid Search Marketing | | klkirby0 -
Which of these six keyword combinations would you go after?
I you could only optimize for one, SEO, which keyword phrase would you select and why? Going by the data I've attached with the two images. QMbkq.png 2ufnF.png
Paid Search Marketing | | bobjones0