Open & Click Rates Based on Email Frequency

[Anonymous]

We need to create a report that shows our leads response to email frequency and I am not quite show which report or combination of reports would do this or even if we can pull the data at all.

Marketo support explained that there analytics is not that complex and perhaps even a combination of Email Performance report and Email Link Performance report will not be able to give me what I want to see.

I would like to know open and click rates when leads receive 1 email from us, what it is on the second email, third email, fourth email, etc.

Does anyone have any experience creating such a report?

[Anonymous]

You can test and report on this by taking a random sample and adding to a new program. Marketo will allow you to report on multiple programs. One program could have lower frequency than the other. 

[Anonymous]

I have got part of it done -- I have created Smart Lists to divide up email recipients by week into how many emails they received.

Now -- I am looking to find out the click rate and open rate of the members of those smart lists with the emails received in that same time period.  Where can I do that? Or can I do that?   Suggestions?