Hi All, I'm trying to connect marketo email data (just email data) to my database housed on redshift. I am seeing marketo has the following API export fields: GetLead, GetMultipleLeads, GetLeadActivities, GetLeadChanges. How would I go about getting email data? I know I can export it but I want the data by date. To give you a broader view of what I'm doing is making it so the links in my marketo emails which lead people to fill out a form on my site have a UTM parameter captured by a cookie on our site. That UTM parameter is then sent to salesforce on the campaign member object which will enable me to see form fills, then tasks, then opportunities coming from my email campaigns. I want to be able to connect all this data in my instance of redshift like I currently do with adwords data and bing search data to optimize my campaign performance and house everything in one set of dashboards for company use. Right now, after reading all the documentation, I do not see how I can get email data into my DWH and when I do an export on the email data it does not have a date range. To get around this I could in theory export email data every day and upload the csv into my DWH after adding a date column but that seems extremely unproductive. I was hoping there would be a way to just get the raw data. -Brian
... View more