Anna just got brought on to an exciting & innovative division of Acme Technologies. Her new job includes ownership of her division’s social data.

Maybe that sounds a bit boring, but if you’re into analytics this is a great gig.

Or at least that’s what Anna thinks, until she gets into her first day and sees the workflow from her predecessor…

Maybe you can guess already, but it is not pretty.

It’s an 8 step process. Takes up 10–20 hours of her week. Requires her to login to 3 different platforms. Essentially, Anna’s new job is building out this monstrosity of a report every month, and she won’t be doing much else.

So, what does this nightmarish workflow look like?

Acme has social data on Sprinklr. Analytics data on Google Analytics and several manually tracked metrics in a cloud hosted spreadsheet.

Anna has to log in to access each service. Export the data or visualization she needs. Put some of it into a new spreadsheet. Then she has to process all that data and build new charts and visualizations.

But we’re not done yet.

She has to copy out all the values and charts from her spreadsheet and put them into a powerpoint presentation to share with her team. That powerpoint needs to be formatted properly and customized to match this weeks data.

One thing is for sure. This is NOT a good use of her time.