Pardot SUR CETTE PAGE
Pardot is a marketing automation solution that enables marketers to identify prospective customers that are most likely to convert.
Pardot integration replicates data using the Pardot API .
See the
Schema section for a list of objects available for replication.
Instantané des fonctions Présentation générale de ce connecteur, y compris des liens utiles et les fonctions supportées.
Preparing for authentication To access your data, you need to authenticate the connection with your account credentials.
Note Informations Assurez-vous que le compte que vous utilisez dispose d'un accès en lecture sur les tables à récupérer.
To retrieve your business unit ID:
Log into your Salesforce account. Navigate to Setup . Search for Pardot in the Quick Find box. Copy and paste your business unit ID into a secured file. To retrieve your consumer key and secret:
Log into your Salesforce account. Navigate to Setup . Search for App Manager in the Quick Find box. Go to your connected app and select View . Copy and paste your consumer key into a secured file. Click Click to reveal to show your consumer secret and copy it. Creating the connection For more information, see Connexion à des applications SaaS
Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify .
Note Conseil You may need to scroll down to see this field.
When status is Verified , the authentication is verified.
Provide a name for the connection in Connection name .
Select Open connection metadata to define metadata for the connection when it has been created.
Connection settings Setting Description Data gateway
Sélectionnez une Passerelle de déplacement des données si cela est nécessaire pour votre cas d'utilisation.
Note Informations Ce champ n'est pas disponible avec l'abonnement Démarreur Qlik Talend Cloud , car il ne supporte pas Passerelle de déplacement des données . Si vous avez un autre niveau d'abonnement et si vous ne souhaitez pas utiliser Passerelle de déplacement des données , sélectionnez Aucune .
Pour des informations sur les avantages de Passerelle de déplacement des données et les cas d'utilisation qui la nécessitent, consultez Passerelle de données Qlik - Déplacement des données
Start Date Saisissez la date, au format MM/DD/YYYY, à partir de laquelle les données doivent être répliquées de votre source vers votre cible.
Pardot Business Unit ID Business unit ID.
Consumer Key A unique identifier for the connected app.
Consumer Secret A password for the connected app.
Note Informations Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 1.
Depending on your destination, table and column names may not appear as they are outlined below.
campaigns
The campaigns table contains info about the campaigns in your Pardot account.
campaigns table foreign keys Join campaigns with on opportunities campaigns.id = opportunities.campaign_id prospects campaigns.id = prospects.campaign_id
campaigns table schema
cost
INTEGER
id
INTEGER
name
STRING
email_clicks
The email_clicks table contains info about email click events.
email_clicks table foreign keys Join email_clicks with on visitor_activities email_clicks.email_template_id = visitor_activities.email_template_id email_clicks.list_email_id = visitor_activities.list_email_id email_clicks.prospect_id = visitor_activities.prospect_id list_memberships email_clicks.prospect_id = list_memberships.prospect_id prospects email_clicks.prospect_id = prospects.id visits email_clicks.prospect_id = visits.prospect_id
email_clicks table schema
created_at
DATE-TIME
drip_program_action_id
INTEGER
email_template_id
INTEGER
id
INTEGER
list_email_id
INTEGER
prospect_id
INTEGER
tracker_redirect_id
INTEGER
url
STRING
list_memberships
The list_memberships table contains info about list memberships.
Note : To replicate this table, the lists
list_memberships table foreign keys Join list_memberships with on lists list_memberships.list_id = lists.id email_clicks list_memberships.prospect_id = email_clicks.prospect_id prospects list_memberships.prospect_id = prospects.id visitor_activities list_memberships.prospect_id = visitor_activities.prospect_id visits list_memberships.prospect_id = visits.prospect_id
list_memberships table schema
created_at
DATE-TIME
id
INTEGER
list_id
INTEGER
opted_out
INTEGER
prospect_id
INTEGER
updated_at
DATE-TIME
lists
The lists table contains info about the lists in your Pardot account.
lists table schema
created_at
DATE-TIME
description
STRING
id
INTEGER
is_crm_visible
BOOLEAN
is_dynamic
BOOLEAN
is_public
BOOLEAN
name
STRING
title
STRING
updated_at
DATE-TIME
opportunities
The opportunities table contains info about the opportunities in your Pardot account.
opportunities table foreign keys Join opportunities with on campaigns opportunities.campaign_id = campaigns.id prospects opportunities.campaign_id = prospects.campaign_id
opportunities table schema
campaign_id
INTEGER
closed_at
DATE-TIME
created_at
DATE-TIME
id
INTEGER
name
STRING
probability
INTEGER
stage
STRING
status
STRING
type
STRING
updated_at
DATE-TIME
value
NUMBER
prospect_accounts
The prospect_accounts table contains info about prospect accounts.
prospect_accounts table foreign keys Join prospect_accounts with on users prospect_accounts.assigned_to.user.id = users.id
prospect_accounts table schema
assigned_to
OBJECT
This is a nested data structure:
user: OBJECT, which is also a nested data structure.
account: INTEGER created_at: DATE-TIME email: STRING first_name: STRING id: INTEGER job_tile: STRING last_name: STRING role: STRING updated_at: DATE-TIME
created_at
DATE-TIME
id
INTEGER
name
STRING
updated_at
DATE-TIME
prospects
The prospects table contains info about the prospects in your Pardot account.
prospects table foreign keys prospects table schema
address_one
STRING
address_two
STRING
annual_revenue
STRING
campaign_id
INTEGER
city
STRING
comments
STRING
company
STRING
country
STRING
created_at
DATE-TIME
crm_account_fid
STRING
crm_contact_fid
STRING
crm_last_sync
DATE-TIME
crm_lead_fid
STRING
crm_owner_fid
STRING
crm_url
STRING
department
STRING
email
STRING
employees
STRING
fax
STRING
first_name
STRING
grade
STRING
id
INTEGER
industry
STRING
is_do_not_call
BOOLEAN
is_do_not_email
BOOLEAN
is_reviewed
BOOLEAN
is_starred
BOOLEAN
job_title
STRING
last_activity_at
DATE-TIME
last_name
STRING
notes
STRING
opted_out
BOOLEAN
password
STRING
phone
STRING
prospect_account_id
INTEGER
recent_interaction
STRING
salutation
STRING
score
INTEGER
source
STRING
state
STRING
territory
STRING
updated_at
DATE-TIME
website
STRING
years_in_business
STRING
zip
STRING
users
The users table contains info about the users in your Pardot account.
users table schema
created_at
DATE-TIME
email
STRING
first_name
STRING
id
INTEGER
job_title
STRING
last_name
STRING
role
STRING
updated_at
DATE-TIME
visitor_activities
The visitor_activities table contains info about visitor activities.
visitor_activities table foreign keys Join visitor_activities with on email_clicks visitor_activities.email_template_id = email_clicks.email_template_id visitor_activities.list_email_id = email_clicks.list_email_id visitor_activities.prospect_id = email_clicks.prospect_id list_memberships visitor_activities.prospect_id = list_memberships.prospect_id prospects visitor_activities.prospect_id = prospects.id visits visitor_activities.prospect_id = visits.prospect_id visitor_activities.visitor_id = visits.visitor_id visitors visitor_activities.visitor_id = visitors.id
visitor_activities table schema
campaign
OBJECT
This is a nested data structure.
campaign_id
INTEGER
created_at
DATE-TIME
details
STRING
email_id
INTEGER
email_template_id
INTEGER
file_id
INTEGER
form_handler_id
INTEGER
form_id
INTEGER
id
INTEGER
landing_page_id
INTEGER
list_email_id
INTEGER
multivariate_test_variation_id
INTEGER
paid_search_id_id
INTEGER
prospect_id
INTEGER
site_search_query_id
INTEGER
type
INTEGER
type_name
STRING
updated_at
DATE-TIME
visitor_id
INTEGER
visitor_page_view_id
INTEGER
visitors
The visitors table contains info about visitors.
visitors table foreign keys visitors table schema
campaign_parameter
STRING
content_parameter
STRING
created_at
DATE-TIME
hostname
STRING
id
INTEGER
ip_address
STRING
medium_parameter
STRING
page_view_count
INTEGER
source_parameter
STRING
term_parameter
STRING
updated_at
DATE-TIME
visits
The visits table contains info about visits.
Note : To replicate this table, you must also set the visitors
visits table foreign keys Join visits with on email_clicks visits.prospect_id = email_clicks.prospect_id list_memberships visits.prospect_id = list_memberships.prospect_id prospects visits.prospect_id = prospects.id visitor_activities visits.prospect_id = visitor_activities.prospect_id visits.visitor_id = visitor_activities.visitor_id visitors visits.visitor_id = visitors.id
visits table schema
campaign_parameter
STRING
content_parameter
STRING
created_at
DATE-TIME
duration_in_seconds
INTEGER
first_visitor_page_view_at
DATE-TIME
id
INTEGER
last_visitor_page_view_at
DATE-TIME
medium_parameter
STRING
prospect_id
INTEGER
source_parameter
STRING
term_parameter
STRING
updated_at
DATE-TIME
visitor_id
INTEGER
visitor_page_view_count
INTEGER
visitor_page_views
OBJECT
This is a nested data structure:
visitor_page_view: ARRAY, which is also a nested data structure.
created_at: DATE-TIME id: INTEGER title: STRING url: STRING
