Need help on relating Program and Activity entity in MarketoSOAP API
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...