Category: Google Dashboard Features

Use Google Sheets to Track and Chart KPIs

September 11, 2017 by Chris Bibey·0 Comments

With the help of Google Sheets, it’s easier than ever to create, edit, and collaborate online.

While many people use this free service to create nothing more than simple spreadsheets, others have come to find that it’s much more powerful than that. This is particularly true if you decide to track and chart KPIs from Google Sheets within your Dasheroo dashboard.

If you’re having a difficult time understanding how Google Sheets and Dasheroo can work together, here are three ways you can synchronize the two applications:

1. Single Metric

With a Dasheroo Google dashboard, you can track data for a specific cell within your spreadsheet. An example of this would be tracking the number of sales calls that you (or a team member) make in a particular day.

2. Bar

Are you looking for a way to better track and compare two or more metrics? This is where the vertical bar chart comes into play.

Tracking your metrics the old fashion way is nothing more than a waste of time, money, and resources. A vertical bar chart can bring your data to life.

3. Leaderboard

Here’s how we define this:

“Select two rows or columns to track your metrics in a dynamic leaderboard chart”

Think about the many ways you can use this. Maybe you want to track the performance of your sales team. Or maybe you’re looking for a better way to track the sales of particular products. A leaderboard may be the solution you’ve been seeking.

Conclusion

The way you track and chart KPIs could be the difference between success and failure. Do you really want to take the risk of making a mistake?

If you’re already using Google Sheets – and there is a good chance you are – it’s time to bring this into your Dasheroo dashboard.

Google Sheets, a Google Dashboard, and Your Sales Team

September 8, 2016 by Janine Popick·0 Comments

You can learn a lot through the implementation of a Google dashboard. From analytics to AdWords, there’s always another piece of data calling your name.

Recently, at Dasheroo, we released a new Google Sheets feature that you’re going to be excited bout. Here’s what we had to say about it:

“Now you can track multiple KPIs on ONE chart in your dashboard, up to 5 in fact. So if you want to see how one metric is performing right alongside others, this is the way to do it.”

We can think of many ways this feature will come in handy, especially in regards to your sales team.

With multi-metric tracking, you have the opportunity to track up to five different metrics in one chart. It really is that simple. Take a look for yourself and add this one to your Google dashboard.

With this in mind, let’s take a look at a few ways it can be used to track sales performance and improve results.

1. Track Sales Revenue by Rep

You have many people on your sales team. You know some are performing up to par, while others are lagging behind the group.

With this Google Sheets feature, you can track your salespeople’s revenue against each other. This allows you to see who’s performing best and who needs to pick up the slack.

2. Track Sales Over Time

At the end of each month (or any other interval), you can use this feature to see how each salesperson is performing as compared to the past.

Is one salesperson consistently making more sales than the month before? Is another experiencing a slow and steady drop-off? Tracking them all in a single graph makes it easy to identify quickly who is doing what.

3. Product Sales

What product performs best for your company? What product is on the verge of being discontinued?

If you can’t answer this question, it may be because you’ve yet to track product sales over a particular period of time.

Our newest feature makes it simple to track up to five product sales, giving you a clear idea of which ones generate the largest percentage of revenue.

Getting started is as simple assigning up for an account, creating a Google dashboard, and using this feature to track a variety of sales data. What are you waiting on?

New Release: New Google Sheets Feature + QuickBooks Online!

August 25, 2016 by Team Dasheroo·1 Comment

We’ve been talking about it and it’s finally here! Check out all of the new insights and dashboards Dasheroo has to offer.

New to Google Sheets Dashboard

Now you can track multiple KPIs on ONE chart in your dashboard, up to 5 in fact. So if you want to see how one metric is performing right alongside others, this is the way to do it.

QuickBooks Online (QBO)

We familiarized ourselves with yet another integration that we think is strategically important, QuickBooks Online! After all it is one of the leading small business accounting software packages out there. We already show you what’s happening with Sales and Marketing on your dashboards from a myriad of integrations, but tracking money out and revenue in for marketing and sales is also important. So to start we’re giving you three insights from QuickBooks to add to your Dasheroo dashboard.

Profit and Loss – View a trending line of income and expenses for your business in the given time period.
Customer Balance – View the amount owed by your customers broken down by due and past due.
Income and Expenses – View your high level profit and loss details for the given time period.

What’s New?

Ever wanted to know what we’ve been working on right from within the Dasheroo application? I know, sometimes you’re too busy to get yourself to the blog…well we’ll get you there! Just click on “What’s New” in the app and you’ll see exactly what we’ve been up to.

More to come!

Track Our Startup: We’re Almost There!

August 24, 2016 by Team Dasheroo·0 Comments

We’ve been talking about our latest software release for a few weeks now. This stuff for sure isn’t easy. You have to merge new code with your existing code without making it “visible” to users until you QA the crap out of it. And that’s what we’re in the midst of, making sure when we do make it visible to you it won’t break your dashboards.

So our awesome team had hopes that we could do that last week but it didn’t happen for a variety of reasons. And it would be more work to release part of it then then whole thing. So you might have to wait a few more days to see all of the awesome work we’ve been doing on Dasheroo.

Remember, we’ve got the ability to track up to five KPIs in a line chart using your Google Sheets dashboard. Pretty cool stuff. That’s the one I’m going to put to good use.

Sales & Marketing

Mimi, our Director of Sales, is working on closing one of our biggest deals yet and we’re pretty excited about it. It will bring us a lot of users which is always awesome. Great job Mimi!

I was recently looking at our YouTube analytics dashboard and saw that we have a ton of views in the past week on Getting Started with Google Sheets. We try to have videos all over our help section of our website since we’re a pretty small team. In fact this particular video had almost 1500 views all time. That’s telling to us, we probably need more videos around using Google Sheets on your dashboards. Alf…..you’re so good at these ?

Are you looking at your YouTube analytics?

Track Our Startup: Up Next? Google Sheets & Quickbooks Online

August 10, 2016 by Team Dasheroo·0 Comments

Thanks to a HUGE mention in a Social Media Examiner article entitled: How to Monitor Multiple Social Media Metrics in a Single Dashboard, we got hundreds of users, a ton of quality leads (Mimi had 8 demos yesterday!) and we’re half way to our new customer goal and it’s only the 10th. Thanks Brandon Olson! He’s the Content Marketing Manager at AWeber, one of our email marketing partners.

UP Next?

Josh and Nivi have been working with James and our developers closely to gear up for our next release which will probably include a bunch of Google Sheets improvements. This will be great to add more metrics to a Google Dashboard along with Google Analytics KPIs and Google Adwords KPIs. We’re also working on a whole new integration with … Quickbooks Online! More on that as we finish up development but it’s going to be cool, very cool.

After that one of our most requested integrations will be released and that’s Active Campaign. For those of you who don’t know them they’ve got a killer marketing automation product which includes email marketing and CRM.

Nivi is going to spent this week looking at the Microsoft Excel API. Even though we’re huge Google Sheets users, there’s a ton of you who still heavily use Microsoft. Sigh.

There’s Chef Rabin of Muy Delicious!

Austin Food Truck!!

Our own Director of Sales Mimi and her husband have opened up an awesome FOOD TRUCK in Austin called Muy Delicious and boy does it live up to its name. Food trucks are popular there, all kinds of amazing chefs have opened them. What to eat? The Giddy Up’s Burger is to die for, the chicken Rich Ranch Tacos are amazing and My Butler’s Boneless Chicken Wings are a must-eat. If you’re in Austin on Manchaca Rd., you need to stop.

Bye for now!

3 Things a Google Dashboard Can Teach You About Your Business

July 21, 2016 by Janine Popick·0 Comments

There is more to Google than its high powered search engine. Through the use of Google Analytics, you can gain a better understanding of your business.

With a Google dashboard in place, it’s easy to:

Track the data that’s most important to your business.
Understand your audience.
Make positive changes on the fly.

Taking this one step further, let’s examine three things a Google dashboard can teach you about your business:

1. Top Traffic Sources

Are you getting most your traffic from the search engines? How about social media? What about email marketing?

Once you setup a Google dashboard, you can answer all these questions in real time. Subsequently, you can adjust your approach to get the most out of each traffic source.

For instance if you saw you were getting a ton of traffic from Organic Search (which you don’t pay for) then why not dig deeper to find out what keywords are driving your results and develop more content around those keywords.

If you see that referral sessions are driving a ton of traffic then dig in to see which referrals are converting the most.

2. Are You Reaching Your Goals?

One of the coolest features of Google Analytics is the ability to set and track goals. In short, this allows you to measure how often users complete a specific action, such as:

Destination
Duration
Event
Pages per session

