At a glance: PBA raw data reports are available via Data Locker.
PBA raw data reports
Use PBA raw data reports to analyze user journeys and actions.
Report descriptions
PBA raw data report topics
Raw data report topic | Description |
---|---|
Website visits |
|
|
|
|
|
|
Raw-data report fields
Website visits and website events
Sample reports
Raw data fields are populated in part from data originating in the mobile app user attribution link and app install event.
Field list website visits and website events report:
Field name | Description | Format | Example |
---|---|---|---|
advertising_id | Advertising ID (GAID) | String | 7fzzz3fa-8bad-46c9-bb03-fffffffffffffffffffffffff |
af_web_id | Cookie ID sent from the web SDK | String | 68972980-58f9-4ca6-8743-c0d633364b6d |
amazon_aid | Amazon Fire TV advertising ID | String | df07c7dc-cea7-4a89-b328-810ff5acb15d |
android_id | Android device ID | String | 68999980-58f9-4ca6-8743-c0d633364b6d |
app_id | The most recent app ID installed | String | id123456789 |
app_name | The most recent app name | String | My App |
app_version | The most recent app version | String | 6.32 |
appsflyer_id | AppsFlyer (install) ID | String | 1594825729709-5655157112349378588 |
attributed_touch_time | On web visits, the timestamp of the web visit On web events, the timestamp of the attributed web visit | yyyy-mm-dd hh:mm:ss | 9/17/2020 0:09:25 |
attributed_touch_type | The type of touchpoint. Currently, always set to website visit. | String | web visit |
bundle_id | PBA bundle ID | String | 048db9bf-97r7-4m2f-919b-607b7kk806d0 |
campaign | Attributed to the website visit | String | Summer Campaign |
campaign_id | Attributed to the website visit | String | 12343425 |
city | Resolved using the IP address | String | Spring Valley |
country_code | Resolved using the IP address | String | US |
customer_user_id | Customer User Identifier (CUID) | String | 5a8771ecbb986ABC |
device_type | The type of device | String | Desktop |
dma | Resolved using the IP address | String | 501 |
event_name | In the website visit report: Always website visit. In the website event report: eventName sent by the web SDK. | String | purchase |
event_revenue | Event revenue amount in purchase currency | String | 199.99 |
event_revenue_currency | 3 digit currency code of the event_revenue | String | USD, ZAR, EUR |
event_revenue_usd | event_revenue converted to USD | String | 57.46 |
event_source | Either web SDK or Server-to-server | String | web SDK, S2S |
event_time | Website visits: time of visit Website event: time of event | yyyy-mm-dd hh:mm:ss | 9/17/2020 0:09:25 |
event_type | The following: Standard event, conversion event, website visit | String | conversion event |
event_url | URL of the webpage where event occurred (Equals Original URL in website visits) | String | http://www.brandpit.com/checkout |
event_value | Website events: Event value details contained in a JSON. Website visits: Always null | JSON | {"sku": "ABC123", “color": "blue", "unit_price":3.99,"currency": "USD"} |
idfa | Advertising identifier | String | A56B9887-FEBA-458C-BEFC-C891F9DF7681 |
idfv | Advertising identifier | String | EBC2F523-B1E5-4484-A4C8-ADC32DC7C23D |
imei | Device identifier | String | 3532211234 |
install_time | The most recent app install time | yyyy-mm-dd hh:mm:ss | 9/17/2020 0:09:25 |
ip | Visitor IP address | String | 24.7.104.115 |
language | Reported by user agent | String | English |
media_channel | Attribtued to the website visit | String | Ad |
media_source | Attribtued to the website visit | String | googleadwords_int |
media_type | Attribtued to the website visit | String | Paid |
oaid | Advertising identifier | String | df07c7dc-cea7-4a89-b328-810ff5acb15d |
original_url | URL address redirecting the user to the website on the attributed website visit | String | https://www.brandpitt.com/signin?utm_source=Googleg&utm_term=shoes&utm_campaign=cool&c=summer&af_siteid=publisher&af_sub1=helloworld |
platform | The platform | String | macOS |
postal_code | Resolved using the IP address | String | 10977 |
query_params | Query params on the redirecting URL (after the ?) Example: https://www.brandpitt.com/signin?utm_source=Google&utm_term=shoes&utm_campaign=cool&c=summer&af_siteid=publisher&af_sub1=helloworld&af_keyword=shoes If URL has no query params, the value will be null | JSON | {"c":"summer",af_siteid":"publisher",af_sub1":helloworld",af_keywords":"shoes","utm_source":"Google","utm_campaign":"cool","utm_term":"shoes"} |
referrer | HTTP document referrer of the attributed website visit | String | https://www.google.com/ |
region | Resolved using the IP address | String | NA |
state | Resolved using the IP address | String | NY |
Website-assisted installs
The record structure of the report is as follows:
- The record fields are grouped as follows:
- Event: The install conversion event.
- Touchpoint: Touchpoints encountered prior to the install conversion.
- An install conversion consists of one or more touchpoints. Each touchpoint has a record in raw data. The install_id groups the touchpoints of an install together.
Example web to app report:
Website assisted installs
Field group | Field name | Description |
---|---|---|
Event | bundle_name | Brand bundle name configured in the Brand Bundle page |
Event | bundle_id | Brand bundle ID |
Event | app_id |
App ID |
Event | install_id | Unique install ID grouping the touchpoints of the user journey. Calculated as bundle_id+appsflyer_id+install_time |
Event | appsflyer_id | AppsFlyer ID assigned to a mobile device when a user installs an app |
Event | install_time | Install time |
Event | install_name |
install, reinstall (meaning a user who installed the app, deleted it, and then installed it again) irrespective of the reinstall cause. |
Event | install_type |
Install type: organic_install, custom_link_install, smart_banner_install, non-organic_install |
Event | final_data |
True or False: If true, the row is final. Example: Install takes place on January 1. For the next 7 days, report rows associated with this install contain the value false under the final_data column On January 8, the conversion is finalized and the value changes to true. Reports starting January 9 no longer contain the install. |
Event | mobile_media_source | The mobile media source engaged last, before the install |
Event | mobile_campaign | The campaign engaged last, before the install |
Event | mobile_campaign_id |
The campaign ID engaged last, before the install |
Event | mobile_device_category |
Device type used: phone, tablet |
Touchpoint | touchpoint_contirubtion |
This filed replaces path_touch_type now deprecated. |
Event | mobile_platform |
Device operating system: Android, iOS |
Event | mobile_country | Country of install according to the device IP address |
Touchpoint | web_timestamp |
Time the web touchpoint occurred |
Touchpoint | web_media_source | Web media source touchpoint |
Touchpoint | web_campaign | Web campaign touchpoint |
Touchpoint | web_campaign_id | Web campaign ID touchpoint |
Touchpoint | web_media_type | |
Touchpoint | web_media_channel | |
Touchpoint | web_device_category |
Value for this touchpoint: Desktop, other, smartphone, tv, tablet |
Touchpoint | web_platform |
The operating system of the device used for the touchpoint: Android, iOS, Windows, macOS, Chrome-os, Linux |
Touchpoint | web_country | Touchpoint country |
Touchpoint | web_pid | UTM value for website visits |
Touchpoint | web_utm_source |
UTM value for website visits |
Touchpoint | web_utm_medium |
UTM value for website visits |
Touchpoint | web_utm_campaign |
UTM value for website visits |
Touchpoint | web_utm_content |
UTM value for website visits |
Touchpoint | web_utm_term |
UTM term (keywords) parameter at a touchpoint |
Touchpoint | web_referrer |
The HTTP referrer of the web visit that the install was attributed to. |
Touchpoint | web_googleads_campaign_id |
Campaign ID provided by Google Ads integration (Available from August 6, 2020) |
Touchpoint | web_googleads_campaign_name |
Campaign name provided by Google Ads integration (Available from August 6, 2020) |
Touchpoint | web_utm_id |
UTM value for website visits |
Event | customer_user_id | Customer user ID as set by the web SDK |
Touchpoint | idfa |
The ID of the device installing the app |
Touchpoint | idfv | The ID of the device installing the app |
Touchpoint | android_id | The ID of the device installing the app |
Touchpoint | advertising_id | The ID of the device installing the app |
Touchpoint | amazon_fire_id | The ID of the device installing the app |
Touchpoint | imei | The ID of the device installing the app |
Conversion paths
Report record structure
- Fields grouped as follows:
- Event: The conversion event and associated information.
- Touchpoint: Details of a touchpoint in the path to conversion.
- A conversion consists of one or more touchpoints. In the file, each touchpoint is represented by a record.
Example Conversion Paths report
Conversion_paths_example_oct20.csv
Conversion paths fields
Field group | Field name | Description |
---|---|---|
Event | conversion_id | Unique conversion ID grouping the touchpoints of a conversion. Calculated as bundle_id+appsflyer_id+conversion_time |
Event | bundle_name |
Brand bundle name set in the brand bundle page
|
Event | bundle_id | Brand bundle ID |
Event | final_data |
True or False: If true, the row is final. Example: A conversion takes place on January 1. For the next 7 days, report rows associated with this conversion contain the value false under the final_data column On January 8, the conversion is finalized and the value changes to true. Reports starting January 9 no longer contain the conversion. |
Event | conversion_type | mobile_conversion, web_converson, install |
Event | app_id | App ID |
Event | appsflyer_id |
ID assigned to a mobile device when a user installs an app
|
Event | conversion_time | - |
Event | conversion_name | Sent by web SDK or web S2S, or the in-app event name sent by the mobile device/mobile S2S. |
Event | conversion_media_source | Attributed media source |
Event | conversion_campaign | Attributed campaign |
Event | conversion_campaign_id |
Attributed campaign ID
|
Event | conversion_media_type |
Attributed media type: Paid, owned, earned
|
Event | conversion_media_channel |
Attributed media channel: Direct, organic search, social media, email, ad, referral
|
Event | conversion_device_category | Device category: Phone, tablet, desktop |
Event | conversion_platform | Platform, for example, MacOs, windows |
Event | conversion_country | User location |
Event | conversion_url |
Web conversions: the page the conversion took place on.
Mobile: Null |
Touchpoint | touchpoint_time | - |
Touchpoint | touchpoint_type | Web visit, mobile click, mobile impression |
Touchpoint | touchpoint_media_source | - |
Touchpoint | touchpoint_campaign | - |
Touchpoint | touchpoint_campaign_id | - |
Touchpoint | touchpoint_media_type | Paid, owned, earned |
Touchpoint | touchpoint_media_channel |
Direct, organic search, social media, email, ad, referral
|
Touchpoint | touchpoint_device_category | Phone, tablet |
Touchpoint | touchpoint_platform | Android, iOS |
Touchpoint | touchpoint_country | Country code |
Touchpoint | touchpoint_utm_source | UTM values for website visits |
Touchpoint | touchpoint_utm_medium | UTM values for website visits |
Touchpoint | touchpoint_utm_campaign | UTM values for website visits |
Touchpoint | touchpoint_utm_content | UTM values for website visits |
Touchpoint | touchpoint_utm_term | UTM values for website visits |
Touchpoint | touchpoint_utm_id | UTM values for website visits |
Touchpoint | touchpoint_referrer | URL referring the user to the website for this touchpoint. In the case of a mobile touchpoint, the value will be null. |
Touchpoint | web_googleads_campaign_id |
Campaign ID provided by Google Ads integration. (Available from August 6, 2020) |
Touchpoint | web_googleads_campaign_name |
Campaign name provided by Google Ads integration. (Available from August 6, 2020) |
Event | customer_user_id | Customer user ID went with the vent |
Event | idfa | Device ID used during the conversion |
Event | idfv | Device ID used during the conversion |
Event | android_id | Device ID used during the conversion |
Event | advertising_id | Device ID used during the conversion |
Event | amazon_fire_id | Device ID used during the conversion |
Event | imei | Device ID used during the conversion |
Field release notes
Date | Report | Change |
---|---|---|
2020-01-17 | Website-Assisted Installs |
The name of the report in Data Locker has changed. |
2020-11-18 |
Website events Website visits |
The report names and structure are changed:
|
2020-10-04 | Web-to-app |
Fields added:
|
2020-10-04 | Conversion paths |
Fields added:
|
Procedures
Setting up PBA reports in Data Locker
- PBA reports are written Daily to the Data Locker in h=23 folder for events occurring on a given day.
- Data can't be written retroactively.
To enable PBA reports an account admin must set up Data Locker:
- Go to Integration > Data Locker.
- Select all the reports in the People-Based Attribution section.
- Click Save configuration.
To download reports, see accessing Data Locker reports.
Data Locker PBA raw data reports are made available in the h=23 folder.
Example: t=website_events/dt=2020-11-26/h=23
Combining PBA and mobile data
The data reflects the users most likely to engage with both your mobile app and website.
Combine mobile app and website data.
Solution:
- Combine reports using customer user ID (CUID)
- Use the same CUID for both mobile and web and combine reports using CUID as the key.
- Then, combine reports using the CUID field
- PBA cross-platform user identification:
- PBA can determine that a web and a mobile user are the same person.
- If so, then web reports with PBA include a mobile advertising ID: Android advertising ID, iOS IDFA, OAID, or Amazon advertising ID.
- Then, combine mobile and web reports based on mobile advertising ID.
Use cases for PBA and mobile
Combine mobile and web data to see user activity across platforms and devices. The combined data lets you:
- Follow the user journey across your brand's digital properties
- Analyze user behavior in each platform
- Consider which platform shows more user engagement
- See which platform produces more conversions
- Measure your efforts at switching users from web to mobile
Application note - downloading and combining Data Locker files
PBA raw data is available in Data Locker. For a given report, the data is contained in the h=23 folder of report type and consists of multiple compressed files.
Use this procedure to:
- Copy the files from Data Locker using Cyber-Duck or any other tool for copying S3 files.
- Combine the files into a single CSV file using Q.
Copying PBA data from Data Locker
Before you begin:
To copy data using Cyber Duck:
- Open Cyberduck
The list of data types available displays.
-
Double-click on a PBA report type and choose from web_events, web_to_app, or web_touch_points.
The list of report dates available displays. - Right-click on a given date.
- Select Download to a specific location and complete the location.
The files download. - Repeat the above steps to copy data from other report types. Each report type and date must be stored in a different directory on your computer.
Creating a combined CSV file:
Before you begin:
Install Q on your computer.
To combine the data in a CSV file using Q:
- Using the command line/maс terminal, go to the directory containing the data.
- Use the command that follows to combine the compressed files into a single file having the name pbadata.csv.
Note: The symbol ~ represents the path/home folder where the Q command is located on your computer. You may need to include the full path to invoke the command.
~q "SELECT * from part*.gz" -d , -H -z -O >pbadata.csv
- Open the file using Excel or any other tool