Oracle-based Marketing Reporting System

Customer

The customer is a California based company that combines your website and marketing campaigns to give you a coherent 360 degree view of all your customers’, prospects’ and partners’ activities. By understanding your customer’s interactions, it routes only valuable, qualified leads into your Sales system. The client makes it simple to plan, execute and analyze marketing campaigns, allowing you to tie your Marketing investments to revenue generation.

Business Case

The Reports project will allow the customer to begin to demonstrate the value of the integrated marketing suite.
The key objectives in the project are as follows:
To provide customers with a set of reports on their dashboard
To allow customers to run these reports daily, weekly, monthly, quarterly, or custom date ranges
To allow customers to save reports to a personal dashboard and email them to multiple addresses.

Solution

SolovatSoft developed an innovative reporting solution that accurately analyzed and displayed customer's campaign statistics. We were faced with challenges of counting traffic even when the tracking code wasn't functional, recording and separating IP addresses into internal, partner or other, and breaking down each report by employee, partner, and customer traffic numbers.

Types of available reports include:
Site Traffic Reports
Page Navigation Reports
Web Traffic Optimization Reports
Demographics Reports
Visitor and Company Profiles
Technology Reports
Campaign Specigic Reports

Features

The application contains the following features:
Google Analytics style reports that demonstrated value of the client’s system
Email delivery of reports
Report customization
Improved performance of existing reports
Permissions functionality
Traffic and Usage Analysis
IP Address Analysis
PDF Conversion Functionality

Tools and Technologies

Linux, XML, Oracle 9i, SOAP