Hands pulling a book off library shelf

Web Analytics Data Dictionary

The Tableau web traffic dashboards are maintained by Office of Marketing and Communication and are fed by Google Analytics (GA4) data.

About Web Traffic Dashboards

  • Developed in Tableau
  • Populated with Google Analytics (GA4) data
  • Data is T-2 latency
  • Use custom definitions, such as Session Channel

Data Dictionary

Device (Device Type, Device Category) – the type of device the user used to access the website.

Download – direct download of a file from a link on our webpage. File formats: pdf, xlsx, docx, pptx, mp3, wav, mp4, zip, doc, xls, ppt, exe. This metric does not include downloads from links on other websites, non-webpage links (email, Teams chat, etc.), or indirect downloads using go-links.

Hostname - subdomain of the page URL. “www” prefix is removed from all hostnames other than www.osu.edu.

Location – where the website was accessed from. In certain cases, the location of a private visitor may default to the U.S. (shown as Kansas) or one of the large data centers (for example, Ashland, Va.) In many reports, the location is rolled up to four categories: Columbus, Ohio, United States outside of Ohio, and International.

Channel (Session Channel) - acquisition channel for the session. The value is calculated from session source, medium, and page referrer. Channel is an attribute of a session.

  • Internal: Internal is the channel by which users arrive at our site from within our own domains or from the “zoom-redirect” source with “web” medium.
  • Direct: Direct is the channel by which users arrive at our site via a saved link or by entering the URL directly.
  • Paid Search: Paid Search is the channel by which users arrive at our site via ads on search-engine sites like Bing, Baidu, or Google.
  • Paid Social: Paid Social is the channel by which users arrive at our site via ads on social sites like Facebook and Twitter.
  • Display: Display is the channel by which users arrive at our site via display ads.
  • Paid Other: Paid Other is the channel by which users arrive at our site via ads, but not through an ad identified as Search, Social, Shopping, or Video.
  • Organic Search: Organic Search is the channel by which users arrive at our site via non-ad links in organic search results.
  • Organic Social: Organic Social is the channel by which users arrive at our site via non-ad links on social sites like Facebook or Twitter.
  • Referral: Referral is the channel by which users arrive at our site via non-ad links on other sites/apps (e.g., blogs, news sites).
  • Email: Email is the channel by which users arrive at our site via tagged links in email. Untagged links in email are classified as Referrals.
  • Affiliates: Affiliates is the channel by which users arrive at our site via links on affiliate sites.
  • (Other): (Other) is the channel by which users arrive at our site that does not fit into any of the above categories.

Pageview – website page loaded by a user. Pageview count is a count of all pageview events. If the same page is accessed twice during a session, it is counted twice.

Pages per Session – number of pageview events in a session.

Page URL - Page URL without custom parameters (UTMs, anchors, custom parameters).

Session – a visit to the website. Session data consists of a series of events (page views, user engagement, downloads) generated by the user during the visit. If the user was inactive for 30 minutes, their activity starts a new session. Only sessions with pageviews are included in reporting.

Session count – count of unique sessions that have a pageview event. Count of sessions on a page URL is called unique pageviews.

Session Duration – sum of time for all events during the session. In most cases, user_engagement events accumulate most time.

Engaged Session – a session that lasts longer than 10 seconds, has a key event, or has at least 2 pageviews.

Percent Engaged Sessions – count of unique engaged sessions divided by total session count.

Session Medium – medium that originated the session. The value comes from manual “utm_medium” parameter or is autopopulated by Google. For example, if the session comes from an organic Facebook post, the value of medium is “organic”. This parameter is applied to all events in the session.

Session Source – source that originated the session. The value comes from manual “utm_source” parameter or is autopopulated by Google. For example, if the session comes from an organic Facebook post, the value of medium is “facebook”. This parameter is applied to all events in the session.

Session Campaign – campaign that originated the session. The value comes from manual “utm_campaign” parameter or is blank. This parameter is applied to all events in the session.

Unique pageviews – unique pages accessed within a session; in other words, if a page is accessed multiple times during a session, it will be counted as one unique pageview.

Time on Page – time the user spent on page during a pageview.

Users – unique user that accesses the website. Note that in many cases, Google is unable to combine user traffic between different devices or browsers. Visits by users who choose strict privacy settings may be counted as one unique user per event. (Currently, user counts are not available in Tableau reports.)

User count – count of unique users at the level of report summarization. For example, daily reports show daily users, i.e., counting one user the same number of times as the days the user accessed the site. (Currently, user counts are not available in Tableau reports.)


Web Analytics Hub

Request access to the Tableau dashboards and learn more about the Web Analytics dashboards at Ohio State:

Get Help

Contact adv-marketinganalytics@osu.edu to get help with data questions or request a new dashboard.