Sponsor management

LD · 2008-02-09, 10: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, 10: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, 12: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, 05: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, 08: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, 04:42 AM

I use xls, in which I log : sponsor, url, login, pass, payment type, min payment amount, notes.
I also use Nifty Stats, 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, 05:29 AM

Quote:

Originally Posted by hashbury

Robo form works well for me with logins

Same here

Simon · 2008-02-10, 07: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, 01: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, 02:14 PM

Thanks all, good info!

RageCash-Ben · 2008-02-10, 07:57 PM

I use StatsRemote. Once you add all your sponsors all you have to do is backup a couple of files.

2008-02-09, 10:12 AM	#1
LD wtfwjd? Join Date: May 2007 Posts: 2,103	Sponsor management 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? __________________ Artisteer Wordpress Theme Generator Create Custom Themes! My Little Network

2008-02-09, 12:15 PM	#3
Greenguy The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep Join Date: Feb 2003 Location: Blasdell, NY (shithole suburb south of Buffalo) Posts: 41,929	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. __________________ Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network

2008-02-09, 05:59 PM	#4
LD wtfwjd? Join Date: May 2007 Posts: 2,103	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. __________________ Artisteer Wordpress Theme Generator Create Custom Themes! My Little Network

2008-02-09, 08:08 PM	#5
hashbury My name is hashbury not assburry Join Date: Oct 2007 Location: Tampa Posts: 1,125	Robo form works well for me with logins also makes submitting a tad bit easier not sure if this helps __________________ Sig Goes Here!

2008-02-10, 04:42 AM	#6
matyko Well you know boys, a nuclear reactor is a lot like women. You just have to read the manual and press the right button Join Date: Jan 2008 Location: Hungary Posts: 158	I use xls, in which I log : sponsor, url, login, pass, payment type, min payment amount, notes. I also use Nifty Stats, 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. __________________ Matyko (Listen to PsyRadio FM)

2008-02-09, 10:29 AM	#2
Jim Banned Join Date: Aug 2003 Location: Mohawk, New York Posts: 19,477	I'm sure Greenie will have a solution for you. He is a touch anal when it comes to organization.

2008-02-10, 07:14 AM	#8
Simon That which does not kill us, will try, try again. Join Date: Aug 2003 Location: Conch Republic Posts: 5,150	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. __________________ "If you're happy and you know it, think again." -- Guru Pitka

2008-02-10, 01:45 PM	#9
tigermom You can now put whatever you want in this space :) Join Date: Dec 2005 Posts: 893	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. __________________ XLEF

2008-02-10, 02:14 PM	#10
LD wtfwjd? Join Date: May 2007 Posts: 2,103	Thanks all, good info! __________________ Artisteer Wordpress Theme Generator Create Custom Themes! My Little Network

2008-02-10, 07:57 PM	#11
RageCash-Ben No offence Apu, but when they were handing out religions you must have been out taking a whizz Join Date: Oct 2007 Location: Australia Posts: 286	I use StatsRemote. Once you add all your sponsors all you have to do is backup a couple of files. __________________ Meat Cash 8 Week $100 PPS Promo