Using Remember the Milk as a Basic CRM Tool – Bulk Loading From Aweber


Please Comment RTM and CRM - A powerful toolBefore you think CRM, think ToDo List.  In a earlier post I have a quick overview and review of Remember the Milk (RTM) as a ToDo list package.  It is very powerful and has grown up over time so that it now has almost every feature you might need.  I love it.  For $25 as year it will synch everything between your smart devices and your desktop. RTM wasn’t designed to be a CRM tool, but it handles the “Customer Relationship” tasks very well.  You have to cheat a little to get meaningful reports, but so far it has worked very well for me. This article is split into two sections.  This section focuses on bulk Moving Leads out of Aweber (an autoresponder company) into Remember the Milk. The other section talks about using Remember the Milk as a CRM tool once you have leads in Remember the milk.  You can view that article here:  https://halepringle.com/using-remember-the-milk-as-a-basic-crm-tool/ Background:   Here is my situation: When I originally wrote this I was running a Lead Co-op using Internet Marketing strategies to generate leads for the Network Marketing business I own. Step #1.   I start with a fairly standard Squeeze Page and an Ethical Bribe:

Squeeze Page and eBook on Network Marketing RTM- Data Source -Squeeze Pagehttp://HalePringle.net

Step #2.  I drive traffic to this page using Solo Ads, PPC, Ad Swaps, JVGiveaways, etc.  (2020 update: these are lousy sources for people serious about changing their lives/  Most of the leads I generated didn’t have two pennies to rub together.) Step #3.  The information about the leads is collected in AWeber Step #4.  AWeber shines at sending pre-set follow-up emails and one-time broadcast emails.  I use AWeber to send the leads a  series of pre-created emails about Dr. Hale, Network Marketing, the company I work with, etc. Step #5.  I need to track the results from my various ad sources and my phone calls, one-on-one emails etc. Step #6.   I want to call those people who left their phone number Steps 5 and 6 can’t be done in AWeber and that is where Remember the Milk (RTM) comes in. I’m not going to try to write out a full manual, but I will show you how I use RTM to help me handle reaching out to prospects and leads.  This is a Customer Relationship Management (CRM) function that usually you pay a lot for. I’m going to walk you through my process. NOTE:  You can use RTM as a CRM even if you aren’t using AWeber.  A lot of what follows is how I convert the AWeber export into something I can bulk import into RTM.   You can certainly do the bulk import part without AWeber. Note:  Scroll down to the header that says COPY/PASTE INTO NOTEPAD if you are note using Aweber. BTW – I am assuming that Excel is fairly new (or completely new) and I’ll try to explain each step in detail.  You can Google for deeper explanations if something is confusing.  If that fails, contact me and I’ll help you. 2020 Update.  If you have a Gmail account (and they are free tp create), you have access to Google Sheets,  Google sheets is a very powerful online spreadsheet system and it will do everything I describe here. I collect emails addresses and phone number from squeeze pages on my web sites.  Some of these leads I want to follow-up with using the phone.  Here is how I do that.

                   Pick the List You Want To Export RTM and CRM Pick a List

#1 – Pick the list you want

#2 – Click on Manage Subscribers (note that the drop down has hidden the count J .  It is much higher than “3”)

Click on the Export as CSV Button RTM and CRM - Click on the Export Button

At the bottom of the screen there is an Export as CSV (Comma Separated Values) button.  Click that.

Open the File in Google Sheets, Excel (or an equivalent) AWeber - Open in Excel What I want to do is create a text file formatted so that I can insert my rows into RTM automatically. Here is what I want is lines that look like this. Pattern:  Name phone state http://email_address Example: Joe smith 555 555 5555 FL http://myemail@gmail.com This will create a task called “Joe Smith 555 555 5555 FL and put the email address into a slot called URL.  I cut and paste the phone number into Skype to make calls.  (I do have the $60/year version that lets me have unlimited calls in the US and Canada.  I have modified my Skype setting so that it reports my cell number as the Caller ID when I call people.   I use the State info to tell me what time zone the people are in.

The Process: AWeber to Spreadsheet to Email to RTM

