Marketing Articles - Rock Solid SEO from The Internet Presence, LLC

How to do Keyword Research

For this example, we will do keyword research on the phrase ‘web hosting’.

https://www.freethesaurus.com/Web+hosting and type in ‘web hosting’, ‘web’, and ‘hosting’ you can come up with these quick main terms.

Web Hosting

Website Hosting

Web Site Hosting

Internet Hosting

Now you can do thorough research on each of these terms but for this article, we will just pick one of the four above. How do we choose which one to use? We’ll pick the one that gets searched for the most!

Sources for Getting Estimated Traffic to Help Choose your Main Keyword Research Theme

There are quite a few places online that you can use as a source to find out how much traffic comes to a certain keyword phrase. These are my favorite ones.

Note: I do not use Google AdWords Keyword Planner for getting estimates on traffic because the numbers are usually off. You can read more about this here. Although I consider it an excellent resource for coming up with more keyword phrases for testing to use.

Let’s compare the results of the top 3 above for the phrase ‘web hosting’

Moz 11,500 to 30,300 searches a month
Spyfu 27,100 to 110,000 searches a month
SEOBook 36,780 searches a month (1,226 daily)

My preference is to collect the data from both Moz and Spyfu and if I see that both results are way off from each other then I will take a second look at that particular keyword phrase.

It is from my experience that Moz’s numbers for searches for the month are more accurate for organic traffic while Spyfu’s numbers are more accurate for pay-per-click searches.

Let’s see what Google AdWords Planner says… 100,000 to 1,000,000 searches a month. (Way Off!)

Now back to seeing which keyword phrase we are going to research.

web hosting (Moz 11,500 to 30,300)(Spyfu 27,100 to 110,000)
website hosting (Moz 11,500 to 30,300)(Spyfu 14,800 to 40,500)
web site hosting (Moz 51 to 100)(Spyfu 2,400 to 5,400)
internet hosting (Moz 201 to 500)(Spyfu 390 to 1,300)

If you notice above ‘web hosting’ is the winner for the number of times it is searched but is it relevant to what we want to achieve? This is why I manually search for these keyword phrases in the browser and look at the SERPs (search engine results pages) to help determine if what website listings are shown are related to what I think ‘web hosting’ is. I look at the websites listed and add 10% to each correct listing then compare the results to all four above.

Web Hosting is 100%
Website Hosting is 100%
Web Site Hosting is 100%
Internet Hosting is 90%

An interesting thing to note is that when you search for ‘internet hosting’ the SERPs have 70% list ‘web hosting’, 10% list ‘internet hosting’, 10% list ‘website hosting, and 10% was not related directly to ‘web hosting’. Seeing how ‘web hosting’ dominates the SERPs in these examples helps tell you what to go with.

Moz has just introduced a new part of the tool that displays the ‘Organic CTR’ of the keyword phrase when you do the research through their website that estimates how likely that the people searching for the keyword phrase find what they are looking for. For the example of ‘web hosting’ the organic CTR according to Moz is 53%. I would only use this as a guide and do it manually yet. Spyfu also has its own CTR but it is measured for pay-per-click rankings instead of organic rankings.

Both Moz and Spyfu offer their estimate on how difficult it is to rank these keyword phrases organically. I use both of them but trust Moz’s number more.

From a scale from 1% (easiest) to 100% (hardest) here are the numbers that Moz and Spyfu give for ‘web hosting’.

Moz 93% to rank for this keyword phrase
Spyfu 74% to rank for this keyword phrase

This is the reason why we do keyword research in the first place to find the right keyword phrase that is searched for the most and that is also easier to rank with.

This is our end result to help us to decide to use the phrase ‘web hosting’.

Thesaurus	Accuracy (Manual)	Moz Low Searches	Moz High Searches	Moz Difficulty	Organic CTR	Spyfu Local Searches	Spyfu Global Searches	CTR	Spyfu Difficulty
web hosting	100.00%	11,500	30,300	93%	53%	27,100	110,000	4.27%	74.00%
website hosting	100.00%	11,500	30,300	93%	53%	14,800	40,500	2.69%	80.00%
web site hosting	100.00%	51	100	91%	53%	2,400	5,400	2.69%	80.00%
internet hosting	90.00%	201	500	72%	34%	390	1,300	2.69%	80.00%

Now that we decided that the Main Keyword Theme we use for our keyword research will be ‘web hosting’ we can start building a list of a few hundred keyword phrases that relate to ‘web hosting’.

Here is a list of resources I use to gather keyword phrases. A few of them are free, a few of them are monthly paid subscriptions, and one of them is a software I purchased.

Thesaurus
Uber Suggest
Google AdWords Keyword Planner
Google Trends
SEOBook
Google Related Searches
Ask.com Related Searches
Trellian
KeywordXP
Moz Keyword Explorer
Spyfu Related Keywords

You can also sort this list alphabetically and grab all of the keyword phrases by who, what, where, when, and how to find out what questions people are asking online about ‘web hosting’ that you can use to your advantage by answering these questions on your website and gaining insight on what the general public is looking for.

Wow! 13,767 keyword phrases were found after I went through the list above! Quite obviously there are going to be duplicates so I entered them into a spreadsheet to remove the duplicates and ended up with 11,424 keyword phrases.

Now I take the remaining 11,424 keyword phrases and plug them into Moz (for organic research) and Spyfu (for pay-per-click research) to get data on such things as:

Organically
- How difficult it is to rank
- What is the organic click-through rate (CTR)
- What is the priority score of each one
Pay Per Click
- Average cost per month to bid on each keyword phrase
- How many unique advertisers are bidding in the last three months
- How difficult it is to rank
- The average cost to bid on each keyword phrase
- Estimated Global Searches
- Estimated Local Searches
- Estimated clicks per month your ad will receive
- Minimum clicks per month your ad will receive
- Broad click-through rate (CTR)

After I enter in the stats for all of these keyword phrases in a spreadsheet I use the following methods to narrow down the list.

Delete phrases that are not searched for very often
Delete phrases that are too difficult to rank for
Delete phrases that have too tough of competition
Delete phrases that have too low of a click-through rate (CTR)
Delete phrases that are too expensive to bid on
Delete phrases not related to me or my business
Delete phrases that do not relate to my area.
- An example would be chiropractic services. I would delete phrases that specify services not located in my area.
Delete phrases that have a low number of clicks in ads
Delete phrases too high in competition for pay-per-click ads

After this is done I will have a list of the top 100 or more keyword phrases that will be perfect for my SEO or Pay Per Click campaign that I want to use.

Happy Keyword Hunting! Or just pay me to do the keyword research because believe it or not I love doing this!

Other services I provide are web design, web hosting, web marketing, and website maintenance.

Michael

Brand New SEO Project – Choosing a New Domain Name

If you want to start a brand new project and want to get a little head start in the game then I would advise looking for just deleted domain names that already have a pretty decent DA (domain authority) or PA (page authority) with backlinks (websites linking to the deleted domain) already in place.

One of the places where you can look up recently deleted domains is https://www.expireddomains.net/deleted-domains/.

To narrow down the search you can filter the results by .com only and a keyword phrase that appears in the domain name.

In the example website https://www.expireddomains.net/deleted-domains/ they provide the number of backlinks, etc. already but I found out from experience that these numbers are NOT accurate and should be used as a guideline only!

You can use a Moz account, Spyfu, or something similar to get an accurate number of backlinks, DA, PA, etc.

The first thing we did is copy and paste the data into a spreadsheet to that we can sort and easily work on the list in front of us.

I sorted the columns by the number of backlinks, amount of traffic, etc. so that I could explore these further.

When I sorted the spreadsheet by the number of backlinks with the largest number first I examined the backlinks to see if they were spammy or all from just a few domains.

When doing research for a client we found some good domain names. We looked up what the website used to look like before the domain got deleted by using the WayBack machine.

Some of the websites did not relate to what the customer wanted to put up so we deleted these from the list.

