I need to create an end of year report of all the digital campaigns - SEM, banners, PPC, etc. What do you recommend is the best format for the report and best data reporting/visualization tools to create such report?

Banner and PPC are best way to get popularity but it depends on budget :)

Oh I know, thanks, but what is the best way to organize the data and consolidate the insights?

Oh I know, thanks, but what is the best way to organize the data and consolidate the insights?

If you know how to work good 'ol Excel, you can really get jiggy with how you organize and display the data. Could even use graphs and charts.

Well thank you - yes, I have been playing around with my excel and new cool graphing features on MS Office 2007