Welcome to the Q&A Forum

Of course, SEOmoz rules big in the world of SEO. However, I'm not sure which blog on Paid Search is currently worth following, so I'm looking for tips here. Which blog do you think provides decent content on AdWords / PPC?

In hindsight, the solution offered on that page does not do the trick. I guess I will keep using my workaround...

Thanks for the quick response. Open Office is something I should have checked first and indeed, opening the .csv in Open Office doesn't cause semicolons to split columns.

A workaround in Excel I've just now tried is making an empty spreadsheet and importing external data from the .csv, which lets me deselect the semicolon as separator.

I've also set the separator to something else in the Windows Language Settings, thanks for that link.

If for example a page title contains a ë the .csv created by the SEOmoz Crawl Test is already split into columns on that point, even though I haven't used Excel's text to columns yet.

When I try to do the latter, Excel warns me that I'm overwriting non-empty cells, which of course is something I would rather not do since that would make me lose valuable data.

My question is: is this something caused by opening the .csv in Excel, or earlier in the process when this .csv is created?

Hi Richard,

I didn't mean nofollow, but noindex,follow. Imagine this situation:

Page A has noindex,follow

Page B has index,follow

Page X has 1 internal link to page A and 1 internal link to page B

Will the linkjuice from page X divide between page A and page B? Or will page B get all the juice (since page A is not indexed?).

Thanks,

Stefan

Great tips regarding deeplinking and link distribution, thanks for that. However, I am still wondering what happens with link juice that is sent to a page with noindex,follow. Will all juice go to an indexed page instead, or will part of the juice go to the noindexed page (and get lost)?

Yes, rankings have dropped sitewide (according to SEOmoz web app). Unfortunately I don't have CTR data.

Thanks. We are of course working on more link juice, but it will take time unfortunately

Here's some data (all organic):

Traffic
May 1-15: 2.900
June 1-15: 1.600

Landingpages
May 1-15: 750
June 1-15: 530

Traffic generating Keywords
May 1-15: 2.000
June 1-15: 1.300

And i've broken it further down into short vs long tail (1-2 word phrases and 3+ word phrases):

SHORT TAIL

Traffic
May 1-15: 1.400
June 1-15: 1.000

Landingpages
May 1-15: 550
June 1-15: 400

Traffic generating Keywords
May 1-15: 1.000
June 1-15: 700

LONG TAIL

Traffic
May 1-15: 1.500
June 1-15: 600

Landingpages
May 1-15: 200
June 1-15: 130

Traffic generating Keywords
May 1-15: 1000
June 1-15: 600

As you can see, both the number of traffic sending keywords and landing pages have dropped significantly for both short and long tail terms. These really seems like a sitewide trend and followed shortly after we doubled the number of product pages. According to Google Trends and our supplier there's no noticable drop in search volumes or orders (this is a product that's been sold throughout the year).

How would you act upon this?

We have an e-commerce store with around 4000 product pages. Although our domain authority is not very high (we launched our site in February and now have around 30 RD's) we did rank on lots of long tail terms, and generated around 8000 organic visits / month.

Two weeks ago we added another 2000 products to our existing catalogue of 2000 products, and since then our organic traffic dropped significantly (more than 50%).

My guess is that link juice has been distributed to too many pages, causing rankings to drop on overall. I'm thinking about noindexing 50% of the product pages (the ones not receiving any organic traffic). However, I am not sure if this will lead to more link juice for the remaining 50% of the product pages, or not.

So my question is: if I noindex,follow page A, will 100% of the linkjuice go to page B INSTEAD of page A, or will just a part of the link juice flow to page B (after flowing through page A first)?

Hope my question is clear

P.s. We have a Dutch store, so the traffic drop is not a Panda issue

Hi Francisco,

Actually I'm only using this for SEO solely, and the purpose is to easily spot the most valuable keyword (in terms of search volume, competition, conversion rates etc.) as well as have some synonyms and related words grouped together to vary product copy.

I have a specific question regarding keyword grouping. Whenever I've have compiled a (long) list of keywords, I create smaller groups of keywords that can be targeted by a category or page. However, I find this to be quite labour-intensive as I'm doing this work manually through filtering in Excel.

To illustrate what I mean, here's an example of a keyword list:

baby shirt
t-shirt for baby
pregnancy shirts
pregnancy gifts

Normally I would create a list of root words, like this:

baby
shirt
pregnancy
gift

I would then manually filter the list on each root word and copy the filtered list to separate tabs, which would result in lists like this:

baby
baby shirt
t-shirt for baby

shirt
baby shirt
t-shirt for baby
pregnancy shirts

etc.

As you can imagine, this is a lot of work. So my hope is that you can help me out with a smart tool / Excel formula / ??? to automate this process.

Thanks for any suggestions!

Hi Rishi,

Thanks for the reply. Can you explain me how exactly PPC data will help to gauge the SEO competition for keywords?

Yeah I'm already using this tool, however it also only let's you process 1 keyword at a time in stead of a list of keywords. Guess I could use it combined with Mozenda though. Does anyone know if Mozenda will be able to scrape keywords from the Adwords tool?

I'm looking for the latter (long tail builder). I've been using Market Samurai, but there does not seem to be an easy option to process a list of keywords 1-by-1 without having to manually run each keyword. Nichebot comes close with it's Keyword cruncher, which takes the first 1-20 keywords of the generated list to find new related keywords or synonyms. However, you cannot import a list yourself to have processed, it starts with 1 keyword. As the keywords on top of the list are not always the most relevant, this does not completely fulfil our needs.

I'm also looking for a Google suggest scraper that can process a list of keywords btw. Any suggestions for 1 of these tools would be great (or perhaps somebody could build it)?

Hi,

I'm looking for a tool that will be able to run a list of keywords 1 by 1 through the Google Adwords keyword tool and place them together in a list, in order to get as much long tail keywords as possible.

Thanks for any suggestion!