Don’t shy away from setting goals related to website traffic. And if you’re going to do this, be sure to track your progress with a Google dashboard.

Set a goal for how people sign up for your service or how many complete a sale. Then compare that to your sign up or sales data and make sure it all jives!

3. Most Popular Content

It’s imperative to understand the type of content that interests your audience. A Google dashboard can provide you with this insight. Here’s an example:

These pages aren’t among our most popular, so we may want to think about updating them in the future to attract more visitors and better suit our audience.

Conversely digging into your popular pages may make you install a pop-up to get a user to join your list. You may want to include a popular product that a visitor buys along with the product on the page they’re visiting. This way you increase your average order size and ultimately your conversion rate.

When you understand what’s driving the most visitors to your site, you can use this to create more targeted content in the future.

Final Thoughts

Even if you’ve had great success without the use of a Google dashboard, don’t continue to put this on the back burner.

Regularly reviewing dashboard data can teach you a lot about your business.

P.S. If you’re looking for a Google dashboard provider, give us a try!

New Release: More Google Adwords Dashboard KPIs

June 29, 2016 by Janine Popick·1 Comment

We’ve been marching towards this release and it’s finally here! Thanks to everyone on the team for working hard on these upgrades that our users have been asking for. You’ll also be seeing more features over the next few weeks so stay tuned!

This week we’ve made some changes to our Google AdWords insights and wanted to provide all the details. If you use Google Adwords within Dasheroo you’ll want to check this out.

Google AdWords Enhancements

Ad Performance

You’ll now view a table that provides your AdWords KPIs at an individual ad level. For every ad: clicks, impressions, CTR, average CPC and Cost are displayed as KPIs for the given time period.

Video Performance

The Video Performance insight is a quick snapshot of how your video ads are doing in the chosen time period. The overview insight shows high level stats like Impressions, Video Views, Video View Rate, Clicks, CPV, Cost, CTR. The insight also shows how these numbers have been trending in the given time period and gives you an indication of how your video ads have been doing.

Video Watch Rate

This multi-line insight will provide stats on the percentage of impressions where a viewer saw 25%, 50%, 75% and 100% of your video ad and how this trends over a period of time. This insight can be configured at an Ad Account, AdGroup, Campaign or individual ad level on your Google dashboard.

Watch 25% rate : Percentage of impressions where the viewer watched 25% of your video
Watch 50% rate : Percentage of impressions where the viewer watched 50% of your video
Watch 75% rate : Percentage of impressions where the viewer watched 70% of your video
Watch 100% rate : Percentage of impressions where the viewer watched 100% of your video

How cool is that? You’ll now be able to track video viewing KPIs on your dashboard.

New Filters

In addition to new insights we have now introduced the ability to configure your Google AdWords insight at the Ad Set, Ad Campaign or individual ad level. So in addition to the overall high level stats on your AdWords account, you can set up insights at a much granular level to see how a particular ad campaign or even an individual ad is performing. Simply add a new insight and configure it in the settings panel.

We’re planning on more releases in the coming weeks, happy dashboarding!

YouTube Analytics: What Should You be Tracking?

June 9, 2016 by Janine Popick·0 Comments

As the largest video-sharing website in the world, YouTube deserves a prominent spot in your marketing plan.

Since being acquired by Google in 2006, the service has grown by leaps and bounds. This growth has allowed many marketing professionals to use YouTube to drive traffic, increase engagement, and build a stronger brand.

Here is the million dollar question: what’s working for your company in regards to its YouTube strategy?

The only way to answer this question is to keep a close eye on your YouTube analytics. Here are several data points you should be tracking:

1. Number of Views

Track the number of views across your entire channel, you have a YouTube Channel right? Drill down deeper, pay close attention to the views associated with each individual video. This gives you a better idea of the type of content your audience is most interested in.

Your primary goal is to experience an overall growth in views, both day over day and week over week.

2. Number of Subscribers

Views are important, but the number of subscribers to your YouTube channel should never be overlooked.

This represents customers or prospects who have an interest in staying current with your videos.

Simply put, the more subscribers you have the more people there are who will view your content. Subsequently, your brand receives more exposure.

3. Most Viewed Videos

In a perfect world, every video you post to YouTube would be a viral success. In the real world, this isn’t something you should expect.

Some videos will outperform expectations. Other videos will fall well short of what you were hoping for.

To increase your chance of future success, familiarize yourself with the types of videos that appeal to your audience. You can do this by tracking your “most viewed videos of all time.”

