Apex Code Development You need to sign in to do that
Don't have an account?
Adammm Calculations on Campaign Object
Hey all, I'm putting together a Marketing ROI dashboard, but having some issues connecting the Campaign Object to Member Status.
What I'd like to do is calculate Cost / Lead and Cost / Sale on the Campaign object.
Qualified Lead, and Sale are Member status values on this campaign.
I also created a custom field called Expense that reflects the $$ spent on the campaign.
Idealy I'd create a custom formula field to divide Expense by Count of Members with member status "Qualified Lead", and another customer formula field to divide Expense by Count of Members with member status of "Sale"
I'm not opposed to doing this in a custom object, but the Campaign seemed like the most logical place to do this since it has the feature of being able to associate Large numbers of leads to it very easily.
Any ideas or help would be great!
Is anyone out there currently calculating Cost / Lead and Cost / Sale in Salesforce? If so I'd love to hear how you do it. Thanks!