Campaign Member Status Values in Marketo

[Raj_Ruprai1]

Hi,

We are trying to export Marketo data into Tableau using Marketo Connector​. The goal is to find the table where the Campaign Member status is stored and display that within Tableau. We see different tables such as the "Lead by List - Attended On Demand" and "Lead by List - Attended Live" which appear to be the closest that maps to Campaign Member Status values. However, we also see the Campaigns in tables that have a Status field.

What table does Marketo store Campaign Member Status values?

[SanfordWhiteman]

You should avoid using the word "tables." What Tableau is presenting as if they're database tables are merely results from API endpoints. It's not as if it has direct access to Marketo's back end. (Which is the definition of an API.) So speak in terms of Marketo functions, not general database concepts.

Also, do you actually mean ​Program ​Member Status?

[Raj_Ruprai1]

Yes to your question about Program Member Status.

[SanfordWhiteman]

Program Membership is retrieved via the /leads/programs/{programId}.json API endpoint.