Wireless Phone Provider
The opportunity was for MaximumAd to take the existing reporting and systems from a descriptive post transaction format from multiple systems and create diagnostic analytics to highlight which systems accounted for the best accuracy.
A leading wireless phone provider had disparate systems that communicated and populated their reverse logistics data with inaccurate, unverifiable, and unreliable data feeds. Similar reports were available among the various systems but they were all describing a different story and the bottom line was being affected with the inaccurate reporting and loss of approximately $280,000 per month or roughly $3.5MM in returned inventory.
The opportunity was for MaximumAd to take the existing reporting and systems from a descriptive post transaction format from multiple systems and create diagnostic analytics to highlight which systems accounted for the best accuracy.
Through mapping and analysis of the existing retail inventory system, the logistics management system, and financial accounting systems, we uncovered several sourcing errors in all three systems and produced diagnostic analytical reports to magnify such errors and be used as a management tool in the future to proactively look for impending errors and be able to prescribe where changes need to be made for data correction.
Phase1 of this project resulted in the proper classification and identification of missing inventory by 83%. Phase2 was focusing on the remaining 17% unaccounted devices. Phase2 completion saw the closure rate to within just 3% of all inventory due to the use of diagnostic, predictive, and prescriptive reports.
The opportunity was for MaximumAd to take the existing reporting and systems from a descriptive post transaction format from multiple systems and create diagnostic analytics to highlight which systems accounted for the best accuracy.
Through mapping and analysis of the existing retail inventory system, the logistics management system, and financial accounting systems, we uncovered several sourcing errors in all three systems and produced diagnostic analytical reports to magnify such errors and be used as a management tool in the future to proactively look for impending errors and be able to prescribe where changes need to be made for data correction.
Phase1 of this project resulted in the proper classification and identification of missing inventory by 83%. Phase2 was focusing on the remaining 17% unaccounted devices. Phase2 completion saw the closure rate to within just 3% of all inventory due to the use of diagnostic, predictive, and prescriptive reports.
Soft Drink Company
MaximumAD took a holistic approach and first flattened all the data from 28 different sources and identified that the initial report of 82% compliance was actually 73% due to skew and bias.
The leading soft drink company launched a campaign to identify the saturation of their products nationwide between three different retailers, approximately 12,000 locations, based on information provided to them from 28 different independent bottlers and marketers. They wanted to know the utilization of the branded beverage display buckets in stores and the percentage of occupancy of their products. The customer then contracted many third party commodity services to collect a set of data points to describe the data at hand. Their result was 82% of branded distribution systems were populated with their product.
The next question was why. Enter MaximumAD.
The set of objectives, and criteria did not tell a story without comprehensive diagnostic data, they knew what, but not why, or how to correct. MaximumAD took a holistic approach and first flattened all the data from 28 different sources and identified that the initial report of 82% compliance was actually 73% due to skew and bias. This showed a near 15% inaccuracy of descriptive reporting.
After analysis and proprietary algorithms, MaximumAd was able to identify 9% of those discrepancies representing actionable data with respect to other factors, “The Secret Sauce”. At the end of the day, the customer took action on 40% of the remaining non-compliance which represented daily sales loss of $6.78 per location per day (4 sodas), or visualized as $81,360 for just three retailers, per day. Lets take that per year, the identification of $30MM in lost sales.
Where are you looking at your data?
The next question was why. Enter MaximumAD.
The set of objectives, and criteria did not tell a story without comprehensive diagnostic data, they knew what, but not why, or how to correct. MaximumAD took a holistic approach and first flattened all the data from 28 different sources and identified that the initial report of 82% compliance was actually 73% due to skew and bias. This showed a near 15% inaccuracy of descriptive reporting.
After analysis and proprietary algorithms, MaximumAd was able to identify 9% of those discrepancies representing actionable data with respect to other factors, “The Secret Sauce”. At the end of the day, the customer took action on 40% of the remaining non-compliance which represented daily sales loss of $6.78 per location per day (4 sodas), or visualized as $81,360 for just three retailers, per day. Lets take that per year, the identification of $30MM in lost sales.
Where are you looking at your data?
Research Consulting Firm
MaximumAD developed a research platform online, hosted the database, and provided valuable insight via descriptive reporting via PowerBI dashboards and reports.
A premier research consulting firm regularly conducts surveys of the students at universities and their alumni. These higher education institutions gather large quantities of prospective, current, and alumni students for insight and to enhance their customer experience.
Traditionally these systems involved a very heavy presence in voice calls and mail ballots for data collection. MaximumAD developed a research platform online, hosted the database, and provided valuable insight via descriptive reporting via PowerBI dashboards and reports.
The overall take rate and participation with the initial phone and mail surveys was estimated around 6% of the entire campaign. The new solution called CDcampus allowed for a holistic targeting, marketing, collecting, and reporting system that saw the take rate sky rocket in the first month alone to 17%, an almost 200% increase. Thanks to UI/UX work and a fully designed database, the research firm was able to collect over 240 data points per survey, versus the original 20 yes no questions.
This has allowed them to catapult their offering and begin to provide automated diagnostic analysis as well as predictive analytics. The use of PowerBI and integration with SQL server allowed for seamless lift and shift of traditional to next generation surveys.
Traditionally these systems involved a very heavy presence in voice calls and mail ballots for data collection. MaximumAD developed a research platform online, hosted the database, and provided valuable insight via descriptive reporting via PowerBI dashboards and reports.
The overall take rate and participation with the initial phone and mail surveys was estimated around 6% of the entire campaign. The new solution called CDcampus allowed for a holistic targeting, marketing, collecting, and reporting system that saw the take rate sky rocket in the first month alone to 17%, an almost 200% increase. Thanks to UI/UX work and a fully designed database, the research firm was able to collect over 240 data points per survey, versus the original 20 yes no questions.
This has allowed them to catapult their offering and begin to provide automated diagnostic analysis as well as predictive analytics. The use of PowerBI and integration with SQL server allowed for seamless lift and shift of traditional to next generation surveys.