Hi Rachael Williams,
There is a Marketo ODBC Driver on the market that allows you to connect directly to Marketo. Have you already tried this out? Marketo ODBC Driver - ODBC | ODBC Drivers | ODBC Connection | ODBC API
I have not. I am not familiar with SQL and that is why I was looking forward to the Tableau/Marketo integration. I have looked into the some data pull technologies but I haven't found one yet that is compatible with a Mac, only Windows software.
Thanks for reaching out. We are currently working on adding a large number of additional Marketo objects to the connector including Programs. As soon as we're ready you'll be able to find our progress at https://www.tableau.com/getbeta, we'd love to hear your feedback.https://www.tableau.com/getbeta
Product Manager - Cloud
We are currently finding that the campaign ID fields don't match between the activity objects and the campaign objects. Have checked all possible ID fields. The ID on the campaign object is a 4 digit number however the campaign ID on the activity records is a 5 digit number.
Do you have any detailed documentation on how the Marketo connector is setup or could you provide us with an explanation of the above?
Also adding in the program object to the connect would be useful as this is the more relevant grouping field for activities and will give us key information like channel.