Re: Campaign Member Status Values in Marketo

Raj_Ruprai1
Level 2

Campaign Member Status Values in Marketo

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?

3 REPLIES 3
SanfordWhiteman
Level 10 - Community Moderator

Re: Campaign Member Status Values in Marketo

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
Level 2

Re: Campaign Member Status Values in Marketo

Yes to your question about Program Member Status.

SanfordWhiteman
Level 10 - Community Moderator

Re: Campaign Member Status Values in Marketo

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