Connections: The offical publication of Applied Client Network

Building a Productivity Dashboard With Applied Epic: Lessons From One Agency
Operations

Building a Productivity Dashboard With Applied Epic: Lessons From One Agency

While many agency leaders have a good sense of who on their team is stretched thin and who is ready for more, that sense is hard to act on when it relies mostly on impressions and gut reactions.

At our agency, we developed an employee productivity dashboard to give our leadership team a more concrete instrument for meaningful action. To build our productivity dashboard, we combined information from Applied Epic, Outlook Exchange, and several internal reporting sources to create a more complete view of workload and capacity.

This dashboard helps us balance workloads, encourage more informed staffing decisions and inspire effective conversations with our team. Our method is always guided by the principle that data is an indicator rather than a conclusion.

As an independent agency, we’re able to allow most of our account managers to work remotely. While this flexibility is a benefit for most, it also means our leadership team doesn’t have the option of walking the floor to compare the ways that our team members handle their work or to see who is overwhelmed. We needed a tool to measure work across multiple channels, whether the employee is sitting in the cubicle next door or in their home office halfway across the country.

For us, that tool is an Excel spreadsheet that pulls data from a variety of sources. Presented across multiple sheets, the data is aggregated, filtered and analyzed to help identify patterns over time and raise questions for our leadership team to investigate.

Before pulling any reports, we agreed on the ways in which data could help us:

  • Balance workloads so everyone is accountable and adequately supported.
  • Make staffing decisions about team headcount.
  • Anticipate busy periods before they arrive.
  • Replace gut-feeling decisions with data-backed insights.
  • Provide tracking consistency to allow for measurable follow-through.
  • Spark meaningful conversations.

Context Is Everything

Data contains no inherent meaning until we ascribe context to it. Interpretations are influenced by myriad variables, encompassing everything from an employee’s work history to misunderstandings of a shared objective. Many factors contribute to how a leadership team should review a complicated set of productivity metrics. Curiosity is critical to a fuller understanding of the data and, ultimately, effective decision making.

Consider these variables:

  • Role: What is this employee actually expected to do day to day, and is that expectation reasonable?
  • Client count and complexity: A smaller book of high-premium, multi-policy accounts can be far more work than a larger book of simple accounts. How much is too much on an employee’s plate?
  • Experience: Someone newer to the role will naturally work differently from a seasoned veteran. Is the employee new to the industry or bringing in habits from prior agencies?
  • Current levels of support: Does this person have help, or are they handling everything themselves? Is the support they are receiving as impactful as expected?
  • Personal situation: How do you respond when a dip in performance coincides with stressors happening in someone’s life outside of work?

Six Layers of Data We Monitor

Imagine the productivity dashboard as a layered cake: each layer represents a data category that contextualizes metrics for individual employees. Taken together as a slice (tasty!), the layers help the leadership team identify patterns across various channels.

Grab a fork and let’s dig in:

  1. Book of business: We start with workload before looking at productivity, comparing client counts, premium and revenue across account managers to get a sense of each book’s relative size and complexity.
  2. Work efforts and activities: We look at activities closed, activities open and work efforts using Applied Epic Dashboards. Not all work efforts are created equal; a re-market takes far more time than a mailing address change, even though each activity is measured equally by Epic.
  3. Email: Sent volume tends to be the most useful comparison when books are roughly equivalent, while received and read counts can show who is spending a lot of time on non-client email.
  4. Phone: Calls received, made and missed, along with average handle time, often say a lot about how someone approaches their day. Most VoIP providers have reports that can be exported and engineered in Excel.
  5. Retention: Clients, policies and revenue retained year over year. While retention is not strictly a measure of productivity, we believe it can be an outcome of productivity or the lack thereof. High retention often signals high productivity, but be mindful of averages; if an account manager has a small book, one cancellation will have an outsized impact.
  6. Cancellations: Similar to retention, cancellations may be an outcome of productivity. We are careful to measure the reason a cancellation occurred. Some cancellations may not be within a service provider’s control, such as the client selling their home, while others could be a direct response to poor customer service, such as your agency receiving a Broker of Record change.

