Feature Request - Email Statistics Data in RevCalc Output - Arena

Submitted by Laura Zexter / June 12 2010 We are now producing numbers in the excel output for the RevCalc (direct & indirect purchases) Although, we seem to keep going back to the Email Statistics report in Eloqua to gather the additional information on the respective Email.  Ideally, if we could get the stats in that report or a subset in the RevCalc output, it would help to be more efficient and have this application in more hands in the organization.  Or if anything, it would be better to have Unique opens instead of "Total Opens"  & email received; it would at least allow us to calculate %opened in excel…


Eloqua Insight reporting different numbers between reports

When looking at a campaign report I get a count of each metric - e.g Opens - from the same campaign totals when I run an email report and roll up the individual email totals for a campaign.  The email reports show lower performance.All the date tranges are the same - in fact I am counting everything as we have just started. Interestingly, when I click into the opens on the email report - to see the actual contacts - I noticed that the total there is different to what is being reported on the headline email report, so the metrics look like they are not being counted correctly.This seems to be confirmed as the rates (like open rate) are actually being calculated on ther larger count I see on the individual contact list! Is anyone else experiencing this? Seems very odd for teh system to be calculating such basic statisctics incorrectly and of course it causes a lot of issues with stakeholders comparing different views and receiving different numbers...
Insight is a 3rd party tool that Eloqua uses and it can take up to 24 hours for some of the data to be sent to Insight. But I'm wondering if the opens that you see when you click through on the report is sending to you an operational report which is run from Eloqua and not Insight which is why the numbers are skewed. You could always submit a ticket with support to check.
Yes its possible, though the actual open rate on the Insight report is calculating correctly from the contact level data whilst the opens is not.  Very strange.  I have been testing extensively thsi evening and have found a number of other anomolies, like numbers changing when you add in a column, but then not changing back when you remove the same column (in fact the changed number actually moves to a 3rd value!).  I think Oracle have some work to do!  I have raised a ticket. cheers

[Reporting] Email statistics based on time between emails

