Documentation

Developers

API References
Data Subject Request API

Data Subject Request API Version 1 and 2

Data Subject Request API Version 3

Platform API

Platform API Overview

Accounts

Apps

Audiences

Calculated Attributes

Data Points

Feeds

Field Transformations

Services

Users

Workspaces

Warehouse Sync API

Warehouse Sync API Overview

Warehouse Sync API Tutorial

Warehouse Sync API Reference

Data Mapping

Warehouse Sync SQL Reference

Warehouse Sync Troubleshooting Guide

ComposeID

Warehouse Sync API v2 Migration

Bulk Profile Deletion API Reference

Calculated Attributes Seeding API

Custom Access Roles API

Data Planning API

Group Identity API Reference

Pixel Service

Profile API

Events API

mParticle JSON Schema Reference

IDSync

Client SDKs
AMP

AMP SDK

Android

Initialization

Configuration

Network Security Configuration

Event Tracking

User Attributes

IDSync

Screen Events

Commerce Events

Location Tracking

Media

Kits

Application State and Session Management

Data Privacy Controls

Error Tracking

Opt Out

Push Notifications

WebView Integration

Logger

Preventing Blocked HTTP Traffic with CNAME

Linting Data Plans

Troubleshooting the Android SDK

API Reference

Upgrade to Version 5

Cordova

Cordova Plugin

Identity

Direct Url Routing

Direct URL Routing FAQ

Web

Android

iOS

Flutter

Getting Started

Usage

API Reference

React Native

Getting Started

Identity

Roku

Getting Started

Identity

Media

iOS

Initialization

Configuration

Event Tracking

User Attributes

IDSync

Screen Tracking

Commerce Events

Location Tracking

Media

Kits

Application State and Session Management

Data Privacy Controls

Error Tracking

Opt Out

Push Notifications

Webview Integration

Upload Frequency

App Extensions

Preventing Blocked HTTP Traffic with CNAME

Linting Data Plans

Troubleshooting iOS SDK

Social Networks

iOS 14 Guide

iOS 15 FAQ

iOS 16 FAQ

iOS 17 FAQ

iOS 18 FAQ

API Reference

Upgrade to Version 7

Xbox

Getting Started

Identity

Unity

Upload Frequency

Getting Started

Opt Out

Initialize the SDK

Event Tracking

Commerce Tracking

Error Tracking

Screen Tracking

Identity

Location Tracking

Session Management

Web

Initialization

Content Security Policy

Configuration

Event Tracking

User Attributes

IDSync

Page View Tracking

Commerce Events

Location Tracking

Media

Kits

Application State and Session Management

Data Privacy Controls

Error Tracking

Opt Out

Custom Logger

Persistence

Native Web Views

Self-Hosting

Multiple Instances

Web SDK via Google Tag Manager

Preventing Blocked HTTP Traffic with CNAME

Facebook Instant Articles

Troubleshooting the Web SDK

Browser Compatibility

Linting Data Plans

API Reference

Upgrade to Version 2 of the SDK

Xamarin

Getting Started

Identity

Web

Alexa

Server SDKs

Node SDK

Go SDK

Python SDK

Ruby SDK

Java SDK

Tools

mParticle Command Line Interface

Linting Tools

Smartype

Media SDKs

Android

Web

iOS

Quickstart
Android

Overview

Step 1. Create an input

Step 2. Verify your input

Step 3. Set up your output

Step 4. Create a connection

Step 5. Verify your connection

Step 6. Track events

Step 7. Track user data

Step 8. Create a data plan

Step 9. Test your local app

HTTP Quick Start

Step 1. Create an input

Step 2. Create an output

Step 3. Verify output

iOS Quick Start

Overview

Step 1. Create an input

Step 2. Verify your input

Step 3. Set up your output

Step 4. Create a connection

Step 5. Verify your connection

Step 6. Track events

Step 7. Track user data

Step 8. Create a data plan

Java Quick Start

Step 1. Create an input

Step 2. Create an output

Step 3. Verify output

Node Quick Start

Step 1. Create an input

Step 2. Create an output

Step 3. Verify output

Python Quick Start

Step 1. Create an input

Step 2. Create an output

Step 3. Verify output

Web

Overview

Step 1. Create an input

Step 2. Verify your input

Step 3. Set up your output

Step 4. Create a connection

Step 5. Verify your connection

Step 6. Track events

Step 7. Track user data

Step 8. Create a data plan

Guides
Partners

Introduction

Outbound Integrations

Outbound Integrations

Firehose Java SDK

Inbound Integrations

Kit Integrations

Overview

Android Kit Integration

JavaScript Kit Integration

iOS Kit Integration

Data Hosting Locations

