Censcia

Data Audit Data Discovery Database Marketing Data Marts SQL Support

Data Audit

The purpose of a Data Audit is to develop an understanding of the content, usability and scope of data that is available for use in managing customer relationships. The audit identifies how many customers or prospects are available for marketing activities by evaluating permission data, previous marketing activity, validity of mail and email addresses, and recency of customer contact. It gives marketing personnel a definitive view of the entire corporate data assets by bringing together data from various systems. The data audit identifies both data that is present and gaps that need to be filled. The result is a roadmap that will allow marketing personnel to develop a data strategy that will functionally support their marketing efforts.

Similar to a financial audit, Censcia provides an independent view of a corporation’s data assets. We have encountered numerous marketing groups who are simply unable to break through the complication of internal IT systems to truly understand what is available and what is useful. Our approach is a non-confrontational effort to bring together the different data sources and get a complete picture of what is available – from a marketing perspective. We require no IT involvement other than to provide access to the database systems or file extracts from the various systems. We do the rest.

Data Marts

Censcia has the experience to design and build optimal database layouts to support marketing efforts. We can architect, design, and build your Data Mart solution. From specifying the various data feeds and building the most efficient structures for data selections and segmentation to setting up feedback process for campaign management, Censcia applies its best practices approach. We have the experience to design flexibility into your Data Mart to allow for future growth and change. Supported by powerful Dell servers and over 2 terabytes of available disk space, Censcia provides the technical know-how to fully support and host marketing operations.

Data Discovery
Sessions

Censcia has a unique capability that we have tried with several clients. It is the ability to conduct data discovery sessions. These are sessions where Censcia has loaded data from various sources within a company and then sits side-by-side with experienced marketing personnel or company executives to find answers to any questions they have in real-time. Queries are run, results are displayed, further questions are raised, and we continue to drill down into the data in a matter of seconds. Censcia provides the technical capabilities and the client provides the questions. These sessions are very effective only if the client personnel have specific goals/needs in mind and have a broad understanding of the data that drives the business. For this reason, it may be beneficial to have business users from key areas of the company all involved.

We have also conducted these Data Discovery Sessions with advertising/marketing agencies using their client’s data. Our technical capabilities form a successful partnership with these types of companies.

Database
Marketing

Censcia has extensive experience providing various database marketing solutions. We can assist clients in developing database marketing strategies or simply assist executing those strategies. We have experience in developing RFM (Recency, Frequency, Monetary) segments, RFMP (Recency, Frequency, Monetary, Product) segments, LTV (Lifetime Value) scoring and segmentation, and responder profiling. We have helped clients design and build loyalty programs, profile existing customers to identify optimal target marketing initiatives select and attain prospect lists, and build prospect databases. We can take the lead on these activities or supplement your current staff if you are resource constrained.

SQL Support

Censcia provides technical personnel experienced with SQL and data modeling tools such as Erwin for staff supplementation. We have experience with SQL Server and Oracle databases (as well as Microsoft Access). We can assist in efforts to cleanse and move data; summarize data for reporting and analysis; and any other data related needs you may have.