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.
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.
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).
There you have it, go on in and play around with making awesome Google Sheets dashboards for your business.
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!
Instagram can be a great way to get in front of now well over 300 million people (updated to 400 active monthly users as of September, 2015), it surpassed Twitter last year. So it was important for Dasheroo to provide free Instagram analytics for your dashboards! So what is engagement when it comes to Instagram? Simple: it’s the number of Likes and Comments divided by the number of followers you have. Why is your Instagram engagement rate important? It’s a great tool to compare other social networks to find what really works for your business.
Last year Social Bakers did a fantastic study. They measured the top 25 ‘most engaging brand profiles’ engagement on social networks. The winner? Instagram by a LOT!
Instagram engagement rates kills it vs. Twitter for Dasheroo.
On a per post basis Instagram posts generated a 3.31% per follower engagement rate! That’s huge when you compare it to the average Twitter engagement rate of .07%. It’s almost 50 times more engagement per follower than other social networks.
Forrester also had a great study that found close to the same, they studied 3 million user interactions with more than 2,500 brand posts and discovered that Instagram posts generated a per-follower engagement rate of 4.21%, or 58 times more engagement per follower than other social networks.
But what does this tell you? We wanted to see how it was working for us and although our Instagram following is small we wanted to see it compared to Twitter. Although it might not be statistically valid, it’s directional and we’ll probably put more oomph into Instagram.
One big note here, Twitter is in the top 10 traffic driver to the Dasheroo site while Instagram is far from that so if you’re down with it being great branding and less transactional (posting a link is a pain) then make sure you add it to your social media marketing!
P.S. Don’t forget to check out your Ultimate Instagram analytics dashboard at Dasheroo, you can track all of your social media analytics too!
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
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.
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.
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!