CPO & CPL report for Marketing Events

[olivecheung]

Hi team!

Would it be possible to build a dashboard where we can see the CPO & CPL of events? We have each event and the cost in this sheet here: https://docs.google.com/spreadsheets/d/1NuuycNC9V7j5nuw2vXXGUC8JL8MbkYAO2_hIFfKtk8E/edit#gid=956174198

We've also been manually adding the opps and leads from each event in this sheet but the updated number is always in the respective Salesforce campaign - is there a way we can pull this information from here?

Please let me know if you need more information or resources. Thanks a lot!!

[ruipperez]

@josemgonzalezleon For you to take a look :)

[olivecheung]

hey @josemgonzalezleon @ruipperez! Would you be able to give me an idea of when this could be done for? thank you very much!

[ruipperez]

Update here: Included 3 tabs in the doc.

• Index: with reports used
• 2022 Events Summary Dash: including all the information related to Opps influenced and Main Opps by Campaign (Type=Events)
• Pivot Table Events: summarise the info in the Summary Dash tab. https://docs.google.com/spreadsheets/d/1NuuycNC9V7j5nuw2vXXGUC8JL8MbkYAO2_hIFfKtk8E/edit#gid=1147704142

The source updates daily