The Customer Insights Explore Reference

This reference details the fields found in the default Explores included with Customer Insights. Note that some Explores share the same fields and the same schema (for example, API Client Dim, API Client From Creation Date Dim, API Client From First Login Date Dim, and API Client From Last Login Date Dim). Whenever there’s a shared schema, we’ve listed the schema once, and indicated which Explores share that schema. For example:

Shared Schemas

In this reference you’ll find information for the following Explores:

  • API Client Dim
  • API Client From Creation Date Dim
  • API Client From First Login Date Dim
  • API Client From Last Login Date Dim
  • App Dim
  • Creation Date Dim
  • Date Dim
  • Deactivated Date Dim
  • Email Verified Date Dim
  • Event Fact
  • Idp Dim
  • Journey Events
  • Last Login Date Dim
  • Last Updated Date Dim
  • Location Dim
  • Profile Dim
  • Profile Fact
  • Time Dim
  • User Agent Dim

App Dim

Maintains data about Capture applications and entity types (user profile databases).

Measures

  • Count

Dimensions

App ID

Application ID for the Capture application. The Application ID can be found in the Janrain Dashboard by clicking the Manage Capture app icon, clicking Clients, and then Looking for the Application ID. Sample data:

xjwuuvc75rs76j73wqfq2zsh85

App Name

Name of the Capture Application. Sample Data:

Janrain

Entity Type

Entity type (user profile database) used by the application. Sample data:

user

Client Dims

Maintains data about Capture clients and key client events (such as creation date and time). Includes:

  • API Client Dim
  • API Client From Creation Date Dim
  • API Client From First Login Date Dim
  • API Client From Last Login Date Dim

Measures

  • Count
  • Count Distinct

Dimensions

API Client ID

Client ID for the Capture client. Client IDs can be viewed in the Janrain Dashboard by clicking the Manage Capture app icon, clicking Clients, and then reviewing list of client IDs. Sample data:

84ptfh3pn7qs4m9mbgav63v8y2kef32n

API Client Name

Name of the Capture client. Sample data:

JanrainDocumentation

Date Dims

Maintains date information; enables you to “slice and dice” dates in different ways and using different formats. Includes:

  • Date Dim
  • Creation Date Dim
  • Deactivated Date Dim
  • Email Verified Date Dim
  • Last Login Date Dim
  • Last Updated Date Dim

Measures

  • Count

Dimensions

Au Format Date

Specified date using the Australian date format: DD/MM/YYYY:

  • DD, two-digit day, including a leading zero as needed.
  • MM. two-digit month, including a leading zero if needed.
  • YYYY, four-digit year.

Sample data:

14/01/2018

Day is Last of Month

Indicates whether the day is the last day of the month. A 1 mean that the day is the last day of the month; a 0 means that it is not. Sample data:

0

Day is Weekday

Indicates whether the specified date is a weekday (Monday through Friday). A value of 1 indicates that the date is a weekday; a value of 0 means that the date is a weekend (Saturday or Sunday). Sample data:

1

Day Name

Returns the day name (Monday, Tuesday, Wednesday, etc.) for the specified date. Sample data:

Tuesday

Full Date

Enables you to return a specified portion of a date:

  • Date: Returns the full date formatted as four-digit year, two-digit month, and two-digit date (2018-10-18)
  • Month: Returns the four-digit year and the two-digit month (2018-07)
  • Quarter: Returns the year and quarter (2018-Q2)
  • Week: Returns the week of the year (42)
  • Year: Returns the year only (2018)

Sample data:

2018-01-14

Month Day Number

Day of the month for the specified date. For example, December 19 has a month day number of 19. Sample data:

17

Month Name

Name of the month (January, February, March, etc.) for the specified date. Sample data:

January

Month Number

Month number for the specified date, with 1 indicating January and 12 indicating December. Sample data:

10

Quarter Number

Indicates the quarter (1, 2, 3, or 4) for the specified date. Quarters are as follows:

  • 1: January 1 through March 31
  • 2: April 1 through June 30
  • 3: July 1 through August 31
  • 4: October 1 through December 31

Sample data:

1

Us Format Date

Specifies the date using the format MM/DD/YYYY:

  • MM, two-digit month, including a leading zero as needed.
  • DD, two-digit day, including a leading zero if needed.
  • YYYY, four-digit year.

Sample data:

01/16/2018

Week Day Number

Number indicating the day of the week, with 1 meaning Sunday and 7 meaning Saturday. Sample data:

3

Year Day Number

Day of the year, with 1 indicating January 1 and 365 (or 366 in a leap year) indicating December 31. For example, February 1, 2018 has a year day value of 32, because that was the 32nd day in the year 2018. Sample data:

