Campaign
Provides campaign information tied to form submissions.
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 FormSubmission.Campaign;
Columns
| Name | Type | References | SupportedOperators | Description |
| eloquaCampaignId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the campaign within Eloqua, used for tracking and reporting. | |
| actualCost | Decimal | The actual cost incurred for running the campaign, representing real spend compared to planned budget. | ||
| adCampaignId | String | Identifier for the related advertising campaign, used to connect Eloqua data with external ad platforms. | ||
| budgetedCost | Decimal | The planned or allocated budget amount for the campaign. | ||
| campaignClassification | String | Category or classification of the campaign, such as Product Launch, Event, or Nurture Program. | ||
| 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 providing context about 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 status of the campaign, such as Draft, Active, or Completed. | |
| campaignType | String | =,<>,>,<,>=,<=,IN,NOT IN | Type of campaign, 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 from 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 attribution alignment. | ||
| user_userID | Int |
User.userID | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the campaign record to the Eloqua user responsible for managing it. |