CX - Campaign Activity Detail Analysis
Description
This subject area provides details of all the Campaign activities for a Contact and Campaign Asset by Activity Date (data sourced from Eloqua).
Business Questions
This subject area can answer the following business questions:
-
For a given time period, what were the Email Opens or Unsubscribed for a given Account?
-
For our key Customer contact, how many Campaigns were targeted at them?
-
For our key Customers, how many Campaigns were targeted at them?
-
Of the Emails that were sent, what percentage were opened on the same day (within 24 hours)?
-
What Asset type performed the best in gaining the most number of responses in a given time period?
-
Which Account has the most number of inbound activity (what is our most active customer)?
Job Roles
The following job roles secure access to this subject area:
Duty Roles
The following duty roles secure access to this subject area:
Primary Navigation
Eloqua > Campaign
Time Reporting
This subject area supports historic analysis/time-based reporting of Campaign based on Campaign Start Date, Campaign End Date and Campaign Activity Date.
Time dimension is linked to There are multiple role-playing time dimensions that are anchored to the following dates: 1. Campaign Start Date 2. Campaign End Date 3. Campaign Activity Date.
Transactional Grain
This subject area returns data at the grain of the Campaign Contact Asset Activity level.
Special Considerations
None.