How to Analyze Affiliate Data Like a Pro (and Why It’s Important)

How to Analyze Affiliate Data Like a Pro (and Why It’s Important)

How to Analyze Affiliate Data Like a Pro (and Why It’s Important)


Wanna know a life-changing, jaw-dropping truth:

Excel is the best thing you’ll ever be able to explore in this god forsaken, barren land we call earth!

Don’t forget that info is power.

This power is the result of a super thorough analytical mindset.

You must know everything.

Every detail is a giant step for you to know more and become better.

The ability to know everything comes through Excel and its many awesome tools for data analysis.

In this article, us Excel experts are gonna explore some of the most crucial data parameters you must bear in mind to succeed.

We’re gonna go through all the relevant details, with a special focus on what’s gonna help you be the king of media buying analysis.

We will refer to the most important Excel tools and show you how to use them for max efficiency.

Ready for a post about the best Excel tips and tricks for affiliates?

Prepared for some awesomely advanced Excel tricks that will optimize your media buying experience?

Let’s begin our journey through affiliate marketing databases and learn some super cool Excel tricks!

The Importance of Affiliate Data

In your life, you’ll be tasked with making a bunch of relevant decisions.

Where should you buy groceries if you want the cheapest supermarket prices?

Which restaurant to pick for a lovely night out with your boo?

How do you deal with all these decisions and their ramifications?


You always need information to decide.

How do you get this info?

By analyzing data.

man analyzing data

This is why a complete dataset makes all the difference.

Quality data usually means quality decisions.

Why not always?

Because it depends on the way that data is actually analyzed.

Later on, we’ll go through the data-analysis best practices.

For now, though, we’re gonna focus on datasets.

Which question should we ask ourselves?

“Which is the most relevant data to know in the media buying game?”

Ready for a rundown of important affiliate metrics?

Let’s go check them so that you can be ready for the best tips and tricks for Microsoft Excel!

Affiliate Metrics: Data Becomes Real

You know as well as any other affiliate marketer out there that affiliate metrics are remarkably important.

They allow you to measure results and get the data you need to optimize faster like a master!

Ready to understand which are the metrics for affiliate marketing that you need to check to analyze that sweet data?


The quantity of clicks you received in a banner.


The quantity of visits on the prelander or landing page.


The costs you must pay to generate the number of clicks/visits you have.

It’ll always be a relation between volumes and the costs per click/impressions/visits you have.


The number of conversions/subscriptions you get from your traffic.


The revenues you’ve gotten from the conversions/subscriptions your traffic has generated.

person with money bills

It’s always a relation between the CPA/payout and the number of conversions.


What you’ve really earned.

This is your profit.

The revenues minus the costs.

This is the info you need if you want to start.


You wanna dive deeper?

Then we’ll have to start exploring a real special little something:

Affiliate data details.

The Difficulty of Analyzing Data in Affiliate Marketing

You’re analyzing data.

The vibe is right, you seem up for it, it’s all going your way.

But wait!

What’s the main difficulty you experience when analyzing data in affiliate marketing?

There are three main issues that come about.

Let’s check each one in detail, shall we?

Three Data-Related Difficulties


Now here’s something that can be super hard.

The quantity of data can make sure that tracking volumes is a complicated endeavor.

If you start by working on a couple of campaigns, then maybe you can follow their evolution.

What if you begin adding campaigns willy-nilly?

Tracking all the volumes is gonna get mighty complex.

The difficulties will start troubling you.

worried man

You’ll have a hard time understanding which campaigns are losing money and where.

What to do?

Follow our advice and check a couple of tools.

Tracking Platform

This is where you can configure the campaigns and receive all the information you need to calibrate optimizations like a master.

You can track conversions made by country, carrier, operating system, device, browser and much more.


You’ll need to analyze huge databases.

This means you’ll need a tool like Excel to help you.

In this article, we’ll show you how to use it properly for you to really take max advantage.


If you want to succeed in this industry, you need to go into detail.

You must thoroughly analyze each parameter and its many correlations.

You’ll need to know your most profitable campaigns and where you should focus your attention.

Look at the websites and understand which ones are golden.

Check operating systems with a high performance and others which aren’t as well known.

Look for the specific niches in which you can increase your profits.

bills of money falling


With so many parameters, it’s only natural that there are many correlations.

One of the most obvious correlations is the one which occurs between the iOS operating system and iPhone/iPad devices.

iOS not showcasing the best results?

It may be due to one of those devices.

There are lots of unexpected correlations.

For example, don’t expect that certain sets of banners will only work for a particular website.

What to do?

Go into detail.

Check different correlations that may appear.

For that, you need a tool that allows for an easy and super fast analysis.

Is it Excel, you ask?

You know it, bro!

How to Analyze Data in Media Buying Campaigns

Do you wanna analyze media buying campaigns like a master?

Then it’s super important to have a great tracking solution or at least to configure the postback correctly.

It’s the only way for you to get relevant and highly-valuable data to analyze.

Let’s say that you have one of these tools implemented.

Then it’s gonna be easier for you to effectively optimize your data using Excel.

Excel allows you to match, configure, relate and organize data.

This will allow you to come up with conclusions.

But how can you analyze a media buying campaign?

Check some clues!

Analyzing Campaigns


First thing to do?

Get an overall view of your campaigns.

Which ones are losing, which ones are mighty profitable and which ones need your immediate attention.

How to do it?

Just match the campaign’s revenues and the campaign’s costs per day.

You’ll have an idea about how your investment is actually going and what’s the effective impact of your actions.

