Excel Add-In for Salesforce Pardot

Build 21.0.7930

Campaigns

Retrieve and modify campaigns.

Table Specific Information

Select

The add-in will use the Salesforce Pardot API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.

  • Id supports '=', '<', '<=', '>', '>='.
  • Name supports '='.
  • CreatedAt supports '=', '<', '<=', '>', '>='.
  • UpdatedAt supports '=', '<', '<=', '>', '>='.

For example, the following queries are processed server side:

SELECT * FROM Campaigns WHERE Id = 43
SELECT * FROM Campaigns WHERE Name = 'Website Tracking'

Insert

This table does not have any required attributes when performing an insert.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Pardot ID for this campaign.

Name String False

Campaign's name.

Cost Integer False

Cost associated to the campaign.

CreatedAt Datetime False

Filter by the creation time.

UpdatedAt Datetime False

Filter by the modification time.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930