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
-
Special Characters in Negative Keywords in Ads
Howdy, fellow mozzers, I came across this weird suggestion in my Bing account (screenshot link: https://dmitrii-regexseo.tinytake.com/tt/NDY3OTc5NF8xNDgyMzY4OA) It almost that the dollar sign in the negative keyword is acting like a wildcard character, or being disregarded completely. I did some tests, it seems that in Google Ads that is not happening. Does anyone have an idea if this is normal behavior? I have never seen this before.
Paid Search Marketing | | DmitriiK0 -
Are there free tools that would tell me the cpc for my keywords?
If not what tools do you recommend to use to get an accurate cpc $ for estimating budget?
Paid Search Marketing | | lina_digital0 -
PPC Keyword list
Hi Im embarking on a PPC campaign targeting one single product that we sell. I am compiling a key word list just now and was just wondering if there is a maximum number of keywords i should be looking to target for this? Thanks in advance
Paid Search Marketing | | TheZenAgency0 -
Has anyone used Adroll (Facebook retargeting)with any success?
Hello! I am wondering if anyone out there has had a good experience with Adroll. I set up a campaign a couple months ago, but have yet to see any return on my investment. I'm now considering stopping this service because it seems to not be living up to its hype. What has your experience in using this service?
Paid Search Marketing | | Gordian0 -
Is there any reason to add the word "buy" to our Adwords keywords?
Was having a discussion with someone so I am going to write this up as neutral as possible and let you guys decide. We have a large keyword list and they are all setup as phrase. Should we go back and add the word buy in front of all those keywords? Even though they are setup as phrase already. Example: "Widget" (as a phrase) Should we go back and add "Buy Widget" as a keyword?
Paid Search Marketing | | EcommerceSite0 -
targeting different keywords for site
A site i am working on seakayakingdevon.co.uk, currently optimising for sea kayaking wishes to target alternative keywords such as - canoeing, canoe trips etc. more importantly rank higher than a dedicated local canoeing center site. The issue is he provides kayaking trips and courses and not canoeing but believes a a large percent of his targeted market actual mistakenly searches for canoeing when they actually mean kayaking or simply have no preference - i.e kayaks are often confused with canoes especially with people who have no preference but are more inclined to search using terms related to canoeing, canoe day trip etc. As his site is geared to what he actually provides, I have advised that he would struggle to target such terms as he has no content relating to canoeing and risks the overall ranking positions and SEO efforts for sea kayaking terms.( As these would have to be diluted and would no longer relate to the actual page content.) What method could he deploy without sacrificing the sea kayaking optimisation? I realise he could optimise the site and content for both but question just how successful this would be when compared with the loss of dedicated sea kayaking audience. Is it really worth targeting keywords for service he doesn't provide? On a separate note the site is doing reasonably well since optmisation for localised serch terms but would like to target a wider UK audience as well i.e. tourism to the area. thanks
Paid Search Marketing | | Bristolweb0 -
Multiple keyword match types - same ad group, or separate ad groups?
Hi guys, Looking at an account that has historically used broad matching, and i'd now like to take some of the better performing keywords and duplicate as phrase and/or exact match to increase the quality of traffic to the landing pages. I know I can add red shoes, "red shoes" and [red shoes] to the same ad group, however I've also read that people are creating separate groups for each match type. Other than easy of management (same group), or more granular targeting of ads (separate groups), should I go with either approach, or a blend of the two? My key objective in this restructure is to drop the currently high bounce rate on the landing pages by improving the relevance of the incoming traffic. Cheers, Jez
Paid Search Marketing | | jez0000 -
Curious about Adwords keyword tool results.
Why the Google Adwords Keywords tool says there are 0 local monthly searches for a keyword or shows a dash, but in spite of this there's competition for those keywords (up to 0.42 in some cases) ? Thanks!!
Paid Search Marketing | | gerardoH0