excel parameters

Look for margin rates.

It’ll help you control your investment and to know when to stop or invest more.

First, go and check the campaign which appears to be losing a whole lotta money.

Then, take quick and swift action.

This will have a major impact on the total margin.

Now’s the moment to go into detail.

Choose a campaign and analyze all the parameters thoroughly.

Check for heavy losses, websites, devices, operating systems, etc.


We may begin the optimization by looking at banners.

banner parameters

Always have 3 banners.


Because you should be following the optimal rule of banners.

Two good banners and one that you wanna test.

See the image above?

We believe it’s easy to see that the banner which has the highest CTR is also the one with the lowest eCPA.

It isn’t always the case.

Even so, it’s frequent that there actually is a correlation between both.

What to do?

Stop banner 3 and add a new one to be tested.

Pro tip:

Always remember that banners have no correlation with other parameters!


websites parameters

Let’s imagine your campaign has a payout of 0.85€.

Looking at the eCPA values, it’s easy to see that SITE 5 is the one you should stop.

Devices VS Operating Systems

devices parameters

operating systems parameters

In these two images, you can see that Android is correlated with several devices.

Let’s suppose that the payout is 0.50€.

It means that – with an eCPA of 0.53€ for Android – you’re losing money.

Should you stop Android?


Why not?

Because of correlations.

Samsung, Samsung tablets and Lenovo are the sources of the bad performance.

Stopping these will make Android profitable and the campaign positive.

By analyzing the correlations, you’ve made your campaign profitable.

There are also positive correlations.

Check your best targets, the correlation between them, and then target those specific ones by creating a new campaign.

Finally, take a look at the prices of your campaign.

campaign prices

On day 6, there’s a decrease of impressions and a CPM increase due to competition.

In this case, it’s clear that someone has gotten your position, therefore decreasing both your volumes and traffic quality.

Since your CPM increased, someone has been able to get a position below you.

The result is an increase of the eCPA, which may turn a profitable campaign into a black hole.

These analyses are fundamental if you want to turn your campaigns into gold mines.

With Excel, you can improve your efficiency and reach the next level.

How to use Excel to Analyze Data in Media Buying Campaigns

Excel is an extremely useful tool for data analysis.

If you don’t want to get involved with programming, then Excel really is both the fastest and easiest tool for you to use.

Anyone can learn how to explore Excel.

It’s just a matter of getting used to the functions and their specific goals.

Why is Excel the belle of the ball?

Here are three good reasons why!

  • Easier to analyze data
  • Great at summarizing in different ways
  • Useful for you to compare building a pivot table report instead of having to go through the process of building the same report manually

Boring, indeed!

Mobile marketing gets bigger, more popular, and more interesting by the minute.

As you get into it, you’ll understand that there are a lot more parameters and variables to be tracked and analyzed.

Through the use of pivot tables, you can perform a successful A/B testing and also split test offers.

There are even some Excel Pivot table tricks you can use to maximize success.

Excel will basically help you create cross tabulations of keywords.

Pivot Tables provide you with a versatile way to handle all those extra columns that you have to deal with in your reports.

Then, all this precious info will be processed through pivot tables in order to optimize your campaigns.

Pivot tables are terrific to analyze data on the fly without building a full program.

This really is one of the best tricks in Microsoft Excel, brother!

You don’t even have to know any Excel formulas.

The name “Pivot Table” somehow makes it sound like it’s some advanced gizmo only reserved for Excel wizards.

It’s actually quite the opposite.

It’s an easy, fast, yet powerful way for marketers who aren’t familiar with Excel to quickly analyze large amounts of data.

Are you someone who believes Excel gives you a general headache?

We both promise this experience is gonna be free of agonizing pain!

Compare building a pivot table report to the process of building the same report manually.

Excel Features You Can Use to Analyze Data

Analyzing your data used to be quite the boring process.

It was a ton of work.

With Excel, though, everything changes for the better.

Indeed, with this amazing tool, it’ll only take a few steps for you to analyze like a pro.

You can instantly create different types of charts, including line and column charts, or add miniature graphs.

You can also apply a table style, create Pivot Tables, quickly insert totals, and apply conditional formatting.


So many cool tricks in Excel, so little time!

Here’s a neat trick we’ll teach you.

Trick – First Part

Select the cells that contain the data you want to analyze.

Trick – Second Part

Click the Quick Analysis button that appears at the bottom right of your selected data (or press CRTL + Q).

quick analysis excel

Which analytical feature should you use?

If you’re not sure which analytical option to pick, here’s a quick overview.

Analytical Tool Overview

Quick Analysis

In the “Quick Analysis” gallery, select the tab you want.

For example, formatting lets you highlight parts of your data by adding things like data bars and colors.

This lets you see high and low values, among other things.

formatting excel


Excel recommends different charts, based on the type of data you’ve selected.

If you don’t see the chart you want, click on “More Charts”.

charts excel

You might notice that the options you can choose from aren’t always the same.

That’s because the options change based on the type of data you’ve selected in your workbook.


Totals allow you calculate the numbers in columns and rows.

For example, the “Running Total” inserts a total that grows as you add items to your data.

Click the little arrows on the right and left to see additional options.

totals excel

Tables make it easy for you to filter and sort your data.

tables excel

Sparklines are like tiny graphs that you can show along your data.

They provide you with a quick way to see trends.

sparklines excel

Best Excel Shortcuts for Data Analysis

There are hundreds of Excel shortcuts and tricks for you to explore.

The problem with this is that it can become overwhelming for you to have to know them all by heart.

