Why Is Data Missing From the COMPANY and LEAD_COMPANY Tables?

Question

Why is data missing from the COMPANY and LEAD_COMPANY tables?

Environment

Connector: Marketo

Answer

We populate the COMPANY and LEAD_COMPANY tables through the following process:

1. While syncing the LEAD table, we check each lead for a value in the externalCompanyId field. If present, we consider the lead associated with a company.
2. We temporarily store the relationship between each lead ID and its company ID.
3. Using the stored company IDs, we query Marketo for additional company details.
4. We upsert the company data into the COMPANY table and create the LEAD_COMPANY table based on the lead-to-company mappings.

We can't retrieve company information if the externalCompanyId field is missing or empty in the source data. Consequently, both tables remain empty.