WebTrends won’t export data, what’s wrong?

I thought I would share another WebTrends Analytics morsel of information since it is so hard to find information about this analytics software that is quick and concise.

Today I was working from home and our self hosted software would not let me download the WebTrends reports that a client requested. It would abort the process and return to the login landing page each time.

We’re using WebTrends self hosted 8.1 software (not the most recent, yet still solid) and we found that WebTrends 8.1 does not play well with Internet Exporer 8.

We found that if I ran my browser in standard IE8 settings it would not export data and the popup of data processing screen was supressed and the system couldn’t complete the request.

There is a setting in the IE8 browser though that is called “compatibility view” that fixes this problem. Just set it to run in compatibility mode for the data site or all sites if you want and your analytics data is available for download again.

On another note, our recently update McAfee security and virus protection software is also blocking the javascript prompted popup window where the data is usually exported and I can’t download any data at work anymore either. We haven’t found a solution to this problem because the security settings get reset to the standard again when the system finds that the administrator has changed them, usually within a 1/2 hour. No word on if the powers that be would make an exception for my computer somehow or if our maintenance systems even allow that.  

It’s going to be a fun month.


WebTrends Email Stats Reports How To Setup

I love that WebTrends is a good solid web analytics reporting solution, but I really find the setup process for just about anything with this system to be very confusing and lengthy. I’m sure there is a reason for this (could be data integrity processes or cost savings) but I really just need a step by step list when I need to get something done quickly and someone to tell me where these oddball parts of the process exist. Therefore I’m writing a list to explain this process so I have it written down and other people can find this info too.

(technical note I’m using webtrends software 8.1, not the webtrends hosted solution)

Today the task at hand is setting up automated reports of webtrends data to be sent monthly by email. The duration of the data collected and the frequency of the reporting schedule are both flexible, it can be daily, weekly, monthly, quarterly or yearly.

The first step is to go to the administration menu from your login. There go to Report Designer and Templates. You can select one of their templates, I needed to create a new one.

Then name your template. Go to next, select the content by adding (and naming) a new chapter, then adding content to that chapter from the add report link on the menu above. Select the “built in report” list from the drop down to get the standard metrics available in webtrends. Check the boxes of the metrics you want included, I would say 4-8 per report is enough before you have too much data for someone to really use. You can make changes to the layout, although I was not looking for that level of detail now.

Click next at the bottom of the page. Then you have some configuration settings, like for wrapping text lines on long urls (ok) and how many rows of data in the reports (20-50 max for readability, top 5 is good).

Click next again and give profiles access to this report. I noticed mine are already given universal access and grey-ed out so nothing much to do with this screen. Then click save.

Next you then go back to the profiles list (admin menu and web analysis and reports & profiles) and edit the profile you want to get this report to add the report to the profile. This is one of those steps I think is redundant and should be automated or brought into the setup process before this because its confusing. You wave over the profile in the list (don’t click it) and get a menu with “actions” and edit is one of them.

From there go to reports in the top menu and on the drop down go to report templates. Click the box by your report to select it, ignore the second checkbox that is labeled default because it will change the default reporting style in the profile to this new report, and that isn’t the intention here.

Then go back to the admin menu a third time and to the scheduler menu (bottom) and then schedule jobs and click the button for a new job. This is the email setup part. Under job type select scheduled report and follow through the pieces of menu from left to right as you fill out each section. First select your profile you want reported on, next give the report a name and assign it to a user (yourself). (note this is also how to disable the emails with the check box below, no idea why this is hidden here). Report type: general report. Output type can me a database, pdf, excel/csv or pdf. I chose pdf because it looks professional and we don’t have to install Microsoft office/word on the server in order to export it. Its the only option that does not require that except the database. Number of data rows to report is up to you, I usually do top 20.

Next add the report destinations, this is where you need the email info. Add your email as the from, add theirs as the to address. Also, cc yourself on these reports so you get them too. Add the SMTP server address (if you don’t have the SMTP address it will hold up all of your other scheduled jobs, so don’t set this up without it.) So, the software knows where to connect to send it from. (contact IT about this if you don’t have it) You can also FTP it if you like your data that way, or save to a folder on the server. (not as exec friendly though) 

Under templates, complete view is ok. Under reports, here you select the reports you want to include. These are a duplicate of the ones you selected above, maybe redundant but this is literally the process we took on the phone with the WebTrends helpdesk people. Report type: standard again, date range: its up to you. Scheduling is next on the menu, you can’t run it on the 1st of the month because data may not have compiled yet in all time zones so the 2nd of the month is the first you can run a monthly report with the most recent previous month’s data. Ditto lag time for dailies, weeklies etc. Run once or run weekly/monthly/daily, as you choose.

