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.

Advertisements

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?

HyperMilling How to Save Money on Gas, fuel economy and Drive Cheaper

I was surprised to read this article about driving, gas mileage and hypermilling which is basically the art of conservative driving to save gas in general by getting about 30% better gas mileage. Of course the results differ depending on which car you drive (or truck) but I think this article brings up a lot of good points and strategies. Here are some of the tips they suggest for saving gas (and money) and improving fuel economy for your car when driving around town:

1. Accelerate slowly from stoplights and stop signs. This is a huge gas saver for those of us who live in the suburbs and city. We do a lot of stop and go driving every day and this acceleration from the light sucks down fuel like nothing else. They recommend never pressing the pedal more than 1 inch down. Never floor the car or race away from the light. Just accelerate slowly and you will not waste gas.

2. Use your cruise control on the highway and tollway. I never do this but I will start now. If you want to avoid costly fuel surges in your engine, just set your cruise control for 55 mph or 65 mph depending on the speed limit, set your car in the right lane or middle one if there are super slow cars or trucks in the right lane, and get there at a normal consistent pace. The car is better at managing acceleration with just enough gas at a consistent rate than we are. Humans generally pump the pedal when they drive and constantly throw too much fuel into the engine and are highly inconsistent. Anyway, I like this because it isn’t that different from what we do now and it is more cost efficient.

3. Properly inflating the tires impacts the gas mileage very little and turning off the air conditioning on highway trips doesn’t do much either. (turning off the air conditioning in stop n go traffic can help though)

So take 20 seconds to accelerate away from traffic lights, turn off the air conditioning in stop and go traffic and use the cruise control as much as possible when driving on the highway and your gas mileage should go up and your fuel consumption should go down and you should save some more money.

And then there are always the old fashioned ways to save money on Gas like carpooling and using public transit. Don’t forget those either!

 

My New Years Resolutions for 2008 (goals) Happy New Year!

This year has been a trying one for me. Both for personal and non-personal reasons especially early in the year. Seriously, it’s not good when TopGear is a highlight of your week. There were some good things later in the year though and I appreciate them a lot. Anyway, here are some of my resolutions for 2008. Hopefully 2008 will be a better year than 2007 was overall.

1. Loose 20 lbs. It’s a necessity. It has been creeping on for 3-4 years and it’s time to take it off again. In real terms this means no deserts, walking or running regularly and no snacks from the vending machine or otherwise. I also have to help my cat Zeus loose some weight. He is also a bit overweight for his size and is equally lazy at the moment.

2. Save 5K more in savings again. I did this in 2007 and intend to do it again in 2008. To have some kind of safety net is important and I took the dependable cash flow from work for granted for too long. I am in ok financial shape now but it can always be better. Then eventually it would be nice to have some money invested again but that might not be until 2009.

3. To keep things going along well with Steve. This isn’t as much a goal as a hope.

4. To keep up the HPV  Cervical Pre-Cancer Dysplasia health related follow ups and surgery again when it’s needed later in the year.

5. To take some kind of web or HTML class. I have been saying this for years and there is only so much you can learn through mucking around right? I feel like I need it for work.

6. To be better at time management. This means to get to bed early and get up early first of all, and otherwise just try and be more conscious of the clock. I get into tunnel vision and loose all track of time and space. I am also a huge daydreamer and distracted easily person. Lots to do better here.

7. To learn to cook some things. Not a real specific goal here, but in general cooking at home is intended to be cheaper, healthier (less processed) and a learning experience so I don’t have to rely on takeout and pre-prepared foods all the time.

8. To get back into being more career goal oriented again. I have been happily sitting in the role I am in here for more than a year. I think it’s time to innovate it or change somehow to get to the next level again. This could be a new role or just more changes within this one. I feel antsy again, and that happens about every year or so.

 So that’s it and it’s published publicly so I have to follow through now. Happy New Year to all of you too.

What are some of your 2008 Goals?

Some new sites to explore

My friend Meg linked to this site SEO moz that I had heard about but not kept up with and they had a web 2.0 competition of sorts not too long ago and the list of winners and runners up is an interesting list of sites to explore on a Friday afternoon. I have not been through all of them yet, but I am interested to continue surfing because there are so many I have never heard of. (and I am on the web at least 8 hrs a day)  So, for the new emerging web and some old favorites I recommend heading over to the seo moz site and taking a gander at their list. Not so much for the sake of who got what award, but for the general discovery of new sites that you might like and be able to use. It’s always interesting here on the internet.

When spamming someone bites you back

I am almost in shock of this post on the wired editor’s personal blog that discloses the emails that he has blocked because he got unsolicited emails pitching Press Releases for products, services, and who knows what else because he is a PR person in public lists. I have to say it was a bold move to do that and he must have had clearance from his employer to do it.

It would have worked if he just blocked them personally, but publishing the list holds this to another level. A public standard of corporate acceptability. And that has gone out the window in buzzy boom market and companies where the greed level is high and the oversight is low. I applaud him for publishing them and it is very entertaining to read through the 199 comments on the post. This brings the issue into the online conversations of a lot of people and may even influence the future actions of overzealous PR people.

Holiday Christmas Shopping Target

I am one of those people who like to have all the Christmas shopping done by Thanksgiving so that I never have to deal with huge mall crowds or long lines wasting my weekends in December. Plus aren’t there a million holiday parties to go to in December? They start early in the month with the work related ones and then continue to friends, family and your own household. So do yourself a favor and start your shopping now.

The first step is writing a list of people that you have to buy gifts for. If you are unsure if a neighbor or coworker would be getting you a gift or not, err on the side of caution and get them something small even if they don’t end up getting you something. It’s always better to be generous than not.

Then there are a million sites online that can help you shop and some even have online coupons for extra discounts. Most guys on your list will be interested in electronics and gadgets. The best place for those is Amazon and there are Amazon coupon codes here. Target is also a great place for shopping for kids gifts. I have to send some cute gifts to both my honorary nieces this year and plan to look for educational toys at Target. They also have cute clothes and books for kids that are great too. There are some Target Coupons here.

It’s never too early to start planning because when December comes you will have enough to deal with for the parties you have to attend and the food and decoration preparation you do in your own home. Why not get all the shopping done now, and check that off the list first?