image-2-tableau

Automate Dashboard Updates to Focus Your Time on Analysis

  |  August 6, 2013   |  Comments

If you ever find yourself spending too much time manually updating dashboards, stop. Think. Figure out the best way to automate.

Updating customized dashboards, spreadsheets, and reports manually is a time-consuming process. It's also one no one really enjoys doing. Sure, it's quicker to do it once, but over time automation will save you a lot of effort. Especially if you are an agency or have a lot of sites you want custom dashboards for.

While it may come as a surprise to some of you who set up automation ages ago, I know many are still manually updating dashboards both on the agency and the brand side. The good news is tools exist to not just make your life easier, but free up time previously spent entering data. This allows for more focus on the fun, creative, and ultimately valuable part of analyst work: fleshing out insights, giving actionable advice to your team, and sharing results.

Today I thought I'd share three ideas to help you stop any manual updating of dashboards that are particularly useful if you're using Google Analytics. However, these tips should still have value no matter what you're using: most major analytics packages have application programming interfaces (APIs) and configurations that allow for similar automation and exporting of data.

1. Use APIs/scripts to auto-populate a custom dash in Google Docs.

image-1-googledocs
Google Analytics data input into a spreadsheet via the Analytics API and Apps Script.

It's now relatively easy to create your own automatically updated dashboard in a Google Doc if you're using Docs and Analytics. This is a great way to share your data in a malleable/social format with your entire organization (or just select people) with a simple link. Once the data is inside a spreadsheet, it's easy to manipulate, create new visualizations, and build internal dashboards. Also, after you have built one it's easy to copy-paste it over and customize versions for different stakeholders. Learn more here (no code required!).

2. Use a connector to pull data out of Analytics into the desired visualization tool.

image-2-tableau
Scatter plot created from GA data in Tableau.

While I'm clearly preferential to the sharability and simplicity of Google Docs, some brands and analysts like to get dashboards and data to play with in offline spreadsheets or apps. For this, I'd recommend checking out some of the many great tools out there like Excellent Analytics or Next Analytics. Additionally, a popular data visualization tool Tableau recently released a connector that plugs right into Analytics as a data source and lets anyone create beautiful and highly customized visualizations.

3. Build custom dashboards right in the product.

image-3-gadash
Area chart in Google Analytics custom dashboard (via Justin Cutroni's PR dashboard).

Alternatively, skip exporting altogether and just make/share custom dashboards (which have an ever-growing list of widgets) right in the product. While this is listed last, it's possibly the best solution as it's the easiest to create and lives right in the product. You can even automate the delivery of these dashboards to various stakeholders so they don't even need to log in to the product to get their daily or weekly update. Most analytics solutions offer this as standard functionality and I'd recommend you try to stay within your main tool as much as possible and build custom dashboards for each of your stakeholders or groups. To give you a head start, our team has built a solutions gallery with many dashboards tailored for specific industries and specializations.

I hope that no matter what you're using you consider spending time up front as part of your measurement planning process to automate the busywork. Save your manual efforts for analysis and creative presentations of data with insights to prove your point and make decisions. If you ever find yourself spending too much time manually updating dashboards, stop. Think. Figure out the best way to automate.

ClickZ Live San Francisco This Year's Premier Digital Marketing Event is #CZLSF
ClickZ Live San Francisco (Aug 11-14) brings together the industry's leading practitioners and marketing strategists to deliver 4 days of educational sessions and training workshops. From Data-Driven Marketing to Social, Mobile, Display, Search and Email, this year's comprehensive agenda will help you maximize your marketing efforts and ROI. Register today!

ABOUT THE AUTHOR

Adam Singer

Adam Singer is Analytics Advocate at Google, a marketing, media and PR industry speaker, startup adviser and blogger. He previously was digital director for a 300+ person global consulting team and over the course of his career has provided online marketing strategy for B2B & B2C brands in a variety of industries including marketing technology, healthcare, manufacturing, advertising/subscription-based web startups, and much in between. Singer and his campaigns have been cited by top media outlets such as TechCrunch, AdWeek, NY Times and more for creative use of digital marketing and PR. Singer blogs at The Future Buzz - an award-winning blog with more than 25K subscribers and frequently-referenced source of what's new in digital marketing.

Connect with Adam on Google+ or Twitter.

 

COMMENTSCommenting policy

comments powered by Disqus

Get the ClickZ Analytics newsletter delivered to you. Subscribe today!

COMMENTS

UPCOMING EVENTS

Featured White Papers

BigDoor: The Marketers Guide to Customer Loyalty

The Marketer's Guide to Customer Loyalty
Customer loyalty is imperative to success, but fostering and maintaining loyalty takes a lot of work. This guide is here to help marketers build, execute, and maintain a successful loyalty initiative.

Marin Software: The Multiplier Effect of Integrating Search & Social Advertising

The Multiplier Effect of Integrating Search & Social Advertising
Latest research reveals 68% higher revenue per conversion for marketers who integrate their search & social advertising. In addition to the research results, this whitepaper also outlines 5 strategies and 15 tactics you can use to better integrate your search and social campaigns.

WEBINARS

    Information currently unavailable

Jobs

    • Internet Marketing Campaign Manager
      Internet Marketing Campaign Manager (Straight North, LLC) - Fort MillWe are looking for a talented Internet Marketing Campaign Manager to join the...
    • Online Marketing Coordinator
      Online Marketing Coordinator (NewMarket Health) - BaltimoreWant to learn marketing from the best minds in the business? NewMarket Health, a subsidiary...
    • Call Center Manager
      Call Center Manager (Common Sense Publishing) - Delray BeachWanted: Dynamic Call Center Manager with a Proven Track Record of Improving Response...