Compose ID

Glossary

Migrate from Segment to mParticle

Migrate from Segment to mParticle

Migrate from Segment to Client-side mParticle

Migrate from Segment to Server-side mParticle

Segment-to-mParticle Migration Reference

Rules Developer Guide

API Credential Management

The Developer's Guided Journey to mParticle

Guides

Getting Started

Create an Input

Start capturing data

Connect an Event Output

Create an Audience

Connect an Audience Output

Transform and Enhance Your Data

Platform Guide
The New mParticle Experience

The new mParticle Experience

The Overview Map

Observability

Observability Overview

Observability User Guide

Observability Span Glossary

Introduction

Data Retention

Connections

Activity

Live Stream

Data Filter

Rules

Tiered Events

mParticle Users and Roles

Analytics Free Trial

Troubleshooting mParticle

Usage metering for value-based pricing (VBP)

Analytics

Introduction

Setup

Sync and Activate Analytics User Segments in mParticle

User Segment Activation

Welcome Page Announcements

Settings

Project Settings

Roles and Teammates

Organization Settings

Global Project Filters

Portfolio Analytics

Analytics Data Manager

Analytics Data Manager Overview

Events

Event Properties

User Properties

Revenue Mapping

Export Data

UTM Guide

Query Builder

Data Dictionary

Query Builder Overview

Modify Filters With And/Or Clauses

Query-time Sampling

Query Notes

Filter Where Clauses

Event vs. User Properties

Group By Clauses

Annotations

Cross-tool Compatibility

Apply All for Filter Where Clauses

Date Range and Time Settings Overview

Understanding the Screen View Event

Analyses

Analyses Introduction

Segmentation: Basics

Getting Started

Visualization Options

For Clauses

Date Range and Time Settings

Calculator

Numerical Settings

Segmentation: Advanced

Assisted Analysis

Properties Explorer

Frequency in Segmentation

Trends in Segmentation

Did [not] Perform Clauses

Cumulative vs. Non-Cumulative Analysis in Segmentation

Total Count of vs. Users Who Performed

Save Your Segmentation Analysis

Export Results in Segmentation

Explore Users from Segmentation

Funnels: Basics

Getting Started with Funnels

Group By Settings

Conversion Window

Tracking Properties

Date Range and Time Settings

Visualization Options

Interpreting a Funnel Analysis

Funnels: Advanced

Group By

Filters

Conversion over Time

Conversion Order

Trends

Funnel Direction

Multi-path Funnels

Analyze as Cohort from Funnel

Save a Funnel Analysis

Explore Users from a Funnel

Export Results from a Funnel

Cohorts

Getting Started with Cohorts

Analysis Modes

Save a Cohort Analysis

Export Results

Explore Users

Saved Analyses

Manage Analyses in Dashboards

Journeys

Getting Started

Event Menu

Visualization

Ending Event

Save a Journey Analysis

Users

Getting Started

User Activity Timelines

Time Settings

Export Results

Save A User Analysis

Dashboards

Dashboards––Getting Started

Manage Dashboards

Organize Dashboards

Dashboard Filters

Scheduled Reports

Favorites

Time and Interval Settings in Dashboards

Query Notes in Dashboards

User Aliasing

Analytics Resources

The Demo Environment

Keyboard Shortcuts

Tutorials

Analytics for Marketers

Analytics for Product Managers

Compare Conversion Across Acquisition Sources

Analyze Product Feature Usage

Identify Points of User Friction

Time-based Subscription Analysis

Dashboard Tips and Tricks

Understand Product Stickiness

Optimize User Flow with A/B Testing

User Segments

APIs

User Segments Export API

Dashboard Filter API

IDSync

IDSync Overview

Use Cases for IDSync

Components of IDSync

Store and Organize User Data

Identify Users

Default IDSync Configuration

Profile Conversion Strategy

Profile Link Strategy

Profile Isolation Strategy

Best Match Strategy

Aliasing

Data Master
Group Identity

Overview

Create and Manage Group Definitions

Introduction

Catalog

Live Stream

Data Plans

Data Plans

Blocked Data Backfill Guide

Personalization
Predictive Attributes

Predictive Attributes Overview

Create Predictive Attributes

Assess and Troubleshoot Predictions

Use Predictive Attributes in Campaigns

Predictive Audiences

Predictive Audiences Overview

Using Predictive Audiences

Introduction

Profiles

Calculated Attributes

Calculated Attributes Overview

Using Calculated Attributes

Create with AI Assistance

Calculated Attributes Reference

Audiences

Audiences Overview

Real-time Audiences

Standard Audiences

Journeys

Journeys Overview

Manage Journeys

Download an audience from a journey

