How do you organize Conversion reporting across 10 sites?

[nsauser]

I have 10 sites that I manage and I need to have an efficient way of reporting Conversions. I'm currently dealing with about 300 per month.

I typically print these out for the owner of the company and will keep them digitally, the question I have is what's better, organizing by month or organizing by site?

I think the best way is to go with each site in a spreadsheet and each tab will be a month. I can't seem to think of a better way to easily access the data.

Any ideas?

[KaneJamison]

I keep track of these in a different spreadsheet for each client, with months as tabs or separate rows. Makes more sense to me than adding and deleting lots of sections every time you add or lose a client. This is the same way you described it in your third paragraph I believe.

There aren't any places within our internal file system that I mix up different clients' data - they all have their own files within each client's folder. What a disaster if you accidentally included other client's data in a monthly report...

[nsauser]

Yea, luckily I'm in-house and there's no worry of mixing up the data. Gosh would that be embarrassing!

Yea I figure one spreadsheet per site and inside, one month per tab.

[KaneJamison]

The upside about being in-house in a situation like this is you can customize much more. When doing client work you need to have a fairly standardized format to stay sane, but yours can be entirely tailored to your needs.

Also, for stuff tracked on a monthly tab, I often find a way to do a End of Year tab that summarizes data and includes years past as a summary, and then create a new version of the spreadsheet each year, so that it doesn't get unwieldy after a year or two. I know that's a complicated suggestion, but the implementation will really depend on what data matters most for Year over Year comparisons versus just month over month.