Skip to content
Book a demoStart free
Connectors

Salesforce Marketing Cloud Account Engagement connector

Set up the Salesforce Marketing Cloud Account Engagement connector in Kaivo: authentication, configuration, the BigQuery tables it syncs, and answers to common

Salesforce Marketing Cloud Account Engagement connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Salesforce Marketing Cloud Account Engagement data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your marketing and sales data instead of moving it.

What is the Salesforce Marketing Cloud Account Engagement connector

Section titled “What is the Salesforce Marketing Cloud Account Engagement connector”

Sync your Salesforce Marketing Cloud Account Engagement (Pardot) data into BigQuery with Kaivo to measure email, forms, and prospect activity in one place.

CategoryMarketing & Sales
AuthenticationAPI key
SetupSelf-service

Getting started with the Salesforce Marketing Cloud Account Engagement connector

Section titled “Getting started with the Salesforce Marketing Cloud Account Engagement connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Salesforce Marketing Cloud Account Engagement account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticating Salesforce Marketing Cloud Account Engagement

Section titled “Authenticating Salesforce Marketing Cloud Account Engagement”

Authenticate with your Salesforce Marketing Cloud Account Engagement credentials. You provide:

Field Description
Client ID
The Consumer Key found when viewing your connected app in Salesforce.

| | Client Secret |

The Consumer Secret found when viewing your connected app in Salesforce.

| | Refresh Token |

Salesforce Refresh Token used to authenticate the connector.

|

Prerequisites

Pardot (Salesforce Account Engagement) uses Salesforce OAuth, so you need your own Salesforce connected app:

  1. In Salesforce Setup → App Manager, create a Connected App with OAuth enabled and the “Manage Pardot services” + “refresh_token, offline_access” scopes, then copy its Consumer Key (Client ID) and Consumer Secret (Client Secret).
  2. Complete the OAuth authorization flow once to obtain a Refresh Token.
  3. Find your Pardot Business Unit ID at Setup → Pardot → Pardot Account Setup. See Salesforce’s guide.

Need help, or want an easier way to connect? Reach our team via the chat in the bottom-right corner.

Configuring the Salesforce Marketing Cloud Account Engagement connector

Section titled “Configuring the Salesforce Marketing Cloud Account Engagement connector”

When you set up the connector, you provide:

Field Description
Pardot Business Unit ID
Pardot Business Unit ID, found at Setup > Pardot > Pardot Account Setup.

| | Start Date |

Any data before this date will not be fetched.

|

Tables and columns synced from Salesforce Marketing Cloud Account Engagement

Section titled “Tables and columns synced from Salesforce Marketing Cloud Account Engagement”

Kaivo syncs 33 tables from Salesforce Marketing Cloud Account Engagement into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