Audience A/B testing from a journey

Journeys 2.0

Warehouse Sync

Data Privacy Controls

Data Subject Requests

Default Service Limits

Feeds

Cross-Account Audience Sharing

Approved Sub-Processors

Import Data with CSV Files

Import Data with CSV Files

CSV File Reference

Glossary

Video Index

Analytics (Deprecated)
Identity Providers

Single Sign-On (SSO)

Setup Examples

Settings

Debug Console

Data Warehouse Delay Alerting

Introduction

Developer Docs

Introduction

Integrations

Introduction

Rudderstack

Google Tag Manager

Segment

Data Warehouses and Data Lakes

Advanced Data Warehouse Settings

AWS Kinesis (Snowplow)

AWS Redshift (Define Your Own Schema)

AWS S3 Integration (Define Your Own Schema)

AWS S3 (Snowplow Schema)

BigQuery (Snowplow Schema)

BigQuery Firebase Schema

BigQuery (Define Your Own Schema)

GCP BigQuery Export

Snowflake (Snowplow Schema)

Snowplow Schema Overview

Snowflake (Define Your Own Schema)

APIs

Dashboard Filter API (Deprecated)

REST API

User Segments Export API (Deprecated)

SDKs

SDKs Introduction

React Native

iOS

Android

Java

JavaScript

Python

Object API

Developer Basics

Aliasing

Integrations

24i

Event

Aarki

Audience

Abakus

Event

ABTasty

Audience

Actable

Feed

AdChemix

Event

Adikteev

Audience

Event

Adjust

Event

Feed

AdMedia

Audience

Adobe Marketing Cloud

Cookie Sync

Event

Adobe Audience Manager

Audience

Adobe Target

Audience

AdPredictive

Feed

Adobe Campaign Manager

Audience

Airship

Audience

Event

Feed

Algolia

Event

AgilOne

Event

AlgoLift

Event

Feed

Alooma

Event

Amazon Advertising

Audience

Amazon Kinesis

Event

Amazon Kinesis Firehose

Audience

Event

Amazon S3

Event

Amazon Redshift

Data Warehouse

Adobe Marketing Cloud

Event

Amazon SNS

Event

Amazon SQS

Event

Amobee

Audience

Amplitude

Event

Forwarding Data Subject Requests

Analytics

Audience

Event

Forwarding Data Subject Requests

Ampush

Audience

Event

AppsFlyer

Event

Feed

Forwarding Data Subject Requests

AppLovin

Audience

Event

Apptentive

Event

Anodot

Event

Apptimize

Event

Apteligent

Event

Attentive

Event

Feed

Attractor

Event

Batch

Event

Audience

Bidease

Audience

Bing Ads

Event

Bluecore

Event

Microsoft Azure Blob Storage

Event

Bluedot

Feed

Blueshift

Event

Feed

Forwarding Data Subject Requests

Branch

Event

Feed

Forwarding Data Subject Requests

Branch S2S Event

Event

Braze

Audience

Forwarding Data Subject Requests

Feed

Event

Button

Audience

Event

Cadent

Audience

Bugsnag

Event

Census

Feed

ciValue

Event

Feed

CleverTap

Event

Audience

Feed

comScore

Event

Conversant

Event

Cordial

Audience

Feed

Criteo

Audience

Event

Crossing Minds

Event

Cortex

Event

Feed

Forwarding Data Subject Requests

CustomerGlu

Event

Feed

Customer.io

Audience

Feed

Event

Databricks

Data Warehouse

Custom Feed

Custom Feed

Antavo

Feed

Datadog

Event

Dynalyst

Audience

Didomi

Event

Dynamic Yield

Audience

Event

Emarsys

Audience

Edge226

Audience

Epsilon

Event

Everflow

Audience

Facebook Offline Conversions

Event

Facebook

Event

Audience

Google Analytics for Firebase

Event

Flurry

Event

Fiksu

Audience

Event

Flybits

Event

ForeSee

Event

Formation

Event

Feed

Foursquare

Feed

Audience

FreeWheel Data Suite

Audience

Google Ads

Audience

Event

Google Analytics

Event

Google Ad Manager

Audience

Google Analytics 4

Event

Google BigQuery

Audience

Data Warehouse

Google Cloud Storage

Audience

Event

Google Enhanced Conversions

Event

Google Marketing Platform

Audience

Cookie Sync

Event

Google Pub/Sub

Event

Google Marketing Platform Offline Conversions

Event

Heap

Event

Herow

Feed

Google Tag Manager

Event

Hightouch

Feed

Hyperlocology

Event

Indicative

Event

Audience

Ibotta

Event

Impact

Event

InMarket

Audience