You can’t possibly absorb 233 new shortcut keys and start using them.

That’s why we’ve got you covered, bro!

The following sections cover some of the best shortcut keys.

Try to incorporate a new shortcut key into your Excel routine every week.

Prepared for a lesson about the best tricks in Excel?

Dive into it!

Excel Shortcuts List

Move Quickly

This is one of the best Excel shortcuts tips and tricks.

Let’s understand how to move quickly among worksheets.

Ctrl + Page Down jumps to the next worksheet.

Ctrl + Page Up jumps to the previous worksheet.

Let’s pretend that your workbook has 12 worksheets named Jan, Feb, Mar, . . . Dec.

If you’re currently on the Jan worksheet, hold down Ctrl and press Page Down five times to move to Jun.

Great, isn’t it?

It really is one of those awesome Excel tricks for you to explore.

Jump to the Bottom

Jump to the bottom of data with Ctrl+Arrow

As long as there are no blank cells in your data, just press Ctrl+Down Arrow to move to the last row in the data set.

Use Ctrl+Up Arrow to move to the first row in the data set.

Quick and easy!

Keep reading for some more useful tricks in Excel.

Current Region

This is one of the most important and useful Excel tips and tricks for beginners.

Select the current region with Ctrl+*

Press Ctrl * to select the current range.

The current range is the whole dataset, in all directions from the current cell until Excel hits the edge of the worksheet or a completely blank row and column.

Let’s say you’ve just selected A2:J987654 but you’re staring at the bottom-right corner of your data.

Press Ctrl + Period to move to the next corner of your data.

Since you’re at the bottom-right corner, it will take two presses of Ctrl + Period to move to the top-left corner.

Even though this moves the active cell, it doesn’t undo your selection.

Popping Open the Right-Click Menu

More useful Excel tricks?

Go for it!

Pop open the right-click menu using Shift + F10

Pressing Shift + F10 opens the right-click menu.

Use the up/down arrow keys to move to various menu choices and the right arrow key to open a fly-out menu.

When you get to the item you want, press Enter to select it.


Date-stamp or time-stamp using Ctrl shift ; or Ctrl shift :

Here’s an easy way to remember this shortcut.

What time is it right now?

It’s 11:21 here.

There’s a colon in the time.

Press Ctrl+Colon to enter the current time in the active cell.

Note that this is not the same as using =NOW() or =TODAY().

Those functions change over time.

These shortcuts mark the time or date in which you pressed the key and the value does not change.

Neat, right?

Another one of those splendid tricks for Excel you have to explore.

Last Task Repeat

Repeat the last task with F4.

Let’s say you’ve just selected a cell.

Here’s what happened next:

Home, Delete, Delete Cells, Delete Entire Row, OK.

You need to delete 24 more rows in various spots throughout your data set.

Select a cell in the next row to delete and press F4, which repeats the last command but on the currently selected cell.

Select a cell in the next row to delete and press F4.

Before you know it, all 24 rows will be deleted.

That’s right!

You didn’t have to click on Home, Delete, Delete Cells, Delete Entire Row, OK 24 times.

The F4 key works with 92% of the commands you’ll use.

Try it.

You’ll love it.

It’ll be obvious when you try to use one of the unusual commands that can’t be redone with F4.

Simple, right?

Now that’s one of the most useful Excel spreadsheet tricks for you to dive into!

Dollar Sign

Add dollar signs to a reference with F4.

When you’re entering a formula and you need to change A1 to $A$1, click F4 while the insertion point is touching A1.

You can press F4 again in order to freeze only the row with A$1.

Press F4 again to freeze the column with $A1.

Press again to toggle back to A1.

The Most Important Excel Formulas You Need to Know to Analyze Data

Ready to use the most famous formulas like a pro?

Need some Excel formula tricks from these two masters?

Pay attention, then!


This is a blessing for any mobile marketer.

It’s one of the best tricks on Excel!

This incredible function is great for comparing and connecting different sets of data.

Basically, this formula will ascertain whether a given value from one table exists in the first column of another table, and then return a value from the second table.



Don’t forget to lock the range of the second table.

This is a common error when copying this formula.


This is pretty useful.

It’s one of those Excel sheet tricks everyone should know.

It comes in handy when you’re creating different keyword lists or adding tracking parameters to URLs:


We personally prefer using the “&” symbol.


Because it’s shorter than typing a full “concatenate” formula, but does the same exact thing.



This is great when you’re writing for a banner.

That’s why it’s one of the most popular Excel tricks and shortcuts for affiliates.

Simply put this formula next to your description cells.

What will happen?

It will tell you when there is more room available, or when it’s over the character limit.


Text to Columns

We find this Excel magic trick to be super useful, especially when we work with destination URL lists.

It’s one of those Excel spreadsheet tips and tricks that you need to grasp!

Let’s say you’ve got a URL report and that you’d like to analyze the performance per unique URL.

However, every destination URL has a unique parameter attached.

Check the image below to see magic happen.

text to columns

Were we right or not?


This is one of those cool Microsoft Excel tricks everyone should know.

Examples of How to Analyze Data Using Excel

You’ve checked all these amazing Excel tricks and awesome examples.

Now, what?

It’s time to put these new Excel tricks into practice.

Doing mobile affiliate marketing?

Then you know as well as we do that there are a lot of variables which can be tracked.

You can track brands, models, carriers, websites and so on.

Imagine you had amazing data about affiliate marketing.

It represented the traffic an affiliate had sent to an offer.

They want to find what they could do with the data to find the campaign’s best-converting segments.

