This example starts with a simple database query and builds a quick dashboard measuring the success of marketing campaigns. Based on the historical results, we also provide a forecast of revenue from the new leads generated.

Nextanalytics can obtain the campaign data direct from a marketing database or load it from a spreadsheet file. Here we start with a detailed report query that already existed. It may contain a number of columns we don't need, but we'll only load the ones we want into memory.

In a simple load and pivot operation, Nextanalytics creates a crosstab with the campaign types listed in the rows and the status reasons across the columns. To understand more about just how powerful this simple operation is, read more about the pivot operation.

In this implementation, a couple of pie charts were added using the Google Charts API. With these simple steps, we have the start of our campaign results dashboard.

Using the same data query, we could just as easily calculate some other interesting metrics, such as the historical win/loss ratio. Combined with the count of new leads, we could make a quick forecast as well.

This particular example makes use of Nextanalytics 'alerts' to color code the values that are above average (blue and green) or below (yellow and red). The blue and yellow indicate those values within a specified percentage factor of the average, in this case 15%.