| James Thurston 2004-02-20, 2:36 am |
| Hi,
I have a problem with Referer information in the Data Warehouse. Our
IIS Web Logs store the correct referer information in the field
'cs(Referrer)', with the full URL, eg:
http://www.google.co.uk/search?q=mu...F-8&hl=en&meta=
When this data gets loaded into the DW, though, only the Referrer
Domain (www.google.co.uk) is stored. So our ReferrerDomain table is
full of correct information, but our Referrer table is empty. Also,
the fields in which these Referrer URLs should appear, in Request and
Visit (according to MS ETL process documentation), do not exist in
those tables.
Is there some setting we need to apply to get the full Referrer URLs
into the DW? I'm under pressure to produce reports for our popular
search engine terms and am stuck without this!
Thanks in advance for any help you can give,
James Thurston
|