NOTE: If you are not using AWeber, you can skip to the other article  https://halepringle.com/using-remember-the-milk-as-a-basic-crm-tool/ You can also scroll down to the major header “Copy and Paste Into Notepad”  if you have a bunch that you want to import. Here are the steps I go through to get my text file.  There are a number of steps here, but if you know Excel (or are willing to learn) they become pretty natural and they take MUCH less time than manually entering the information for each lead.
  1. Reformat the Phone Column (See Below)
  2. Find your last version and sort on column D.  Figure out the last leads in that group (If you don’t know how to sort, make sure the “Home” tab is clicked and then click on the column header for Column D  – it has a “D” in it.  That will highlight the whole column.  Now up in the right corner of the menus is a button called “Sort and Filter”.  When you click on that you will be offered an option to expand the sort to include the whole table.  You want to do that.  Sorting one column by itself would mess up the table and you wouldn’t be able to see when an individual signed up.)
  3. Take your current version and sort on column D.  Delete everyone you already have in the earlier version. (Highlight the whole area and right click in the area and choose “Delete the entire row” from the options offered.)
  4. Reorganize the columns so that you end up with name, phone, region, email and country at the left side of the table.  (See Below)
  5. The “Region” column contains the “State” in the U.S.  It will be blank for non-USA.  Manually insert something like XX or UK or Foreign in those that are from countries.  These are ones you don’t want to try calling on the phone.
  6. Insert a blank column to the left of the email column (Click on the header for a column so that the whole column is highlighted.  Right click and choose the “Insert” option.)
  7. Click on the Formulas Menu option.  Click on “Insert Function” at the very left.  Choose “Text” as the Category and Concatenate at the function.  Press OK.  Type http:// in the text 1 box and +F1 in the second text box and then click OK.  You should have a column with the email addresses preceded by http://    BTW  I know that this should really be mailto:\\  but RTM will put this into a slot called URL and recognizes it as an email if you click on it.
  8. Highlight the name, phone, region, email columns and click on Copy button.
  9. Paste these into Notepad.
  10. Manually remove spaces from any lines that are very long.
  11. Copy and paste all the lines into an email and send it to RTM.  You can find the email address in RTM under “Settings” à “Info.  Use “inbox” as the Subject line of the email.   I’ll talk more about what I do inside RTM later.
  12. Save the File – use a name that tells you the source and the date.  You need to be able to find this file later.
Here are some of the steps in more detail.

Make Columns Wider in Excel

An important feature is how widen a column.  The default is about 10 characters and that isn’t enough for columns like the Email Column.   If you mouse over the header of a column, you will see the cursor change to an icon with arrows pointing left and right when you go over the line separating columns.  Hold the left mouse button down and drag the icon to the right to make the column wider and to the left to make it narrower.

Reformat the Phone Number Column

Reformat the Phone Column RTM and CRM - Reformat the Phone Column

Click on the T Column header.  That should highlight the whole column.  Right Click somewhere on the column and choose the “Format the Cells” option.   This screen will pop-up.  Choose “Special” and “Phone number”

Moving a Column.

To Move a Column
  • Click on the header which highlights a whole column.
  • Click Ctrl-X or right click and choose CUT.   You will see a dotted line around the whole column.
  • Click on the header of the column to the right of where you want the original column moved.  This will highlight the second column.  The original column still has the dotted line around it.
  • Right click on the column and choose “Insert Deleted Cells

Move a Column RTM and CRM - Move A column

#1 – Click on the area with the A to highlight the whole column.  The click Ctrl-X or right-click and choose CUT #2 – Click on the area for another header – like D here.  This will highlight a second column. #3 – Right Click on the column and choose the “Insert Cut Cells” option.  The column will move.

Modify to Email Address to include http://

Insert a blank column to the left of the Email Column RTM and CRM Create a blank column

#1 – Click on the header (near the D) to highlight the whole column)

#2 – Right Click on the column and choose “Insert”

Excel will insert an empty column to the left of the one you highlighted.

Put http:// at the beginning of each email address. RTM and CRM  Concatenate http:\\ and email

Not Shown – Click on the header of the Empty Column you just created so that it is highlighted.

#1 – Choose the Formulas Menu option

#2 – Click on “Insert Function”

#3 – Choose “Text” as the category

