Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Keyword Organising

Keyword Research

659

seoman10 last edited by

Does anyone know of any tools to aid organising keywords?

I'm currently using Excel extensively in an effort to bring some organisation, however it is very labour intensive.
1 Reply Last reply
Reply Quote 0
DmitriiK last edited by

Hi there.

What kind of keyword organizing are you talking about?

As far as I know there are no good tools for organizing keywords. I use google sheets - you can do quite a lot with them. Also you can write your own scripts. However, we are in process of building our own custom solution for in-house use. Because it will satisfy every single nuance i need. Quite honestly, it isn't that much work time if you plan carefully. So, I'd recommend talking to your developer team
1 Reply Last reply
Reply Quote 2

Got a burning SEO question?

Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.

Start my free trial

Browse Questions

View

From

Sorted by

With category

Explore more categories

Related Questions

Keyword List stuck on "Gathering Metrics"

keywords metrics

Hello! I set up a keyword list over a week ago and the majority of the keywords still say "Gathering Metrics." Any advice on how to get this data to populate? Thanks!
Keyword Research | | mollykathariner_ms

0
Country Wise Keyword difficulty

I want to know that how it is possible that global and country-wise keyword difficulty should be the same. Please help me out understand this confusion.
Keyword Research | | Daie8

0
How do I use Google Keyword in onsite seo?

Hello to all, I wanted to ask if I am doing this correctly. So I own a Bernese mountain dog website I used the google keyword research tools to view keyword ideas. I listed my results below. So my questions are: 1 - Bernese Mountain Dog Puppies (the keyword) blow away the other keywords. So when you are looking at your sites most popular keywords, do you make the most popular keyword your homepage? Because it gets the most link juice? Like would you build the homepage around the best keyword instead of branding - like the company name etc? Or does it matter? Basically just as long as you use it for one page? 2 - When you have keywords that have parts of other keywords, is it safe to use the longer keyword because it has parts of the other phrases? Such as Bernese mountain dog puppies for sale is a part of Bernese mountain dog puppies for sale in Colorado. So if you use bernese mountain dog puppies for sale in Colorado, it will also hit the bernese mountain dog puppies for sale? ( without the In Colorado) What type of strategy would you use for this type of situation? 3- Lastly, and thank you for your time - I watched a video from a grey hat seo guy. He said to take a keyword or phrase like say Colorado home builders, create a page like example.com/Colorado-home-builders/ Then make you h1 tag - The Best Colorado Home Builders Add The Best Colorado home builders to your meta description and one more time in your h2 tag Then create a Bold, and italic The Best Colorado Home Builders in your unique content paragraphs. So my question is - is this grey hat and bad? Or the standard? I do not want to get hit for over optimizing. So just wanted to ask you opinion first. In the end, I truly thank you for taking the time to read my questions. I appreciate everyone's help and greatly appreciate your knowledge. So my results look like this | bernese mountain dog puppies | 590 | Low | $0.45 | 1% | |
| bernese mountain dog puppies for sale | 90 | High | $0.42 | 9% | |
| bernese mountain dogs | 90 | Low | $0.37 | 0% | |
| bernese mountain dog puppies for sale in colorado | 30 | Medium | $0.76 | 0% | |
| bernese mountain dog breeders in colorado | 20 | Medium | $0.32 | 0% | |
| bernese mountain dogs colorado | 40 | Low | $0.08 | 0% | |
| bernese mountain dog puppy breeders | 10 |
Keyword Research | | Berner

0
How many keywords is too many?

Hi there Moz'ers, I run a mens fashion brand called THE AFFAIR, where we craft premium T-shirts and Art Prints inspired by your favourite books. So my problem is that I have no idea what to try to rank for keyword wise because every product is inspired by a different book and author. Whilst I could go very wide and try for terms such as "graphic t-shirts" or "printed t-shirts" they are a) super competitive and b) bear no relation to the primary selling point being the literature inspired basis of what we do. But on the flip side, there's just not that many people searching for "Jules Verne t-shirts" or even "Adventure t-shirts" to go a little wider at the genre level. Basically I'm confused at a conceptual level about how to best select my keywords and desperately need some help before running down the wrong path! For what it's worth the site is built on WP (using WooCommerce) and I have installed Yoast and begin playing around with it... But anyway it's the larger strategy that has me stumped at the moment and I really don't know where to begin. Thanks for your time and all comments very much appreciated. FREE T-SHIRT to whoever has the best solution 🙂 cheers
Zoltan
Keyword Research | | theaffair

0
The best way to do keyword research in different languages

Could anyone give me a little advice about the best way to do keyword research in different languages? French and Spanish specifically (unsurprisingly). Are there any tools or systems available that will give local language keyword variants on English keywords so that I can have a look at real world searches in local languages - rather than what I take to be the best translation (if that makes any sense). Many thanks, Iain
Keyword Research | | iain

0
Keyword Stuffing?

I'm the copy writer for a marketing firm, who is doing the SEO work for a website that sells wholesale Disney apparel. I was recently asked to rewrite their homepage blurb, as it was all over the place. However, one thing I'm wondering is if you guys felt the various Disney keyword combinations (IE: Disney Beach Towels, Disney Mugs, Disney Travel Mugs, etc) were necessary for SEO purposes? Or, if they would be considered keyword stuffing? I thought they seemed pretty spammy, but I just wanted to run it by you guys and get your thoughts. Both versions are below. Thanks! Current: Welcome to our website. We are so glad that you have found us, and hope that your ordering experience is a positive one. Here you will find all the Licensed Disney apparel you will ever need to fill your store. We offer Disney apparel in all sizes; infant through plus size. Styles include adult, men, women, youth, toddler, boys, girls, infants, sleepwear, fleece, tanks, dresses, short sets, tee shirts, and much more! Are you looking for Disney licensed accessories? Want Disney licensed collectable pins? We have 80+ designs. We also carry Disney beach towels, Disney mugs, Disney travel mugs, Disney tumblers, Disney beach bags, Disney totes bags, and Disney messenger bags, and more. In addition to all of our Disney products, we also offer other high demand licenses such as Marvel, and Nickelodeon. **REVISED:**Welcome to ------- online shop! Our top priority is providing retailers with a wide array of wholesale licensed apparel and accessories from renown brands like Disney, Nickelodeon & Marvel. We carry a vast inventory of products, in a variety of shapes, sizes, colors and styles - so your store can always stay stocked with all the in-demand items kids and adults crave! Whether your customers want Mickey Mouse t-shirts and beach towels for their next vacation, or Tinkerbell travel mugs and tote bags for everyday use, our wholesale Disney selection has you covered. We also carry over 80 designs of Disney’s popular collectible pins and an equally rich selection of licensed Marvel and Nickelodeon goods.
Keyword Research | | BrandLabs

0
Should i go with 50% Keyword Competition ?

I just checked through seomoz keyword tool and found one of my keyword which "Photoshop Stroke Brushes" have around 50% competition.. should i continue to go with or can you suggest me any same keywords ?
Keyword Research | | xplodeguru

0
How can i track keywords history

i need to keep a record for all keywords history , is there any way that we can track keywords history so we can compare each week with the previous weeks ?
Keyword Research | | omarfk

0