Automating the SEO Outreach Using Data

by Nicolae Buldumac
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?


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 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, 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 "" 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 “" 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.


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

What are SIC Codes and NAICS Codes?
What are SIC Codes and NAICS Codes?
Understanding both the Standard Industrial Classification (SIC) and Northern American Industry Classification System (NAIC) can help you get the most from these databases, which represent an extensive survey of the economic landscape of North America, from larger market trends to company specific information about business activities.
Why Does B2B Lead Generation Matter?
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 10 features of  B2B data providers
Due diligence
Top 10 features of B2B data providers
Information has always been a critical success factor of any business, be that knowledge about prospects, the market or competitors. But today, with the digital boom and the B2B data sector moving with an extremely fast pace, data has become the indispensable fuel of any business’ engine.