Building a lead database across the United States

How and where to find data?

I’m Dmitry, B2B Marketing Expert and the CMO with Belkins company. We specialize in B2B lead generation, and generating sales appointments, extending our services across 50+ industries in North America and Western Europe. 

Our company consists of three departments: SalesSupport, and Lead Research. The Support Department includes SDRs, Account Managers, and Email Copywriters and covers the tasks of setting outreach campaigns, preventing emails from going to spam folders, lead qualification, and appointment setting.

Why are SDRs not in Sales Department? SDRs do more than sales. They work with the clients’ databases, monitor their results, consult them, etc. Every SDR is held responsible for the success of their clients.

  • Sales teams attract new clients. Also, it serves as a sandbox for newly hired SDRs who need to gain more experience for working with leads on the client’s behalf.
  • Lead Research/R&D /Lead Generation/Data Research. Hands down, this is the heart of our company. This department covers lead research, lead validation, lead analysis and segmenting. The quality of the data found by our Lead Research teams defines the quality of the results delivered by our Sales Department and Support Department. 

Our Lead Research teams do their magic the following way: marketing research of the industry, making an ICP, data research, and, ultimately, building a lead database. 

The basic lead information includes name and surname, title, place of employment, business email and everything that allows personalizing a sales offer. For instance:

  1. Number of employees;
  2. Active hiring;
  3. Technology stack (programming language, frameworks, etc.);
  4. Annual revenue;
  5. Monthly site visits

Outlining an ICP (Ideal Customer Profile) is the first step of lead generation. It requires building a database that would meet the client’s needs closely. It will allow to pinpoint the key titles in the company, outline the audience’s pain points and throw away all irrelevant segments. Logically, there can be no email personalization, structured business messages or a unique value proposition until the ICP is ready.

To build an ICP without taking too much of ours and our client’s time, we made a special form. After our clients fill it, we move the form to our ResearchTrello Board. Then we assign the tasks to our team and we get started.

On average, it takes from 24 to 48 hours to process an ICP for the test leads. It allows the client to see how a Belkins’ database looks like. Also, when the clients receive test leads, they can try to generate appointments by themselves

As we start our work with the client, we research the client’s needs and build a list of companies that are a close match to the client’s ICP.

To make our research as productive as possible, we use the following resources:

  • LinkedIn – it allows viewing companies and titles. It’s not the only source of data, but it provides open access to the contact data that the companies publish for networking and cooperation. As our work continues, LinkedIn becomes a great outreach platform.  
  • Crunchbase – contains information about companies, attracted investments, and founders. 
  • AngelList – provides information about companies and investors.  
  • Clutch.co – features information about the wide range of service vendors, including reviews, ratings, articles and clients’ feedback.   
  • G2.com / Capterra.com – most of the product-manufacturing companies register here. The platform also features reviews about their work and products. 
  • Zoominfo / Datanyze – these resources offer information about the technology used by the companies. They also allow to segment them by popularity, revenue and to view technical data.   
  • SimilarTech – allows finding web-technologies related to e-commerce, widgets, marketing and etc.

After you build the list of companies, you must identify your decision-makers. If you have loyal customers, learn more about their companies’ structure and processes to find if there are things that are common for the entire industry. In case you are not sure which title is your decision-maker, reach out to several employees and ask them who you should be speaking with. 

What I learned from mistakes:

  • Check the company’s activity;

If you think that a company is a direct match, don’t be in a hurry to send emails. If the company’s official media accounts are inactive and contain only six-month-old posts, while its blog hasn’t been updated for three months, you are more likely to waste your time than get a response.

  • Locate stagnating companies;

LinkedIn Insights allows you to see the hiring graphics, number of titles in the company and its growth for 1-2 years.

Example:  You specialize in outsourcing. The target company has five job offers for Android developers. For the last three months, the company has tripled its number of IOS developers. This should give you a clear idea of how your value proposition must look like.

  • Study the company’s structure closely;

To find your decision-maker, explore the structure of the company that you want to add to your Outreach list. Check the About us, Contacts, and Team pages. Take a look at the blog authors to determine your possible recipients. 

In case the site doesn’t provide you with the necessary information, visit the company’s LinkedIn. It usually features data of all Western companies, startups, and experts. You only need to enter the name of the company to the search bar and start looking through the employees. Top managers usually update their profiles with relevant information, so finding an appropriate person should be easy. 

However: Nowadays, LinkedIn is rather a recruiting and candidate search platform rather than a tool for finding contacts and generating leads. Many companies create LinkedIn profiles for online presence. Therefore, if you can’t find the necessary information about your prospects in LinkedIn, that’s because they no longer post it in their profile. 

Luckily, there is an alternative. If you heard about Xing, you know what I mean. If you haven’t, it’s a LinkedIn analog that is very popular in Germany and DACH countries. The service has over 15 million users, so, compared to LinkedIn and its 500 million users, it’s not exactly the top professional network in the world. Nevertheless, Xing has been a huge success in Europe: the number of Xing users from DACH regions counts up to 13 million, while LinkedIn DACH-stationed users make up only 11 million.  

So, your list of companies is ready. Your next step is to find and verify their emails. There are many services that can help you out. 

