Campaign
Lists campaigns along with performance metrics and configuration attributes.
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 CampaignAnalysis.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 | =,<>,>,<,>=,<=,IN,NOT IN | The actual cost incurred for running the campaign, representing real spend versus planned budget. | |
| adCampaignId | String | Identifier for the associated advertising campaign, often used to connect Eloqua data with external ad platforms. | ||
| budgetedCost | Decimal | =,<>,>,<,>=,<=,IN,NOT IN | The budgeted or planned cost for the campaign prior to execution. | |
| campaignClassification | String | Category or classification of the campaign, such as Product Launch, Event, or Nurture. | ||
| campaignCreatedByUserId | Int |
User.userID | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the user who originally created the campaign record. |
| campaignCreatedDateTime | Datetime | Date and time when the campaign record was created in Eloqua. | ||
| campaignDescription | String | Text description summarizing the campaign's purpose, strategy, or objectives. | ||
| 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 attribution and reporting. | |
| campaignRegion | String | =,<>,>,<,>=,<=,IN,NOT IN | The 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 Draft, Active, or Completed. | |
| 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 related campaign in an external CRM system. | |
| isDeleted | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the campaign record has been 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 associated with the campaign, often used for cross-sell or reporting alignment. | ||
| marketingActivity_eloquaCampaignId | Int |
MarketingActivities.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking this campaign to its related marketing activity record in Eloqua. |
| user_userID | Int |
User.userID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking this campaign to the Eloqua user record responsible for it. |