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.

In a simple operation, Nextanalytics creates a crosstab with the campaign types by the status reason.  To understand more about just how powerful this simple operation is, click here.

In this example, we add a couple of pie charts using the Google Charts API, which doesn't require any additional software to be installed. With these simple steps, we have our campaign results dashboard.

Since we have all the information to calculate the historical win/loss ratio, it is a simple matter to use this along with the new lead count to generate a forecast.

Note that we can apply 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%.