As previously mentioned, Pivot tables will allow you to easily analyze this data.

There are a bunch of Excel pivot table tips and tricks for you to know.

Step One

Select all, table.

excel pivot table

Step Two

Insert/Pivot Table/OK

pivot tables insert

Step Three

In any pivot table, you need to fill the box with the corresponding variable.

variable box

a) Filter – pre-selection of what you want
b) Rows – for your x-axis
c) Columns – for your y-axis
d) Values
§ Count
§ Sum
§ Max
§ Min
§ Average

Select the field you want to see in the row fields area.

In this case, you’ll select Campaign.

This is what you want to analyze.

For the columns, press clicks, conversions, and revenue.

Step Four

After this, you need to change the format of the cells accordingly.

Since the revenue isn’t in euros, you need to select the column/format and insert the currency.

Step Five

Wanna check one of the best Excel tricks and tips?

Keep reading!

Imagine you want to analyze CellFlirt – mobile T-Mobile campaign in more detail.

You also wanna analyze its top-converting brands.

It has 27 conversions and 162€ in revenue.

You want to select the field that it’ll open into.

Click “brand”.

It adds all the brands for the campaigns in the row section.

pivot table 2

pivot table 3

The brands will appear for all the campaigns.

Even so, we only want to analyze that specific one.

How to go about it?


Select all/options under pivot table/tools, and collapse the entire field.

After that, just hit the plus button of the campaign you want.

pivot table 4

Since you’re optimizing conversion rates, you want to add a calculated field because the conversion rate isn’t available in the data as it wasn’t calculated.

To do so, insert calculated field & format accordingly, after selecting the pivot table.

Formula = conversions (insert field) /clicks (insert field)

pivot table 5

pivot table 6

The brands Sharp & Softbank have high conversion rates.

The next step would be to insert that field on the report filter and only select those two to pinpoint them.

In order to conclude the analysis, press SubID.

It shows you the ads which have performed best for those two specific brands.

pivot table 7

If you go deeper, you can see that ads 23, 19, 13, 22 are performing better.

Ad 10 is performing poorly.

What to do?

You should pause that ad in those two brands.

Now is this one of the coolest Microsoft Excel tricks or what?


Enjoyed these Microsoft Excel tips and tricks?

Think you know so many great Excel tricks that your affiliate marketing colleagues are gonna feel sad?

Spread the word on these neat Excel tricks, bro!

You know everything you need.

Working on Excel involves a lot of copy-pasting, cleaning, formatting, and calculating.

You can do it all manually, of course.

But you can read up, learn the rules of the game, and use Excel’s mighty powerful functionalities in order to become much more efficient.

The tips that we’ve shown in this article will increase the efficiency of your analysis.

More importantly, they will also make sure you come up with better conclusions.

The actions that you’ll take after coming up with your conclusions will have a huge impact on the performance and profits of your campaigns.

Performance. Metrics. Improvement. Success.

This is what knowing the best Excel tricks is all about.

Use this master article, keep checking the most useful Excel tricks, and become an Excel pro who uses this super cool tool to increase affiliate marketing revenues.


André Martins

Business Intelligence Team Member

Rodrigo Salema

Business Intelligence Analyst

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.


14 Essential SEO Extensions You Should Be Using

14 Essential SEO Extensions You Should Be Using

14 Essential SEO Extensions You Should Be Using


If you work on SEO for your own website or for others, you’ll notice that there are tasks which come with the job.

In fact, on the more technical side, checking redirects, titles and trackers are frequent activities.

On the marketing side, finding keywords, checking whether or not emails were opened, and discovering email addresses in order to perform a sweet outreach are some of the other super common tasks you’ll have to perform.

But what if I could help you speed up these dull processes?

What if I was able to provide you some advice and refer awesome and free Chrome extensions that’ll make it easier for you to explore SEO to the max?

These tools are the cream of the crop.

Trust me:

I use these useful Chrome Extensions with all with my clients at Spark Foundry.

But before I get to officially name these SEO extensions, there’s something you should know.

It’s kind of a disclaimer:

These tools for SEO aren’t magical.

They will only provide amazing clues and help you complete tasks much faster, helping you optimize your time like an SEO professional should.

They won’t turn you into an SEO master, though.

They’ll just help you out!

My hope for the readers of this free SEO tool bonanza?

That knowing these useful SEO tools is gonna improve your whole SEO process!

Let’s see if I can get you to be more productive!

Ready to be wowed by this phenomenal list of free SEO tools?

Then check the best SEO tools for marketing pros and some of the coolest Chrome extensions you’ll need to get!

I promise you won’t need to start learning how to make a Chrome Extension since these features for SEO are gonna rock your world!

Let’s find the best SEO tool, shall we?

List of the Best SEO Chrome Extensions

Time to find the best On-Page SEO tool for you!

Ready for some small SEO tools that will help you big time?

I promise these are all of the very best FREE SEO tools for you to check and improve your skills!

Here’s the list of the very best SEO Chrome Extensions!

1. Wappalyzer

Wappalyzer chrome extension

Ready for one of the best free SEO tools alive today?

Go for it!

Want an SEO tool that effectively helps you find out about the specific technologies a website is using?

Want to be able to get to know which CMS the website uses?

Feel like you have to understand the analytics, the type of advertising networks the website plays with, the sort of web server, and much more?

Then Wappalyzer is key to your SEO experience and a wicked Google SEO analysis tool you need to check!

Normally, you’d need to know the website’s owner.

You’d have to run into him on some shady street and ask away.

No need.

This useful SEO tool is here for you.