97

Year Number

Four-digit year for the specified date. For example, July 12, 2018 has the year number 2018. Sample data:

2018

Year Week Number

Week number for the specified date. Week numbers begin on the Monday of the week of January 4. For example, January 4, 2019 falls on a Friday. Therefore, for week of the year purposes, Week 1 for the year 2019 actually begins on Monday, December 31, 2018, the Monday of that week. Sample data:

51

Event Fact

Maintains data about Janrain events such as traditional sign-in or entity updates.

Measures

  • Count
  • Count Distinct
  • Count Distinct Janrain UUIDs
  • Count Entity API Only Creates
  • Count Entity Creates
  • Count Entity Deletes
  • Count Entity Updates
  • Count Events
  • Count Registrations
  • Count Sign-ins
  • Count Social Registrations
  • Count SSO Token Refreshes
  • Count Traditional Registrations
  • Count Traditional Sign-ins

Dimensions

Event ID

Unique identifier assigned to the event. Sample data:

6e6395eb-c729-4b53-9f23-90f639096146

Event Type

Specifies the type of event that took place. Event types include:

  • signin.traditional
  • signin.traditional_register
  • signin.social
  • signin.social_register
  • signin.sso

Sample data:

signin.traditional

Janrain Uuid

Specifies the Universally unique identifier assigned by Janrain to the user associated with the event. Sample data:

f4e4a2b7-87ba-4fe6-96e1-9aca9d03dcf3

Social (Yes/No)

Yes/No value that indicates whether the user associated the event logged on by using social login. Sample data:

False

Time Stamp Date

Date and time that the event took place. You can return selected portions of the time stamp, including:

  • Date
  • Hour
  • Minute
  • Month
  • Quarter
  • Week
  • Year

Sample data:

2018-02-20 16:01

Idp Dim

Maintains information about Identity Providers (IDPs), third-party entities such as Facebook and Twitter that can be used for social login.

Measures

  • Count

Dimensions

Idp Name

Name of the Identity Provider used to log on or register. Sample data:

Facebook

Location Dim

Maintains location information for users, including city, state (region), country, and continent.

Measures

  • Count

Dimensions

City

Name of the city as specified in the user profile. Sample data:

Toronto

Continent

Name of the continent for the user’s country. Continents are automatically calculated based on the user’s country. Sample data:

North America

Continent Code

Two-digit ISO code for the user’s continent as specified in the user profile. Continents are automatically calculated based on the user’s country code. Sample data:

EU

Country

Name of the country as specified in the user profile. Sample data:

France

Country Code

Two-digit ISO country code. Sample data:

FR

Postal Code

User’s postal (zip) code, as specified in the use profile. Sample data:

35010

Region

User’s region (e.g., state or province) as specified in the user profile. Sample data:

CA

Profile Dim

Maintains demographic information drawn from user profiles.

Measures

  • Count

Dimensions

Age

Age (in years) of the user, based on the birthdate specified in the user profile. Sample data:

37

Age Tiered Every Ten

Assigns user profiles to a “tier” (group) based on the age of the user associated with the profile. These tiers (which are built on 10-year intervals) include:

  • Undefined
  • Below 0 years old
  • 0 to 9 years old
  • 10 to 19 years old
  • 20 to 29 years old
  • 30 to 39 years old
  • 40 to 49 years old
  • 50 to 59 years old
  • 60 to 69 years old
  • 70 to 79 years old
  • 80 to 89 years old
  • 90 to 99 years old
  • 100 to 109 years old
  • 110 or more years old

Sample data:

Below 0                       0
0 to 9                   64,432
10 to 19              1,352,087
20 to 29             12,197,019
30 to 39             11,710,094
40 to 49              9,388,384
50 to 59              7,459,093
60 to 69              4,887,536
70 to 79              1,876,332
80 to 89                444,389
90 to 99                 68,729
100 to 109               28,958
110 or Above              1,276
Undefined           149,832,160

Age Tiered Janrain Segments

Assigns user profiles to a “tier” (group) based on the age of the user associated with the profile. These tiers (which are built on Janrain demographic segments) include:

  • Undefined
  • Below 0
  • 0 to 13 years old
  • 14 to 17 years old
  • 18 to 20 years old
  • 21 to 24 years old
  • 25 to 34 years old
  • 35 to 44 years old
  • 45 to 54 years old
  • 55 to 64 years old
  • 65 or more years old

Sample data:

Below 0                   0
0 to 13             125,165
14 to 17            537,730
18 to 20          1,238,683
21 to 24          2,801,906
25 to 34         15,236,934
35 to 44         10,027,242
45 to 54          8,688,638
55 to 64          6,403,182
65 or Above       4,418,849
Undefined       149,832,160

