Has anyone ever built a separate data warehouse that contains Marketo interesting moments?

[Dan_Stevens_]

We're in the process of building a separate data warehouse/BI dashboard tool that goes well beyond what RCA/RCE can offer today.  The Opportunity Influencer Analyzer doesn't work for us since we have hundreds/thousands of opportunities.  So one of the key data points are Interesting Moments.  Are Interesting Moments even something we can extract from Marketo?

[SanfordWhiteman]

Yes, that is a type of Activity.​

[Dan_Stevens_]

But isn't that limited to values like "Web page visit" or "filled out form" (vs. something more detailed like "Filled Out Form: Gated Content Form (Global) on www.avanade.com/en/about-avanade/partnerships/sitecore/customer-experiences-whitepaper")?

[Josh_Hill13]

You can pull out these items from the log activity data.

[Grégoire_Miche2]

Hi Dan,

No, interesting moments are just one type of activities, exactly as "web page visits".-, with a distinct activity ID.

The API has a "get activity types" endpoint (Get Activity Types » Marketo Developers) that enables to get the list of types that you can the reuse as a parameter to the "Get Lead activities" endpoint (Get Lead Activities » Marketo Developers)

-Greg

[Nicholas_Manojl]

I built a little webapp using Angularjs - you type in a username and the date for a paging token and it pops back the last interesting moments for the lead record.

If I could do it, a developer could probably do a much better job of it.

[Anonymous]

Hello Dan,

We are looking at doing that now. We do all of our reporting via Full Circle and SFDC but due to the volume of emails we send we don't push all our email analytics into SFDC. Because of this we are looking at moving this data to our data warehouse so we can then run Tableu reports from the Marketo data, SFDC data, and Full Circle data. We will also weave in Bizable data and Google Analytics.

This is a big undertaking, but we are starting to get all of these pieces in motion.

Regards,

Kelley

[Anonymous]

Hi Dan,

As Greg mentioned, you can use Marketo API "Get Lead Activities" and specify activity type as "Interesting Moment" to get the data. But you can try Data Loader for Marketo (DLM) to retrieve all kinds of Marketo data including Interesting Moment activities without any coding.

Due to the large volume of data and the limitation of Marketo reporting function, we pull all data from Marketo to our data warehouse and do analytics with Tableau. We have run this practice for a long time. If you have any questions about Marketo data or Marketo reports, feel free to contact me directly vivian_wu@trend.org​ . Thanks!

Vivian