How to Make a Beautiful Google Sheets Dashboard

At Dasheroo we use Google Sheets for, well, just about everything. They’re cool, they’re shareable and they won’t bring your non-Microsoft centric system down. Nuff said. So because we really needed them for our own use we figured “hey, wouldn’t the rest of the businesses in the world need a cool Google Sheets dashboard?” A resounding “YES” was heard.

The Line Graph Insight

The line graph is a great insight that will quickly point out anomalies; you can compare them with other line graphs, and have great insight into what’s happening over a given time period.

The Line graph insight allows you to select two columns or two rows within your Google Sheet to display in a line chart. You’ll select one row/column to be the X (horizontal) axis and then the other row/column for the Y (vertical) axis.

Line graphs on a Dasheroo dashboard from Google Sheet data

 

The Leaderboard Insight

A leaderboard lets you track who or what is in the lead! It’s great for tracking your salespeople, what products are sold the most or for us here at Dasheroo what business dashboard features are being requested the most!

​The Leaderboard insight allows you to select two columns or rows within your Google Sheet to display in a dynamic leaderboard chart. One row/column will be Labels (e.g. names of your customer support reps) and the other will be the Values that correspond to the Labels (e.g. # of cases closed per rep).
Regardless of the ordering of your Sheet data in the columns/rows you selected, the Leaderboard insight will automatically sort the insight in descending order with the “leader” listed at the top. You’ll also be able to see trending information so you will know if something has jumped or dropped a few spots since you last checked your insight.

Create a leaderboard Dasheroo dashboard from your Google Sheet data.

The Funnel Insight

We live and die by the funnel graph, read our post on How to Track a Conversion Funnel. They’re great for tracking conversion rates at every touchpoint. So you can see how many people started to do something and how many people completed what they were doing. For instance if you sent an email campaign you can see how many were sent, how many people opened, how many then clicked and how many ended up signing up or buying. Nifty eh?

The Funnel insight allows you to select two columns or rows within your Google Sheet to display in a funnel chart. One row/column will be set as Labels (e.g. the steps in a workflow) and the other will be the Values that correspond to the Labels (e.g. # of people who completed each step).

Create a funnel Dasheroo dashboard from your Google Sheet data.

There you have it, go on in and play around with making awesome Google Sheets dashboards for your business.

What’s a Good Twitter Engagement Rate for Your Tweets?

Dasheroo's twitter engagement rates.

In this Dasheroo dashboard for Twitter Analytics you’ll see that Dasheroo Tweets 6 times a day and falls right where the big brands do!

At Dasheroo, since we provide businesses free business dashboards to track all of their important KPIs, engagement rates are important for us as well as our users. That’s why we just changed our Twitter analytics engagement rate to include Favorites because we think that’s in important metric to add into the Tweet engagement equation.

Twitter engagement rate for your Tweets we defined as the following: Favorites + RT’s + Replies ÷ Total followers.

So how do you know how you compare? The life of a Tweet is short these days with everyone Tweeting like mad. According to Followerwonk you need to tweet like 9 times/day to stay relevant and that number is likely to GROW! So what would you consider a good engagement rate?

According to Social Bakers (met you guys at SMMW15!) the average Twitter engagement for the top 25 brands came in at about .0007 or .07% for a Tweet. Dasheroo’s engagement rate on a per post basis falls right in there. Our belief is that even if someone doesn’t engage directly with us, hopefully we made an impression.

So if your post got 5 Favorites, 2 RT’s and 8 Replies and you have 1000 followers:

5+2+8 ÷ 1000 = .015 or 1.5%. Pretty good as far as Twitter engagement goes according to the average of the big brands!

Dave Kerpen (@DaveKerpen), CEO, Likeable Local talks about how big brands and their bosses get interaction on Twitter. LL has an algorithm that tracked who the most likable senior executives are at well-known companies. We love that Ralph Lauren is tweeting from his company’s account with the -RL signature!

So how are you doing with your Twitter analytics engagement metric? Check out our previous post 9 Ways to Pump Up Your Twitter Engagement, it’s awesome!

P.S. Don’t forget to check out your Ultimate Twitter analytics dashboard at Dasheroo, you can track all of your social media analytics too!

Facebook Ads: Monitoring Your Cost Per Page Like

If you’re advertising on Facebook Ads (and you should look at it if you aren’t) you might be the type to “set it and forget it”. We know, we’ve been there. But just taking a quick peek at your Facebook Ads metrics in your Dasheroo data dashboard might make you think a bit more about how you do your Facebook advertising.

When you’re starting out you might start with one ad. Take for instance Dwight The Pup. He started out with under 100 likes and it was costing his owners .26 per like. Over time and as more people like his page, his cost per like has gone down to .21 per like with NO adjustments to the ad. And with 1609 clicks and 1376 Likes that’s coming in at a cool 85.5% conversion rate

Screen Shot 2015-02-22 at 11.20.53 AM

Then they did a test, they took two pics they liked with the same message. This one below got 23 clicks (not very valid) and 18 likes so a 78.2% conversion rate. They’ll keep a close eye on this for a few more days to see if Facebook gives this ad some love but .46 per like ain’t cuttin’ it.

Screen Shot 2015-02-22 at 11.13.59 AM

Now compare that to this ad below. Facebook is serving way more of it. out of 131 clicks they got 107 Likes, an 81.6% conversion rate. So far Image 1 seems to be working and .29 per like is getting closer to the winner.

Screen Shot 2015-02-22 at 11.14.15 AM

So in your biz you might consider creating a few ads; one with a person’s picture, one with a picture of your product and one with your logo. All of them should have the same message if you’re testing them head to head. Your call-to-action is asking people to “like” your Facebook page. This way when you have something to post (which hopefully is each day) your post will appear in your Fan’s streams. And if they like what you’ve posted their friends will see it and hopefully like it too.

Now you can compare your cost per page like to see who is bringing in the most Likes at the best price!

P.S. Don’t forget to check out your Ultimate Facebook Ads data dashboard at Dasheroo, you can track all of your social media analytics too!