I had a hard time naming this discussion....since I've never been asked this question before. My team built some nurture programs for one of our marketing partners at the end of last year. A contact's path through the program and how soon they received the next email in the series was based on their activity with the email: open, clickthrough, or form submit.  She recently reached out to us and wants to know the following: "Is there any way in Eloqua to report on the open, unsubscribe and click thru rates based on duration between emails? For example, for all of emails that had a 7-day wait period between them, did the stats differ on the same emails with 3-week wait periods between the emails?" Being relatively new to Eloqua10 (we migrated in December) I'm not sure what reports are available, nor where to start.  I did some looking last night and I couldn't find anything like what she is wanting to see. Has anyone done this before?
dliloia Can you please promote this in your network? Thanks!
If you have the analyzer license, you can run the email analysis overview by selecting the required emails. Then add the send time parameter into your report. That will show you the timing of different batches. This should help you. If you want to go deeper, i think you can add the contact parameter to view the actual contacts and engagement (not 100% positive, but you can try . 
Hi Rohit Gudipudi,  I finally have had a chance to dive into this.  What do you mean by adding the send time parameter?  Where/how do I add that?
Do you have the insight analyzer license ?
I do, but I haven't had a chance to totally figure it out yet!
on the email analysis report.. select the email you need stats for... once you run the report on a selected time frame, the results will show up... to the left, you will have report objects, search for "email sent date/time".. you will find that object.. drag and drop that onto your report... that should give you the metrics for different times of the email send... 
Julia, The best way to run a multi-dimensional report like this is to export the data into Excel and build a Pivot Table. -Sam

For all contacts what campaigns they were sent in the last 12 months and did they click it?

Hi All, We'd like a report that shows for each contact (within a segment) all the campaigns have they been sent in the last 12 months and if they opened it and clicked it each campaign? We've looked through Classic Insight & BI with know obvious report that will do this. We can pull it per campaign but thats going to tak us a long time as we have over 500 campaigns going to 11,000 contacts over the year. Thanks for any help! Cheers, Chris
Hi Chris, - I don't know if this is exactly what you want, but if you look at the Email Analysis Overview by Segment report in Insight, this will show you all of your segments, and then it breaks down the sends that were sent to that particular segment, - from there you can drill down into the contacts.  I think I understand what you are after, the ability to create a segment of X people & then to see for those contacts which email sends they had been sent & which ones they had engaged with. - This would be quite a tricky report to display because as you mentioned, you have 500 campaigns, - so in order to adequately display the results there needs to be 500 columns to indicate true / false (if they were sent) and another 500 true / false columns to indicate engagement. - you would need to display all of the campaigns otherwise you might not return all of the campaigns involved with the contacts.   
As Andy already mentioned, It would indeed be a complex report. Since you can't show/unshow per contact which campaign they were present in, it would be a report of at least 1000 columns.Because the reports are table based, you can't just say that contact A was in Campaign X,Y and Z. It will display that contact A was in Campaign X,Y and Z AND it wasn't in Campaign A,B,C,D etc. etc. Also the additional columns would display engagement. I'm wondering if that kind of report would really give you insight? What information are you looking for? Focused on the Contact Engagement or focused on the Campaign Engagement?
Thanks Tom and Andy, basically we want to deep dive on all 11,000 contacts for each campaign (actually about a 100 not 500) looking at engagement did they open it and did they click it so the left Y axis of the table would start with all the 11000 contacts and then the X axis would have each of the campaigns on it (100) with an indication of open and click. I can appreciate this is going to be a meaty spreadsheet, perhaps the API can pull this data too and we'll analyse it in PHP but perhaps we should be lead scoring really? As an aside Eloqua is a little ambiguous when you look to filter/segment on 'Open' engagement, its based on total opens not unique (I think) as you can say opened at least 4 emails in the last 3 months for example, but that could be 3 opens of 1 campaign and 1 of a different campaign, we'd like a uniquely opened 4 different emails in a given time period, is that possible? Thanks again for your time! Cheers, Chris
You can do this in Insights under New > Analysis > Campaign analysis then pull the campaign name in, the contacts details, emails opened and emails clicked.You may need to filter the data to avoid getting the 'too many results' output.In the results, add a pivot table and include the campaign name in the columns and the contact details in the rows.That should give you a view per contact of their campaign results.
Hi John, Thank you so much for this, its looks like just what we need, a custom reporting tool available to us within Eloqua.  Ive checked our instance though and I can't find the area you are refiering to, from within Eloquan Ive gone to Insight off the Analytics dropdown: Then the nearest i 'Think' I can get to is this page:  Im not sure we have access in our instance to what you have. Thanks again, Chris
Insight was previously in controlled availability, but you now need to create an SR with support to request access - https://docs.oracle.com/cloud/latest/marketingcs_gs/OMCAA/index.html#CSHID=OracleBI  You also need an Analyzer reporting license to be able to create and edit the reports, so it could be worth asking that in the SR too.
Thanks again John, we have Insight but not Analyzer, Ive asked the client to add it to their instance. Cheers, Chris
We have Analyzer now, we'll take a look, thanks again. Cheers, Chris
Great, we can do what we need to do, seems like Analyser is a great custom report building tool.  Lets see how well it performs! Thanks again all, Chris

Average Sent to Click Time

Hello Topliners Power Users, How many of you have asked yourself, or had stakeholders ask, "how long does it take our audience to click on an email?" I've heard many marketers make statements regarding the time it takes for recipients to click an email once it has been delivered. I'd love to get a metric to validate some assumptions, and help with evaluation times on the canvas. Is there a way to report this in analyzer, or a report which I can modify to produce high level results? I'd rather not pull clickthroughs for a single email and do comparison in excel, as I want this to include a high volume of emails. I am thinking something like average delivered to click time. Let me know your thoughts!
Hi if you have access to Insights through OBI, you can use the New > Analysis and choose the Email Clickthrough subject area. Pick in the email fields you want to see plus Unique Clickthroughs and an extra field.Click on the extra fields cog and select edit formula. You can create a name for the field by clicking the radio button and adding a name.Then use this TIMESTAMPDIFF formula to find the number of minutes from Send to Click.TIMESTAMPDIFF(SQL_TSI_MINUTE,"Email Send Date Attribute"."Email Send Date", "Email Clickthrough Attributes"."Email Clickthrough Date") If you want to use SECOND, HOUR, DAY, WEEK, MONTH instead of minute they all work too. Things to remember when reporting this, you cannot see the number of emails sent/delivered in this subject area so its not the full picture.Also, emails sent on Fridays are often opened on Mondays which can skew your stats dramatically and ruin any insight from averages.OBI is great, its so simple to make the data interesting! Good luck.
This site is great as a reference point for Calendar Date/Time functions.

Email Stats Calculation

I’m compiling open rates and click-through stats for emails I have sent and was wondering if you could shed some light on the stats.   For example, I’m noticing that all of our click through rates are small (all hovering around 1% for newsletters, targeted emails, etc.).  Do you know how Eloqua defines click through rate?  I would assume that it takes the number of clicks  and compares that rate to the number of emails opened.  However, I couldn’t find the definition on their site. Also, could you shed more light on the “click to open ratio?”   Is that a better measure of click throughs?  
Hi Robert,Click-through Rate (CTR) is calculated as the number of click-throughs over the number of emails delivered. Click-to-Open Rate (CTOR) is calculated as the number of click-throughs over the number of opens. If you are looking at these metrics for an individual email batch, they will represent uniques. In otherwords, if I click 5 times in that email, I still count as 1 click-through. If you are looking at aggregrate email metrics (totalled across multiple email batches), the metrics may not represent uniques, as one individual may have received more than one of those emails. CTOR reflects how well your email performed beyond the open. It speaks to how well the email message/content, offer, email layout resonated with the recipients. It does share some of the same weaknesses as Open Rate, as opens can be under-reported due to images being blocked or not available (e.g. plain text), but it can be very revealing in that it provides another level of insight into the "funnel" of email engagement steps (Sent>Delivered>Opened>Clicked>Response). As with any metric you use, you'll want to see the trend over time -- benchmark against yourself. If you'd like to compare your numbers to other similar businesses, I suggest you check out the bi-annual Eloqua Benchmark Report. In the latest edition, page 11 shows email metric benchmarks (including both CTR and CTOR) by industry. Gaea
Hey Gaea, is that benchmark report kept up to date? Right now http://www.eloqua.com/benchmark/ points to the April 2011 version of the PDF.
Hi Gaea, for the Open Rates, does Eloqua count "implied opens" on text version emails (since pixel image used to track opens wouldn't work on text emails, would Eloqua count clicks registered as an open)? Or else, does that mean the Opens stats are all skewed because it doesn't account for who opened the text version?
Hi Robin,Emails received as plain text that are opened will not be counted in the open rate. As you note, if that hidden image isn't viewed, the open can't be counted. I would suggest that Open Rate is still a valuable metric, but best taken in context of trends over time and overall email funnel engagement. Gaea
Hi Mark,The Benchmark data presented in that format has been replaced by two other tools: Chart of the Week and the Benchmark Dashboard report in Insight. We've noted that the metrics haven't actually varied that much in the last year, see Eloqua's Chart of the Week: Which Industries are Adapting to Email Changes?, and information in the PDF is therefore still a good guidepost. If you haven't already, I definitely suggest subscribing to the Chart of the Week, there are some great, actionable nuggets in those posts! Gaea
When we look at open rates, it's already assumed that we and everyone else isn't capturing text based emails received. Therefore all of our metrics are based on the HTML versions anyhow, so it's more about the relative rates as opposed to assuming this is a specific number. Also, we rely more heavily on click through rates instead of open rates. Click through DOES capture those people that opened it in a text version so you get the complete picture that way.