Kindly read the instructions. I provided the excel file.
Create an Excel document with the following pivot tables, one pivot table per tab.
1. Total Sessions and Bounce Rate by Month (sort by month in calendar order)
2. Default Channel Group, Sessions, Users (sort by sessions, largest to smallest)
3. Device Category, Bounce Rate, Pageviews per Visit (PPV*) (sort by bounce rate, smallest to largest)
4. Default Channel Group, Device Category, Sessions, Bounce Rate, PPV (sort by sessions, largest to smallest)
* Pageviews per Visit: this is a custom metric that you must create.
The formula is: Pageviews/Sessions
NOTE: Pivot Tables must have their own formulas – if you export data that is already formulated – for example, AVERAGE, RATE, PERCENTAGE, etc…the pivot table will perform a function of a function. (
Hint: Bounce Rate is the number of bounces per session).
Finalize Your Excel Pivot Table Assignment
· Once you have all pivot tables created, paste a copy of each one onto a single Excel tab (your tab will have 4 tables pasted on it).
· Name this tab “Summary”.
· Format your tables in the way shown in the video (proper Metric titles, bold for headings, etc.)
· Add a title to this page to describe your report.
· Use the proper number formats for each metric.
· Provide a footnote that says where your data came from.
Summary
| 1 Master View |
| New Custom Report |
| 20210101-20211231 |
| Links to data: |
Dataset1
| Device Category | Default Channel Grouping | Month of the year | Sessions | Users | Pageviews | Bounces |
| desktop | Direct | 04 | 57820 | 44809 | 264859 | 30488 |
| desktop | Direct | 11 | 56728 | 38848 | 339862 | 22496 |
| desktop | Direct | 03 | 56151 | 42485 | 259486 | 27694 |
| desktop | Direct | 12 | 55608 | 40303 | 379650 | 21241 |
| desktop | Direct | 10 | 54791 | 39155 | 319486 | 22451 |
| desktop | Direct | 07 | 51278 | 37166 | 304696 | 20546 |
| desktop | Direct | 09 | 48920 | 35893 | 277010 | 20688 |
| desktop | Direct | 05 | 48496 | 36175 | 260779 | 21395 |
| desktop | Direct | 06 | 48057 | 34547 | 279009 | 20350 |
| desktop | Direct | 08 | 46017 | 33283 | 295762 | 18372 |