Get to know the exoskeleton of a website, what makes it tick and what secrets lie beneath the technologically crafted surface.

This SEO master tool is remarkably important in your SEO research process.

Use it well!

2. BuiltWith

builtwith chrome extension

This great platform for SEO enthusiasts is quite similar to Wappalyzer.

I consider it a basic SEO tool that everyone should explore.

Just like the previous tool, BuiltWith gives you details of how a website is built, providing even more info, including which JS libraries, trackers, APIs, alternative mobile versions, which server is hosting a website and much more.

It will definitely provide more details than Wappalyzer.

Even so, the interface can be a bit messier.

This means that BuiltWith is probably a better option in case you happen to be a developer, since it definitely needs its users to have a coding background.

Is this one of the best Extensions for Chrome or what?

3. Full Page Screenshot

Full Page Screenshot chrome extension

This is not an SEO tool but it can save you a whole lotta time, in case you’re a guy who takes screenshots every single day.

I personally need to screenshot SERPs a lot.

And guess what?

I had no idea there was a simple way to take a clear shot of the whole screen, including the part I normally would have to scroll to get to see.

It doesn’t work on all pages.

Even so, you can use it to photograph not only Google’s SERP but most of the other search engine tools around.

Loved this Chrome Extension screenshot tool?

Move on to another must have Chrome Extensions, then!

4. Grammarly

Grammarly chrome extension

There’s a crime out there.

It’s on the rise but nobody wants to talk about it.

What is it, you ask?

Haphazard outreach emails filled with spelling mistakes!

Is there a way to fix this plague?



Don’t wanna start off with the wrong foot when it comes to the outreach stage of your SEO efforts?

Boy is this the tool for you.

Grammarly is a super awesome tool that anyone writing in English should get.

This is a very good grammar and spelling tool which is able to catch a whole lotta mistakes.

Indeed, it catches more than the usual checkers from Microsoft or Google Drive.

To top it all?

Grammarly will actually provide explanations for you to be able to understand what you wrote wrong and become a better copywriter.

Don’t get me wrong:

It’s not a miracle worker!

You shouldn’t trust it blindly, or try to get by without ever reading a book, writing a gibberish-filled version of English and hoping this tool can save you when the time comes.

Even so, this will surely save you from some shamefully embarrassing moments.

Grammarly also has a paid version.

My opinion?

The one they provide for free will do the trick!

Now that’s one of the best Google Chrome extensions for SEO players!

5. Redirect Path

Redirect Path chrome extension

Google SEO tools that do wonders?

Here we go!

Temporary redirects (302) are some of the most common mistakes SEO masters find on their daily activities.

They also find that some websites keep forgetting the redirects between the www, the non-www redirects, and the trailing slash redirects, making the same page available on many URLs.

Is there a way to avoid this chaotic mess?

Am I ready to recommend another one of my awesome extensions for Chrome?


Redirect Path is your friend!

This extension will track every single page as soon as you open it and tell you what type of response code the browser received.

If anything else but a standard 200 response code is found, you don’t even need to click on the extension to see the result.

Redirect Path tracks all the steps, and is also quite helpful when it comes to finding pages with several redirects.

Another one of those awesome Chrome Store extensions you need to explore!

6. Ghostery

Ghostery chrome extension

Feel a conspiracy theory kicking in and need one of the top SEO spy tools in the business?

Wonder how many different ways there are to spy and track you?

Think you’re being tracked as you visit a specific web page?

Ghostery to the rescue!

This tool will allow you to find out what kind of trackers are onto you.

This tool for SEO is more than helpful.


Because having too many trackers messing up your game can truly be damaging.

In fact, it can actually slow down your page’s loading speed.

Use this tool to find out whether or not there are any unnecessary trackers corrupting your chances for SEO success.

It’s common to forget an old tracking pixel on a website, as it doesn’t seem to cause any harm.

But what if nothing relevant is being tracked?

Why should users have to load resources and make their whole experience much slower and boring?

No more!

Speed up your life with Ghostery!

It’s one of the top Chrome Extensions for you to explore!

7. Hunter

Hunter chrome extension

As an SEO expert, you need to contact people all the time.

But tell me:

How many minutes and hours of your day are spent as you try to actually find the contact info you’re looking for?

A whole lot, I imagine.

Don’t worry!

Hunter has a smart system which finds the most frequent pattern for a domain (e.g. ), scans the website for emails mentioned on any page, and gives you a good guess of the email you need.

If you outreach writers constantly, this Chrome extension is a real time saver.

8. MozBar


This truly is one of the best Moz SEO tools around and one of those free online SEO analysis tools everyone should dive into!

Regardless of whether or not you trust the domain and page metrics given by SEO tools such as Open Site Explorer, you should definitely use MozBar.

To do what?

To take a look at the page code without opening a confusing page of HTML code.

It’s an SEO analysis tool that changes everything!

The MozBar will extract the title, description, canonical, cache, http status, structured data and highlight the types of links present on a page (follow, no-follow, internal, external).

Awesome SEO bar for you to use, right?

You know I only provide the Google Chrome extension you need to succeed!

9. Keywords Everywhere

Keywords Everywhere

Wanna check the search volume for a specific keyword directly on the SERPs?

Want an SEO keyword tool that rocks?


This SEO keyword research tool shows the data for the query searched as well as the “people also ask for” suggestions.

Unfortunately, you can only find data for keywords written in English.

You can also use this SEO keyword tool online to check the search volume for some markets such as the US, UK, and Australia.

