Tenjin的DataVault schema是其功能的核心。来自不同地方的所有信息都可以通过id很好地结合在一起。通过以这种方式组织信息，DataVault可以轻松地构建准确的模型和分析。
Tables 数据表 #
- events 事件
- 来自 Tenjin SDK 或第三方归因提供商的设备层级数据
- campaigns 广告活动
- 新增用户来源的广告活动，或者来自广告变现平台 API 的广告计划
- ad_networks 广告平台
- 广告平台的列表
- apps 应用
- 应用列表
- daily_country_spend 分国家每日广告消耗
- 包含细分广告计划和国家的安装前事件（比如展示、点击、安装以及花费等）。“spend（花费）” 指换算为 USD 的广告花费总额， “original_spend（原始花费）” 指 “original_currency（原始货币）”形式下的广告花费总额
- publisher_apps 开发者应用
- 通过广告变现平台 API 获取的开发者广告计划数据
- daily_ad_revenue 每日广告变现收入
- 包含细分开发者广告系列、日期和国家/地区的广告变现收入数据
- ad_engagements
- 只支持非自归因广告平台，包含细分设备的点击或展示数据。请注意：此数据表默认不启用，详情请咨询您在 Tenjin 的客户经理
- reporting_metrics 报告指标
- 与面板盘上指标相同步的所有非群组数据指标
- reporting_cohort_metrics 报告群组指标
- 与面板上指标相同步的所有群组数据指标
- sk_ad_networks
- SK Ad Network ID 到 Tenjin 的特定 ID 的映射
- skan_ad_network_metrics
- 通过 SK Ad Network 回传接收到的关于转换值和维度的汇总报告
- skan_apple_metrics
- 从 Apple 接收到的关于转换值和维度的汇总报告
- 与
sk_ad_network_metrics数据表有着相同的列。但是，因为Apple回传数据的限制，campaign_id列是空的
- installs
- 应用安装事件，Tenjin SDK提供
- ad_mediation_impressions_preview
- 从聚合获取到的展示层级的收益数据。注意，请联系客户经理咨询此数据集的开通。
- user_attributes
- 包括用户的归因
字段清单 #
(S): Sort Key 排序键
(D): Dist Key 分配键
events 事件 #
| Column | 说明 | Example value 例值 |
|---|---|---|
| created_at (S) | 创建事件的时间戳 | 2018-07-01 00:00:00 |
| advertising_id | iOS 的 IDFA 或 Android 的 Google Advertising ID。小写，不带连字符。 | 29eeb1610fe74997b6d53f02e9711f8c |
| bundle_id | 应用的包名 bundle ID（我们会将包名转化为小写） | com.tenjin.wordfinder |
| platform | App发布的平台 | ios or android |
| os_version | 设备的操作系统版本 | 8.0 |
| app_version | 应用版本 | 1.0.3 |
| limit_ad_tracking | 用户限制广告跟踪 (0 否,1 是) | 1 |
| app_id | Tenjin 的内部应用 id。可以与 apps 应用表中的id字段进行连接 | ee270433-b7da-4e0f-9b03-8dd25d89da49 |
| event_type | 事件类型为“事件”或“购买” | event |
| event | event_type=event,事件时，该值为 open或自定义事件名称。 | open |
| source_campaign_id | Tenjin 内部的广告计划 id。可以与 campaigns 广告计划表中的id进行连接 | 18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e |
| acquired_at | 用户获取的时间戳 | 2018-07-01 00:00:00 |
| price | 付费事件的原始单价 | 1.99 |
| quantity | 付费事件的采购数 | 2 |
| product_id | 付费事件的产品id | com.tenjin.wordfinder.package50 |
| currency | 付费事件的货币代码 | USD |
| country | 国家代码 | US |
| total_revenue | 付费事件的总收入（美元） 美分 | 350 |
| revenue | 付费事件的净收入（美元） 美分 | 245 |
| site_id | 广告计划的发布者ID（对于付费推广广告） | |
| developer_device_id | iOS 的 IDFV。Android 则为空。小写，不带连字符。 | b6bc48fe0ce949e4b229ce6c55663fca |
| purchase_state |
| 3 |
| value | 自定义事件值 | 1 |
| uuid | unique event ID | a3e3e535-a32c-4887-9c91-3160c91b3876 |
| device | 设备类型 | iPad2,5 |
| creative_name | 素材名称 | test_creative |
| ip_address | 用户的IP地址 | 71.165.85.114 |
| source_uuid | 如果该广告活动是付费投放，则为点击或展示事件的UUID。该UUID可以与ad_engagements表中的uuid进行关联。 | 0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e |
| loaded_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
| tracking_status | iOS设备的ATT状态。0=>未确定，1=>受限制，2=>拒绝，3=>已授权 | 3 |
| analytics_installation_id | 应用安装专用标识符，小写且不包含连字符。 | f024e65f3dd94f16983726bcef192d68 |
| customer_user_id | 来自App的用户ID，由setCustomerUserId SDK方法设置。 | jdabGcerT32_d |
campaigns 广告活动 #
| Column | 说明 | Example value 例值 |
|---|---|---|
| id | Campaign的独特ID | 3b70e477-c151-4167-9174-cca6ffa2c7bc |
| name | Campaign名 | test @bYkiNAbrAOCpzETWviMILo |
| ad_network_id | 广告渠道的ID（即该Campaign所属的广告渠道）。可与ad_networks表中的id字段进行关联。 | 3 |
| app_id | Tenjin 的内部应用 id。可以与 apps 应用表中的id字段进行连接 | ee270433-b7da-4e0f-9b03-8dd25d89da49 |
| remote_campaign_id | 广告渠道使用的campaign_id。我们通过广告渠道的Reporting API获取该ID。 | 6026825090762 |
| campaign_bucket_id | 用于对campaign进行分组的campaign bucket id。可以通过该id与campaign_buckets表中的id进行关联。 | fbbc74bd-8a73-472a-86f7-5e2a4642a201 |
| updated_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
| loaded_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
ad_networks 广告平台 #
| Column | 说明 | Example value 例值 |
|---|---|---|
| id (S) | 广告渠道的独特ID | 3 |
| name | 广告渠道名 | |
| updated_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
apps 应用 #
| Column | 说明 | Example value 例值 |
|---|---|---|
| id | App的独特ID | ee270433-b7da-4e0f-9b03-8dd25d89da49 |
| name | App名 | Word Search |
| store_id | App的store ID | 887212194 |
| bundle_id | App的包名 | com.tenjin.wordfinder |
| platform | App发布的平台 | ios or android |
| updated_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
| loaded_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
daily_country_spend 分国家每日广告消耗 #
| Column | 说明 | Example value 例值 |
|---|---|---|
| id | 消耗数据的独特ID | 174491158 |
| date (S) | date when the spend happens | 2018-07-01 |
| country | country where the spend happens | US |
| campaign_id (D) | ID for the campaign. This can be joined with id in the campaigns table | b1d67331-204b-4ee3-9cac-7c0f0f33b5bf |
| spend | Ad Spend amount in USD cents. | 400 |
| installs | number of installs reported | 8 |
| clicks | number of clicks reported | 10 |
| impressions | number of impressions reported | 126 |
| original_spend | Ad Spend amount in original currency | 4 |
| original_currency | original currency | USD |
| updated_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
| loaded_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
| missing_country | if country info was missing for the spend that the Ad Network sent | false |
publisher_apps 开发者应用 #
| Column | 说明 | Example value 例值 |
|---|---|---|
| id | unique ID for the publisher app | b71ff0ab-f1b4-4ca6-98fc-0064a5b9d1d7 |
| ad_network_id | id for the Ad Network publisher campaign is attributed to. It can be joined with id in ad_networks table | 1 |
| app_id | Tenjin 的内部应用 id。可以与 apps 应用表中的id字段进行连接 | ee270433-b7da-4e0f-9b03-8dd25d89da49 |
| name | name of the publisher campaign | Word Search! Free-ios-Tapjoy |
| updated_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
| loaded_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
daily_ad_revenue 每日广告变现收入 #
| Column | 说明 | Example value 例值 |
|---|---|---|
| id | unique ID for the ad revenue | 107852371 |
| date (S) | date when the ad revenue happens | 2018-07-01 |
| publisher_app_id (D) | ID for the publisher campaign. This can be joined with id in the publisher_apps table | b71ff0ab-f1b4-4ca6-98fc-0064a5b9d1d7 |
| country | country for the metrics | US |
| revenue | ad revenue amount in USD cents | 20000 |
| conversions | number of conversions reported | 8 |
| clicks | number of clicks reported | 10 |
| impressions | number of impressions reported | 126 |
| interstitial_revenue | ad revenue amount in USD cents for Interstitial ads | 20000 |
| interstitial_conversions | number of conversions reported for Interstitial ads | 8 |
| interstitial_clicks | number of clicks reported for Interstitial ads | 10 |
| interstitial_impressions | number of impressions reported for Interstitial ads | 126 |
| banner_revenue | ad revenue amount in USD cents for banner ads | 20000 |
| banner_conversions | number of conversions reported for banner ads | 8 |
| banner_clicks | number of clicks reported for banner ads | 10 |
| banner_impressions | number of impressions reported for banner ads | 126 |
| native_revenue | ad revenue amount in USD cents for native ads | 20000 |
| native_conversions | number of conversions reported for native ads | 8 |
| native_clicks | number of clicks reported for native ads | 10 |
| native_impressions | number of impressions reported for native ads | 126 |
| offerwall_revenue | ad revenue amount in USD cents for offerwall ads | 20000 |
| offerwall_conversions | number of conversions reported for offerwall ads | 8 |
| offerwall_clicks | number of clicks reported for offerwall ads | 10 |
| offerwall_impressions | number of impressions reported for offerwall ads | 126 |
| video_revenue | ad revenue amount in USD cents for video ads | 20000 |
| video_conversions | number of conversions reported for video ads | 8 |
| video_clicks | number of clicks reported for video ads | 10 |
| video_impressions | number of impressions reported for video ads | 126 |
| other_revenue | ad revenue amount in USD cents for other ads | 20000 |
| other_conversions | number of conversions reported for other ads | 8 |
| other_clicks | number of clicks reported for other ads | 10 |
| other_impressions | number of impressions reported for other ads | 126 |
| updated_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
| loaded_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
ad_engagements #
| Column | 说明 | Example value 例值 |
|---|---|---|
| created_at (S) | 创建事件的时间戳 | 2018-07-01 00:00:00 |
| advertising_id | iOS 的 IDFA 或 Android 的 Google Advertising ID。小写，不带连字符。 | 29eeb1610fe74997b6d53f02e9711f8c |
| attributable | if the click/impression is used for Attribution or not. true or false | true |
| event_type | either clicks or impressions | clicks |
| campaign_id | ID for the campaign. This can be joined with id in the campaigns table | b1d67331-204b-4ee3-9cac-7c0f0f33b5bf |
| bundle_id | App的包名 | com.tenjin.wordfinder |
| platform | App发布的平台 | ios or anroid |
| ip_address | 用户的IP地址 | 71.165.85.114 |
| limit_ad_tracking | user’s limit ad tracking | (0,1) |
| uuid | unique ID for the event. It can be joined with source_uuid events table | 0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e |
| app_id | Tenjin 的内部应用 id。可以与 apps 应用表中的id字段进行连接 | ee270433-b7da-4e0f-9b03-8dd25d89da49 |
| country | 国家代码 | US |
| site_id | 广告计划的发布者ID（对于付费推广广告） | |
| user_agent | User Agent | Dalvik/2.1.0 (Linux; U; Android 8.0.0; SM-G570M Build/R16NW) |
| remote_click_id | click id ad-networks passes through the click url. | DSGfaa |
| loaded_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
| tracking_status | iOS设备的ATT状态。0=>未确定，1=>受限制，2=>拒绝，3=>已授权 | 3 |
| analytics_installation_id | 应用安装专用标识符，小写且不包含连字符。 | f024e65f3dd94f16983726bcef192d68 |
reporting_metrics 报告指标 #
| Column | 说明 | Example value 例值 |
|---|---|---|
| date (S) | date the metric applies to | 2018-11-01 |
| ad_network_id | Tenjin ID of the Ad Network | 3 |
| platform | App发布的平台 | ios or android |
| app_id | Tenjin ID of the app | ee270433-b7da-4e0f-9b03-8dd25d89da49 |
| campaign_id | Tenjin ID of the campaign | b1d67331-204b-4ee3-9cac-7c0f0f33b5bf |
| country | two-letter country code | US |
| site_id | 网站 ID | |
| daily_active_users | unique devices seen | 105 |
| sessions | count of app open events | 23650 |
| iap_revenue | sum of in-app purchase revenue in USD cents | 245 |
| reported_spend | allocated spend from Ad Network reporting APIs in cents | 5323 |
| reported_impressions | allocated impressions from Ad Network reporting APIs | 13000 |
| reported_clicks | allocated clicks from Ad Network reporting APIs | 3000 |
| reported_installs报告激活 | allocated installs from Ad Network reporting APIs | 4000 |
| publisher_ad_revenue | allocated sum of publisher ad revenue from Ad Network reporting API in USD cents | 2000 |
| tracked_impressions | count of impressions tracked by Tenjin Attribution | 13000 |
| tracked_clicks | count of clicks tracked by Tenjin Attribution | 4000 |
| tracked_installs追踪激活 | count of installs tracked by Tenjin Attribution | 3000 |
| loaded_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
reporting_cohort_metrics 报告群组指标 #
| Column | 说明 | Example value 例值 |
|---|---|---|
| event_date (S) | date current cohort the metrics apply to | 2018-11-01 |
| install_date | date of the Install | 2018-10-01 |
| days_since_install | days since Install | 3 |
| platform | App发布的平台 | ios or anroid |
| app_id | Tenjin ID of the app | ee270433-b7da-4e0f-9b03-8dd25d89da49 |
| campaign_id | Tenjin ID of the campaign | b1d67331-204b-4ee3-9cac-7c0f0f33b5bf |
| country | two-letter country code | US |
| site_id | 网站 ID | |
| daily_active_users | unique devices seen | 105 |
| sessions | count of app open events | 23650 |
| iap_revenue | sum of in-app purchase revenue in USD cents | 245 |
| publisher_ad_revenue | allocated sum of publisher ad revenue from Ad Network reporting API in USD cents | 2000 |
| loaded_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
For reporting_cohort_metrics use the install_date and days_since_install to get metrics as in the dashboard. ex:
Plaintext
SELECT install_date AS DATE, apps.name as app_name, ad_networks.name as ad_network, country, SUM(CASE WHEN days_since_install <= 1 THEN (publisher_ad_revenue + iap_revenue) / 100.0 ELSE 0 END) AS d1_total_LTV, SUM(CASE WHEN days_since_install <= 2 THEN (publisher_ad_revenue + iap_revenue) / 100.0 ELSE 0 END) AS d2_total_LTV, SUM(CASE WHEN days_since_install <= 3 THEN (publisher_ad_revenue + iap_revenue) / 100.0 ELSE 0 END) AS d3_total_LTV, SUM(CASE WHEN days_since_install = 1 THEN daily_active_users ELSE 0 END) AS d1_retained_users, SUM(CASE WHEN days_since_install = 2 THEN daily_active_users ELSE 0 END) AS d2_retained_users, SUM(CASE WHEN days_since_install = 3 THEN daily_active_users ELSE 0 END) AS d3_retained_users FROM reporting_cohort_metrics LEFT JOIN apps ON apps.id = reporting_cohort_metrics.app_id LEFT JOIN bucket_campaign_info ON bucket_campaign_info.id = reporting_cohort_metrics.campaign_id LEFT JOIN ad_networks ON ad_networks.id = bucket_campaign_info.ad_network_id WHERE install_date = '2018-10-11' GROUP BY 1, 2, 3, 4 LIMIT 10 sk_ad_networks #
Contact your Account Manager to access this table.
| Column | 说明 | Example value 例值 |
|---|---|---|
| id(S) | Lowercase string SK Ad Network ID for the Ad Network. | “cstr6suwn9.SKAdNetwork” |
| ad_network_id | Integer Tenjin-specific ID for the Ad Network. Can be joined via ad_networks.id | 5 |
| updated_at | Timestamp representing when the record was last updated. | 2021-01-01 00:00:00 |
| loaded_at | Timestamp representing when the record was last loaded into DataVault. | 2021-01-01 00:00:00 |
skan_ad_network_metrics #
Contact your Account Manager to access this table.
| Column | 说明 | Example value 例值 |
|---|---|---|
| date(S) | Date the SK Ad Network postback was received. | 2021-01-01 |
| sk_ad_network_id | Lowercase string SK Ad Network ID for the Ad Network. | “cstr6suwn9.SKAdNetwork” |
| ad_network_id | Integer Tenjin-specific ID for the Ad Network. Can be joined via ad_networks.id | 5 |
| sk_app_id | Integer SK App ID of the App being advertised. Equivalent to apps.store_id for iOS Apps. | 1478027094 |
| app_id | UUID Tenjin-specific ID for the App. Can be joined via apps.id. | “9668185b-da2e-4638-b15f-e03431377ac5” |
| sk_campaign_id | SK Campaign ID, an Integer from 0-99. | 10 |
| campaign_id | UUID Tenjin-specific ID for the Campaign. Can be joined via campaigns.id | “61817a78-0a8f-4e83-98c0-8106f7a6ea92” |
| sk_source_app_id | String representing the App that showed the advertisement that led to a Conversion. | “284882215” |
| fidelity_type | 1 for StoreKit Ads, 0 for view-through ads. | 1 |
| conversion_value | Conversion Value, an Integer from 0-63. | 33 |
| conversion_value_count | Integer count of occurrences of the conversion_value. | 250 |
| redownload_count | Integer count of occurrences of the conversion_value that were redownloads. | 11 |
| assist_count | Integer count of occurrences of the conversion_value that were assists. | 2 |
| redownload_assist_count | Integer count of occurrences of the conversion_value that were both redownloads and assists. | 1 |
| loaded_at | Timestamp representing when the record was last loaded into DataVault. | 2021-01-01 00:00:00 |
skan_apple_metrics #
| Column | 说明 | Example value 例值 |
|---|---|---|
| date(S) | Date the SK Ad Network postback was received. | 2021-01-01 |
| sk_ad_network_id | Lowercase string SK Ad Network ID for the Ad Network. | “cstr6suwn9.SKAdNetwork” |
| ad_network_id | Integer Tenjin-specific ID for the Ad Network. Can be joined via ad_networks.id | 5 |
| sk_app_id | Integer SK App ID of the App being advertised. Equivalent to apps.store_id for iOS Apps. | 1478027094 |
| app_id | UUID Tenjin-specific ID for the App. Can be joined via apps.id. | “9668185b-da2e-4638-b15f-e03431377ac5” |
| sk_campaign_id | SK Campaign ID, an Integer from 0-99. | 10 |
| campaign_id | UUID Tenjin-specific ID for the Campaign. Always null, as Apple does not provide any way to get this value. | null |
| sk_source_app_id | String representing the App that showed the advertisement that led to a Conversion. | “284882215” |
| fidelity_type | 1 for StoreKit Ads, 0 for view-through ads. | 1 |
| conversion_value | Conversion Value, an Integer from 0-63. | 33 |
| conversion_value_count | Integer count of occurrences of the conversion_value. | 250 |
| redownload_count | Integer count of occurrences of the conversion_value that were redownloads. | 11 |
| assist_count | Integer count of occurrences of the conversion_value that were assists. | 2 |
| redownload_assist_count | Integer count of occurrences of the conversion_value that were both redownloads and assists. | 1 |
| loaded_at | Timestamp representing when the record was last loaded into DataVault. | 2021-01-01 00:00:00 |
installs #
| Column | 说明 | Example value 例值 |
|---|---|---|
| created_at | 创建事件的时间戳 | 2018-11-01 00:00:00 |
| advertising_id | IDFA for iOS or Google advertising ID for Android. Lower case, without hyphen | 29eeb1610fe74997b6d53f02e9711f8c |
| bundle_id | 应用的包名 bundle ID（我们会将包名转化为小写） | com.tenjin.wordfinder |
| platform | App发布的平台 | ios or android |
| os_version | 设备的操作系统版本 | 8.0 |
| app_version | 应用版本 | 1.0.3 |
| limit_ad_tracking | 用户限制广告跟踪 (0 否,1 是) | 1 |
| app_id | Tenjin 的内部应用 id。可以与 apps 应用表中的id字段进行连接 | ee270433-b7da-4e0f-9b03-8dd25d89da49 |
| source_campaign_id | Tenjin 内部的广告计划 id。可以与 campaigns 广告计划表中的id进行连接 | 18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e |
| acquired_at | 用户获取的时间戳 | 2018-10-01 00:00:00 |
| country | 国家代码 | US |
| site_id | 广告计划的发布者ID（对于付费推广广告） | |
| developer_device_id | IDFV for iOS. Empty for Android. Lower case, without hyphen | b6bc48fe0ce949e4b229ce6c55663fca |
| uuid | unique event ID | a3e3e535-a32c-4887-9c91-3160c91b3876 |
| device | 设备类型 | iPAD 2,5 |
| creative_name | 素材名称 | test_creative |
| ip_address | 用户的IP地址 | 71.165.85.114 |
| source_uuid | 如果该广告活动是付费投放，则为点击或展示事件的UUID。该UUID可以与ad_engagements表中的uuid进行关联。 | 0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e |
| loaded_at | DataVault中被更新时的时间戳 | 2018-10-01 00:00:00 |
| tracking_status | iOS设备的ATT状态。0=>未确定，1=>受限制，2=>拒绝，3=>已授权 | 3 |
| analytics_installation_id | Tenjin generated Application Install-specific identifier. Lower case, without hyphen | f024e65f3dd94f16983726bcef192d68 |
ad_mediation_impressions_preview #
Contact your Account Manager to access this table
| Column | 说明 | Example value 例值 |
|---|---|---|
| acquired_at | 用户获取的时间戳 | 2018-11-01 00:00:00 |
| ad_mediation_ad_format | Format of the Ad unit | 横幅 |
| ad_mediation_network | 展示广告的渠道 | Applovin |
| ad_mediation_placement | 广告渠道定义的广告位 | my_banner_placement |
| ad_mediation_provider | Ad mediation provider | Applovin MAX |
| ad_mediation_revenue_microcents | Ad revenue in microscents as provided by the mediation provider | 22000 |
| advertising_id | iOS 的 IDFA 或 Android 的 Google Advertising ID。小写，不带连字符。 | 29eeb1610fe74997b6d53f02e9711f8c |
| analytics_installation_id | Application Install-specific identifier for Android devices. Used for analytics when a user does not consent to sharing their Google advertising id. (Empty for iOS.) Lower case, without hyphen. | f024e65f3dd94f16983726bcef192d68 |
| app_id | Tenjin 的内部应用 id。可以与 apps 应用表中的id字段进行连接 | ee270433-b7da-4e0f-9b03-8dd25d89da49 |
| app_version | 应用版本 | 1.0.3 |
| bundle_id | 应用的包名 bundle ID（我们会将包名转化为小写） | com.tenjin.wordfinder |
| country | 国家代码 | US |
| created_at | 创建事件的时间戳 | 2018-11-01 00:00:00 |
| creative_name | 素材名称 | test_creative |
| customer_user_id | 来自App的用户ID，由setCustomerUserId SDK方法设置。 | jdabGcerT32_d |
| developer_device_id | IDFV for iOS. Empty for Android. Lower case, without hyphen | b6bc48fe0ce949e4b229ce6c55663fca |
| device | 设备类型 | iPAD 2.5 |
| engaged_at | Timestamp for the click/impression event the user interacted with before acquisition | 2018-01-01 00:00:00 |
| ip_address | 用户的IP地址 | 71.165.85.114 |
| limit_ad_tracking | user’s limit ad tracking | (0,1) |
| loaded_at | DataVault中被更新时的时间戳 | 2018-07-01 00:00:00 |
| os_version | 设备的操作系统版本 | 8.0 |
| platform | App发布的平台 | 8.0 |
| sdk_version | Tenjin SDK版本 | 12.2.22 |
| site_id | 广告计划的发布者ID（对于付费推广广告） | |
| source_campaign_id | Tenjin 内部的广告计划 id。可以与 campaigns 广告计划表中的id进行连接 | 18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e |
| source_uuid | UUID for the impression event if the campaign was paid campaign. It can be joined with uuid in ad_engagements table | 0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e |
| tracking_status | iOS设备的ATT状态。0=>未确定，1=>受限制，2=>拒绝，3=>已授权 | 3 |
| uuid | unique ID for the event. It can be joined with source_uuid events table | 0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e |
user_attributes #
| Column | 说明 | Example value 例值 |
|---|---|---|
| advertising_id | iOS 的 IDFA 或 Android 的 Google Advertising ID。小写，不带连字符。 | 29eeb1610fe74997b6d53f02e9711f8c |
| limit_ad_tracking | 用户限制广告跟踪 (0 否,1 是) | 1 |
| acquired_at | 用户获取的时间戳 | 2018-07-01 00:00:00 |
| country | 国家代码 | US |
| site_id | 广告计划的发布者ID（对于付费推广广告） | |
| developer_device_id | iOS 的 IDFV。Android 则为空。小写，不带连字符。 | b6bc48fe0ce949e4b229ce6c55663fca |
| analytics_installation_id | 应用安装专用标识符，小写且不包含连字符。 | f024e65f3dd94f16983726bcef192d68 |
| source_campaign_id | Tenjin 内部的广告计划 id。可以与 campaigns 广告计划表中的id进行连接 | 18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e |
| tracking_status | iOS设备的ATT状态。0=>未确定，1=>受限制，2=>拒绝，3=>已授权 | 3 |
| last_seen | timestamp when the user was last seen | 2018-07-01 00:00:00 |
回溯期 #
以下这些 tables 数据表的历史数据取决于回溯期。如果你想了解 DataVault 数据仓库的回溯窗口，请联系 Tenjin 的客户经理。
- events 事件
- ad_engagements
- reporting_metrics 报告指标
- reporting_cohort_metrics 报告群组指标