Make sure you cross-market your videos too! You can post them on a blog, social media, to your site and you can include them in your email marketing campaigns. This way you can get your video viewed by a wider audience.

When it comes to YouTube analytics, there is a lot of data that deserves your attention. Start out by focusing on the three key points detailed above.

P.S. Dasheroo has some very cool dashboards for your YouTube Analytics so check them out, they’re free!

Track Our Startup: Exceeded Monthly KPIs + New Release on the Way

June 1, 2016 by Team Dasheroo·0 Comments

We’ve got a ton going on between all of the work our engineering team has been doing AND beating each KPI we track! Read on!

We’ve been busy trying to get release #27 out the door. If you remember it’s some new integrations with the likes of SendGrid and some new insights for Facebook Ads and a few other apps. Court and Nivi have been knee-deep in testing mode, great work guys. We’re hoping to get it out by next week so sit tight.

Dasheroo’s new UI on the way soon!

I also can’t wait until we release our new UI. It’s super slick.

Josh has been working super closely with the awesome partner team at Zapier (that amazing company that gives you hundreds of metrics on your Dasheroo dashboard) posted a great blog post announcing our integration with them. They’ll be sending an email out to all of their hundreds of thousands of users soon.

We’re going to start working on a multi-stat insight for Google Sheets, a highly requested feature from our users, pretty cool huh? You’ll be able to compare one KPI to another all in one chart!

We’ve been at work behind the scenes on a stats refresh issue. Some of our customers are noticing that updates aren’t happening hourly but maybe ever few hours so we’re looking into all of our providers to make sure the problem isn’t widespread.

We made our monthly number, I should say numbers! We exceeded all of our KPIs: our new user KPI, our new paying customer KPI and our revenue KPI, and we couldn’t be happier. We shoot to increase our KPIs 10-15% each month and so far so good! More on KPIs.

On to June!

Here’s a Great Example of a Google Dashboard

May 24, 2016 by Janine Popick·0 Comments

Google is the king of free tools for marketing professionals. For example, we love the functionality and power of Google’s Keyword Planner. This is a tool we use day after day, and it’s really helped us take our business to the next level.

A Google dashboard is a great way to better understand your business. From traffic to advertising budgets to goals, the amount of data is never-ending.

If the time has come to create your first Google dashboard, here are three elements to include:

Google AdWords

If at any point you decide to spend money on AdWords advertising, it’s essential to track your results down to every last penny. And you want to track the ‘top of the funnel’, that is how much traffic your driving to your website to evenutally…convert.

Answer questions such as:

How much are you spending every day?
Which keywords are converting best?
What is your ROI?

It’s easy to spend money on AdWords. It’s not as easy to make money. By tracking data and results, you increase your chance of success.

Google Analytics

How do you know how much traffic your website is receiving? Do you understand your top traffic sources? What about your most visited pages?

At Dasheroo, we don’t spend money on Google Adwords (yet) but we do track exactly how many Sessions we get, how many users are responsible for those sessions.

On the dashboard below we include Google Users numbers so we can see how many new users vs. existing ones we get. We also use the “notes” feature so everyone is on the same page for what our conversion rates are.

These are the types of questions you can answer by integrating Analytics into your Google dashboard.

Information like this will change the way you do business.

Google Sheets

Here’s what Google has to say about Sheets:

“With Google Sheets, you can create, edit, and collaborate wherever you are. For free.”

What more can you want? You can leave Excel spreadsheets in the past, instead relying on Sheets to create and collaborate. Through secure cloud storage, you can access all of your sheets from anywhere in the world, with any device.

At Dasheroo on our Google Dashboard you’ll find a ton of great KPIs we track.

We want to look at where we are to goal (we use Dasheroo’s countdown insight) and what our conversion rates are.

Google Ecommerce

This is the ‘bottom of the funnel’ if you’re selling retail. You can track exactly how much you sold from all of that traffic you drove using Google Adwords (or not!)

At Dasheroo since we sell based on monthly subscriptions we use Stripe. However we put that information into a Google Sheet so we can track it all on one Google Dashboard. For us FTC means First Time Customer so we’re pretty happy we got to 100%!

Final Thoughts

At Dasheroo, we have long been a fan of Google’s many free tools. Furthermore, we want all our clients to realize what these tools can do for them. That’s why we have put so much time into helping you create the perfect Google dashboard! Get yours for free at Dasheroo!