Need help on relating Program and Activity entity in MarketoSOAP API

[Anonymous]

Hi All -

We started pulling Marketo data into Data warehouse tables using SOAP API's. We have successfully pulled Lead, Activity, Program, Opportunity and OpportunityPersonRole data from Marketo using informatica's webservice capability.

After data pull we started relating these attributes. We stuck up when we tried to link Program and Activity data. Ideally we should have one to many relationship between Program and Activity. As an example a program called "Big data email blast" should have many email activites related to LEAD's. We didn't see Program ID in "Activity" table when we pulled in data.

Need help on how we can relate Program and Activity entitiy in Marketo. In a business use case of integrating Marketo data into Data warehouse, how we are relating "Program" and "Activity" entities. Business scenario is we would like to know how many activites a program has associated with it and how many lead and opportunity it triggered.

Any help on this will be a great help.. Thank you...

Thanks!
Shivachethan

[Anonymous]

The relationship would be established aggregating the results of getLeadActivity, getMObjects and getMultipleLeads, unless I am misunderstanding the use case.

http://developers.marketo.com/documentation/soap/

[Anonymous]

Hi,

Thank you very much for your reply.

We need to know how "Program" and "Activity" data talk each other. We have used LeadActivity and LeadChanges to get ACTIVITY data and getMObjects for PROGRAM data.

Ideally ACTIVITY data should have a Program identifier(Program id) to understand Program associated to an activitiy if any.

How we have Program to Activity relationship in Marketo ER model ?

Thanks!
Shivachethan