InMobi

Audience

Event

Insider

Audience

Event

Feed

Intercom

Event

Inspectlet

Event

iPost

Audience

Feed

ironSource

Audience

Jampp

Audience

Event

Iterable

Audience

Feed

Event

Kafka

Event

Kayzen

Audience

Event

Kissmetrics

Event

Kochava

Feed

Event

Forwarding Data Subject Requests

Klaviyo

Audience

Event

Kubit

Event

LaunchDarkly

Feed

Leanplum

Feed

Event

Audience

LifeStreet

Audience

Liftoff

Audience

Event

LiveLike

Event

Liveramp

Audience

MadHive

Audience

mAdme Technologies

Event

Mailchimp

Audience

Event

Feed

Localytics

Event

Marigold

Audience

Mautic

Audience

Event

MediaMath

Audience

Mediasmart

Audience

Microsoft Azure Event Hubs

Event

Mixpanel

Audience

Forwarding Data Subject Requests

Event

MoEngage

Audience

Feed

Event

Mintegral

Audience

Moloco

Event

Audience

Monetate

Event

Movable Ink

Event

Movable Ink - V2

Event

Multiplied

Event

Nanigans

Event

myTarget

Audience

Event

Nami ML

Feed

Narrative

Audience

Event

Feed

NCR Aloha

Event

Optimizely

Audience

Event

Neura

Event

OneTrust

Event

Oracle BlueKai

Event

Paytronix

Feed

Oracle Responsys

Event

Audience

Persona.ly

Audience

PieEye

Inbound Data Subject Requests

Personify XP

Event

Plarin

Event

Pilgrim

Feed

Event

Pinterest

Event

Audience

Postie

Event

Audience

Punchh

Audience

Event

Feed

Primer

Event

Qualtrics

Event

Pushwoosh

Event

Audience

Quantcast

Event

Radar

Event

Feed

Remerge

Event

Audience

Reddit

Audience

Event

Regal

Event

Retina AI

Event

Feed

Reveal Mobile

Event

Rokt

Audience

RTB House

Audience

Event

Sailthru

Audience

Event

RevenueCat

Feed

Salesforce Email

Audience

Feed

Event

Salesforce Mobile Push

Event

Samba TV

Audience

Event

Scalarr

Event

SendGrid

Audience

Feed

SessionM

Event

Feed

ShareThis

Audience

Feed

Shopify

Custom Pixel

Feed

Signal

Event

SimpleReach

Event

Singular

Event

Feed

Singular-DEPRECATED

Event

Skyhook

Event

Slack

Event

SmarterHQ

Event

Snapchat

Event

Audience

Snapchat Conversions

Event

Smadex

Audience

Snowplow

Event

Snowflake

Data Warehouse

Split

Event

Feed

Sprig

Audience

Event

Splunk MINT

Event

StartApp

Audience

Statsig

Event

Feed

Stormly

Audience

Event

Swrve

Feed

Event

Talon.One

Audience

Event

Feed

Tapad

Audience

Tapjoy

Audience

Taptica

Audience

Taplytics

Event

Teak

Audience

The Trade Desk

Audience

Cookie Sync

Event

Ticketure

Feed

TikTok Event

Audience

Audience (Deprecated)

Event

Audience Migration

Triton Digital

Audience

Quadratic Labs

Event

Treasure Data

Audience

Event

Valid

Event

Twitter

Audience

Event

TUNE

Event

Vkontakte

Audience

Vungle

Audience

Voucherify

Audience

Event

Webhook

Event

Webtrends

Event

White Label Loyalty

Event

Xandr

Audience

Cookie Sync

Wootric

Event

YouAppi

Audience

Yahoo (formerly Verizon Media)

Audience

Cookie Sync

Z2A Digital

Audience

Event

Yotpo

Feed

Zendesk

Event

Feed

Data Warehouse

The mParticle integration for Google BigQuery allows you to forward your incoming data to a BigQuery dataset, where you can query it directly.

After configuration, mParticle’s back-end services will perform the following actions in your BigQuery dataset:

  1. Store each app’s data in a separate set of tables.
  2. Create a table for each custom event name as well as each eCommerce event name that has occurred at least once in the last 30 days. All other message types (e.g., session start, session end, screen views, etc.) will be put into a single table called [Table Prefix]_“otherevents”.
  3. Stream data into each table accordingly. Loaded data should be available for analysis within a few seconds of streaming insertion into a table.
  4. Set expiration time according to the data retention policy configured on the mParticle UI.

Note that mParticle begins loading current data into BigQuery from the time the integration is enabled. You can work with mParticle customer support team to load historical data.

BigQuery Configuration