Besides the SERPs, Keywords Everywhere also presents the data directly in tools such as Amazon, eBay, Answer The Public, Majestic (Anchor Text Report), YouTube and 12 other services.

Love this SEO keywords tool as much as I do?


10. HubSpot Sales

hubspot sales extension

One of the best SEO software tools in the biz?

One of those awesome HubSpot SEO tools that keeps on giving?

Let’s go!

This tool supports sales with many features.

The one I find most useful as an SEO?

The email tracker.

You need to register once.

Then, every email sent via Gmail or Outlook can be tracked.

It’s really useful, since it allows you to know whether or not someone is opening your emails many times, which can be a signal that they’re interested in whatever you’ve offered.


This tool only works on desktop.

You’ll also have some trouble in case the email is sent or forwarded to several people, as the tracking doesn’t know who opened it.

This amazing SEO tool gives you the time and location.

Even though it can be helpful, it’s not the perfect tool for SEO.

11. Check My Links

Check My Links extension

An SEO audit tool that helps you every single day?

One of those perfect SEO monitoring tools which never fail to amaze?

Check My Links is here!

Hunting for some broken links?

Check all the links on a page for broken and redirects in one single click!

This can be useful for you to find opportunities or to create a presentation for a client.

Why is this free SEO audit tool useful in that regard?

Because it allows you to create a visual representation of a coding problem, for instance.

Is this one of the best marketing SEO tools or what?

12. SalesHandy

saleshandy chrome extension

Link building is one of the most important tasks for an SEO.

And sending emails is a critical part to get that done.

So, how to manage this huge task getting most results while investing least time?

I recommend you use SalesHandy. It lets you track email engagement data the exact number of times your emails were opened, link clicks, location, and even gives you details of activities on any documents that you have attached to it. It helps you know if your back-link prospect is engaging with your message or not and optimize your outreach accordingly.

On top of that, it enables you to send personalized email merge campaigns with automated follow-ups saving you lots of time and increasing the response rate of your campaigns.

Moreover, SalesHandy uses drip-method to send email merge campaigns adhering to Gmail’s daily sending limit, making sure you get higher email deliverability.

It’s a great Chrome extension that helps you get more done using emails!

13. Mangools SEO Extension

mangools seo extension

This extension brings the data from the Mangools SEO suite any time you need it when browsing the internet.

Without using any tool and without leaving the current tab, you’ll get the most important SEO metrics such as Domain Authority, Page Authority, Citation Flow and Trust Flow altogether with popularity metrics including the Alexa Rank, number of referring IPs and Facebook shares.

What’s more, you’ll get the list of backlinks with options for in-depth analysis in the Mangools tools in one click.

The Mangools SEO extension provides an on-page analysis to spot any optimization errors in meta tags and headings.

It includes the SERP preview tool, keyword density checker, word counter and page speed analysis tool. You’ll also find any broken outbound links and their anchor texts.

One thing I really like about the extension is that it provides context menu integrations and advanced features available directly in the SERP.

Related: Take advantage of our exclusive KWFinder discount.

14. Nightwatch SEO Search Simulator

nighwatch seo extension

Tired of having to use Incognito mode, proxy or VPN to check your unbiased rankings?

Not anymore!

Nightwatch SEO Search Simulator let you simulate search engine queries from any location on Google.

This is the easiest way for you to check and track your website or your competitor’s rankings. It’s free, easy to use and can save you tons of time.

It’s a great extension that simplifies work for any marketer and SEO professional who wants to use an intuitive solution for rank tracking to check positions of the chosen websites in the SERP.


Loved these SEO optimization tools and Chrome Extensions?

Wanna start developing Chrome Extensions to help other SEO marketers?


Now, tell me something:

Which SEO extensions do you use and why do you use them?

There are some White Hat SEO tools which aren’t necessarily made for a certain purpose, but you should make sure to maximize them, using them for your specific SEO efforts!

I hope this article has been able to help you save some time, find new insights, and achieve better SEO results.


Visit the Chrome Extension Store, explore more online SEO tools, and start taking SEO to a whole new level of productive perfection!

I want you to be able to manage Chrome Extensions to maximize SEO success.

Use these top SEO tools to reach the sky!


Gustavo Pelogia

SEO Client Manager at Spark Foundry

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.


SEO Affiliate Marketing: A Comprehensive Guide

SEO Affiliate Marketing: A Comprehensive Guide

SEO Affiliate Marketing: A Comprehensive Guide

Hello, internet marketing enthusiast! We’re glad you’re here. If you’re reading this, you probably either want to get started with affiliate marketing or you’re simply looking to launch a new project and want some guidance to help you ensure that you make the right decisions. Either way, we will do our very best to share some great tips with you so that your first or next campaign can get off to a great start!

Ready to start? Let’s go!


Sometimes, the connection between SEO and affiliate marketing can be tricky.

In fact, if a business or a site has a drop in rankings, they often rush to the conclusion that one of their affiliates is to blame.

This is mostly caused by the bad reputation affiliate backlinks have, often without a real reason.

In order to fight this, it’s important to know some good SEO practices for affiliate marketers!

First, it’s crucial that you understand how Google ranks websites.

This helps you build your site in such a way that it ranks highly for a good reason.

In turn, your site generates more revenue, and you can know with certainty that there’s nothing wrong on your end.

In other words, knowing good SEO practices can save you from experiencing a whole lotta pain in your affiliate marketing journey.

What is Affiliate Marketing?

Affiliate marketing is basically the act of promoting someone else’s products or services and earning a commission when someone clicks your link and performs the desired action.

