Automating the SEO Outreach Using Data

by Nicolae Buldumac
· 05/06/2017 12:22
Automating the SEO Outreach Using Data

 Today everyone talks about SEO and the wealth of different techniques involved, yet when you ask a company what they do to achieve a good ranking, the majority of them repeat the same process - “buy links, press release, guest post”. In today’s blog, we'll talk about how to approach the SEO from another perspective, one that few companies have thought of, but can prove very effective.

To begin, I’ve numbered some problems companies have regarding SEO:

  • Problem 1: Your keyword is so difficult to rank in Google that you have already invested over 5k in SEO budget, but you're still not reaching your keyword goal ranking.

  • Problem 2: You have a budget for SEO, but you can't find contact information for websites or find a webmaster who is willing to get in with contact you.

  • Problem 3: You have the budget, but you can't find any relevant websites for your keyword.

  • Problem 4: Your budget is very limited, and you can't find reliable and affordable website partners.

  • Problem 5: You don't have an experienced SEO specialist on your team

So, looking at these problems, almost all company employees - especially experts in the field - would agree that these are the biggest issues faced in the world of SEO today. Number 5 is arguably the most prominent, and can also have the largest impact on your company, given that an SEO specialist is able to grow your company ranking substantially.

If you don't have an experienced SEO Specialist, someone from the company has to do the job, so the final question is: How to build an SEO outreach plan without too much experience or knowledge?

Introduction

Let's assume that your target keyword is “Travel Agency”, your target market is the United States, your budget for SEO is a maximum 5000$ / month, your goal is to rank on page one (any position), in the next three months, and your website name is Example.com. Looking at the image below, we can see that “Travel Agency” is searched globally 122,000 times and in US around 41,000, which is good.  Also, keyword difficulty is not too high, but not hard also. So, this keyword could be simple to rank - especially as it has two keywords.

SEO Goals

To improve the target keyword "Travel Agency", we need to have some goals in place so we don't miss any important details.

For this guide, we'll plan out this type of SEO content technique:

  • 100 Guest Posts

  • 100 Sidebar Content Links

  • 25 Banners on Homepage

  • 50 Sidebar Image Links

In total, 275 backlinks to improve the site to rank for the keywords "Travel Agency". According to Ahrefs, we need at least 35 domains referring to Example.com, but our goal is to have 275 referring domains, giving us a more stable rank which will not play positions in the coming months.

Plan What Kind of Website you may Need for Partnership:

To have a good ranking for the keywords "Travel Agency", we need to determine which kind of websites "Example.com" text and imagea and guest posts will be placed.

  • Educational Blogs about Tourism / Travel / Hotels / Vacations / Tickets

  • News Websites about Tourism / Travel / Hotels / Vacations / Tickets

  • Forums Websites about Tourism / Travel / Hotels / Vacations / Tickets

  • Product / Company Website about Tourism / Travel / Hotels / Vacations / Tickets

  • Informational Website about Tourism / Travel / Hotels / Vacations / Tickets

Websites Metric Data Requirements:

  • Websites should have a minimum DR of 45 (Ahrefs Ranking)

  • Websites should be all be written in English

  • Websites should have at least 100 backlinks

  • Websites should be updated permanently

So, abiding by the requirements above, and adding our guest posts and image and links on this required websites, we should easily win some great positions in google for the keywords "Travel Agency".

Start Gathering the Websites Mentioned Above:

We need to find 5000 potential websites that match the requirements above, but finding all of these manually - and then engaging them - will take years. Here's where we need to automate all of the SEO outreach, enabling us to do it in the shortest possible timeframe.

To find the potential websites much faster, we may need help from data provider companies, such as Global Database, or your current vendor. In this example we used data from Global Database's platform, which provides company and demographic data for almost all industries.

