New Release: New Google Sheets Feature + QuickBooks Online!

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.

Google Sheets multi KPI dashboard

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.QBO Income and Expenses Dasheroo dashboard
  • Customer Balance – View the amount owed by your customers broken down by due and past due.QBO Past Due Dasheroo dashboard
  • Income and Expenses – View your high level profit and loss details for the given time period.QBO Income & Expenses dashboard

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.

Dasheroo - What's New Feature

More to come!

Track Our Startup: We’re Almost There!

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 YouTube Analyticsand 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?

Startup Lessons: The Power of a Single Positive Mention

Here at Dasheroo we’re increasing organic traffic and signups each month with zero paid media. It’s a combination of our freemium model, solid SEO and inbound marketing, and what we hope is a great product and user experience that people will share. We’ve also done a ton of influencer marketing to get our product off the ground and continue influencer outreach. We track our activity very carefully, and can pretty much plot our growth trend.

But all that said, it’s awesome when we get an unexpected – and very much appreciated! – mention from a big influencer. In this case, it was from our friends at Social Media Examiner. Talk about an influence, their blog and email reaches hundreds of thousands of marketers and is very well read and highly respected.

The article was How to Monitor Multiple Social Media Metrics in a Single Dashboard and we were fortunate to be the first of four options they recommend:

Dasheroo article from SME resulting from influencer marketing.

The power of a single positive mention!

On that day, August 8th, and for several days after that our new user signups went through the roof:

Dasheroo new users from influencer marketing!

We estimate that that one positive mention drove almost 1,000 incremental new users. And of course it’s not all about new users – our signup conversion rates doubled! We also saw an immediate spike in sales and agency leads for Mimi, our agency salesperson, to follow up on and close.

Lesson learned: Work your ass off and do good things, people will talk about you and stuff like this can happen! Influencer marketing is no joke.

Next, we’re making sure to run cohorts on this audience segment to carefully track how they convert and retain over time. This will help inform us as to the audience match, product focus and potential of partnering with them on future activities.

YouTube Analytics: Here’s What You’re Missing

As the number one video sharing website in the world, every marketing professional should have a YouTube strategy that drives traffic, increases engagement, and boosts brand recognition.

Here are some YouTube statistics that prove the power of this social platform:

  • YouTube has more than one billion users.
  • YouTube can be navigated in more than 75 languages.
  • More than half of all YouTube views are on mobile devices.

Some companies have dabbled with YouTube marketing in the past. Others, however, have ignored it altogether.

Regardless of your past experience and future goals, you should never overlook the power of reaching your audience via video.

And anything can be turned into a video can’t it? You can have a “how-to” video on setting up a tent, a recipe video for making apple pie, a video on the proper way to wash a dog and a video on how to grow tomatoes indoors, the possibilities are endless!

To ensure that your marketing strategy is trending in the right direction, it’s imperative to study your YouTube analytics data on a regular basis. In addition to basic data – such as the number of video uploads and views – there are other details that deserve your attention. Here are some you may have overlooked in the past:

YouTube Analytics: Watch TimeScreen Shot 2016-08-19 at 8.23.33 AM

Don’t focus all so much time on number of views that you overlook the importance of watch time. We define this as follows:

“The total time that users spent watching your videos, in minutes.”

Taking this one step further, if you find that your watch time spiked during a particular period, review your video library for a better idea of the cause.

For instance, How to Grow Tomatoes Indoors During the Winter had 239,000 views. It would be great to know if there was a spike in watch time one year after he posted it. Then he could look to Google Analytics to see what site may have mentioned him to drive more traffic to his video.

You can look at your Dasheroo “Most Viewed Videos” dashboard to uncover the answer. From there, you’ll want to spend more time and money marketing that particular video.

YouTube Analytics: EngagementScreen Shot 2016-08-19 at 8.23.47 AM

This means something different on every social platform. With YouTube, focus on the following:

  • Shares
  • Comments
  • Likes (and dislikes)

