Integrations
Looker is a business intelligence software and big data analytics platform that helps you explore, analyze and share real-time business analytics easily. Looker gives you the ability to define complex segments from your data warehouse, and run calculations on your data. The Looker Feed allows you to import segments, calculations, and insights back into mParticle for activation.
You can find Looker’s documentation on this integration here.
Send event data (impressions and actions) or user data (gender, LTV, audience memberships aggregated at the user level)
For every identity you want to recieve from Looker, you must create a dimension in the LookML to map the Looker identifier to its corresponding mParticle identifier.
Sample LookML:
dimension: email {
tags: [“mp_email”]
sql: ${TABLE}.email ;;
}
mParticle Key | Looker Tag |
---|---|
mp_email |
|
customer_id | mp_customer_id |
mp_facebook |
|
mp_google |
|
microsoft | mp_microsoft |
mp_twitter |
|
yahoo | mp_yahoo |
other | mp_other |
other2 | mp_other2 |
other3 | mp_other3 |
other4 | mp_other4 |
mParticle Field | Looker Tag | Description |
---|---|---|
User Attribute | mp_user_attribute |
To send Looker user attributes to mParticle you must create a dimension in the LookML to map the Looker attribute to the mp_user_attribute tag.All looker dimensions with this tag will get sent over as user attributes to mParticle with the following name: looker_<looker_view_name>.<looker_dimension_name> |
Sample LookML:
dimension: ltv {
type: number
sql: ${TABLE}.ltv ;;
value_format: “$#,##0.00”
tags: [“mp_user_attribute”]
}
If the above dimension were defined in a Looker view named users
, the resulting mParticle user attribute would be looker_users.ltv
.
Looker will send Custom Events to mParticle along with event attributes as described below.
mParticle Field | Looker Tag | Description |
---|---|---|
Event Name | mp_event_name |
|
Custom Event Type | mp_custom_event_type |
The custom event type, per mParticle’s custom events schema. |
Event Attributes | mp_custom_attribute |
To send Looker user attributes to mParticle you must create a dimension in the LookML to map the Looker attribute to the mp_custom_attribute tag.All Looker dimensions with this tag will get sent over as devices to mParticle as follows: custom_attributes.looker_<looker_view_name>.<looker_dimension_name> |
Device Info | mp_device_info |
To send Looker attributes to mParticle as device info attributes you must create a dimension in the LookML to map the Looker attribute to the mp_device_info tag.Looker dimensions with this tag will get sent to mParticle as device_info fields only if the dimension name matches one of mParticle’s predefined device_info fields. |
Sample LookML:
dimension: category {
type: number
sql: ${TABLE}.category ;;
tags: [“mp_custom_attribute”]
}
If the above dimension were defined in a Looker view named events
, the resulting mParticle event attribute would be looker_events.category
.
Was this page helpful?