We need a Campaign level, daily report of metrics including click through and impressions for specific timeframes (or if this is not possible, hourly) by location.
Specific time frames example
The report might well breakdown as follows:
Location Timeframe Duration Clicks through Impressions
Chicago 0000 to 0450 4h 50mins 28 45
Chicago 0450 to 0755 3h 5mins 41 61
Chicago 0756 to 2359 16h 3mins 55 163
New York ...
New York would show similar information.
The console app should have ability to request the data at any given time for any location throughout the day.
Although the example above shows only 3 timeframes for Chicago there could be more timeframes, although unlikely to exceed 10 timeframes within a day.
Hourly reporting example;
If the above is not possible and it's only possible to pull hourly data the report would be similar but the timeframes would be hourly, for example:
Location Hour Clicks through Impressions
Chicago 0100 28 45
Chicago 0200 41 61
Chicago 0300 55 163
New York 0100 60
We would like a .Net console app that will capture this data daily. How exactly this would be done needs to be worked out by whoever takes on the project.