[AccessD] OT: Affiliate Program

Hi Rocky:

If she is constructing the links, could she add a query string to the URL
(EX: http://www.thesleepadvisor.com/index.asp?AffiliateID=1)? Depending on
your server model, then you could add code to automatically detect the query
string and log it to a database/session variable/cookie (using server side
code). Then on a successful order, your system looks for the db
value/session variable/cookie and adds it to the order record.

Hope this helps. 

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Friday, February 10, 2006 12:54 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] OT: Affiliate Program

Dear List:

I have a web site where we are selling The Sleep Advisor
(www.thesleepadvisor.com).  Someone with an alternative health site has
proposed to promote The Sleep Advisor on her site and send folks to our
site. She asks if we have an affiliate program.  Which we ain't.

I looked into it a bit and it doesn't look trivial. Basically we need a way
to know if someone visiting our site and buying The Sleep Advisor originated
from her site.  We're hosted by Affinity and have Urchin statistics but I
don't see anything there that would be helpful right off.

Does anyone know a slick, quick way to do this?

MTIA

Rocky

--
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com