To load data, please complete the following steps.

  1. Enable BigQuery in your project in Google Cloud Platform.
  2. From the IAM page for your project, add mparticle-gcp-clientfacing@gcp-prod-170221.iam.gserviceaccount.com as a member with the BigQuery Job User and Project Viewer roles.
  3. From the BigQuery page for your project:

    • Create a dataset to load your app into.
    • Click on Share Dataset on the dataset page.
    • Add mparticle-gcp-clientfacing@gcp-prod-170221.iam.gserviceaccount.com with the BigQuery Data Editor and Project Viewer roles.
      medium
  4. This step is optional, if you want to sync data downstream using Storage API instead of Streaming API. The default Use Storage API Data Sync configuration setting is set to false and mParticle uses Streaming API endpoint for data sync. However, if you wish to use Storage API, you must first enable access to Storage API in your Google project and then set the Use Storage API Data Sync configuration setting in mParticle to true.
  5. Log into mParticle platform, and navigate to the BigQuery page.
  • Enter your BigQuery projectId (note that it may be different from your project name) and the datasetId of the dataset created in step 3.

  • Enter your BigQuery table prefix
  • Choose from the dropdown your preferred partition time granularity. None is set by default and it will use weekly sharding tables. If you choose any other option, that value will be used as it’s time-unit partitioning using the event timestamp.
  • BigQuery supports clustering upto four columns. Select the Clustering Columns in your preferred order to perform clustering. Note: If no columns are selected and partitioning is enabled in the above step, clustering will be done on eventtimestamp. Also, this setting is only applicable if partitioning is enabled.
  • Optionally, you may configure a data retention policy that will apply at table level for sharding or partition level for partions.
  1. Connect individual inputs to the BigQuery output from the Connections page. You must connect every input you want to store data for.

mParticle Setup

After adding Google BigQuery from the integrations Directory, you can find the settings UI at Setup > Data Warehouse.

From the main page for your Google BigQuery configuration, select the Settings tab to provide the necessary settings to get your Google BigQuery integration working.

To forward data subject erasure requests to Google BigQuery, set the Forwarding Status toggle to Active and select I understand after reading the disclaimer. Once the status has been set to Active, erasure requests are sent to Google BigQuery immediately upon being received by mParticle.

Connection Settings

Setting Name Data Type Default Value Platform Description
BigQuery Table Name string Feed Table name for this partner feed. If not set, the partner name will be used. Only applicable to feeds inputs, no effect on apps inputs. If “Split Partner Feed Data by Event Name” checkbox is enabled, this setting is not used.
Split Partner Feed Data by Event Name boolean False Feed If enabled, split partner feed data by event name. Otherwise load data into the same table.
Send Batches without Events boolean True All If enabled, an event batch that contains no events will be forwarded.

Optional Steps

You can upload your own JSON BigQuery service account credentials using the Google Service Account Key JSON (Optional) field in the Data Warehouse > Settings page. If you do not provide your custom credentials, mParticle’s Google service account credentials will used. The image below shows a sample JSON configuration file.

After successfully saving the configurations, data loading should start within a few minutes, and you can view the data load status on the mParticle BigQuery page.

BigQuery Schema

All of your data is stored in one single BigQuery dataset.

Each app has its own set of tables. Each table name has a table name prefix. This will be the name of your app, except for data from Feeds, for which you can customize the prefix in the Connection Settings.

By default, each custom event name and eCommerce event name have their own table in BigQuery dataset, and all other event names (e.g., session-start, session-end) are stored in a single table. The naming conversion of the table names are as follows.

  • A custom event name will have a table named [Table Prefix]_event_[event type]_[event name]. For example, a Navigation type event named SignUp from an app named “my cool app” will have a table named mycoolapp_event_navigation_signup.
  • An eCommerce event name will have a table named [Table Prefix]_ecomm_[event name].
  • All other events are stored in a table named [Table Prefix]_otherevents.

Additionaly, the partition time granularity and clustering columns setting will impact in how data is physically stored and how table names are resolved. On top of what’s mentioned above:

  • If partition time granularity is set to None (default value) data is stored by week using a sharding approach and clustering is not performed in this case. Each table name has a date value as an appendix, the date value is the date of the Sunday of a week. For example, you’ll see table names like mycoolapp_event_navigation_signup20160424, mycoolapp_event_navigation_signup20160417, mycoolapp_event_navigation_signup20160410, etc.
  • Otherwise, for any other option, the choosen time frame will be used to enable the bigquery time partitioning over the eventtimestamp column, and the subsequent selected clustering columns or eventtimestamp (if no columns are selected) will be used for clustering optimizations. The choosen time partitioning option will be appended as a constant literal at the end of the table. If you choose Day it will end up being mycoolapp_event_navigation_signup_day or mycoolapp_event_navigation_signup_month for Month, etc. That allows to update the partition time granularity setting with the overdraw that it’s sent to a new different table since it’s not allowed to update the configuration in an existing table.

