Release Noteslink
September 2023link
We now support capturing deletes for the LIST_MEMBERSHIP table. We are gradually rolling out this feature to all our customers.
May 2023link
We have added a new table, LIST_EMAIL, to store the details of your sent emails.
We can now sync the EMAIL table into your destination using the Pardot API version 5 endpoints.
January 2023link
We now sync the permanently deleted records of the PROSPECT table. We set the is_permanently_deleted column for the permanently deleted records to true. To capture these deletes, we perform a full re-sync of the PROSPECT table on weekends.
You can now sync the custom properties of the LIST and MAP data types in the PROSPECT table.
December 2022link
We have added a new table, LIST_EMAIL, which stores the text and HTML content of emails. For more information about the table, see Pardot's documentation.
We have added the following new columns to the EMAIL table:
campaign_idclient_typecreated_by_idlist_email_idlist_idprospect_idsent_atWe are gradually rolling out this feature to all existing customers.
February 2021link
The Pardot connector now supports authorization using Salesforce OAuth. You can now authenticate with an SSO-enabled user account. See our setup instructions for more details.
New connectors created after February 16, 2021, will support this new functionality by default.
January 2021link
In your connector setup form, you can now limit the REST API calls that your Pardot connector makes per day. By default, the REST API call limit is 150,000 per day.
We have released pre-built, dbt Core-compatible data models for Pardot. Find the model in Fivetran's dbt hub. 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.
The Pardot connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Pardot's priority-first syncs fetch the most recent 14 days' worth of data from the EMAIL, VISIT, and VISITOR_ACTIVITY tables. To learn more, see our priority-first sync documentation.
March 2020link
We now sync custom fields to the PROSPECT_ACCOUNT table in JSON format.
November 2019link
We have fixed a bug in our Pardot connector. Previously, we only synced visitors flagged as "Identified," because by default, the visitor endpoint we use to sync visitors only syncs visitors flagged as "Identified." We have changed the setting and now sync all visitors.
Because of this bug, there may be a mismatch between the list of visitors in your Pardot dashboard and in the VISITOR table in your destination. If you notice a mismatch, you need to re-sync the VISITOR table to fix it. Contact support to trigger a re-sync.
August 2019link
We have deprecated the VISITOR_REFERRER table from our schema because the Pardot API does not provide us with information to populate this table.
July 2018link
We have added custom_* fields to the CAMPAIGN table.