Moz Q&A is closed.
After more than 13 years, and tens of thousands of questions, Moz Q&A closed on 12th December 2024. Whilst we’re not completely removing the content - many posts will still be possible to view - we have locked both new posts and new replies. More details here.
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 [email protected].
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
-
Unsolved How should I update the grouping of keywords in a google ads account
hi, I have a google adwords account running for a while in a fairly competitive market in a major city so there is only one geo location with many suburbs or council areas as popular searched. I have keywords that are 2-4 words long and very similar. I have had one keyword in its own campaign, several in one campaign and a location campaign. The location campaign has several adgroups for specific suburbs. My question is that the most popular search terms are similar but in different campaigns and I am wondering if this is not the best way. for example I have these keywords in separate campaigns as exact match and phrase match
Paid Search Marketing | | salliWW
rubbish removal
rubbish removal near me
rubbish removal Washington But the way google uses exact match seems to be changing and I am concerned these would be best in one adgroup. Also these keywords trigger similar phrases, for example, waste removal. Is it best to put them in one campaign with one ad group or one campaign with separate adgroups, or leave as is. As competition has increased I need to bid for top of page now and need to keep budget rises as little as possible..0 -
How to know competitors keywords for adwords
I want to run google campaign for adwords and I want to target keywords that my competitor is ranking for. How can I know what are the keywords that are helping my competitors the most. Is there some way so that I can know what my competitor is bidding for those keywords. I heard it also depends on the landing page quality. Please suggest the best strategy to run adwords at lower cost and yet perform well. I am willing to run campaign for this website . It is basically meant to connect manufacturers representatives and independent sales reps to businesses. Any suggestions are welcome.
Paid Search Marketing | | HelloWorld20200 -
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 -
Adwords Duplicate Keywords with Different Match Types - Good or Bad?
If you have the following keywords in an Ad Group advertising for a product, let's for example call it "target" product [target product] "target product" +target +product I've found that the exact match keyword has the highest conversion rate in almost all circumstances. So it would make sense to have a higher max bid on the exact match then phrase or broad batch. Even with lots of negative search terms to maximize conversion on the broader matches, if the bid is the same as exact match, the cost per conversion will be much higher (too high.) However in chatting with an Adwords Support Rep (on a different matter) they stated after looking through my account at the end of the chat: " duplicate keywords will impact on quality score. your all keywords will compete with each other" However many of the ad groups in question these duplicate keywords have quality score of 9 and 10. So obviously if there is an effect it seems it may be minimal. I thought it was pretty common for people to bid higher on more exact match and lower on more broad match. What's the real story here? Was this support rep not seeing the big picture?
Paid Search Marketing | | JCCMoz1 -
Adwords negative keywords / keyword lists conflicting?
Does any of you had any experience on large 5k+ shared negative keyword lists impacting normal campaign negative keywords in Adwords even if they are not selected on these campaigns? And a second question; does anyone know how selected negative keyword lists can be removed from a campaign? I seem to be able to add them but not to remove them... Cheers!
Paid Search Marketing | | hellemans0 -
Arabic Keyword Research
Hi All, Can anyone recommend good SEOs who specialise in Arabic? I've had my client's website translated into Arabic but the translation company do not specialise in local keyword research. They've translated literally I think (obviously not being an Arabic speaker, I can't confirm this). I need someone to review the translated site (only 4 pages so far), with a marketing head on, and ensure it includes the relevant local keywords used in UAE countries. Will also require deeper keyword research for a Google.ae PPC campaign and Ad copy written in Arabic. If I fail to find someone here in the moz community I'll head over to oDesk, where I'll find everyone and their mother-in-law proclaiming to be the worlds best Arabic SEO 😕
Paid Search Marketing | | seowoody
I like recommendations! Thanks, Woody 🙂0 -
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 -
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