Social Media Scorecard
About the Fortune 500 Retail Company
This is an American multi-brand, multi-channel, specialty retailer that offers an assortment of women’s, men’s and children’s apparel and accessories. It operates more than 300 retail stores throughout the United States and conducts its business through retail, catalogs and online.
Challenge
Challenge
The client required an overhaul and expansion of their current web-based Social Media Scorecard document in order to improve accuracy, timeliness, and efficiency of social media reporting.
Solution
Solution
We enhanced back-end data sheets by correcting various formulas and increased processing speed by removing unnecessary functions. We also re-designed the weekly and monthly scorecards based on the client’s preferences and created a new quarterly and fiscal YTD scorecard to enhance reporting capabilities. Along the way, we were able to add new functionality and migrate the data and scorecards to a more stable platform.
Benefit
Benefit
At the end of each reporting period (week, month, and quarter), the client simply enters the raw data for each platform and the applicable scorecards automatically calculate and update along with the applicable charts and graphs.
