For flexible reporting among multiple related data sources, long format is best. Several long tables with indexes/keys that tie them together for joining (normalized) are better than a single wide table with the same info. When I prep data for reporting on these blogs (WordPress data) or our communities data, I have build a collection of related tables that make it easier to slice/dice/visualize different aspects of the same system.