Network Marketing: Tip #3- Keeping Your Call Log Organized
Remember Cold Calling is challenging enough without any further complications to reduced your effectiveness as a Network Marketer. Do you have trouble keeping track of who you’ve called when, what they said, or if they answered the phone, if you have to get back to them, or where you got that contact in the first place? Do you need to report on your activity to someone on a regular basis?
Join the club! You, like me, need to keep a call log.
You probably have contacts coming in from a few places, in a variety of formats. Maybe most of them come in from your auto-responder service, but those print out in single sheets of paper for each contact. And I bet that you, just like me, scribble your notes around the edges of those papers.
Join the 21st century—I did! You need to start a Microsoft Excel workbook for your call log. Here’s how!
Open Excel and save your new blank workbook as Call Log 09, or whatever year or month you wish. Now customize your columns and rows. Row 1 (going from left to right, horizontally) will contain your category headers. You can put these in any order that works for you, but I like it this way:
Column A, Row 1: Time Period of Report
Column B, Row 1: Contact Name
Column C, Row 1: Date Called
Column D, Row 1: Contact Email
Column E, Row 1: Contact Phone
Column F, Row 1: Time Zone
Column G, Row 1: Company
Column H, Row 1: Contact Attempts
Column I, Row 1: Sent to Call (or other action)
Column J, Row 1: Notes
Column K, Row 1: Closing Attempts
Column L, Row 1: Contact Address
Now that you have each of those cells filled in with your headers, it’s good to color them, so you can refer easily to whatever piece of information you want. Click on Column A Row 1, and drag your mouse across that row, all the way to Column L Row 1. Keep that row highlighted (don’t click on it again) and do click on your fill color icon in the tool bar at the top of the page. Choose a color and click on it. Maybe you would also like one section to have a special highlight or its own color, so you can see it instantly—Date Called, maybe. Just click on that one cell, click on the fill color icon again, and choose a different color. And, of course, you can bold the type in your header if you wish.
Depending on where your contact information comes from, you will have to either manually enter it, or (far more preferably) get it downloaded from your auto-responder on a daily basis. This is easy to set up with your auto-responder—if you run into trouble, use their live online help service. You will need the name of the Excel file you just created.
You will probably want to keep a separate worksheet for each month, or whatever your reporting period is. All you have to do is add a worksheet to your file: Click on the Insert drop-down menu, and select Worksheet. Then copy your original formatted sheet to the new sheet: Click on the cell that is the axis point for both the columns and the rows—this is at the top left corner of your worksheet. Now your entire worksheet will be highlighted, and you can either right-click and select Copy, or click on the Copy icon in your toolbar. Go to your new worksheet—the locater tabs are at the bottom of the workbook—click on that same axis point cell again, and either right-click and select Paste, or click on the Paste icon in your toolbar. Voila! Now all you have to do is rename each worksheet so that it has a separate name for whatever time period you want (January 09, say, or 9/1 – 9/14): Go to the little tab at the bottom of the page that says Sheet 1 (or Sheet 2, etc.), right-click on it and select Rename. Now you can type in whatever you choose to call that individual worksheet.
You can email your worksheet; you can print it out and fill in by hand; or type in your updated information. Remember, though, if you are printing, be sure to format your file so that it will look okay when printed. Click on the File drop-down menu, and select Page Setup. You will probably want to select Horizontal for Orientation, and you can also adjust your Margins, etc. here.
Imagine how productive you’ll be, and how much time you’ll save!
Good luck!
Mark H. Pepper is a Network Marketing Growth Specialist who has been helping people streamline their mlm-home based businesses to ensure good return on their investment. Mark takes great pleasure in helping and assisting other entrepreneurs in growing their business utilizing the technologies available today to ensure a long lasting successful marketing venture……… You can contact Mark at his office: (928)239-5070 Article Source:http://www.articlesbase.com/marketing-tips-articles/network-marketing-tip-3-keeping-your-call-log-organized-1570554.html
If growing your business is important to you visit: http://www.mlm-growthdynamics.com/av/
