PRODUCTS AND SERVICES
DATA PROCESSING AND WAREHOUSING
Successful campaigns begin with clean, accurate data. Put our decades of experience in data processing and warehousing to your advantage.
For over two decades, ADR's founder worked as a database marketing service provider for several Fortune 500 clients. This experience includes data cleansing and standardization as well as the design, build, and implementation of marketing data warehouses. With the increasing need for harnessing big data, ADR can help clients design and implement efficient warehouses that can deliver results quickly and accurately.
Examples of ADR Founder's Prior Data Warehousing Projects
A financial client needed a web-based user interface that allowed it to run ad-hoc results reports on its marketing campaigns. Using SQL Server, a backend data warehouse was constructed that fed into a BI Tool, allowing the client to have secure access to campaign results. The warehouse efficiently stored several years worth of marketing campaigns, allowing reports to run against over a hundred million records in seconds. ADR's founder led the team that designed the databases and stored procedures that accurately matched responses to campaigns and created the reporting tables.
One project involving big data required the tracking of display campaigns, web impressions, clicks, quotes and purchases for an insurance client. Via a sophisticated attribution system, all the clicks, quotes and purchases were tracked back to specific campaigns, allowing the client to optimize their display campaigns and effectively reduce their acquisition cost per policy. Over 1 billion web impressions were tracked per month.
ADR is helping a publishing client design and build an enterprise data warehouse that contains email and web campaigns, their associated opens and clicks, and the resulting product orders. Detailed customer engagement data will also be stored. This warehouse will maintain several billion records per year.