Network Marketing Activity Tracking


After going through training with quite a few different marketers who specialize in training Network Marketers, I came up with my own conclusions about Network Marketing Activity Tracking. Most of these are small modifications of material taught by Frazer Brookes, Marina Simone and Brandy Shaver.

There appear to be four different types of tracking that need to take place.

  1. Network Marketing Activity Tracking – Counting Daily Actions
  2. Tracking The People in Your Funnels – here is a link to a post about using a simple to use tool called TRELLO to track your prospects: https://halepringle.com/track-prospects-with-trello-network-marketing-3
  3. Tracking the Date/Time When You Are Scheduled to Do Things – Use a Calendar like Google Calendar
  4. Tracking the steps in your daily Method of Operation (DMO). – I use the columns in this tracking sheet to track my DMO.

1. Network Marketing Activity Tracking – Counting

A common theme among the trainers I follow is that for the most part you need to track Activity not Results. We can control our activity and as we take more and more action, we will get betters. Skill Times Activity = Results. When we set result-based goals and just track results, it is very easy to become discouraged, especially when we are just starting and our skills are weak. The tracking sheet I downloaded from most of the trainers tended to be comprehensive and frankly overwhelming. (I’ve been a researcher and “numbers guy” for over 40 years and when I feel overwhelmed, I KNOW most people feel the same way.) In a recent training with Frazer Brooks, the participants suggested things to track and we quit at 19. He broke it down to those we really needed to track and ended up with six. He was using a paper planner to track these. I wanted a spreadsheet and while I could have done it myself, I went to Fivverr.com and for $20 had what I wanted in one one day.

This sheet covers five years and is pretty easy to expand a few years from now. You can also add a column and copy/paste another column to add something else you want to track.

The questions and the left are for Active Prospecting. Starting with # of Lives the questions are more for Passive Following building.

  • Date – There is one row for each day. There are two extra rows between the Weeks (shown in yellow) and two rows between months (shown in magenta).
  • Day of Week – Three letter abbreviations
  • 333 day1 – If you are using the 333 method of prospecting, this column would be used to trac =thow may people you started the process with. I’m not going to go over the 333 method here, even though it is the process I currently use..
  • FAM – This stands for Find a new Facebook Friend, Add them as a friend and Message them. For active prospecting this is probably the most critical activity you can do. There are a ton of scripts available. If you would like to see some message me
  • Asked Question – Building relationships is critical in a Network Marketing business. At some point you need to ask the person is they are open to looking at your product or your business. The coumn counts how many times you actually Asked the Question.
  • Used Tool – The preferred tool these days appears to be Add/Tag/Message (ATM) groups. You friend a person, then you Add the Person to the Group, Tag them in a comment under a video or post that is most suited for their needs and then you Message them to continue the process of making a sale or signing up a new partner. Your tool of choice will depend upon your company. It might be a recorded video, a house meeting, a hotel meeting, a Zoom call or something else.
  • Yes/No – You got a yes or a No when you asked the question.
  • New Customer – Count your new customers
  • New Team Member – Count your new sign ups.
  • Happy Birthday Messages – how many
  • Pre-enrolled – this is not common. You can use it for something else –
  • Commission – you will take this from your company site and will only go in the Month End row.
  • # Lives – Count the number of FB, Instagram or YouTube Lives you did during the day.
  • Story Posts – How many Story Posts were made
  • Product Post – Did you do a post selling the product>
  • Insp Posts – How many Inspiration posts were made.
  • Ed Posts – Educational Posts
  • Ques Posts – Ask a Question Posts
  • Life Posts – Posts about your life
  • Curiosity Post – Count the number of Curiosity posts you did.
  • Extra 1 – Replace this with what ever you want
  • Notes – Use this to explain why a day might be have bben special – good or bad.

At the end of every week and every month there are two special rows. The End-of=Week rows are highlighted in Yellow. The Endof Month rows are highled in magenta.

  • The sum of month’s tallies for each column.
  • The Average Per Day – the Sum divided by the number of days in the week or month.

Get Your Own Copy

Here is a link to make a copy of this spreadsheet is Google Sheets – a free spreadsheet that runs in your browser. If you have a Gmail account, you have access to Google Sheets. Make Your own Copy

