groggy

Don´t know if the title really explains what I want to accomplish but I hope the following will explain a little bit better. In our ad sale system we have simple "impression stock" to give our sales team an indication how much impressions that is available on each zone and day. But I have to get this somehow from Revive. Can someone give me point in the right direction where to start? Is there any PlugIn that already do this calculation? Any tips in what tables and rows I should start looking for useful data is appreciated. My plan is to run a SQL-query once a day and import that information in to the sale-system, so we´re not talking about systems that are constantly in sync.