Email Domain

Domain name (e.g., gmail.com) for the email address specified in the user profile. Sample data:

gmail.com

Gender

User’s gender, as specified in the user profile. Sample data:

female

Profile Fact

Maintains information about deleted profiles. Provides a way to link Customer Insights information to a specific user (typically used for Customer Journey analytics).

Measures

  • Count

Dimensions

Creation Tiers 30/60/90+

Assigns user profiles to a “tier” (group) based on the number of days since the profile was created. These tiers include:

  • 0 to 29 days since the profile was created
  • 30 to 59 days since the profile was created
  • 60 to 89 days since the profile was created
  • 90 or more days since the profile was created

Sample data:

0-29 days         35,314,303
30-59 days         6,641,235
69-89 days         2,742,628
90+ days         103,740,214

Days Since Creation

Indicates the number of days since the user profile was created. Sample data:

35

Days Since Last Logon

Indicates the number of days since the user last logged on. Sample data:

77

Deactivated

Yes/No value indicating whether or not the user profile has been deactivated. Sample data:

Yes

Deleted (Yes/No)

Yes/No value that indicates whether the user profile has been deleted. Although profiles might be deleted, profile demographic information and profile-related events are not deleted from the analytics database. Sample data:

True

Email Not Verified

Yes/No value indicating whether or not the user has verified their email address. Sample data:

No

Janrain Uuid

Specifies the Universally unique identifier assigned by Janrain to the user. Sample data:

d34db8c7-1879-44dc-b351-8eb4b006209a

Last Login Tiers 30/60/90+

Assigns user profiles to a “tier” (group) based on the number of days since the user associated with a profile last logged on. These tiers include:

  • 0 to 29 days since the last logon
  • 30 to 59 days since the last logon
  • 60 to 89 days since the last logon
  • 90 or more days since the last logon
Sample data:

0-29 days           46,344,461
30-59 days          15,035,757
69-89 days           8,580,717
90+ days             3,860,478

Time Dim

Maintains hour/minute of the day information for events. Note that Time Dim information is stored in the Coordinated Universal Time (UTC) format and not in local time; however, local time is used for timestamp fields. You can modify your local time zone by:

  1. Clicking your user profile icon and then clicking Account.
  2. On the Account page, click Time Zone and select the desired time zone:

    Changing Your Time Zone

Completing the preceding procedure changes your default time zone. You can also change the time zone for an individual Look or Dashboard by clicking the Time Zone list in the Look/Dashboard toolbar.

Measures

  • Count

Dimensions

Hour

Hour of the day, based on a 24-hour clock. Hour 0 is the time from midnight to 12:59 AM; hour 1 is the time from 1:00 AM to 1:59 AM: etc. Sample data:

23

Minute

Minute of the hour. Minute values are reused throughout the day; for example, 10:23 AM and 11:23 AM both have a minute value of 23. Sample data:

45

User Agent Dim

Maintains information about devices and browsers used to access your web site.

Measures

  • Count

Dimensions

Browser

Name of the web browser used to connect to the web site. Sample data:

Firefox

Browser Version

Version number of the web browser used to connect to the web site. Sample data:

6.0

Device

Name of the device used to connect to the web site. Sample data:

iPhone

Device Brand

Brand/manufacturer of the device used to connect to the web site. Sample data:

Samsung

Device Model

Model number of the device used to connect to the web site. Sample data:

Nexus 5

Is Bot (Yes/No)

Yes/no value indicating whether the device used to connect to the web site is run by an automated Internet robot (bot). Sample data:

true

Is Mobile (Yes/No)

Yes/no value indicating whether the device used to connect to the web site is a mobile device such as a cell phone. Sample data:

false

Is Pc (Yes/No)

Yes/no value indicating whether the device used to connect to the web site is a personal computer. Sample data:

false

Is Tablet (Yes/No)

Yes/no value indicating whether the device used to connect to the web site is a tablet. Sample data:

False

Is Touch Capable (Yes/No)

Yes/no value indicating whether the device used to connect to the web site has a touch screen. Sample data:

True

OS

Operating system of the device used to connect to the web site. Sample data:

Windows 10

OS Version

Version number of the operating system used to connect to the web site. Sample data:

5.1.1

Journey Events

Maintains information about users and their activity on your web site. Requires a subscription to Customer Journey Analytics.

Measures

  • Count
  • Count of Unique Duids (Unique identifier for the user, based on a domain-specific cooker)
  • Count of Unique Events
  • Count of Unique Janrain Uuids

Dimensions

App ID

ID of the Capture application used during the session. Sample data:

