Has anyone ever built a separate data warehouse that contains Marketo interesting moments? | Community
Skip to main content
Dan_Stevens_
Dan_Stevens_
Level 10
July 11, 2016
Question

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

  • July 11, 2016
  • 4 replies
  • 2143 views

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?

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

4 replies

SanfordWhiteman
SanfordWhiteman
Level 10
July 11, 2016

Yes, that is a type of Activity.​

Dan_Stevens_
Dan_Stevens_Author
Level 10
July 11, 2016

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
Josh_Hill13
Level 10
July 11, 2016

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

Nicholas_Manojl
Nicholas_Manojl
Level 8
July 11, 2016

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.

A
Anonymous
July 12, 2016

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

A
Anonymous
December 16, 2016

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

Terms & ConditionsAccessibility statement

Loading footer...