Engagement

Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs.

Screenshot

Audience: Engagement Dashboard using test data

Requirements

The following items are required to build this dashboard.

• Web Analytics Tracking with the following events

  • Pageviews

Steps to building this dashboard

1. Create a View

2. Create a dashboard

3. Add Sessions Tile

4. Add Pageviews Tile

5. Add Session Duration Bucket

6. Add Sessions by Duration Tile

7. Add Pageviews by Duration Tile

1. Create a View

Configure the view using the below parameters

Title	Type	Auto Dimensions	Timestamp
Session Duration	Query	None	create_ts

Copy and paste the following script into the SQL box and save:

with ssd as
(select p.visit_id,p.page_url,count(p.id) as page_views,v.create_ts, max(p.create_ts) as last_action_ts,
            abs(datediff(s,max(p.create_ts),v.create_ts)) as session_duration,
            case 
            when session_duration >= 0 and session_duration <= 10 then '0 - 10 seconds'
  					when session_duration >= 11 and session_duration <= 30 then '11 - 30 seconds'
 						when session_duration >= 31 and session_duration <= 60 then '31 - 60 seconds'
 						when session_duration >= 61 and session_duration <= 180 then '61 - 180 seconds'
 						when session_duration >= 181 and session_duration <= 600 then '181 - 600 seconds'
 						when session_duration >= 601 and session_duration <= 1800 then '601 - 1800 seconds'
            else '1801+seconds'
            end as session_bucket
            from _fxm_events p
            join _fxm_visits v on v.id = p.visit_id
 						where p.name = '_fxm.pages.view' and 
            (create_ts between '{{start_timestamp}}' and '{{end_timestamp}}')
            group by p.visit_id,v.create_ts,p.page_url             
 ) 
 select * from ssd

Super-powers are granted randomly so please submit an issue if you're not happy with yours.

Once you're strong enough, save the world:

hello.sh

# Ain't no code for that yet, sorry
echo 'You got to trust me on this, I saved the world'

2. Create a new dashboard

.... continue here...

3. Add Sessions Tile

Description of what this tile is and what it represents and how its calculated.

5. Add Session Duration Bucket

Description of what this tile is and what it represents and how its calculated.

Also describe each column and what each one means and how its calculated

Column	Description
Session_Bucket	Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs.
Pageviews_sum	Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs.
Sessions Count	Lorem ipsum, or lipsum as it is sometimes known, is dummy text used in laying out print, graphic or web designs.