Five Ways to Decrease Ad Hoc Analytics RequestsIn my first job as a web analyst in the late ‘90s, I worked in an IT department of a large telecommunications company. The analytics team consisted of me and another person who was part time. We worked out a pretty good process of providing standardized reporting to about 40 marketers, content editors and executives on a monthly basis.

This system would work great until our manager would stop by one of our cubes with a time-consuming, ad hoc request that would throw off our timing and perfectly tuned schedule.  The requests weren't necessarily difficult -- like running a geolocation visit report based on a specific date range -- they just came at inopportune times and would throw our schedule off. We called these random requests “drive bys.”

I conducted research with over 100 digital analytics managers a few years ago and was a bit surprised that ad hoc requests came up as a task that comprised nearly 50 percent of their team's work hours. Many of the digital analytics managers I’ve worked with over the years describe ad hoc requests as an issue that won’t go away.

While it would be easy to talk about the lack of consideration my old boss had for the beautiful schedule my colleague and I had put together, or the unrealistic expectations your manager or stakeholders have for you to have complex analyses turned around in 48 hours, I believe the accountability for change could be staring you in the mirror. That’s right, it’s you.

The change you need to make?

Don’t Say 'Yes'

This doesn’t mean saying “no” to requests either.

It really means “I hear your request. Now let me evaluate what it will take to do this and also evaluate what will not get done, if I fulfill this request."

Here are 5 points to consider before you say “yes.”

1. What is the business reason for the request?

A business reason requires the requestor to describe why they want their ad hoc request fulfilled. Once you understand the request, you can determine whether this is a task you’ve never undertaken, or perhaps you’ve done similar work or created a similar report or analysis that provides the answer to the question being asked.

2. Are the analyses or reports requested the right ones to answer the business question?

The requestor may or may not have experience in analytics, but you are the resident expert. Once you know the business reason, you may see that there are metrics to be created and reports to be run that are not the same as what was originally requested.

Regardless of the approach, be sure to confirm the requirements with your stakeholder before doing the work. Creating a separate document or email, having a meeting to review for changes and then a written acknowledgement at the beginning of the work may not seem necessary, but once the project starts and everyone forgets the details, having clear approval helps everybody.

3. Once you've figured out how the ad hoc request should be fulfilled, determine the level of effort needed to produce the work product and the amount of time it will take.

We generally don’t want to think about how much time it will take to go through all of the steps to produce the analysis. Estimating hours on a task level is not a lot of fun. It requires us to be accountable for our time, and it puts us into the uncomfortable role of creating an expectation -- and we don’t want to fall short of these expectations. Here’s what you do;