Solved

How to track where a buying customer came from..???

Posted on 2006-06-16
7
357 Views
Last Modified: 2012-06-22
I've got a shopping cart setup that when a person completes an order it updates the database and sets the lead source in the invoice to Web Page (this is how my client has it setup.)  I'd like to be more specific with that and see where the person came from: eBay, BrokerBin, PriceGrabber, etc.  I know I can use Request.ServerVariables("HTTP_REFERRER") to grab a referring URL, but I'm confused as to where I put this and how I store it.

I was thinking I could store the referring URL in a session variable and then populate a field in the database with this along with the rest of the info that gets inserted. The problem is...how do I store this and make sure the correct URL gets inserted?  

If I store the URL in a session variable I'd have to add that to every page that the person could possibly enter the site with.  But then if they go to another page on my own site doesn't the referring URL now become the site itself?  So as soon as they load another page that sets the session it'll set to its own domain and overwrite the actual domain the person came from.

Am I missing something here?  How does one go about doing this?  Any information would be greatly appreciated.  Thanks!
0
Comment
Question by:Andrew Angell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 31

Expert Comment

by:alorentz
ID: 16922484
Create the session variable in the global.asa in session_onstart.  It will only fire once per session when they come to the site.

Then store the session varaible.
0
 
LVL 11

Author Comment

by:Andrew Angell
ID: 16922721
So this should work..??

<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Session_OnStart
    Session("referringURL") = Request.ServerVariables("HTTP_REFERRER")
End Sub
</SCRIPT>

Then I can use Session("referringURL") to populate the database?  Am I on the right track here?
0
 
LVL 31

Expert Comment

by:alorentz
ID: 16922798
global.asa  -  do you know what this file is?

http://www.w3schools.com/asp/asp_globalasa.asp

You're on the right track...but read about global.asa.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 11

Author Comment

by:Andrew Angell
ID: 16923426
Nope, never used it before.  I'm having a little trouble following along apparently.  Here's what I've done.  I created the following global.asa and put it in the root directory on my xp pro test machine.  All of the sites that I test on this machine are created in virtual directoies within the actual site root so that i can still keep them all seperate....I don't think this should be effecting anything should it..???

Anyway, here's the global.asa that I have:

<script language="vbscript" runat="server">

sub Application_OnStart
  'some code
end sub

sub Application_OnEnd
  'some code
end sub

Sub Session_OnStart
Application.Lock
Application("referringURL")=Request.ServerVariables("HTTP_REFERRER")
Application.UnLock
End Sub

sub Session_OnEnd
  'some code
end sub

</script>

I created the following test.asp page as well and put it in one of my sites' directories:


<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
If Application("referringURL") <> "" Then
      Response.Write(Application("referringURL"))
Else
      Response.Write("Nothing to show")
End If
%>

Loading that test page directly prints Nothing to Show, which makes sense to me.  So I then created a link from another test machine that linked to this test page, but when I view that I'm still getting Nothing to Show.

What am I doing wrong?
0
 
LVL 11

Author Comment

by:Andrew Angell
ID: 16923444
I've also tried putting the global.asa inside the virtual directory with no luck.  I read that a script will use it's closest global.asa file so I figured I'd give that a shot....again, no luck.
0
 
LVL 31

Accepted Solution

by:
alorentz earned 250 total points
ID: 16923834
You should not use application variables...only session variables.  And the global.asa shold be in the root directory.

But, let's make this simple.

Create a file called tracker.asp, and put this code in it:

<%
if session("referringURL") = "" then
   session("referringURL") = Request.ServerVariables("HTTP_REFERRER")
end if
%>


Then use tracker.asp as an include file (like <!--#include virtual="/tracker.asp" -->) and include it in all your pages (or only the pages you want).  That way it will track on any page of the site, and only record the referrer on the first page that is accessed.

That should work for you....
0
 
LVL 11

Author Comment

by:Andrew Angell
ID: 16924541
that'll work.  thanks!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CDO.Message not able to send attachement 5 40
VBScript on Html 15 55
ASP Classic, check if Querystring is UCase or LCase 8 28
Making Table Thru ASP Response.write 5 19
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question