Connect leads with opportunities for reporting

(0) Share

Report

Posted on by Community Member

Good morning all,

We are struggling on creating relationships between leads (in our case, origin = Marketing activty) that become an opportunity, and then from then to check which ones become real business (in order to get a good ROI metrics of our marketing expenditures).

Is there any relationship where we can get such info?

I have tried to export the whole number of columns possible in "All Leads" and in "All Opportunities" to see if there is any ID that is the same in both cases, but I can't find any.

Appreciate any support on this topic a lot.

Thanks.

Categories:

Lead Management and LinkedIn

I have the same question (0)

All responses (4)

Answers (0)

megcda 2,192 on at

Like (0)

Report
Copy link

Link copied!

Hi Rosemary,

Are you running Dynamics 365 for Marketing or are you using Enterprise Marketing?

Thanks,

Megan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I'm using Microsoft Dynamics 365, Sales & Marketing modules. Thanks.

Was this reply helpful? Yes No
Suggested answer

Christian Abeln Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello,

Yes such relationship exists! On a Lead you have the lookup field 'Qualifying Opportunity'. When you qualify a lead the created opportunity will be recorded in that field.

You can also add the field to the Lead Form via customization.

An Opportunity will typically be closed as won in order to record the it became real business. So basically you would look for opportunities that have been closed as won, and aggregate the revenue recorded. You can do that aggregation on the Source Campaign or Source Customer Journey if you are using Dynamics 365 for Marketing.

Try creating a Char ton the Opportunity and you can see the revenue for your opportunities by source campaign.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot, very much appreciated.

Was this reply helpful? Yes No