The Entrepreneur Forum | Startups | Entrepreneurship | Starting a Business | Motivation | Success

Creating a Simple Dashboard Using Google Sheets

Andy Black

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,035
47,950
4,306
Ireland
A few people asked about simple dashboards in Google Sheets. This could equally be done in Excel, but I prefer to use Sheets as it's saved in the cloud and can be shared.

This might not be what you're expecting. I want to see numbers, not fancy graphs (and especially not pie charts!).

This video shows how the data was formatted to be uploaded into this sheet:

What's your takeaways?

Will you do anything different?


View: https://youtu.be/Tvm6n6OfV-A
 

Don't like ads? Remove them while supporting the forum. Subscribe.

  • Thread starter
  • Moderator
  • #3

Andy Black

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,035
47,950
4,306
Ireland

million$$$smile

Platinum Contributor
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Summit Attendee
Speedway Pass
Dec 25, 2012
698
4,783
1,134
Midwest
I really like the idea that it basically 'forces' the business to interact daily by inputting the number and types of inquiries they are receiving from their ad spend. I would think it would quickly identify where and how to tweak that ad spend.
Many times a business owner is just out there 'working' in their business, and don't take the time to work on their business. By having your client (business owner) interact daily in the input, it ensures that his participation will help to eliminate the end of month questions such as is this really worth it and am I really getting that ROAS?

Daily client participation is the key to keeping the client.
My key takeaway as a business owner is:
If I'm going to spend the money, I can't expect to just turn over $$$ to an agency and forget about it until the end of the week, or month or whenever.
If I were an agency, I think I'd need to have a contract where it spells out daily client participation to insure that the client remains actively involved.

Busyness can often get in the way of business.
As an agency, I would want to know the pulse of the clients attitude on how the ads are doing. This daily participation through a shared dashboard helps the agency to stave off any possible negativity from the clients that the ads aren't working.

It is as important to the agency to collect data on the clients attitude as it is to collect data on the ads.
If that is done, then the agency will have the client for the long term. There should be little turnover in
clients, because that client response becomes as important as anything the agency is doing.

Tweaking isn't just done to ads.

It also takes some of the pressure off the agency due to the fact that mutual participation on the dashboard is mandatory.

I love the way you can scan down through the data rather than across horizontally. So much quicker!
Interaction and participation from both sides is key. I think developing a shared dashboard is an easy way to gauge a lot more than just ad spend.

I like that it is just numbers. It keeps it simple.

Hope this makes sense.
 
  • Thread starter
  • Moderator
  • #5

Andy Black

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,035
47,950
4,306
Ireland
I really like the idea that it basically 'forces' the business to interact daily by inputting the number and types of inquiries they are receiving from their ad spend. I would think it would quickly identify where and how to tweak that ad spend.
Many times a business owner is just out there 'working' in their business, and don't take the time to work on their business. By having your client (business owner) interact daily in the input, it ensures that his participation will help to eliminate the end of month questions such as is this really worth it and am I really getting that ROAS?

Daily client participation is the key to keeping the client.
My key takeaway as a business owner is:
If I'm going to spend the money, I can't expect to just turn over $$$ to an agency and forget about it until the end of the week, or month or whenever.
If I were an agency, I think I'd need to have a contract where it spells out daily client participation to insure that the client remains actively involved.

Busyness can often get in the way of business.
As an agency, I would want to know the pulse of the clients attitude on how the ads are doing. This daily participation through a shared dashboard helps the agency to stave off any possible negativity from the clients that the ads aren't working.

It is as important to the agency to collect data on the clients attitude as it is to collect data on the ads.
If that is done, then the agency will have the client for the long term. There should be little turnover in
clients, because that client response becomes as important as anything the agency is doing.

Tweaking isn't just done to ads.

It also takes some of the pressure off the agency due to the fact that mutual participation on the dashboard is mandatory.

I love the way you can scan down through the data rather than across horizontally. So much quicker!
Interaction and participation from both sides is key. I think developing a shared dashboard is an easy way to gauge a lot more than just ad spend.

I like that it is just numbers. It keeps it simple.

Hope this makes sense.
Yep, it makes perfect sense and it’s very interesting feedback. You’re more focused on WHAT is being done and WHY, rather than HOW it was done. I like that someone who thinks like you got value from the video, and how I hope the HOW-TO techies will get value too.

In this case it's a Weekly Trading sheet. I think daily trading is too often, and monthly trading isn't often enough. We do have a comms channel open with each client throughout the week and encourage feedback in there. Even a small sniff of insight from the business owner can help us dial things in.

We update the numbers weekly, but the media buyers add in their high level changes daily to the sheet so we can see what was done each day in a week.

When I was in a team spending €120k a day each of the 35 team members had their own Daily Trading sheet that they updated. That data was fed into the master sheet for the managers and business owners to work from.

And yeah... I'm getting to the point where prospects have to agree to update their side of the sheet before they become a client. Delegate, don't abdicate.
 
  • Thread starter
  • Moderator
  • #7

Andy Black

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,035
47,950
4,306
Ireland
Nice work Andy.
What do you use to record your videos? Software / dedicated microphone?
Camtasia and the simple headphone with inbuilt mic that I use to chat to people.
 

Sponsored Offers

MARKETPLACE 7 Days To Freedom: From Wantrepreneur/Wage Slave To Freelancer
I attended the live session, really loved it! It gives some useful and practical tips on how to...
  • Sticky
MARKETPLACE Lex DeVille's - Advanced Freelance Udemy Courses!
Three things: 1. Discord Chat is open. Click here for free access. 2. New YouTube Channel...
  • Sticky
MARKETPLACE Fox Web School "Legend" Group Coaching Program 2021
Its for students who have joined. Did you sign up? Hey Rob, been watching your infoproduct and...
Introducing MJ's Personal Unscripted Network, Join Now for FREE!
Any chance to make it available outside of US? It has been available outside of the US on...
MARKETPLACE Not sure how to start? This free book will teach you how to build a successful web design business
If there’s one thread I see repeated over and over again on the forum, it goes like this: “I...
  • Sticky
MARKETPLACE You Are One Call Away From Living Your Dream Life - LightHouse’s Accountability Program ⚡
Thanks for clearing that up. What do you recommend for those who are still in the process of...

Forum Sponsor

Over 100 Fastlane Students
More Details...

New Topics

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Monthly conference calls with doers
Ideas needing execution, more!

Join Fastlane Insiders.

Top Bottom