LeadActivities
Shows campaign lead activity, tracking responses and interactions over time.
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.LeadActivities;
Columns
| Name | Type | References | SupportedOperators | Description |
| eloquaCampaignId [KEY] | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the lead activity metrics to the related Eloqua campaign. |
| leadResponseDateHour [KEY] | Datetime | =,<>,>,<,>=,<=,IN,NOT IN | Date and time, rounded to the hour, when the lead response activity was recorded. | |
| newContacts | Int | =,<>,>,<,>=,<=,IN,NOT IN | Number of new contacts created as a result of the campaign during the recorded period. | |
| newLeads | Int | =,<>,>,<,>=,<=,IN,NOT IN | Number of new leads generated from the campaign during the recorded period. | |
| totalResponses | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of responses captured from the campaign, including leads and other tracked actions. | |
| campaign_eloquaCampaignId | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the lead activity record to the related campaign record. |