Redshift Assessment Repository

Sample Log

U0001,billy@gmail.com,2020-11-01T13:15:33,P0001| U0002,jane@gmail.com,2021-04-01T12:11:33,P0005| U0003,nancy@gmail.com,2023-06-01T17:14:33,P0011| U0003,nancy@gmail.com,2023-06-01T17:14:33,P0011| U0003,nancy@gmail.com,2013-06-01T17:14:33,P0014| U0001,billy@gmail.com,2001-11-01T13:15:33,P0017| U0004,sam@outlook.com,2001-11-01T03:15:33,P0023| U0005,billy@gmail.com,2020-11-01T05:15:33,P0001| U0006,sarah@gmail.com,2021-04-01T06:11:33,P0005| U0007,paul@aol.com,2023-06-01T07:07:33,P0011| U0008,gene@outlook.com,2023-06-01T02:14:33,P0011| U0009,abe@gmail.com,2013-06-01T03:14:33,P0012| U0010,george@aol.com,2001-11-01T09:15:33,P0005| U0011,glen@outlook.com,2001-11-01T13:15:33,P0003| U0012,april@outlook.com,2023-06-01T02:14:33,P0031| U0013,adam@gmail.com,2013-06-01T03:14:33,P0026| U0014,anne@aol.com,2001-11-01T09:15:33,P0019| U0011,glen@outlook.com,2001-11-01T13:15:33,P0005| U0014,anne@aol.com,2001-11-01T09:15:33,P0018

Log

unique set of users using the site

unique set of page codes users are accessing

user email addresses that have accessed at least 2 pages

top 10 most visited pages and how often they were accessed

unique set of users that are using the site before 8am