Website Analytics Form

---

Overview

OMB
CODEBK
STATSDATA
EXAMPLEDATA
Google Analytics Help
Changelog

---

Sheet 1: OMB

---

Sheet 2: CODEBK

Variable	Statistic	Coding	Format	Statistic Type	Definition	Topic
MM_YYYY	Month and year of statistic data	MM/YYYY	date format	Required
TOTAL_SESSION	Total number of sessions (or visits)	range of 0 - ???	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 - ???	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 - ???	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
AVG_PPV	Average number of pages viewed per visitor	range of 0 - ???	numeric, 2 decimal places	Required	The average number of pages viewed per VISITOR to your website. Calculated by dividing total number of page views by TOTAL_VISITORS. In formula: TOTAL_PAGEVIEW/TOTAL_VISTITOR	Overall Usage
POP_CP_ASTHMA	Total number of page views for content pages within ASTHMA (NCDM Content Area)	range of 0 - ???	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 - ???	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 - ???	numeric	Required		Popular Content
POP_CP_HS	Total number of page views for content pages within HEAT STRESS (NCDM Content Area)	range of 0 - ???	numeric	Required		Popular Content
POP_CP_AIR	Total number of page views for content pages within AIR POLLUTANTS (NCDM Content Area)	range of 0 - ???	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 - ???	numeric	Required		Popular Content
POP_CP_BD	Total number of page views for content pages within BIRTH DEFECTS (NCDM Content Area)	range of 0 - ???	numeric	Required		Popular Content
POP_CP_CANCER	Total number of page views for content pages within CANCER (NCDM Content Area)	range of 0 - ???	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 - ???	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 - ???	numeric	Required		Popular Content
POP_DQ_ASTHMA	Total number of page views for data queries within ASTHMA (NCDM Content Area)	range of 0 - ???	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 - ???	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 - ???	numeric	Required		Popular Content
POP_DQ_HS	Total number of page views for data queries within HEAT STRESS (NCDM Content Area)	range of 0 - ???	numeric	Required		Popular Content
POP_DQ_AIR	Total number of page views for data queries within AIR POLLUTANTS (NCDM Content Area)	range of 0 - ???	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 - ???	numeric	Required		Popular Content
POP_DQ_BD	Total number of page views for data queries within BIRTH DEFECTS (NCDM Content Area)	range of 0 - ???	numeric	Required		Popular Content
POP_DQ_CANCER	Total number of page views for data queries within CANCER (NCDM Content Area)	range of 0 - ???	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 - ???	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 - ???	numeric	Required		Popular Content
UNIQUE_VISITORS	Total number of unique visitors	range of 0 - ???	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 - ???	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		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		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_3	Top platforms/operating systems used to explore portal -3rd		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_REFSITE_1	Top referring sites - 1st	website	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 or social networks, which drive the most visitors to your website.	Access
TOP_REFSITE_2	Top referring sites - 2nd	website	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	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		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		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		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
POP_CP_NON_NAME1	Name of non-NCDM Content Area on content pages -1st		text	Optional	This statistic is the number of page views for content pages (not data queries) that are not related to NCDM topics. Counts should be grouped by topic areas in order to help identify and rank topics by popularity. For example: Count all the page views for all radon content area pages and sum together to get a total for the radon content area. The more granular the information reported, the better.	Popular Content
POP_CP_NON_COUNT1	Number of page views for top non-NCDM Content Areas on Content Pages -1st	range of 0 - ???	numeric	Optional		Popular Content
POP_CP_NON_NAME2	Name of non-NCDM Content Area on content pages -2nd		text	Optional		Popular Content
POP_CP_NON_COUNT2	Number of page views for top non-NCDM Content Areas on Content Pages -2nd	range of 0 - ???	numeric	Optional		Popular Content
POP_CP_NON_NAME3	Name of non-NCDM Content Area on content pages -3rd		text	Optional		Popular Content
POP_CP_NON_COUNT3	Number of page views for top non-NCDM Content Areas on Content Pages -3rd	range of 0 - ???	numeric	Optional		Popular Content
POP_DQ_NON_NAME1	Name of non-NCDM Content Area on data queries -1st		text	Optional	This statistic is the number of page views for data queries (not content pages) for any content that is not contained within the NCDM content areas. Counts of data queries should be grouped by topic areas. For example: Count all the page views that included a data query of radon data and sum together to get a total number of page views for the radon topic area.	Popular Content
POP_DQ_NON_COUNT1	Number of page views for top non-NCDM Content Areas on data queries -1st	range of 0 - ???	numeric	Optional		Popular Content
POP_DQ_NON_NAME2	Name of non-NCDM Content Area data queries -2nd		text	Optional		Popular Content
POP_DQ_NON_COUNT2	Number of page views for top non-NCDM Content Areas on data queries -2nd	range of 0 - ???	numeric	Optional		Popular Content
POP_DQ_NON_NAME3	Name of non-NCDM Content Area data queries -3rd		text	Optional		Popular Content
POP_DQ_NON_COUNT3	Number of page views for top non-NCDM Content Areas on data queries -3rd	range of 0 - ???	numeric	Optional		Popular Content
VISITOR_AFF_1	Top visitor affiliations -1st		text	Optional	This statistic asks for the first most common affiliations found among your visitors that are non-ISP domains (i.e., domains that are not associated with an internet service provider such as Comcast, Verizon, Time Warner, etc.) and that are not affiliated with the recipient’s agency domain. Affiliations of interest include domains registered to universities, federal agencies and local governments, medical centers, etc.	Reach
VISITOR_AFF_2	Top visitor affiliations -2nd		text	Optional	This statistic asks for the second most common affiliations found among your visitors that are non-ISP domains (i.e., domains that are not associated with an internet service provider such as Comcast, Verizon, Time Warner, etc.) and that are not affiliated with the recipient’s agency domain. Affiliations of interest include domains registered to universities, federal agencies and local governments, medical centers, etc.	Reach
VISITOR_AFF_3	Top visitor affiliations -3rd		text	Optional	This statistic asks for the third most common affiliations found among your visitors that are non-ISP domains (i.e., domains that are not associated with an internet service provider such as Comcast, Verizon, Time Warner, etc.) and that are not affiliated with the recipient’s agency domain. Affiliations of interest include domains registered to universities, federal agencies and local governments, medical centers, etc.	Reach
GOVT_VISITORS	Number of visitors from state/city governmental domain	range of 0 - ???	numeric	Optional	A count of visitors from within each recipient’s state or city domain (e.g., maine.gov).	Reach