The host binding section he literally told me to ignore. So I have no idea what that means. Then you get a summary page at the end and click save.

You just wait now and see if everything gets delivered correctly. It is good that the report is only generated once per month on the date you specify as a job that processes, so it can run data in the past (vs only from the point you created the report, forward like custom reports do because they create their own database table) and it won’t clog up your processing queue with a lot of memory/processing because it’s just once.

I wish there were short concise directions for setting up webtrends email reports like this on the web already but I realize that nothing is easy or self explanatory with database systems or webtrends. It’s just part of the territory until next generation tools come around, and no I don’t mean Google Analytics (which is almost as confusing now to beginners). Someday this has to get simpler in process so more people can use it.

Chicago CTA Rant – Where are the Busses? Commuting Problems

I have been a commuter in Chicago for about 3 years now. I was initially excited to abandon my car in it’s parking space during the week and walk to the EL train and then to work every day. I have saved a bucket-load of cash not paying for gas or parking downtown since I have worked in that area. I was able to get to work in 1 hour from door to door, and it would be faster if I caught the CTA Train right when I got to the station. It was never more than a 10 minute wait for a green line though.

All these things changed recently when I moved in with my Fiance in Warrenville. (I had been living in Oak Park for the last 7 years) Now I am only tied to downtown Chicago by the METRA trains. Which is very frustrating since the BNSF only comes in to Union Station which is all the F way over west of the loop and not walkable to Michigan Avenue. 

This means you have to fill that gap with more public transport since cabs are too expensive to take every day. Your choices are the CTA elevated Trains which aren’t really by Union Station or Michigan Avenue either or the CTA Buses. Everyone said the Buses were the way to go. And for all the ranting about Metra, the CTA Buses have ended up being far more problematic than the Train. (although the train has been so packed the last 2 days that people have been standing in the isles in all the cars)

This morning for example it was a 1/2 hour wait for a 121 bus by Union Station. WTF? They are supposed to run every 12-15 minutes per the CTA Site. Last night was no better. I caught the 151 bus to Union Station for a change (most days I wait a 1/2 hour for that at 6 pm also) and then there was no Train until 6:50 pm. I spent a 1/2 hour sitting in the train station doing nothing. Where was the 6:20 BNSF?

That is the first time a METRA train has been missing but the CTA buses are there at about a 50% rate . I can walk to the train station in a 1/2 hour, but if I can get a bus it only takes 15 minutes (even stopping on every block). But if I knew there would not be a bus for a 1/2 hour I would just F-ing walk.

I get to start working from home on Fridays this week. I won’t miss the 1.5-2 hour commute each way.

How have your experiences been with Chicago CTA & METRA commuting?

Campbells Soup in Smaller Cans With No Soup? Sucks

Ok, this marketing blog has turned into the marketing and product rant blog as I find more and more companies making boneheaded decisions about their marketing and products. This week’s winner is Campbell’s Soups. I bought a bunch of Campbell’s soup a few weeks ago because in Chicago winter starts in late October and ends in June. Canned condensed Campbell’s soup is an easy and not-going-to-kill-you type microwave dinner I keep around all winter in case of a lack of groceries. (or any brand for that matter)

This new batch of cans though is either smaller or they have decided to cram so many more noodles, vegetables and pasta into the can so that there is now no room at all for the actual soup. The vegetable soup I opened last week was solid when I opened it. It would not pour at all. I had to scoop it out in large chunks and even after I added the can of water the condensed soup solids inside the noodles would not dissolve. It was like water with floating soup chunks in it. Gross.

Today was worse, peas and ham soup was solid as a rock and the water did not blend well here either. All the solid peas sat at the bottom of a soup that used to be puree style. WTF? Is gas that expensive that you can’t include water or actual soup in your cans anymore? Is space that much of a premium? Did an MBA tell you this would work? I thought so. Assholes.


This sucks, the soup comes out gross every time and I will have to switch brands again to get back to actual soup broth in a can. This just goes to show you can never trust an MBA to actually give you suggestions that will work. They always F up the product with lower quality everything and take away important features that the customer values in the name of saving a few pennies and paying their 150K per year salary.

I buy this kind of Campbell’s soup because it is easy to make and is edible right out of the can with minimal changes. Now I end up microwaving it until it is boiling and the soup solids still won’t dissolve. Well, I guess that is enough for this rant. Campbell’s has lost my money, we will see how long it takes them to figure it out before they loose a lot more people too. Hello Progresso.