After conducting a quick search on Global Database, we're able to buy this industry data from them and we'll also ask for a custom-built list:

  •  Tourism USA Companies (7000 Companies)

  • Media USA Companies (2000 Companies)

  • Bespoke List of Travel Blogs (we'll need 2000 Travel Blogs with personal information)

  • Bespoke List of Travel Forums (we'll need 500 Travel forums with personal information)

  • Bespoke List of all website that contain the keywords "Travel agency" repeated 10x times (4500 Websites).

After our search we now have a total of 15,000 websites that match our content requirements. Let's proceed to the next steps, in which we will filter 15,000 websites based on Ahrefs Domain Rank and backlink profile.  We need to be sure that all these profiles match the SEO standard link partnership requirement.

Filter all 15,000 Website Profiles from Global Database

Ok, so we now have 15,000 website profiles with contact information such as Full Name, Company Name, Website Name, and Phone Number. Next we're going to copy all 200 domains (repeat until all domains have been processed) into Ahrefs' Domain Batch Analysis tool.

 

We'll have to repeat this step 100 times as Ahrefs' limit is 200 domain queries per report. OK, so once we've finished, we should get something like this:

We've now got h Ahrefs' Data Insights for all 15,000 websites. The requirement is to have a minimum Domain Rank of 45 and a minimum 100 backlinks. Download all data into your Excel and filter all domains that have more than 45+ DR and more 100+ backlinks.

After this, you should get around 5000 valid domains that match the content and SEO metric requirement.

 

Ok, so we filtered 5000 out of 15,000 domains that have a Domain Rank of 45 and minimum backlinks of 100.

FYI: we also had to add only English websites that are regularly updated, but this will be explained in another topic. Now we have done this step we have a total of 5000 potential domains.

Prepare and Append the Data for SEO Campaign

So now we have 5000 domains verified from the contextual and SEO metric. We should remove the rest of the domain profiles from Global Database's List and the list should only contain the 5000 domains we verified above with the contact information (you may have to do a vlookup to match the contact information with the domain).

You'll also have to do a vlookup and assign the right domain type to each domain. So for example, if you have “Travelguide.com" in your list, you should assign domain type “Informational Site”. This way you're structuring all the domains so we can plan the SEO campaign more easily and without issues.

 

By this point we've now structured our 5000 domains and we have assigned the Domain Type tag so it will be easier to create SEO campaigns.

Pre-final Stage: Prepare the SEO Outreach campaign

Ok, we have 5000 domain profiles with email information, contact data, and we also have the Domain Type tag set up and all of our domains have been verified. Now we have to sign up with a CRM or any CRM you may have, so we can upload all of these domain profiles and start preparing our SEO Campaign. We need to have a CRM so we can manage our partnerships, add notes, add tasks and build an internal SEO platform which will be useful for any employee from the company.  

 

Let's remember that our goal was to have:

  • 100 Guest Posts

  • 100 Sidebar Content Links

  • 25 Banners on Homepage

  • 50 Sidebar Image Links

So we need 275 partnerships approved from all of those 5000 website leads. Now we have to create four email templates which we will send to each email over the course of two months (20,000 emails total).

Ok, we've uploaded all website profiles leads into Zoho, each profile has all the information from Website Name to Domain Type.  Now let's take a look at the types of emails we should be sending out.

 

Email Templates

Below, we've prepared four email templates which will go to each website lead for the purpose of engaging and adding at least one type of content partnership.

Email Template for Homepage Banner Request:

 

Email Template for Sidebar Text Link Request:

 

Email Template for Sidebar Image Link Request:

 

Email Template for Guest Post Request:

 

We're finally done! We have our email templates and our 5000 website leads ready. The only thing we have to do now is create a workflow as to how to contact all 5000 leads in two months, so that we'll have an SEO rank improvement from the third month.

Final Step:

We have a total of 5000 website leads and we have four types of emails. We need to send all the emails (20,000) in a maximum time period of two months. Our main goal here is to be sure that each webmaster/website lead gets at least four types of content partnership requests.

Let's talk about how to plan the email campaign for SEO outreach:

First & Second Week:

Send 500 emails daily using template ONE for the next 10 days.

Third & Fourth Week:

Send 500 emails daily using template TWO for the next 10 days

Fifth & Sixth Week:

Send 500 emails daily using template THREE for the next 10 Days

Seven & Eight Week:

Send 500 emails daily using template FOUR for the next 10 days.

If one of the website lead responds positively to your request, remove them from the future email campaign or unsubscribe them from the list so that they don't get emailed again.

Following this plan, we made sure that all 5000 website leads had the potential of collaborating with our website using four types of content.

 

Conclusion:

The main goal of this guide was to demonstrate how any company can take a different approach to SEO or website ranking.  Many companies don't have an internal SEO Specialist, so this guide was written to enable those who don't necessarily have lots of experience in the subject to take a different approach and start building their SEO reputation.

The advantage of this SEO strategy is that you don't need much time or too much knowledge. Your website could get faster results using this strategy and it can also be used for lead generation or any purpose. The main aim was to show how to automate the SEO outreach using data bought from Global Database or any other provider.

To implement this strategy in your company, you will need:

  • Global Database Data on websites and companies

  • Access to Ahrefs to check for domain ranking and backlink analysis

  • Zoho CRM to upload the website leads and send the emails

  • Excel lists to append & Vlookup and play with the data

Related posts

Integrating Registry Data for Enhanced Customer Relationship Management (CRM)
Marketing5-7 min read

Integrating Registry Data for Enhanced Customer Relationship Management (CRM)

In today’s competitive business landscape, Customer Relationship Management (CRM) plays a pivotal role in maintaining strong customer connections, streamlining sales processes, and driving business growth.
What is firmographic data?
Marketing5-7 min read

What is firmographic data?

What is firmographic data, why is it important for your marketing campaigns and where can you get it?
Top 10 B2B data enrichment tools in 2024
Marketing5-7 min read

Top 10 B2B data enrichment tools in 2024

Discover our top 10 recommendations for data enrichment in 2024
Top 10 B2B Data Providers in 2024
Marketing5 min read

Top 10 B2B Data Providers in 2024

High-quality B2B data will be essential to helping generate leads and grow your sales in 2024. But how do you choose the right B2B data provider for you?
Empower Your Business Growth with B2B Data Enrichment: A Comprehensive Guide
Marketing3-5 min read

Empower Your Business Growth with B2B Data Enrichment: A Comprehensive Guide

Imagine the possibility of your sales team peering into a mystical crystal ball, gazing upon it to reveal precise and pertinent information about your target prospects🙂
30+ B2B Data Enrichment Tools of Our Choice for Lead Generation in 2023
Marketing

30+ B2B Data Enrichment Tools of Our Choice for Lead Generation in 2023

Stats show, that the average data decay is about 3% per month. This is why top B2B lead generation and data enrichment solutions are of great importance for both marketing and sales teams. Here is our list of the most promising data enrichment tools of our choice for lead generation in 2023 - GlobalDatabase.com
Why Does B2B Lead Generation Matter?
Marketing10 min read

Why Does B2B Lead Generation Matter?

In this basic B2B lead generation guide, you’ll learn about B2B lead generation marketing and digital strategies, effective tools and tactics, and B2B lead generation platforms that can put you on the path to sustainable business growth.
Top 8 B2B marketing trends for 2021
Marketing9 min read

Top 8 B2B marketing trends for 2021

Together with all them surprises 2020 has brought us, it has also triggered a range of changes to the B2B world, many of which are here to stay. Here are the main B2B marketing trends to pay due attention to in 2021.
How to create an email drip programme
Marketing

How to create an email drip programme

The modern buyer is both better able, and better equipped, to conduct their own pre-sales research. Which means that high pressure sales techniques no longer work