I'm putting together a service which will combine data from a couple of different sources, one of these being campaign monitor. I've managed to create the standard unopened / unique opened / bounces chart pretty easily. It's the line graph I'm struggling with. On CM reports clicks and opens are grouped and totalled by hour, but the API outputs the raw click data. Has anyone found a way of reproducing the chart?
You would like to somehow group the data sent from CM by hour, is that correct? If so, what language are you using to do this and I may be able to offer some assistance.