Rich Is NOT A Crime

Tuesday, April 18, 2006

Using EXCEL as an "autosubmitter"

If you have spent any time at all doing on-line marketing, you are familiar with "safelists." These are lists that people opt-in to, to receive and send emails to each other, most likely containing commercial advertisements. They avoid anti-spam laws, because - by opting-in and by providing a "list" email - you are agreeing to accept commercial emails.

And you also probably know that, to get any results at all from safelists, you need to belong to a LOT of them. But how do you manage them? How do you remember what ads you have posted to which safelists? How do you remember when it is time to post again, or which safelists are credit-based or "pro" and have virtually unlimited ability to post to?

Set up an Excel spreadsheet, and in each cell, use the "Insert-Hyperlink" function to provide a link directly to the login webpage for each spreadsheet. I also add a column to the left of each such link, in which I put a letter or short indicator of the ad that was posted.

Across the top, the columns are labelled per day of the week. The left column can be either "type of safelist (credit, pro, 7-day, etc)." or the program you are advertising (Warp Speed Wealth, Fitness Portal, etc.).

The result looks something like this:

PROGRAM.....................Monday....Tuesday....etc.
WarpSpeedWealth... MadVlad.. GuaranteedResults..
FitnessPortal ....... ActualVisitors ... Quiddity ...

Inside the Excel spreadsheet, you can add columns if you are tracking particular ads or testing the responsiveness of certain safelists to headlines, products, etc.

Using a spreadsheet like this will oranize your campaigns, and help you get your ads out to more places on a regular basis. For on-line marketing, consistency of ad placement is one of the most important factors in attaining success.

Good luck!

0 Comments:

Post a Comment

<< Home