SSIS Components for Oracle Eloqua

Build 24.0.8963

Activity_CampaignMembership

Retrieve Campaign Membership Activities.

Table Specific Information

This table is the only activity table not available in the Bulk API.

Select

ContactId is required to query Activity tables.

Columns

Name Type Description
ID [KEY] Long The unique identifier of the campaign membership activity.
Name String The name of the campaign membership activity.
CreatedAt Datetime The date and time the campaign membership activity was created.
Type String The type of campaign membership activity.
AssetId Long The Id of the asset associated with the campaign membership activity.
AssetType String The type of the asset associated with the campaign membership activity.
AssetName String The name of the asset associated with the email campaign membership activity.
ContactId Long The Id of the contact who performed the campaign membership activity.
Responded String Whether the campaign membership activity has been responded to.
CampaignName String The campaign name of the campaign membership activity.
LeadStage String The lead stage of the campaign membership activity.
CampaignId Long The campaignId of the campaign membership activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ExportToken String The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth String The depth of information requested from Eloqua.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963