Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Fri Feb 10 10:37:31 CST 2006
Shamil: Will this work for non-static IP addresses? (Is that the right question?) My IP address on someone else's web site is actually my ISP's. I think. Second, we don't have our own order page. We use PayPal and avoided the whole gateway company interface thing. (PayPal takes about the same cut as a gateway company). So would this create a problem? I'm leaning now towards a coupon or discount code that we can save in the sales record which would give free shipping or $5 off and that would enable us to link a specific sale to an affiliate and also support multiple affiliates with different codes plus a unique discount code if we ran an ad or put a flyer into some publication. Rocky Shamil Salakhetdinov wrote: > Rocky, > > I just made a simple test - created simple HTML page on one of my test > sites: > > http://4auto.biz/apps/testAffilate.htm > > And from this web page made a link to > > http://www.smsconsulting.spb.ru/affilates/test.htm?ID=1 > > When I went through this test route I found the following HTTP log record in > my logs: > > 10.1.1.181 - - [10/Feb/2006:18:28:57 +0300] "GET /affilates/test.htm?ID=1 > HTTP/1.1" 304 - "http://4auto.biz/apps/testAffilate.htm" "Mozilla/4.0 > (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322; .NET CLR > 2.0.50727)" > > where: > > - 10.1.1.181 is my PC's IP address in the LAN of my ISP provider; > - http://4auto.biz/apps/testAffilate.htm - the URL of the page, which > generated this HTTP log record (for you it will be your affilate's URL); > - GET /affilates/test.htm?ID=1 HTTP/1.1 - is the HTTP request generated by > previous URL > > Now you have 10.1.1.181 linked to the info that it came from > http://4auto.biz/apps/testAffilate.htm with ID=1 (ID defines your different > products, which an affilate can sell from their site). > > The entered page on your site (/affilates/test.htm?ID=1 in my sample) should > be a dynamic Web page generating the URL to follow with affilate and product > Id and unique coupon ID as parameters to track your customer's activity > until they order your software/service entering coupon Id on last step (the > coupon ID could be also static and corresponding HTML page aslo static - > then this coupon would be a unique ID for a given affilate/your software > product.service pair)... > > You can then automatically analyze the activity of 10.1.1.181 in your HTTP > log records and find that it will result in opening your order page and > placing order for your software or getting subscription to your service > using unique/fixed coupon Id - then you can pay your affilates for bringing > a paying customer to your site... > > Maybe it can be done simpler - it is new territory for me too - I'm just > thinking how it can be done... > > Shamil > > ----- Original Message ----- > From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Cc: "rubin Naiman" <RRNaiman at cox.net> > Sent: Friday, February 10, 2006 6:15 PM > Subject: Re: [AccessD] OT: Affiliate Program > > > >> Shamil: >> >> I wrote a crude app to parse the log files from my E-Z-MRP web site. I >> put it up on www.e-z-mrp.com/ftpguest for you to download and take a >> look. Maybe it will help. My purpose was just to do page counts and if >> you look at the query 'qryCountsofMajorPagesByMonth' you'll see what I'm >> using this app for. My log files look like the same format as yours. >> >> I always wondered what those extra fields were for. Can they be used >> somehow to track sales? What we need is a way to know if someone went >> to our site from her site, ended up on the order page and placed an >> order. You can download the product from our site but most people place >> an order for it to be shipped to them. Some of the info I've seen on >> affiliate programs seems to indicate that they work with downloadable >> products versus shippable. >> >> An alternative I was thinking about was to put some kind of coupon or >> discount code on her site where people can link to us and have a place >> on our order page where the buyer can key in the coupon or discount code >> and modify the code to give the discount. This way we could set up >> discount codes for different affiliates or put a discount coupon as an >> insert in a publication. >> >> New territory for me. Hope the list will tolerate this bit of OT for a >> few days. >> >> Thanks for the help. >> >> Regards, >> >> Rocky >> >> Shamil Salakhetdinov wrote: >> >>> Rocky, >>> >>> Internet servers are usually able to keep raw logs of HTTP requests - >>> these >>> are seperate ASCII files and their records are well formatted and look >>> like >>> the sample log records from my site's today HTTP requests log in the >>> P.S. >>> of this message. >>> >>> I did plan for quite some time to write code to parse these records and >>> to >>> put them into database for further analysis but I didn't have good >>> reasons >>> to that for myself. >>> >>> Now, if nobody here will point on a ready to use solution then we can >>> write, >>> test and use such TCP/IP log parser together and when well done make >>> it available on AccessD site for download... >>> >>> How about this idea? I can write some code for starters on weekend... >>> >>> Shamil >>> >>> P.S. HTTP requests sample log: >>> >>> 139.18.2.214 - - [10/Feb/2006:00:04:09 +0300] "GET /robots.txt HTTP/1.1" >>> 404 >>> 297 "-" "findlinks/1.1.1-a1 >>> (+http://wortschatz.uni-leipzig.de/findlinks/)" >>> >>> 70.85.193.178 - - [10/Feb/2006:00:05:57 +0300] "HEAD /shamil_s HTTP/1.1" >>> 301 - "-" "LWP::Simple/5.803" >>> >>> 70.85.193.178 - - [10/Feb/2006:00:06:00 +0300] "HEAD /shamil_s/ HTTP/1.1" >>> 200 - "-" "LWP::Simple/5.803" >>> >>> 70.85.193.178 - - [10/Feb/2006:00:06:03 +0300] "GET /shamil_s HTTP/1.1" >>> 301 >>> 334 "http://www.jaja-jak-globusy.com/" "Poirot" >>> >>> ... >>> >>> 70.78.74.47 - - [10/Feb/2006:05:33:36 +0300] "GET >>> /shamil_s/pics/clearday.jpg HTTP/1.1" 200 5675 >>> "http://smsconsulting.spb.ru/shamil_s/" "Mozilla/4.0 (compatible; MSIE >>> 6.0; >>> Windows NT 5.1; SV1; .NET CLR 1.1.4322)" >>> >>> 70.78.74.47 - - [10/Feb/2006:05:33:36 +0300] "GET >>> /shamil_s/pics/pole2.gif >>> HTTP/1.1" 200 226 "http://smsconsulting.spb.ru/shamil_s/" "Mozilla/4.0 >>> (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)" >>> >>> ... >>> >>> 68.142.249.46 - - [10/Feb/2006:11:31:19 +0300] "GET /robots.txt HTTP/1.0" >>> 404 297 "-" "Mozilla/5.0 (compatible; Yahoo! Slurp; >>> http://help.yahoo.com/help/us/ysearch/slurp)" >>> >>> 68.142.251.104 - - [10/Feb/2006:11:31:20 +0300] "GET >>> /.net/tutorials/vb.net/ncm.htm HTTP/1.0" 200 37707 "-" "Mozilla/5.0 >>> (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)" >>> >>> 68.142.250.147 - - [10/Feb/2006:11:34:21 +0300] "GET >>> /shamil_s/topics/tstmodex.htm HTTP/1.0" 200 3088 "-" "Mozilla/5.0 >>> (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)" >>> >>> ... >>> >>> ----- Original Message ----- >>> From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com> >>> To: "Access Developers discussion and problem solving" >>> <accessd at databaseadvisors.com> >>> Sent: Friday, February 10, 2006 9:53 AM >>> 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 >>>> >>>> >>> >> -- >> 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 >> > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com