Shamil Salakhetdinov
shamil at users.mns.ru
Fri Feb 10 10:22:04 CST 2006
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