Custom Report - All Interesting Moments | Community
Skip to main content
June 22, 2018
Question

Custom Report - All Interesting Moments

  • June 22, 2018
  • 3 replies
  • 7955 views

Hi guys,

We are working on a Lead Scoring Data project and need to be able to pull all of the interesting moments for our customers. Unfortunately, I could not find a Marketo report that allows me to gather a list of all interesting moments for our customers. Would love some guidance on a workaround for this report. Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Josh_Hill13
Level 10
June 22, 2018

It is not available.

You can look at Last Int Moment fields or use API.

SanfordWhiteman
Level 10
June 22, 2018

Just to expand on Josh's comment, these kinds of cross-lead, activity-centric reports aren't available in the UI (a report of all form fillouts is another example).

But if you use the API (Bulk Export or Bulk Extract, the latter much easier) you can get at this remarkably easily. In many ways, the API takes the opposite angle on Marketo data from the UI. There are readymade views/exports via API that aren't possible via UI and vice versa.

June 25, 2018

Thank you for the suggestion! I have yet to fully deep-dive into using API but I guess I'm going to learn now

Dan_Stevens_
Level 10
June 23, 2018

One option is to create an "Interesting Moment History" field - where you store a continuous feed of IMs each time a new one is triggered; and an "Interesting Moment Score" field.  For example, here's how we capture these when someone attends an event:

The default choice value for when the IM is appended to the existing history value is as follows:

{{system.dateTime}}: Attended an Avanade Event: {{trigger.Name}}{{my.line-break}}{{lead.Avanade Interesting Moment History}}

You can then run a report where IM Score > 2 (to ensure your report only includes those people with at least 2 IMs).

We use the IM history field in both our reports and real-time alerts (to sales and marketing).  Here's an example of how this appears within our real-time alerts (we do the same thing for web page history):

Think of this as a poor man's way of reporting on Marketo Sales Insight (MSI) data without having to purchase MSI!

I presented on this technique at Marketo Summit (as part of my "Strengthening Sales & Marketing Alignment: Developing Real-Time Alerts with Rich, Actionable Insights" session).  Here's a copy of the presentation deck (which also includes a great tip provided by @Sanford​ on how to create a simple velocity email script token to insert hidden line breaks between each entry in your history field and make each entry readable within your reports/alerts).

June 25, 2018

Dan,

This is extremely helpful, thank you! I'm going to do some more digging and see if I can apply your technique to our instance and get the results I need. Super thankful to you for sending over the presentation deck!