Reporting Portal Development

Overview

A Fortune 5000 company was looking for a mobile solution that included event management to capture lead data in real time in order to better manage communication to any given individual through the marketing funnel, as well as to facilitate effectiveness metrics for management.

Challenge

The client was looking to capture events and leads for multiple events nationwide. They needed a fully-integrated solution for B2B companies that could handle unlimited front-end users with unlimited devices. The solution had to be built on cross-platform technology and provide scalability and flexibility as the needs of the organization grew. It should also support multi-site management to accommodate multiple users at a national level. It required a powerful and secure back-end system, providing a fully-integrated end-to-end solution with a robust reporting portal.

Result/Summary

PDS created a complete responsive user interface using .NET with a SQL backend. The reporting portal included multiple reports to track leads and events across national levels. Each report offered drill down functionality for regions, districts and individual sales and showed important metrics for measuring marketing ROI. The reports were created using a robust grid-view system that allowed each user to customize their selection. PDS also implemented a feature enabling the user to export a CSV formatted report based on their custom selection. The project has been successful from onset and is an ongoing project that PDS supports and maintains and customizes each year for the client.

Market Analysis – Automotive Supplier

“Beta” Company is a regional retailer of tires and automotive repair. Beta is a leader in the industry and sells to a diverse audience. Beta was interested in determining which markets represented the greatest opportunity for growth, so as to expand their brand.

Staff Planning System for Field Offices

This national client wanted a way for its individual store managers to plan their staff and equipment needs using their own local knowledge of seasonal trends, coupled with in-depth statistics provided at the corporate level. The client had previously handled this via the loose collection of Excel documents in various formats using data that wasn't current enough to be useful.

Marketing Event Management System

This client holds thousands of local marketing events across the country, hosted by its field offices. Raffles and giveaways are held and leads are collected. They needed a way to collect the lead data, coupled with responses to a few strategic questions, and integrate the data into a CRM effort where the leads could then be contacted by phone and email with discount offers. Client wanted real-time visibility to event activity, CRM activity, and subsequent conversion rates.

Targeted Mailing for a Non-Profit

One of the top art museum organizations in the United States was looking to expand its membership, add donors, and increase visitor attendance.

Managed Mail Solution

This client provides seniors and their families with senior living options for all stages of their lives. They have several locations in multiple states. They focus not only on their senior residents and families, but also take great pride in being an employer-of-choice for their employees.

Database Migration

Canine to Five is Metro Detroit’s finest dog daycare, boarding, and grooming facility, located in the heart of Detroit’s Historic Midtown Neighborhood. Canine to Five is a staple in Detroit culture and, through its commitment to dogs and their owners, it has grown to include a second location in Ferndale.