Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Fri Feb 10 09:15:33 CST 2006
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