We have an email that runs daily at either 9 am, 12 pm, or 3 pm. I am trying to pull a report that will show how the email performed in 2013. I pulled an Email Performance report but it only shows the number of individuals who were delivered the email (there are 29 individuals signed up so 29 emails go out each day) but I want to see how many emails were delivered and the open rates, click rates, etc (ie: 29 x the number of days the eamil has gone out). For example: December should be 29 x 31 days. I thought an Email Performance report would show this, but it does not.
Try using Revenue Explorer. I have had much better results when using RCA to get results for a deep dive on one email campaign or program. You can start with one of the standard RCA reports and you can customize the date range. I would also add in the date sent to ensure you can sort out results by month or day. You can export the results to excel and sort further as needed.
We don't use Sales Insight -- instead we add campaign flow steps for sent, clicked, opened and filled-out-form. Then we sync our SFDC campaigns at the Marketo program level. It gives sales reps the ability to see who has opened etc emails within a campaign. It's very easy to do - would be happy to walk you through it if you're interested.
At times the only way I can get what I need, is by combining chunks of reports. That means I have to report within a week or reporting becomes a nightmare of splicing and dicing over months.
Unfortunately, without RCA, there isn't a nice, easy way to consolidate this information. How do you have the campaign set up? Is it three different campaigns or 1 campaign with wait steps? You can use smart lists to get a sense of behaviors if it is three different campaigns.
Gotcha, one idea would be to create smart lists for each campaign. You can use the "Member of Smart Campaign" filter to segment between the send times. Then, you can use the "Was sent email" and "Clicked link in email" filters and change the day to see how your numbers evolved over time per send time. VERY manual, but may shed some light on what you are trying to find.