account (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address_one STRING
address_two STRING
admin_id INT64
api_calls_used INT64
city STRING
company STRING
country STRING
created_at TIMESTAMP
created_by_id INT64
fax STRING
id INT64
level STRING
maximum_daily_api_calls INT64
phone STRING
plugin_campaign_id INT64
state STRING
territory STRING
updated_at TIMESTAMP
updated_by_id INT64
website STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
campaigns (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
cost FLOAT64
created_at TIMESTAMP
created_by_id INT64
folder_id INT64
id INT64
is_deleted BOOL
name STRING
parent_campaign_id INT64
salesforce_id STRING
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
custom_fields (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_at TIMESTAMP
created_by_id INT64
field_id STRING
id INT64
is_analytics_synced BOOL
is_record_multiple_responses BOOL
is_required BOOL
is_use_values BOOL
name STRING
salesforce_id STRING
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
custom_redirects (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
bitly_is_personalized BOOL
bitly_short_url STRING
campaign_id INT64
created_at TIMESTAMP
created_by_id INT64
destination_url STRING
folder_id INT64
ga_campaign STRING
ga_content STRING
ga_medium STRING
ga_source STRING
ga_term STRING
id INT64
is_deleted BOOL
name STRING
salesforce_id STRING
tracked_url STRING
tracker_domain_domain STRING
tracker_domain_id INT64
updated_at TIMESTAMP
updated_by_id INT64
url STRING
vanity_url STRING
vanity_url_path STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
dynamic_content_variations (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
comparison STRING
content STRING
dynamic_content_id INT64
id INT64
operator STRING
value1 STRING
value2 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
dynamic_contents (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
based_on STRING
based_on_prospect_api_field_id STRING
created_at TIMESTAMP
created_by_id INT64
embed_code STRING
embed_url STRING
folder_id INT64
id INT64
is_deleted BOOL
name STRING
tag_replacement_language STRING
tracker_domain_id INT64
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
email_clicks (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
drip_program_action_id INT64
email_template_id INT64
id INT64
list_email_id INT64
prospect_id INT64
tracker_redirect_id INT64
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
emails (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
campaign_id INT64
client_type STRING
created_by_id INT64
email_template_id INT64
id INT64
is_operational BOOL
list_email_id INT64
name STRING
prospect_id INT64
sent_at TIMESTAMP
subject STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
account_custom_field_id INT64
address STRING
name STRING
prospect_custom_field_id INT64
user_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
account_custom_field_id INT64
address STRING
name STRING
prospect_custom_field_id INT64
user_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
engagement_studio_programs (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
business_hours__end_time TIME
business_hours__start_time TIME
business_hours__timezone STRING
created_at TIMESTAMP
created_by_id INT64
id INT64
is_deleted BOOL
prospects_multiple_entry__maximum_entries INT64
prospects_multiple_entry__minimum_duration_in_days INT64
salesforce_id STRING
schedule__created_at TIMESTAMP
schedule__start_on TIMESTAMP
schedule__stop_on TIMESTAMP
schedule_created_by_id INT64
status STRING
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: engagement_studio_programs__business_hours__days

Section titled “Subtable: engagement_studio_programs__business_hours__days”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: engagement_studio_programs__recipient_list_ids

Section titled “Subtable: engagement_studio_programs__recipient_list_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: engagement_studio_programs__suppression_list_ids

Section titled “Subtable: engagement_studio_programs__suppression_list_ids”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
files (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
bitly_is_personalized BOOL
bitly_short_url STRING
campaign_id INT64
created_at TIMESTAMP
created_by_id INT64
folder_id INT64
id INT64
is_tracked BOOL
name STRING
salesforce_id STRING
size INT64
tracker_domain_id INT64
updated_at TIMESTAMP
updated_by_id INT64
url STRING
vanity_url STRING
vanity_url_path STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
folder_contents (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
created_by_id INT64
folder_id INT64
folder_ref STRING
id INT64
object_id INT64
object_name STRING
object_ref STRING
object_type STRING
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
folders (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
created_by_id INT64
id INT64
name STRING
parent_folder_id INT64
path STRING
updated_at TIMESTAMP
updated_by_id INT64
use_permissions BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
form_fields (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_at TIMESTAMP
created_by_id INT64
css_classes STRING
data_format STRING
error_message STRING
form_id INT64
has_dependents BOOL
has_progressives BOOL
has_values BOOL
id INT64
is_always_display BOOL
is_do_not_prefill BOOL
is_maintain_initial_value BOOL
is_required BOOL
label STRING
prospect_api_field_id STRING
sort_order INT64
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
form_handler_fields (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
created_by_id INT64
data_format STRING
error_message STRING
form_handler_id INT64
id INT64
is_maintain_initial_value BOOL
is_required BOOL
name STRING
prospect_api_field_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
form_handlers (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_id INT64
created_at TIMESTAMP
created_by_id INT64
embed_code STRING
error_location STRING
folder_id INT64
id INT64
is_always_email BOOL
is_cookieless BOOL
is_data_forwarded BOOL
is_deleted BOOL
name STRING
salesforce_id STRING
success_location STRING
tracker_domain_id INT64
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
forms (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
after_form_content STRING
before_form_content STRING
campaign_id INT64
checkbox_alignment STRING
created_at TIMESTAMP
created_by_id INT64
embed_code STRING
folder_id INT64
font_color STRING
font_family STRING
font_size STRING
id INT64
is_always_display BOOL
is_captcha_enabled BOOL
is_cookieless BOOL
is_deleted BOOL
is_use_redirect_location BOOL
label_alignment STRING
layout_template_id INT64
name STRING
radio_alignment STRING
redirect_location STRING
required_character STRING
salesforce_id STRING
show_not_prospect BOOL
submit_button_text STRING
thank_you_code STRING
thank_you_content STRING
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
landing_pages (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
archive_date DATE
bitly_is_personalized BOOL
bitly_short_url STRING
campaign_id INT64
created_at TIMESTAMP
created_by_id INT64
folder_id INT64
form_id INT64
id INT64
is_deleted BOOL
is_do_not_index BOOL
is_use_redirect_location BOOL
layout_table_border INT64
layout_template_id INT64
layout_type STRING
name STRING
redirect_location STRING
salesforce_id STRING
title STRING
tracker_domain_id INT64
updated_at TIMESTAMP
updated_by_id INT64
url STRING
vanity_url STRING
vanity_url_path STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
layout_templates (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
created_by_id INT64
folder_id INT64
form_content STRING
id INT64
is_deleted BOOL
is_include_default_css BOOL
layout_content STRING
name STRING
site_search_content STRING
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lifecycle_histories (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
id INT64
next_stage_id INT64
previous_stage_id INT64
prospect_id INT64
seconds_elapsed INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lifecycle_stages (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
id INT64
is_deleted BOOL
is_locked BOOL
match_type STRING
name STRING
position INT64
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_emails (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_id INT64
client_type STRING
created_at TIMESTAMP
created_by_id INT64
email_template_id INT64
folder_id INT64
id INT64
is_deleted BOOL
is_operational BOOL
is_paused BOOL
is_sent BOOL
name STRING
sent_at TIMESTAMP
subject STRING
tracker_domain_id INT64
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
account_custom_field_id INT64
address STRING
prospect_custom_field_id INT64
user_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
account_custom_field_id INT64
address STRING
name STRING
prospect_custom_field_id INT64
user_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
list_membership (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
created_by_id INT64
id INT64
list_id INT64
opted_out BOOL
prospect_id INT64
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
lists (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at TIMESTAMP
created_by_id INT64
folder_id INT64
id INT64
is_deleted BOOL
is_dynamic BOOL
is_public BOOL
name STRING
title STRING
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
opportunities (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
campaign_id INT64
closed_at TIMESTAMP
created_at TIMESTAMP
created_by_id INT64
id INT64
name STRING
probability INT64
salesforce_id STRING
stage STRING
status STRING
updated_at TIMESTAMP
updated_by_id INT64
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
prospect_accounts (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
annual_revenue STRING
assigned_to_id INT64
billing_address_one STRING
billing_address_two STRING
billing_city STRING
billing_country STRING
billing_state STRING
billing_zip STRING
created_at TIMESTAMP
created_by_id INT64
employees STRING
fax STRING
id INT64
industry STRING
is_deleted BOOL
name STRING
number STRING
ownership STRING
phone STRING
rating STRING
salesforce_id STRING
shipping_address_one STRING
shipping_address_two STRING
shipping_city STRING
shipping_country STRING
shipping_state STRING
shipping_zip STRING
sic STRING
site STRING
ticker_symbol STRING
updated_at TIMESTAMP
updated_by_id INT64
website STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
prospects (72 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
address_one STRING
address_two STRING
annual_revenue STRING
assigned_to_id STRING
campaign_id INT64
campaign_parameter STRING
city STRING
comments STRING
company STRING
content_parameter STRING
converted_at TIMESTAMP
converted_from_object_name STRING
converted_from_object_type STRING
country STRING
created_at TIMESTAMP
created_by_id INT64
department STRING
do_not_sell BOOL
email STRING
email_bounced_at TIMESTAMP
email_bounced_reason STRING
employees STRING
fax STRING
first_activity_at TIMESTAMP
first_assigned_at TIMESTAMP
first_name STRING
first_referrer_query STRING
first_referrer_type STRING
first_referrer_url STRING
grade STRING
id INT64
industry STRING
is_deleted BOOL
is_do_not_call BOOL
is_do_not_email BOOL
is_email_hard_bounced BOOL
is_reviewed BOOL
is_starred BOOL
job_title STRING
last_activity_at TIMESTAMP
last_name STRING
lifecycle_stage_id INT64
medium_parameter STRING
notes STRING
opted_out BOOL
phone STRING
profile_id INT64
prospect_account_id INT64
recent_interaction STRING
salesforce_account_id STRING
salesforce_campaign_id STRING
salesforce_contact_id STRING
salesforce_id STRING
salesforce_last_sync TIMESTAMP
salesforce_lead_id STRING
salesforce_owner_id STRING
salesforce_url STRING
salutation STRING
score STRING
source STRING
source_parameter STRING
state STRING
term_parameter STRING
territory STRING
updated_at TIMESTAMP
updated_by_id INT64
user_id INT64
website STRING
years_in_business STRING
zip STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
created_by_id INT64
id INT64
name STRING
object_count INT64
updated_at TIMESTAMP
updated_by_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tracker_domains (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
created_by_id INT64
default_campaign_id INT64
domain STRING
https_status STRING
id INT64
is_deleted BOOL
is_primary BOOL
ssl_requested_by_id INT64
ssl_status STRING
ssl_status_details STRING
tracking_code STRING
updated_at TIMESTAMP
updated_by_id INT64
validated_at TIMESTAMP
validation_status STRING
vanity_url_status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
created_by_id INT64
email STRING
first_name STRING
id INT64
is_deleted BOOL
job_title STRING
role STRING
role_name STRING
salesforce_id STRING
tag_replacement_language STRING
updated_at TIMESTAMP
updated_by_id INT64
username STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
visitor_activities (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type INT64
campaign_id INT64
created_at TIMESTAMP
custom_redirect_id INT64
details STRING
email_id INT64
email_template_id INT64
file_id INT64
form_handler_id INT64
form_id INT64
id INT64
landing_page_id INT64
list_email_id INT64
multivariate_test_variation_id INT64
opportunity_id INT64
paid_search_ad_id INT64
prospect_id INT64
site_search_query_id INT64
type_name STRING
updated_at TIMESTAMP
visit_id INT64
visitor_id INT64
visitor_page_view_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
visitor_page_views (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_id INT64
created_at TIMESTAMP
duration_in_seconds INT64
id INT64
salesforce_id STRING
title STRING
url STRING
visit_id INT64
visitor_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
visitors (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_id INT64
campaign_parameter STRING
content_parameter STRING
created_at TIMESTAMP
do_not_sell BOOL
hostname STRING
id INT64
ip_address STRING
is_identified BOOL
medium_parameter STRING
page_view_count INT64
prospect_id INT64
source_parameter STRING
term_parameter STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
visits (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
campaign_parameter STRING
content_parameter STRING
created_at TIMESTAMP
duration_in_seconds INT64
first_visitor_page_view_at TIMESTAMP
id INT64
last_visitor_page_view_at TIMESTAMP
medium_parameter STRING
prospect_id INT64
source_parameter STRING
term_parameter STRING
updated_at TIMESTAMP
visitor_id INT64
visitor_page_view_count INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the Salesforce Marketing Cloud Account Engagement sync works

Section titled “How the Salesforce Marketing Cloud Account Engagement sync works”

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Salesforce Marketing Cloud Account Engagement supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Salesforce Marketing Cloud Account Engagement?

Section titled “How long does the initial sync take for Salesforce Marketing Cloud Account Engagement?”

It depends on how much history is in your Salesforce Marketing Cloud Account Engagement account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Salesforce Marketing Cloud Account Engagement’s schema changes?

Section titled “What happens when Salesforce Marketing Cloud Account Engagement’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Salesforce Marketing Cloud Account Engagement, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Salesforce Marketing Cloud Account Engagement instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Salesforce Marketing Cloud Account Engagement connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Salesforce Marketing Cloud Account Engagement data

Section titled “Common use cases for Salesforce Marketing Cloud Account Engagement data”

Use emails and email_clicks to track engagement across your campaigns.

Join prospects with visitor_activities to see how leads engage before they convert.

Use forms, form_handlers, and landing_pages to find what drives the most conversions.

Bring lifecycle_stages and lifecycle_histories into BigQuery to track funnel progression.

Use Salesforce Marketing Cloud Account Engagement data in your AI and BI tools

Section titled “Use Salesforce Marketing Cloud Account Engagement data in your AI and BI tools”

Once Salesforce Marketing Cloud Account Engagement data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Salesforce Marketing Cloud Account Engagement data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Salesforce Marketing Cloud Account Engagement connector pricing and plan details.