Release Notes
July 2024
We have added a new field, Historical Sync Limit, to the connector setup form. This allows you to select the time range for which historical data should be synced. The default value is ALL_TIME
. For an existing connector, you can edit the connection details and set the time frame value. We have also added support for the timeframe_months
field for connectors created using the Create a Connector endpoint. For more information, see our REST API config.
The historical sync limit only applies to the following tables:
EMAIL
LIST_MEMBERSHIP
VISITOR_ACTIVITY
VISITOR_PAGE_VIEW
For more information, see our Pardot documentation.
We have added a new table, EXTERNAL_ACTIVITY
. For more information, see Pardot's API documentation for the external-activites
endpoint.
We will gradually roll out this change to all connectors. The table can be selected by selecting the toggle in the setup form. Refer to Pardot's setup guide for more information.
May 2024
We have added a new table, EMAIL_TEMPLATE
with the following child tables:
REPLY_TO_OPTION
SENDER_OPTION
April 2024
We have upgraded the following tables of our Pardot connector to version 5 of the Pardot API.
CAMPAIGN
LIST
LIST_MEMBERHSIP
VISIT
VISITOR
VISITOR_ACTIVITY
VISITOR_PAGE_VIEW
As part of the upgrade, we have made the following schema changes:
Added the following new columns to the
CAMPAIGN
table:created_at
created_by_id
folder_id
parent_campaign_id
salesforce_id
updated_at
updated_by_id
Added the following new columns to the
LIST
table:campaign_id
created_by_id
folder_id
updated_by_id
Added the following new columns to the
LIST_MEMBERSHIP
table:created_by_id
updated_by_id
Added the following new columns to the
VISITOR
table:campaign_id
do_not_sell
is_identified
Added the following new columns to the
VISITOR_ACTIVITY
table:custom_redirected_id
updated_at
Added the following new columns to the
VISITOR_PAGE_VIEW
table:campaign_id
duration_in_seconds
salesforce_id
visitor_id
Deprecated the
is_crm_visible
column from theLIST
table.
We have added a new table CUSTOM_FIELD
with the following columns:
created_at
created_by_id
field_id
id
is_analytics_synced
is_record_multiple_responses
is_required
is_use_values
name
salesforce_id
type
updated_at
updated_by_id
We are gradually rolling out this improvement to all existing connectors.
January 2024
We now perform rollback syncs with a window of three days to capture all the updates made to the EMAIL_TAG
table. This addresses the issue where email sent_at
dates occurring after their related tag created_at
dates led to missed updates. In some cases, if the difference between the email sent_at
dates and the related tag object created_at
date is more than three days, the email tag objects may not be synced. To resolve this issue, contact our support team.
We are gradually rolling out this improvement to all the existing connectors.
September 2023
We now capture deletes for the LIST_MEMBERSHIP
table. We are gradually rolling out this feature to all existing connectors.
May 2023
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 2023
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 2022
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_id
client_type
created_by_id
list_email_id
list_id
prospect_id
sent_at
We are gradually rolling out this feature to all existing connectors.
February 2021
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 2021
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 2020
We now sync custom fields to the PROSPECT_ACCOUNT
table in JSON format.
November 2019
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 2019
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 2018
We have added custom_*
columns to the CAMPAIGN
table.