Data Visualisation

12 Month Browser Daily Snapshot

Field Name	Description	Data Type	Required	Nullable
Device_Browser	Name of Browser	String	No	Yes
Month_year	Observation Month & Year	Header	No	Yes
Browser_count	Numbers of Browser	Integer	No	Yes
Percent_month	Percent of the total amount	Integer	No	Yes
Post_stamp	Time of observation	Date_stamp	No	Yes

Data Source: Google Analytics

Script location: https://github.com/govau/GAlileo/blob/master/dags/bq_scripts_project_ursa_major/dta_sql_browser_snapshot_12months_daily_doi

12 Month Browser Version Daily Snapshot

Field Name	Description	Data Type	Required	Nullable
Device_Browser_version	Name of Browser	String	No	Yes
Month_year	Observation Month & Year	Header	No	Yes
Browser_count	Numbers of Browser	Integer	No	Yes
Percent_month	Percent of the total amount	Integer	No	Yes
Post_stamp	Time of observation	Date_stamp	No	Yes

Data Source: Google Analytics

Script Location: https://github.com/govau/GAlileo/blob/master/dags/bq_scripts_project_ursa_major/dta_sql_browser_ver_snapshot_12months_daily_doi

12 Month Device Brand Daily Snapshot

Field Name	Description	Data Type	Required	Nullable
Device_Brand	Name of Device	String	No	Yes
Month_year	Observation Month & Year	Header	No	Yes
Device_count	Numbers of Device	Integer	No	Yes
Percent_month	Percent of the total amount	Integer	No	Yes
Post_stamp	Time of observation	Date_stamp	No	Yes

Data Source: Google Analytics

Script Location: https://github.com/govau/GAlileo/blob/master/dags/bq_scripts_project_ursa_major/dta_sql_devicebrand_snapshot_12months_daily_doi

12 Month Device Category Daily Snapshot

Field Name	Description	Data Type	Required	Nullable
Device_Category	Category of Device	String	No	Yes
Month_year	Observation Month & Year	Header	No	Yes
Device_Category_count	Numbers of each Device Category	Integer	No	Yes
Percent_month	Percent of the total amount	Integer	No	Yes
Post_stamp	Time of observation	Date_stamp	No	Yes

Data Source: Google Analytics

Script Location: https://github.com/govau/GAlileo/blob/master/dags/bq_scripts_project_ursa_major/dta_sql_devicecategory_snapshot_12months_daily_doi

12 Month Operating System Daily Snapshot

Field Name	Description	Data Type	Required	Technical
Device_opsys	Category of Device operating system	String	No	Yes
Month_year	Observation Month & Year	Header	No	Yes
Device_Opsys_count	Numbers of each Device operating system	Integer	No	Yes
Percent_month	Percent of the total amount	Integer	No	Yes
Post_stamp	Time of observation	Date_stamp	No	Yes

Data Source: Google Analytics

Script Location: https://github.com/govau/GAlileo/blob/master/dags/bq_scripts_project_ursa_major/dta_sql_opsystem_snapshot_12months_daily_doi

12 Month Operating System Version Daily Snapshot

Field Name	Description	Data Type	Required	Technical
Header	Title	Header	Title
Paragraph	Text	Header	Title	Title
Header	Title	Header	Title	Title
Paragraph	Text	Header	Title	Title

https://github.com/govau/GAlileo/blob/master/dags/bq_scripts_project_ursa_major/dta_sql_opsystem_ver_snapshot_12months_daily_doi

12 Month Screen Resolution Daily Snapshot

Field Name	Description	Data Type	Required	Technical
Header	Title	Header	Title
Paragraph	Text	Header	Title	Title
Header	Title	Header	Title	Title
Paragraph	Text	Header	Title	Title

https://github.com/govau/GAlileo/blob/master/dags/bq_scripts_project_ursa_major/dta_sql_screen_res_snapshot_12months_daily_doi

90 Day Unique Visitors Daily Snapshot

Field Name	Description	Data Type	Required	Technical
Header	Title	Header	Title
Paragraph	Text	Header	Title	Title
Header	Title	Header	Title	Title
Paragraph	Text	Header	Title	Title

https://github.com/govau/GAlileo/blob/master/dags/bq_scripts_project_ursa_major/dta_sql_unique_visitors_snapshot_90days_daily_doi

90 Day Unique Visitors Hourly Split Week Snapshot

Field Name	Description	Data Type	Required	Technical
Header	Title	Header	Title
Paragraph	Text	Header	Title	Title
Header	Title	Header	Title	Title
Paragraph	Text	Header	Title	Title

https://github.com/govau/GAlileo/blob/master/dags/bq_scripts_project_ursa_major/dta_sql_unique_visitors_snapshot_90days_daily_doi

Website Count

Field Name	Description	Data Type	Required	Technical
Header	Title	Header	Title
Paragraph	Text	Header	Title	Title
Header	Title	Header	Title	Title
Paragraph	Text	Header	Title	Title

https://github.com/govau/GAlileo/blob/master/dags/bq_scripts_project_ursa_major/dta_sql_websites_count_doi