There is no
fivetran_deleted column for the leads table, preventing you from viewing deleted leads.
Marketo - Lead records
To track deleted records, we have added the ACTIVITY_DELETED_LEAD table, as mentioned in our docs. Use the below query to see the correct deleted status of your leads:
WHEN activity_deleted_lead.lead_id IS NULL THEN false
END as deleted
LEFT JOIN activity_deleted_lead on lead.id=activity_deleted_lead.lead_id;
Our Marketo connector uses priority-first sync to fetch your activities data. Sometimes, we pull recent lead data that is overwritten by outdated records when we sync your older data.
This may cause a lead to be created but the deletion to be missed. This is because we have read the deletion first when pulling the most recent activities.