You have already been in work for well over 12 hours. You said you would meet your best friend after work at 5pm. That was 4 hours ago!
Once a week you have to produce one of these reports. It’s now 9:15pm and you haven’t even started putting the data into spreadsheet yet.
You begin to login to Google Analytics. Earlier in the day you checked your personal Gmail emails and haven’t logged out.
Google Analytics automatically logs you in and shows you an overview of some stats. “Hang on that doesn’t look right?”. You realise straight away you are looking at the traffic information for your personal blog. Tiredness has started kicking in.
“I always do that”. You log out of your personal Google account and into the businesses Google Analytics account. “That’s better”, the stats in front of you to make more sense, if only slightly.
“How do you export the data again”. You manage to get all the information you need out of Google Analytics into a spreadsheet, ready to start linking all the traffic stats from the business’s social media accounts.
“I hate doing this bit”. You start trying to link up the data between Google Analytics spreadsheet and the Facebook Insights export.
One of the support guys from IT has setup an Excel spreadsheet that ‘should’ help with linking the two sets of data together. “Tom, makes it look so easy, I can never get my head round how to use his spreadsheet. I’m sure it is harder than he thinks”
After 15 minutes of error messages from Tom’s spreadsheet. You give up and start copying and pasting the Facebook stats into the Google Analytics spreadsheet. Creating a couple of graphs hoping the data is correct.
You work for a small business, with just under 30 employees. You have worked in their small marketing team for 18 months now. The owner asked you to create this report for him on a weekly basis.
You are under constant pressure to product the report. This week even more so. The owner is going away tomorrow evening and wants the report by 8am tomorrow morning. Not that he looks at the data to make informed decisions. “He will just throw it on his desk anyway. Last time I didn’t the produce the report he was livid”
The clock on the wall clicks past 10PM. Right, only Instagram, Twitter and the PayPal stats left to do. “He wants me to include his LinkedIn profile, forgot about that”.
“Finally, all done” It’s well after midnight. You click print on the PDF you have generated from the all the stats you have pulled together. “5 copies just to be on the safe side”
“My boss should know how late I have worked till”. You have saved the PDF to your PC. You compose a quick email and send it to your boss and the business owner. “Hope his phone alert wakes him up”.
You send your friend a text message apologising for having to cancel your plans yet again. Re-arranging from the same time next week. “Hope it doesn’t take me this long next week, Jen must be losing patients with me, constantly cancelling out plans due to work”
“There must be an easier way?”