Since we find several thousands of contacts each month, it’s critical to us that our search was quick and productive. Therefore, we chose the following tools: 

Hunter.io – our main tool for searching corporate emails. It’s very handy and provides a lot of email validation features. 

LinkedIn Sales Navigator – we use this extension when we manually gather emails. It allows us to get emails straight from the LinkedIn profile. 

We also use Snov.io and other Hunter alternatives, but this subject needs an individual article. When we need to find a personal email, we can use several options: 

Option 1. Parsing

Use Dux-Soup, Phantombuster and Google Spreadsheets to select Gmail mailboxes just like Twitter and Facebook URLs. Quite often, links to Twitter are added to LinkedIn profiles. 

Option 2. Singular inquiries

With Name2Email Google Chrome extension and LinkedIn Sales Navigator, you can find personal emails if you know the name and domain. If you do things right, you will also get LinkedIn, Facebook, Twitter. 

After you finalize your database, it’s time to send emails. To manage our sequences, we use Reply. This service allows us to automate our sequences and optimize our work with emails.

The success of your emails depends on: 

  1. Database;
  2. Mailbox settings;
  3. Personalized templates;
  4. Relevant value proposition.

Always have 10 minutes to check all qualifiers in your database to avoid any possible mistakes. I suggest doing so in your sending tool’s interface to prevent problems with coding, fonts, and gaps. 

Keep a close eye on the limits of your email service provider and check your content for spam triggers so your emails won’t land into your spam folders, completely nullifying your efforts. 

Convert a Database from Microsoft Access to MySQL

The current version of dbForge Studio for MySQL does not allow to import the whole Access database at once. Instead, there is an option to migrate separate Access tables in MySQL format.

The article below describes the entire process of converting Microsoft Access tables to MySQL.

Importing Data

1. Open dbForge Studio for MySQL.

2. On the Database menu click Import Data. The Data Import wizard opens.

3. Select MS Access import format and specify a location of Source data. Click Next.

If the Source data is protected with a password, the Open MS Access Database dialog box appears where you should enter the password.

NOTE: To perform the transfer you should have Microsoft Access Database Engine installed. It will install components that can be used to facilitate transfer of data between Microsoft Access files and non-Microsoft Office applications. Otherwise, the Import wizard will show the following error:

Therefore, if you face the problem, download the missing components here.

Note, that the bit versions of your Windows OS and Microsoft Access Database Engine should coincide, that is, if you have the 64-bit system, you should use the 64-bit installer. However, there are cases when the 32-bit Microsoft Access is installed on the 64-bit Windows OS. In this case perform the following steps before installing.

  • Click Start, click All Programs, and then click Accessories.
  • Right-click Command prompt, and then click Run as Administrator.
  • Type file path leading to installer and “/passive”. It should look like this:

In the case above the Windows OS is 64-bit, but the installed version of Microsoft Access is 32-bit. That is why the 64-bit installer is required.

4. Select a source table. To quickly find a table in the list, enter characters of a required name into the Filter field. The list will be filtered to show only those that contain such characters in their names.

5. Specify a Target MySQL connection, and a database to convert the data to. Also, since we need to create a new table, select New table and specify its name. Click Next.

6. Map the Source columns to the Target ones. Since we create a new table in MySQL, dbForge Studio for MySQL will automatically create and map all the columns, as well as data types for each column. If the automatic match of columns’ data types is not correct, you may edit data types  manually.

Target columns are located in the top and the Source columns at the bottom of the wizard page (see the screen-shot below). Click Source column fields and select required columns from the drop-down list.

NOTE: To cancel mapping of all the columns, click Clear Mappings on the toolbar. To restore it, click Fill Mapping.

7. To edit the Column Properties, double-click a column or right-click a column and select Edit Column.

8. Click Import and see the import progress. dbForge Studio for MySQL will notify you whether the conversion completed successfully or failed. Click the Show log file button to open the log file.

9. Click Finish.

NOTE: You can save the import settings as a template for future uses. Click the Save Template button on any wizard page to save the selected settings. Next time you should only select a template and specify a location of the Source data – all the settings will be already set.

Setting Up Constraints

After importing all necessary tables you can to set up (or correct) relations between the converted tables by creating/editing foreign keys (if required).

Also, you may create primary keys, if you skipped this step during creation of a table.

Creating Foreign Key

  1. Open the table you need and choose New Foreign Key from the Table menu.
  2. Add required columns, select referenced table and referenced constraint, and click OK.

-or-

  1. Switch to the Constraints tab.
  2. Create a constraint from the context menu.

NOTE: To create a foreign key, the referenced table should have a unique index, otherwise dbForge Studio will prompt you to create it. Click Yes in the dialog and the unique index will be added.

Creating Primary Key

  1. Right-click a table, select Edit Table, switch to Constraints tab. To create a key, right-click on the white area and select New Primary Key.
  1. Add required columns to the key and click OK. You can also switch to the Constraints tab and create the primary key within context menu.

Summary

In this article we reviewed the aspects of importing MS Access database to MySQL database by means of dbForge Studio for MySQL. Despite the fact, that the current version of the program does not include the tool to migrate a MS Access database at once, the described above importing mechanism allows to perform the import fast and easily.

dbForge Studio for MySQL supports the .accdb format.