Dirty Data? 5 Questions to Determine if Your Incentive Promotion Data is Clean

Data powers incentive promotions. A channel incentives and program management (CIPM) solution can help streamline accuracy and efficiency of the channel; however, challenges tend to arise if your data inputs aren’t standardized and clean.
The Benefits of Clean Data
Complete and clean data enables smooth program automation and workflows – such as safe validation of claims, simple auditory compliance, quick creation of micro target audiences, reward payouts, communications, participant registration, and more.
With the efficiency created by the program doing the heavy lifting, it affords program Admins greater time to apply their channel expertise to more strategic and valuable work.
WorkStride incentive programs share three key common benefits to clean data:

Be in the promotional driver’s seat. Simply incorporate complex inputs and calculation rules on one or many promotions to better suit your specific audiences. Create specific program requirements or enable your own specific trainings, to that particularly underperforming Western region, to keep the ecosystem productive and engaged. Choose the strategies that best suit the audience, such as promotion type—for example, unit SPIFFs, Loyalty Rebates, and Top Seller contests—as well as reward options like Visas, Direct Deposit, and a Rewards Mall.
Reduce fraud and errors. Due to the reduction of the human element, a software-driven solution will have a smaller margin of error than self or manual reporting. This helps ensure claims are valid, user registrations are authorized, and reward payouts are accurate. Gain control to setup your processes to ensure that claims are being paid out fraud free, with compliant auditory trails.
Realize the true potential of your reports. See standard reports like your promotion summary, user, or sales submission report, along with other standard or custom ones to broaden your promotional point-of-view. Avoid tooling around with exports from CRM or ERP systems to see how your program is performing.

Is Your Data Clean?
These benefits of an efficient and streamlined program start with ensuring that data feeding into the program is clean and reliable.
Your channel data can include product SKUs, sales data, user and partner attributes, along with other historical program data. As an accessory to raw program data, also important is the math element, including promotional logic, registration requirements, and other specific program rules. These criteria flow through and interact with program data inputs – all building the data plant which powers your promotions. The program data is the fuel source (like wind, oil, natural gas, etc. is for electrical plants) for incentive promotions.
Before unleashing the power, ask yourself:

Where is all your data coming from?In which location(s) does the data that will feed the program rest? It could be in a centralized system, dispersed amongst separate partner systems, across numerous files, not generated yet (in the case of a brand new program), or a multitude of other locations.
In what condition is your data?Is your data dirty? Is it organized enough to be processed for fulfillment or ingested into a channel incentive program? Is it free of blank cells, duplicates, extra spaces, non-standard or inconsistent formatting, etc.?
How will the data get into your program?Through what medium(s) will your data get from its current restful state to its platform to use in your promotions. Examples include file exports, transfers, system integration (or even multiple integrations).
How will the data interact?When you blend your data with product, sales, promotion, and other inputs, how are you ensuring the pieces all come together to tell the story of who sold what, when, where, and how much to ensure program longevity?
What specific inputs (behaviors) deserve a reward?Once your data is live and producing outputs, configure your program logic to payout your intended user behaviors that will earn the greatest return for your program. Consider percentage rebates to partner loyalists as a “thank you,” or motivating SPIFFs to brand new partners to get them participating.

Is Excel Reporting A Wise Choice?

That depends on where the data comes from.
I recently saw a comment by Randall Bolten to a Proformative webinar on Excel based reporting. Mr. Randall is author of the book “Painting with Numbers” which the author describes as “Presenting Financials and Other Numbers so People will Understand You.”
Seeing and understanding data is the outcome of effective communication of financial results to company management and users of financial statements (banks, investors, shareholders, etc.). These financial results can represent management reports of past performance, budget and forecast data, financial statements, the organization’s financial strategic and operational plan and more.
Microsoft Excel is the most widely used software application in the workplace. You would be hard pressed to find a single person using a computer at work without at least occasionally opening an Excel workbook and using it for a variety of applications. In accounting and finance, Excel is used daily and can be found open on the computer desktop for as long as the user is logged in.
Financial reporting with Excel makes perfect sense as long as the user fully understands the benefits and limitations, and especially the pitfalls and risks involved, as we are about to discover here.
It still amazes me to see how companies, even large ones, depend on Excel for consolidations and compilations of financial statements, despite the fact that their ERP software or accounting applications are usually perfectly capable of producing such statements with the proper setup.
The main risk in using a spreadsheet in the preparation of corporate financial statements arises from the use of home-grown spreadsheets with user-defined formulas, functions, macros, and links, all of which can include errors and omissions, can be easily overwritten or manipulated, erased or lost. To that add the typical lack of periodic review of these spreadsheets for accuracy and completeness, and the risk for material errors in the financial statements increases considerably.
The same is true for corporate budget preparation and periodic re-forecasting done in Excel. This is still common practice in many organizations and even well known, dedicated database based planning and budgeting solutions use a “spreadsheet like” approach having some of the pitfalls listed above, reasoning that users are already familiar with the Excel interface and use of its formulas, functions, and links.
As we have seen in several of the blog entries on this site, this is a very dangerous and undesirable practice: Are You Still Consolidating Financial Statements in a Spreadsheet? and Forecasting a Balance Sheet in a Spreadsheet World.
There is, however, a set of compelling reasons why Excel can (and under the right conditions should) be used for presentations of financial results and other reporting. The principal example is when the financial data that needs to be communicated to users of these reports originates in a much more robust environment and is directly linked to the data source.
In the case of planning and budgeting applications, if Excel is only used for graphic and tabular presentation of data, without any significant formulas, functions, worksheet links and other user programming, there is a compelling reason to use this tool, for its rich set of formatting and graphical presentation options, and the robust and consistent data links established between the data source (e.g., Planning and Budgeting Software) and Excel.
A good example of using Excel to create presentation quality reports and analysis is Analytics Maestro from Centage Corporation. I have covered this application earlier in this blog: Accounting and Business Data Come to Life. This is a perfect situation where Excel does not directly participate in the creation of data through use of formulas, functions or any other programming. It merely is the recipient of data from Budget Maestro where all current and historical accounting data plus all budget versions reside. Through a seamless interface with Excel, raw data is completely and accurately transferred where Analytics Maestro Excel add-in takes over and displays it in the chosen format and includes the exact content needed for the particular presentation.
An application such as Analytics Maestro considerably reduces the risk of introducing material errors in reports. All presentation reports are as accurate as the raw data received from the actual accounting or ERP software and the data from the planning and budgeting solution. Since a link is directly established between these applications, there is no manual data entry required or any user interaction, hence the accuracy, completeness, and error-free data transferred into Analytics Maestro.
Finally, changes to the source data (e.g., revision of budget data) will automatically update the information displayed in Analytics Maestro. Here again, no formulas, functions or links ever need to be created or updated in Excel. You get the outstanding display features of Excel with no risk to the integrity or accuracy of the reported information.
With this level of formatting and presentation capability, reporting and analysis with Excel becomes a sensible choice for users in many areas of the enterprise. Conversely, any use of Excel for planning and budget modeling or preparation of consolidated financial statements remains a risky endeavor and should be avoided.