Tips, tricks, and pokes, just WebTrends Analytics
Random header image... Refresh for more!

Ask or Suggest

This is the place where you can suggest topics or questions. In the comments, we mean. Go for it.

Share:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google

Tags

Somewhat Related Posts

  • EU Directives FAQ from WebTrends
  • ...
  • Cool Custom Report: Organic-Only Search Terms & Traffic
  • ...
  • Cool Custom Report: Google Organic Rank dimension
  • ...

    55 comments

    1 Marcus W { 07.26.08 at 4:52 pm }

    Anything that will make Unique Visitors understandable. Also, the use of WT.pi and Wt.seg. Thanks! GREAT site.

    2 Donovan { 08.18.08 at 7:33 pm }

    Our site uses dynamic onsite advertising. (I think). We use dynamic advertising items on our home page that link to featured products on the site. I assume that fits WT’s definition of “onsite advertising” – can’t be too sure, their documentation is pitiful.

    Given that the image and text varies and is not pulled from a static library, how can we rig it so that we can count views and clicks and revenue generated?

    To see what I’m talking about, go to our home page – the item in question is the Viewers’ Top Pick item in the RH nav column.

    We’ve managed to give it a SmartView parameter, but we’d like to track it in the Onsite Advertising reports.

    3 rocky { 08.21.08 at 7:45 am }

    Great suggestion, important topic. Give us a bit to sort it out.

    4 Kerstin { 08.25.08 at 4:49 pm }

    Under pokes, surely someone needs to do a poke at the ever-revolving WT CEOs. And I would dearly like to know if Dan Stickel is going back to work at Google. Was he just a plant, or is Google going to buy out WebTrends someday?

    5 rocky { 08.25.08 at 9:36 pm }

    No kidding.

    Also, no clue.

    It does illustrate how even people with power and accomplishments still can be ….

    Well.

    All we really know for sure is that WT finally has a CEO who knows the business and the product and as far as we can tell has great values. He’d better stick around.

    6 rocky { 09.01.08 at 3:52 pm }

    Donovan – still working on it. It’s a b….

    It’s harder than expected. Smartview is the place to start, and we’re sorting that one out okay, but what we really want is to skip looking at overlays.

    7 B { 09.29.08 at 4:47 pm }

    For sites that haven’t yet moved from server log analysis to SDC page tagging, is there a step-by-step outline of the implementation from start to finish? The WebTrends docs leave something to be desired. Also, a visio of how all the components (tag/cookie/SDC server/data source/dsc.config/log file/etc) interact would be great. And how about a Tagging/Cookie 101 lesson?

    8 Anthony { 11.25.08 at 9:28 am }

    morn all… we have finally switched over to SDC from log file. we had to… our CMS application (Interwoven Teamsite) and the way the application was set up was bad… for every content area on our site using CSS divs i.e. (left nav, center_col, right_col)etc…. the visual editor would add the tags to each area… so we had 4 of those tags on every page… thus every time someone came to a page, it was registered 4 times.. thus webtrends was generating stats that were 400% over what they should be. i helped finally get SDC in place as well as GAnalytics for comparison. stats are looking normal.

    to my question… we use parameters on our site in the URI, i.e.: http://www.mysite.com/members/?id=
    http://www.mysite.com/members/?userType=

    it seems in comparison to GAnalytics, that the numbers are off. significanly.
    in GAnalytics, the page views for the /members/ area for the month of Nov. is about 44k. and it shows all page views down to the session ID’s. which is how i want…granted.

    in WebTrends my content group of /members/.* for the month of Nov. is less than 1k. and i think it is becuase my profile is not showing the URI’s that have query parameters or session ID’s.

    how can i set up my profile to take these session ID’s an query strings and incorporate them into the specific page they are associated with…

    i.e.

    /members/index.asp?id=1224
    /members/signon.asp?userType=member

    are all added to

    /members/

    i have tried to set URL Rebuilding to “no rebuilding”
    and setting page file types to “Count hits to all file types as page views” and then setting that to both Truncate and No Truncate but can not get the numbers i think they should be displaying.

    any insight to this getting fixed would be greatly appreciated.

    9 Brad Reppen { 01.26.09 at 9:19 am }

    I have a question or two.

    1.I’m trying to figure out how to create a report with recency. I’m using pages of interest, do I copy it and add the WT.vr.vc as a separate count? I’m not really sure how to go about that or taking an existing report and adding useful info to it.

    2. How would I go about adding bounce rate from entry pages to the report?

    3. The RSS guide from Webtrends is pretty poor for ‘how to’ although it is great to get you fired up to do it. I was able to put tags in a viewed RSS page, and the links the are used to ’subscribe’ the question I have is what should the report look like? which measures, how do I ensure subscriptions are more than just click and abandon (without actually subscribing)? How do I pull apart the Article Title to count just them?

    thanks for your help
    -Brad

    10 rocky { 01.26.09 at 9:36 am }

    Brad –

    1. We are working on a post about recency. It’s rapidly turning into SEVERAL posts about recency. We’ll try to address the Pages of Interest question – haven’t touched on it much. Can you supply more info about what you are doing with Pages of Interest?

    2. Bounce rate for various entry pages. Nope. You have to do exports and combine two WT reports. Amazing isn’t it.

    3. For RSS we use Feedburner for reporting, not WebTrends, because so many readers won’t execute a tag. This is a huge topic and we suspect that others have figured out more than we have. We just took the easy way out with Feedburner’s stats, which actually are pretty good. We think Google’s relationship with Feedburner is evidence that FB is the answer more than something like Analytics is.

    11 Brad Reppen { 01.26.09 at 12:58 pm }

    Thanks Rocky, sure here is what we are doing with Pages of Interest. On a corporate site I monitor we have a group of about 9 articles that are part of the home page. They are considered high value, and we are hoping to show that people that look at those articles return to the site often, and are more likely to perform other actions on the site.

    I had the app dev place WT.pi meta tags on the articles, and enabled the pages of interest report in WT. We now see a number of views of the page views based on visitor history, but they don’t include the WT.vr.vc count, which I’m not to sure how to add to an existing report.
    I’d also like to make sure this removes new visitors so that it doesn’t skew the report.

    Thanks,
    -Brad

    12 Adam { 02.12.09 at 11:15 am }

    If I recall, there is Javascript code that will “debug” the Webtrends tags passed in an alert if you paste the code in your browser while on the page that is tagged. Could you kindly post on that matter or email me the solution. Thanks, Adam

    13 rocky { 02.12.09 at 11:24 am }

    Debug as in fix, no. Debug as in “see what a debugger would see,” yes.

    Check this Outsider post – is it what you are thinking of?
    http://www.webtrendsoutsider.com/2008/checking-your-webtrends-sdc-tags/

    Also, we recently noticed new code in the latest version of the SDC tag that has something to do with debugging. We don’t know what it is or how to use it, but we will find out.

    14 rocky { 02.12.09 at 1:19 pm }

    Adam, just added the right string for the TagBuilder tag as well. Thanks for the nudge.

    15 rocky { 02.12.09 at 4:45 pm }

    … AND, we found out what the new TagBuilder “debug” code section is – yet another way to do this, but much more nicely arranged. It’s been added to the main text.

    16 Kerstin Bailey { 02.17.09 at 1:57 pm }

    I’m in a filter fight.

    In the end, what I want is a custom report that has the content group from just the site entry page, with a drill-down to search engine phrases. (ie. what search terms are bringing people to various sections of our site?)

    No such dimension, so I was trying for a report filter. Am I missing something or is there no such critter? Can you suggest an alternate way to look at the problem?

    17 rocky { 02.17.09 at 10:20 pm }

    I really like the concept of this report.

    Are you using SDC? It puts several parameters into the first hit of a visit, and only into the first hit. Sounds like what you need in your custom report (first dimension content groups, second dimension search phrase) is a filter that allows only entry/first pages. Try making a custom filter based on URL, where the page is anything (*), and the query parameter is WT.vt_f_s=1. This parameter only has a value of 1, so the value is superfluous and instead can be set to anything (*). This filter would be applied to the custom report as an include, of course.

    There are several other first-hit parameters and I’m not totally sure which one(s) will work for all possible SDC cookie arrangements. I just picked one. I’ll try to do a more thorough check tomorrow.

    (WT.vt_f_s and WT.vt_a_s may both work. I’ve changed this response to the f_s version, because of my later comments on changing the timeout. There are a lot of interdependencies here.)

    18 Kerstin Bailey { 02.18.09 at 11:26 am }

    Yes, we are using SDC, with software v8.5.

    Thanks – I’ll try it!

    19 rocky { 02.18.09 at 11:38 am }

    Also, Kerstin, note that “first hit of a visit” includes an assumption about the timeout— that it is 30 minutes. This is the default so 30 minutes is usually going to be appropriate for most users.

    But if your sessionizing definition is for some reason set to something else, you’ll probably want to consider changing the SDC tag to match the default time you actually use. This is unknown territory for us. It looks like you can change the timeout for this in the SDC tag – look for “(dLst.getTime()+1800000)” in the tag – 1800000 is 30 minutes in milliseconds.

    We don’t know what will happen if you try this, especially if it’s in On Demand.

    20 Connie B { 02.19.09 at 6:20 am }

    I am trying to link a custom report into my Access database via ODBC and I keep getting an error that says the table includes multiple fields with the same name and therefore won’t link the report. I reviewed the column names listed for each of the measures in this custom report and shortened them, thinking that some of the similarly named columns were just getting cut off and ignoring the end of the name that made them unique. It still didn’t help. Any ideas?!

    21 rocky { 02.19.09 at 7:28 am }

    Connie, When you reviewed them, did you re-analyze to get those shorter names to apply?

    Also, are you using any tools to form your ODBC links/queries? How do you know what the field names are, in other words? Sometimes the ODBC field names are not what you’d expect from looking at the GUI.

    Which field is the problem? (remove some, see when the query starts working)

    Having asked those intelligent questions, I now have to admit that I may not be any smarter than you about solving this. I would suggest moving this one over to the webtrends forums (http://forums.webtrends.com), where there are more ODBC mavens.

    Nevertheless I will get other Outsiders to take a look at the question.

    22 JD { 02.19.09 at 11:24 am }

    Firstly, thanks for putting this site together. I am slowly coming around to being more positive about Webtrends, and you’ve been a big help.

    Here’s an odd problem we’re seeing: the title attached to the home page in reports depends on what the period of the report is. If I look just at this month (Feb 2009) “www.example.org” is listed with the correct title. If I look at just last year, it’s listed with the correct title. If I look at reports from or including January of this year…it’s titled “Download:/”!

    If I understand WT and your page on “Page titles in reports” at all, there are basically two places that could have come from: the WT.ti tag in either the SDC tagging or META info on the page, and the HTML page title itself. It seems unlikely that any of these would have been “Download:/” at any point…

    The one possible complicating factor is that during January, we changed the web server so that “www.example.org” no longer returned the home page, but a 301 redirect to the bare “example.org”. I can’t see how that could cause this effect, but it’s the one unusual factor in play.

    Do you think emptying the WDB page title cache file would help? Is there another way to correct WT’s idea of the page title? (Unfortunately emptying the file requires getting someone else to do that, since I don’t have access to the server…choosing Windows-based analysis software and then making a Unix sysadmin responsible for it was Yet Another Brilliant Decision on my company’s part, but that’s another story…)

    23 Kerstin Bailey { 02.19.09 at 11:42 am }

    Replying to Rocky in comment 19: Yes, we’re using the default 30 minute time-out.

    I had already set up WT.vt_a_s before you changed the post.

    Using the first few content groups as examples:
    Going from no filter to using a filter of WT.vt_a_s=1 drops the resulting visits 23- 29%, which is within a believable range for our data.

    Swapping out WT.vt_a_s=1 for WT.vt_f_s=1 increased the resulting visits by about 4%.

    Looking at the descriptions of these two variables in the 6/08 admin user’s guide, I think we should be using WT.vt_a_s, simply because we are not on the warehouse and it is not Express Analysis. But what is meant by “Real Time analysis” anyway? Any other interdependencies I should worry about?

    Thanks again!

    24 translation Files { 02.23.09 at 9:36 am }

    Do you know if there are any tricks to building translation files? I use a translation file in our environment based off of a table in SQL server. I had it working in our environment before. I had a DBA extract the data from the tables so I could refresh our translation file and now it doesn’t work. There are something like 4000 lines in the file. I’ve removed characters from the file that I thought would throw it like double quotes, forward slashes, copyright symbols and trademarke symbols. It’s still not working for me. Are there any other rules or best practices for creating a translation file from a SQL server extract that I should know about? Thanks!

    25 rocky { 02.23.09 at 10:27 am }

    Can you define “doesn’t work” ? You probably mean “things aren’t being translated at all” but just checking.

    If it’s just not working, I would triple check the location of the file and the filename and extension to make sure WebTrends is actually able to find it. Permissions and privileges too. Is it basically an identical file, in the same spot, with the same name? If it was comma-delimited before, is it the same now?

    Is it a csv?

    26 Tony Doore { 03.04.09 at 10:29 am }

    Heres the thing i have a 3 kpi’s
    1. Registering
    2. Requesting a brouchure
    3. Doing 1. and 2.

    First two are easy and currently working they are just parameters, however i would like to count the number of times a visitor has Registered and Requested a brochure in a single measure.
    i would like a custom measure so that i can re use this in other reports related to KPI and marketing

    27 Brad Reppen in Dallas { 03.05.09 at 3:50 pm }

    Hi Rocky,
    Is there a report that will measure breath and depth of a range of and segment of visits? So this might be how many content groups are visited and how deep they go into the content within a week and by return visitors?

    We’re trying to figure out engagement for visit types.

    28 rocky { 03.06.09 at 8:18 am }

    Wow, the Outsider has been attracting some really good questions lately, showing a much more sophisticated idea of engagement than we’ve seen for a while. We actually have two questions we haven’t published yet while we try to come up with answers.

    Breadth = number of different content groups. That’s something we’ve liked for a long time. It just makes too much sense to ignore.

    “Deep” would be …. ? Some people define it as simply the number of pages. We define it as layers in the site, ranging from overview pages down to detail-that-only-a-committed-visitor-would-want pages. We turn each layer into a content group.

    You can use content group paths and Excel in a separate profile to get what you’re calling “breadth”.

    This actually deserves its own posting, although I think we’ve touched on it before. We’ll work on it.

    A very, very cool graph has one axis for depth and one for breadth, and every visit gets a dot. You can see how many go both deep and broad, how many are narrow and deep, etc.

    We have a complicated script that preprocesses logs to produce this kind of information and other very handy special parameters. The Content Groups approach described above then isn’t necessary. We have talked about polishing and releasing this script to other WebTrends users, maybe a small group at first who will put in the time to use it and help improve it. Anybody who happens to read this paragraph and is interested should Tweet us or mail us.

    29 Stephen { 03.19.09 at 9:06 am }

    Having a bit of a prob configuring Smartview at my work. Can’t seem to get the Smartview option when creating a new profile. Checked EVERY pdf manual that was created but no luck. A couple of previously created profiles do have Smartview available (but dont have any data) so my Smartview has been installed ok. Maybe someone via this blogsite might have a suggestion.

    30 rocky { 03.21.09 at 10:48 am }

    Are you saying that everything in the SmartView tab in the profile admin screen is grayed out?

    Or that when you create a profile from scratch, the new profile wizard doesn’t show you the SmartView button in the Profile Class screen (which appears only if you click Advanced Profile Options on the opening screen)?

    31 Scott Ross { 04.28.09 at 5:55 am }

    I thought it would be cool to have one Search based report that combined Natural and Paid searches but not as a single total but as individual totals. Example .
    Entry Page
    Search Engine
    Keyword
    Natural
    Paid

    And then from a measures stanpoint – page views, visits, orders, revenue

    32 Andrew S { 06.15.09 at 2:22 am }

    Hi, great site. Was just wondering if there is a way that I can change the settings so that when I open a profile the calendar defaults to run the previous Mon – Sun? Many Thanks

    33 JD { 06.16.09 at 9:03 am }

    Good news! Safari 4 works properly with Webtrends now. You still get the popup messages about the browser not being supported, but everything seems to work fine.

    34 rocky { 06.23.09 at 7:07 am }

    Andrew – You’re stuck on two counts. First, if you haven’t set up the profile to use Monday-Sunday as its definition of a week, you won’t be able to view that kind of week unless you use a custom date range. You can set any day to be the start of a week, but you have to specify it in Reports >> Report Periods.

    Second, there is no known way to preset the time period that a profile will open to when you first click on it. That would be a GREAT feature. I get tired of always starting out with the first few hours of today, which is where any of my analyses generally end.

    35 Miles Bennett { 01.22.10 at 4:25 am }

    Hey Rocky would be great to hear your opinion on the WebTrends Word Press plugin from Douglas Karr (@douglaskarr)

    36 rocky { 01.22.10 at 2:07 pm }

    Miles,

    I’d like to hear my opinion on it too! Will try to install the beta asap. Great idea.

    37 Jo Darby { 01.28.10 at 4:21 am }

    Hi there,

    I’m pretty new to WebTrends and therefore am particularly pleased that I have stumbled upon this site.

    I was hoping for some help with the REST URL generator and using it to make useful report in excel. I can’t quite get my head around how I can refresh the data while retaining what already exists.

    Also, why is there no option to obtain data by week?

    Thanks,

    Jo

    38 rocky { 01.28.10 at 1:21 pm }

    Sorry Jo, we can’t help with that …. yet. We Outsiders are dyed-in-the-wool software users and REST is available only to OnDemand customers at this time, possibly starting early summer.

    Have you been to the Developers Network on the WebTrends site? REST is a big topic over there in the Data Extraction section. http://developer.webtrends.com

    And the user forum at http://forums.webtrends.com has REST users commenting.

    39 rocky { 02.10.10 at 3:44 pm }

    I think I remember that this has to do with different sessionizing methods for those two reports, and I don’t think the issue exists any more. Let me look at my old notes.

    40 Lance { 02.18.10 at 3:32 pm }

    New to WT. Looking for a way to track “mailto” events on the site (i.e. if a person clicks on a link to an e-mail box from a page of content). Have not seen anything in WT documentation for how to track this.

    41 rocky { 02.19.10 at 8:46 am }

    Are you using SDC tagging? The SDC tag captures mailto clicks automatically.

    If you’re using server logs, there’s still a way. Give me a while to document it and possibly make a post on it.

    42 Lance { 02.19.10 at 10:16 am }

    Using SDC tagging. How do I get at the mailto information?

    43 rocky { 02.19.10 at 10:40 am }

    Lance -

    Create your SDC tag using WebTrends’ tagbuilder, at http://tagbuilder.webtrends.com. When creating the tag, go to the Event Tracking options (the menu along the bottom of the tagbuilder screen). The fourth choice is tracking mailto’s. Other things available in that menu are tracking anchor # links, formbutton clicks, image map clicks, and some others.

    If you know javascript, you could look at the code generated by the tagbuilder and adapt it to the SDC tag you’re already using, if you want.

    44 DWE { 12.31.10 at 11:21 am }

    Hi
    I’ve recently taken over the analytics for our company. When I checked our stats, I noticed that the custom reports were horribly skewed. PPC reports showing numbers that were 60% lower than what was actually being shown in Adwords (I used Adwords as a measure, since I could guage the trends between the two). As a result, I’m skeptical that any of our custom stats are accurate. I have been trying to find clear documentation on setting up reports for email/banners/ppc. As I am new to the WT system, I’m finding it incredibly frustrating to get clear answers.

    The question continually runs through my head as to whether we’re actually using the best methods for collecting this info.

    There is a .csv.txt file that is in place to track _id codes associated with campaigns, although it doesn’t seem to accurately deliver numbers, or even break out the information in a consistent manner.

    Obviously, was done wrong, and not having been involved in setting things up I’m pulling my hair out trying to figure out where to start!

    Any direction to more clear documentation would be of great assistance!

    Thanks
    DWE

    45 WendiM { 01.31.11 at 2:44 pm }

    Is it possible to create a report that will show you content consumption (page views) by frequency and / or recency of visit? I would prefer to see it by recency.

    46 rocky { 02.13.11 at 6:42 pm }

    Wendi – Let’s define that a little more. Are you talking about “how many days (average) since last viewing this particular page”? Or, “average number of pages in today’s visitors most recent visit”? Or something else?

    47 Music Reviews { 04.01.11 at 4:07 pm }

    We are just getting ready to launch a PPC Adword campaign (google specific) and as I delve into WebTrends “Most Recent Search Phrases (Paid)” and other built in reports, I am starting to realize that they are lacking. Here’s the URL we are using in AdWords:
    http://www.domain.com/landing/campaign.html?WT.srch=1&WT.mc_id=twitter&WT.seg_1={keyword:nil}

    I’m very green with respect to custom reports so I am trying to figure out how to wrap my head around some useful data.

    Obviously we start with a filter for Paid search (WT.srch=1) but then how do I rope the rest into a meaningful report?

    This: WT.mc_id=twitter
    is an AdGroup and will be defined in Campaigns.csv.

    This: WT.seg_1={keyword:nil}
    Will be the keyword that triggered the ad.

    There should be a variable in the referrer field that should get the actual search phrase.

    I was thinking to have a report that drills down from Adgroup > Keyword > Search Phrase

    How do I start with dimensions, measures and finally a decent report that will make me godlike?

    BTW – Your blog has saved me numerous times. Not enough WebTrends resources out there. Thanks!

    48 rocky { 04.03.11 at 2:37 pm }

    Hmmm, MusicReviews, your question definitely needs its own post, because a lot of people get tangled up in this. (p.s. thanks for the compliment).

    In fact, your question is quite impressive in its underlying complexity. There are a number of ways to do it and a number of possible resulting reports. It could lead to several Outsider posts – on drilldown, on campaigns.csv, on the Google ValueTracks, and on the difference between the paid-for term and the actually-typed-in term. Thanks for the ideas!

    Anyway “godlike” is a good goal, so let’s try an answer here in this corner of The Outsider for the specific thing you are after, which is that three-part drilldown. You’re almost there with what you’ve already written.

    Let’s assume you really want to use WT.seg_1 populated by the Google ValueTrack for the paid-for keyword. You realize that WT.seg_1 gets stored as WT.vhseg_1 in the visitor history table, giving you access to “most recent keyword” in other reports, right?

    But you want to ignore that for now and just create a dimension based on WT.seg_1, which will be occur only in the hit that actually results from a paid search click in the current visit. So, create that dimension. That will be the Keyword piece of your drilldown “Adgroup > Keyword > Search Phrase.”

    The Adgroup piece of your drilldown sounds like it would just be a dimension defined as “WT.mc_id”. To avoid craziness, I wouldn’t use the Campaign or Campaign ID dimension, I would create a custom dimension based on values of WT.mc_id, treating WT.mc_id like a normal parameter with no special meaning or internal transformations. The fact that you’re using campaigns.csv to add attributes to the Adgroup (i.e. campaign) name isn’t used here, though you can definitely use it in other reports.

    And your final dimension should be the “search phrase” dimension, right out of the box.

    Once you have all three of this dimensions created, you go through the Dimension creation process one more time, this time creating a custom drilldown dimension. In the “Based On” part of creating a dimension, choose “Custom Drilldown”. You’ll then see a different-looking screen with places to identify what dimensions you want in your drilldown.

    I hope this is somewhere in the neighborhood of what you are after. If not, let me know.

    By the way, the comparison of “paid for” to “actually typed in” keywords is already available in the Google Adwords interface. You probably already know this.

    49 Music Reviews { 04.04.11 at 10:36 am }

    Many thanks. I think I’ve got this all in place.

    One more question, would I just use “Visits” as my measure? Is there anything else I would want in this report?

    50 rocky { 04.04.11 at 3:46 pm }

    To tell you the truth, MR, I’m not sure whether Visits or PV would be preferred. It’s my habit to always do both — sometimes discrepancies between the two tell me something about either my report setup or visitor behavior. How about this — you do both, then come back here and tell us how the whole thing went? (including whether the advice was worth anything)

    51 Wanda { 04.05.11 at 12:17 pm }

    I’m very new to WebTrends. I am looking for a way to look at 2 dimensions. Under Marketing, Visitors Cites, I can see which city people are coming in from…. I want to drill down from there. What page are people in city X going to? Is there a way to do that?

    52 rocky { 04.05.11 at 12:23 pm }

    Wanda, yes. You need to make a custom report. It needs to be a two-dimension one, and the first dimension should be “city” and the second dimension (nested inside the first dimension) should be “Pages.” You’ll end up with a list of all the cities, and under each city will be a sublist of pages.

    If you haven’t made a custom report yet, this is a good one to start with – not too easy, not too hard. When setting up a custom report, the Dimensions tab has room for both a primary and a secondary dimension, so it’s pretty self-explanatory once you look at it. For Measures, I’d choose two measures: Visits and Page Views. You won’t need any filters. Let us know how it goes.

    53 Ulrik Sandholt { 05.04.11 at 3:10 am }

    Hi there,

    Thanks for a great site.
    I have recently discovered something I think could be helpful for people who want drilldowns int heir campaign reports, but do not want the hassle of a translation file.

    You can actually do an alternative to using a translation sheet. When using ?WT.mc_id as a campaign parameter, you can logically seperate your campaign in drilldowns by using a unique seperator like _ or – between each level of drilldown.

    Example: www. mysite.com/buy cheapstereo ?WT.mc_id=Campaignname_Medianame_Bannersize_Placement

    where Campaignname is dim1, Medianame is dim2 and so forth. The names are entirely up to you. If you want to call them Campaign, Adgroup and Horse, you can do that:)

    If you then build a dimension that uses a query parameter WT.vr.vac and ticks off the checkbox: Parameter Contains Drilldown Data (not Express Analysis compliant)

    and in the field delimiter enter _

    Then you should get a drilldown campaign report with the above dimensions.

    If you look in the Webtrends Query parameter reference guide:

    You will find the following on page 18:

    Campaign Parameter:
    WT.mc_id
    WT.mc_id=Campaign ID
    Identifies a specific marketing campaign. Pass this query parameter to pages that you want to
    associate with a specific campaign. You can specify a numeric or string value.
    WebTrends Analytics Considerations
    If you plan to export WebTrends Analytics report data to a SmartReport, values that are either characters or a combination of numbers and characters work best with Microsoft Excel.

    If you enable Visitor History in a profile, WebTrends Analytics reads this parameter and stores it in the Visitor History database. The most recent value of this parameter is made available by Visitor History
    on every hit as WT.vr.rac.

    Let me know if you would like to hear more or if you have already posted something like this.

    BR Ulrik

    (this is a finding my ex colleague Nikolaj did, when doing some work for a client with this need. Only fair to mention, if he reads it :) )

    54 rocky { 05.08.11 at 5:51 pm }

    Ulrik, Thanks! Your timing is great – I have a couple topics that I’m trying to fully understand so I can write something about them (and use them better in WT). Drilldowns is one. Campaign translation files is another. This comment of yours lands on both. I’ve copied into my scratch file and will reference it when I can get my head around things. If I don’t refer to you by name when I do that post, give me a kick by e-mail.

    p.s. I have been a fan of your knowledgeable posts over on the user forum for a few months now.

    55 Nikolaj Bardram { 06.09.11 at 2:32 am }

    Heh, thanks for the credit – and I do read this blog. It has inspired me more than once.

    Leave a Comment