CampaignResponse
Captures campaign response metrics such as conversions, click-throughs, and response rates.
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.CampaignResponse;
Columns
| Name | Type | References | SupportedOperators | Description |
| campaignResponseID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the campaign response record within Eloqua. | |
| contactID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the contact associated with this specific campaign response. | |
| eloquaCampaignID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the response record to the related Eloqua campaign. | |
| responseDateHour | Datetime | Date and time, down to the hour, when the campaign response occurred. | ||
| totalNewLeads | Int | Number of new leads generated as a result of this campaign response. | ||
| totalResponses | Int | Total count of all responses recorded for the campaign during the specified time frame. |