How to gets analyts and generate visual reports from sessions?

Question

I'm looking for a technique or approach to get data from user session logs and convert it to a some sort of visual style (bars/charts/whatever).

We'd like to specifically have the users session "arcs" (login->news->something->logout) displayed in a way that makes it easier to analyze the way people use the site.

This is meant for our service as a usability analyser with the idea that we could make out and see the UX/UI problems that users experience, just from the statistics.

Google Analytics and Piwik are cool and have some of the same functionality but we're looking to go a bit further...

Any ideas on how to get started? Also if I missed an obvious way of doing this, feel free to point out!

Answer 1

The Forena module can be used for such types of reporting. It comes with all sorts of Sample reports and solutions, such as the Site administration reports, which contain data about the actual Drupal site.

Here are some details about those reports:

• Active Users - A variation of D7's admin/people, including hyperlinks to the Logs for User report.
• Active Users Email - A demo of the ability to send email to all active users of a drupal site.
• Logs for User - Most recent watchdog log entries for a user (specified as a report parameter).
• Role Details - A table displaying all users for a Drupal role (specified as a report parameter), and the Drupal permissions granted to them, with for each user hyperlinks to either view or edit the user's profile.

Cloning these sample reports into custom variations is straight forward. E.g. tune the active users report with some report parameters to only report about user registered this week. Or as I did some time ago in this report (with drilldown links also, i.e. the numbers in red in it):

Refer to my comment in the forena issue queue for more details about the above screenshot.

There is even AbitMORE: this module also supports charting of those data (a typical related requirement ...).

Disclosure: I'm a co-maintainer of this module,
I hope this does not violate the site's policy on self-promotion.

Answer 2

I don't know of any modules that build this functionality inside Drupal itself. However, there are several tools out there, for which there are Drupal modules, that allow you to visualize the arc that you speak of. Two of my favorites are:

MixPanel: Mixpanel can allow you to create funnels that will help you see how the user is progressing through your website. For example, how many logged in users clicked on a product, how many of those went on to the payment page, and how many of those actually ending up paying. Mixpanel also has a Drupal module for easy integration. Or you could easily integrate this using a custom Mixpanel module with minimal effort. This is how a funnel in MixPanel would look like:

_{(source: wordpress.com)}

Google Analytics: It has a fantastic Visitors flow functionality that will allow you set flows, goals, and track against those too. Again, Google Analytics has a readymade Drupal module. Here's what a flow in GA would look like:

Answer 3

module google analytic report with charts activated do the work

EDIT:

i don't know if i exactly reply to your needs but google analytics report module create a default view to display a summary charts and datas tabs from GA datas. These drupal attached views can be modified and extended with adding GA:session variables such as

Adsense metrics: AdSense Exits
The number of sessions that ended due to a user clicking on an AdSense ad.
API name: ga:adsenseExits.
Ecommerce calculated metrics: Ecommerce Conversion Rate
The average number of transactions for a session on your property.
Calculation: ga:transactions / ga:sessions.
API name: ga:transactionsPerSession.
Ecommerce dimensions: Sessions to Transaction
The number of sessions between users' purchases and the related campaigns that lead to the purchases.
API name: ga:sessionsToTransaction.
Event tracking calculated metrics: Events / Session with Event
The average number of events per session with event.
Calculation: ga:totalEvents / ga:sessionsWithEvent.
API name: ga:eventsPerSessionWithEvent.
Event tracking metrics: Sessions with Event
The total number of sessions with events.
API name: ga:sessionsWithEvent.
Goal conversions calculated metrics: Goal Conversion Rate
The percentage of sessions which resulted in a conversion to at least one of your goals.
Calculation: ga:goalCompletionsAll / ga:sessions.
API name: ga:goalConversionRateAll.
Goal conversions calculated metrics: Goal XX Conversion Rate
The percentage of sessions which resulted in a conversion to the requested goal number.
Calculation: ga:goalXXCompletions / ga:sessions.
API name: ga:goalXXConversionRate.
Goal conversions calculated metrics: Per Session Goal Value
The average goal value of a session on your property.
Calculation: ga:goalValueAll / ga:sessions.
API name: ga:goalValuePerSession.
Internal search calculated metrics: % Sessions with Search
The percentage of sessions with search.
Calculation: ga:searchSessions / ga:sessions.
API name: ga:percentSessionsWithSearch.
Internal search calculated metrics: Site Search Goal Conversion Rate
The percentage of search sessions (i.e., sessions that included at least one search) which resulted in a conversion to at least one of your goals.
Calculation: ga:goalCompletionsAll / ga:searchUniques.
API name: ga:searchGoalConversionRateAll.
Internal search calculated metrics: Site Search Goal XX Conversion Rate
The percentage of search sessions (i.e., sessions that included at least one search) which resulted in a conversion to the requested goal number.
Calculation: ga:goalXXCompletions / ga:searchUniques.
API name: ga:searchGoalXXConversionRate.
Internal search metrics: Sessions with Search
The total number of sessions that included an internal search
API name: ga:searchSessions.
Page tracking calculated metrics: Pages / Session
The average number of pages viewed during a session on your property. Repeated views of a single page are counted.
Calculation: ga:pageviews / ga:sessions.
API name: ga:pageviewsPerSession.
Page tracking dimensions: Page Depth
The number of pages visited by users during a session. The value is a histogram that counts pageviews across a range of possible values. In this calculation, all sessions will have at least one pageview, and some percentage of sessions will have more.
API name: ga:pageDepth.
Session calculated metrics: Avg. Session Duration
The average duration of user sessions represented in total seconds.
Calculation: ga:sessionDuration / ga:sessions.
API name: ga:avgSessionDuration.
Session calculated metrics: Bounce Rate
The percentage of single-page session (i.e., session in which the person left your property from the first page).
Calculation: ga:bounces / ga:sessions.
API name: ga:bounceRate.
Session metrics: Bounces
The total number of single page (or single engagement hit) sessions for your property.
API name: ga:bounces.
Session metrics: Session Duration
The total duration of user sessions represented in total seconds.
API name: ga:sessionDuration.
Session metrics: Sessions
Counts the total number of sessions.
API name: ga:sessions.
Social interactions metrics: Unique Social Actions
The number of sessions during which the specified social action(s) occurred at least once. This is based on the the unique combination of socialInteractionNetwork, socialInteractionAction, and socialInteractionTarget.
API name: ga:uniqueSocialInteractions.
Time dimensions: Hour
A two-digit hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time, adhering to all local rules for daylight savings time. If your timezone follows daylight savings time, there will be an apparent bump in the number of sessions during the change-over hour (e.g. between 1:00 and 2:00) for the day per year when that hour repeats. A corresponding hour with zero sessions will occur at the opposite changeover. (Google Analytics does not track user time more precisely than hours.)
API name: ga:hour.
Traffic sources dimensions: Social Source Referral
Indicates sessions that arrived to the property from a social source. The possible values are Yes or No where the first letter is capitalized.
API name: ga:hasSocialSourceReferral.
User calculated metrics: % New Sessions
The percentage of sessions by people who had never visited your property before.
Calculation: ga:newUsers / ga:sessions.
API name: ga:percentNewSessions.
User dimensions: Count of Sessions
The session index for a user to your property. Each session from a unique user will get its own incremental index starting from 1 for the first session. Subsequent sessions do not change previous session indicies. For example, if a certain user has 4 sessions to your website, sessionCount for that user will have 4 distinct values of 1 through 4.
API name: ga:sessionCount.