Marketo Release Notes – Fivetran Support Portal

June 2021link

We have added a new table, FOLDER, to support Marketo API’s Folders endpoint.

May 2021link

We now display a broken connector task on your connector dashboard when we detect that your Bulk API daily usage quota is not sufficient for a sync to complete. We keep track of your daily bulk API usage, and if your quota is less than 70% of the estimated API usage required to successfully sync data, we display this error. Increase your Bulk API quota to resolve the task.

We have made the following changes to the Schema tab of your connector details page:

Added the ACTIVITY_TYPE and OPPORTUNITY_MEMBERSHIP tables. You can now select or deselect the tables from your syncs. We include the two tables in the sync if you have enabled the Allow all option in the Schema Change Settings menu.
Fixed the name of the API_USAGE table. Previously, the table was incorrectly named USAGE.
Added the child tables of COMPANY, LEAD, LIST, PROGRAM, and PROGRAM_MEMBERSHIP tables. The child tables are view-only. You must include or exclude the parent tables.

April 2021link

We have added the following new tables to support Marketo API’s Segmentation endpoints:

SEGMENTATION
SEGMENT
LEAD_SEGMENT

November 2020link

You can now exclude the following activity tables from your syncs:

ACTIVITY_ADD_TO_LIST
ACTIVITY_ADD_TO_NURTURE
ACTIVITY_ADD_TO_OPPORTUNITY
ACTIVITY_CHANGE_DATA_VALUE
ACTIVITY_CHANGE_STATUS_IN_PROGRESSION
ACTIVITY_DELETE_LEAD
ACTIVITY_MERGE_LEADS
ACTIVITY_NEW_LEAD
ACTIVITY_REMOVE_FROM_LIST
ACTIVITY_REMOVE_FROM_OPPORTUNITY

On your Connector Details page, go to the Schema tab and deselect the tables.

August 2020link

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 2020link

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 2019link

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 2019link

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 2019link

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 2018link

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 2018link

We have added two new tables, EMAIL and API_USAGE.