Release Notes
November 2020
You can now omit the following activity tables from replicating to your destination:
ACTIVITY_ADD_TO_LISTACTIVITY_ADD_TO_NURTUREACTIVITY_ADD_TO_OPPORTUNITYACTIVITY_CHANGE_DATA_VALUEACTIVITY_CHANGE_STATUS_IN_PROGRESSIONACTIVITY_DELETE_LEADACTIVITY_MERGE_LEADSACTIVITY_NEW_LEADACTIVITY_REMOVE_FROM_LISTACTIVITY_REMOVE_FROM_OPPORTUNITY
August 2020
We have released a pre-built dbt package for Marketo. Find the package in Fivetran's dbt hub. Learn more about our dbt integration in our dbt Transformations documentation.
February 2020
We now use a separate API endpoint to retrieve deleted lead activities, because Marketo’s BULK API does not support these activities. We can’t retrieve deleted lead activities older than 14 days because Marketo doesn’t retain them.
November 2019
We have released version 3 of our Marketo connector. This new version:
- Fixes data integrity issues with Marketo activities by fetching them using BULK API
- Syncs your most recent activity data first using priority-first sync
For more details about Marketo version 3, see our Marketo documentation.
August 2019
Fivetran now allows you to exclude secondary attribute columns (for example, client_ip_address, query_parameters) from all activity tables. You can exclude these columns by navigating your schema tab in your dashboard and deselecting them for a particular table.
February 2019
Fivetran now fetches lead activities following the Marketo Activities Data Retention Policy.
High volume activities are fetched from the last 90 days. This includes following activities:
- Add to List
- Change Score
- Change Data Value
- Visit Webpage
- Sync Lead to SFDC
- Sync Lead to Microsoft
- Update Opportunity
- Request Campaign
All other activities are fetched from the last 25 months.
June 2018
We have added a new table, EMAIL_TEMPLATE_HISTORY.
All activity tables related to emails (for example, ACTIVITY_SEND_EMAIL, ACTIVITY_EMAIL_DELIVERED, etc.) now have a foreign key relationship to the EMAIL_TEMPLATE_HISTORY table.
April 2018
We have added two new tables, EMAIL and API_USAGE.