Image depicting people seamlessly connected when lead-to-account matching issues are resolved.

How Lead-to-account matching issues are a data quality problem

In our next installment, aligned with The trailblazer’s guide to marketing, sales, and RevOps excellence, we delve into lead-to-account matching. This process is crucial for helping sales reps identify which leads are linked to specific accounts, allowing for more targeted and effective outreach and ensuring that no leads are overlooked.

Previously, we discussed how improving data quality can help overcome ideal customer profile (ICP) challenges, enhance segmentation, address data governance issues, and improve routing accuracy. We also highlighted the importance of managing duplicate accounts and records to ensure clean data and accurate reporting for better-informed business decisions.

The importance of accurate data in lead-to-account matching

So, maybe it’s not your lead-to-account matching; maybe it’s your data quality.

When new leads are added to a database, sales reps always want to know if they are associated with one of their key accounts. RevOps teams do their best to match these leads so they can be assigned to the right rep and further any opportunities with the accounts, but sometimes data issues get in the way.

Examples of data quality challenges in lead-to-account matching

For example, the following leads might have attended an event:

First Name

Last Name

Email Address

Company

Country

Wolfgang

Mozart

w.mozart@musicco.com

Music Co.

Austria

Fanny

Mendelssohn

fanny.m@musicco.com

Music Company

Germany

Clara

Schumann

clara.schumann@schumann.com

Schumann Music

Germany

Joe

Bach

j.s.bach@schumann.com

Schumann Music LLC

Germany

Igor

Stravinsky

i.stravinsky@wildcomposers.com

Wild Comps

Russia

Barbara

Strozzi

Barbara.strozzi@gmail.com

Wild Composers

Italy

Our account data for these companies looks like this:

Account Name

Website

The Music Company

musicco.com

Schumann Music

schumann.com

Wild Composers

wildcomposers.com

If we try to do a simple exact match on account name, we’ll have a problem and only get two matches out of six:

Email AddressCompanyAccount NameMatch?
w.mozart@musicco.comMusic Co.No
fanny.m@musicco.comMusic CompanyNo
clara.schumann@schumann.comSchumann MusicSchumann MusicYes
j.s.bach@schumann.comSchumann Music LLCNo
i.stravinsky@wildcomposers.comWild CompsNo
Barbara.strozzi@gmail.comWild ComposersWild ComposersYes

Improving matches through data standardization

If we clean up company names for the purposes of matching, we do a little better and get three out of six. Bolded records show the fields that were standardized:

Email Address

Company

Account Name

Match?

w.mozart@musicco.com

Music Company

No

fanny.m@musicco.com

Music Company

No

clara.schumann@schumann.com

Schumann Music

Schumann Music

Yes

j.s.bach@schumann.com

Schumann Music

Schumann Music

Yes

i.stravinsky@wildcomposers.com

Wild Comps

No

Barbara.strozzi@gmail.com

Wild Composers

Wild Composers

Yes

But if we match on website after we do an exact match for company/account name, we’ll get all six:

Email Address

URL

Company

Account Name

Match?

w.mozart@musicco.com

musicco.com

Music Company

The Music Company

Yes

fanny.m@musicco.com

musicco.com

Music Company

The Music Company

Yes

clara.schumann@schumann.com

schumann.com

Schumann Music

Schumann Music

Yes

j.s.bach@schumann.com

schumann.com

Schumann Music

Schumann Music

Yes

i.stravinsky@wildcomposers.com

wildcomposers.com

Wild Comps

Wild Composers

Yes

Barbara.strozzi@gmail.com

wildcomposers.com

Wild Composers

Wild Composers

Yes

The impact of data quality on lead-to-account matching

After cleaning data and running multiple matching processes, we get a much higher match rate and can more easily recognize leads that belong to accounts.

Obviously, this is a very simple scenario, but with standardization and multiple matching processes, we can not only match all these leads, but also make a good guess that Ms. Strozzi’s corporate email address is b.strozzi@wildcomposers.com as a pattern match with Mr. Stravinsky’s corporate email address, all because of the improvement in data quality.

Want to learn more about improving your data quality and lead-to-account matching? Download The GTM guide to data quality to ensure your data is prepped for matching, or watch the Openprise Master Class: Lead routing: the art of agility and accuracy.

If you’re ready to take the next step, schedule a demo today!

Recommended Resources



Leave a comment