There are a ton of different affiliate networks you can join.

This is great!


Because it helps you market in a niche you’re passionate about.


Moreover, it will also help to keep you interested for the long haul.

If you happen to be a golf nut and you create a site in that specific niche, there’s a good chance that you’ll actually stick with it.

And guess what?

That eternal ability to stick with it is what will eventually lead to your success!

The Process

Here’s the process:

You sign up for an affiliate network and decide on what you want to promote.

You get your affiliate links and place them on your websites, videos, or social networks so that people get to click those links and continue purchasing a product or service.

When your target audience performs the desired action, you get paid.

We mentioned the expression “desired action” because it doesn’t always have to be a sale.

Some affiliate networks offer CPA, which means Cost Per Action.

An example of an action in which the traffic does not need to buy for you to get paid would be when the visitor (traffic) fills out a form and opts in.

It can be that simple!

SEO Affiliate Marketing in 2018: Success Tips for Affiliate Marketers

Let’s get right down to the nitty-gritty!

It’s time to talk about everything you need to know before firing up your affiliate campaign.

We will go over many different things which allow you to better understand how it all works and where everything fits in.

Let’s do this!

Niche Selection

This is a big one and for many reasons.

Indeed, choosing a niche is half the battle!

First things first:

Picking something you’re passionate about is a great way to start!

Another aspect you need to take into account when selecting a niche is whether or not there’s a hungry crowd of people searching for what you might want to offer them.

If you’re involved in the niche and have a good feel for what people are looking for, this should be easy.

Make sure to check whether or not there is actual search volume for keywords that will work with your offers.

If there are no searches, there’s no traffic!

Need some tools you can use that provide keyword search volume and cost per click?

Domain Name

This is a huge factor.

It can really determine whether or not your website is successful.

The choice you have to make is simple:

Either you wanna have a website with a huge authority that can be something you can actually brand, or you wanna go for a short, straight-to-the-point, exact match or partial match domain.

Each method can become a site that earns money, which means you really need to take some time before you launch and decide what are the long-term goals you have for the website.

The beautiful thing about building a large, authority site?

You can always be on top of it and you’ll get to turn a real profit, whereas if you happen to choose an exact match domain to target one main keyword, it could all fizzle out over time as trends change.

For example, if you’re working in the golf niche, do you want to create an authority site that you can keep exploring long-term and use it as a continuous project or do you want to target a specific product or niche within the massive general niche of golf?

IE Footjoy rain pants/ VS Dry Golf Now | Details & Reviews of Latest Waterproof Golf Gear /

The exact match option might produce faster results while the other option could be something you continue to build upon as time goes by.

Is there a right or a wrong way?

No, not really.

You can make money either way, which is why it’s really important that you take some time to ponder upon these crucial matters at the early stages of your endeavor.


Yes, hosting matters.

Whether you’re thinking about SEO, PPC, or social media marketing as a way to generate traffic to the site, hosting plays a bigger role than you may realize.

Think about it:

Do you like going to a slow-loading website and waiting for it to load?

Of course not!

It doesn’t matter what method of traffic generation you’re using:

Visitors will leave the site more often than not and it can affect your SEO efforts.

And then, what?

Before you can even understand what’s going on, there goes your chance of getting a sale!

A quality web hosting solution will be fast, secure, reliable, local, and won’t cost you much.

Who’s got the best hosting for affiliate marketers?

We all have our favorites.

Just make sure you pick a hosting solution that offers you everything that was previously mentioned!


Content will largely depend on your earlier choices.

Did you opt for the route of a targeted niche site or did you choose the long-term, authority-style site?

If you chose the laser-targeted niche site (sometimes called sniper site) you won’t need a ton of content.

It’s important to note that it’s worth the money and/or effort for you to go ahead and get some high-quality, professionally written content for your money pages.

If you’re taking the authority site path, the content will hopefully be handled in-house either by yourself or by someone you’ve partnered with on the project that has the knowledge and passion to keep adding content for many years to come.

Content marketing can bring you loads of targeted traffic.

If you do it right, your blog/site will have followers and regular readers forever!

On-Page SEO

Whether you’re making a sniper site or a blog/authority site you’ll want to get your on-page SEO dialed in.

With the sniper site, it should be pretty straightforward.

You’re targeting something very specific such as footjoy rain pants and your on-page SEO will reflect that.

With an authority-style site, you’ll want the homepage to have a general theme/topic overview.

Later on, you’ll be able to create posts, pages, and sub-pages to target certain keywords.

Your on-page for each post or page will then have its own on-page factors.

Choosing the Right Keywords

Google has changed a lot when it comes to niches, domains, and keywords.

While it’s still a good idea to choose a domain name that’s short and memorable and to have short URLs (Google gives a URL’s first 5 words much more importance than the others), the same no longer applies to keywords.

With the addition of the Hummingbird algorithm to its search engine, Google introduced latent semantic indexing (LSI).

This means the search engine tries to figure out what your article is about based on what you’re actually writing about.

Long tail keywords are also important if you want to rank well!

Instead of competing for the keyphrase “good restaurants”, you’d have much more success in affiliate marketing with a long tail keyword such as “good Italian restaurants in Brooklyn”, for example.

The good thing about these long tail keywords is that, due to LSI, you don’t have to always repeat the complete sentence or even write it in the same order.


Because Google will pick up on it throughout the text, anyways.

There’s a great tool you can use that’s really gonna help you with LSI:


Wondering what you’ve gotta do?

Just insert the keyword you’ve picked to optimize your page on LSIgraph and the tool will work its magic!

