{"id":15474,"date":"2026-02-20T07:06:12","date_gmt":"2026-02-20T07:06:12","guid":{"rendered":"http:\/\/mariusz.bijok"},"modified":"2026-03-17T17:57:28","modified_gmt":"2026-03-17T17:57:28","password":"","slug":"datavault-schema-and-tables","status":"publish","type":"docs","link":"https:\/\/tenjin.com\/zh\/docs\/datavault-schema-and-tables\/","title":{"rendered":"DataVault\u6570\u636e\u7ed3\u6784\u548c\u56fe\u8868"},"content":{"rendered":"<p class=\"translation-block\">Tenjin\u7684DataVault schema\u662f\u5176\u529f\u80fd\u7684\u6838\u5fc3\u3002\u6765\u81ea\u4e0d\u540c\u5730\u65b9\u7684\u6240\u6709\u4fe1\u606f\u90fd\u53ef\u4ee5\u901a\u8fc7<code>id<\/code>\u5f88\u597d\u5730\u7ed3\u5408\u5728\u4e00\u8d77\u3002\u901a\u8fc7\u4ee5\u8fd9\u79cd\u65b9\u5f0f\u7ec4\u7ec7\u4fe1\u606f\uff0cDataVault\u53ef\u4ee5\u8f7b\u677e\u5730\u6784\u5efa\u51c6\u786e\u7684\u6a21\u578b\u548c\u5206\u6790\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Tables \u6570\u636e\u8868<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#0\" style=\"text-decoration:none\">events \u4e8b\u4ef6<\/a>\n<ul class=\"wp-block-list\">\n<li>device level data that comes from Tenjin SDK or 3rd party attribution provider<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#1\" style=\"text-decoration:none\">campaigns \u5e7f\u544a\u6d3b\u52a8<\/a>\n<ul class=\"wp-block-list\">\n<li>\u65b0\u589e\u7528\u6237\u6765\u6e90\u7684\u5e7f\u544a\u6d3b\u52a8\uff0c\u6216\u8005\u6765\u81ea\u5e7f\u544a\u53d8\u73b0\u5e73\u53f0 API \u7684\u5e7f\u544a\u8ba1\u5212<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#3\" style=\"text-decoration:none\">ad_networks \u5e7f\u544a\u5e73\u53f0<\/a>\n<ul class=\"wp-block-list\">\n<li>\u5e7f\u544a\u5e73\u53f0\u7684\u5217\u8868<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#4\" style=\"text-decoration:none\">apps \u5e94\u7528<\/a>\n<ul class=\"wp-block-list\">\n<li>\u5e94\u7528\u5217\u8868<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#5\" style=\"text-decoration:none\">daily_country_spend \u5206\u56fd\u5bb6\u6bcf\u65e5\u5e7f\u544a\u6d88\u8017<\/a>\n<ul class=\"wp-block-list\">\n<li>Includes pre-install metrics(such as imps, clicks, installs, and spend) by date, campaign, and country. &#8220;spend&#8221; is spend amount converted to USD, and &#8220;original_spend&#8221; is spend amount in &#8220;original_currency&#8221;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"\/zh\/v1\/#6\" style=\"text-decoration:none\">publisher_apps \u5f00\u53d1\u8005\u5e94\u7528<\/a>\n<ul class=\"wp-block-list\">\n<li>\u901a\u8fc7\u5e7f\u544a\u53d8\u73b0\u5e73\u53f0 API \u83b7\u53d6\u7684\u5f00\u53d1\u8005\u5e7f\u544a\u8ba1\u5212\u6570\u636e<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#7\" style=\"text-decoration:none\">daily_ad_revenue \u6bcf\u65e5\u5e7f\u544a\u53d8\u73b0\u6536\u5165<\/a>\n<ul class=\"wp-block-list\">\n<li>\u5305\u542b\u7ec6\u5206\u5f00\u53d1\u8005\u5e7f\u544a\u7cfb\u5217\u3001\u65e5\u671f\u548c\u56fd\u5bb6\/\u5730\u533a\u7684\u5e7f\u544a\u53d8\u73b0\u6536\u5165\u6570\u636e<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#8\" style=\"text-decoration:none\">ad_engagements<\/a>\n<ul class=\"wp-block-list\">\n<li>\u53ea\u652f\u6301\u975e\u81ea\u5f52\u56e0\u5e7f\u544a\u5e73\u53f0\uff0c\u5305\u542b\u7ec6\u5206\u8bbe\u5907\u7684\u70b9\u51fb\u6216\u5c55\u793a\u6570\u636e\u3002\u8bf7\u6ce8\u610f\uff1a\u6b64\u6570\u636e\u8868\u9ed8\u8ba4\u4e0d\u542f\u7528\uff0c\u8be6\u60c5\u8bf7\u54a8\u8be2\u60a8\u5728 Tenjin \u7684\u5ba2\u6237\u7ecf\u7406<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#11\" style=\"text-decoration:none\">reporting_metrics \u62a5\u544a\u6307\u6807<\/a>\n<ul class=\"wp-block-list\">\n<li>\u4e0e\u9762\u677f\u76d8\u4e0a\u6307\u6807\u76f8\u540c\u6b65\u7684\u6240\u6709\u975e\u7fa4\u7ec4\u6570\u636e\u6307\u6807<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#12\" style=\"text-decoration:none\">reporting_cohort_metrics \u62a5\u544a\u7fa4\u7ec4\u6307\u6807<\/a>\n<ul class=\"wp-block-list\">\n<li>\u4e0e\u9762\u677f\u4e0a\u6307\u6807\u76f8\u540c\u6b65\u7684\u6240\u6709\u7fa4\u7ec4\u6570\u636e\u6307\u6807<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#14\" style=\"text-decoration:none\">sk_ad_networks<\/a>\n<ul class=\"wp-block-list\">\n<li>SK Ad Network ID \u5230 Tenjin \u7684\u7279\u5b9a ID \u7684\u6620\u5c04<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#15\" style=\"text-decoration:none\">skan_ad_network_metrics<\/a>\n<ul class=\"wp-block-list\">\n<li>Aggregated reports for conversion values and dimensions received via SK Ad Network postbacks.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#16\" style=\"text-decoration:none\">skan_apple_metrics<\/a>\n<ul class=\"wp-block-list\">\n<li>Aggregated reports for conversion values and dimensions received via Apple.<\/li>\n\n\n\n<li class=\"translation-block\">\u4e0e<code>sk_ad_network_metrics<\/code>\u6570\u636e\u8868\u6709\u7740\u76f8\u540c\u7684\u5217\u3002\u4f46\u662f\uff0c\u56e0\u4e3a<code>Apple<\/code>\u56de\u4f20\u6570\u636e\u7684\u9650\u5236\uff0c<code>campaign_id<\/code>\u5217\u662f\u7a7a\u7684<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#17\" style=\"text-decoration:none\">installs<\/a>\n<ul class=\"wp-block-list\">\n<li>App install events, as provided by Tenjin SDK.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#18\" style=\"text-decoration:none\">ad_mediation_impressions_preview<\/a>\n<ul class=\"wp-block-list\">\n<li>\u4ece\u805a\u5408\u83b7\u53d6\u5230\u7684\u5c55\u793a\u5c42\u7ea7\u7684\u6536\u76ca\u6570\u636e\u3002\u6ce8\u610f\uff0c\u8bf7\u8054\u7cfb\u5ba2\u6237\u7ecf\u7406\u54a8\u8be2\u6b64\u6570\u636e\u96c6\u7684\u5f00\u901a\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#19\" style=\"text-decoration:none\">user_attributes<\/a>\n<ul class=\"wp-block-list\">\n<li>\u5305\u62ec\u7528\u6237\u7684\u5f52\u56e0<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u5b57\u6bb5\u6e05\u5355<\/h3>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p>(S): Sort Key \u6392\u5e8f\u952e <br>(D): Dist Key \u5206\u914d\u952e<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"0\">events \u4e8b\u4ef6<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>created_at <sup>(S)<\/sup><\/td><td>\u521b\u5efa\u4e8b\u4ef6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>advertising_id<\/td><td>iOS \u7684 IDFA \u6216 Android \u7684 Google Advertising ID\u3002\u5c0f\u5199\uff0c\u4e0d\u5e26\u8fde\u5b57\u7b26\u3002<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>bundle_id<\/td><td>app&#8217;s bundle ID(we convert bundle_id to lowercase)<\/td><td>com.tenjin.wordfinder<\/td><\/tr><tr><td>platform<\/td><td>App\u53d1\u5e03\u7684\u5e73\u53f0<\/td><td>ios or android<\/td><\/tr><tr><td>os_version<\/td><td>\u8bbe\u5907\u7684\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c<\/td><td>8.0<\/td><\/tr><tr><td>app_version<\/td><td>\u5e94\u7528\u7248\u672c<\/td><td>1.0.3<\/td><\/tr><tr><td>limit_ad_tracking<\/td><td>\u7528\u6237\u9650\u5236\u5e7f\u544a\u8ddf\u8e2a (0 \u5426,1 \u662f)<\/td><td>1<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin \u7684\u5185\u90e8\u5e94\u7528 id\u3002\u53ef\u4ee5\u4e0e apps \u5e94\u7528\u8868\u4e2d\u7684<code>id<\/code>\u5b57\u6bb5\u8fdb\u884c\u8fde\u63a5<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>event_type<\/td><td class=\"translation-block\">\u4e8b\u4ef6\u7c7b\u578b\u4e3a\u201c\u4e8b\u4ef6\u201d\u6216\u201c\u8d2d\u4e70\u201d<\/td><td>event<\/td><\/tr><tr><td>event<\/td><td class=\"translation-block\">event_type=<code>event<\/code>,\u4e8b\u4ef6\u65f6\uff0c\u8be5\u503c\u4e3a <code>open<\/code>\u6216\u81ea\u5b9a\u4e49\u4e8b\u4ef6\u540d\u79f0\u3002<\/td><td>open<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">Tenjin \u5185\u90e8\u7684\u5e7f\u544a\u8ba1\u5212 id\u3002\u53ef\u4ee5\u4e0e campaigns \u5e7f\u544a\u8ba1\u5212\u8868\u4e2d\u7684<code>id<\/code>\u8fdb\u884c\u8fde\u63a5<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>acquired_at<\/td><td>\u7528\u6237\u83b7\u53d6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>price<\/td><td>\u4ed8\u8d39\u4e8b\u4ef6\u7684\u539f\u59cb\u5355\u4ef7<\/td><td>1.99<\/td><\/tr><tr><td>quantity<\/td><td>\u4ed8\u8d39\u4e8b\u4ef6\u7684\u91c7\u8d2d\u6570<\/td><td>2<\/td><\/tr><tr><td>product_id<\/td><td>\u4ed8\u8d39\u4e8b\u4ef6\u7684\u4ea7\u54c1id<\/td><td>com.tenjin.wordfinder.package50<\/td><\/tr><tr><td>currency<\/td><td>\u4ed8\u8d39\u4e8b\u4ef6\u7684\u8d27\u5e01\u4ee3\u7801<\/td><td>USD<\/td><\/tr><tr><td>country<\/td><td>\u56fd\u5bb6\u4ee3\u7801<\/td><td>US<\/td><\/tr><tr><td>total_revenue<\/td><td class=\"translation-block\">\u4ed8\u8d39\u4e8b\u4ef6\u7684\u603b\u6536\u5165\uff08\u7f8e\u5143\uff09 \u7f8e\u5206<\/td><td>350<\/td><\/tr><tr><td>revenue<\/td><td class=\"translation-block\">\u4ed8\u8d39\u4e8b\u4ef6\u7684\u51c0\u6536\u5165\uff08\u7f8e\u5143\uff09 \u7f8e\u5206<\/td><td>245<\/td><\/tr><tr><td>site_id<\/td><td>\u5e7f\u544a\u8ba1\u5212\u7684\u53d1\u5e03\u8005ID\uff08\u5bf9\u4e8e\u4ed8\u8d39\u63a8\u5e7f\u5e7f\u544a\uff09<\/td><td>Instagram<\/td><\/tr><tr><td>developer_device_id<\/td><td>iOS \u7684 IDFV\u3002Android \u5219\u4e3a\u7a7a\u3002\u5c0f\u5199\uff0c\u4e0d\u5e26\u8fde\u5b57\u7b26\u3002<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>purchase_state<\/td><td><ul><li>0: Unknowable \u2013 \u8d2d\u4e70\u672a\u6536\u5230\u6536\u636e<\/li><li>1: Unverified \u2013 \u5df2\u63d0\u4f9b\u6536\u636e\uff0c\u4f46\u65e0\u6cd5\u9a8c\u8bc1<\/li><li>2: Fraudulent \u2013 \u63d0\u4f9b\u4e86\u6b3a\u8bc8\u6027\u6536\u636e<\/li><li>3: Verified \u2013 \u6210\u529f\u9a8c\u8bc1<\/li><li>4: Sandbox \u2013 \u6536\u636e\u5df2\u5728\u6d4b\u8bd5\u6c99\u76d2\u4e2d\u9a8c\u8bc1<\/li><li>5: Duplicate \u2013 \u8be5\u6536\u636e\u5df2\u5728\u4e4b\u524d\u7684\u4e00\u6b21\u8d2d\u4e70\u4e2d\u63d0\u4ea4\u8fc7<\/li><li>6: Stale \u2013 \u8be5\u8d2d\u4e70\u4e8b\u4ef6\u53d1\u751f\u57283\u5929\u524d\uff0c\u5e76\u975e\u5b9e\u65f6\u53d1\u751f\u3002<\/li><\/ul><\/td><td>3<\/td><\/tr><tr><td>value<\/td><td>\u81ea\u5b9a\u4e49\u4e8b\u4ef6\u503c<\/td><td>1<\/td><\/tr><tr><td>uuid<\/td><td>unique event ID<\/td><td>a3e3e535-a32c-4887-9c91-3160c91b3876<\/td><\/tr><tr><td>device<\/td><td>\u8bbe\u5907\u7c7b\u578b<\/td><td>iPad2,5<\/td><\/tr><tr><td>creative_name<\/td><td>\u7d20\u6750\u540d\u79f0<\/td><td>test_creative<\/td><\/tr><tr><td>ip_address<\/td><td>\u7528\u6237\u7684IP\u5730\u5740<\/td><td>71.165.85.114<\/td><\/tr><tr><td>source_uuid<\/td><td class=\"translation-block\">\u5982\u679c\u8be5\u5e7f\u544a\u6d3b\u52a8\u662f\u4ed8\u8d39\u6295\u653e\uff0c\u5219\u4e3a\u70b9\u51fb\u6216\u5c55\u793a\u4e8b\u4ef6\u7684UUID\u3002\u8be5UUID\u53ef\u4ee5\u4e0ead_engagements\u8868\u4e2d\u7684<code>uuid<\/code>\u8fdb\u884c\u5173\u8054\u3002<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">iOS\u8bbe\u5907\u7684<a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_self\">ATT\u72b6\u6001<\/a>\u3002<code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code>=&gt;\u672a\u786e\u5b9a\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code>=&gt;\u53d7\u9650\u5236\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code>=&gt;\u62d2\u7edd\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code>=&gt;\u5df2\u6388\u6743<\/td><td>3<\/td><\/tr><tr><td>analytics_installation_id<\/td><td>Tenjin generated Application install-specific identifier. Lower case, without hyphen.<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><tr><td>customer_user_id<\/td><td>\u6765\u81eaApp\u7684\u7528\u6237ID\uff0c\u7531setCustomerUserId SDK\u65b9\u6cd5\u8bbe\u7f6e\u3002<\/td><td>jdabGcerT32_d<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"1\">campaigns \u5e7f\u544a\u6d3b\u52a8<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>Campaign\u7684\u72ec\u7279ID<\/td><td>3b70e477-c151-4167-9174-cca6ffa2c7bc<\/td><\/tr><tr><td>name<\/td><td>Campaign\u540d<\/td><td>test @bYkiNAbrAOCpzETWviMILo<\/td><\/tr><tr><td>ad_network_id<\/td><td class=\"translation-block\">id for the ad network, campaign is assigned to. It can be joined with <code>id<\/code> in ad_networks table<\/td><td>3<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin \u7684\u5185\u90e8\u5e94\u7528 id\u3002\u53ef\u4ee5\u4e0e apps \u5e94\u7528\u8868\u4e2d\u7684<code>id<\/code>\u5b57\u6bb5\u8fdb\u884c\u8fde\u63a5<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>remote_campaign_id<\/td><td>\u5e7f\u544a\u6e20\u9053\u4f7f\u7528\u7684campaign_id\u3002\u6211\u4eec\u901a\u8fc7\u5e7f\u544a\u6e20\u9053\u7684Reporting API\u83b7\u53d6\u8be5ID\u3002<\/td><td>6026825090762<\/td><\/tr><tr><td>campaign_bucket_id<\/td><td class=\"translation-block\">\u7528\u4e8e\u5bf9campaign\u8fdb\u884c\u5206\u7ec4\u7684campaign bucket id\u3002\u53ef\u4ee5\u901a\u8fc7\u8be5id\u4e0ecampaign_buckets\u8868\u4e2d\u7684id\u8fdb\u884c\u5173\u8054\u3002<\/td><td>fbbc74bd-8a73-472a-86f7-5e2a4642a201<\/td><\/tr><tr><td>updated_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3\">ad_networks \u5e7f\u544a\u5e73\u53f0<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>id <sup>(S)<\/sup><\/td><td>\u5e7f\u544a\u6e20\u9053\u7684\u72ec\u7279ID<\/td><td>3<\/td><\/tr><tr><td>name<\/td><td>ad network name<\/td><td>Facebook<\/td><\/tr><tr><td>updated_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4\">apps \u5e94\u7528<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>App\u7684\u72ec\u7279ID<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>name<\/td><td>App\u540d<\/td><td>Word Search<\/td><\/tr><tr><td>store_id<\/td><td>App\u7684store ID<\/td><td>887212194<\/td><\/tr><tr><td>bundle_id<\/td><td>app&#8217;s bundle ID<\/td><td>com.tenjin.wordfinder<\/td><\/tr><tr><td>platform<\/td><td>App\u53d1\u5e03\u7684\u5e73\u53f0<\/td><td>ios or android<\/td><\/tr><tr><td>updated_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5\">daily_country_spend \u5206\u56fd\u5bb6\u6bcf\u65e5\u5e7f\u544a\u6d88\u8017<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>\u6d88\u8017\u6570\u636e\u7684\u72ec\u7279ID<\/td><td>174491158<\/td><\/tr><tr><td>date <sup>(S)<\/sup><\/td><td>date when the spend happens<\/td><td>2018-07-01<\/td><\/tr><tr><td>country<\/td><td>country where the spend happens<\/td><td>US<\/td><\/tr><tr><td>campaign_id <sup>(D)<\/sup><\/td><td class=\"translation-block\">ID for the campaign. This can be joined with <code>id<\/code> in the campaigns table<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>spend<\/td><td>ad spend amount in USD cents.<\/td><td>400<\/td><\/tr><tr><td>installs<\/td><td>number of installs reported<\/td><td>8<\/td><\/tr><tr><td>clicks<\/td><td>number of clicks reported<\/td><td>10<\/td><\/tr><tr><td>impressions<\/td><td>number of impressions reported<\/td><td>126<\/td><\/tr><tr><td>original_spend<\/td><td>ad spend amount in original currency<\/td><td>4<\/td><\/tr><tr><td>original_currency<\/td><td>original currency<\/td><td>USD<\/td><\/tr><tr><td>updated_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>missing_country<\/td><td>if country info was missing for the spend that the ad network sent<\/td><td>false<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6\">publisher_apps \u5f00\u53d1\u8005\u5e94\u7528<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>unique ID for the publisher app<\/td><td>b71ff0ab-f1b4-4ca6-98fc-0064a5b9d1d7<\/td><\/tr><tr><td>ad_network_id<\/td><td class=\"translation-block\">id for the ad network publisher campaign is attributed to. It can be joined with <code>id<\/code> in ad_networks table<\/td><td>1<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin \u7684\u5185\u90e8\u5e94\u7528 id\u3002\u53ef\u4ee5\u4e0e apps \u5e94\u7528\u8868\u4e2d\u7684<code>id<\/code>\u5b57\u6bb5\u8fdb\u884c\u8fde\u63a5<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>name<\/td><td>name of the publisher campaign<\/td><td>Word Search! Free-ios-Tapjoy<\/td><\/tr><tr><td>updated_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"7\">daily_ad_revenue \u6bcf\u65e5\u5e7f\u544a\u53d8\u73b0\u6536\u5165<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>unique ID for the ad revenue<\/td><td>107852371<\/td><\/tr><tr><td>date <sup>(S)<\/sup><\/td><td>date when the ad revenue happens<\/td><td>2018-07-01<\/td><\/tr><tr><td>publisher_app_id <sup>(D)<\/sup><\/td><td class=\"translation-block\">ID for the publisher campaign. This can be joined with <code>id<\/code> in the publisher_apps table<\/td><td>b71ff0ab-f1b4-4ca6-98fc-0064a5b9d1d7<\/td><\/tr><tr><td>country<\/td><td>country for the metrics<\/td><td>US<\/td><\/tr><tr><td>revenue<\/td><td>ad revenue amount in USD cents<\/td><td>20000<\/td><\/tr><tr><td>conversions<\/td><td>number of conversions reported<\/td><td>8<\/td><\/tr><tr><td>clicks<\/td><td>number of clicks reported<\/td><td>10<\/td><\/tr><tr><td>impressions<\/td><td>number of impressions reported<\/td><td>126<\/td><\/tr><tr><td>interstitial_revenue<\/td><td>ad revenue amount in USD cents for interstitial ads<\/td><td>20000<\/td><\/tr><tr><td>interstitial_conversions<\/td><td>number of conversions reported for interstitial ads<\/td><td>8<\/td><\/tr><tr><td>interstitial_clicks<\/td><td>number of clicks reported for interstitial ads<\/td><td>10<\/td><\/tr><tr><td>interstitial_impressions<\/td><td>number of impressions reported for interstitial ads<\/td><td>126<\/td><\/tr><tr><td>banner_revenue<\/td><td>ad revenue amount in USD cents for banner ads<\/td><td>20000<\/td><\/tr><tr><td>banner_conversions<\/td><td>number of conversions reported for banner ads<\/td><td>8<\/td><\/tr><tr><td>banner_clicks<\/td><td>number of clicks reported for banner ads<\/td><td>10<\/td><\/tr><tr><td>banner_impressions<\/td><td>number of impressions reported for banner ads<\/td><td>126<\/td><\/tr><tr><td>native_revenue<\/td><td>ad revenue amount in USD cents for native ads<\/td><td>20000<\/td><\/tr><tr><td>native_conversions<\/td><td>number of conversions reported for native ads<\/td><td>8<\/td><\/tr><tr><td>native_clicks<\/td><td>number of clicks reported for native ads<\/td><td>10<\/td><\/tr><tr><td>native_impressions<\/td><td>number of impressions reported for native ads<\/td><td>126<\/td><\/tr><tr><td>offerwall_revenue<\/td><td>ad revenue amount in USD cents for offerwall ads<\/td><td>20000<\/td><\/tr><tr><td>offerwall_conversions<\/td><td>number of conversions reported for offerwall ads<\/td><td>8<\/td><\/tr><tr><td>offerwall_clicks<\/td><td>number of clicks reported for offerwall ads<\/td><td>10<\/td><\/tr><tr><td>offerwall_impressions<\/td><td>number of impressions reported for offerwall ads<\/td><td>126<\/td><\/tr><tr><td>video_revenue<\/td><td>ad revenue amount in USD cents for video ads<\/td><td>20000<\/td><\/tr><tr><td>video_conversions<\/td><td>number of conversions reported for video ads<\/td><td>8<\/td><\/tr><tr><td>video_clicks<\/td><td>number of clicks reported for video ads<\/td><td>10<\/td><\/tr><tr><td>video_impressions<\/td><td>number of impressions reported for video ads<\/td><td>126<\/td><\/tr><tr><td>other_revenue<\/td><td>ad revenue amount in USD cents for other ads<\/td><td>20000<\/td><\/tr><tr><td>other_conversions<\/td><td>number of conversions reported for other ads<\/td><td>8<\/td><\/tr><tr><td>other_clicks<\/td><td>number of clicks reported for other ads<\/td><td>10<\/td><\/tr><tr><td>other_impressions<\/td><td>number of impressions reported for other ads<\/td><td>126<\/td><\/tr><tr><td>updated_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"8\">ad_engagements<\/h4>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>created_at <sup>(S)<\/sup><\/td><td>\u521b\u5efa\u4e8b\u4ef6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>advertising_id<\/td><td>iOS \u7684 IDFA \u6216 Android \u7684 Google Advertising ID\u3002\u5c0f\u5199\uff0c\u4e0d\u5e26\u8fde\u5b57\u7b26\u3002<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>attributable<\/td><td class=\"translation-block\">if the click\/impression is used for attribution or not. <code>true<\/code> or <code>false<\/code><\/td><td>true<\/td><\/tr><tr><td>event_type<\/td><td class=\"translation-block\">either <code>clicks<\/code> or <code>impressions<\/code><\/td><td>clicks<\/td><\/tr><tr><td>campaign_id<\/td><td class=\"translation-block\">ID for the campaign. This can be joined with <code>id<\/code> in the campaigns table<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>bundle_id<\/td><td>app&#8217;s bundle ID<\/td><td>com.tenjin.wordfinder<\/td><\/tr><tr><td>platform<\/td><td>App\u53d1\u5e03\u7684\u5e73\u53f0<\/td><td>ios or anroid<\/td><\/tr><tr><td>ip_address<\/td><td>\u7528\u6237\u7684IP\u5730\u5740<\/td><td>71.165.85.114<\/td><\/tr><tr><td>limit_ad_tracking<\/td><td>user&#8217;s limit ad tracking<\/td><td>(0,1)<\/td><\/tr><tr><td>uuid<\/td><td class=\"translation-block\">unique ID for the event. It can be joined with <code>source_uuid<\/code> events table<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin \u7684\u5185\u90e8\u5e94\u7528 id\u3002\u53ef\u4ee5\u4e0e apps \u5e94\u7528\u8868\u4e2d\u7684<code>id<\/code>\u5b57\u6bb5\u8fdb\u884c\u8fde\u63a5<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>country<\/td><td>\u56fd\u5bb6\u4ee3\u7801<\/td><td>US<\/td><\/tr><tr><td>site_id<\/td><td>\u5e7f\u544a\u8ba1\u5212\u7684\u53d1\u5e03\u8005ID\uff08\u5bf9\u4e8e\u4ed8\u8d39\u63a8\u5e7f\u5e7f\u544a\uff09<\/td><td>Instagram<\/td><\/tr><tr><td>user_agent<\/td><td>User Agent<\/td><td>Dalvik\/2.1.0 (Linux; U; Android 8.0.0; SM-G570M Build\/R16NW)<\/td><\/tr><tr><td>remote_click_id<\/td><td>click id ad-networks passes through the click url.<\/td><td>DSGfaa<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">iOS\u8bbe\u5907\u7684<a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_self\">ATT\u72b6\u6001<\/a>\u3002<code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code>=&gt;\u672a\u786e\u5b9a\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code>=&gt;\u53d7\u9650\u5236\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code>=&gt;\u62d2\u7edd\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code>=&gt;\u5df2\u6388\u6743<\/td><td>3<\/td><\/tr><tr><td>analytics_installation_id<\/td><td>Tenjin generated Application install-specific identifier. Lower case, without hyphen.<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"11\">reporting_metrics \u62a5\u544a\u6307\u6807<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>date <sup>(S)<\/sup><\/td><td>date the metric applies to<\/td><td>2018-11-01<\/td><\/tr><tr><td>ad_network_id<\/td><td>Tenjin ID of the ad network<\/td><td>3<\/td><\/tr><tr><td>platform<\/td><td>App\u53d1\u5e03\u7684\u5e73\u53f0<\/td><td>ios or android<\/td><\/tr><tr><td>app_id<\/td><td>Tenjin ID of the app<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>campaign_id<\/td><td>Tenjin ID of the campaign<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>country<\/td><td>two-letter country code<\/td><td>US<\/td><\/tr><tr><td>site_id<\/td><td>\u7f51\u7ad9 ID<\/td><td>Instagram<\/td><\/tr><tr><td>daily_active_users<\/td><td>unique devices seen<\/td><td>105<\/td><\/tr><tr><td>sessions<\/td><td>count of app open events<\/td><td>23650<\/td><\/tr><tr><td>iap_revenue<\/td><td>sum of in-app purchase revenue in USD cents<\/td><td>245<\/td><\/tr><tr><td>reported_spend<\/td><td>allocated spend from ad network reporting APIs in cents<\/td><td>5323<\/td><\/tr><tr><td>reported_impressions<\/td><td>allocated impressions from ad network reporting APIs<\/td><td>13000<\/td><\/tr><tr><td>reported_clicks<\/td><td>allocated clicks from ad network reporting APIs<\/td><td>3000<\/td><\/tr><tr><td>reported_installs\u62a5\u544a\u6fc0\u6d3b<\/td><td>allocated installs from ad network reporting APIs<\/td><td>4000<\/td><\/tr><tr><td>publisher_ad_revenue<\/td><td>allocated sum of publisher ad revenue from ad network reporting API in USD cents<\/td><td>2000<\/td><\/tr><tr><td>tracked_impressions<\/td><td>count of impressions tracked by Tenjin attribution<\/td><td>13000<\/td><\/tr><tr><td>tracked_clicks<\/td><td>count of clicks tracked by Tenjin attribution<\/td><td>4000<\/td><\/tr><tr><td>tracked_installs\u8ffd\u8e2a\u6fc0\u6d3b<\/td><td>count of installs tracked by Tenjin attribution<\/td><td>3000<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"12\">reporting_cohort_metrics \u62a5\u544a\u7fa4\u7ec4\u6307\u6807<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>event_date <sup>(S)<\/sup><\/td><td>date current cohort the metrics apply to<\/td><td>2018-11-01<\/td><\/tr><tr><td>install_date<\/td><td>date of the install<\/td><td>2018-10-01<\/td><\/tr><tr><td>days_since_install<\/td><td>days since install<\/td><td>3<\/td><\/tr><tr><td>platform<\/td><td>App\u53d1\u5e03\u7684\u5e73\u53f0<\/td><td>ios or anroid<\/td><\/tr><tr><td>app_id<\/td><td>Tenjin ID of the app<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>campaign_id<\/td><td>Tenjin ID of the campaign<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>country<\/td><td>two-letter country code<\/td><td>US<\/td><\/tr><tr><td>site_id<\/td><td>\u7f51\u7ad9 ID<\/td><td>Instagram<\/td><\/tr><tr><td>daily_active_users<\/td><td>unique devices seen<\/td><td>105<\/td><\/tr><tr><td>sessions<\/td><td>count of app open events<\/td><td>23650<\/td><\/tr><tr><td>iap_revenue<\/td><td>sum of in-app purchase revenue in USD cents<\/td><td>245<\/td><\/tr><tr><td>publisher_ad_revenue<\/td><td>allocated sum of publisher ad revenue from ad network reporting API in USD cents<\/td><td>2000<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>For reporting_cohort_metrics use the install_date and days_since_install to get metrics as in the dashboard. ex:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\" data-no-translation=\"\" data-no-auto-translation=\"\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#39404f;color:#c8d0e0\">Plaintext<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\" data-no-translation=\"\" data-no-auto-translation=\"\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>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 <\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewbox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\" data-no-translation=\"\" data-no-auto-translation=\"\"><code data-no-translation=\"\" data-no-auto-translation=\"\"><span class=\"line\"><span style=\"color: #d8dee9ff\">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 = &#39;2018-10-11&#39; GROUP BY 1, 2, 3, 4 LIMIT 10 <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"14\">sk_ad_networks<\/h4>\n\n\n\n<p>Contact your Account Manager to access this table.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>id<sup>(S)<\/sup><\/td><td>Lowercase string SK Ad Network ID for the ad network.<\/td><td>&#8220;cstr6suwn9.skadnetwork&#8221;<\/td><\/tr><tr><td>ad_network_id<\/td><td>Integer Tenjin-specific ID for the ad network. Can be joined via ad_networks.id<\/td><td>5<\/td><\/tr><tr><td>updated_at<\/td><td>Timestamp representing when the record was last updated.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>Timestamp representing when the record was last loaded into DataVault.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"15\">skan_ad_network_metrics<\/h4>\n\n\n\n<p>Contact your Account Manager to access this table.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>date<sup>(S)<\/sup><\/td><td>Date the SK Ad Network postback was received.<\/td><td>2021-01-01<\/td><\/tr><tr><td>sk_ad_network_id<\/td><td>Lowercase string SK Ad Network ID for the ad network.<\/td><td>&#8220;cstr6suwn9.skadnetwork&#8221;<\/td><\/tr><tr><td>ad_network_id<\/td><td>Integer Tenjin-specific ID for the ad network. Can be joined via ad_networks.id<\/td><td>5<\/td><\/tr><tr><td>sk_app_id<\/td><td>Integer SK App ID of the App being advertised. Equivalent to <code data-no-translation=\"\" data-no-auto-translation=\"\">apps.store_id<\/code> for iOS Apps.<\/td><td>1478027094<\/td><\/tr><tr><td>app_id<\/td><td>UUID Tenjin-specific ID for the App. Can be joined via <code data-no-translation=\"\" data-no-auto-translation=\"\">apps.id<\/code>.<\/td><td>&#8220;9668185b-da2e-4638-b15f-e03431377ac5&#8221;<\/td><\/tr><tr><td>sk_campaign_id<\/td><td>SK Campaign ID, an Integer from 0-99.<\/td><td>10<\/td><\/tr><tr><td>campaign_id<\/td><td>UUID Tenjin-specific ID for the Campaign. Can be joined via campaigns.id<\/td><td>&#8220;61817a78-0a8f-4e83-98c0-8106f7a6ea92&#8221;<\/td><\/tr><tr><td>sk_source_app_id<\/td><td>String representing the App that showed the advertisement that led to a conversion.<\/td><td>&#8220;284882215&#8221;<\/td><\/tr><tr><td>fidelity_type<\/td><td>1 for StoreKit Ads, 0 for view-through ads.<\/td><td>1<\/td><\/tr><tr><td>conversion_value<\/td><td>Conversion Value, an Integer from 0-63.<\/td><td>33<\/td><\/tr><tr><td>conversion_value_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code>.<\/td><td>250<\/td><\/tr><tr><td>redownload_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were redownloads.<\/td><td>11<\/td><\/tr><tr><td>assist_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were assists.<\/td><td>2<\/td><\/tr><tr><td>redownload_assist_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were both redownloads and assists.<\/td><td>1<\/td><\/tr><tr><td>loaded_at<\/td><td>Timestamp representing when the record was last loaded into DataVault.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"16\">skan_apple_metrics<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>date<sup>(S)<\/sup><\/td><td>Date the SK Ad Network postback was received.<\/td><td>2021-01-01<\/td><\/tr><tr><td>sk_ad_network_id<\/td><td>Lowercase string SK Ad Network ID for the ad network.<\/td><td>&#8220;cstr6suwn9.skadnetwork&#8221;<\/td><\/tr><tr><td>ad_network_id<\/td><td>Integer Tenjin-specific ID for the ad network. Can be joined via ad_networks.id<\/td><td>5<\/td><\/tr><tr><td>sk_app_id<\/td><td>Integer SK App ID of the App being advertised. Equivalent to <code data-no-translation=\"\" data-no-auto-translation=\"\">apps.store_id<\/code> for iOS Apps.<\/td><td>1478027094<\/td><\/tr><tr><td>app_id<\/td><td>UUID Tenjin-specific ID for the App. Can be joined via <code data-no-translation=\"\" data-no-auto-translation=\"\">apps.id<\/code>.<\/td><td>&#8220;9668185b-da2e-4638-b15f-e03431377ac5&#8221;<\/td><\/tr><tr><td>sk_campaign_id<\/td><td>SK Campaign ID, an Integer from 0-99.<\/td><td>10<\/td><\/tr><tr><td>campaign_id<\/td><td>UUID Tenjin-specific ID for the Campaign. Always null, as Apple does not provide any way to get this value.<\/td><td><code data-no-translation=\"\" data-no-auto-translation=\"\">null<\/code><\/td><\/tr><tr><td>sk_source_app_id<\/td><td>String representing the App that showed the advertisement that led to a conversion.<\/td><td>&#8220;284882215&#8221;<\/td><\/tr><tr><td>fidelity_type<\/td><td>1 for StoreKit Ads, 0 for view-through ads.<\/td><td>1<\/td><\/tr><tr><td>conversion_value<\/td><td>Conversion Value, an Integer from 0-63.<\/td><td>33<\/td><\/tr><tr><td>conversion_value_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code>.<\/td><td>250<\/td><\/tr><tr><td>redownload_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were redownloads.<\/td><td>11<\/td><\/tr><tr><td>assist_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were assists.<\/td><td>2<\/td><\/tr><tr><td>redownload_assist_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were both redownloads and assists.<\/td><td>1<\/td><\/tr><tr><td>loaded_at<\/td><td>Timestamp representing when the record was last loaded into DataVault.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"17\">installs<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>created_at<\/td><td>\u521b\u5efa\u4e8b\u4ef6\u7684\u65f6\u95f4\u6233<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>advertising_id<\/td><td>IDFA for iOS or Google advertising ID for Android. Lower case, without hyphen<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>bundle_id<\/td><td>app&#8217;s bundle ID(we convert bundle_id to lowercase)<\/td><td>com.tenjin.wordfinder<\/td><\/tr><tr><td>platform<\/td><td>App\u53d1\u5e03\u7684\u5e73\u53f0<\/td><td>ios or android<\/td><\/tr><tr><td>os_version<\/td><td>\u8bbe\u5907\u7684\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c<\/td><td>8.0<\/td><\/tr><tr><td>app_version<\/td><td>\u5e94\u7528\u7248\u672c<\/td><td>1.0.3<\/td><\/tr><tr><td>limit_ad_tracking<\/td><td>\u7528\u6237\u9650\u5236\u5e7f\u544a\u8ddf\u8e2a (0 \u5426,1 \u662f)<\/td><td>1<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin \u7684\u5185\u90e8\u5e94\u7528 id\u3002\u53ef\u4ee5\u4e0e apps \u5e94\u7528\u8868\u4e2d\u7684<code>id<\/code>\u5b57\u6bb5\u8fdb\u884c\u8fde\u63a5<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">Tenjin \u5185\u90e8\u7684\u5e7f\u544a\u8ba1\u5212 id\u3002\u53ef\u4ee5\u4e0e campaigns \u5e7f\u544a\u8ba1\u5212\u8868\u4e2d\u7684<code>id<\/code>\u8fdb\u884c\u8fde\u63a5<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>acquired_at<\/td><td>\u7528\u6237\u83b7\u53d6\u7684\u65f6\u95f4\u6233<\/td><td>2018-10-01 00:00:00<\/td><\/tr><tr><td>country<\/td><td>\u56fd\u5bb6\u4ee3\u7801<\/td><td>US<\/td><\/tr><tr><td>site_id<\/td><td>\u5e7f\u544a\u8ba1\u5212\u7684\u53d1\u5e03\u8005ID\uff08\u5bf9\u4e8e\u4ed8\u8d39\u63a8\u5e7f\u5e7f\u544a\uff09<\/td><td>Instagram<\/td><\/tr><tr><td>developer_device_id<\/td><td>IDFV for iOS. Empty for Android. Lower case, without hyphen<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>uuid<\/td><td>unique event ID<\/td><td>a3e3e535-a32c-4887-9c91-3160c91b3876<\/td><\/tr><tr><td>device<\/td><td>\u8bbe\u5907\u7c7b\u578b<\/td><td>iPAD 2,5<\/td><\/tr><tr><td>creative_name<\/td><td>\u7d20\u6750\u540d\u79f0<\/td><td>test_creative<\/td><\/tr><tr><td>ip_address<\/td><td>\u7528\u6237\u7684IP\u5730\u5740<\/td><td>71.165.85.114<\/td><\/tr><tr><td>source_uuid<\/td><td class=\"translation-block\">\u5982\u679c\u8be5\u5e7f\u544a\u6d3b\u52a8\u662f\u4ed8\u8d39\u6295\u653e\uff0c\u5219\u4e3a\u70b9\u51fb\u6216\u5c55\u793a\u4e8b\u4ef6\u7684UUID\u3002\u8be5UUID\u53ef\u4ee5\u4e0ead_engagements\u8868\u4e2d\u7684<code>uuid<\/code>\u8fdb\u884c\u5173\u8054\u3002<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-10-01 00:00:00<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">iOS\u8bbe\u5907\u7684<a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_self\">ATT\u72b6\u6001<\/a>\u3002<code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code>=&gt;\u672a\u786e\u5b9a\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code>=&gt;\u53d7\u9650\u5236\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code>=&gt;\u62d2\u7edd\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code>=&gt;\u5df2\u6388\u6743<\/td><td>3<\/td><\/tr><tr><td>analytics_installation_id<\/td><td>Tenjin generated Application install-specific identifier. Lower case, without hyphen<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"18\">ad_mediation_impressions_preview<\/h4>\n\n\n\n<p>Contact your Account Manager to access this table<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>acquired_at<\/td><td>\u7528\u6237\u83b7\u53d6\u7684\u65f6\u95f4\u6233<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>ad_mediation_ad_format<\/td><td>Format of the Ad unit<\/td><td>\u6a2a\u5e45<\/td><\/tr><tr><td>ad_mediation_network<\/td><td>\u5c55\u793a\u5e7f\u544a\u7684\u6e20\u9053<\/td><td>Applovin<\/td><\/tr><tr><td>ad_mediation_placement<\/td><td>\u5e7f\u544a\u6e20\u9053\u5b9a\u4e49\u7684\u5e7f\u544a\u4f4d<\/td><td>my_banner_placement<\/td><\/tr><tr><td>ad_mediation_provider<\/td><td>Ad mediation provider<\/td><td>Applovin MAX<\/td><\/tr><tr><td>ad_mediation_revenue_microcents<\/td><td>Ad revenue in microscents as provided by the mediation provider<\/td><td>22000<\/td><\/tr><tr><td>advertising_id<\/td><td>iOS \u7684 IDFA \u6216 Android \u7684 Google Advertising ID\u3002\u5c0f\u5199\uff0c\u4e0d\u5e26\u8fde\u5b57\u7b26\u3002<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>analytics_installation_id<\/td><td>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.<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin \u7684\u5185\u90e8\u5e94\u7528 id\u3002\u53ef\u4ee5\u4e0e apps \u5e94\u7528\u8868\u4e2d\u7684<code>id<\/code>\u5b57\u6bb5\u8fdb\u884c\u8fde\u63a5<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>app_version<\/td><td>\u5e94\u7528\u7248\u672c<\/td><td>1.0.3<\/td><\/tr><tr><td>bundle_id<\/td><td>app&#8217;s bundle ID(we convert bundle_id to lowercase)<\/td><td>com.tenjin.wordfinder<\/td><\/tr><tr><td>country<\/td><td>\u56fd\u5bb6\u4ee3\u7801<\/td><td>US<\/td><\/tr><tr><td>created_at<\/td><td>\u521b\u5efa\u4e8b\u4ef6\u7684\u65f6\u95f4\u6233<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>creative_name<\/td><td>\u7d20\u6750\u540d\u79f0<\/td><td>test_creative<\/td><\/tr><tr><td>customer_user_id<\/td><td>\u6765\u81eaApp\u7684\u7528\u6237ID\uff0c\u7531setCustomerUserId SDK\u65b9\u6cd5\u8bbe\u7f6e\u3002<\/td><td>jdabGcerT32_d<\/td><\/tr><tr><td>developer_device_id<\/td><td>IDFV for iOS. Empty for Android. Lower case, without hyphen<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>device<\/td><td>\u8bbe\u5907\u7c7b\u578b<\/td><td>iPAD 2.5<\/td><\/tr><tr><td>engaged_at<\/td><td>Timestamp for the click\/impression event the user interacted with before acquisition<\/td><td>2018-01-01 00:00:00<\/td><\/tr><tr><td>ip_address<\/td><td>\u7528\u6237\u7684IP\u5730\u5740<\/td><td>71.165.85.114<\/td><\/tr><tr><td>limit_ad_tracking<\/td><td>user&#8217;s limit ad tracking<\/td><td>(0,1)<\/td><\/tr><tr><td>loaded_at<\/td><td>DataVault\u4e2d\u88ab\u66f4\u65b0\u65f6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>os_version<\/td><td>\u8bbe\u5907\u7684\u64cd\u4f5c\u7cfb\u7edf\u7248\u672c<\/td><td>8.0<\/td><\/tr><tr><td>platform<\/td><td>App\u53d1\u5e03\u7684\u5e73\u53f0<\/td><td>8.0<\/td><\/tr><tr><td>sdk_version<\/td><td>Tenjin SDK\u7248\u672c<\/td><td>12.2.22<\/td><\/tr><tr><td>site_id<\/td><td>\u5e7f\u544a\u8ba1\u5212\u7684\u53d1\u5e03\u8005ID\uff08\u5bf9\u4e8e\u4ed8\u8d39\u63a8\u5e7f\u5e7f\u544a\uff09<\/td><td>instagram<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">Tenjin \u5185\u90e8\u7684\u5e7f\u544a\u8ba1\u5212 id\u3002\u53ef\u4ee5\u4e0e campaigns \u5e7f\u544a\u8ba1\u5212\u8868\u4e2d\u7684<code>id<\/code>\u8fdb\u884c\u8fde\u63a5<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>source_uuid<\/td><td>UUID for the impression event if the campaign was paid campaign. It can be joined with uuid in ad_engagements table<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">iOS\u8bbe\u5907\u7684<a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_self\">ATT\u72b6\u6001<\/a>\u3002<code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code>=&gt;\u672a\u786e\u5b9a\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code>=&gt;\u53d7\u9650\u5236\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code>=&gt;\u62d2\u7edd\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code>=&gt;\u5df2\u6388\u6743<\/td><td>3<\/td><\/tr><tr><td>uuid<\/td><td class=\"translation-block\">unique ID for the event. It can be joined with <code>source_uuid<\/code> events table<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"19\">user_attributes <\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>\u8bf4\u660e<\/th><th>Example value \u4f8b\u503c<\/th><\/tr><\/thead><tbody><tr><td>advertising_id<\/td><td>iOS \u7684 IDFA \u6216 Android \u7684 Google Advertising ID\u3002\u5c0f\u5199\uff0c\u4e0d\u5e26\u8fde\u5b57\u7b26\u3002<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>limit_ad_tracking<\/td><td>\u7528\u6237\u9650\u5236\u5e7f\u544a\u8ddf\u8e2a (0 \u5426,1 \u662f)<\/td><td>1<\/td><\/tr><tr><td>acquired_at<\/td><td>\u7528\u6237\u83b7\u53d6\u7684\u65f6\u95f4\u6233<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>country<\/td><td>\u56fd\u5bb6\u4ee3\u7801<\/td><td>US<\/td><\/tr><tr><td>site_id<\/td><td>\u5e7f\u544a\u8ba1\u5212\u7684\u53d1\u5e03\u8005ID\uff08\u5bf9\u4e8e\u4ed8\u8d39\u63a8\u5e7f\u5e7f\u544a\uff09<\/td><td>Instagram<\/td><\/tr><tr><td>developer_device_id<\/td><td>iOS \u7684 IDFV\u3002Android \u5219\u4e3a\u7a7a\u3002\u5c0f\u5199\uff0c\u4e0d\u5e26\u8fde\u5b57\u7b26\u3002<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>analytics_installation_id<\/td><td>Tenjin generated Application install-specific identifier. Lower case, without hyphen.<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">Tenjin \u5185\u90e8\u7684\u5e7f\u544a\u8ba1\u5212 id\u3002\u53ef\u4ee5\u4e0e campaigns \u5e7f\u544a\u8ba1\u5212\u8868\u4e2d\u7684<code>id<\/code>\u8fdb\u884c\u8fde\u63a5<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">iOS\u8bbe\u5907\u7684<a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_self\">ATT\u72b6\u6001<\/a>\u3002<code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code>=&gt;\u672a\u786e\u5b9a\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code>=&gt;\u53d7\u9650\u5236\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code>=&gt;\u62d2\u7edd\uff0c<code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code>=&gt;\u5df2\u6388\u6743<\/td><td>3<\/td><\/tr><tr><td>last_seen<\/td><td>timestamp when the user was last seen<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\u56de\u6eaf\u671f<\/h3>\n\n\n\n<p>\u4ee5\u4e0b\u8fd9\u4e9b tables \u6570\u636e\u8868\u7684\u5386\u53f2\u6570\u636e\u53d6\u51b3\u4e8e\u56de\u6eaf\u671f\u3002\u5982\u679c\u4f60\u60f3\u4e86\u89e3 DataVault \u6570\u636e\u4ed3\u5e93\u7684\u56de\u6eaf\u7a97\u53e3\uff0c\u8bf7\u8054\u7cfb Tenjin \u7684\u5ba2\u6237\u7ecf\u7406\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>events \u4e8b\u4ef6<\/li>\n\n\n\n<li>ad_engagements<\/li>\n\n\n\n<li>reporting_metrics \u62a5\u544a\u6307\u6807<\/li>\n\n\n\n<li>reporting_cohort_metrics \u62a5\u544a\u7fa4\u7ec4\u6307\u6807<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Tenjin&#8217;s DataVault schema lies at the heart of its special sauce. All information from various places is nicely joined together through ids. With information organized in this way, DataVault makes it easy to build models and analyses in a deterministic way. List of tables List of table fields (S): Sort Key (D): Dist Key events&#8230;<\/p>","protected":false},"author":25,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_category":[96],"glossaries":[],"doc_tag":[],"class_list":["post-15474","docs","type-docs","status-publish","hentry","doc_category-datavault"],"acf":[],"year_month":"2026-04","word_count":1977,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"mariusz.bijok","author_nicename":"mariusz-bijok","author_url":"https:\/\/tenjin.com\/zh\/blog\/author\/mariusz-bijok\/"},"doc_category_info":[{"term_name":"DataVault","term_url":"https:\/\/tenjin.com\/zh\/docs\/category\/datavault\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DataVault Schema and Tables<\/title>\n<meta name=\"description\" content=\"Tenjin&#039;s DataVault schema lies at the heart of its special sauce. All information from various places is nicely joined together through ids.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tenjin.com\/zh\/docs\/datavault-schema-and-tables\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DataVault Schema and Tables\" \/>\n<meta property=\"og:description\" content=\"Tenjin&#039;s DataVault schema lies at the heart of its special sauce. All information from various places is nicely joined together through ids.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tenjin.com\/zh\/docs\/datavault-schema-and-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"Tenjin\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-17T17:57:28+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@TenjinMMP\" \/>\n<meta name=\"twitter:label1\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data1\" content=\"14 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/\"},\"author\":{\"name\":\"mariusz.bijok\",\"@id\":\"https:\/\/tenjin.com\/#\/schema\/person\/2df6a56c45e0493e93ec6d7100750b77\"},\"headline\":\"DataVault Schema and Tables\",\"datePublished\":\"2026-02-20T07:06:12+00:00\",\"dateModified\":\"2026-03-17T17:57:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/\"},\"wordCount\":3672,\"publisher\":{\"@id\":\"https:\/\/tenjin.com\/#organization\"},\"inLanguage\":\"zh-Hans\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/\",\"url\":\"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/\",\"name\":\"DataVault Schema and Tables\",\"isPartOf\":{\"@id\":\"https:\/\/tenjin.com\/#website\"},\"datePublished\":\"2026-02-20T07:06:12+00:00\",\"dateModified\":\"2026-03-17T17:57:28+00:00\",\"description\":\"Tenjin's DataVault schema lies at the heart of its special sauce. All information from various places is nicely joined together through ids.\",\"breadcrumb\":{\"@id\":\"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/tenjin.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Docs\",\"item\":\"https:\/\/tenjin.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DataVault Schema and Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/tenjin.com\/#website\",\"url\":\"https:\/\/tenjin.com\/\",\"name\":\"Tenjin\",\"description\":\"Growth Made Simple\",\"publisher\":{\"@id\":\"https:\/\/tenjin.com\/#organization\"},\"alternateName\":\"Tenjin - Mobile Measurement Partner\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/tenjin.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/tenjin.com\/#organization\",\"name\":\"Tenjin\",\"url\":\"https:\/\/tenjin.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/tenjin.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/04\/images.webp\",\"contentUrl\":\"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/04\/images.webp\",\"width\":429,\"height\":117,\"caption\":\"Tenjin\"},\"image\":{\"@id\":\"https:\/\/tenjin.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/TenjinMMP\",\"https:\/\/www.youtube.com\/@TenjinMMP\",\"https:\/\/www.linkedin.com\/company\/tenjin\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/tenjin.com\/#\/schema\/person\/2df6a56c45e0493e93ec6d7100750b77\",\"name\":\"mariusz.bijok\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/tenjin.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ed77b923271ae0c54cf6cc2b3d031d191c17791d92b8a5f5d186753477fbbdb9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ed77b923271ae0c54cf6cc2b3d031d191c17791d92b8a5f5d186753477fbbdb9?s=96&d=mm&r=g\",\"caption\":\"mariusz.bijok\"},\"url\":\"https:\/\/tenjin.com\/zh\/blog\/author\/mariusz-bijok\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DataVault\u6570\u636e\u7ed3\u6784\u548c\u56fe\u8868","description":"Tenjin's DataVault schema lies at the heart of its special sauce. All information from various places is nicely joined together through ids.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/tenjin.com\/zh\/docs\/datavault-schema-and-tables\/","og_locale":"zh_CN","og_type":"article","og_title":"DataVault Schema and Tables","og_description":"Tenjin's DataVault schema lies at the heart of its special sauce. All information from various places is nicely joined together through ids.","og_url":"https:\/\/tenjin.com\/zh\/docs\/datavault-schema-and-tables\/","og_site_name":"Tenjin","article_modified_time":"2026-03-17T17:57:28+00:00","twitter_card":"summary_large_image","twitter_site":"@TenjinMMP","twitter_misc":{"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"14 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/#article","isPartOf":{"@id":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/"},"author":{"name":"mariusz.bijok","@id":"https:\/\/tenjin.com\/#\/schema\/person\/2df6a56c45e0493e93ec6d7100750b77"},"headline":"DataVault Schema and Tables","datePublished":"2026-02-20T07:06:12+00:00","dateModified":"2026-03-17T17:57:28+00:00","mainEntityOfPage":{"@id":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/"},"wordCount":3672,"publisher":{"@id":"https:\/\/tenjin.com\/#organization"},"inLanguage":"zh-Hans"},{"@type":"WebPage","@id":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/","url":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/","name":"DataVault\u6570\u636e\u7ed3\u6784\u548c\u56fe\u8868","isPartOf":{"@id":"https:\/\/tenjin.com\/#website"},"datePublished":"2026-02-20T07:06:12+00:00","dateModified":"2026-03-17T17:57:28+00:00","description":"Tenjin's DataVault schema lies at the heart of its special sauce. All information from various places is nicely joined together through ids.","breadcrumb":{"@id":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tenjin.com\/"},{"@type":"ListItem","position":2,"name":"Docs","item":"https:\/\/tenjin.com\/docs\/"},{"@type":"ListItem","position":3,"name":"DataVault Schema and Tables"}]},{"@type":"WebSite","@id":"https:\/\/tenjin.com\/#website","url":"https:\/\/tenjin.com\/","name":"Tenjin","description":"\u8ba9\u589e\u957f\u53d8\u7b80\u5355","publisher":{"@id":"https:\/\/tenjin.com\/#organization"},"alternateName":"Tenjin - Mobile Measurement Partner","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tenjin.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-Hans"},{"@type":"Organization","@id":"https:\/\/tenjin.com\/#organization","name":"Tenjin","url":"https:\/\/tenjin.com\/","logo":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/tenjin.com\/#\/schema\/logo\/image\/","url":"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/04\/images.webp","contentUrl":"https:\/\/tenjin.com\/wp-content\/uploads\/2026\/04\/images.webp","width":429,"height":117,"caption":"Tenjin"},"image":{"@id":"https:\/\/tenjin.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/TenjinMMP","https:\/\/www.youtube.com\/@TenjinMMP","https:\/\/www.linkedin.com\/company\/tenjin"]},{"@type":"Person","@id":"https:\/\/tenjin.com\/#\/schema\/person\/2df6a56c45e0493e93ec6d7100750b77","name":"mariusz.bijok","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/tenjin.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ed77b923271ae0c54cf6cc2b3d031d191c17791d92b8a5f5d186753477fbbdb9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ed77b923271ae0c54cf6cc2b3d031d191c17791d92b8a5f5d186753477fbbdb9?s=96&d=mm&r=g","caption":"mariusz.bijok"},"url":"https:\/\/tenjin.com\/zh\/blog\/author\/mariusz-bijok\/"}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/docs\/15474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/comments?post=15474"}],"version-history":[{"count":5,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/docs\/15474\/revisions"}],"predecessor-version":[{"id":16790,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/docs\/15474\/revisions\/16790"}],"wp:attachment":[{"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/media?parent=15474"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/doc_category?post=15474"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/glossaries?post=15474"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/tenjin.com\/zh\/wp-json\/wp\/v2\/doc_tag?post=15474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}