#4 – Choose CONCATENATE – as the junction

#4 – Click on OK

Finish the Concatenate Formula RTM and CRM - Finish concatenation

If it just enters the value for the first Cell Do this.

Copy Formula to The Rest of the Column RTM and CRM  Copy Formula to Entire Column

#1 – Click on the cell with the formula in it and press Ctrl-C or right click and choose Copy

#2 –  Click the cell below the cell with the formula and drag the mouse down to highlight the rest of the column

#3 – Click “Insert Copied Cell”     The “+” you put in front of the +E1 tells Excel that it should change the number to match the row number when you do things like this copy.  So Row 2 becomes +E2, three becomes +E3 etc.

Copy and Paste Into Notepad (or another text editor)

NOTE:  Start here is you are not using AWeber. BTW  You can enter prospects into Remember the Milk one at at time.  You don’t have to bulk import. Use your mouse to highlight the first four columns (name, phone, region and the modified email address column we just created).  If you are not using AWeber, you may copy and paste this data from somewhere else. Copy and paste into a Notepad file Manually remove spaces in long lines.  Your email will wrap very long lines.  RTM will see that as two lines and create two tasks.  Neither one will be complete. Again you want lines that look like this (as one long line) John Jones 555-555-5555 CA  http://hisemail@gmail.com You don’t have to have the elements in this order.  I just like to have the name first.

RTM Email Address to Send “Tasks” to

Import Email Address RTM and CRM  Find Email Address to Send To

#1 – Click on Settings

#2 – Click on Info

#3 –  Copy the “Import Email Address

You need to put this into your email system as a Contact.  I called mine “RTM Import”.

Send Tasks to Remember the Milk

  1. Start an email to your RTM Import address
  2. Enter “inbox” in the Subject Line
  3. Copy and paste the contents of your Notepad into your email
  4. Erase any extra lines including your signature block.  You are going to get one task per line, so make sure that each line is one of your leads from AWeber.
  5. Send the Email  You will find these new tasks in Remember the Milk;
Go to This article to see what I do once new tasks are in Remember the Milk.

I have shown you how to export a list from AWeber into Excel. We went over how to reformat the spreadsheet. We looked at how to move the columns we need from the spreadsheet into a text file and edit that. We then emailed the list to RTM to create a bunch of tasks at one time. The next step was to process the new leads and put them in the proper tab. I then went over how I make calls and process them. At the end we talked about reporting.

Moving Several Leads into Remember the Milk at One Time

In the previous article I covered getting a properly formatted list out of Aweber.  In many cases you may want to create a text file of prospects and enter all of them at one time.  I;m going to start there.

The Process

What I want to do is create a text file formatted so that I can insert my rows into RTM automatically. Here is what I want is lines that look like this. Pattern:  Name phone state http://email_address Example: Joe smith 555 555 5555 FL http://myemail@gmail.com This will create a task called “Joe Smith 555 555 5555 FL and put the email address into a slot called URL.  I cut and paste the phone number into Skype to make calls.  (I do have the $60/year version that lets me have unlimited calls in the US and Canada.  I have modified my Skype setting so that it reports my cell number as the Caller ID when I call people.   I use the State info to tell me what time zone the people are in. Note;  I purchased an upgrade to Skype.  It lets me make calls anywhere in the US and Canada for free.  I went into the settings and changed the phone number that appears to the person I’m calling.  Their caller ID shows my cell phone number.   Using Skype this way allows me to use a headset and is easier for me that using a cell phone to make lots of calls. When I sit in front of my computer, my hands want to be on the keyboard. Making Calls with Skype lets that happen. I can also use Skype’s “Recent Calls” list to count how many calls I’ve made today.

Copy and Paste Into Notepad (or another text editor)

NOTE:  Start here is you are not using AWeber. BTW  You can enter prospects one at at time.  You don’t have to bulk import. Use your mouse to highlight the first four columns (name, phone, region and the modified email address column we just created).  If you are not using AWeber, you may copy and paste this data from somewhere else. Copy and paste into a Notepad file Manually remove spaces in long lines.  Your email will wrap very long lines.  RTM will see that as two lines and create two tasks.  Neither one will be complete. Again you want lines that look like this John Jones 555-555-5555 CA  http://his-email@gmail.com You don’t have to have the elements in this order.  I just like to have the name first.