You should choose a niche that’s closely connected to the products you’re promoting.

Ideally, you and your writers should be comfortable with it.

One of the most important steps you’ve gotta go through in order to find the right keywords for your site is how you go about implementing keyword research and become a master that’s always one step ahead of all other affiliates.

Are you struggling with this process?

No worries!

You can understand how to research keywords with Google’s algorithm in mind.

Avoid Content Farms and Poor Content

It might sound enticing to just spam as much content that has no real value for the audience, but this practice has been frowned upon for quite a while now.

Trust us:

With the numerous algorithm changes and search engine updates that have come about in the past few years, this practice can actually hurt your rankings!

The best way of getting high Google rankings and a whole lotta traffic is to bet on high-quality content.

You need to engage your audience and provide them something of value.

If you create seriously amazing content that entertains, engages and educates the reader, you’ll definitely get a higher number of backlinks.

Quality will increase your audience’s loyalty and trust, which means that they’ll also be more willing to check out any products or services you’re promoting.

“How can content marketing overtake SEO completely when the only way to successful content marketing is to have SEO?” – Neil Patel

A case study released by Backlinko’s Brian Dean showed that – from an SEO perspective – the ideal length for an article in 2016 is over 1500 words.

This is a radical shift from the time when a 300-word page was considered long.

It all goes to show that the emphasis is on more thorough, well-researched articles.

content lenght in seo

Source: serpIQ

Whatever you do regarding the type and length of your videos, blogs, and presentations, be sure that you’re making them for your target audience, and that it adds value to their lives in some way.

Optimize Your Site for Mobile

We’re long past the time of asking ourselves whether marketing for mobile users is important.

It is.

Over 80% of internet users have smartphones, and it’s estimated that around 50% of all internet traffic is coming from mobile devices.

This means you need to jump on that bandwagon and make your site mobile-friendly if you haven’t done it already.

Luckily, this doesn’t have to cost you much in both time and money, as there are a whole lotta services and templates that can help you with this.

For example, WordPress has several plugins specifically made to help you optimize your site for mobile browsing.

You can easily test your site to check the kind of mobile experience it grants with various third party services – even Google has one.
google page speed insights

Apart from that, you should also know Google PageSpeed Insights gives you solutions so that you can solve your website’s problems and increase speed.

Social Media is Your Friend

In today’s marketing world, social media is king.

Over 95% of online marketers use some form of a social media marketing campaign to promote their brand and establish communication with their audience.


Since it’s very interactive, customers have the feeling that they’re communicating with other people, instead of connecting with a faceless corporation.


Conversion rates are much higher.

Hubspot studies show that – besides higher conversion rates – social media leads also have a higher lead-to-close rate than classic outbound marketing with newsletters, landing pages, and so forth.

It’s simple, really!

Every post you make on Twitter, Facebook, Instagram, and any other social network can be seen by an ever-growing audience.

People can share your content, comment on it, and do the promotion for you.

You build your brand and gain recognition, but you have to establish your brand voice early on and try to stick to it.

If you wanna be the affiliate king, social media is the way to go!

Off-Page SEO

Here it is!

Off-Page SEO!

The age-old debate regarding backlinks!

What the heck are backlinks?

Do you even need them?

A backlink is a link from another site to yours.

Plain and simple.

How the sites link to you is critical, and it’s worth mentioning that crappy links will eventually get your site in the crapper with Google.

What to do?

Be careful when it comes to what you do and how you go about it.

There would be nothing worse than working as hard as you possibly can and finally getting the results you want, and then having it all taken away from you just because you were too lazy with your links.

Do you need links to rank?

Of course you do!

Some people will tell you that you only need to create quality content and that it will rank naturally.

We say balderdash!

Not true!

We’ve asked some of the people who are adamant about this to answer the following question:

What happens when there are a lot of sites with great content?

What do they do?

We’ll tell you what:

They brush the question aside.

Without having to write an entire book, we can assert with 100% certainty that backlinks done right will be one of the keys to your long-term success. Voila Norbert’s email finder is the go-to tool when looking to secure backlinks on publications.

The type of website you decide to create doesn’t matter.

You need backlinks.


Two great guys you should follow to learn the art of safe, effective SEO?




You could have all of the above nailed down, and still not be able to make sales because your website fails to be optimized for conversions.

Yes, you have to get the traffic before you can get conversions.

Even so, you must make sure that you take a little time (and maybe even spend a little money) to ensure that you have good calls-to-action and that your site is properly funneling people to where you want them to go.

Small tweaks in this department can lead to massive profits!

Just keep that in mind because it’s critical to whatever style of site you decide to build.

Final Thoughts

Affiliate marketing is a great way to make money.

It provides anyone with a chance to earn money online.

When you figure it out, you get to work from anywhere.

In fact, you get to be your own boss, set your own schedule, and have the ultimate freedom!

Even so, don’t be foolish:

This is all gonna require hard work.

You need to go through a lot of reading, writing, experimenting and testing before you reap the rewards of affiliate success!

What to do?

Read and reread the tips showcased in this article, apply them to your strategy, and then take action!


Because – when all is said and done – imperfect action will always trump the theories of those who stand by and do nothing at all!

Another endnote:

Never forget that constant algorithm changes have made it impossible to go about life with SEO hacking in mind.

This means that you must enter into a whole new and modern marketing paradigm.

Focus on the user experience and on providing the best, most useful content and services possible!

Go for it now!


João Aguiar

Head of Marketing at Mobidea

Josh Parker

Owner of Badger SEO

No Results Found

The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.