Release Notes

October 2025

We unified each connector’s pre-built dbt Core*–compatible data models into a single model. It standardizes and documents the Fivetran schemas created in your destination and outputs analytics-ready tables. Previously, most connectors used distinct source and transform models.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

September 2025

We no longer support historicSyncTimeFrame when creating connections using REST API configuration.

August 2025

We have made changes to our Marketo connection setup form and REST API parameters to support the Marketo SOAP API deprecation. These changes won't impact how your connection syncs data to your destination.

We have removed the Provide SOAP API Credentials for BULK API Quota Estimation toggle and the following related fields from the connection setup form:

• SOAP API User Id
• SOAP API Encryption Key
• SOAP API Endpoint

Similarly, we have discontinued the following parameters from the REST API Configuration:

• user_id
• encryption_key
• soap_uri

We have updated the Quickstart packages for the following connectors:

• Amazon Ads to version 1.0.0.
• Asana to version 1.0.0.
• Facebook Pages to version 1.0.0.
• Fivetran Platform to version 2.3.0.
• GitHub to version 1.0.0.
• Greenhouse to version 1.0.0.
• Instagram Business to version 1.0.0.
• Intercom to version 1.0.0.
• Iterable to version 1.0.0.
• Jira to version 1.0.0.
• Klaviyo to version 1.0.0.
• Lever to version 1.0.0.
• LinkedIn Ad Analytics to version 1.0.0.
• LinkedIn Company Pages to version 1.0.0.
• Mailchimp to version 1.0.0.
• Marketo to version 1.0.0.
• Microsoft Advertising to version 1.0.0.
• Mixpanel to version 0.14.0.
• NetSuite SuiteAnalytics to version 1.0.0.
• Pardot to version 1.0.0.
• Pendo to version 1.0.0.
• Pinterest Ads to version 1.0.0.
• Qualtrics to version 1.0.0.
• QuickBooks to version 0.21.0.
• Recharge to version 1.0.0.
• Recurly to version 1.0.0.
• Reddit Ads to version 1.0.0.
• Sage Intacct to version 1.0.0.
• Salesforce Marketing Cloud to version 0.3.0.
• ServiceNow to version 0.5.0.
• Shopify to version 0.21.0.

July 2025

You can now deselect the LEAD table in your connection schema tab.

June 2025

You can now set the prioritise_bulk_export_over_rest parameter using the Fivetran REST API. This parameter allows your connection to use BULK export to extract both the LEAD and ACTIVITY_* tables to improve connection performance and reduce the number of API calls.

April 2025

We have added a new field, Sync data from selected date, under the Historical Sync Time Frame dropdown in the setup form. This allows you to select the exact date up to which the backward sync will occur. The default value is Sync all historical data. You can edit the connection details and update the time frame for an existing connector.

This limit applies to the following tables:

• ACTIVITY_*
• DELETED_PROGRAM_MEMBERSHIP
• LEAD_SEGMENT
• LIST_MEMBERSHIP
• MERGED_LEAD
• OPPORTUNITY_MEMBERSHIP
• SEGMENT

We are gradually rolling out this feature to all connections.

January 2025

We have updated the Quickstart packages for the following connectors:

• Fivetran Platform Connector to version 1.11.0
• Marketo to version 0.13.1
• Mixpanel to version 0.11.0
• NetSuite SuiteAnalytics to version 0.17.1
• Qualtrics to version 0.3.0
• QuickBooks to version 0.17.1
• Salesforce to version 1.2.0
• ServiceNow to version 0.4.0
• Shopify to version 0.16.0
• Stripe to version 0.16.0
• Xero to version 0.7.0
• Zendesk Support to version 0.19.3
• Zuora to version 0.3.1

December 2024

We have updated the Quickstart packages for the following connectors:

• Fivetran Platform Connector to version 1.10.0
• Greenhouse to version 0.8.0
• LinkedIn Ad Analytics to version 0.10.0
• Mailchimp to version 0.10.0
• Marketo to version 0.12.1
• QuickBooks to version 0.17.0
• Shopify to version 0.14.0
• Stripe to version 0.15.1
• Tiktok Ads to version 0.7.0
• Twilio to version 0.4.0
• Zendesk Support to version 0.19.1