The next step was to examine the backlinks of the top deleted domains that had the most backlinks.

I used the tools from Moz’s Link Explorer to take a closer look at the backlinks.

Ideally, this is what we were looking for:

A large number of backlinks that are not spammy.
The backlinks coming from many domain names that are not in the same IP block.
Backlinks that match your language.
Backlinks from websites that relate to the website that you want to put up.

It was discovered that there were only a few worth looking at. One of the sites we had thousands of backlinks pointing to the old domain name but they were not of high value and although the site had a DA (domain authority) of 24 we chose not to use this one. Domain authority is ranked from 1 (brand new site) to 100 (a super authoritative site like Google, Amazon, eBay, etc.).

The next step was checking the amount of traffic to the old website that got deleted.

In another column from the deleted domain list, it had an estimate for the amount of traffic that visited this deleted domain’s website. We double checked this estimated number with the result that Spyfu showed us. The amount of traffic was within fair range with what the deleted domain name website showed us.

Another way to research this is to see how many times this website was mentioned on social media sites like Facebook, Twitter, etc. One quick easy way to do this is doing a search in Google using the domain name between quotes like this. “examplesite.com”. This will show you all the websites out there that use exactly this domain name on other websites.

There are also some free online tools out there that you can use such as Hootsuite, SocialMention, Twitter Analytics, etc.

Deciding on a domain name

Since we did not find any super positive domain names we decided to start out with a fresh one. One of the first steps we did is run what she wanted the website to be about through a thesaurus and created a list of similar keyword phrases that related to what she wanted and ran them through a traffic estimator like the tool that Moz uses.

The next step after we found out what phrases were searched for the most we plugged them into Google Trends to see how the searches for each phrase did throughout time. Using one of the Moz tools it also showed us how hard it was to rank for each keyword phrase that we had on our list. This would be very important in determining to build a website around or possibly picking a domain name.

After the client has decided what domain name to use and finding out it was available, (it had many searches, was steadily growing in interest in Google Trends, and was not to difficult to rank for) I told her that we should look at her keyword phrase that she wanted to use as a domain name in the SERPs (search engine results pages). It was discovered that on the first two pages of Google The keyword phrase was part of the domain name or a page of the domain name telling us that having the keyword phrase in the domain name was still a huge ranking factor in this example.

Note: It used to be easy to rank for a website by purchasing a domain name that used the keyword phrase within its URL. This is no longer the case. But there are examples sometimes where this still rings true. The domain the client picked happen to be one of these examples.

In the SERPs, I used the Moz Tool Bar to quickly give us an overview on the DA (domain authority), PA (page authority), and links for each site that was ranking in Google. An overview of this data showed that a website that used the keyword phrase had a low DA and PA but still outranked a website with a much higher DA and PA just by the simple fact that its keyword phrase was in its domain name. Another thing that was noticed was that these two sites still beat out giants like Facebook, Instagram, and Etsy!

It was decided at this moment to use the domain name that the client picked out. But there was a problem…

The domain name she picked up would be easy to rank for, had a high organic click-through rate (which means that the likelihood that people will read the domain name will find what they are looking for when they click the link) and had potential.

So what was the problem? It broke the cardinal rules of picking a domain name.

Easy to Spell
Easy to Remember
And is ‘catchy’

The domain name was not any of these because it was hard to spell, pronunciation, and remember but I told her not to despair. We could purchase another domain name that was easy to spell, remember, etc and just have it forward to her excellent keyword phrase domain name. This way she could tell her clients over the phone, on the radio, etc. the simplier version domain name and it will just forward to her keyword rich, more accurate description domain name. She would be getting the best of both worlds.

New Domain Authority Coming from Moz

Guide to Domain Authority 2.0

Transcription:

Domain Authority is changing. Here’s what you need to know.

What is Domain Authority?

Domain Authority (DA) predicts the ranking ability of a website. Higher DA scores indicate a higher chance of ranking in search engine results. Domain Authority scores are based on factors from a domain’s inbound links (backlinks).

What’s changing?

Moz now has…

More link data
Better ways to interpret that link data
Fresher link data

The new Domain Authority will be the most accurate way to compare your site’s ranking potential against your competition.

With metrics like Spam Score and link quality patterns factored into a sophisticated machine-learned model, you can keep pace with Google’s algorithm updates and make smarter search marketing decisions.

Timeline of recent updates

(September 2017) Tracking metrics over time – Moz starts tracking historical data. DA, PA, and Linking Domain counts can now be seen over time.

(April 2018) Bigger & fresher link index – Moz announces a rebuild of our link technology. This change makes our link index 35x bigger and 30x fresher than before.

(March 2019) New & improved algorithm – Moz updates the way DA is calculated, adding new factors that will improve the accuracy of the scores.

How will this affect my data?

If you monitor your site’s Domain Authority, you can expect to notice some changes. For some sites, DA scores may be higher; for others, they may be lower.

This is due to the update in how we calculate scores and is not a direct reflection of a change you’ve made to your link building strategy.

The update will apply to historical data so that you can continue to measure linear progress. This means that your “Metrics over time” will still be an accurate representation of your site’s authority and link improvement over time.

If you have a Campaign with Moz, we will retain your old score temporarily for reference. You will be able to view this data in the Links section of your Campaign.

Because we’re adding more factors to our algorithm, sites with suspicious link patterns may notice a change in DA beyond their normal fluctuations. This could cause a larger gap between your site’s score and the scores of others.

Dos and don’ts for using DA

DO: Use DA as a comparative metric between sites of a similar caliber, category, or industry.

DON’T: Don’t look at your site’s Domain Authority score in isolation.

DO: Look to see how your competitors’ DA scores fluctuated in light of any updates. How do you compare?

DON’T: Don’t mistake our 0–100 scale for an F–A grading on a test. You should not be aiming for 100 to get an “A,” but rather should be aiming for a score that is higher than your direct competitors (those who show up near you in search results for your target keywords).

DO: Expect regular fluctuations in your DA score, as both your site’s link profile and the rest of the web change over time.

DON’T: Don’t mistake DA for PageRank, Google’s link-based ranking signal. DA was created by Moz, and Google doesn’t factor the score into your site’s ranking.

To sum it up:

Moz is changing the way our Domain Authority score is calculated for even better accuracy.

Expect changes to your DA score in light of this update, but know that it’s not a reflection of changes to your site.

DA is a comparative metric, so look to see how your competitors’ scores change, too.

Aim for a score that is higher than your direct competitors (those who show up near you in search results).

Keyword Research Reports: How much are they worth?

Of course, I already did keyword research on ‘keyword research reports’ out there but all that tells me is that there is an interest out there of people looking to buy specific keyword research reports.

But, how much do people think it’s worth? How much are people willing to pay? I’ve done a little test and performed a free keyword research report and have given it away to one of my customers for free but I feel it was the wrong target audience. Why? Because she was not really looking for or needing a keyword research report. I received valuable insight on what she thought of the report herself and got her input on how much she thought it was worth but the dollar amount would not be accurate because she was not looking for or needing the keyword research report. Obviously, it would be worth more to people who were looking for it in the first place!

On average a report would cost $300 to $400 worth of labor. I enjoy doing these reports and get thrilled when discovering what people are thinking about certain topics, what is popular, and what areas they are popular in, etc. so I thought what if I were to do reports on certain subjects and sell them online for less? Would an interest be out there? The answer is yes but I was limited on what they expected or what they were willing to pay for one. If you have a dollar amount in mind please share it in the comments below.

First of all, what is the target audience of people wanting keyword research reports?