For our tomato video our host would want to know if people are liking it, commenting on his content and sharing it with their friends and followers. If he used Dasheroo he could tell quickly what is going on with his video and see that he has a ton of thumbs up, a few thumbs down and the overall number of comments he’s getting. You can also see if you look at his comments he often replies to people asking questions. That sparks more engagement.

YouTube Analytics - How to grow tomatoes indoors

So when engagement begins to pick up, keep the momentum by jumping in on the action and respond to comments. Along with this, you can produce similar videos (since you already know they interest your audience).

So…

When it comes to YouTube analytics, you’ll never be hurting for data. While you focus on the basics, don’t overlook the more advanced details (see above) that can help you tweak your marketing strategy for better results.

Track Our Startup: New Release On the Way

As we told you last week we’ve been busy on our next release for your dashboards due out later this week. What’s new? A bunch!!

New Features for Tracking KPIs On The Way!

The biggest request we get from those who track KPIs on a Google Sheets dashboard is support for tracking multiple KPIs on one sheet. Well in the next release you’ll be able to support FIVE!!

You’ll also get access to these new features right from within your dashboards so every time we do a release it will be even easier to find out all the goodies you’ll have access to.

We’ll also have a few Quickbooks Online insights to add to your dashboards. Now you’ll be able to track KPIs like your P&L right from Dasheroo.

We’re also working to get our Active Campaign dashboard out so you can track all of your marketing KPIs in one spot. That will likely make the release after this one. Great job guys!

We’ve been doing pretty good with our SEO lately. We use a tool called SEM RushSEM Rush - Dasheroo SEO which we really like. It gives us great competitive intel for keywords that other businesses in our space are ranking for. We can easily see where we are plotted next to other businesses. In the chart on the right you can see that we are ranking for the most organic keywords that drive the right targeted traffic. Can you tell we love our graphs and charts here at Dasheroo? 🙂

Alf, our VP of Customer Success, has been busy recovering from the awesome onslaught of user questions and suggestions (which we love) from the Social Media Examiner article last week. It was an awesome article, How to Monitor Multiple Social Media Metrics in a Single Dashboard, thanks again @SMExaminer! We also had a record number of purchases we’ve ever had in a week.

Back to work!

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

social media examiner article: track KPIs in a dashboardThanks 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.

Austin Food Truck: Muy Delicious

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!

Social Media Examiner: Monitor KPIs In a Single Dashboard!

Social Media Examiner: Set Up a Single Dashboard to track KPIsWe just got HUGE ink in a great article from Social Media Examiner and we couldn’t be more excited. It’s all about tracking KPIs from a single spot. It’s an awesome read: How to Monitor Multiple Social Media Metrics in a Single Dashboard.

Writer Brandon Olson who is the Content Marketing Manager at AWeber, one of the world’s leading email marketing providers, walks you through how to choose the right tool for your business (so yes our competition is in there, we like them!) how to connect Facebook, Twitter, Pinterest, Instagram and LinkedIn social media KPIs.

And it’s not a surprise Brandon also talks about how to tie in Google Analytics KPIs as well as an email marketing dashboard.

Also check out his other Social Media Examiner article: How to Generate Leads With Social Media Quizzes

Twitter Analytics: What’s Your Primary Focus?

Can you believe that Twitter has approximately 310 million monthly active users (as of March 31, 2016)? Or how about the fact that 83% of these users are active on mobile?

With statistics like these, it’s important for Twitter analytics to be a big part of any social media strategy.

Of course, there is more to Twitter than posting updates and hoping for a steady increase in your number of followers. You must focus your time, energy, and effort on the areas that have the best chance of making a positive impact on your company.

With this in mind, here are three details that deserve your attention:

1. Follower GrowthScreen Shot 2016-08-02 at 1.50.31 PM

There is a big difference between hoping you grow your follower count and taking steps to make this happen.

This chart displays day over day and week over week growth.

But don’t stop here. Make note of the days when the biggest increases occur. What did you do differently? Did you post more updates? Did you share an interesting blog post? Dig deep to find out which actions have the biggest impact on your follower count.

2. Highest Engagement

You can make as many updates as you want, but remember this: engagement Twitter analytics: highest engagementis what matters most.

