CustomRedirects
Track links on your website or third-party site with Pardot custom redirects.
Table Specific Information
Select
The driver will use the Salesforce Pardot API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.
- Id supports '=', '<', '<=', '>', '>='.
- IsDeleted supports '='.
For example, the following queries are processed server side:
SELECT * FROM CustomRedirects WHERE Id = 40 SELECT * FROM CustomRedirects WHERE IsDeleted = 'true'
Insert
The following attributes are required when performing an insert: Name, CampaignId, DestinationUrl.
INSERT INTO CustomRedirects (Name,CampaignId,DestinationUrl) VALUES ('name','1','https://example.com/content.html')
Update
Update CustomRedirects attributes.
UPDATE CustomRedirects SET Name = 'newName', FolderId = '527425' WHERE Id = 24143
Delete
Remove all CustomRedirects objects or one by specifying the Id of the CustomRedirect.
DELETE FROM CustomRedirects WHERE Id = 10003
GetDeleted
To retrieve custom redirects that are in the recycle bin in Pardot the following operation is supported:
GETDELETED FROM CustomRedirects
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Int64 | True |
Pardot ID for this campaign. | |
| Name | String | False |
Name of the object for identification in Pardot. | |
| CampaignId | Int64 | False |
Pardot Campaign related to this object. | |
| DestinationUrl | String | False |
A fully qualified URL. The visitor who clicks the custom redirect is directed to this location. | |
| FolderId | Int64 | False |
ID of the folder containing this object. Uses the asset type's uncategorized folder if not specified on create. | |
| TrackerDomainId | Int64 | False |
ID of the tracker domain to use in the URL for this object. Uses the primary tracker domain for the account if not specified on create. | |
| VanityUrl | String | True |
Fully qualified vanity URL. Includes tracker domain and vanityUrlPath. | |
| VanityUrlPath | String | False |
Vanity URL path (excluding protocol and host). Must be unique for each tracker domain. | |
| GASource | String | False |
Google Analytics Campaign source. | |
| GAMedium | String | False |
Google Analytics Campaign medium. | |
| GATerm | String | False |
Google Analytics Campaign keyword. | |
| GAContent | String | False |
Google Analytics Campaign content. | |
| GACampaign | String | False |
Google Analytics Campaign ID. | |
| SalesforceId | String | True |
ID of the Salesforce object representing this object. | |
| TrackedUrl | String | True |
Fully qualified tracked URL. Does not include Vanity URL. | |
| BitlyIsPersonalized | String | True |
True if a custom Bitly URL was set. | |
| BitlyShortUrl | String | True |
If set, a fully qualified Bitly URL. | |
| IsDeleted | Boolean | True |
True if the object is in the Pardot recycle bin. | |
| CreatedAt | Datetime | True |
The object creation timestamp. | |
| UpdatedAt | Datetime | True |
The timestamp of the last update of the object. | |
| CreatedById | Int64 | True |
ID of the individual who created this object. | |
| UpdatedById | Int64 | True |
ID of the individual who last updated this object. |