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
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 -
Keyword Quality Score is 8/10
Hi, I have few keywords in my Adwords search campaign with quality score 8/10. When I checked everything is above average like 1>Ad relevance 2> Landing Page Experience 3> Expected click through rate.to If everything is above average what to improve to get quality score 10/10?? I'm using most of the ad extension Thanks
Paid Search Marketing | | Alick3000 -
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 -
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 -
Does anyone know if there are any adwords guideline restrictions against naming a product with the term "Clinically Proven?"
If you do a search for something like "protein powder" there are the sponsored ads where you can shop. Does anyone know if there are any guidelines against naming a product with "Clinically Proven." For example, "Clinically Proven Protein Powder." Any guidance, insight, or links helping to answer this question would be appreciated.
Paid Search Marketing | | jbmac0 -
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 -
Adwords Keyword Quality Score changes when keyword is paused
Today I was pausing a bunch of low quality score keywords for a client, the thing is, once I paused the keywords, the quality score would immediately change. For example, a number of keywords that had a QS of 3 while they were running, immediately changed to 1 once paused. Out of curiosity I un-paused one of them and it remained at 1. Has anyone else experienced this and/or have an explanation? Cheers
Paid Search Marketing | | David_ODonnell0 -
Adwords Keyword Research - Impressions, CTR
Hello, In my Adwords Keyword Research (spending $300 to find out any keywords I'm missing using mostly exact match keywords) am I looking for impressions or Click Through Rate, or both? Please explain.
Paid Search Marketing | | BobGW0