Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

How to Identify Customer Accounts from Accounts Created from Qualifying a Lead

Posted on by 32

Hi,

We have a list of 'Accounts' within Dynamics which includes our existing customers, but the list also includes 'Accounts' that were automatically created when qualifying a lead (these 'Accounts' may still be in quote stage and are not customers yet).

We can't seem to create a list of actual customers on the 'Account' views (on the sales app), as there does not seem to be a method of filtering these into actual customers.

We also want to send out a bulk email to all existing customers (through the marketing app), but it is currently using the entire list of accounts, which would send a customer email to the list of existing customers and automatically generated 'Accounts' that were created when qualifying a lead. 

Is there a field on the account form that we're missing, to say whether an 'Account' is a customer or not?

Can anyone advise please?

Thanks,

CP 

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: How to Identify Customer Accounts from Accounts Created from Qualifying a Lead

    Hello,

    If my reply (or replies) answers your question take a minute and verify the answer. You can do it by clicking "Yes" at the top of the reply (or replies) under the label "Does this answer your question?"

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to Identify Customer Accounts from Accounts Created from Qualifying a Lead

    Hi Cnpeps,

    As Andrew said, you need use 'Originating Lead' lookup field as filter to check accounts.

    There is one 1:N relationship between Lead and Account, so one  lookup field named 'Originating Lead' in the Account entity:

    Originating Lead: Shows the lead that the account was created from if the account was created by converting a lead in Microsoft Dynamics 365. This is used to relate the account to data on the originating lead for use in reporting and analytics.

    pastedimage1664851820326v1.png

    Then you can create one new Account view with  'Originating Lead' not contain data as filter:

    pastedimage1664851202423v1.png

    Then you can get a list of accounts that do not include those that are automatically created when qualifying a lead,.

    pastedimage1664851575795v2.png

  • Verified answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: How to Identify Customer Accounts from Accounts Created from Qualifying a Lead

    Hello,

    There is a field called "Relationship Type" where you might define the type of relationship with the customer - either it's an existing customer or the prospect but in order to use that field, you will have to update the existing data.

    In order to identify if the account was converted from the lead, you can check the "Originating Lead" field.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans