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. |