Bhagwant,

In v3 there used to be umbraco tracking package however since google analytics that product was shelved so now you use google or write your own. What is the reason for not using google?

Regards

Ismail

Thanks Ismail,

I am using Umbraco V 6.1.0.

There are two reasons for not using Google Analytics.

1. Website is deployed on intranet, so It is private website

2. Google Analytics will not provide user details, e.g. User A has views X, Y, Z pages

I found the way to track user activity, I am writing my own code for track user activity.

Thanks & Regards,

Bhagwant

I second the request for being able to do this. Anyone know of a package to monitor member activity?

Bhagwant, if I do not find anything I will end up having to build it for a client. I'll share my results if you are interested. Client wants to know, at minimum, who logged in each month, and how many times. They do not care about what pages, but I will probably add that in because it just makes sense to know.

I've never created an official Umbraco package....this just might be my first attempt.

@Kiel did you find any solution or have you build anything for your client? As per my researchy we can add custom code in global.asax file and track requested urls

@Bhagwant I have not tried anything yet. I am finally getting to a point where I am between projects at work and can give this a shot. I'll keep you posted on any progress.

@Keil

I have written this code in global.asax file and it is working. Now I can track user ID, page, refferel page, IP and other details.

Let me know if you need any help.

protected void Application_EndRequest(object sender, EventArgs e)
     {

         if(HttpContext.Current.User.Identity.IsAuthenticated)
         {

           umbraco.NodeFactory.Node current =  umbraco.NodeFactory.Node.GetCurrent();
           umbraco.cms.businesslogic.member.Member mem = umbraco.cms.businesslogic.member.Member.GetCurrentMember();
           System.Web.HttpBrowserCapabilities browser = Request.Browser;


            if(Conn.State==ConnectionState.Closed) 
                Conn.Open();

            MySqlCommand Cmd = new MySqlCommand();

            String strQuery = "INSERT INTO c3_generic_umbraco_portal.c3_membertracking (VisitDate, UserID, UserName, PageTitle, PageURL, ReferrerURL, RemoteAddress, Browser, BrowserMajorVersion, BrowserMinorVersion, Platform, MobileDeviceModel, MobileDeviceManufacturer)";

            strQuery = strQuery + "VALUES ('" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', '" + mem.Id + "', '" + mem.Text + "', '" + current.Name + "', '" + current.NiceUrl + "', '" + Request.UrlReferrer + "', '" + Request.ServerVariables["REMOTE_ADDR"] + "', '" + browser.Browser + "', '" + browser.MajorVersion + "', '" + browser. MinorVersionString + "', '" + browser.Platform + "', '" + browser.MobileDeviceModel + "', '" + browser.MobileDeviceManufacturer + "');";

            Cmd.Connection = Conn;
            Cmd.CommandText = strQuery;
            Cmd.CommandType = CommandType.Text;
            Cmd.ExecuteNonQuery();

           }


    }

@Bhagwant- I also have a similar kind of requirement.

a.    Where did User look in the site (timestamp, data, etc)
b.    Which data did he downloaded (which PDFs, timestamp, data, etc)
c.    What did he read or clicked (timestamp, duration, etc.)

Is there something which can be worked out for downloads ? or do you have any inputs for me?

I'm part way through my version of this. I've implemented a way to log all requests from a logged in memeber (I'm ignoring non-authenticated requests for my application) and an admin section to view their activity. I have a lot of ideas on how I want this to work for me specifically. For now, here is my very basic beginnings...

Page Views Summary: A total of page views, no user information. Shows you "popular" pages. Will eventually filter by date.
Member Activity: From a drop-down, select your site member and pick a day, or all dates and view a list of page views in date-descending order. Eventually I will add some graphing to track user activity and make things much prettier.

I've considered doing a daily-summary of activity as an email, I am working on a similar automated task at work so I figured I might as well roll it into this project as an option to turn on/off.

Any suggestions? 

@Varun

I have thought about how to track the downloading of files. If you were strictly talking about .PDF's it would be pretty easy because you could create a PDF viewer page and add a query string so you'd see the file name in teh stats.

if you're talking about word docs, .zip files or something that you can't "preview", I'm still thinking on that one. It would be very interesting to be able to know if a user has downloaded something or not. Consider a teacher giving assignments to students, if they have not downloaded the assignment you could be aware they are a slacker. I'm sure there are 1000 scenarios there.

I'm going to continue to explore this one I think...

@Kiel

Any further ideas on the file download tracking? (NOT .pdfs, but actual .ZIP and .EXE files? I just had a request come across my desk for a way to track these by Member, then export a list of users, email addys, and download dates of said users (to send notification emails to said users when a bug is found and they need to re-download the latest update/bug-fix).

Well...

PDF's would be easy. I know you didn't ask, but just being thorough. You could have a PDF Viewer page dedicated to that PDF, and since it loads automatically, you would know that it at least popped up in front of them. Obviously you can't tell they read it just like I'm sure everyone always reads Terms of Agreements before clicking Agree. hah.

Files....that's another story.

If "I" am tracking every request....you could do a downloader page:  www.mysite.com/Downloader.aspx?file=[filename]

that would show up in the member activity as a request for a page. you would just need to tweak the filename to be descriptive enough to tell you version etc.

Would that suit your needs? I might test this in the project I'm working on, its shaping up quite nicely, just slow.

This sounds like an interesting project, Kiel, would be really useful for a site that we built.

Few quick questions:

1. Did you manage to get downloads of files working?

2. Did you manage to get graphs/charts implemented? Was wondering if anything 'off the shelf' like Google Charts would be usable.

3. Noticed you were working on Umbraco 6 - would this work on Umbraco 7?

Many thanks

I need to pick this project back up. Let me see where I left off. I know I have some basic charting done and I had excluded a lot of directories for clean numbers and some other stuff. I am struggling finding good resources on how to REALLY integrate down deep into Umbraco to get a new section and all that. Let me pick it back up and get back with you. 

I should also drop what I have for v6 and finish it in v7, good call.

Sounds good, Kiel : ) Thanks for the update.

Does adding all of this information in the backend slow the site down at all? Just thinking for sites that are quite database intensive (lots of content segmentation by member group etc) would it increase any overheads?

Did this ever get further?

This is great information! I'm most curious about people downloading files as well.

If the files are stored in the Media folder of Umbraco wouldn't your Application_EndRequest function be catching that request? What makes tracking the downloads so difficult?

@RJ89 asked a good question as well. What effect does the SQL commands have on busy site? Maybe recording the data to a daily log or xml file of sorts would be lighter?

Thanks again for the info shared so far!

Has anyone implemented something like this in V7? Do you have any tips?

Also interested to know if anyone has implemented something like this in V7?

Cheers Kerri

This would be something I would be interested in as well. We are putting together a internal knowledgebase/ learning hub where we would like to be able to track usage of our students/employees (members) so as to capture metrics used to improve knowledge sharing and training. Has there been anything like this done recently? Ideally something that works with a current or more up to date version of Umbraco.

is working on a reply...