---

Sheet 3: STATSDATA

Metric

MM_YYYY

TOTAL_SESSION

TOTAL_VISITOR

TOTAL_PAGEVIEW

AVG_PPV

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

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

<name_date_submitter1> ex. Iowa_June16_RobWalker

<name_date_submitter2>

#DIV/0!

<name_date_submitter3>

#DIV/0!

<name_date_submitter4>

#DIV/0!

<name_date_submitter5>

#DIV/0!

<name_date_submitter6>

#DIV/0!

<name_date_submitter7>

#DIV/0!

<name_date_submitter8>

#DIV/0!

<name_date_submitter9>

#DIV/0!

<name_date_submitter10>

#DIV/0!

<name_date_submitter11>

#DIV/0!

<name_date_submitter12>

#DIV/0!

QC NOTES

QC KEY (QC row or individual cell)

-1 = Counts Approximated

-2 = Data Unavailable

---

Sheet 4: EXAMPLEDATA

Metric	MM_YYYY	TOTAL_SESSION	TOTAL_VISITOR	TOTAL_PAGEVIEW	AVG_PPV	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	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
Iowa_Dec2016_Rwalker	Dec-16	500	200	1,000	5.00	50	33	45	75	45	12	-2	50	33	45	50	33	45	75	45	12	-2	50	33	-2	200	100	Widows	OS X	IOS	cdc.gov	google.com	county.gov	public health data	environmental health	water quality	climate change	100	radon	25	private water	15	climate change	100	radon	25	private water	15	State university	Local Gov	Hospital	200
Iowa_Jan2017_Rwalker	Jan-17	550	220	1,100	5.00	25	45	95	85	85	21	-2	25	45	95	25	45	95	85	85	21	-2	25	45	-2	220	100	Widows	OS X	IOS	cdc.gov	yahoo.com	county.gov	water quality	washington county health	carbon monoxide	climate change	100	private water	30	radon	15	climate change	100	private water	30	radon	15	State university	Local Gov	Hospital	200
Iowa_Feb2017_Rwalker	Feb-17	600	230	1,050	4.57	55	12	23	65	65	31	-2	55	12	23	55	12	23	65	65	31	-2	55	12	-2	230	100	Widows	OS X	IOS	epa.gov	google.com	county.gov	earth day	rabies	health	climate change	125	radon	25	private water	10	climate change	125	radon	25	private water	10	State university	Local Gov	Hospital	200
QC NOTES						-1	-1	-1	-1	-1	-1	-2	-1	-1	-1							-2	-2	-2	-2	-1	-1											-1		-1		-1	-1		-1		-1					-1
QC KEY
-1 = Counts Approximated
-2 = Data Unavailable

---

Sheet 5: Google Analytics 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
MM_YYYY	Normally at Google Analytics, you can select the time span on the top right.
TOTAL_SESSION	Audience => Overview: Sessions
TOTAL_VISITOR	Audience => Overview: Users
TOTAL_PAGEVIEW	Audience => Overview: Pageviews
AVG_PPV	Audience => Overview: Pages / Session
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 => New Users
OUTSIDE_VISITORS	Audience => Location
TOP_OS_1	Audience => Browser & OS
TOP_OS_2	Audience => Browser & OS
TOP_OS_3	Audience => Browser & OS
TOP_REFSITE_1	Acquisition => Source/Medium
TOP_REFSITE_2	Acquisition => Source/Medium
TOP_REFSITE_3	Acquisition => Source/Medium
TOP_TERMPHRASE_1	Acquisition => Search Console => Queries (might need setup)
TOP_TERMPHRASE_2	Acquisition => Search Console => Queries (might need setup)
TOP_TERMPHRASE_3	Acquisition => Search Console => Queries (might need setup)
POP_CP_NON_NAME1	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_NON_COUNT1	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_NON_NAME2	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_NON_COUNT2	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_NON_NAME3	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_CP_NON_COUNT3	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_NON_NAME1	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_NON_COUNT1	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_NON_NAME2	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_NON_COUNT2	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_NON_NAME3	Behavior => Overview; Behavior => SiteContent => Content Drilldown
POP_DQ_NON_COUNT3	Behavior => Overview; Behavior => SiteContent => Content Drilldown
VISITOR_AFF_1
VISITOR_AFF_2
VISITOR_AFF_3
GOVT_VISITORS

---

Sheet 6: Changelog

Last Update 8/1/2019
8/2/2018
	Intial Release
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)