---
title: Column Definitions for Raw Data
url: "https://tenjin.com/docs/column-definitions-for-raw-data/"
updated: "2026-09-28"
category: Data Exports
---

# Column Definitions for Raw Data

RDE and CDE exports use the same columns. The columns in your file depend on the event types you select. A column can be empty when it doesn’t apply to a row or the data isn’t available.

## Column definitions

 ColumnTypeDescriptionExampleacquired_attimestampWhen the user was acquired (attributed).2026-08-20 09:00:00ad_mediation_ad_formatstringAd Format of the impression, such as banner, interstitial, rewarded, native, or MREC.Rewardedad_mediation_networkstringAd Network that served the impression.AdMobad_mediation_placementstringAd placement name or ID.rewarded_homead_mediation_providerstringMediation platform that reported the impression.maxad_mediation_revenue_microcentsbigintImpression revenue in USD microcents. Divide by 100,000,000 to get USD.22000 (= USD 0.00022)ad_network_namestringAd Network of the attributed campaign.Google Adsadvertising_idstringAdvertising ID: IDFA on iOS, GAID on Android, Fire Advertising ID on Amazon, OAID on other Android stores. Empty when the user limits ad tracking or doesn’t allow tracking.29eeb1610fe74997b6d53f02e9711f8canalytics_installation_idstringTenjin ID for the app installation. Changes when the app is reinstalled.f024e65f3dd94f16983726bcef192d68app_idstringTenjin app ID.ee270433-b7da-4e0f-9b03-8dd25d89da49app_namestringApp name in Tenjin.Word Searchapp_versionstringApp version.3.2.1attributablebooleanWhether the click or impression could be used for Attribution.trueattribution_strategystringHow the user was attributed, such as click or impression.clickbundle_idstringiOS Bundle ID or Android package name.com.example.gamecampaign_idstringTenjin campaign ID.b1d67331-204b-4ee3-9cac-7c0f0f33b5bfcampaign_namestringCampaign name.US_iOS_WordSearch_Q1coarse_conversion_valuestringSKAN coarse Conversion value: low, medium, or high.mediumconversion_valueintegerSKAN fine Conversion value (0–63).33countrystringTwo-letter country code.UScreated_attimestampWhen the event happened.2026-08-24 14:32:00creative_idstringTenjin creative ID.c1d2e3f4-a5b6-7890-c1d2-e3f4a5b67890creative_namestringCreative name.spring_video_01currencystringCurrency code of the transaction.USDcustomer_user_idstringYour user ID, if you set one in the SDK or S2S integration.user_12345developer_device_idstringIDFV on iOS, App Set ID on Android.b6bc48fe0ce949e4b229ce6c55663fcadevicestringDevice model.iPhone15,2engaged_attimestampWhen the attributed click or impression happened.2026-08-19 17:32:00engagement_typestringType of the attributed engagement: click or impression.clickeventstringEvent name: open for app opens, your event name for custom events, or the subscription status (see Subscription Event values).level_completeevent_typestringRow type: event, purchase, subscription, click, impression, Install, or reinstall.purchasefraud_processed_attimestampWhen Tenjin flagged the record as fraud.2026-08-24 14:35:12fraud_reason_codestringWhy Tenjin flagged the record as fraud.FRAUDULENT_PURCHASEfraud_rule_idstringID of the fraud rule that flagged the record.5948c959-ba2e-4b9c-b365-bbd5e8b88341iab_tcfstringIAB TCF purpose-consent string from the device.11011ip_addressstringIP address of the device.203.0.113.10limit_ad_trackinginteger1 if the user limits ad tracking, 0 if not.1lock_windowbooleanSKAN flag to lock the Conversion window early.falseos_versionstringOperating system version.17.6platformstringApp platform: ios, android, amazon, or android_other.androidpricedoublePrice per unit, in the transaction currency.9.99product_idstringStore product ID.com.example.game.coinpack1purchase_stateintegerReceipt validation result (see purchase_state values).3quantityintegerNumber of units purchased.1receiptstringStore receipt of the purchase. On iOS, a Base64-encoded App Store receipt. On Android, the Google Play purchase data as JSON.iOS: MIIT0wYJKoZIhvcNAQcC… ; Android: {“orderId”:”GPA.0000-0000-0000-00000″, …}referrerstringInstall referrer (Android).utm_source=exampleremote_campaign_idstringCampaign ID from the Ad Network.6026825090762remote_click_idstringClick or impression ID from the Ad Network.network_click_123remote_creative_idstringCreative ID from the Ad Network.23851234567890123revenuebigintNet revenue in USD cents, after the store’s cut. Divide by 100 to get USD.699sdk_versionstringTenjin SDK version.1.17.4site_idstringSub-publisher or source app ID from the Ad Network.publisher_42source_campaign_idstringTenjin ID of the campaign the user was attributed to.18a0c1d6-02a2-4188-bbc0-0fe38dbcc37esource_uuidstringID of the click or impression the user was attributed to. Matches uuid in Ad Engagements exports.0df8ccda-372b-4e9e-8fdc-dfa0eb0c333estore_deductionstringCustom store deduction set for the app, if any.0.15store_idstringApp store ID.887212194sub_campaignstringAd set or ad group from the Ad Network.adset_winter_saletotal_revenuebigintGross revenue in USD cents, before the store’s cut. Divide by 100 to get USD.999tracking_statusintegeriOS App Tracking Transparency status (see tracking_status values).3transaction_idstringStore transaction ID.GPA.0000-0000-0000-00000user_agentstringUser agent of the device.Mozilla/5.0 …uuidstringUnique ID of the row.a3e3e535-a32c-4887-9c91-3160c91b3876valuebigintValue sent with a custom event.42

## Subscription Event values

 ValueMeaningtrial_newFree trial started.trialFree trial still active.active_newPaid subscription started.activePaid subscription renewed or still active.churnUser turned off auto-renew. Subscription is active until the period ends.trial_churnUser turned off auto-renew during the free trial.cancelledSubscription expired.

## purchase_state values

 ValueMeaning0Unknowable: no receipt was sent.1Unverified: the receipt couldn’t be verified with the store.2Fraudulent: the receipt failed validation.3Verified: the receipt was validated with the store.4Sandbox: test purchase.5Duplicate: the purchase was already recorded.6Stale: the purchase arrived more than three days late.

## tracking_status values

 ValueMeaning0Not determined1Restricted2Denied3Authorized