You need to sign in to do that
Don't have an account?
Roy D.
% of conversion
Trying to figure out a good way to calulate the % of contacts that are converted into leads that have a opportunity stage = Enrolled. Any ideas ?
I want to present the data in Excel on a pivot table
Qtr=4 July
Campaign Contacts Leads %Conv
A654 200 50 25%
Thanks,
Roy
I want to present the data in Excel on a pivot table
Qtr=4 July
Campaign Contacts Leads %Conv
A654 200 50 25%
Thanks,
Roy
Let's assume for this example that the stage ends up in column J.
On sheet2, cell A2 enter =COUNTA(J:J) (total number of records)
On sheet2, cell A3 enter =COUNTIF(J:J,"Enrolled") (total number of records marked as enrolled)
On sheet2, cell A4 enter =A3/A2 and format as a percent.
Not perfect, but it should work. I don't believe you can have a pivot table show percentages of the total.
HTH