Use Data to Ask Curious Questions

We measure productivity quarterly to identify trends. A snapshot of the data can be helpful, but patterns are typically uncovered over time.

In our experience, the most valuable thing a dashboard produces is a set of good questions spurred on by curious review.

Here are a few examples and questions to consider when assessing productivity:

  • One account manager receives far fewer calls than a peer and misses most of them, yet completes more than twice as many work efforts in Epic.
  • What is contributing to the difference? Is this a training need, a workflow preference or a sign they’re buried in back-office work?
  • Two producers show a large gap in policy and client retention, and the one with stronger retention also manages nearly three times as many clients.
  • Why might the gap exist? What factors could be contributing?
  • Two account managers document their work very differently: one creates far more attachments, the other more activity notes.
  • How do they work differently, and what is an acceptable variance between people?

None of these questions assumes an answer.

A high missed-call rate might point to a coaching opportunity, or it might mean someone is carrying more than their share of the service load, and you won’t know which until you dig deeper. A leadership team may investigate email volume, retention and cancellation reasons and book of business size to provide context for meaningful questions.

How you ask those questions matters, since people tend to answer honestly when they sense genuine curiosity and may be less open to conversation when they feel challenged.

What Leaders Should Know Before Measuring Productivity

A productivity dashboard only creates value if it becomes part of how your leadership team operates. A few things to consider when transforming the data into practice:

  • Ensure data integrity. A dashboard is only as good as the data behind it. Without strong data integrity, the numbers can be misleading and undermine trust in your efforts.
  • Know your tools. Reports are best when you need broad swaths of data, and Epic Dashboards work well when you need more specificity and control.
  • Review on a regular schedule. Patterns emerge from regular, comparative review over time, and they sharpen the insights you glean. For our agency, we have decided to review quarterly, comparing period over period. Be mindful of the time investment in building, refreshing and analyzing the dashboard for each measured period.
  • Tie it to business objectives. Productivity metrics should connect to the agency’s broader goals, such as retention, growth and service quality, so that everyone understands why they matter. Connect these metrics to consistent expectations for your team to avoid misunderstandings about your agency’s goals.
  • Avoid analysis paralysis. The volume of data gathered in the productivity dashboard can be overwhelming to managers who are already busy. A few well-chosen metrics will get far more use than a sprawling dashboard. Remember, we are all human!
  • Transparency with your team. It’s worth deciding up front what you’ll share with the team and what stays at the leadership level. Transparency looks different for each agency. Depending on size and culture, some agencies may decide that the process is an open one, or that it should be more opaque.
  • Balance quantitative with qualitative. Be curious. Pairing the numbers with what your managers already know about their people will often yield better conversations.

Get Started With Your Own Dashboard

Running reports is only half the battle on a productivity dashboard. Lasting impact comes from thoughtful implementation. Start by identifying a handful of metrics tied to organizational objectives for your agency, gather your data over time and review the results with curiosity.

Useful conclusions are formed by experienced and inquisitive leaders, bolstered by dependable data. A successful productivity dashboard won’t necessarily tell you who your rock star employees are, but it will illuminate where to look, what to ask and how you might better support your team.

Elliot Targum

Elliot Targum

Elliot Targum is chief operating officer of Dwight Rudd Insurance, an independent, privately held boutique brokerage in Boston founded in 1949. He leads the agency’s strategic planning, helping leadership set priorities, plan staffing and growth and oversees day-to-day operations. Outside the agency, Elliot is a game designer and owner of a Boston-area escape room.

Jordan Lindley

Jordan Lindley

Jordan Lindley is operations manager at Dwight Rudd Insurance. He oversees the flow of information through the organization, supervises the reception team and maintains the agency’s databases and reporting. Jordan is an Applied Client Network volunteer and an incoming ACN board member. Outside work, Jordan is a musician and songwriter.