Skip to content

Data Visualisation

patdbro edited this page May 25, 2020 · 25 revisions

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

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

12 Month Browser 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_browser_ver_snapshot_12months_daily_doi

12 Month Device Brand 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_devicebrand_snapshot_12months_daily_doi

12 Month Device Category 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_devicecategory_snapshot_12months_daily_doi

12 Month Operating System 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_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

Clone this wiki locally