We now capture deletes for the following tables:
We have added the
_fivetran_deleted system column to the above tables.
We have added a new table,
FOLDER, to support Marketo API’s Folders endpoint.
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:
OPPORTUNITY_MEMBERSHIPtables. 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_USAGEtable. Previously, the table was incorrectly named
Added the child tables of
PROGRAM_MEMBERSHIPtables. The child tables are view-only. You must include or exclude the parent tables.
We have added the following new tables to support Marketo API’s Segmentation endpoints:
You can now exclude the following activity tables from your syncs:
On your Connector Details page, go to the Schema tab and deselect the tables.
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.
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.
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.
Fivetran now allows you to exclude secondary attribute columns (for example,
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.
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.
We have added a new table,
All activity tables related to emails (for example,
ACTIVITY_EMAIL_DELIVERED, etc.) now have a foreign key relationship to the
We have added two new tables,