Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
1) Discuss the breakdown of sessions and other metrics across channels and device category.  Is there anything noteworthy?    (2) Discuss the inferences that can be made from the following table

1) Discuss the breakdown of sessions and other metrics across channels and device category.  Is there anything noteworthy?    (2) Discuss the inferences that can be made from the following table

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

(1) Discuss the breakdown of sessions and other metrics across channels and device category.  Is there anything noteworthy? 

 

(2) Discuss the inferences that can be made from the following table

+ First user default channel group 1 2 3 4 5 6 7 Free form 1 Totals Direct Paid Search Organic Search Cross-network Referral Paid Other Display Device category desktop mobile tablet smart tv desktop tablet mobile smart tv desktop tablet mobile desktop tablet smart tv desktop mobile smart tv tablet desktop mobile tablet desktop mobile smart tv Sessions 31,900 100.0% of total 4,719 549 516 72 6,798 1,181 5 2 4,791 313 13 2,959 414 2 2,153 487 4 465 4,072 27 174 255 3 552 Total users 23.942 100.0% of total 3.017 382 360 33 5,061 941 5 2 3,372 249 3 2,012 290 1 2,075 473 4 462 3,614 25 170 167 3 221 New users 23,234 100.0% of total 2,864 36 347 34 4,935 931 5 2 3,319 248 1 2,010 289 1 2,070 471 4 462 3,541 23 169 159 3 224 Returning users 2,501 100.0% of total 346 2 48 9 680 89 0 0 501 24 1 345 41 0 27 6 0 2 243 0 3 40 0 65 Bounce rate 51.8% Avg 0% 54,1% 79.2% 66.1% 65.3% 31.5% 34.9% 40.0% 50.0% 42.0% 50.5% 15.4% 46.3% 46.4% 50.0% 92.6% 95.3% 75.0% 96.1% 46.7% 85.2% 62.6% 45.5% 66.7% 69.2% Average session duration 2m 20s Avg 0% 3m 22s 4m 36s 2m 02s 2m 32s 2m 58s 2m 44s Om 11s Om 20s 2m 35s 1m 47s 5m 49s 2m 48s 2m 51s Om 12s Om 25s Om 19s Om 14s Om 10s 1m 20s Om 04s 0m 39s 1m 48s Om 04s 2m 50s Session conversion rate 2.5% 100.0% of total 3.0% 25.5% 1.9% 0.0% 2.5% 2.3% 0.0% 0.0% 2.8% 1.9% 23.1% 3,3% 2.9% 0.0% 0.8% 1.0% 0.0% 0.0% 0.4% 0.0% 0.0% 1.2% 0.0% 0.0% 5 ✓ Transactions 796 100.0% of total 145 142 10 0 172 27 0 0 136 6 3 99 12 0 18 5 0 0 18 0 0 3 0 0 ↓ 91+ Purchase revenue $213,258.80 100.0% of total $40,192.80 $38,329.40 $3,549.00 $0.00 $48,358.50 $7,528.90 $0.00 $0.00 $37,120.60 $1,294.00 $477.00 $23,565.50 $3,231.00 $0.00 $3,775.70 $1,445.40 $0.00 $0.00 $3,924.00 $0.00 $0.00 $467.00 $0.00 $0.00
Transcribed Image Text:+ First user default channel group 1 2 3 4 5 6 7 Free form 1 Totals Direct Paid Search Organic Search Cross-network Referral Paid Other Display Device category desktop mobile tablet smart tv desktop tablet mobile smart tv desktop tablet mobile desktop tablet smart tv desktop mobile smart tv tablet desktop mobile tablet desktop mobile smart tv Sessions 31,900 100.0% of total 4,719 549 516 72 6,798 1,181 5 2 4,791 313 13 2,959 414 2 2,153 487 4 465 4,072 27 174 255 3 552 Total users 23.942 100.0% of total 3.017 382 360 33 5,061 941 5 2 3,372 249 3 2,012 290 1 2,075 473 4 462 3,614 25 170 167 3 221 New users 23,234 100.0% of total 2,864 36 347 34 4,935 931 5 2 3,319 248 1 2,010 289 1 2,070 471 4 462 3,541 23 169 159 3 224 Returning users 2,501 100.0% of total 346 2 48 9 680 89 0 0 501 24 1 345 41 0 27 6 0 2 243 0 3 40 0 65 Bounce rate 51.8% Avg 0% 54,1% 79.2% 66.1% 65.3% 31.5% 34.9% 40.0% 50.0% 42.0% 50.5% 15.4% 46.3% 46.4% 50.0% 92.6% 95.3% 75.0% 96.1% 46.7% 85.2% 62.6% 45.5% 66.7% 69.2% Average session duration 2m 20s Avg 0% 3m 22s 4m 36s 2m 02s 2m 32s 2m 58s 2m 44s Om 11s Om 20s 2m 35s 1m 47s 5m 49s 2m 48s 2m 51s Om 12s Om 25s Om 19s Om 14s Om 10s 1m 20s Om 04s 0m 39s 1m 48s Om 04s 2m 50s Session conversion rate 2.5% 100.0% of total 3.0% 25.5% 1.9% 0.0% 2.5% 2.3% 0.0% 0.0% 2.8% 1.9% 23.1% 3,3% 2.9% 0.0% 0.8% 1.0% 0.0% 0.0% 0.4% 0.0% 0.0% 1.2% 0.0% 0.0% 5 ✓ Transactions 796 100.0% of total 145 142 10 0 172 27 0 0 136 6 3 99 12 0 18 5 0 0 18 0 0 3 0 0 ↓ 91+ Purchase revenue $213,258.80 100.0% of total $40,192.80 $38,329.40 $3,549.00 $0.00 $48,358.50 $7,528.90 $0.00 $0.00 $37,120.60 $1,294.00 $477.00 $23,565.50 $3,231.00 $0.00 $3,775.70 $1,445.40 $0.00 $0.00 $3,924.00 $0.00 $0.00 $467.00 $0.00 $0.00
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Types of Database
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS