STARTING POSITION

The client needed basic business level reports and was relying on a manual process that was slow, fraught with errors and did not provide information in a cohesive package. The goal was to display marketing and sales metrics to management for benchmarking and to show potential growth.

• Painstaking update process. The client’s seller central data was manually sourced, cleaned and displayed every week.
• Day old reports. The process was so tedious and slow that the report would be stale before getting to key stakeholders.
• Disparate data sources. To calculate simple marketing metrics like ACOS and ROI. Required combining data sources that did not speak to each other naturally. This resulted in those KPIs not being available.

PROCESS AND IMPACT

CDA’s work allowed the client to effectively source, clean and display their data to internal management. This timely and effective reporting allowed management to see the potential of marketing. This clarity resulted in an increased marketing budget and 2.5x order growth YoY.

• Easy fast refreshes. Using R, we implemented scripts that automated the cleaning process of the data. We also used Tableau to automate the reporting and analysis. This saved the client 5 hours a week.
• Fresh and accurate. The automated pieces allowed for the reporting to be refreshed almost automatically each week. Additionally, the errors caused by manual processing were removed.
• Confluence of data. The disparate data sources were able to be joined into one cohesive data set in the R script. This allowed ACOS, ROI and channel measurements to be displayed in Tableau.