Shamil Salakhetdinov
shamil at users.mns.ru
Fri Feb 10 10:26:32 CST 2006
<<< They may or may not complete the order there. >>> Yes, Rocky, but if the order coupon/Id (fixed for affilate/product pair or generated when customers enter your page via affilate's site) will be put in the next page after entry page URL as parameter and then entered when order is placed then you can use it to join HTTP log and your/paypal order database info.... 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> Sent: Friday, February 10, 2006 6:46 PM Subject: Re: [AccessD] OT: Affiliate Program > Shamil: > > More than that I need to know where a sale came from (actually, knowing > the number of visitors generated from an affiliate would be interesting > but not really necessary). And since our order button links to PayPal, > this may be a problem. They may or may not complete the order there. > > Rocky > > > Shamil Salakhetdinov wrote: >> <<< >> >>> Feel free to have a look at http://emmajohnstoneceramics.com/usage/ . >>> >> Yes, Chris my ISP collects/presents similar statistics for my site: >> >> http://www.smsconsulting.spb.ru/acclogs/hourly_usage_200601.png >> http://www.smsconsulting.spb.ru/acclogs/daily_usage_200601.png >> http://www.smsconsulting.spb.ru/acclogs/usage_200601.html8 >> >> But Rocky needs raw information to analyze his site activity generated by >> his affilate sites - I think such information can be extracted from HTTP >> log >> records but I don't know how this HTTP logging works in details. My guess >> is >> that the first entry via affilate site should have this site's identifier >> in >> URL, which can be extracted and linked with all the following activity of >> the IP address presented as the first element of the entry log record... >> >> Shamil >> >> ----- Original Message ----- >> From: "Foote, Chris" <Chris.Foote at uk.thalesgroup.com> >> To: "'Access Developers discussion and problem solving'" >> <accessd at databaseadvisors.com> >> Sent: Friday, February 10, 2006 12:57 PM >> Subject: Re: [AccessD] OT: Affiliate Program >> >> >> >>> Interesting project! >>> >>> I too had considered such a project in the past, but was daunted by the >>> complexity. >>> >>> My web hosting company (DSVR) supports a product called Webalizer. This >>> is >>> a >>> server-side (PERL?) jobbie that analyses log files. >>> >>> Feel free to have a look at http://emmajohnstoneceramics.com/usage/ . >>> >>> Regards! >>> Chris Foote >>> >>> >>>> -----Original Message----- >>>> From: accessd-bounces at databaseadvisors.com >>>> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Shamil >>>> Salakhetdinov >>>> Sent: Friday, February 10, 2006 9:22 AM >>>> To: Access Developers discussion and problem solving >>>> Subject: Re: [AccessD] OT: Affiliate Program >>>> >>>> >>>> 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)" >>> >>> ... >>> -- >>> 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