Business owners who want to learn what interests the general public for what they have to offer.
- For example, they could jump on new trends that are just taking off and market to those people.
People who create Google Ads or other PPC (Pay Per Click) campaigns.
- For example, they could tell if they are wasting money on keyword phrases that they are bidding that people are not searching for. (Plus the report will tell you the ‘value’ of each keyword phrase as well.)
Web Developers (not designers) who want to layout the website properly.
- For example, if they knew what people are asking online they could create an FAQ page to answer their questions.
- Or, if they see a trend on what people are looking for they can set up the navigation layout of the website to match.
Advertisers
- For example, if they knew what keyword phrases are typed into Google the most they could design an ad to match what they are looking for.
Any other type of people you can think of? If so, leave it in the comments below.

If you are interested, this page on keyword research gives you more details on what is included in the report. After all, you would need to know all that is included before putting a price tag on it right?

In short, this is what these reports would include:

Questions that would get answered:
- What keyword phrases are related to your website?
- What keyword phrases are searched for the most?
- Which keyword phrases are the easiest to rank for?
- What questions do people ask that is related to your website?
- What websites should you get links from based on your keyword phrase?
- What type of links should you get related to your best keyword phrase?
What would be included in the reports:
- The number of times per month each keyword phrase is searched for.
- How hard it is to rank for each keyword phrase.
  (The keyword phrases will be color coded from green to red to get an idea quickly.)
- A percentage from 1 to 100 that the keyword phrase will likely get clicked on. (Organic CTR)
- A short comment on what you would have to do to rank for each keyword phrase.
- Questions people ask related to your keyword research theme.
- Best website links to get for your best keyword phrase.
- The best type of website links you should concentrate on for linking to your website.
- Recommendations from me on what you should do to give your website the maximum performance it needs.
- An in-depth analysis of how to use this information

Thank you for taking the time to read this and thank you even more if you contributed a comment on what you think of this idea. And of course, if you want a custom keyword research done you can contact me at any time.

How to work with WooCommerce in 2019

WooCommerce has become one of the most popular choices to go with WordPress if you want to sell online. Since it is open-source it can be downloaded and added for free but there are additions you can purchase to add onto WooCommerce to make your life easier or give you an option that WooCommerce does not have. So if you want an inexpensive alternative to having a shopping cart on your website then use WordPress (which is great for marketing) and WooCommerce.

To install WooCommerce first log into your WordPress account and click on Plugins > Add New like below.

Plugins > Add New

Next, type in ‘WooCommerce’ into the keyword search in the upper right-hand corner (1). Then click the ‘Install’ button (2).

Search > Install

Then click on the ‘Activate’ button to activate it.

Click ‘Activate’

Once you activate WooCommerce you are taken to the store setup page where you can enter in the following. Don’t worry you can skip this step if you like and enter it in later if you don’t have all of the information on hand.

Where is your store based?
(enter in the country where your store resides)
Address
(Enter the address where your store is located so your shipping calculator is accurate)
What type of products do you plan to sell?
(You are given three choices, [physical, digital, and both]. For physical they are products that you can handle with your hands. For digital they are products that you can download like music and software.)

The next step is to set up what you will use for accepting payments. As of 2019, the choices available to you are Stripe, PayPal, and offline payments. Click on the little slider icon to the right to enable or disable the option.

Payment Options

Step Three takes you to a screen where you set up what type of shipping to hookup. Out of the box for WooCommerce in 2019, there is only free shipping and flat rate shipping where you can choose how much to charge for shipping depending upon the zone (location) that you want to ship too. If you want to use FedEx or USPS there are extensions that you can get for free or pay for to enhance WooCommerce.

Below this is the option to print shipping labels at home if you want. If enabled it is recommended to install the plugin ‘Jetpack’ which is a very useful all-in-one plugin to help secure your website, crunch images to save space, automatically post to social media accounts, etc.

How to set up shipping for WooCommerce in 2019

Shipping Options

The next screen that shows up is the ‘Recommended’ portion of setting up WooCommerce.

Here you can choose to install these other programs to help with your WooCommerce store.

