> For the complete documentation index, see [llms.txt](https://docs.foxmetrics.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.foxmetrics.com/templates/google-analytics/audience/engagement.md).

# Engagement

## Screenshot

![Audience: Engagement Dashboard using test data](/files/-MaFAYdOhZ4w2Abno6nC)

## 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:

```sql
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
```

{% hint style="info" %}
&#x20;Super-powers are granted randomly so please submit an issue if you're not happy with yours.
{% endhint %}

Once you're strong enough, save the world:

{% code title="hello.sh" %}

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

{% endcode %}

## 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.

![](/files/-MaFGyhmlb7R4TbL9YWr)

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. |