Campaign Member Status Values in Marketo | Community
Skip to main content
Raj_Ruprai1
Level 2
January 22, 2019
Question

Campaign Member Status Values in Marketo

  • January 22, 2019
  • 1 reply
  • 2897 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

SanfordWhiteman
Level 10
January 22, 2019

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
January 24, 2019

Yes to your question about Program Member Status.

SanfordWhiteman
Level 10
January 24, 2019

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