Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Email frequency vs engagement
Hi all,
We would like to see the email frequency with engagement like below,
Number of emails sent 1, 2, 3, 4, 5, 6-10, 10+, 15+ and 20+ in a month
AND
Open rates/CTR
AND
Split that, or show the view for different BUs(campaign field).
Please let me know if this custom report is possible in insight or do we have any other workarounds?
Regards,
Saravanan
Answers
-
Hi,
if I understand you correctly then you can use bin functionality on count(emails by whatever your fields are) or filter based equivalent to solve your 20+, 15-19, 10 - 14 etc requirement
You can also use a column selector to allow users to add various optional fields, but this may make the logic of the above requirement more complex.
Alternatively you could use a view selector in place of a column selector to keep the logic for your first requirement simple.
0 -
How is the data stored? Does it support this use in it's natural form or do you need to move it and transform it to support the requirement?
What do you mean by 'IN INSIGHT"?
0 -
Hi
Eloqua BI Insight custom report i am trying to achieve the above request.
0 -
Insight as far as I'm aware is the Eloqua reporting tool which really is OBIEE 11.1.1.9. What have you tried in order to build this analysis? What does your subject area look like? Do you have access to make modifications to the repository?
0 -
@saravananv I would suggest moving your question over to Topliners. Eloqua users can help you there.
0