RTM Email Address to Send “Tasks” to

RTM and CRM  Find Email Address to Send To

Import Email Address #1 – Click on Settings #2 – Click on Info #3 –  Copy the “Import Email Address

You need to put this into your email system as a Contact.  I called mine “RTM Import”.

Send Tasks to Remember the Milk

  1. Start an email to your RTM Import address
  2. Enter “inbox” in the Subject Line
  3. Copy and paste the contents of your Notepad into your email
  4. Erase any extra lines including your signature block.  You are going to get one task per line, so make sure that each line is one of your leads from AWeber.
  5. Send the Email.

Final Preparation Steps In Remember the Milk.

The tasks will arrive in the Inbox, which is not where you want them to be.   However it does let you finish your prep work.   Here are my final steps.
  1. Select ALL (will put a check mark on all of them)
  2. Tag them all with a tag that describes the source (e.g. solo-9-13 for a solo ad run on 9-13)
  3. Make them all due on a particular date.
  4. Move them to the LIST where you want them.
Here are some screen shots

Send the Email:  Subject Line Inbox

RTM and CRM  Send Email to RTM
Email to Inbox #1 – Send to the email address we got from Settings –> Info #2 – The word in the Subject Line indicates which Tab to put the tasks in #3 – Wrapped lines will show up as two tasks.  It is best to not have any of these!

Once The Tasks are in Remember the Milk

RTM and CRM  Tag All
Select All – Tag – Due Date Not shown – Click on the Inbox  LIST on the left #1 – Click on ALL (this will check the boxes for all the entries) #2 – See the checks and the lines turn yellow background #3 – Click on the little icon beside the work “Tag” and enter a code for the source of these leads. #4 – Enter a date – it will be added to all of the leads.  You can enter something like “Wed” and RTM knows that is Wednesday and RTM will find the date. There are lots of other things I can do with RTM.  This just scratches the surface, but it is a pretty good scratch  🙂

Remember the Milk  was not designed to be a CRM tool, but it does pretty well.

Until next time, you have a Great Day!  Oh Hale Yes!  🙂

Dr Hale

↓ ↓ If this post gave you some ideas – Go ahead & comment below.  ↓ ↓

Hale Pringle

Hale Pringle Ed. D.

Hale Pringle – Hale Yes! Skype hale.pringle Email: Hale@HalePringle.com  Connect with me on  Facebook or Twitter  
Print Friendly, PDF & Email
About Hale Pringle

Dr. Hale is an Internet Entrepreneur and Network
Marketing expert. His greatest pleasure is
helping people and he does just that, drawing
upon the immense resources that he has gathered
over the years in his unquenchable thirst for
knowledge.

Dr. Hale lives in beautiful, sunny Florida with
his wife, two dogs and a cat. His four children
are grown and are scattered around the state.

An eternal optimist you will hear him say
regularly: “Is this a Great Day?” The answer is
always, “Hale Yes!”

If you need help with your online marketing or a
network marketing opportunity Dr. Hale is the go
to man. “Hale Yes!”

Comments

  1. Thank you for putting so much into this post Hale. I went a spent the time to play around with RTM based on your article here. I have set it up, just with the free version so far as a CRM. I like the versatility of RTM to be able to add your own tabs, etc.

    Thanks once again for your great advice about good tools to use. Hope to catch you again on the small group webinar.

    Regards,
    Ross.
    Ross Freiberg recently posted..Why Do We Need To Do Business Planning?My Profile

    • Ross,

      I’m glad you like it. I’d love for it to have a “more professional” name, but it sure does the work.

      Talk to you Thursday (errr make that Friday for you 🙂 )

      Dr. Hale

Trackbacks

  1. […] post Using Remember the Milk as a Basic CRM Tool appeared first on Hale Pringle | Take Your Blogging and Internet Marketing to the Next Level […]

  2. […] wrote a post recently about using a nice To Do List system called Remember the Milk as a Customer Relationship Management (CRM) tool. Remember the Milk (RTM) allows me to schedule calls and record my […]

Speak Your Mind

*

CommentLuv badge

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