0920-1175 Standardized Web Statistics - Codebook

---

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