PDA

View Full Version : Sponsor management


LD
2008-02-09, 11:12 AM
I started out keeping my sponsors login info on an Excel spreadsheet which has turned into an unorganized monster, with two or three versions on various computers. Any good options to help get shit together?

Jim
2008-02-09, 11:29 AM
I'm sure Greenie will have a solution for you. He is a touch anal when it comes to organization. :)

Greenguy
2008-02-09, 01:15 PM
Oops! I had a long post on here, but then noticed that you said "login" & not just "sponsor info"

I spread sheet is a good idea - I have them on a text file, but it's tab'd, so I can import it into xl if I wanted to.

Create a master & make copies onto an external drive every now & then.

LD
2008-02-09, 06:59 PM
Thanks Greenie. I saw a script somewhere that kept a neat little database on the server. I could probably publish an Excel spreadsheet to my server as well to keep everything centralized.

hashbury
2008-02-09, 09:08 PM
Robo form works well for me with logins
also makes submitting a tad bit easier
not sure if this helps

matyko
2008-02-10, 05:42 AM
I use xls, in which I log : sponsor, url, login, pass, payment type, min payment amount, notes.
I also use Nifty Stats (http://niftystats.com/), which is a free tool I Can Not live without. If you are paranoid it can be scary, but it keeps all your login infos on your machine and it is free because of the banners.

Mateusz
2008-02-10, 06:29 AM
Robo form works well for me with logins

Same here |thumb

Simon
2008-02-10, 08:14 AM
One thing I add to my Excel spreadsheet is a column for the email I used when I signed up. That can help if you need to have your password reset and sent to you. Plus I almost always signup using an email address like "sponsor-name@mytrackingdomain.com" so I can filter their incoming emails directly into a folder and, maybe more important, I can be pretty sure when someone has sold/rented/traded my email address.

tigermom
2008-02-10, 02:45 PM
Make sure you password-protect the file. In fact, I prefer to use KeePass so that my passwords are all encrypted. It's also useful for managing the zillion other passwords I have all over the place.

LD
2008-02-10, 03:14 PM
Thanks all, good info!

RageCash-Ben
2008-02-10, 08:57 PM
I use StatsRemote. Once you add all your sponsors all you have to do is backup a couple of files.