Using the TRACKING SHEET

Automatically Move the Cursor to the Current Date

As you get further and further down the sheet, the time it takes to scroll down to the row containing today’s date takes longer and longer. This sheet has a way to help you with that issue. Here it is.

In the upper left corner there is a button that says “today()” When you click on this button, the cursor will move down to the row with today’s date in column A. Easy Peasy.

NOTE: It takes a while for the sheet to load and an automatic script to find the row with today’s date in it. Watch for the “Working” message in the top center of the page. Don’t press the TODAY() button until the Working message goes away.

THE WORKING MESSAGE

THERE IS ONE OTHER CATCH

The first time you press the button there are a few scary message that you agree to. They are the standard messages that Google displays for any new script. They are nothing to worry about here. Here are the screens:

Press the CONTINUE Button

Choose your account.

Yes, the script has not been verified. I’m not even sure how to get Google to verify a script. I do know that the script has 4 lines and a formula. I understand every bit of the code and there is nothing malicious in there. Click the ADVANCED BUTTON.

This is a standard message. The only thing this script does is read your sheet and move the cursor.

Press the ALLOW. button.

YOU ONLY NEED TO DO THIS ONCE.

A TIP On Daily Use

During the day I keep a notepad (actually EditPad Pro 7) open with a column of prompts. During the day I use the notepad to record the number of friend request, follow ups, etc. that I do. At the end of the day, I transfer these numbers to the Tracking Sheet described here. It is much faster than waiting for the Tracking Sheet to load and get to the correct row.,

EXAMPLE

Add Your Own Columns

The best was is to copy an existing column. That way all of the formulas are copied at the same time.

#1 – Click the little letter at the very top of the column you want to copy (It will turn black). That will highlight the column
#2 – Right click and choose Copy (The entire column is now in your clipboard. Right Click again and choose “Insert 1 right”

Click on the letter at the top of the new column (it will turn black) so that the column is highlighted. Click you choice of the PASTE options.

Now all you need to do is change the A cell which contains the description of what the column contains.

Drag the Columns to an Order That Suits You

Click the litter and it will turn black. Hold the mouse key down and you will see the hand cursor icon. Goliding the mouse key down drag the colmn left or right.

2. Network Marketing Activity Tracking – Tracking Prospects

Here are three ways to track People

First Sticky Notes wall.

Create the following Columns on the wall

Fam Asked Tool Follow No Yes
______Question_______Ups

You create a sticky note for each person. Put their name, the date you added them as a friend and notes about them on the note. Move the note from one column to the next as they move through the process.

Second Trello

The columns are the same. Each person is a “Card.” You add ifo to the card and drag them from one column to the next as they move through the system.

Third Remember the Milk

This is a system I used to use. I’ve written some blog posts on it before (See Here) I currently use a Trello board because that is easier for beginners to understand and use.

We use the same system

Obviously this is a more complicated system, but it will create an email and remind me each day what is due that day.

3. Network Marketing Activity Tracking – Tracking Time

Frazer uses Google calendar and his phone’s alarm system to record when he is due to make a call, give a presentation, etc.

His quote is “Your Calendar is you Boss.” He strongly suggests that you create time block for each day where you carry our specific activities like prospecting or follow-ups.

4. Network Marketing Activity Tracking – Tracking your DMO

Right now I tracim

Right now I track my DMO using the columns in the tracking spreadsheet described in this post.

Some people use a Trello Board. I have used an app on my phone called List Daily List. This app allows you to set activities. You check them off each day, I saves the results for 90 days and it rests the list every day.

I’ll write more about this later.

Short, sweet and hopefully simple – these three systems let you track your activity, your prospects and manage your time.

Until Next Time. Remember, You Are One Decision Away…! Oh Hale Yes
When you decide you need more information, check out the sidebar links —->>

Print Friendly, PDF & Email

Trackbacks

  1. […] THis app helps you track the activities you need to carry out. It does not track how many people you talked to, new friends you added, etc. Here is a post that shows a Google Sheet where you can track these counts . Tracking Network Marketing Activities […]

Speak Your Mind

*

CommentLuv badge

This site uses Akismet to reduce spam. Learn how your comment data is processed.