Monday, May 9, 2016

Adding unique content Stage 1

Today I exported my entire product list via BigCommers to a Csv file.

Then I took my description column and inserted a new column into it. I wanted to add my website, the product brand, and the product name to my description. My hope is that by doing this, I would be able to have a little more unique descriptions. My friend who started www.waketaker.com 1 month ago has gotten 14k pages indexed by google. My 7500 pages on www.healthyexercize.com have been published, but not indexed for the last 3 months. My pages have zero unique content (well all but about 500 of them) while www.waketaker.com has only the waketaker added to the description.


The formula that I used to combine 3 columns and words are:
="HealthyExercize"&"  "&C2&" "&G2&" "&H2  The " " are so that I had spaces between the info on the cells. It looked like this afterward (as an example)

This came out to HealthyExercize Champion 2 Lb Dumbbell This dumbbell is . . .
Without the " " it would have looked like this:
HealthyExercizeChampion2 Lb DumbbellThis dumbbell is. . .

There needs to be an & between each cell added and a & between any exact words added such as spaces and HealthyExercize.


You can see how the formula in the upper left translates into the first few cells under column J. Column J is the added column I added.

Then I drug the formula all the way down and copied it so it used the same formula

Then I Copied (CTL C) and right clicked and chose to copy the value. That replaced the formula and put the words in solid as a description.

I checked visually to make sure my description didn't have any duplicate words. For example Champion Barbells might show up and Champion Champion Barbells because I added the brand and the product name.

If I found a duplicate I highlighted the column (in my case Column J) and hit CTL H. Find: Champion Champion (the duplicate words) and Replace: Champion (only one of the duplicate names)

Once I knew I didn't have duplicate names, I uploaded it back up to Big Commerce with the new descriptions.

Checking Site:healthyexercize.com on google chrome, I can see that google has indexed 3170 of my pages. I did this 5 minutes ago and came up with 3200. So it varies a little depending on your internet speed. But about 3k of my pages have been indexed. That number has been the same for at least 203 months. Lets see how many are indexed with this change in the next few weeks. Brandon did this to his site and got immediate indexing (within a couple of weeks)

No comments:

Post a Comment