Data Audit and Cleansing

Green Beacon Solutions will work with you to discover, analyze, and assess your data to identify quality problems and business rule violations. This assessment follows a predefined project scope, which includes the types of data audited, the amount of data audited, and the time attributed to the analysis. Our methodology provides a data quality assessment process, that includes comprising business rules, analysis, measurements, history, and reports about a particular source, and is repeatable for future use. Elements of a complete assessment process include the following integrity checks:

• Data Profile - the quality and quantity level of the data
• Column Analysis - the validity of the data
• Referential Integrity - the integrity of the data
• Business Rules Compliance - the consistency of the data

During the data audit, Green Beacon suggests third-party tools to evaluate street address quality and even the level of redundancy of records found in the data set.
Within the findings of this assessment process, you will view examples of specific data defects and the impact of those defects on your organization's day-to-day business. Green Beacon will present reports of domain measurements and analysis tests, make recommendations for process improvements, and offer suggestions regarding how to cleanse existing data elements.

Before you load your data into a centralized database solution, it's critical to ensure your data is normalized, standardized, matched, and consolidated as accurately as possible.

Green Beacon's Data Cleansing Service relies on our consultants' years of industry experience in implementing the best data quality practices available. Green Beacon consultants use their expertise to efficiently and effectively process your data while regularly providing results that exceed client expectations. They then customize the following general process to meet your business needs:

• Review audit results and data requirements
• Define/refine business rules
• Create repeatable business rules
• Process data and evaluate reports/output
• Validate results
• Make adjustments (if necessary) and finalize output 

Data Analysis and Campaign Management

Data analysis helps your marketing team improve their understanding of customer behavior. In turn, this better understanding allows them to target marketing campaigns more accurately and to align campaigns more closely with the needs, wants, and attitudes of customers and prospects.

If the necessary information exists in a database, the data analysis process can identify and profile virtually any customer behavior or characteristic. Through our Data Analysis and Campaign Management service, Green Beacon will work with your team using the latest in data visualization techniques and tools to create accurate data sets for your campaigns. The result is an integrated solution between your data and your CRM solution.

Green Beacon partners with smartFOCUS to bring clients the best-of-breed marketing application available in today's marketplace.

Partnering with smartFOCUS

The smartMARKETER solution focuses on marketers and makes the following modules available to address the critical components of their jobs as follows (see the attached for details):

• Data exploration & analysis
  o RFM
  o Scoring
  o Segmentation
• Campaign Management
• Results Reporting
• Modeling

We are convinced that marketers have two major problems, just about across the board:

1. Data is not clean and not well-organized for easy access - as a result the answers Marketers get from the data is often suspect at best.

2. There are very few tools in the marketplace that act- the way marketers act; give me an answer ¦but here's another question based on that answer-

Green Beacon takes care of the data problem (as described above). And the smartMARKETER solution- that is installed and configured to your needs by Green Beacon - solves the second problem. Its data visualization tool allows marketers to slice and dice the data in any way they want, and provides views into the data that no other tools on the market can give you - from Excel format to Venn diagrams.