NBS – What gets measured improves!

Lean Dmaic Business Improvement Concept Wooden Step With Text D Lean Dmaic Business Improvement Concept Wooden Step With Text Define Measure Anal
© PixelRockstar.com

Why record your activity?

> Know how active you actually have been
> Measure your results against the expected average
> Fine tune with your coach
> Improve consistency
> Duplicate your example

What activity gets recorded and where?

When you access the Daily Activity sheet of your Activity Workbook, can enter your Activity by clicking the button shown in the following screenshot

This will allow you to enter your activity as shown in the columns in the following screenshots

Activity: Message 1: Connection Requests (Column B)

  • This is the number of connection requests you sent out that day
  • This is automatically updated from the PBO sheet – however, it is wise to over-type the number in case you need to clear your PBO results.

Activity: Message 2: Thanks for connecting (Column C)

  • How many Thanks for Connecting messages did you send out today?
  • Record that number in Column C

Activity: Message 3: Which date suits you best? (Column D)

  • This can be something like:
    • Would it work for you to attend one Monday in the next couple of weeks?
  • Note that this counts as a “Which date suits you best activity”
  • How many of these did you send today?
  • Record that number in Column D

Activity: Calendar invites Sent (Column E)

  • This activity will normally be comprised of
    • (1) A date confirmation message in LinkedIn and
    • (2) Sending an electronic calendar invite
  • How many of these did you send today?
  • Record that number in Column E

Activity: Number of new personal attendees (Column F)

  • This is the actual number of people you had attend the Hub – the goal is to have on average 2 people attending per week
  • That could be 6 people one week and none the next!

Names of your new (Personal) attendees (Column H)

  • This does not include the people that the committed builders in your team have brought.

Number of new (Group) attendees (Column I)

  • This is the number of NEW bums on seats at Hub meeting outside of those you have personally invited

Number of repeat (Group) attendees (Column J)

  • This is the total number of people (including your personals and their personals) who have attended a Hub meeting more than once.

People to focus on (Column K)

  • These are the people who are attending or have attended several times
  • They are potential people worth investing time with by showing them how to use the Hub for themselves
  • Thus duplicating your efforts


If you accidentally over-type a cell (such as the date in Column A), you can easily Undo that action by either pressing the back arrow at the top of the screen or by pressing Ctrl-Z. You can do this a number of times to undo the last ‘n’ recent entries.

Also, let’s say you discover you have made a real mess sometime in the last couple of days – you can easily go back to a prior version.

You can go back to a previous version by going into the File menu, hover over Version History then select “See version history”.
Then on the right of your spreadsheet, you will see the past history.
You can select one of these versions and have a look at it.
If you want to go back to that version you have the ability to do so.
Click Here for the documentation from Google – it’s pretty good.

Important Note

Goal setting works!

  • It is amazing what actually gets achieved when you have a number to go for
  • If you are serious about doing 10,000 steps a day and you are measuring your steps with a pedometer, you will do a lot at the end of the day to take it from 8,000 to 10,000!
  • The same applies here!

At the top right of your Daily Activity sheet, you will see a summary of your activity for the last 6 months as shown in the following screenshot

Here’s what “Your Average %” means:

  • Thanks for Connecting
    • This is the number of people accepting your connection request as a percentage of the number of people you have attempted to connect with
  • Which Date Suits You Best?
    • This is the number of people you ask: Which Date Suits you best (to attend a Hub) as a percentage of the number of people you connect with
  • Calendar Invites Sent
    • This is the number of people who accepted your calendar invite to attend a Hub as a percentage of the number of people you asked: Which date suits you best?
  • Hub Attended
    • This is the number of people who attend as a percentage of those who said they would come

Allow for the lag!
Increase your attendance rate

When you first start there is likely to be a lag.
For example, people will often say they will come next Monday but something ‘more important’ comes up.

That does not mean they will not eventually attend next week or some time in the future.

Most importantly, you can increase your attendance rate by:

(1) Sending a message several days prior to the Hub letting them know you have arranged for them to meet some others on the night (be respectful of their time)

(2) Sending a message (SMS is good) letting them know some administrative details such as plenty of parking around the building, ask the person at the desk to point me out, go up the stairs at the front to get to the function room.