{"id":15474,"date":"2026-02-20T07:06:12","date_gmt":"2026-02-20T07:06:12","guid":{"rendered":"http:\/\/mariusz.bijok"},"modified":"2026-06-15T10:28:30","modified_gmt":"2026-06-15T10:28:30","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=\"wp-block-paragraph 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\">\u5e7f\u544a\u4e92\u52a8\u91cf<\/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 class=\"wp-block-paragraph\">(S): Sort Key \u6392\u5e8f\u952e <br>(D): Dist Key \u5206\u914d\u952e<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/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>\u5e7f\u544a_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 \u6216 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>\u6d3b\u52a8<\/td><\/tr><tr><td>\u6d3b\u52a8<\/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>\u6253\u5f00<\/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>\u4ef7\u683c<\/td><td>\u4ed8\u8d39\u4e8b\u4ef6\u7684\u539f\u59cb\u5355\u4ef7<\/td><td>1.99<\/td><\/tr><tr><td>\u6570\u91cf<\/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\u7b80\u4f53\u4e2d\u6587\uff08\u5927\u9646\uff09<\/td><\/tr><tr><td>\u8d27\u5e01<\/td><td>\u4ed8\u8d39\u4e8b\u4ef6\u7684\u8d27\u5e01\u4ee3\u7801<\/td><td>\u7f8e\u5143<\/td><\/tr><tr><td>\u56fd\u5bb6<\/td><td>\u56fd\u5bb6\u4ee3\u7801<\/td><td>\u7f8e\u56fd<\/td><\/tr><tr><td>\u603b\u6536\u5165<\/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>\u5f00\u53d1\u8005\u8bbe\u5907ID<\/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>\u8d2d\u4e70\u72b6\u6001<\/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>\u503c<\/td><td>\u81ea\u5b9a\u4e49\u4e8b\u4ef6\u503c<\/td><td>1<\/td><\/tr><tr><td>uuid<\/td><td>\u552f\u4e00\u4e8b\u4ef6 ID<\/td><td>a3e3e535-a32c-4887-9c91-3160c91b3876<\/td><\/tr><tr><td>\u8bbe\u5907<\/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>\u8ddf\u8e2a\u72b6\u6001<\/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>\u5ba2\u6237\u7528\u6237ID<\/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 class=\"wp-block-paragraph\"><\/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\uff08\u7b80\u4f53\u4e2d\u6587\uff08\u5927\u9646\uff09\uff09<\/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>\u6d3b\u52a8_\u6876_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>\u66f4\u65b0\u65f6\u95f4<\/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 class=\"wp-block-paragraph\"><\/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>\u66f4\u65b0\u65f6\u95f4<\/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 class=\"wp-block-paragraph\"><\/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>\u5355\u8bcd\u641c\u7d22<\/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 \u6216 Android<\/td><\/tr><tr><td>\u66f4\u65b0\u65f6\u95f4<\/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 class=\"wp-block-paragraph\"><\/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>\u65e5\u671f <sup>(S)<\/sup><\/td><td>\u53d1\u751f\u652f\u51fa\u7684\u65e5\u671f<\/td><td>2018-07-01<\/td><\/tr><tr><td>\u56fd\u5bb6<\/td><td>\u6d88\u8d39\u53d1\u751f\u5730<\/td><td>\u7f8e\u56fd<\/td><\/tr><tr><td>campaign_id <sup>(D)<\/sup><\/td><td class=\"translation-block\">\u8be5\u6d3b\u52a8\u7684ID\u3002\u8be5\u5b57\u6bb5\u53ef\u4e0e<code>id<\/code>\u5728campaigns\u8868\u4e2d\u8fdb\u884c\u5173\u8054<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf\uff08\u7b80\u4f53\u4e2d\u6587\uff08\u5927\u9646\uff09\uff09<\/td><\/tr><tr><td>\u82b1\u8d39<\/td><td>ad spend amount in USD cents.<\/td><td>400<\/td><\/tr><tr><td>installs<\/td><td>\u62a5\u544a\u7684\u5b89\u88c5\u6b21\u6570<\/td><td>8<\/td><\/tr><tr><td>\u70b9\u51fb\u91cf<\/td><td>\u62a5\u544a\u7684\u70b9\u51fb\u6b21\u6570<\/td><td>10<\/td><\/tr><tr><td>impressions<\/td><td>\u62a5\u544a\u7684\u5c55\u793a\u6b21\u6570<\/td><td>126<\/td><\/tr><tr><td>\u539f\u59cb\u652f\u51fa<\/td><td>ad spend amount in original currency<\/td><td>4<\/td><\/tr><tr><td>\u539f\u59cb\u8d27\u5e01<\/td><td>\u539f\u59cb\u8d27\u5e01<\/td><td>\u7f8e\u5143<\/td><\/tr><tr><td>\u66f4\u65b0\u65f6\u95f4<\/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>\u7f3a\u5931\u7684\u56fd\u5bb6<\/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 class=\"wp-block-paragraph\"><\/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>\u53d1\u5e03\u8005\u5e94\u7528\u7684\u552f\u4e00\u6807\u8bc6\u7b26<\/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>\u51fa\u7248\u5546\u6d3b\u52a8\u540d\u79f0<\/td><td>\u8bcd\u8bed\u641c\u7d22\uff01\u514d\u8d39-iOS-Tapjoy<\/td><\/tr><tr><td>\u66f4\u65b0\u65f6\u95f4<\/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 class=\"wp-block-paragraph\"><\/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>\u5e7f\u544a\u6536\u5165\u7684\u552f\u4e00\u6807\u8bc6\u7b26<\/td><td>107852371<\/td><\/tr><tr><td>\u65e5\u671f <sup>(S)<\/sup><\/td><td>\u5e7f\u544a\u6536\u5165\u4ea7\u751f\u7684\u65e5\u671f<\/td><td>2018-07-01<\/td><\/tr><tr><td>publisher_app_id <sup>(D)<\/sup><\/td><td class=\"translation-block\">\u53d1\u5e03\u5546\u6d3b\u52a8\u7684 ID\u3002\u8be5\u5b57\u6bb5\u53ef\u4e0e publisher_apps \u8868\u4e2d\u7684 <code>id<\/code> \u5b57\u6bb5\u8fdb\u884c\u5173\u8054<\/td><td>b71ff0ab-f1b4-4ca6-98fc-0064a5b9d1d7<\/td><\/tr><tr><td>\u56fd\u5bb6<\/td><td>\u6307\u6807\u6240\u5c5e\u56fd\u5bb6<\/td><td>\u7f8e\u56fd<\/td><\/tr><tr><td>revenue<\/td><td>\u5e7f\u544a\u6536\u5165\u91d1\u989d\uff08\u5355\u4f4d\uff1a\u7f8e\u5206\uff09<\/td><td>20000<\/td><\/tr><tr><td>\u8f6c\u6362<\/td><td>\u62a5\u544a\u7684\u8f6c\u5316\u6b21\u6570<\/td><td>8<\/td><\/tr><tr><td>\u70b9\u51fb\u91cf<\/td><td>\u62a5\u544a\u7684\u70b9\u51fb\u6b21\u6570<\/td><td>10<\/td><\/tr><tr><td>impressions<\/td><td>\u62a5\u544a\u7684\u5c55\u793a\u6b21\u6570<\/td><td>126<\/td><\/tr><tr><td>\u63d2\u64ad\u5e7f\u544a\u6536\u5165<\/td><td>ad revenue amount in USD cents for interstitial ads<\/td><td>20000<\/td><\/tr><tr><td>\u63d2\u9875\u5f0f\u8f6c\u5316<\/td><td>number of conversions reported for interstitial ads<\/td><td>8<\/td><\/tr><tr><td>\u63d2\u64ad\u5e7f\u544a\u70b9\u51fb\u91cf<\/td><td>number of clicks reported for interstitial ads<\/td><td>10<\/td><\/tr><tr><td>\u63d2\u9875\u5f0f\u5c55\u793a<\/td><td>number of impressions reported for interstitial ads<\/td><td>126<\/td><\/tr><tr><td>banner_revenue<\/td><td>\u6a2a\u5e45\u5e7f\u544a\u7684\u5e7f\u544a\u6536\u5165\u91d1\u989d\uff08\u5355\u4f4d\uff1a\u7f8e\u5206\uff09<\/td><td>20000<\/td><\/tr><tr><td>banner_conversions<\/td><td>\u6a2a\u5e45\u5e7f\u544a\u62a5\u544a\u7684\u8f6c\u5316\u6b21\u6570<\/td><td>8<\/td><\/tr><tr><td>banner_clicks<\/td><td>\u6a2a\u5e45\u5e7f\u544a\u62a5\u544a\u7684\u70b9\u51fb\u6b21\u6570<\/td><td>10<\/td><\/tr><tr><td>\u6a2a\u5e45\u5c55\u793a\u6b21\u6570<\/td><td>\u6a2a\u5e45\u5e7f\u544a\u7684\u62a5\u544a\u5c55\u793a\u6b21\u6570<\/td><td>126<\/td><\/tr><tr><td>\u672c\u571f\u6536\u5165<\/td><td>\u539f\u751f\u5e7f\u544a\u7684\u5e7f\u544a\u6536\u5165\u91d1\u989d\uff08\u5355\u4f4d\uff1a\u7f8e\u5206\uff09<\/td><td>20000<\/td><\/tr><tr><td>native_conversions<\/td><td>\u539f\u751f\u5e7f\u544a\u62a5\u544a\u7684\u8f6c\u5316\u6b21\u6570<\/td><td>8<\/td><\/tr><tr><td>native_clicks<\/td><td>\u539f\u751f\u5e7f\u544a\u62a5\u544a\u7684\u70b9\u51fb\u6b21\u6570<\/td><td>10<\/td><\/tr><tr><td>native_impressions<\/td><td>\u539f\u751f\u5e7f\u544a\u7684\u62a5\u544a\u5c55\u793a\u6b21\u6570<\/td><td>126<\/td><\/tr><tr><td>offerwall_revenue<\/td><td>Offerwall \u5e7f\u544a\u7684\u5e7f\u544a\u6536\u5165\u91d1\u989d\uff08\u5355\u4f4d\uff1a\u7f8e\u5206\uff09<\/td><td>20000<\/td><\/tr><tr><td>offerwall_conversions<\/td><td>Offerwall \u5e7f\u544a\u62a5\u544a\u7684\u8f6c\u5316\u6b21\u6570<\/td><td>8<\/td><\/tr><tr><td>offerwall_clicks<\/td><td>Offerwall \u5e7f\u544a\u7684\u62a5\u544a\u70b9\u51fb\u91cf<\/td><td>10<\/td><\/tr><tr><td>\u4f18\u60e0\u5899\u5c55\u793a\u6b21\u6570<\/td><td>Offerwall \u5e7f\u544a\u7684\u62a5\u544a\u5c55\u793a\u6b21\u6570<\/td><td>126<\/td><\/tr><tr><td>\u89c6\u9891\u6536\u5165<\/td><td>\u89c6\u9891\u5e7f\u544a\u7684\u5e7f\u544a\u6536\u5165\u91d1\u989d\uff08\u5355\u4f4d\uff1a\u7f8e\u5206\uff09<\/td><td>20000<\/td><\/tr><tr><td>\u89c6\u9891\u8f6c\u6362<\/td><td>\u89c6\u9891\u5e7f\u544a\u62a5\u544a\u7684\u8f6c\u5316\u6b21\u6570<\/td><td>8<\/td><\/tr><tr><td>\u89c6\u9891\u70b9\u51fb\u91cf<\/td><td>\u89c6\u9891\u5e7f\u544a\u7684\u62a5\u544a\u70b9\u51fb\u6b21\u6570<\/td><td>10<\/td><\/tr><tr><td>\u89c6\u9891_\u5c55\u793a\u91cf<\/td><td>\u89c6\u9891\u5e7f\u544a\u7684\u62a5\u544a\u5c55\u793a\u6b21\u6570<\/td><td>126<\/td><\/tr><tr><td>\u5176\u4ed6\u6536\u5165<\/td><td>\u5176\u4ed6\u5e7f\u544a\u7684\u5e7f\u544a\u6536\u5165\u91d1\u989d\uff08\u5355\u4f4d\uff1a\u7f8e\u5206\uff09<\/td><td>20000<\/td><\/tr><tr><td>\u5176\u4ed6\u8f6c\u6362<\/td><td>\u5176\u4ed6\u5e7f\u544a\u62a5\u544a\u7684\u8f6c\u5316\u6b21\u6570<\/td><td>8<\/td><\/tr><tr><td>\u5176\u4ed6\u70b9\u51fb<\/td><td>\u5176\u4ed6\u5e7f\u544a\u62a5\u544a\u7684\u70b9\u51fb\u6b21\u6570<\/td><td>10<\/td><\/tr><tr><td>\u5176\u4ed6\u5370\u8c61<\/td><td>\u5176\u4ed6\u5e7f\u544a\u62a5\u544a\u7684\u5c55\u793a\u6b21\u6570<\/td><td>126<\/td><\/tr><tr><td>\u66f4\u65b0\u65f6\u95f4<\/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 class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"8\">\u5e7f\u544a\u4e92\u52a8\u91cf<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><\/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>\u5e7f\u544a_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>\u5e94\u5f52\u56e0\u4e8e<\/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\"><code>\u70b9\u51fb\u91cf<\/code>\u6216<code>\u5c55\u793a\u91cf<\/code><\/td><td>\u70b9\u51fb\u91cf<\/td><\/tr><tr><td>campaign_id<\/td><td class=\"translation-block\">\u8be5\u6d3b\u52a8\u7684ID\u3002\u8be5\u5b57\u6bb5\u53ef\u4e0e<code>id<\/code>\u5728campaigns\u8868\u4e2d\u8fdb\u884c\u5173\u8054<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf\uff08\u7b80\u4f53\u4e2d\u6587\uff08\u5927\u9646\uff09\uff09<\/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 \u6216 Android<\/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>\u9650\u5236\u7528\u6237\u5e7f\u544a\u8ffd\u8e2a<\/td><td>(0,1)<\/td><\/tr><tr><td>uuid<\/td><td class=\"translation-block\">\u8be5\u4e8b\u4ef6\u7684\u552f\u4e00\u6807\u8bc6\u7b26\u3002\u5b83\u53ef\u4e0e <code>source_uuid<\/code> \u4e8b\u4ef6\u8868\u8fdb\u884c\u5173\u8054<\/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>\u56fd\u5bb6<\/td><td>\u56fd\u5bb6\u4ee3\u7801<\/td><td>\u7f8e\u56fd<\/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>\u7528\u6237\u4ee3\u7406<\/td><td>Dalvik\/2.1.0 (Linux\uff1bU\uff1bAndroid 8.0.0\uff1bSM-G570M Build\/R16NW)<\/td><\/tr><tr><td>remote_click_id<\/td><td>\u70b9\u51fb ID \u7531\u5e7f\u544a\u7f51\u7edc\u901a\u8fc7\u70b9\u51fb URL \u4f20\u9012\u3002.<\/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>\u8ddf\u8e2a\u72b6\u6001<\/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 class=\"wp-block-paragraph\"><\/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>\u65e5\u671f <sup>(S)<\/sup><\/td><td>\u8be5\u6307\u6807\u9002\u7528\u7684\u65e5\u671f<\/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 \u6216 Android<\/td><\/tr><tr><td>app_id<\/td><td>\u8be5\u5e94\u7528\u7684Tenjin ID<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>campaign_id<\/td><td>\u8be5\u6d3b\u52a8\u7684Tenjin ID<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf\uff08\u7b80\u4f53\u4e2d\u6587\uff08\u5927\u9646\uff09\uff09<\/td><\/tr><tr><td>\u56fd\u5bb6<\/td><td>\u4e24\u4f4d\u5b57\u6bcd\u7684\u56fd\u5bb6\u4ee3\u7801<\/td><td>\u7f8e\u56fd<\/td><\/tr><tr><td>site_id<\/td><td>\u7f51\u7ad9 ID<\/td><td>Instagram<\/td><\/tr><tr><td>\u65e5\u6d3b\u8dc3\u7528\u6237<\/td><td>\u68c0\u6d4b\u5230\u7684\u552f\u4e00\u8bbe\u5907\u6570<\/td><td>105<\/td><\/tr><tr><td>\u4f1a\u8bdd<\/td><td>\u5e94\u7528\u6253\u5f00\u4e8b\u4ef6\u7684\u8ba1\u6570<\/td><td>23650<\/td><\/tr><tr><td>iap_revenue<\/td><td>\u5e94\u7528\u5185\u8d2d\u4e70\u6536\u5165\u603b\u989d\uff08\u5355\u4f4d\uff1a\u7f8e\u5206\uff09<\/td><td>245<\/td><\/tr><tr><td>\u5df2\u62a5\u544a\u652f\u51fa<\/td><td>allocated spend from ad network reporting APIs in cents<\/td><td>5323<\/td><\/tr><tr><td>\u62a5\u544a\u7684\u5c55\u793a\u91cf<\/td><td>allocated impressions from ad network reporting APIs<\/td><td>13000<\/td><\/tr><tr><td>\u62a5\u544a\u7684\u70b9\u51fb\u91cf<\/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>\u51fa\u7248\u5546\u5e7f\u544a\u6536\u5165<\/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 class=\"wp-block-paragraph\"><\/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>\u8be5\u6307\u6807\u6240\u9002\u7528\u7684\u5f53\u524d\u961f\u5217\u7684\u65e5\u671f<\/td><td>2018-11-01<\/td><\/tr><tr><td>\u5b89\u88c5\u65e5\u671f<\/td><td>date of the install<\/td><td>2018-10-01<\/td><\/tr><tr><td>\u5b89\u88c5\u540e\u5929\u6570<\/td><td>days since install<\/td><td>3<\/td><\/tr><tr><td>platform<\/td><td>App\u53d1\u5e03\u7684\u5e73\u53f0<\/td><td>iOS \u6216 Android<\/td><\/tr><tr><td>app_id<\/td><td>\u8be5\u5e94\u7528\u7684Tenjin ID<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>campaign_id<\/td><td>\u8be5\u6d3b\u52a8\u7684Tenjin ID<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf\uff08\u7b80\u4f53\u4e2d\u6587\uff08\u5927\u9646\uff09\uff09<\/td><\/tr><tr><td>\u56fd\u5bb6<\/td><td>\u4e24\u4f4d\u5b57\u6bcd\u7684\u56fd\u5bb6\u4ee3\u7801<\/td><td>\u7f8e\u56fd<\/td><\/tr><tr><td>site_id<\/td><td>\u7f51\u7ad9 ID<\/td><td>Instagram<\/td><\/tr><tr><td>\u65e5\u6d3b\u8dc3\u7528\u6237<\/td><td>\u68c0\u6d4b\u5230\u7684\u552f\u4e00\u8bbe\u5907\u6570<\/td><td>105<\/td><\/tr><tr><td>\u4f1a\u8bdd<\/td><td>\u5e94\u7528\u6253\u5f00\u4e8b\u4ef6\u7684\u8ba1\u6570<\/td><td>23650<\/td><\/tr><tr><td>iap_revenue<\/td><td>\u5e94\u7528\u5185\u8d2d\u4e70\u6536\u5165\u603b\u989d\uff08\u5355\u4f4d\uff1a\u7f8e\u5206\uff09<\/td><td>245<\/td><\/tr><tr><td>\u51fa\u7248\u5546\u5e7f\u544a\u6536\u5165<\/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 class=\"wp-block-paragraph\">\u5bf9\u4e8e reporting_cohort_metrics\uff0c\u8bf7\u4f7f\u7528 install_date \u548c days_since_install \u6765\u83b7\u53d6\u4e0e\u4eea\u8868\u76d8\u4e2d\u76f8\u540c\u7684\u6307\u6807\u3002\u4f8b\u5982\uff1a<\/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 class=\"wp-block-paragraph\">\u8bf7\u8054\u7cfb\u60a8\u7684\u5ba2\u6237\u7ecf\u7406\u4ee5\u67e5\u770b\u6b64\u8868\u683c\u3002.<\/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>\u66f4\u65b0\u65f6\u95f4<\/td><td>\u8868\u793a\u8be5\u8bb0\u5f55\u6700\u540e\u4e00\u6b21\u66f4\u65b0\u65f6\u95f4\u7684\u65f6\u95f4\u6233\u3002.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>\u8868\u793a\u8be5\u8bb0\u5f55\u6700\u540e\u4e00\u6b21\u88ab\u52a0\u8f7d\u5230 DataVault \u4e2d\u7684\u65f6\u95f4\u6233\u3002.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"15\">skan_ad_network_metrics<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u8bf7\u8054\u7cfb\u60a8\u7684\u5ba2\u6237\u7ecf\u7406\u4ee5\u67e5\u770b\u6b64\u8868\u683c\u3002.<\/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>\u65e5\u671f<sup>(S)<\/sup><\/td><td>\u6536\u5230 SK Ad Network \u56de\u8c03\u7684\u65e5\u671f\u3002.<\/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>\u201c9668185b-da2e-4638-b15f-e03431377ac5\u201d<\/td><\/tr><tr><td>sk_campaign_id<\/td><td>SK \u6d3b\u52a8 ID\uff0c\u4e00\u4e2a 0 \u5230 99 \u4e4b\u95f4\u7684\u6574\u6570\u3002.<\/td><td>10<\/td><\/tr><tr><td>campaign_id<\/td><td>\u8be5\u6d3b\u52a8\u7684 UUID\uff08\u5929\u795e\u4e13\u5c5e ID\uff09\u3002\u53ef\u901a\u8fc7 campaigns.id \u8fdb\u884c\u5173\u8054<\/td><td>\u201c61817a78-0a8f-4e83-98c0-8106f7a6ea92\u201d<\/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>\u201c284882215\u201d<\/td><\/tr><tr><td>fidelity_type<\/td><td>StoreKit \u5e7f\u544a\u4e3a 1\uff0c\u89c6\u56fe\u8f6c\u5316\u5e7f\u544a\u4e3a 0\u3002.<\/td><td>1<\/td><\/tr><tr><td>conversion_value<\/td><td>\u8f6c\u6362\u503c\uff0c\u4e00\u4e2a\u4ecb\u4e8e0\u523063\u4e4b\u95f4\u7684\u6574\u6570\u3002.<\/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>\u91cd\u65b0\u4e0b\u8f7d\u6b21\u6570<\/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>\u8868\u793a\u8be5\u8bb0\u5f55\u6700\u540e\u4e00\u6b21\u88ab\u52a0\u8f7d\u5230 DataVault \u4e2d\u7684\u65f6\u95f4\u6233\u3002.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/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>\u65e5\u671f<sup>(S)<\/sup><\/td><td>\u6536\u5230 SK Ad Network \u56de\u8c03\u7684\u65e5\u671f\u3002.<\/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>\u201c9668185b-da2e-4638-b15f-e03431377ac5\u201d<\/td><\/tr><tr><td>sk_campaign_id<\/td><td>SK \u6d3b\u52a8 ID\uff0c\u4e00\u4e2a 0 \u5230 99 \u4e4b\u95f4\u7684\u6574\u6570\u3002.<\/td><td>10<\/td><\/tr><tr><td>campaign_id<\/td><td>\u8be5\u6d3b\u52a8\u4e13\u7528\u7684 UUID \u5929\u795e\u6807\u8bc6\u7b26\u3002\u8be5\u503c\u59cb\u7ec8\u4e3a null\uff0c\u56e0\u4e3a Apple \u672a\u63d0\u4f9b\u4efb\u4f55\u83b7\u53d6\u6b64\u503c\u7684\u65b9\u6cd5\u3002.<\/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>\u201c284882215\u201d<\/td><\/tr><tr><td>fidelity_type<\/td><td>StoreKit \u5e7f\u544a\u4e3a 1\uff0c\u89c6\u56fe\u8f6c\u5316\u5e7f\u544a\u4e3a 0\u3002.<\/td><td>1<\/td><\/tr><tr><td>conversion_value<\/td><td>\u8f6c\u6362\u503c\uff0c\u4e00\u4e2a\u4ecb\u4e8e0\u523063\u4e4b\u95f4\u7684\u6574\u6570\u3002.<\/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>\u91cd\u65b0\u4e0b\u8f7d\u6b21\u6570<\/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>\u8868\u793a\u8be5\u8bb0\u5f55\u6700\u540e\u4e00\u6b21\u88ab\u52a0\u8f7d\u5230 DataVault \u4e2d\u7684\u65f6\u95f4\u6233\u3002.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/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>\u5e7f\u544a_ID<\/td><td>iOS \u6a21\u5f0f\u4e0b\u4f7f\u7528 IDFA\uff0cAndroid \u6a21\u5f0f\u4e0b\u4f7f\u7528 Google \u5e7f\u544a ID\u3002\u8bf7\u4f7f\u7528\u5c0f\u5199\uff0c\u4e14\u4e0d\u5e26\u8fde\u5b57\u7b26<\/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 \u6216 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>\u56fd\u5bb6<\/td><td>\u56fd\u5bb6\u4ee3\u7801<\/td><td>\u7f8e\u56fd<\/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>\u5f00\u53d1\u8005\u8bbe\u5907ID<\/td><td>iOS \u5bf9\u5e94 IDFV\u3002Android \u5219\u7559\u7a7a\u3002\u5c0f\u5199\uff0c\u4e0d\u5e26\u8fde\u5b57\u7b26<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>uuid<\/td><td>\u552f\u4e00\u4e8b\u4ef6 ID<\/td><td>a3e3e535-a32c-4887-9c91-3160c91b3876<\/td><\/tr><tr><td>\u8bbe\u5907<\/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>\u8ddf\u8e2a\u72b6\u6001<\/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 class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"18\">ad_mediation_impressions_preview<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">\u8bf7\u8054\u7cfb\u60a8\u7684\u5ba2\u6237\u7ecf\u7406\u4ee5\u67e5\u770b\u6b64\u8868\u683c<\/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>\u5e7f\u544a\u5355\u5143\u7684\u683c\u5f0f<\/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>\u5e7f\u544a\u6295\u653e\u670d\u52a1\u5546<\/td><td>Applovin MAX<\/td><\/tr><tr><td>ad_mediation_revenue_microcents\uff08\u6ce8\uff1a\u6839\u636e\u8981\u6c42\uff0c\u5c06\"microcents\"\u4fdd\u7559\u4e3a\u539f\u59cb\u5355\u4f4d\u7b26\u53f7\uff0c\u672a\u8fdb\u884c\u6570\u503c\u8f6c\u6362\u3002\uff09<\/td><td>\u7531\u4e2d\u4ecb\u670d\u52a1\u5546\u63d0\u4f9b\u7684\u4ee5\u5fae\u5206\uff08microscents\uff09\u4e3a\u5355\u4f4d\u7684\u5e7f\u544a\u6536\u5165<\/td><td>22000<\/td><\/tr><tr><td>\u5e7f\u544a_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>\u56fd\u5bb6<\/td><td>\u56fd\u5bb6\u4ee3\u7801<\/td><td>\u7f8e\u56fd<\/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>\u5ba2\u6237\u7528\u6237ID<\/td><td>\u6765\u81eaApp\u7684\u7528\u6237ID\uff0c\u7531setCustomerUserId SDK\u65b9\u6cd5\u8bbe\u7f6e\u3002<\/td><td>jdabGcerT32_d<\/td><\/tr><tr><td>\u5f00\u53d1\u8005\u8bbe\u5907ID<\/td><td>iOS \u5bf9\u5e94 IDFV\u3002Android \u5219\u7559\u7a7a\u3002\u5c0f\u5199\uff0c\u4e0d\u5e26\u8fde\u5b57\u7b26<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>\u8bbe\u5907<\/td><td>\u8bbe\u5907\u7c7b\u578b<\/td><td>iPad 2.5<\/td><\/tr><tr><td>engaged_at<\/td><td>\u7528\u6237\u5728\u88ab\u6355\u83b7\u524d\u4e0e\u4e4b\u4ea4\u4e92\u7684\u70b9\u51fb\/\u5c55\u793a\u4e8b\u4ef6\u7684\u65f6\u95f4\u6233<\/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>\u9650\u5236\u7528\u6237\u5e7f\u544a\u8ffd\u8e2a<\/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>\u5982\u679c\u8be5\u5e7f\u544a\u7cfb\u5217\u662f\u4ed8\u8d39\u5e7f\u544a\u7cfb\u5217\uff0c\u5219\u4e3a\u5c55\u793a\u4e8b\u4ef6\u7684 UUID\u3002\u8be5 UUID \u53ef\u4e0e ad_engagements \u8868\u4e2d\u7684 uuid \u8fdb\u884c\u5173\u8054<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>\u8ddf\u8e2a\u72b6\u6001<\/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\">\u8be5\u4e8b\u4ef6\u7684\u552f\u4e00\u6807\u8bc6\u7b26\u3002\u5b83\u53ef\u4e0e <code>source_uuid<\/code> \u4e8b\u4ef6\u8868\u8fdb\u884c\u5173\u8054<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/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>\u5e7f\u544a_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>\u56fd\u5bb6<\/td><td>\u56fd\u5bb6\u4ee3\u7801<\/td><td>\u7f8e\u56fd<\/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>\u5f00\u53d1\u8005\u8bbe\u5907ID<\/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>\u8ddf\u8e2a\u72b6\u6001<\/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>\u6700\u540e\u4e0a\u7ebf\u65f6\u95f4<\/td><td>\u7528\u6237\u6700\u540e\u4e00\u6b21\u88ab\u770b\u5230\u7684\u65f6\u95f4\u6233<\/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 class=\"wp-block-paragraph\">\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>\u5e7f\u544a\u4e92\u52a8\u91cf<\/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":17,"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-07","word_count":1977,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"\u963f\u52aa\u62c9\u683c","author_nicename":"anurag","author_url":"https:\/\/tenjin.com\/zh\/blog\/author\/anurag\/"},"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.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DataVault Schema and Tables | Tenjin<\/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 | Tenjin\" \/>\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-06-15T10:28:30+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\":\"anurag\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/#\\\/schema\\\/person\\\/e039df04bf002f4a0825fce9d6d5f13b\"},\"headline\":\"DataVault Schema and Tables\",\"datePublished\":\"2026-02-20T07:06:12+00:00\",\"dateModified\":\"2026-06-15T10:28:30+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 | Tenjin\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tenjin.com\\\/#website\"},\"datePublished\":\"2026-02-20T07:06:12+00:00\",\"dateModified\":\"2026-06-15T10:28:30+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\\\/e039df04bf002f4a0825fce9d6d5f13b\",\"name\":\"anurag\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g\",\"caption\":\"anurag\"},\"url\":\"https:\\\/\\\/tenjin.com\\\/zh\\\/blog\\\/author\\\/anurag\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DataVault \u6a21\u5f0f\u548c\u8868 | Tenjin","description":"Tenjin \u7684 DataVault \u6a21\u5f0f\u662f\u5176\u6838\u5fc3\u4f18\u52bf\u6240\u5728\u3002\u6765\u81ea\u5404\u5904\u7684\u6240\u6709\u4fe1\u606f\u90fd\u901a\u8fc7 ID \u88ab\u5b8c\u7f8e\u5730\u6574\u5408\u5728\u4e00\u8d77\u3002.","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 | Tenjin","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-06-15T10:28:30+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":"anurag","@id":"https:\/\/tenjin.com\/#\/schema\/person\/e039df04bf002f4a0825fce9d6d5f13b"},"headline":"DataVault Schema and Tables","datePublished":"2026-02-20T07:06:12+00:00","dateModified":"2026-06-15T10:28:30+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 \u6a21\u5f0f\u548c\u8868 | Tenjin","isPartOf":{"@id":"https:\/\/tenjin.com\/#website"},"datePublished":"2026-02-20T07:06:12+00:00","dateModified":"2026-06-15T10:28:30+00:00","description":"Tenjin \u7684 DataVault \u6a21\u5f0f\u662f\u5176\u6838\u5fc3\u4f18\u52bf\u6240\u5728\u3002\u6765\u81ea\u5404\u5904\u7684\u6240\u6709\u4fe1\u606f\u90fd\u901a\u8fc7 ID \u88ab\u5b8c\u7f8e\u5730\u6574\u5408\u5728\u4e00\u8d77\u3002.","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\/e039df04bf002f4a0825fce9d6d5f13b","name":"\u963f\u52aa\u62c9\u683c","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/secure.gravatar.com\/avatar\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dc89d050d7f8053be5b8856ebaaabf82adb98e0ea57d1579b8397fb09de189c8?s=96&d=mm&r=g","caption":"anurag"},"url":"https:\/\/tenjin.com\/zh\/blog\/author\/anurag\/"}]}},"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\/17"}],"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}]}}