Name

Definition

Raw Data

Means data that has not undergone Data Management

Cleansed Data

Means data that has been checked for malformed attributes, proper timestamps, valid geographic locations, duplicate events, etc.

MAU

Means Monthly Active Users and is the calculated total number of unique Users delivered in a calendar month

DAU

Means Daily Active Users and is the calculated total number of unique Users delivered in a single day

aDAU

Means Average Daily Active Users and is the calculated number of the average Daily Active Users (DAU) delivered in a calendar month

aDAU is calculated as the total number of unique Users delivered each day, divided by the total days in the month (or partial month)

For example: Average DAU = (SUM: total unique Users received each day) / (Applicable days in month)

PII

Means Personally Identifiable Information and is any information that could be used to identify any individual, either directly or indirectly, including: name; mailing address; social security number; phone number; email address; or health, financial, employment information, or government-issued identifier

Data Field

Data Type

Sample Value

Description

device_id 

String

8d1437b1-0e2c-462b-a4e8-41bf58…

Unique device advertising identifier

id_type 

String

ADID

Ad ID device type: IDFA (iOS) or ADID (Android) 

latitude 

Float

18.864864

Latitude of the event 

longitude 

Float

76.39176

Longitude of the event 

horizontal_accuracy 

Float

19

GPS accuracy in meters

timestamp 

Long

1564623910000

Unix timestamp of the event (millisecond) 

ip_address 

String

157.33.161.132

IP address of the event

device_os 

String

Android

Device operating system: iOS or android

os_version 

String

 9

Device operating system version

user_agent 

String

Mozilla/5.0 (Linux; Android 9; SM…

Web browser version and operating system 

country 

String

IN

ISO2 2-digit alpha country code of the event 

source_id 

String

24

Quadrant unique identifier for data source 

publisher_id 

String

ebd8eceafe1479f86f75e2f54d6 aac7

Unique developer identifier 

app_id 

String

2bfef19b8fdbfe3b5bf0cd388831d0df

Unique application identifier 

location_context

String

0

0= foreground | 1= background

geohash 

String

teq7664zc1d5

Unique location alphanumeric string

consent

String

1

0 = NA | 1 = yes

quad_id

String

1c8a34c01930e77e3748e496af0aa….

Quadrant's unique device identifier