Any update on the data retention policy setting after a table creation would not have effect on the existing tables. When using sharding that implies that the change will take effect on the next weekly table creation. In the case of partitioned tables, it will only have effect if the table prefix or partition time granularity is updated too which may lead into a new table creation (if it does not exist yet). For updates on your existing tables you will need to do a manual update from your BigQuery console.

Each table has the following fields.

Field Name Data Type Data Mode Description
appid INTEGER NULLABLE mParticle app Id
appplatformid INTEGER NULLABLE mParticle AppPlatformId, e.g., Google Now app has iOS platform and Android platform, and each platform has an unique mParticle AppPlatformId
appname STRING NULLABLE App name
appversion STRING NULLABLE App version
packagename STRING NULLABLE App package name
apparchitecture STRING NULLABLE App architecture
ispirated BOOLEAN NULLABLE Is the device pirated?
applicationbuildnumber STRING NULLABLE Application build number
isdebugsigning BOOLEAN NULLABLE Is the app debug signing?
upgradedate TIMESTAMP NULLABLE App upgrade timestamp
appenvironment STRING NULLABLE App environment, debug or production
installreferrer STRING NULLABLE Install referrer
brand STRING NULLABLE Device brand
product STRING NULLABLE Device product
devicename STRING NULLABLE Device name
deviceudid STRING NULLABLE Device UDID
manufacturer STRING NULLABLE Device manufacturer
platform STRING NULLABLE Device platform
osversion STRING NULLABLE Device OS version
devicemodel STRING NULLABLE Device model
localecountry STRING NULLABLE Device’s locale country
localelanguage STRING NULLABLE Device’s locale language
networkcountry STRING NULLABLE Network country
networkcarrier STRING NULLABLE Network carrier name
screenheight INTEGER NULLABLE Device’s screen height
screenwidth INTEGER NULLABLE Device’s screen width
screendpi INTEGER NULLABLE Device’s screen dpi
deviceutcoffset INTEGER NULLABLE Device UTC offset
osversionint INTEGER NULLABLE Android OS version int
idfa STRING NULLABLE iOS IDFA
googleaid STRING NULLABLE Android Google Advertising ID
architecture STRING NULLABLE Device architecture
istablet BOOLEAN NULLABLE Is the device a tablet?
vendoridentifier STRING NULLABLE iOS vendor identifier
pushtoken STRING NULLABLE Push token
attributionserviceprovider STRING NULLABLE Attribution service provider name
attributionpublisher STRING NULLABLE Attributed publisher name
attributioncampaign STRING NULLABLE Attributed campaign name
mparticleuserid INTEGER NULLABLE UserId assigned by mParticle
customerid STRING NULLABLE User’s customerID, usually this is the unique userId in your system
facebookid STRING NULLABLE User’s Facebook user Id
twitterid STRING NULLABLE User’s Twitter ID
googleuserid STRING NULLABLE User’s Google ID
microsoftuserid STRING NULLABLE User’s Microsoft ID
yahoouserid STRING NULLABLE User’s Yahoo ID
email STRING NULLABLE User’s email
otheruserid STRING NULLABLE “Other” type user identity
otheruserid2 STRING NULLABLE “Other2” type user identity
otheruserid3 STRING NULLABLE “Other3” type user identity
otheruserid4 STRING NULLABLE “Other4” type user identity
isdebug BOOLEAN NULLABLE True for debug environment and false for production environment
batchid INTEGER NULLABLE A unique ID of the batch
batchtimestamp TIMESTAMP NULLABLE Batch timestamp
sdkversion STRING NULLABLE mParticle SDK version
clientip STRING NULLABLE Client IP address
accumulatedltvvalue FLOAT NULLABLE Accumulated LTV value of a user
entrypointtype INTEGER NULLABLE Type of incoming data, 1 means from SDK and 128 means from S2S
countrycode STRING NULLABLE Country code
cityname STRING NULLABLE City name
postalcode STRING NULLABLE Postal code
regioncode STRING NULLABLE Geo region code
latitude FLOAT NULLABLE Geo latitude
longitude FLOAT NULLABLE Geo longitude
accuracy FLOAT NULLABLE Geo accuracy
sessionid INTEGER NULLABLE A unique ID of the session
sessionstarttimestamp TIMESTAMP NULLABLE Session start timestamp
eventid INTEGER NULLABLE A unique ID of the event
eventtimestamp TIMESTAMP NULLABLE Event timestamp
messagetypeid INTEGER NULLABLE Message Type Id
eventstarttimestamp TIMESTAMP NULLABLE Event start timestamp
eventname STRING NULLABLE Event name
eventtypeid INTEGER NULLABLE Event type Id
eventlength INTEGER NULLABLE How long did the event take? Represents session length in milliseonds on session end events
eventltvvalue FLOAT NULLABLE Monetary value extracted from the event
dataconnectiontype STRING NULLABLE Data connection type
exceptionhandled BOOLEAN NULLABLE Handled exception or crash
firstseentimestamp TIMESTAMP NULLABLE Timestamp of the first event on this user
isfirstrunevent BOOLEAN NULLABLE Is this a first run event?
isupgradeevent BOOLEAN NULLABLE Is this an app upgrade event?
successfullyclosed BOOLEAN NULLABLE Is the last session successfully closed? Will be false if app is forcefully killed
applicationtransitiontypeid INTEGER NULLABLE Applicaiton Transition TypeId
samplingpercentage INTEGER NULLABLE Not used
ecommercescreenname STRING NULLABLE eCommerce screen name
ecommerceisnoninteractive BOOLEAN NULLABLE Is eCommerce action interactive?
productactiontypeid INTEGER NULLABLE eCommerce Product Action Type Id
0 = unknown
1 = add_to_cart
2 = remove_from_cart
3 = checkout
4 = checkout_option
5 = click
6 = view_detail
7 = purchase
8 = refund
9 = add_to_wishlist
10 = remove_from_wishlist
promotionactiontypeid INTEGER NULLABLE Promotion Action Type Id
0 = unknown
1 = view
2 = click
attauthorizationstatus STRING NULLABLE iOS 14 ATT Authorization status
atttimestamp TIMESTAMP NULLABLE iOS 14 ATT Authorization status timestamp
httpheaderuseragent STRING NULLABLE User-Agent field from the HTTP Header
mparticledeviceid STRING NULLABLE mParticle Device Stamp
eventattributes RECORD REPEATED A repeated field containing a list of event attribute key value pairs
eventattributes.attributename STRING NULLABLE Event attribute name
eventattributes.attributevalue STRING NULLABLE Event attribute value
userattributes RECORD REPEATED A repeated field containing a list of user attribute key value pairs
userattributes.attributename STRING NULLABLE User attribute name
userattributes.attributevalue STRING NULLABLE User attribute value
jailbroken RECORD REPEATED Device’s jailbroken status
jailbroken.attributename STRING NULLABLE Jailbroken attribute name
jailbroken.attributevalue STRING NULLABLE Jailbroken attribute value
eventcustomflags RECORD REPEATED Event custom flags
eventcustomflags.attributename STRING NULLABLE Custom flag attribute name
eventcustomflags.attributevalue STRING NULLABLE Custom flag attribute value
audiencemembership RECORD REPEATED A repeated field containing mParticle segment ID’s the user was a member of at the time of the event
audiencemembership.audienceid INTEGER NULLABLE mParticle segment ID
productimpressions RECORD REPEATED A repeated field containing a list of product impressions
productimpressions.productimpressionlist STRING NULLABLE Product impression list name
productimpressions.product_id STRING NULLABLE Product Id
productimpressions.product_name STRING NULLABLE Product name
productimpressions.product_brand STRING NULLABLE Product brand
productimpressions.product_category STRING NULLABLE Product category
productimpressions.product_variant STRING NULLABLE Product variant
productimpressions.product_position INTEGER NULLABLE Product position
productimpressions.product_price FLOAT NULLABLE Product price
productimpressions.product_quantity FLOAT NULLABLE Product quantity
productimpressions.product_couponcode STRING NULLABLE Product coupon code
productimpressions.product_attributes STRING NULLABLE JSON string of all product attributes
productimpressions.product_addedtocarttimestamp TIMESTAMP NULLABLE Added to cart timestamp
productimpressions.product_totalproductamount FLOAT NULLABLE Total product amount
productaction RECORD NULLABLE Product action information
productaction.actiontype INTEGER NULLABLE eCommerce Product Action Type Id
0 = unknown
1 = add_to_cart
2 = remove_from_cart
3 = checkout
4 = checkout_option
5 = click
6 = view_detail
7 = purchase
8 = refund
9 = add_to_wishlist
10 = remove_from_wishlist
productaction.checkoutstep INTEGER NULLABLE Checkout step
productaction.checkoutoptions STRING NULLABLE Checkout options
productaction.productactionlist STRING NULLABLE Product action list
productaction.productlistsource STRING NULLABLE Product list source
productaction.transactionid STRING NULLABLE Transaction id
productaction.affiliation STRING NULLABLE Transaction affiliation
productaction.totalamount FLOAT NULLABLE Transaction total amount
productaction.taxamount FLOAT NULLABLE Transaction tax amount
productaction.shippingamount FLOAT NULLABLE Transaction shipping amount
productaction.couponcode STRING NULLABLE Transaction coupon code
productactionproducts RECORD REPEATED A repeated field containing a list of products associate with a product action
productactionproducts.product_id STRING NULLABLE Product Id
productactionproducts.product_name STRING NULLABLE Product name
productactionproducts.product_brand STRING NULLABLE Product brand
productactionproducts.product_category STRING NULLABLE Product category
productactionproducts.product_variant STRING NULLABLE Product variant
productactionproducts.product_position INTEGER NULLABLE Product position
productactionproducts.product_price FLOAT NULLABLE Product price
productactionproducts.product_quantity FLOAT NULLABLE Prodict quantity
productactionproducts.product_couponcode STRING NULLABLE Product coupon code
productactionproducts.product_attributes STRING NULLABLE JSON string of all product attributes
productactionproducts.product_addedtocarttimestamp TIMESTAMP NULLABLE Added to cart timestamp
productactionproducts.product_totalproductamount FLOAT NULLABLE Total product amount
promotionaction RECORD REPEATED A repeated field containing a list of eCommerce product promotions
promotionaction.promotion_action_type INTEGER NULLABLE eCommerce Promotion Action Type Id
0 = unknown
1 = view
2 = click
promotionaction.promotion_id STRING NULLABLE Promotion Id
promotionaction.promotion_name STRING NULLABLE Promotion name
promotionaction.promotion_creative STRING NULLABLE Promotion creative
promotionaction.promotion_position STRING NULLABLE Promotion position
shoppingcart RECORD REPEATED A repeated field containing a list of products in a shopping cart
shoppingcart.product_id STRING NULLABLE Product Id
shoppingcart.product_name STRING NULLABLE Product name
shoppingcart.product_brand STRING NULLABLE Product brand
shoppingcart.product_category STRING NULLABLE Product category
shoppingcart.product_variant STRING NULLABLE Product variant
shoppingcart.product_position INTEGER NULLABLE Product position
shoppingcart.product_price FLOAT NULLABLE Product price
shoppingcart.product_quantity FLOAT NULLABLE Prodict quantity
shoppingcart.product_couponcode STRING NULLABLE Product coupon code
shoppingcart.product_attributes STRING NULLABLE JSON string of all product attributes
shoppingcart.product_addedtocarttimestamp TIMESTAMP NULLABLE Added to cart timestamp
shoppingcart.product_totalproductamount FLOAT NULLABLE Total product amount