Storefront Theme
(Highly recommended from me! Create a ‘Child Theme’ of this template so that when it updates to the latest version you do not lose any of your work. The layout of a shopping cart is already set up for you with this them.)
Automated Taxes
(Let WooCommerce and Jetpack do the work for you.)
MailChimp
(If you plan to have a newsletter or want to start an email campaign then MailChimp is the way to go. Although MailChimp can be confusing at first it is powerful to have on your side.
Facebook
(Woocommerce sets up pixel tracking for marketing, messenger, catalog, syncs, etc.
Instagram
(Instagram is not available as of May 17th, 2019 yet.)

When you click on ‘Continue’ at the bottom the checked selections will be automatically installed for you.

2019 WooCommerce Recommendations

If you chose to use JetPack as one of the options you will be asked to create an account by signing up or you can just use your Google Login to make things go easier and faster.

After that your WooCommerce is ready. You will be taken to the screen below where you will have the following options available to you.

Sign up for a newsletter with WooCommerce
(Receive emails for tips and the latest updates.)
Create a single product
(Manually create your first product.)
Import several products
(Use a spreadsheet to upload several hundred or even a thousand products at once.)
Visit Dashboard
(This is a quick overview of products sold, awaiting payments, customer information, etc.)
Review Settings
(Take a look at how you set up WooCommerce and extra settings that you can do to fine-tune things.)
View and Customize
(From here you can customize the look of the store by choosing colors, adding a logo, etc.)

I will go over how to add a single product in Woocommerce in a future post. Also, I will show you how to import several products as well.

WooCommerce is Ready

Save this post and come back when I update it with links on how to do the steps in more detail such as adding products.

Michael

How to add a product in 2019 WooCommerce with SEO in Mind

After you log into your WordPress site select Products > Add new and when the new screen shows up add the Product Name along the top.

Products > Add New

After you enter the Product Name you can add a detailed description of the product in the big box below. Note: I installed the classic editor of WordPress instead of using the block editor. I find it much easier. To install the classic editor you can use the link https://wordpress.org/plugins/classic-editor/ to download it or go to Plugins > Add New and do a search for ‘classic editor’.

You can add images, lists, text, and whatever you want for your product description.

Enter product description in the big content box

Next, choose your product type.

Choose a type for this product. Simple is suitable for most physical goods and services (we recommend setting up a simple product for now).

Variable is for more complex products such as t-shirts with multiple sizes. Also called, product attributes which can be different sizes, colors, etc.
Grouped products are for grouping several simple products into one.
Finally, external products are for linking off-site. If you have an affiliate program where you make money selling other people’s products you would use this option and enter the affiliate link website address (URL).

Two checkboxes are to the right.

Virtual: Means the products are intangible and are not shipped.
Downloadable: Means that your website visitors can be given access to download the product to their computer right after purchasing it.

Product Type

Next, you can enter the price of your product. You can also put in a sale price and schedule a time to when the sale will be going on. Also, if you want can set the product to be taxable or not and what tax class you want.

Pricing WooCommerce Products

Next, you enter the short description of the product. This information is displayed if you have multiple products on one page of the website so remember to make it enticing enough for them to click through and take a closer look at your product!

Product Short Description

To add a picture of your product click on the link ‘Set product image’. This will be the main image of your product to display on your site. You can create a ‘Product Gallery’ for any other images of the product. For example, if you want to show different views or colors of your product. Another example is displaying an image showing it in use.

Product Images

For a little detail and SEO work, you can enter the following when adding a product image. You will notice this on the right when you upload a product image. If you already have the product image in your Media Gallery you can go to Media > Library then select the image you want to edit, click edit, and fill in these details below.

Alt Text
(This is text that you put that describes the image for screen readers for vision-impaired visitors to your website. This is an opportunity for SEO but keep it’s true purpose in mind to describe what the image is for the vision-impaired.
Title
(Although this does not show up in the website it will enter it in the code of the website. This is an SEO opportunity as well where you can help the search engines find this particular product. One thing that I enter here is the part number of the product. Part numbers are easy to rank for in search engines.
Caption
(The text you put here will display just below the product when it is shown on the website. A brief description, name, or part number can be displayed here and also can help with search engine optimization (SEO).
Description
(This also does not show up on the website but describes the product. I have found with some of my marketing customers that if you put a strong detailed description of the product your images will start to rank in the search engines. It was a nice quick easy way to get rankings.

Product Image Details

The next step is to add product tags for your product. Tags are a nice feature to help your customers find your products easier but is not required. Although I would do it because anything that makes it easier for your customer to find your product will make it easier for them to purchase it. Plus product tags are another opportunity for helping you to rank.

Product Tags

If you have a lot of products it would be a good idea to add them to a category. Categories also make it easier for your website visitors to find your products and if they can find your products easier it will mean more sales. Although this is optional, like the product tags, I recommend using this for both ease of use for the website visitor and the opportunity for SEO. If you forget to assign it a category then all product will be set to ‘Uncategorized’. You can rename this category but not delete it by going to Products > Categories > Edit.

Product Categories

The next step is to publish your WooCommerce Product. You have a few options here.

Save Draft
(You can save it as a draft so it will be saved but not displayed on your website.)
Preview
(You can preview what your product will look like before you publish it.)
Publish
(This will make it live right away.)
Publish immediately Edit
(You can choose to have this product go live at a certain set future date.)
Visibility
- Public
  (You can have this product visible to the public)
- Password Protected
  (Visitors would have to log into your website in order to see it.)
- Private
  (Perhaps you only want admins to your website to view this product.)

Publish Product

And there you have it! This is how to manually publish a single product with SEO in mind.

Michael Rock

How to Import Many Products in WooCommerce for 2019

If you have a lot of products to import from a previous shopping cart that you used to use this can be a big time saver!

I was a little disappointed that WooCommerce did not have a sample .csv file that you could download and use as a template, but here is a workaround for that. Just create one product manually then go to Products > All Products then click on the ‘Export’ button along the top of the page.

How to Export Products in WooCommerce

After you do this you will come to a screen where you are given the options on how to export your products.

How to export products in 2019 WooCommerce

Export Options in WooCommerce

Just leave all of the options to ‘Export all categories’ and you do not have to check the box ‘Export custom meta?’. It is not needed for inputting your products. After you have done this a .csv file is generated that you can download. After you downloaded the .csv file you can open it in your spreadsheet editor, whether it be Google Sheets, Excel, Open Office, etc.

NOTE: When you manually create a product to export to create a template try to fill in as much information as possible!

These are the column headings that show up when you do this and are displayed below along with a brief description of each in parenthesis. If the export column is blank it is safe to leave them blank for the next import.

ID (Tracking ID number created by WooCommerce. You can leave this blank.)
Type (Type of product.)
SKU (The SKU number you use for inventory. Okay to leave blank if you do not have one.)
Name (Name of the product.)
Published (Published to your website. 1 means yes, 0 means no.)
Is featured? (Main product to display on your website. 1 means yes, 0 means no.)
Visibility in catalog (Viewable to the public.)
Short description (Short description of the product shown on multiple products page.)
Description (Detailed description of the product shown on the single product page.)
Date sale price starts (Beginning sale date.)
Date sale price ends (Ending sale date.)
Tax status (Whether the product is taxable or not.)
Tax class (Type of tax class.)
In stock? (1 means yes. 0 means no.)
Stock (How many you have in stock.)
Low stock amount (How many you have in stock before you get the ‘low stock’ warning.)
Backorders allowed? (1 means yes, 0 means no.)
Sold individually? (1 means yes, 0 means no.)
Weight (oz) (Weight of Product with the shipping container.)
Length (in) (Length of the shipping container with the product.)
Width (in) (Width of the shipping container with the product.)
Height (in) (Height of the shipping container with the product.)
Allow customer reviews? (1 means yes, 0 means no.)
Purchase note (Whether to allow people to leave a purchase note on the product.)
Sale price (Price of the product when it is on sale.)
Regular price (Normal price of the product.)
Categories (Category that the product fits into.)
Tags (Tags used to help find the product on your website separated by commas.)
Shipping class (Type of shipping class.)
Images (URL address of where the image is stored. NOTE: If you enter in the URL address where it is on your old shopping cart and the image URL is still is active then when you import the products into your new shopping cart WooCommerce will add the images to your new shopping cart and update the URL address of the product images to match! This is a great time saver!)
Download limit (A limit to downloading a non-physical product such as e-books, software, etc.)
Download expiry days (How long the website visitor is allowed to download a non-physical product.)
Parent (If your product is under a parent product it is displayed here.)
Grouped products (If your product is part of grouped products then it is displayed here.)
Upsells (Upsells that are added for your product.)
Cross-sells (Cross-sells related to your product.)
External URL (External URLs that talk about your product. It is normally not recommended to have one of these because we do not want people to leave your site. Instead, add any external information on your own web site!)
Button text (Custom text that you want on the product button.)
Position (Position your product is displayed. This can be blank.)

You can now compare the data from the spreadsheet where your old shopping cart is and copy and paste the info into the corresponding column of the exported test template that you created.

If after you do this you find a mistake that you made after you imported hundreds of products there is a great free plug-in that you can use that will delete all of the products at once that comes in handy! Warning though it WILL delete all of your products! WooCommerce Remove All Products

After you fill out the spreadsheet you can browse for your file and import it into WooCommerce where you will be asked to double check that the categories of what you are importing match the categories of WooCommerce.

Importing products into WooCommerce

If you want to do a bulk edit of your products in your spreadsheet then upload them without editing or replacing all of your products you can check the checkbox, ‘Existing products that match by ID or SKU will be updated. Products that do not exist will be skipped.’. Just make sure that you export your latest products before doing a bulk edit on your spreadsheet so that the ID and SKU numbers match so no mistakes are made.

Import Products Into WooCommerce Step Two

Importing Products into WooCommerce

When you see this you will realize that you could have just uploaded your old shopping cart .csv file and pick and choose which WooCommerce category it would match too without having to create a template I just described above. But I have found that by creating a template and importing it that way leaves the chance of making a mistake much smaller.

Plus, it is a good idea to have a more accurate spreadsheet on your products for referring back to on later. After you verify that all of the categories match click ‘Run the Importer’ button at the bottom to import your products.

And there you have it. That is how you upload many products at once using the 2019 WooCommerce Importer.

How to add an affiliate link to 2019 WooCommerce

In order to have your WooCommerce shopping cart display affiliate links, you will have to change the product type to ‘External/Affiliate product’.

How to Add Affiliate Product to 2019 WooCommerce Step 1

Select External/Affiliate

After you change the product type just enter in the link to the external site (in this case) or the affiliate link (be sure to include the data after the question mark in the URL so that you get credit for the affiliate link).

An example of an affiliate link is https://rover.ebay.com/rover/1/711-53200-19255-0/1?mpre=https%3A%2F%2Fwww.ebay.com%2Fitm%2F2005-Ford-Mustang-GT%2F303158466387%3Fhash%3Ditem4695a71753%3Ag%3AFvcAAOSwV9RcpqMC&campid=5338534859&toolid=20008

How to Add Affiliate Product to 2019 WooCommerce Step 2

Enter in affiliate link here

Some of you may have noticed a problem. Even though the ‘Buy Product’ is listed there, a couple of PayPal buttons may also be there which can screw up people trying to purchase this product.

How to Add Affiliate Product to 2019 WooCommerce Step 3

Disable PayPal Checkout

As of May 21st, 2019 WooCommerce has not rectified this so if you have any products that are external/affiliate you will have to go to WooCommerce > Settings > Payment Methods and disable ‘PayPal Checkout’ then click ‘Save Changes’ to fix this. This will get rid of the PayPal buttons but don’t worry you can still have people purchase your products using PayPal.

Moz vs. Spyfu

I consider both Moz, Google AdWords, and Spyfu to be excellent tools when I do my research and with most keyword research tools you find online they all have different numbers.

Google AdWords I have always known to wildly inaccurate search volumes and I only use it to get keyword ideas. Rand Fishkin did some tests and wrote about it as well. You can read his post on moz.com “Why Google AdWords’ Keyword Volume Numbers Are Wildly Unreliable – Whiteboard Friday”

I noticed individually the search volume numbers were usually a bit off between Moz and Spyfu so I decided to run a test on some keyword research I did and compared a little over 200 phrases that I would share below.

As I tell my customers I believe Moz to be more accurate for organic search results and I believe Spyfu to be more accurate for pay per click results. Of course, Google AdWords is supposed to be for pay per click results but I never trusted their numbers and only trust them for keyword phrase ideas to add to the list then paste them into Moz’s tool to get volume numbers.

To further complicate things Moz uses ‘Min Volume’ and ‘Max Volume’ while Spyfu uses ‘Local Searches’ and ‘Global Searches’. Can we really compare these two? Did Spyfu use these terms to make their numbers more plausible when compared to other tools like Moz and Google AdWords?

When comparing Moz’s ‘Min Volume’ to Spyfu’s ‘Local Searches’ we find the difference in numbers from 19 to over 49,000. When comparing Moz’s ‘Max Volume’ to Spyfu’s ‘Global Searches’ we find the difference in numbers from 40 to 468,000.

When comparing all of them together in the chart below you would think that the two ‘Difference’ columns would be relatively close from lowest to highest but it isn’t. It jumps around quite a bit.

Note: Moz’s n/a and the difference #value! could not be calculated because some of the keyword phrases are not in Moz’s index.

Keyword Analyzed 6/7/2019	Moz Min Volume	Spyfu Local Searches	Difference	Moz Max Volume	SpyFu Global Searches	Difference
funnel digital marketing	0	20	20	10	50	40
power digital marketing	501	880	379	850	1000	150
digital marketing near me	201	480	279	500	1000	500
digital marketing software	101	210	109	200	1000	800
digital marketing strategist	201	480	279	500	1300	800
digital marketing podcast	101	390	289	200	1000	800
digital marketing strategy pdf	51	70	19	100	1000	900
digital marketing workshop	51	90	39	100	1000	900
digital marketing for dummies pdf	11	110	99	50	1000	950
digital marketing videos	11	140	129	50	1000	950
why digital marketing is important	11	140	129	50	1000	950
digital marketing for real estate	11	320	309	50	1000	950
digital marketing real estate	11	320	309	50	1000	950
real estate digital marketing	11	320	309	50	1000	950
web marketing agency	11	320	309	50	1000	950
master digital marketing	0	30	30	10	1000	990
digital marketing tips	201	320	119	500	1600	1100
b2b digital marketing	101	260	159	200	1300	1100
digital marketing agency near me	101	590	489	200	1300	1100
digital marketing objectives	11	70	59	50	1300	1250
digital marketing case studies	11	210	199	50	1300	1250
digital marketing case study	11	210	199	50	1300	1250
digital marketing b2b	11	260	249	50	1300	1250
digital marketing company in usa	11	260	249	50	1300	1250
digital marketing for business	11	260	249	50	1300	1250
digital marketing conferences	11	590	579	50	1300	1250
digital marketing conference	11	720	709	50	1300	1250
digital marketing introduction	0	70	70	10	1300	1290
introduction to digital marketing	0	70	70	10	1300	1290
digital marketing agency us	0	140	140	10	1300	1290
digital marketing agency usa	0	140	140	10	1300	1290
business digital marketing	0	260	260	10	1300	1290
digital marketing businesses	0	260	260	10	1300	1290
digital marketing for b2b	0	260	260	10	1300	1290
social media marketing courses online	0	320	320	10	1300	1290
digital marketer conference	0	590	590	10	1300	1290
digital marketing course near me	101	140	39	200	1600	1400
digital marketing classes	201	480	279	500	1900	1400
digital marketing platforms	101	390	289	200	1600	1400
digital marketing solutions	101	480	379	200	1600	1400
digital marketing basics	51	210	159	100	1600	1500
online digital marketing	51	235	184	100	1600	1500
digital content marketing	51	260	209	100	1600	1500
digital marketing firm	51	720	669	100	1600	1500
why digital marketing	11	170	159	50	1600	1550
digital marketing articles	11	260	249	50	1600	1550
digital marketing content	11	260	249	50	1600	1550
digital marketing online	11	260	249	50	1600	1550
tips for digital marketing	11	320	309	50	1600	1550
digital marketing classes online	11	480	469	50	1600	1550
digital marketing solution	11	480	469	50	1600	1550
about digital marketing	0	30	30	10	1600	1590
digital marketing strategy examples	0	210	210	10	1600	1590
content digital marketing	0	260	260	10	1600	1590
digital marketing platform	0	390	390	10	1600	1590
digital marketing online class	0	480	480	10	1600	1590
online digital marketing classes	0	480	480	10	1600	1590
importance of digital marketing	101	140	39	200	1900	1700
digital marketing plan template	101	390	289	200	1900	1700
digital marketing campaign	101	480	379	200	1900	1700
what is digital marketing strategy	51	210	159	100	1900	1800
future of digital marketing	51	320	269	100	1900	1800
the future of digital marketing	51	320	269	100	1900	1800
advantages of digital marketing	11	110	99	50	1900	1850
digital marketing advantages	11	110	99	50	1900	1850
what is a digital marketing strategy	11	210	199	50	1900	1850
digital marketing future	11	320	309	50	1900	1850
future digital marketing	11	320	309	50	1900	1850
digital marketing expert	11	390	379	50	1900	1850
digital marketing experts	11	390	379	50	1900	1850
digital marketing kpi	11	390	379	50	1900	1850
kpi digital marketing	11	390	379	50	1900	1850
digital marketing class	11	480	469	50	1900	1850
advantage of digital marketing	0	110	110	10	1900	1890
digital marketing tutorial	0	110	110	10	1900	1890
what are digital marketing strategies	0	210	210	10	1900	1890
digital marketing funnel	201	720	519	500	2400	1900
role of digital marketing	101	170	69	200	2400	2200
internet marketing agency	101	940	839	200	2400	2200
traditional marketing vs digital marketing	51	0	-51	100	2400	2300
digital marketing vs traditional marketing	51	320	269	100	2400	2300
digital marketing roles	11	170	159	50	2400	2350
digital marketing website	11	260	249	50	2400	2350
digital marketing funnels	11	720	709	50	2400	2350
digital marketing mix	0	90	90	10	2400	2390
website digital marketing	0	260	260	10	2400	2390
digital marketing channels	201	590	389	500	2900	2400
freelance digital marketing	1701	1900	199	2900	5400	2500
how to do digital marketing	101	260	159	200	2900	2700
seo digital marketing	101	320	219	200	2900	2700
digital marketing news	851	1300	449	1700	4400	2700
digital marketing specialist	851	1600	749	1700	4400	2700
digital marketing for dummies	501	880	379	850	3600	2750
digital marketing analyst	501	1000	499	850	3600	2750
benefits of digital marketing	51	210	159	100	2900	2800
digital marketing seo	51	320	269	100	2900	2800
digital marketing benefits	11	210	199	50	2900	2850
seo in digital marketing	11	320	309	50	2900	2850
digital channel marketing	11	590	579	50	2900	2850
benefits digital marketing	0	210	210	10	2900	2890
digital marketing plan	201	720	519	500	3600	3100
digital marketing trends	201	720	519	500	3600	3100
digital media marketing	201	880	679	500	3600	3100
digital marketing analytics	201	1000	799	500	3600	3100
masters in digital marketing	51	720	669	100	3600	3500
digital marketing planning	11	720	709	50	3600	3550
digital marketing plans	11	720	709	50	3600	3550
digital marketing trend	11	720	709	50	3600	3550
marketing digital media	11	880	869	50	3600	3550
master in digital marketing	0	720	720	10	3600	3590
master of digital marketing	0	720	720	10	3600	3590
media digital marketing	0	880	880	10	3600	3590
digital marketing analysis	0	1000	1000	10	3600	3590
types of digital marketing	201	480	279	500	4400	3900
learn digital marketing	201	590	389	500	4400	3900
digital marketing books	101	720	619	200	4400	4200
online marketing agency	101	1000	899	200	4400	4200
digital marketing pdf	51	140	89	100	4400	4300
digital marketing work	0	140	140	10	4400	4390
new digital marketing	0	1300	1300	10	4400	4390
digital marketing specialists	0	1600	1600	10	4400	4390
digital marketing blogs	201	720	519	500	5400	4900
digital marketing tools	201	720	519	500	5400	4900
digital marketing meaning	101	170	69	200	5400	5200
digital marketing blog	101	720	619	200	5400	5200
online marketing company	101	1600	1499	200	5400	5200
digital marketing freelance	101	1900	1799	200	5400	5200
freelance digital marketer	51	1900	1849	100	5400	5300
digital marketing tool	11	720	709	50	5400	5350
digital marketing freelancer	11	1900	1889	50	5400	5350
blog digital marketing	0	720	720	10	5400	5390
marketing company online	0	1600	1600	10	5400	5390
digital marketing consultant	201	1300	1099	500	6600	6100
digital marketing consulting	51	1300	1249	100	6600	6500
digital marketing consultancy	11	1300	1289	50	6600	6550
digital marketing consultants	11	1300	1289	50	6600	6550
digital marketeer	11	891	880	50	6624	6574
digital marketing training	501	720	219	850	8100	7250
digital market	101	320	219	200	8100	7900
digital marketing trainer	11	720	709	50	8100	8050
digital marketing definition	851	1900	1049	1700	12100	10400
digital marketing services	851	1900	1049	1700	12100	10400
digital marketing strategy	851	2400	1549	1700	12100	10400
digital marketing courses online	201	1600	1399	500	12100	11600
online digital marketing courses	201	1600	1399	500	12100	11600
define digital marketing	201	1900	1699	500	12100	11600
digital marketing strategies	201	2400	2199	500	12100	11600
digital marketing service	51	1900	1849	100	12100	12000
strategic digital marketing	51	2400	2349	100	12100	12000
digital marketing course online	11	1600	1589	50	12100	12050
online digital marketing course	11	1600	1589	50	12100	12050
definition of digital marketing	11	1900	1889	50	12100	12050
digital marketing online course	0	1600	1600	10	12100	12090
definition digital marketing	0	1900	1900	10	12100	12090
digital marketing as a service	0	1900	1900	10	12100	12090
digital strategy marketing	0	2400	2400	10	12100	12090
strategies for digital marketing	0	2400	2400	10	12100	12090
digital marketing company	851	3600	2749	1700	18100	16400
what is digital marketing	4301	5400	1099	6500	40500	34000
what is digital marketing?	101	5400	5299	200	40500	40300
digital marketing is	0	5400	5400	10	40500	40490
what are digital marketing	0	5400	5400	10	40500	40490
what is the digital marketing	0	5400	5400	10	40500	40490
digital marketing agency	4301	14800	10499	6500	49500	43000
digital marketing agencies	501	14800	14299	850	49500	48650
agency digital marketing	11	14800	14789	50	49500	49450
digital marketer agency	11	14800	14789	50	49500	49450
digital agency marketing	0	14800	14800	10	49500	49490
marketing digital agency	0	14800	14800	10	49500	49490
digital marketing course	1701	3600	1899	2900	74000	71100
digital marketing courses	501	3600	3099	850	74000	73150
course in digital marketing	0	3600	3600	10	74000	73990
course of digital marketing	0	3600	3600	10	74000	73990
courses in digital marketing	0	3600	3600	10	74000	73990
courses on digital marketing	0	3600	3600	10	74000	73990
marketing digital	2901	1900	-1001	4300	201000	196700
digital marketing	30301	49500	19199	70800	368000	297200
digital marketer	4301	49500	45199	6500	368000	361500
digital marketers	11	49500	49489	50	368000	367950
digital markets	11	49500	49489	50	368000	367950
digital marketing?	0	49500	49500	10	368000	367990
/digital-marketing/	n/a	49500	#VALUE!	n/a	368000	#VALUE!
benefit of digital marketing	n/a	210	#VALUE!	n/a	2900	#VALUE!
companies with digital marketing	n/a	3600	#VALUE!	n/a	18100	#VALUE!
course digital marketing	n/a	3600	#VALUE!	n/a	74000	#VALUE!
courses for digital marketing	n/a	3600	#VALUE!	n/a	74000	#VALUE!
digital business marketing	n/a	260	#VALUE!	n/a	1300	#VALUE!
digital market strategies	n/a	2400	#VALUE!	n/a	12100	#VALUE!
digital marketer near me	n/a	480	#VALUE!	n/a	1000	#VALUE!
digital marketing agency in usa	n/a	140	#VALUE!	n/a	1300	#VALUE!
digital marketing benefit	n/a	210	#VALUE!	n/a	2900	#VALUE!
digital marketing company usa	n/a	260	#VALUE!	n/a	1300	#VALUE!
digital marketing strategy.	n/a	2400	#VALUE!	n/a	12100	#VALUE!
digital marketing trainers	n/a	720	#VALUE!	n/a	8100	#VALUE!
digital marketing tutorials	n/a	110	#VALUE!	n/a	1900	#VALUE!
digital marketing what	n/a	5400	#VALUE!	n/a	40500	#VALUE!
digital real estate marketing	n/a	320	#VALUE!	n/a	1000	#VALUE!
ditgital marketing	n/a	644	#VALUE!	n/a	4784	#VALUE!
example digital marketing strategy	n/a	210	#VALUE!	n/a	1600	#VALUE!
marketing digital definicion	n/a	10	#VALUE!	n/a	1300	#VALUE!
marketing online service	n/a	590	#VALUE!	n/a	1900	#VALUE!
service digital marketing	n/a	1900	#VALUE!	n/a	12100	#VALUE!
services of digital marketing	n/a	1900	#VALUE!	n/a	12100	#VALUE!
strategy for digital marketing	n/a	2400	#VALUE!	n/a	12100	#VALUE!
strategy of digital marketing	n/a	2400	#VALUE!	n/a	12100	#VALUE!
workshop on digital marketing	n/a	90	#VALUE!	n/a	1000	#VALUE!

Where does Moz get its data from?

According to the article on their website, their accuracy is at about 95%. They are using Russ Jones’ volume bucket methodology and adding in anonymized clickstream data from ~1 million real searchers in the US.

Where does Spyfu get its data from?

Spyfu says they use some of its data from Google AdWords as well but also says the search (volume) numbers are way off just like Moz did. They mention that they use their own in-house method using several different factors stating that, “freakishly right way more than we’re wrong.”

Here is another article that says Spyfu is right 90% of the time for ad budgets and SEO clicks. This article on their website gives more detail on how they come up with their numbers. Spyfu also sites when a company checked how accurate their data was and cited 79% then Spyfu explained how they improved the numbers since this study to bring it up to 90%.

My question is this. If one claims to be 95% correct and the other claims to be 90% correct why are the numbers when comparing the two so far off? Is it because one states they are min and max volume while the other call it local and global value?

Here is the definition of local and global searches from Spyfu:

Monthly Searches

This is the average number of times each month that Google users search this exact keyword, broken into local (country) search volume.

Monthly Searches

This is the average number of times each month that Google users search this exact keyword, broken into global (world-wide) search volume.

Here is the definition of min and max searches from Moz:

Volume ranges show you (with 95% or more accuracy) how often a term or phrase is searched for in Google each month.

Keyword Difficulty

When you compare the ranking difficulty between Moz and Spyfu here is what you find. I calculated this by using a percentage and the range became -52% to 62% difference. Another very large difference. You will also notice that overall there is not a gradual lowest to highest for Moz or Spyfu when sorted by the column ‘Percentage Difference’.

Keyword Analyzed 6/7/2019	Moz Difficulty	SpyFu SEO Difficulty	Percentage Difference
ditgital marketing	61	40	-52.50%
digital marketeer	58	47	-23.40%
define digital marketing	60	52	-15.38%
digital marketing meaning	62	57	-8.77%
digital marketing definition	61	57	-7.02%
definition of digital marketing	61	57	-7.02%
definition digital marketing	59	56	-5.36%
what are digital marketing	58	61	4.92%
digital marketing plan template	47	50	6.00%
digital marketing is	60	64	6.25%
digital marketing what	56	60	6.67%
what is digital marketing	57	63	9.52%
what is the digital marketing	59	66	10.61%
media digital marketing	57	64	10.94%
what is digital marketing?	57	64	10.94%
digital media marketing	62	70	11.43%
digital market	61	69	11.59%
importance of digital marketing	37	42	11.90%
about digital marketing	55	63	12.70%
marketing digital media	59	69	14.49%
digital marketing news	50	59	15.25%
digital marketing trend	44	52	15.38%
why digital marketing is important	38	45	15.56%
digital marketer	58	69	15.94%
/digital-marketing/	61	73	16.44%
digital marketing?	61	74	17.57%
role of digital marketing	41	50	18.00%
digital marketing	60	74	18.92%
the future of digital marketing	38	47	19.15%
digital marketing future	39	49	20.41%
digital marketing vs traditional marketing	23	29	20.69%
future of digital marketing	38	48	20.83%
content digital marketing	49	62	20.97%
digital marketing tools	44	56	21.43%
digital marketing trends	40	51	21.57%
digital marketing content	47	60	21.67%
digital markets	52	67	22.39%
digital marketing tool	44	57	22.81%
online digital marketing course	47	61	22.95%
power digital marketing	45	59	23.73%
digital marketers	53	70	24.29%
future digital marketing	39	52	25.00%
benefits of digital marketing	30	40	25.00%
traditional marketing vs digital marketing	23	31	25.81%
digital marketing trainers	40	54	25.93%
digital marketing tips	41	56	26.79%
digital marketing videos	38	52	26.92%
example digital marketing strategy	40	55	27.27%
digital marketing plans	37	51	27.45%
why digital marketing	42	58	27.59%
learn digital marketing	44	61	27.87%
digital business marketing	48	67	28.36%
strategic digital marketing	45	63	28.57%
digital marketing courses online	47	66	28.79%
how to do digital marketing	42	59	28.81%
digital marketing strategy examples	39	55	29.09%
digital marketing tutorial	36	51	29.41%
digital marketing course online	48	68	29.41%
tips for digital marketing	38	54	29.63%
course digital marketing	50	72	30.56%
new digital marketing	45	65	30.77%
benefits digital marketing	29	42	30.95%
marketing digital	51	74	31.08%
online digital marketing courses	48	70	31.43%
digital marketing case studies	26	38	31.58%
online digital marketing classes	45	66	31.82%
digital marketing tutorials	38	56	32.14%
digital content marketing	40	59	32.20%
digital marketing online course	48	71	32.39%
digital marketing courses	50	74	32.43%
digital marketing for dummies pdf	35	52	32.69%
digital marketing class	47	70	32.86%
digital marketing introduction	36	54	33.33%
digital marketing course	48	72	33.33%
courses in digital marketing	48	72	33.33%
courses on digital marketing	48	72	33.33%
benefit of digital marketing	28	42	33.33%
digital marketing online	47	71	33.80%
course of digital marketing	47	71	33.80%
social media marketing courses online	42	64	34.38%
kpi digital marketing	32	49	34.69%
digital marketing blog	28	43	34.88%
digital marketing online class	46	71	35.21%
digital marketing objectives	29	45	35.56%
course in digital marketing	47	73	35.62%
online digital marketing	45	70	35.71%
digital marketing for dummies	36	56	35.71%
digital marketing planning	36	56	35.71%
digital marketing case study	25	39	35.90%
digital marketing for b2b	32	50	36.00%
what is a digital marketing strategy	40	63	36.51%
strategy for digital marketing	40	63	36.51%
digital marketing mix	33	52	36.54%
b2b digital marketing	31	49	36.73%
advantages of digital marketing	24	38	36.84%
digital marketing analyst	36	57	36.84%
digital marketing analytics	41	65	36.92%
marketing digital definicion	29	46	36.96%
digital marketing basics	34	54	37.04%
what are digital marketing strategies	39	62	37.10%
digital marketing training	39	62	37.10%
digital marketing classes online	44	70	37.14%
digital strategy marketing	44	70	37.14%
types of digital marketing	27	43	37.21%
digital marketing kpi	32	51	37.25%
digital marketing platforms	37	59	37.29%
digital marketing articles	35	56	37.50%
digital market strategies	40	64	37.50%
digital marketing platform	38	61	37.70%
digital marketing campaign	33	53	37.74%
digital marketing benefits	28	45	37.78%
courses for digital marketing	44	71	38.03%
digital marketing services	29	47	38.30%
digital marketing course near me	45	73	38.36%
digital marketing strategy	40	66	39.39%
digital marketing strategy.	40	66	39.39%
digital marketing podcast	35	58	39.66%
strategy of digital marketing	38	63	39.68%
what is digital marketing strategy	39	65	40.00%
digital marketing classes	44	74	40.54%
digital marketing trainer	35	59	40.68%
digital marketing as a service	32	54	40.74%
digital marketing advantages	26	44	40.91%
digital marketing b2b	30	51	41.18%
blog digital marketing	30	51	41.18%
digital marketing plan	34	58	41.38%
digital marketing businesses	39	67	41.79%
strategies for digital marketing	39	67	41.79%
companies with digital marketing	39	67	41.79%
digital marketing pdf	29	50	42.00%
digital marketing work	37	64	42.19%
digital marketing strategist	30	52	42.31%
services of digital marketing	30	52	42.31%
digital marketing strategies	39	68	42.65%
digital marketing benefit	29	51	43.14%
digital marketing specialist	34	60	43.33%
digital real estate marketing	30	54	44.44%
marketing online service	40	73	45.21%
digital marketing conference	30	55	45.45%
digital channel marketing	30	55	45.45%
digital marketing analysis	31	57	45.61%
advantage of digital marketing	25	46	45.65%
digital marketing freelance	33	61	45.90%
digital marketing funnel	27	50	46.00%
digital marketing service	28	52	46.15%
digital marketer conference	29	54	46.30%
digital marketing roles	29	54	46.30%
website digital marketing	45	84	46.43%
digital marketing consulting	31	58	46.55%
digital marketing specialists	33	62	46.77%
digital marketing for business	35	66	46.97%
digital marketing blogs	27	51	47.06%
funnel digital marketing	28	53	47.17%
digital marketing conferences	28	53	47.17%
business digital marketing	35	67	47.76%
digital marketing near me	39	76	48.68%
digital marketing workshop	24	47	48.94%
digital marketing for real estate	26	51	49.02%
digital marketing consultants	29	57	49.12%
master in digital marketing	32	63	49.21%
digital marketing website	42	83	49.40%
digital marketing real estate	25	50	50.00%
real estate digital marketing	25	50	50.00%
digital marketing agency near me	39	78	50.00%
introduction to digital marketing	27	54	50.00%
digital marketing funnels	27	54	50.00%
digital marketing channels	27	54	50.00%
freelance digital marketing	31	62	50.00%
digital marketing freelancer	30	60	50.00%
workshop on digital marketing	22	44	50.00%
marketing company online	40	81	50.62%
digital marketer near me	39	79	50.63%
digital marketing company	38	77	50.65%
digital marketing agency	38	77	50.65%
digital marketing software	34	69	50.72%
seo in digital marketing	34	69	50.72%
digital marketing expert	28	57	50.88%
digital marketing agencies	38	78	51.28%
digital agency marketing	37	76	51.32%
seo digital marketing	35	72	51.39%
digital marketing seo	34	70	51.43%
masters in digital marketing	32	66	51.52%
online marketing agency	41	85	51.76%
service digital marketing	28	59	52.54%
digital marketing solution	25	53	52.83%
freelance digital marketer	28	60	53.33%
marketing digital agency	36	79	54.43%
digital marketing firm	39	86	54.65%
online marketing company	36	80	55.00%
digital marketing solutions	27	61	55.74%
digital marketing consultant	27	61	55.74%
digital marketing agency us	36	83	56.63%
agency digital marketing	35	81	56.79%
master digital marketing	31	73	57.53%
digital marketer agency	34	81	58.02%
digital marketing strategy pdf	18	43	58.14%
digital marketing books	23	55	58.18%
master of digital marketing	30	73	58.90%
digital marketing consultancy	22	54	59.26%
internet marketing agency	35	86	59.30%
digital marketing experts	24	60	60.00%
digital marketing agency usa	33	84	60.71%
web marketing agency	34	87	60.92%
digital marketing company usa	32	82	60.98%
digital marketing agency in usa	32	84	61.90%
digital marketing company in usa	31	82	62.20%

I would be very interested in your comments below about these findings and what you think of the two is the most accurate?

Affiliate Marketing

Affiliate marketing is basically the process of marketing someone else’s product. If you promote their product on your website and they click a link to purchase it on their website you will get a percentage of the sale called a commission.

Although many see this as passive or residual income, a lot of hard work has to be done to build up a reputable website that gets a lot of traffic before you can reap the benefits of very little work to obtain passive or residual income. After this is done then very little maintenance is needed. If you happen to have a website that already gets a ton of traffic then just dive in.

Physical Products vs. Subscription Services vs. Digital Products

For physical products, the money you get will be one-time only. But if you make a sale that is subscription based you can continue to get a percentage of the sale for as long as the consumer uses your affiliate’s subscription service. Many digital products that you can promote to sell are based on a subscription basis such as SEO tools, but also can be a software game that is a one-time purchase.

Commission Rate

A commission rate is the percentage of the sale you will receive after they make the purchase from one of your links to their products. For example, a 4% commission rate on an item is $4.

Cookie Duration

A cookie is a bit of code embedded on the link on your website that people follow when they make a purchase of the product you are promoting. This allows the affiliate or affiliate marketing company to know who the sale comes from so that they can pay you. Cookie duration is a time-stamp on the link you provide on your website that allows you to receive credit for the sale as long as it is within that time-stamp. For example, if the affiliate or affiliate company has a cookie duration of one day this means that the person who clicked the link on your website has one day to make the purchase on their website in order to qualify that you get paid.

The interesting thing about this is that even though Amazon’s cookie duration is only 24 hours there is a plus side to using Amazon. Once they make the purchase on Amazon’s website if they purchase anything else within the 24-hour time frame you will get credit for those purchases as well. This means that if they follow a link on your website to purchase a camping tent on their website the visitor will see ‘Related Products’ on Amazon’s website that they can purchase and if they purchase some sleeping bags also you will get credit for that as well. As a side note, Amazon was the first website that utilized ‘Related Products’ and ‘People who have purchased this have also purchased…’ which I feel was the shopping selling technique that really put them on the map. This technique alone helped generate over 300% more sales on their website and this technique has been copied many times in other shopping cart websites.

Acceptance by Affiliates

You may think that it is easy to be allowed to sell their products. In the case of eBay, this is true but in the case of many other affiliates, you have to be accepted by their guidelines such as having an important enough website that gets enough traffic. If you cannot meet the specific affiliate guidelines then you cannot be accepted to sell their products on your website.

Affiliate List

There are many affiliates and affiliate marketing company’s out there. Here are some of them listed below that pertain to hobbies that I am interested in. Cars and the Outdoors. It would be important for you to pick an affiliate that you are passionate about what you would want to sell to people. To find an affiliate that matches what you love type into google “what I love” affiliate program. Where you replace “what I love” with “cars” or “outdoor” or whatever. It is important to put what you love in quotation marks to help with searching for your custom affiliate program to use. When you put something in quotation marks into Google search it will look for that EXACT phrase.

Automotive Affiliates
- Advanced Auto Parts
  - Niche: Automotive
  - Type: Physical Goods
  - Commission Rate: 4%
  - Cookie Duration: 30 Days
- Amazon
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission Rate: 1% to 10%
  - Cookie Duration: 24 Hours
- Auto Anything
  - Niche: Automotive
  - Type: Physical Goods
  - Commission Rate: 2%
  - Cookie Duration: 1 Day
- AutoBarn.net
  - Niche: Automotive
  - Type: Physical Goods
  - Commission Rate: 8%
  - Cookie Duration: 45 Days
- Autozone
  - Niche: Automotive
  - Type: Physical Goods
  - Commission Rate: 3%
  - Cookie Duration: 45 Days
- Avis
  - Niche: Automotive Rental
  - Type: Service
  - Commission Rate: 4%
  - Cookie Duration: 1 Day
- BuyAutoParts.com
  - Niche: Automotive
  - Type: Physical Goods
  - Commission: 5% to 8%
  - Cookie Duration: 7 Days
- JC Whitney
  - Niche: Automotive
  - Type: Physical Goods
  - Commission: 8%
  - Cookie Duration: 30 Days
- Tire Rack
  - Niche: Automotive
  - Type: Physical Goods
  - Commission: 6%
  - Cookie Duration: 60 Days
- Vivid Racing
  - Niche: Automotive
  - Type: Physical Goods
  - Commission: 4% to 5%
  - Cookie Duration: 30 Days
Outdoor Affiliates
- Amazon
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission Rate: 1% to 10%
  - Cookie Duration: 24 Hours
- Backcountry
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 4% to 12% depending upon product
  - Cookie Duration: 30 Days
- Bass Pro Shops
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 5%
  - Cookie Duration: 30 Days
- Cabella’s
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 3%
  - Cookie Duration: 14 Days
- CampingMaxx
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 10%
  - Cookie Duration: Unknown
- Coleman
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 5%
  - Cookie Duration: 14 Days
- Hyperlite Mountain Gear
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 8%
  - Cookie Duration: 30 Days
- Marmot
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 8%
  - Cookie Duration: 90 Days
- Moosejaw
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 3% to 10%
  - Cookie Duration: 30 Days
- Mountain Hardware
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 8% to 10%
  - Cookie Duration: 21 Days
- Outdoor Gear Exchange
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 6%
  - Cookie Duration: 30 Days
- REI
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 5%
  - Cookie Duration: Unknown
- Sportsman Guide
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 1%, 3%, 7%, and 10%
  - Cookie Duration: 7 Days
- US Outdoor
  - Niche: Outdoors
  - Type: Physical Goods
  - Commission: 8%
  - Cookie Duration: 120 Days
Affiliate Marketing Companies
- AvantLink
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission: Varies by Vendor
  - Cookie Duration: Varies by Vendor
- AWIN: Global Affiliate Marketing Network
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission: Varies by Vendor
  - Cookie Duration: Varies by Vendor
- Clickbank
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission: Varies by Vendor (Can be as high as 50%!)
  - Cookie Duration: Varies by Vendor
- Commission Junction
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission: Varies by Vendor
  - Cookie Duration: Varies by Vendor
- eBay
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission: 50% to 70% of Auction Fees
  - Cookie Duration: 24 hours for buy it now and 10 days for auctions
- Peerfly
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission: Varies by Vendor
  - Cookie Duration: Varies by Vendor
- ShareASale
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission: Varies by Vendor
  - Cookie Duration: Varies by Vendor
- Skimlinks
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission: Varies by Vendor
  - Cookie Duration: Varies by Vendor
- Walmart
  - Niche: Everything
  - Type: Physical and Digital Goods
  - Commission: 1% to 4%
  - Cookie Duration: 3 Days