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.
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.
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.
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.
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!
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.
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.
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.