Supported identities

The following user identities can be forwarded to Google BigQuery:

  • customerid
  • email
  • other
  • other2
  • other3
  • other4
  • other5
  • other6
  • other7
  • other8
  • other9
  • other10
  • mobilenumber
  • phonenumber2
  • phonenumber3

Partner Feed Data

Events from each connected Partner Feed will be stored under a single table unless the Split Partner Feed Data by Event Name checkbox is enabled. You can choose the table name for each Feed in the Connection Settings. If you do not provide a name, mParticle will use the name of the Partner.

medium

Device Application Stamp Forwarding

Events can be forwarded with a Device Application Stamp stored in the device ID column. You can enable this in the settings page for your data warehouse configuration by toggling the Store Device Stamp checkbox.

Best Practices

  1. Query a specific table whenever possible. Doing this lowers your BigQuery bill since BigQuery charges by how much data is queried.
  2. For the same reason as above, only include the fields you really want in a query whenever possible.
  3. When counting number of distinct elements, BigQuery use estimation by HyperLogLog by default. To get an exact count, use “count(distinct fieldName, n)”, which tells BigQuery to use estimation only if there are more than n number of unique elements.
  4. When dealing with more than one repeated field, use FLATTEN operator. When using FLATTEN operator and table wildcard functions together, reference the following example:

    -- calculate daily signups from facebook US users
    SELECT
      DATE(EventTimestamp),
      COUNT(*)
    FROM
      FLATTEN((
        SELECT
          *
        FROM
          TABLE_QUERY([myproject:mydataset], 'table_id contains "mycoolapp"')), eventattributes)
    WHERE
      EventName = 'SignUp'
      AND EventAttributes.attributename = 'Sign Up Method'
      AND EventAttributes.attributevalue = 'Facebook'
      AND UserAttributes.attributename = 'Country'
      AND UserAttributes.attributevalue = 'US'
    GROUP BY 1
    ORDER BY 1
    Last Updated: December 5, 2024