You want your audience to engage with your content, whether it be through a retweet, reply, or like. When this happens, you know you’re on the right path. You also know what types of updates to share in the future.

3. Amplification Rate

Often overlooked, at Dasheroo we define this as follows:

“Rate that followers share your Tweets with their followers (amplification = number of RT’s per Tweet).”

This goes hand in hand with engagement, as you want your amplification rate to be as high as possible. In short, this means your followers are sharing your updates with their followers. In other words, your content is amplified!

Now what do you think about Twitter analytics? Will you spend more time on this part of your social media marketing plan in the future?

Track Our Startup: We’re Finally On Vacation

opinions_charts01

This would be a a great addition to Dasheroo dashboards wouldn’t it? 🙂

Ok, we’ve been working pretty hard on your dashboards here at Dasheroo the past year and some of you who have been following us know we’re a distributed company. That said we can work from anywhere as long as we’re all ok with dealing with any customer and company issues from the time zone where that issue occurs. Everyone at Dasheroo is aok with that.

This week we’re happy to announce that one of us is in Hawaii (or is it Hawai’i?) with the family, one of his favorite places on Earth! Another member of the team is in New York visiting family with his family. The quality of life is an important aspect for all of us here at Dasheroo and to the extent we can, we take complete advantage of it.

We are big believers in living life here at Dasheroo and balancing living life with servicing customers and pushing our company along. And we’re doing it. If we could have a gauge in our dashboards for balancing work/life…we would!

So while we’re busy working on the next integrations (Quickbooks, Active Campaign) and supporting the last releases (SendGrid, Facebook Ads, Google Adwords) we’re trying to enjoy our families in the summer months. So should you, life is short.

The Presidential nominations are over (whew!), the Olympics are beginning (yikes for Rio!) and summer is in full swing. Thanks for the support, rest-assured even from a beach or camping with our kids we are still checking in hourly if not more to make sure all of your dashboards are up and running.

Cheers and happy summer!

Startup Lessons Learned: Customer Segmentation Exercise, Fun!

The other day, I realized with all the hubbub that happens in our small & growing startup Dasheroo, that I had lost touch a bit with just whoour customers are. Sure, I could talk about “here’s how many we have, this % are agencies, that % are consumer brands, here’s the ARPU and this % are outside the US” type crap, but it bugged me I hadn’t done a deeper dive for awhile.

Dasheroo customer segmentation research in Google Sheets

I put our customers into Google Sheets on my Dasheroo dashboard so everyone could see!

So on yet another gorgeous San Francisco day I hauled my dog Dwight, a beer and my MacBook out on our patio for a little customer segmentation project. I took 100 random paying customers that are from our ‘sales assisted’ category, meaning they pay us enough $$ to have a sales person work with them, as opposed to our lower ARPU ‘auto convert’ biz. Not saying the auto convert biz is in any way less important, but I needed to focus where to point or limited resources for outbound sales efforts.

One by one, I hit their websites and built on a Google Sheet with a simple ‘who – where – what’ layout; the customer name, where they are based, and what type of business they are.

OK, maybe it took a beer or so more to complete but as I progressed I got more and more excited. I mean, it’s so easy to go from one sale to the next, always focused on ‘the next’ that you can begin to miss some key trends and customer profile types.

In this case, a few really interesting, and I hope actionable, trends were spotted with my customer segmentation research:

  • Agencies that target the SMB market. Regional in nature, and a good concentration in the Southeast US and Australia
  • These agencies aren’t ‘we’ll do everything for you’, a huge % focus on social media and influencer campaigns and measurement only.
  • A few decentralized departments of pretty large, well known consumer brands.

So what? Here’s what: we’re gonna re-focus our lead gen budget with these geos and a closer match to the ‘social media’ agency markets vs. a more broad targeting. Next, we’re thinking about launching an outbound effort to “land & expand’ to grow within the large consumer brands, working our way across geographic departments first and hopefully further across functional departments within each location!

Sure, I could have ditched this project off to someone else. But sometimes rolling up your sleeves and getting your hands a little dirty with customer segmentation can really help put your focus back where it matters. Next, a similar exercise with our auto convert buyers!