Understanding Leads API in Marketo | Community
Skip to main content
Sid_Patil
Level 2
February 22, 2019
Question

Understanding Leads API in Marketo

  • February 22, 2019
  • 1 reply
  • 3195 views

Hello All,

We are just beginning to test some tools to get data out of Marketo into our data warehouse. For that, we are using a third party tool. One of the tables (a Marketo system table) I see created is a "lead" table. Is this table all the contacts (with email/without email/unsubscribed/marketable leads etc) that I have in my Marketo instance? If not, what records are captured in this table?

I ask this question because the Total Leads (Marketable + Not Marketable) I see in my Marketo's DB dashboard is different than the row count in this "lead" table. I tried to read the documentation on Leads API but it was difficult for me to follow since we are relatively new to Marketo.

Thank you all! Appreciate any help in this context or how Leads API generally works too

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
February 22, 2019

We are just beginning to test some tools to get data out of Marketo into our data warehouse. For that, we are using a third party tool. One of the tables (a Marketo system table) I see created is a "lead" table.

It's not a "table". It's the response from a REST API endpoint. The decision to present it as a relational "table" is entirely up to the consuming application (and often an incorrect use of the RDBMS concept).

Is this table all the contacts (with email/without email/unsubscribed/marketable leads etc) that I have in my Marketo instance?

Depends on the 3rd-party tool and whether that application applies filters to the result set. Most likely, it is indeed supposed to be all People/Leads in your Marketo instance (Marketo doesn't use the word "Contact"; all instances use "Lead" in some places and newer instances use "People" as well).

Again, this is not a table. The REST API does not return tables. It returns JSON-, CSV- and/or PHP-serialized data.

I tried to read the documentation on Leads API but it was difficult for me to follow since we are relatively new to Marketo.

You need to ask the 3rd-party vendor. The filtering (and therefore the count) in a 3rd-party application is entirely under their control. It's likely that they (a) are not reconciling deleted leads and/or (b) did not fetch all the leads from your Marketo instance. It's extremely easy to introduce such discrepancies if the product has not been meticulously designed to avoid them.

Sid_Patil
Sid_PatilAuthor
Level 2
February 24, 2019

Thanks, Sanford! That was really helpful.