2expajwx26ep8a3yyc6bketugw

Browser Allows Cookies (Yes/No)

Indicates whether cookies are enabled in the browser. Sample data:

No

Browser Colordepth

Color resolutions of the browser, in bits per pixel. Sample data:

32

Browser Document Charset

Character set for the browser; most browsers use UTF-8. Character sets are used to convert raw ones and zeros into human-readable character sets. Sample data:

UTF-8

Browser Document Dimensions

Width and height (in pixels) of the web page. Sample data:

1264x1347

Browser Has Director

Indicates whether the browser supports Adobe Director. 0 means that the browser does not support Director; 1 means that it does. Sample data:

1

Browser Has Flash

Indicates whether the browser supports Adobe Flash. 0 means that the browser does not support Flash; 1 means that it does. Sample data:

0

Browser Has Gears

Indicates whether the browser supports Google Gears, a discontinued utility that supplements browsers with features such as offline storage. 0 means that the browser does not support Gears; 1 means that it does. Sample data:

0

Browser Has Java

Indicates whether the browser supports Java. 0 means that the browser does not support Java; 1 means that it does. Sample data:

1

Browser Has PDF

Indicates whether the browser allows you to view Adobe PDF files. 0 means that the browser does not let you view PDF files; 1 means that it does. Sample data:

1

Browser Has Quicktime

Indicates whether the browser supports the Quicktime media player. 0 means that the browser does not support Quicktime; 1 means that it does. Sample data:

0

Browser Has Realplayer

Indicates whether the browser supports the Real media player. 0 means that the browser does not support Real; 1 means that it does. Sample data:

0

Browser Has Silverlight

Indicates whether the browser supports Microsoft Silverlight. 0 means that the browser does not support Silverlight; 1 means that it does. Sample data:

1

Browser Has Windows Media Player

Indicates whether the browser supports the Windows Media Player. 0 means that the browser does not support Windows Media Player; 1 means that it does. Sample data:

1

Browser IP Hash

“Hashed” (encoded) client IP address. Sample data:

++++3qSwZswnA24k0SiMxg==

Browser Language

Configured language for the browser. Values are stored using IETF language tags. Sample data:

en-US

Browser Screen Resolution

Screen resolutions in pixels (width x height). Sample data:

1920x1200

Browser Time Zone

Time zone of the client computer. Sample data:

America/New York

Browser Viewport Dimensions

Visible area of a web page as displayed in the browser. Values are in pixels (width x height). Sample data:

1396x851

Domain Uuid

Universally unique identifier assigned to an anonymous use (also referred to as the DUID or the Domain User ID). This differs from the Janrain UUID, an identifier assigned to a known, registered user. Note that a single Janrain UUID can be associated with multiple DUIDs. Sample data:

0000003b-8060-401f-8077-9073000bc542

Event Action

Used with custom events, the Event Action specifies the action performed by the user (for example, click, play, stop, etc.). Sample data:

login

Event Category

Used with custom events, the Event Category specifies a category type (blog, video, news, etc.). Sample data:

traditional authentication

Event Label

Used with custom events to identify a particular event (e.g., Super Bowl Campaign). Sample data:

visitorId

Event Property

Used with custom events, the Event Property and Event Value enable you to store additions information as name-value pair: for example, the Title property might store the value My First Video. Sample data:

Message

Event Type

Type of event. For example, pv means “page view” and se means “structured event.” A structured event is an authentication-based event such as registration or successful login. Sample data:

pv

Event Uuid

Universally unique identifier assigned to the event. Sample data:

0000002d-e2c3-4e32-949e-80fdbf027158

Event Value

Used with custom events, the Event Property and Event Value enable you to store additions information as name-value pair: for example, the Title property might store the value My First Video. Sample data:

validationErrors

Janrain Uuid

Universally unique identifier of the user (as assigned in the Janrain database). Sample data:

fbf0cf95-b0be-48ce-914e-242355a220fe

Page Title

Title of the web page that was viewed. Sample data:

Customer Identity and Access Management (CIAM) | Janrain

Page URL

URL of the web page that was viewed. Sample data:

https://www.janrain.com/

Referrer URL

URL of the web page where the user clicked a link in order to be directed to the target web page. Sample data:

https://janrain.com

Session Uuid

Universally unique identifier assigned to the event. Sample data:

00000387-f0ab-4d49-8f82-25d542ff33d9

Session Visit ID

Session number assigned to the visit. Sample data:

1

Timestamp Date

You can return the following portion of the timestamp:

  • Date
  • Hour
  • Minute
  • Month
  • Quarter
  • Time
  • Week
  • Year

Sample data:

2018-05-18 21:15:11

See Also

Scroll ↓