|
Home > Archive > Commerce Server Analysis > July 2004 > URLs with multiple querystrings
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
URLs with multiple querystrings
|
|
| Chris Lewis 2004-06-01, 5:00 pm |
| Hello,
I've currently got some reports from the DW that show me
the number of times a specific querystring/value was used
i.e. sku=1234 or campaign=16 etc.
What I'm looking to find now is a combination of these
i.e. how many times did sku=1234&campaign=16 appear on a
single page. This would allow me to see the most popular
products being viewed from each specific external
campaign.
Thank you in advance
Chris
| |
| Brian Blum [MSFT] 2004-06-28, 7:29 pm |
| As you know, there is no 'Out of the box' report that does what you want.
You'll have to write a custom query that joins the results of querystring
query to the CampaignEvent table.
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
--------------------
Content-Class: urn:content-classes:message
From: "Chris Lewis" <anonymous@discussions.microsoft.com>
Sender: "Chris Lewis" <anonymous@discussions.microsoft.com>
Subject: URLs with multiple querystrings
Date: Tue, 1 Jun 2004 08:00:49 -0700
Lines: 15
Message-ID: <1663101c447e9$39f69570$a401280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcRH6Tn2eu9lttwSQDqbYWiTRIbJcw==
Newsgroups: microsoft.public.commerceserver.analysis
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.analysis:2161
NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
X-Tomcat-NG: microsoft.public.commerceserver.analysis
Hello,
I've currently got some reports from the DW that show me
the number of times a specific querystring/value was used
i.e. sku=1234 or campaign=16 etc.
What I'm looking to find now is a combination of these
i.e. how many times did sku=1234&campaign=16 appear on a
single page. This would allow me to see the most popular
products being viewed from each specific external
campaign.
Thank you in advance
Chris
| |
| Chris Lewis 2004-06-29, 5:52 pm |
| Hi Brian,
Thanks for replying. I think I confused you a little with
the campaign querystring. This is nothing to do with the
campaigns module. Imagine it's two querystrings SKU and
OnlinePartner.
What is the key that links two individual entries in the
table holding the querystrings in the DW i.e. how can I
tell that these 2 querystrings (and their values) appeared
in a single url.
Thanks again.
Chris
| |
| Brian Blum [MSFT] 2004-07-01, 5:53 pm |
| OK, now I think I see what you're trying to do. The key that you're
looking for is the URIKey field in the Request table. You should be able
to run a query like:
SELECT TOP 100 [a].[Qstringname] AS [Name], [a].[strval] AS [Value],
SUM(a.RequestCount) AS [Requests], [URIKey] FROM [SVQueryStringFactTable]
AS [a], [Site] AS [c], [Date] AS [d] WHERE [c].[siteid] = [a].[siteid] AND
[d].[dateid] = [a].[dateid] AND [c].[SiteName] = 'CS2005Retail1' GROUP BY
[a].[qstringname], [a].[strval], [a].[UriKey] ORDER BY [a].[requests] DESC
and see the results grouped together by the URIKey. Then you can join
using URIKey to URI table to get the URI string.
--------------------
Content-Class: urn:content-classes:message
From: "Chris Lewis" <anonymous@discussions.microsoft.com>
Sender: "Chris Lewis" <anonymous@discussions.microsoft.com>
References: <1663101c447e9$39f69570$a401280a@phx.gbl>
<WbJ8kfWXEHA.308@cpmsftngxa10.phx.gbl>
Subject: RE: URLs with multiple querystrings
Date: Tue, 29 Jun 2004 12:08:38 -0700
Lines: 15
Message-ID: <2321d01c45e0c$7beb1940$a501280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcReDHvoM7Kltd75SpyjUSIN5oc22w==
Newsgroups: microsoft.public.commerceserver.analysis
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.analysis:2240
NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
X-Tomcat-NG: microsoft.public.commerceserver.analysis
Hi Brian,
Thanks for replying. I think I confused you a little with
the campaign querystring. This is nothing to do with the
campaigns module. Imagine it's two querystrings SKU and
OnlinePartner.
What is the key that links two individual entries in the
table holding the querystrings in the DW i.e. how can I
tell that these 2 querystrings (and their values) appeared
in a single url.
Thanks again.
Chris
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
|
|
|
|
|