0920-1175 Standardized Web Statistics - Codebook

[NCEH] Environmental Public Health Tracking Network (Tracking Network)

Att5I Web Stats Template.xlsx

OMB: 0920-1175

Document [xlsx]
Download: xlsx | pdf

Overview

CODEBOOK
Sample_Data
Data
Google Analytic Help
Changelog


Sheet 1: CODEBOOK


































Variable Statistic Coding / value Format Statistic Type Definition Topic
STATE_NAME State name From Drop down list Text Required State Name or City Name Identifier
FIPS CODE FIPS Code Auto-populated from state name selection, range of 1-78 numeric Required Federal Information Processing Standards (FIPS) are numeric codes used to identify states and counties, as assigned by the National Institute of Standards and Technology (NIST). Identifier
DATE Month and year of statistic data MM/dd/YYYY- From Drop down list date format Required Last day of the month including the year corresponding to the monthly timeframe of the collected data Identifier
TOTAL_SESSION Total number of sessions (or visits) range of 0 - ???, Blank if no data available numeric Required Sessions are the individual periods of time (also known as “visits”) that visitors spend on your site. One session is the record of a single visitor browsing a website during a given time period. This can include multiple page views, or events. In general, sessions end at midnight on the day a session was initiated or after 30 minutes of inactivity. Overall Usage
TOTAL_VISITOR Total number of visitors range of 0 - ???, Blank if no data available numeric Required A visitor is a person who goes to a website. More precisely, a visitor is the uniquely identified client that is generating page views within a defined time period (i.e. during one month). Overall Usage
TOTAL_PAGEVIEW Total page views for all site pages, summed range of 0 - ???, Blank if no data available numeric Required Page views are the amount of times visitors arrive on individual pages of your website. If a user reloads a page, that action will be counted as an additional page view. If a visitor navigates to a different page and then returns to the original page, a second page view will be recorded as well. Overall Usage
POP_CP_ASTHMA Total number of page views for content pages within ASTHMA (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required This statistic is the number of page views (not data queries) related to NCDM topics. Counts should be grouped by topic areas. Example: Count page views for all asthma content area pages and sum together to get a total for the content area. The more granular the information reported, the better.
Popular Content
POP_CP_MI Total number of page views for content pages within MYOCARDIAL INFARCTION (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_CP_CO Total number of page views for content pages within CARBON MONOXIDE POISONING (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_CP_HS Total number of page views for content pages within HEAT STRESS (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_CP_AIR Total number of page views for content pages within AIR POLLUTANTS (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_CP_WATER Total number of page views for content pages within DRINKING WATER CONTAMINANTS (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_CP_BD Total number of page views for content pages within BIRTH DEFECTS (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_CP_CANCER Total number of page views for content pages within CANCER (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_CP_CHILDBLL Total number of page views for content pages within CHILDHOOD BLOOD LEAD LEVELS (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_CP_RBO Total number of page views for content pages within REPRODUCTIVE HEALTH OUTCOMES (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_DQ_ASTHMA Total number of page views for data queries within ASTHMA (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required This statistic is the number of page views for data queries (not content pages) grouped by NCDM topic areas. For example: Count all the page views that included a query of cancer data and sum together to get a total number of page views for the topic area. Popular Content
POP_DQ_MI Total number of page views for data queries within MYOCARDIAL INFARCTION (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_DQ_CO Total number of page views for data queries within CARBON MONOXIDE POISONING (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_DQ_HS Total number of page views for data queries within HEAT STRESS (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_DQ_AIR Total number of page views for data queries within AIR POLLUTANTS (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_DQ_WATER Total number of page views for data queries within DRINKING WATER CONTAMINANTS (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_DQ_BD Total number of page views for data queries within BIRTH DEFECTS (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_DQ_CANCER Total number of page views for data queries within CANCER (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_DQ_CHILDBLL Total number of page views for data queries within CHILDHOOD BLOOD LEAD LEVELS (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
POP_DQ_RBO Total number of page views for data queries within REPRODUCTIVE HEALTH OUTCOMES (NCDM Content Area) range of 0 - ???, Blank if no data available numeric Required Popular Content
UNIQUE_VISITORS Total number of unique visitors range of 0 - ???, Blank if no data available numeric Required Unique visitors are individual (non-duplicate) visitors to a site over the course of a specific time period. This data is determined by cookies that are stored in visitor browsers. When a user visits your site for the first time, a new visit and unique visitor are both recorded. If the same user returns to the site after their initial visit, only a new visit is added. Reach
OUTSIDE_VISITORS Number of out-of-state/city visitors range of 0 - ???, Blank if no data available numeric Required This statistic asks for the number of visitors that are located outside of each recipients’ jurisdiction (i.e., city or state). For example, Google Analytics determines locations from visitors' IP addresses and where internet service providers assign those ranges. Reach
TOP_OS_1 Top platforms/operating systems used to explore portal -1st From Drop down list, Select Unavailable option if data not available and Other if OS not in the list enumeration Required This statistic asks for the first most popular operating system most used by visitors to access your website. List: ["Windows", "OS X" "Android", "iOS", "Linux", "other"] Access
TOP_OS_2 Top platforms/operating systems used to explore portal -2nd From Drop down list, Select Unavailable option if data not available and Other if OS not in the list enumeration Required This statistic asks for the second most popular operating system most used by visitors to access your website. List: ["Windows", "OS X" "Android", "iOS", "Linux", "other"] Access
TOP_OS_3 Top platforms/operating systems used to explore portal -3rd From Drop down list, Select Unavailable option if data not available and Other if OS not in the list enumeration Required This statistic asks for the Third most popular operating system most used by visitors to access your website. List: ["Windows", "OS X" "Android", "iOS", "Linux", "other"] Access
TOP_REFSITE_1 Top referring sites - 1st website, Enter Unavailable if data not available text Required Other websites that refer or send visitors to your website are called referring sites. This statistic asks for the first most occurring website, not search engines( Google/Google.com, Bing, Yahoo search, AOL, Duckduckgo, etc..) or social networks (Facebook, Youtube, whatapps, Instagram, Tiktok, etc..), which drive the most visitors to your website. Access
TOP_REFSITE_2 Top referring sites - 2nd website, Enter Unavailable if data not available text Required Other websites that refer or send visitors to your website are called referring sites. This statistic asks for the second most occurring website, not search engines or social networks, which drive the most visitors to your website. Access
TOP_REFSITE_3 Top referring sites - 3rd website, Enter Unavailable if data not available text Required Other websites that refer or send visitors to your website are called referring sites. This statistic asks for the third most occurring website, not search engines or social networks, which drive the most visitors to your website. Access
TOP_TERMPHRASE_1 Top relevant search terms or search phrases leading visitors to site -1st Enter Unavailable if data not available text Required This statistic asks for the first most common terms (eliminating words such as “and” or “the”) or phrases (e.g. “childhood lead”) entered into search engines that led visitors to your website. Access
TOP_TERMPHRASE_2 Top relevant search terms or search phrases leading visitors to site -2nd Enter Unavailable if data not available text Required This statistic asks for the second most common terms (eliminating words such as “and” or “the”) or phrases (e.g. “childhood lead”) entered into search engines that led visitors to your website. Access
TOP_TERMPHRASE_3 Top relevant search terms or search phrases leading visitors to site -3rd Enter Unavailable if data not available text Required This statistic asks for the third most common terms (eliminating words such as “and” or “the”) or phrases (e.g. “childhood lead”) entered into search engines that led visitors to your website. Access

Sheet 2: Sample_Data

STATE_NAME FIPS_CODE DATE TOTAL_SESSION TOTAL_VISITOR TOTAL_PAGEVIEW POP_CP_ASTHMA POP_CP_MI POP_CP_CO POP_CP_HS POP_CP_AIR POP_CP_WATER POP_CP_BD POP_CP_CANCER POP_CP_CHILDBLL POP_CP_RBO POP_DQ_ASTHMA POP_DQ_MI POP_DQ_CO POP_DQ_HS POP_DQ_AIR POP_DQ_WATER POP_DQ_BD POP_DQ_CANCER POP_DQ_CHILDBLL POP_DQ_RBO UNIQUE_VISITORS OUTSIDE_VISITORS TOP_OS_1 TOP_OS_2 TOP_OS_3 TOP_REFSITE_1 TOP_REFSITE_2 TOP_REFSITE_3 TOP_TERMPHRASE_1 TOP_TERMPHRASE_2 TOP_TERMPHRASE_3
Iowa 19 8/31/21 456 123 1067 5 0 0 0 4 4 4 4 1 315 282 486 10 0 133 147 63 30 65 67 5 12 Windows iOS Unavailable dph.georgia.gov Direct Traffic dph.georgia.gov environmental health CDC Tracking Unavailable
Iowa 19 9/30/21 45 21 2039 65 2 1 1 3 102 0 56 2 263 307 392 24 1 64 127 0 0 48 105 14 16 Other Android Chrome OS cdc.gov Direct Traffic epa.gov washington county health Unavailable carbon monoxide
Iowa 19 10/31/21 29 32 1467 10 2 2 2 6 96 617 79 6 501 297 504 28 0 72 218 72 35 67 65 10 20 Unavailable iOS Android epa.gov Direct Traffic hhs.gov rabies Iowa environment health health
Iowa 19 11/30/21 6 2 2319 5 0 0 0 4 4 4 4 1 315 282 486 10 12 133 147 63 30 65 34 5 12 Windows Unavailable Unavailable dph.georgia.gov Direct Traffic dph.georgia.gov environmental health CDC Tracking Unavailable
Iowa 19 12/31/21 568 21 1237 4 1 1 1 3 103 0 16 2 263 307 392 24 1 64 127 45 63 54 105 14 16 Other Android Chrome OS cdc.gov Direct Traffic epa.gov washington county health Unavailable carbon monoxide
Iowa 19 1/31/22 29 32 3450 10 2
2 6 1396 617 79 6 501 297 504 28 0 72 0 72 35 76 43 10 20 Unavailable iOS Android epa.gov Direct Traffic dph.georgia.gov rabies Iowa environment health health
Iowa 19 2/28/22 6 1 6719 5 0 0 0 4 4 4 4 1 315 282 486 10 0 133 147 63 30 65 32 5 12 Windows iOS Unavailable dph.georgia.gov Direct Traffic epa.gov environmental health CDC Tracking Unavailable
Iowa 19 3/31/22 678 21 2437 4 1 1 1 3 54

2 263 307 392 24 1 64 127 40 63 46 105 14 16 Other Android Chrome OS cdc.gov Direct Traffic epa.gov washington county health Unavailable carbon monoxide
Iowa 19 4/30/22 29 32 1250 10 2 2 2 6 1396 617 79 6 501 297 504 28 0 72 218 72 0 0 32 10 20 Unavailable iOS Android epa.gov Direct Traffic dph.georgia.gov rabies Iowa environment health health
Iowa 19 5/31/22 79 15 4319 5 0 0 0 4 4 4 4 1 315 282 486 10 0 133 147 63 30 65
5 12 Windows iOS Unavailable dph.georgia.gov Direct Traffic epa.gov environmental health CDC Tracking Unavailable
Iowa 19 6/30/22 165 21 4537 3 1 1 1 3 0 76 0 2 263 307 392 24 1 64 127 30 63 112 105 14 16 Other Android Chrome OS cdc.gov Direct Traffic epa.gov washington county health Unavailable carbon monoxide
Iowa 19 7/31/22 29 32 4550 10 2 2 2 6 1396 617 79 6 501 297 504 28 0 72 218 72 35 342 0 10 20 Unavailable iOS Android epa.gov Direct Traffic dph.georgia.gov rabies Iowa environment health health

Sheet 3: Data

STATE_NAME FIPS_CODE DATE TOTAL_SESSION TOTAL_VISITOR TOTAL_PAGEVIEW POP_CP_ASTHMA POP_CP_MI POP_CP_CO POP_CP_HS POP_CP_AIR POP_CP_WATER POP_CP_BD POP_CP_CANCER POP_CP_CHILDBLL POP_CP_RBO POP_DQ_ASTHMA POP_DQ_MI POP_DQ_CO POP_DQ_HS POP_DQ_AIR POP_DQ_WATER POP_DQ_BD POP_DQ_CANCER POP_DQ_CHILDBLL POP_DQ_RBO UNIQUE_VISITORS OUTSIDE_VISITORS TOP_OS_1 TOP_OS_2 TOP_OS_3 TOP_REFSITE_1 TOP_REFSITE_2 TOP_REFSITE_3 TOP_TERMPHRASE_1 TOP_TERMPHRASE_2 TOP_TERMPHRASE_3

#N/A 8/31/21


































#N/A 9/30/21


































#N/A 10/31/21


































#N/A 11/30/21


































#N/A 12/31/21


































#N/A 1/31/22


































#N/A 2/28/22


































#N/A 3/31/22


































#N/A 4/30/22


































#N/A 5/31/22


































#N/A 6/30/22


































#N/A 7/31/22


































Sheet 4: Google Analytic Help

Google Analytics Help
Tip: Create a custom report to get the monthly report from Google Analytics in one step: Customization => Custom Reports
Variable Where to find in Google Analytics
DATE Normally at Google Analytics, you can select the time span on the top right, select a full month as timeframe
TOTAL_SESSION Audience => Overview: Sessions
TOTAL_VISITOR Audience => Overview: Users
TOTAL_PAGEVIEW Audience => Overview: Pageviews
POP_CP_ASTHMA Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_MI Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_CO Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_HS Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_AIR Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_WATER Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_BD Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_CANCER Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_CHILDBLL Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_RBO Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_ASTHMA Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_MI Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_CO Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_HS Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_AIR Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_WATER Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_BD Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_CANCER Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_CHILDBLL Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_RBO Behavior => Overview; Behavior => SiteContent => Content Drilldown
UNIQUE_VISITORS Audience => Overview => New Users
OUTSIDE_VISITORS Audience => Location
TOP_OS_1 Audience => Technology=>Browser & OS
TOP_OS_2 Audience => Technology=>Browser & OS
TOP_OS_3 Audience => Technology=>Browser & OS
TOP_REFSITE_1 Acquisition => All Traffic => Source/Medium
TOP_REFSITE_2 Acquisition => All Traffic => Source/Medium
TOP_REFSITE_3 Acquisition => All Traffic => Source/Medium
TOP_TERMPHRASE_1 Acquisition => Search Console => Queries (Search query)
TOP_TERMPHRASE_2 Acquisition => Search Console => Queries (Search query)
TOP_TERMPHRASE_3 Acquisition => Search Console => Queries (Search query)

Sheet 5: Changelog

Last Update 08/11/2022












8/11/2022 Total variables changed from 36 to 37





Metrics Added:





METRICS REASON FOR ADDING NUMBER OF METRICS OPTIONAL OR REQUIRED?


FIPS_CODE Added as additional identifier for states. 1 Required, auto-populated field based on STATE_NAME selection.








8/17/2020













Total variables changed from 53 to 36 ( 2 variables identifier and 34 traffic metrics all mandatory)





Metrics Removed:





METRICS REASON FOR REMOVING NUMBER OF METRICS OPTIONAL OR REQUIRED?


AVG_PPV No need to have in the data collection template, it is a calculated Metrics and is available in data visualization tool 1 Required


POP_CP_NON_NAME1
POP_CP_NON_COUNT1
POP_CP_NON_NAME2
POP_CP_NON_COUNT2
POP_CP_NON_NAME3
POP_CP_NON_COUNT3
POP_DQ_NON_NAME1
POP_DQ_NON_COUNT1
POP_DQ_NON_NAME2
POP_DQ_NON_COUNT2
POP_DQ_NON_NAME3
POP_DQ_NON_COUNT3
VISITOR_AFF_1
VISITOR_AFF_2
VISITOR_AFF_3
GOVT_VISITORS
Had >=50% of missing data 16 Optional









Variable Updated





VARIABLES REASON FOR UPDATE




STATE_NAME Useful to identify Recipients data, no need to have date associated to it as in earlier version











Validation rules implemented on columns




8/1/2019












A. AVG_PPV Average number of pages viewed per visitor (was visit) range of 0 - ??? numeric, 2 decimal places Required The average number of pages viewed per VISITOR (was session) to your website. Calculated by dividing total number of page views by TOTAL_VISITORS (was total number of visits). In formula: TOTAL_PAGEVIEW/TOTAL_VISITOR














B.
Column F in the STATSDATA tab modified to add optional formual calculation of Col E/Col D (TOTAL_PAGEVIEW/TOTAL_VISITOR)

















8/2/2018






Initial Release




File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy