Personalizing a Dashboard for 200 Users
Published March 31st, 2016, updated February 15th, 2022
Summary - Dashboarding and visualization tools like Klipfolio allow distributed teams and organizations to stay aligned and make data-driven decisions using a shared, centralized report. But, what about those situations in which many different stakeholders need access to their own, individualized subsets of the same data? See how Empirical Path did this for their clients.
We work with a well-known publisher of consumer content which manages a network of 200 affiliated content providers. These affiliated contributors submit articles and videos for publication on our client’s mobile apps and website. Over the course of 2015 content providers were asking our client a simple question: how is our content doing? While answering this question on a case by case basis would be straightforward, providing feedback to 200 affiliated content providers would not, and our client wanted to provide real-time feedback, so content could be improved in real time.
They asked us for help.
With access to a large data set containing all the information the content affiliates were requesting, our task was to build real-time dashboards that could be used to surface localized KPIs to specific content providers. Learn how to define your organization's KPIs.
We started by working with the client to clearly establish the business goals of the project and define the KPIs that we needed to visualize in the dashboards. Experience has shown that the temptation to take shortcuts during this phase leads to dashboards which don’t deliver business value and actually end up creating extra hours of work. We agreed on the metrics we were after included pageviews by user device, user demographics, and top content categories.
Next, we set out to simplify the data set to make it easier to work within Klipfolio. We implemented Google Tag Manager to simplify the administration of the Google Analytics data and added some custom GA reports to capture specific events, content groupings, and custom dimensions.
Then, we turned to designing the dashboard. We began mocking up dashboard layout concepts, defining Klip chart types, and the widgets that would best communicate the metrics the content providers were looking for. This made the next step, constructing the dashboards, relatively painless.
Here is the simple and efficient method our developers used to quickly set up the Klipfolio backend for user-login filtering for our client’s 200 users. All you need is a Google Sheet as a Data Source for your Klipfolio dashboard. Within the Google Sheet, create a tab that looks like this:
Using this sheet, Klipfolio can filter the data based on the “dimensionN” field. So, when John Smith (00001) logs in, the Klips he sees will only contain data where dimensionN = 00001. For example, if Klipfolio sees the following data within a Data Source for total sessions from Nov 15?Nov 16, 2015, John Smith will see his total as 4,000. The next user, Marie Jones (00002), would see a total of 2,100, and so on down your list?in our case, another 198 rows.
Full Klipfolio documentation on user-level filtering can be found here.
Once finished building the individual KPIs, we set up some test logins for quality assurance using Google Analytics Query explorer to compare and contrast the data being surfaced on the Klipfolio dashboards. For non-GA data sources, we recommend using your favorite SQL workbench to directly query dependencies to see the raw data and make any tweaks necessary before adding the final query to the related Klipfolio datasource.
Once we completed our tests and were confident in the data our users would be seeing, we went ahead and added the 200 users to the Google Sheet table. We then provided users with seats from Klipfolio’s admin screen (see pricing details on Klipfolio users here).
And that's how we personalized a dashboard for 200 users with Klipfolio.
At Empirical Path, our web analytics, A/B testing and tag management consultants focus only on measuring your marketing and online presence. Our Reporting & Advisory Practice tells the story behind your numbers by creating custom reports and translating data into business insights. We synthesize web analytics, advertising, marketing automation, social and CRM data into dashboards using automatically updated spreadsheets, Klipfolio and other tools, then draw findings and recommendations from the visualizations each month or quarter. Our Web Analytics Implementation Practice fixes and enhances web analytics implementations, making your metrics more trusted, complete and actionable. If you have questions or are interested in getting expert help with your implementation, we would be happy to talk with you. Contact us at www.empiricalpath.com.
Pauw Agency brings transparency to the music industry with Cervinodata
By Erik van Dorp — September 29th, 2020
Three Ways Unito Uses Data As Rocket Fuel
By Lauren Thibodeau — September 25th, 2020
Digital Agency Tracks Return on Ad Spend (ROAS) for Clients with Klipfolio
By Mitch Dupuis — March 16th, 2020
Irdeto saves 15 hours of marketing report work per month with Klipfolio
By Mitch Dupuis — February 20th, 2020