{"id":193,"date":"2013-01-22T09:37:34","date_gmt":"2013-01-22T09:37:34","guid":{"rendered":"https:\/\/cloudamp.com\/news\/?p=193"},"modified":"2020-10-27T09:54:56","modified_gmt":"2020-10-27T09:54:56","slug":"the-emailed-dashboards-school-of-management","status":"publish","type":"post","link":"https:\/\/cloudamp.com\/news\/the-emailed-dashboards-school-of-management\/","title":{"rendered":"The Emailed Dashboards School of Management"},"content":{"rendered":"

Today we have access to increasing amounts of data and analytics, from all kinds of systems and applications that were not easily accessible to business users even 5 or 10 years ago.<\/em><\/p>\n

\u201cBig Data\u201d it is sometimes called, though more because it sounds cool than the actual size of the data in many cases. With all of this data however, understanding the \u201cmeaning\u201d of the data is increasingly difficult.<\/em><\/p>\n

W<\/strong>e all need a way to quickly spot trends, and gain actionable insights from all that data that helps us manage the people and processes in our daily work.<\/p>\n

One method I have found to be particularly effective in making use of data is having a series of dashboards automatically updated and then emailed to me nightly or weekly. Hourly between midnight and 4 or 5 AM, Salesforce updates my dashboards and emails them to me, graphs and all, to be reviewed while having my morning coffee and cleaning out the inbox.<\/p>\n

Getting dashboards emailed to me eliminates the need to remember to log in and check the correct reports, and makes it easy to spot any anomalies or trends early. If I need more information about a graph or chart, clicking on it in my inbox takes me directly to the underlying report in Salesforce.<\/p>\n

And having all the\u00a0data centralized in Salesforce<\/a>\u00a0(hopefully) makes it easy for the data to be up-to-date without any human intervention to combine data sources or update spreadsheets.<\/p>\n

Some Dashboards I like to see daily:<\/h2>\n
\n

Website traffic via\u00a0Google Analytics into Salesforce<\/a>\u00a0<\/strong>\u2013 how many unique visitors, page views, etc. did I get yesterday and where did they come from? How did that big blog post do? Anything that doesn\u2019t look right? (Yes, I know I can log into Google Analytics and see this high level data plus a whole lot more, but I probably won\u2019t \u2014 unless an email dashboard alerts me to something that warrants deeper investigation.)<\/p>\n

\"\"<\/a><\/p>\n

Registrations via\u00a0backend database integration<\/a><\/strong>\u00a0\u2013 if visitors are signing up on a web site or registering for an account with a SaaS product, I want to push that to Salesforce (within a few minutes ideally), so I can correlate visitors with registrations and have a clear view of the top of my funnel.<\/p>\n

Leads via Salesforce\u2019s\u00a0Web-to-Lead form<\/a>\u00a0and other sources<\/strong>\u00a0\u2013 how many inquiries are we receiving, and what is happening to them. This should include lead sources, ideally set by an automated tracking system (and yes\u00a0I have one that I favor<\/a>), as well as anything sales reps or marketing people enter into Salesforce clearly identified as such for separation in reporting.<\/p>\n

\"\"<\/a><\/p>\n

Sales activity via Salesforce<\/strong>\u00a0\u2013 How many calls, emails and other activities are happening, and which reps are performing best. Don\u2019t think of this as big brother or keeping the Sales people honest, but more as understanding your business\u2019 sales productivity. And if you haven\u2019t worked in sales before, you have to witness the data to understand that one Sales rep\u00a0really can<\/em>\u00a0make 5 times more calls than another rep (and generally close 5 times as much business, though not always) even though both reps appear productive anecdotally.<\/p>\n

Online Advertising Performance<\/strong>\u00a0\u2013 If you are advertising online, Leads or Registrations with daily graphs broken out by advertising publisher is a particularly useful dashboard. You do need to keep some of those ad networks or blogs honest in terms of the impressions they are running and traffic they are sending you. Plus you will be able to see right away if your conversion tracking code was accidentally left off that new landing page, rather than at the end of the month when the numbers are run and it is too late.<\/p>\n

 <\/p>\n

Some Dashboards I like to see weekly:<\/h2>\n
\n

Usage data<\/strong>\u00a0\u2013 Integrating usage data from SaaS products or other customer behavior or purchasing information into Salesforce accounts is critical for both lead scoring \/ account ranking, as well as aggregate numbers on how the business is doing overall. I like to see a dashboard that has total usage (or whatever the key metric that shows customer adoption is) across all customers, as well as a list of top accounts, new accounts with high usage, and potential churn accounts whose usage \/ purchasing has recently dropped off.<\/p>\n

\"\"<\/a><\/p>\n

Conversion funnel<\/strong>\u00a0\u2013 what are the trends in terms of lead conversion \/ opportunity creation, and how does the top of the funnel look in terms of volume.<\/p>\n

Sales Pipeline<\/strong>\u00a0\u2013 what Salesforce Opportunities are open, if there are free trials which are expiring in the next week or two, how many deals are at each stage, and is anything neglected or staying open forever without movement?<\/p>\n

\"\"<\/a><\/p>\n

Revenue<\/strong>\u00a0\u2013 If you have a billing or other financial system integrated into Salesforce, it is nice to have some revenue dashboards as well. It isn\u2019t a substitute for financial reporting (and won\u2019t make the accountants happy), but can help you see total revenue, new sales, and understand some high level financial trends, even if it isn\u2019t accurate to the penny.<\/p>\n

By reviewing daily or weekly dashboards emailed from Salesforce, you can start each day with a quick overview of your business, and an easy opportunity to understand any trends and spot problem areas or successes. In addition, building these dashboards will ensure that you have all or most of the data that you need in Salesforce for other people to use, so it can make the chances of success much greater if you are just rolling out Salesforce CRM.<\/p>\n

You may need to dive back into any one of a number of systems to see further details in the data, or use more sophisticated analytical tools to understand the correlations between different data sets. But ultimately having the data summarized, automatically updated and emailed to you in dashboards is a great way to stay on top of the top line numbers and trends in your business.<\/p>\n

How are you using dashboards, and do you get them via Email? Let me know in the comments below.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Today we have access to increasing amounts of data and analytics, from all kinds of systems and applications that<\/p>\n","protected":false},"author":2,"featured_media":197,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-193","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/posts\/193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/comments?post=193"}],"version-history":[{"count":5,"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/posts\/193\/revisions"}],"predecessor-version":[{"id":205,"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/posts\/193\/revisions\/205"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/media\/197"}],"wp:attachment":[{"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/media?parent=193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/categories?post=193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudamp.com\/news\/wp-json\/wp\/v2\/tags?post=193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}