We have also updated the Quickstart package for the Ad Reporting multi-connector data model to version 1.10.0.

October 2024

The Marketo connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

September 2024

We have added the following new columns to the EMAIL_TEMPLATE_HISTORY table:

• auto_copy_to_text
• is_open_tracking_disabled
• pre_header

July 2024

You can now set the historical sync time frame for the following tables:

• ACTIVITY_*
• LEAD_SEGMENT
• SEGMENT
• DELETED_PROGRAM_MEMBERSHIP
• OPPORTUNITY_MEMBERSHIP
• LIST_MEMBERSHIP
• MERGED_LEAD

To support this enhancement, we have added a new drop-down menu, Historical Sync Time Frame, to the connector setup form.

April 2024

We have added a new table, TOKEN, to store the tokens associated with folders and programs.

We have changed the priority fetch period of priority-first syncs from 7 days to 1 day. For more information, see our priority-first sync documentation.

December 2023

We have added a new table, FILE, to store details about all the files in your Marketo account.

October 2023

We now support syncing custom fields in the PROGRAM_MEMBERSHIP table. On your Connector Details page, go to the Schema tab and select or deselect the custom fields you want to sync.

September 2023

We can now provide you with an estimate of your BULK API quota usage by using your Marketo SOAP API credentials. To support this feature, we have made the following changes to the connector setup form:

• Added a new toggle, Provide SOAP Credentials for BULK API Quota Estimation. You can opt to set this toggle to ON and provide your SOAP API credentials while configuring the connector.

• Made the following fields optional:

  • SOAP API User Id
  • SOAP API Encryption Key
  • SOAP API Endpoint

For more information, see our setup instructions.

We have added new Quickstart packages for the following connectors:

• Greenhouse
• Iterable
• Klaviyo
• Marketo
• Mixpanel
• Twitter Organic

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

June 2023

We have added the following new columns to the PROGRAM table:

• folder_id
• folder_name
• folder_type
• folder_value
• head_start

We now sync custom properties to the PROGRAM table. We sync the properties with the prefix custom_.

May 2023

We now sync campaign data from the Smart Campaigns API endpoint and have made the following schema changes:

• We have added the following new columns to the CAMPAIGN table:

  • computed_url
  • flow_id
  • folder_id
  • folder_type
  • is_communication_limit_enabled
  • is_requestable
  • is_system
  • max_members
  • qualification_rule_type
  • qualification_rule_interval
  • qualification_rule_unit
  • recurrence_start_at
  • recurrence_end_at
  • recurrence_interval_type
  • recurrence_interval
  • recurrence_weekday_only
  • recurrence_day_of_month
  • recurrence_day_of_week
  • recurrence_week_of_month
  • smart_list_id
  • status

• We have removed the program_name column from the CAMPAIGN table.

We now support incremental updates for the CAMPAIGN table. We perform a full re-import of the table on the weekends to capture deletes.

Connections created after May 18, 2023, will support these changes by default. We are gradually rolling out these changes to all existing connections.

April 2023

Our Marketo connectors now support table-level re-syncs.

We have renamed the LEAD_JOIN_MERGES table to MERGED_LEAD. Be sure to update your queries.

February 2023

We have added a new table, ACTIVITY_TYPE_ATTRIBUTE.

December 2022

We have added a new button, SUPPORTS UPDATEDAT IN BULK EXPORT?, to the connector setup form. You can now determine if your Marketo subscription supports the updatedAt filter for BULK exports. For more information, see Enable updatedAt filter for your subscription.

June 2022

We now capture deletes for the following tables:

• CAMPAIGN
• PROGRAM
• PROGRAM_COST
• PROGRAM_TAG

We have added the _fivetran_deleted system column to the above tables.

June 2021

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

May 2021

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 2021

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

• SEGMENTATION
• SEGMENT
• LEAD_SEGMENT

November 2020

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 2020

We have released pre-built, dbt Core-compatible data models for Marketo. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

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 for the past 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 for the past 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.