The speed of the reports is significantly influenced by four things: Selected columns, filters, grouping and selected time period.
columns
The more columns are selected, the longer requires the report to generate. Longest Reports need with the column requests and RTB requests; the second longest required reports with the column view. All other columns take about the same length. Depending on the application, the duration may vary: If many clicks but produced only a few views, then a report with the Clicks column is possibly slower than the report with the column view.
Here should be noted that certain columns require other columns: If, for example, revenues are spent, the ad server will also views with query, even if the views column is not displayed. Background here is that could be possibly associated costs / revenues with the views that are necessary for the calculation of turnover. Similar relationships exist eg clicks and CTR, views and CTR, clicks and sales, actions and sales etc ..
Period
The speed of the report is significantly influenced by the chosen period. is the fastest generate a report in which only selected as the period "today". Second fastest time only "yesterday" - although the difference between and "yesterday" with larger customers already is quite large "today". more time will then be taken to the more days more needed to generate the reports. Again, there is a clear difference if the period includes a date that is older than 2 months.
filter
The less advertising spaces / advertising media ultimately to choose the faster it goes. It makes no difference, however if a site is selected and no advertising space or whether a site is selected and all advertising spaces are marked. The other way around is no filtering but faster than a very broad filter with lots of choices.
grouping
must be all the more grouped the slower it gets. Fastest grouping is by date only. Then the grouping ad space / advertising material and then everyone else. Slowest grouping is by sub-IDs (referrer).