MOBILE LOCATION DATA DICTIONARY


LOCATION DATA DEFINITIONS

 

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

 

LOCATION DATA SCHEMA

 

Data Field

Data Type

Sample Values

Description

device_id 

String 

8d1437b1-0e2c-462b-a4e8-41bf581beb5a

Unique advertising identifier from the device 

id_type 

String 

ADID

Advertising ID device type: IDFA (iOS) and 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 as reported by the device OS 

timestamp 

Long 

1564623910000

Unix timestamp of the event (millisecond) 

device_os 

String 

Android

Operating system of the device: "iOS" or "android" 

os_version 

String 

 9

Version of the device operating system 

ip_address 

String 

157.33.161.132

IP address of the event generated from the device 

user_agent 

String 

Mozilla/5.0 (Linux; Android 9; SM-J600G Build/PPR1.180610.011; wv) AppleWebKit/537.36 (KHTML like Gecko) Version/4.0 Chrome/74.0.3729.136 Mobile Safari/537.36

Web browser version and operating system 

country 

String 

IN

ISO2 2-digit alpha country code for the devices seen in the country 

source_id 

String 

 24

Quadrant unique identifier for the data source 

publisher_id 

String 

ebd8eceafe1479f86f75e2f54d6 aac7

Unique developer identifier 

app_id 

String 

2bfef19b8fdbfe3b5bf0cd388831d0df

Unique application identifier 

location_context

String 

0

0= foreground, the event was captured when the app was open

1= background, the event was captured when the app was not open 

geohash 

String 

teq7664zc1d5

Unique alphanumeric string to express a location