outbound datafeeds: export hard to get data to warehouse

For performance and to make reporting easier, we should export the data that we need to run very complicated queries for to the warehouse.

This data includes (probably not limited to)

• AdMax nominal budget

• AdMax carryover

We should export the lowest level of data (probably searchEngineAccount) to new warehouse tables that are designed for easy (and fast) querying using select statements so we can simplify the select statements in the datafeeds, and generate datafeeds much faster.

Example queries:

select sum(nominalBudget), sum(carryover) from admaxDataExport where startTime='2011-11-01' group by accountID;

select sum(nominalBudget), sum(carryover) from admaxDataExport where startTime > '2011-11-01' group by accountID, startTime

Exporting would need to be done every time AdMaxSummarizer is run.