Lead to Account Mapping | Community
Skip to main content
A
Anonymous
January 21, 2016
Solved

Lead to Account Mapping

  • January 21, 2016
  • 5 replies
  • 4799 views

I am looking at options to begin some type of lead to account matching in Marketo. Essentially what I am attempting to accomplish is set up a program that will append/auto fill in lead data based on the company/domain address.

Example:

New lead from Nike is created. Program sees that there is an Account already in SFDC for Nike. It takes certain data from the account and auto fills in lead fields.

Any suggestions or even links to agencies that might be able to assist here. Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Grégoire_Miche2

I understand no problem. We are using SFDC w/ Marketo as well


Hi again Robert,

With SFDC, the easiest method is an SFDC trigger. The typical matching info will be email domain or email domain + country (depending on your sales org.)

email domain has the great advantage over account name that one cannot temper its spelling. You have to write it correctly or you will not receive the emails. The second advantage is that it is unique on a WW basis.

You will need to fields :

  • One "Account" field on lead, type = lookup (account).
  • One "email domain" string field on the account object.

The trigger will detect a new lead or a lead update when the lead has no account and will try to find a match between the lead email domain and the account which Email Domain field (exact match) and, if a match is done, will fill the lead "Account" field. Once the matching is done, you will use some workflows on the lead to populate the lead fields from the account field.

In order to populate the account Email domain field, you can start manually or with an import. It you think worth it, you could create another trigger that looks into account contact and determines the email domain, although this has some risks.

The last stage of the whole process will be to replace SFDC default lead conversion assistant with a wizard that leverage the lead account info to make sure that, when converted, the resulting contact does not end up in another account.

-Greg

5 replies

A
Anonymous
February 25, 2016

Just FYI, lead-to-account matching will  most likely be supported in Marketo as a standard functionality in upcoming releases in 2016. ABM is a one of the focused topic of 2016 product roadmap.

Pl. feel free to reach out to me directly on mjeswani@marketo.com for more details on this topic or any other ABM topic.

I would  suggest to also create an IDEA on this topic.  This helps in prioritization of the feature.

Thanks,

MJ

Product Management

Grégoire_Miche2
Grégoire_Miche2
New Participant
January 29, 2016

Hi Scott K. Wilder​,

Could you please merge this post with this one : Lead to Account Mapping

There are the exact same question, from the same requester, and we get a little lost trying to follow the conversations

Thanks,

-Greg

Dory_Viscoglio
Dory_Viscoglio
New Participant
February 25, 2016

Hey Greg, I don't think conversations can be merged -- just deleted. And I don't think we want to lose the conversations that have happened on either thread.

Grégoire_Miche2
Grégoire_Miche2
New Participant
January 29, 2016

Hi Robert,

You can also give a look to Reachforce's SmartForm service. It enables you to enrich your form with a choice of exactly which account the visitor is from and help driving an accurate match. Once you have the match, you can consider creating a trigger in SFDC that does the automatic conversion.

SmartForms – Marketo LaunchPoint

Marketo themselves are using Smartform.

-Greg

J
JDNelson1
Community Manager
January 21, 2016

Hi Robert,

We are currently implementing LeadSpace for this. They score every record as it comes into our database, then we have a bunch of fields that get appended with contact & lead data; if the lead data matches a company data then it kicks off some sfdc processes that then convert contact and add to accounts. Luckily I'm not our sfdc admin and merely hope to reap the benefits from this integration and not have to map it all out. We've been mostly happy with LeadSpace, but have also looked at LeanData as a possible partner. Best of luck.

A
Anonymous
January 22, 2016

Hi Robert,

I suggest you look at the services offered by FuzzyMatchCompanyNames.com website. They map a new lead against SFDC account. They may be willing to expose their API to integrate with Marketo. Worth checking. There may be other vendors offering the same as well.

Thanks

Grégoire_Miche2
Grégoire_Miche2
New Participant
January 21, 2016

Hi Robert,

This cannot be done in Marketo, but could be in your CRM, if you have one.

The technique to use is the same as the one I explained in this post :

-Greg

A
Anonymous
January 21, 2016

Hi Gregoire,

Thanks for sharing the link. Some really nice information in there. I have some questions on the web services in use and the set up. Would you mind having a quick call/screen share?

Grégoire_Miche2
Grégoire_Miche2
New Participant
January 21, 2016

Hi Robert,

I cannot share too much as I cannot share things from my customers.

You may also talk to Stephen Schimmel​, as we already had a discussion about this.

What CRM are you using ?

-Greg

Terms & ConditionsAccessibility statement

Loading footer...