That is consultancy to be technical, But this is done pretty easily in our RCA module, do you have access to that?
Yes I do!
Mobile: 44 7717 357 454<tel:44%207717%20357%20454>
7th Floor, 110 Cannon Street, London,
EC4N 6EU, UK
People matter. Get their insight.
This communication is intended for the person(s) above only. It may contain information that is confidential and legally privileged. If received in error, please delete this e-mail and notify the sender.
We do all the reporting in SFDC Dashboards - though a lot of the information comes from Marketo. Depending on the information needed we have to have two DB components for Lead and Contact MQLs. I've put Leads as "Net New" and Contacts as "Existing." Inquiries are Campaign responses that are all derived from Marketo programs.
We track activities, by standard Activity Type, as well on another DB:
Opportunity tracking is the easiest as that's SFDC's bread and butter. We track by #'s of opps, value of opps, what stage the opps are in, and by varying timelines (month, quarter, year).
I should add for Opportunities, we have an easy way of tracking these as all Sales Development created opps are from Marketing at our company. And we use Primary Campaign Source.
How do you flag the Contact records in Salesforce, so that you know they've been 'touched' by Marketo in some was as to included in the stats?
Salesforce say that there is no way to track Campaign members to their activities on the contact or lead objects - so again, interested to know what filters you're using on your Activities so that you're only tracking those that come specifically from a Marketo lead?
Our "inquiry" reporting uses the standard SFDC Report Type 'Campaign with Campaign Members' and filter on "Responded." You could also filter on any Campaign field/value and Campaign Member Statuses. This report type brings in leads and contacts. Important thing to note with this report is that the record count is the number of responses (not leads/contacts). You'd have to export to excel or create a custom formula to get a total number of leads/contacts that have responded to a campaign.
For Contacts, I'm using a field "MQL Date" that is updated in Marketo. So I know that the lead has been touched by campaign(s).