Pardot: Campaigns

Description

• Each record represents a campaign in Pardot

Supported Data Sources

• Pardot

Columns

Type	Name	Description
INTEGER	campaign_id	Pardot ID for this campaign
STRING	campaign_name	Campaign's name
INTEGER	cost	Cost associated to the campaign
BOOLEAN	_fivetran_deleted	Boolean representing whether the record has been deleted in the source system.
DATETIME	_fivetran_synced	The timestamp of when a record was last synced by Fivetran.
INTEGER	count_opportunities	Count of all campaign opportunities
INTEGER	count_opportunities_won	Count of all campaign opportunities won
DECIMAL	sum_opportunity_amount_won	Sum of all campaign opportunities won
INTEGER	count_opportunities_lost	Count of all campaign opportunities lost
DECIMAL	sum_opportunity_amount_lost	Sum of all campaign opportunities lost
INTEGER	count_prospects	Number of prospects associated with the campaign