MarketingActivities
Contains marketing activity data across multiple Eloqua campaigns and channels.
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.MarketingActivities;
Columns
| Name | Type | References | SupportedOperators | Description |
| eloquaCampaignId [KEY] | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Identifier linking the marketing activity metrics to the related Eloqua campaign. |
| campaignMembers | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of members associated with the campaign during the recorded period. | |
| dateHourKey | Datetime | Date and time, rounded to the hour, when the marketing activity metrics were recorded. | ||
| totalInboundActivities | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of inbound activities, such as form submissions, content downloads, or landing page visits. | |
| totalOutboundActivities | Int | =,<>,>,<,>=,<=,IN,NOT IN | Total number of outbound activities, such as email sends, campaign pushes, or ad deliveries. | |
| campaign_eloquaCampaignId | Int |
Campaign.eloquaCampaignId | =,<>,>,<,>=,<=,IN,NOT IN | Foreign key linking the marketing activity record to the related campaign record. |