Campaign
Lists campaign metadata, including campaign IDs, names, and configuration details.
Select
The driver uses the Oracle Eloqua Reporting API to access entities. To query a view, a fully qualified query consisting of both the schema name and table name is required to avoid any ambiguity.
For example, the following query specifies the schema name followed by the table name to access this view:
SELECT * FROM ActivityDetails.Campaign;
Columns
| Name | Type | References | SupportedOperators | Description |
| eloquaCampaignId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the campaign within Eloqua, used to track and report on campaign performance. | |
| actualCost | Decimal | The actual cost incurred for running the campaign, reflecting real spend versus budgeted estimates. | ||
| adCampaignId | String | Identifier for the corresponding advertising campaign, often used to link Eloqua data with external ad platforms. | ||
| budgetedCost | Decimal | The planned or allocated budget amount for the campaign, set prior to execution. | ||
| campaignClassification | String | Category or classification of the campaign, used for grouping and reporting purposes. | ||
| campaignCreatedByUserId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the user who originally created the campaign record. | |
| campaignCreatedDateTime | Datetime | Date and time when the campaign record was first created in Eloqua. | ||
| campaignDescription | String | Text description providing details about the purpose, content, or strategy of the campaign. | ||
| campaignEndDate | Datetime | Scheduled or actual end date for the campaign's activities. | ||
| campaignName | String | =,<>,>,<,>=,<=,IN,NOT IN | The display name of the campaign as defined within Eloqua. | |
| campaignProduct | String | =,<>,>,<,>=,<=,IN,NOT IN | The product or service associated with the campaign, used for marketing attribution and reporting. | |
| campaignRegion | String | =,<>,>,<,>=,<=,IN,NOT IN | Geographic region or market targeted by the campaign. | |
| campaignStartDate | Datetime | Scheduled or actual start date for the campaign's activities. | ||
| campaignStatus | String | =,<>,>,<,>=,<=,IN,NOT IN | Current lifecycle status of the campaign, such as Active, Completed, or Draft. | |
| campaignType | String | =,<>,>,<,>=,<=,IN,NOT IN | Type of campaign being run, such as Email, Event, Digital Ad, or Multi-Channel. | |
| crmCampaignId | String | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the Eloqua campaign to a corresponding campaign in an external CRM system. | |
| isDeleted | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the campaign record has been marked as deleted in Eloqua. | |
| lastActivatedByUserId | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the user who last activated the campaign for execution. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the campaign record. | ||
| referenceProduct | String | Additional product reference associated with the campaign, often used for cross-sell or reporting alignment. |