{"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\/vi\/docs\/datavault-schema-and-tables\/","title":{"rendered":"C\u1ea5u tr\u00fac v\u00e0 b\u1ea3ng c\u1ee7a DataVault"},"content":{"rendered":"<p class=\"wp-block-paragraph translation-block\">C\u1ea5u tr\u00fac DataVault c\u1ee7a Tenjin ch\u00ednh l\u00e0 y\u1ebfu t\u1ed1 c\u1ed1t l\u00f5i t\u1ea1o n\u00ean \u201cb\u00ed quy\u1ebft\u201d c\u1ee7a n\u00f3. T\u1ea5t c\u1ea3 th\u00f4ng tin t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i m\u1ed9t c\u00e1ch m\u1ea1ch l\u1ea1c th\u00f4ng qua c\u00e1c <code>id<\/code>. V\u1edbi c\u00e1ch t\u1ed5 ch\u1ee9c th\u00f4ng tin nh\u01b0 v\u1eady, DataVault gi\u00fap vi\u1ec7c x\u00e2y d\u1ef1ng c\u00e1c m\u00f4 h\u00ecnh v\u00e0 ph\u00e2n t\u00edch tr\u1edf n\u00ean d\u1ec5 d\u00e0ng theo c\u00e1ch x\u00e1c \u0111\u1ecbnh.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Danh s\u00e1ch c\u00e1c b\u1ea3ng<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#0\" style=\"text-decoration:none\">s\u1ef1 ki\u1ec7n<\/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\">chi\u1ebfn d\u1ecbch<\/a>\n<ul class=\"wp-block-list\">\n<li>c\u00e1c chi\u1ebfn d\u1ecbch m\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c g\u00e1n v\u00e0o, ho\u1eb7c c\u00e1c chi\u1ebfn d\u1ecbch t\u1eeb API c\u1ee7a m\u1ea1ng qu\u1ea3ng c\u00e1o<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#3\" style=\"text-decoration:none\">m\u1ea1ng qu\u1ea3ng c\u00e1o<\/a>\n<ul class=\"wp-block-list\">\n<li>danh s\u00e1ch c\u00e1c m\u1ea1ng qu\u1ea3ng c\u00e1o<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#4\" style=\"text-decoration:none\">\u1ee9ng d\u1ee5ng<\/a>\n<ul class=\"wp-block-list\">\n<li>danh s\u00e1ch c\u00e1c \u1ee9ng d\u1ee5ng<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#5\" style=\"text-decoration:none\">chi ti\u00eau h\u00e0ng ng\u00e0y theo qu\u1ed1c gia<\/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=\"\/vi\/v1\/#6\" style=\"text-decoration:none\">\u1ee9ng d\u1ee5ng c\u1ee7a nh\u00e0 xu\u1ea5t b\u1ea3n<\/a>\n<ul class=\"wp-block-list\">\n<li>c\u00e1c chi\u1ebfn d\u1ecbch c\u1ee7a nh\u00e0 xu\u1ea5t b\u1ea3n m\u00e0 ch\u00fang t\u00f4i nh\u1eadn \u0111\u01b0\u1ee3c t\u1eeb API c\u1ee7a m\u1ea1ng qu\u1ea3ng c\u00e1o<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#7\" style=\"text-decoration:none\">doanh_thu_qu\u1ea3ng_c\u00e1o_h\u00e0ng_ng\u00e0y<\/a>\n<ul class=\"wp-block-list\">\n<li>bao g\u1ed3m d\u1eef li\u1ec7u doanh thu qu\u1ea3ng c\u00e1o theo chi\u1ebfn d\u1ecbch c\u1ee7a nh\u00e0 xu\u1ea5t b\u1ea3n, theo ng\u00e0y v\u00e0 theo qu\u1ed1c gia<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#8\" style=\"text-decoration:none\">s\u1ed1 l\u1ea7n t\u01b0\u01a1ng t\u00e1c qu\u1ea3ng c\u00e1o<\/a>\n<ul class=\"wp-block-list\">\n<li>bao g\u1ed3m d\u1eef li\u1ec7u v\u1ec1 s\u1ed1 l\u1ea7n nh\u1ea5p chu\u1ed9t ho\u1eb7c s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb cho t\u1eebng thi\u1ebft b\u1ecb. B\u1ea3ng n\u00e0y ch\u1ec9 ch\u1ee9a d\u1eef li\u1ec7u t\u1eeb c\u00e1c m\u1ea1ng qu\u1ea3ng c\u00e1o kh\u00f4ng t\u1ef1 ph\u00e2n b\u1ed5. L\u01b0u \u00fd: B\u1ea3ng n\u00e0y kh\u00f4ng \u0111\u01b0\u1ee3c b\u1eadt theo m\u1eb7c \u0111\u1ecbnh; vui l\u00f2ng li\u00ean h\u1ec7 v\u1edbi ng\u01b0\u1eddi qu\u1ea3n l\u00fd t\u00e0i kho\u1ea3n Tenjin c\u1ee7a b\u1ea1n n\u1ebfu b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng n\u00f3.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#11\" style=\"text-decoration:none\">ch\u1ec9 s\u1ed1 b\u00e1o c\u00e1o<\/a>\n<ul class=\"wp-block-list\">\n<li>bao g\u1ed3m t\u1ea5t c\u1ea3 c\u00e1c ch\u1ec9 s\u1ed1 kh\u00f4ng thu\u1ed9c nh\u00f3m \u0111\u01b0\u1ee3c \u0111\u1ed3ng b\u1ed9 h\u00f3a v\u1edbi d\u1eef li\u1ec7u tr\u00ean b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#12\" style=\"text-decoration:none\">ch\u1ec9 s\u1ed1 nh\u00f3m \u0111\u1ed1i t\u01b0\u1ee3ng b\u00e1o c\u00e1o<\/a>\n<ul class=\"wp-block-list\">\n<li>bao g\u1ed3m t\u1ea5t c\u1ea3 c\u00e1c ch\u1ec9 s\u1ed1 theo nh\u00f3m \u0111\u01b0\u1ee3c \u0111\u1ed3ng b\u1ed9 h\u00f3a v\u1edbi d\u1eef li\u1ec7u tr\u00ean b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#14\" style=\"text-decoration:none\">sk_m\u1ea1ng_qu\u1ea3ng_c\u00e1o<\/a>\n<ul class=\"wp-block-list\">\n<li>B\u1ea3ng \u0111\u1ed1i chi\u1ebfu gi\u1eefa c\u00e1c ID c\u1ee7a SK Ad Network v\u00e0 c\u00e1c ID ri\u00eang c\u1ee7a Tenjin d\u00e0nh cho c\u00e1c m\u1ea1ng qu\u1ea3ng c\u00e1o.<\/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\">C\u00e1c c\u1ed9t gi\u1ed1ng nh\u01b0 trong <code>sk_ad_network_metrics<\/code>. Tuy nhi\u00ean, <code>campaign_id<\/code> lu\u00f4n c\u00f3 gi\u00e1 tr\u1ecb <code>null<\/code> do nh\u1eefng h\u1ea1n ch\u1ebf v\u1ec1 d\u1eef li\u1ec7u nh\u1eadn \u0111\u01b0\u1ee3c t\u1eeb Apple.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#17\" style=\"text-decoration:none\">c\u00e0i \u0111\u1eb7t<\/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\">xem tr\u01b0\u1edbc s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb qua n\u1ec1n t\u1ea3ng trung gian qu\u1ea3ng c\u00e1o<\/a>\n<ul class=\"wp-block-list\">\n<li>Doanh thu qu\u1ea3ng c\u00e1o theo m\u1ee9c hi\u1ec3n th\u1ecb t\u1eeb nh\u00e0 cung c\u1ea5p d\u1ecbch v\u1ee5 trung gian. L\u01b0u \u00fd: B\u1ea3ng n\u00e0y kh\u00f4ng \u0111\u01b0\u1ee3c b\u1eadt theo m\u1eb7c \u0111\u1ecbnh; vui l\u00f2ng li\u00ean h\u1ec7 v\u1edbi ng\u01b0\u1eddi qu\u1ea3n l\u00fd t\u00e0i kho\u1ea3n Tenjin c\u1ee7a b\u1ea1n n\u1ebfu mu\u1ed1n s\u1eed d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#19\" style=\"text-decoration:none\">thu\u1ed9c t\u00ednh ng\u01b0\u1eddi d\u00f9ng<\/a>\n<ul class=\"wp-block-list\">\n<li>bao g\u1ed3m c\u00e1c thu\u1ed9c t\u00ednh c\u1ee7a ng\u01b0\u1eddi d\u00f9ng<\/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\">Danh s\u00e1ch c\u00e1c tr\u01b0\u1eddng c\u1ee7a b\u1ea3ng<\/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): Kh\u00f3a s\u1eafp x\u1ebfp <br>(D): Ph\u00edm ph\u00e2n bi\u1ec7t<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"0\">s\u1ef1 ki\u1ec7n<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>th\u1eddi_gi\u1edd_t\u1ea1o <sup>(S)<\/sup><\/td><td>d\u1ea5u th\u1eddi gian khi s\u1ef1 ki\u1ec7n \u0111\u01b0\u1ee3c t\u1ea1o ra<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>id_qu\u1ea3ng_c\u00e1o<\/td><td>IDFA \u0111\u1ed1i v\u1edbi iOS ho\u1eb7c ID qu\u1ea3ng c\u00e1o c\u1ee7a Google \u0111\u1ed1i v\u1edbi Android. Vi\u1ebft th\u01b0\u1eddng, kh\u00f4ng c\u00f3 d\u1ea5u g\u1ea1ch ngang.<\/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>n\u1ec1n t\u1ea3ng<\/td><td>n\u1ec1n t\u1ea3ng c\u1ee7a \u1ee9ng d\u1ee5ng<\/td><td>iOS hay Android<\/td><\/tr><tr><td>os_version<\/td><td>phi\u00ean b\u1ea3n h\u1ec7 \u0111i\u1ec1u h\u00e0nh c\u1ee7a thi\u1ebft b\u1ecb<\/td><td>8.0<\/td><\/tr><tr><td>phi\u00ean b\u1ea3n \u1ee9ng d\u1ee5ng<\/td><td>phi\u00ean b\u1ea3n \u1ee9ng d\u1ee5ng<\/td><td>1.0.3<\/td><\/tr><tr><td>gi\u1edbi h\u1ea1n theo d\u00f5i qu\u1ea3ng c\u00e1o<\/td><td>gi\u1edbi h\u1ea1n theo d\u00f5i qu\u1ea3ng c\u00e1o c\u1ee7a ng\u01b0\u1eddi d\u00f9ng (0,1)<\/td><td>1<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">ID \u1ee9ng d\u1ee5ng n\u1ed9i b\u1ed9 c\u1ee7a Tenjin. ID n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi <code>id<\/code> trong b\u1ea3ng apps<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>lo\u1ea1i s\u1ef1 ki\u1ec7n<\/td><td class=\"translation-block\">ho\u1eb7c <code>s\u1ef1 ki\u1ec7n<\/code> ho\u1eb7c <code>mua h\u00e0ng<\/code><\/td><td>s\u1ef1 ki\u1ec7n<\/td><\/tr><tr><td>s\u1ef1 ki\u1ec7n<\/td><td class=\"translation-block\">Khi `event_type` c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 <code>event<\/code>, th\u00ec gi\u00e1 tr\u1ecb n\u00e0y s\u1ebd l\u00e0 <code>open<\/code> ho\u1eb7c m\u1ed9t t\u00ean s\u1ef1 ki\u1ec7n t\u00f9y ch\u1ec9nh.<\/td><td>m\u1edf<\/td><\/tr><tr><td>ID chi\u1ebfn d\u1ecbch ngu\u1ed3n<\/td><td class=\"translation-block\">M\u00e3 chi\u1ebfn d\u1ecbch n\u1ed9i b\u1ed9 c\u1ee7a Tenjin d\u00e0nh cho ng\u01b0\u1eddi d\u00f9ng chi\u1ebfn d\u1ecbch \u0111\u01b0\u1ee3c g\u00e1n cho. M\u00e3 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi <code>id<\/code> trong b\u1ea3ng campaigns<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>ng\u00e0y_mua<\/td><td>d\u1ea5u th\u1eddi gian khi ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c thu h\u00fat<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>gi\u00e1<\/td><td>gi\u00e1 mua ban \u0111\u1ea7u cho giao d\u1ecbch mua<\/td><td>1.99<\/td><\/tr><tr><td>s\u1ed1 l\u01b0\u1ee3ng<\/td><td>s\u1ed1 l\u01b0\u1ee3ng mua cho s\u1ef1 ki\u1ec7n mua h\u00e0ng<\/td><td>2<\/td><\/tr><tr><td>product_id<\/td><td>M\u00e3 s\u1ea3n ph\u1ea9m cho giao d\u1ecbch mua h\u00e0ng<\/td><td>com.tenjin.wordfinder.package50<\/td><\/tr><tr><td>ti\u1ec1n t\u1ec7<\/td><td>m\u00e3 ti\u1ec1n t\u1ec7 cho giao d\u1ecbch mua h\u00e0ng<\/td><td>USD<\/td><\/tr><tr><td>qu\u1ed1c gia<\/td><td>m\u00e3 qu\u1ed1c gia<\/td><td>Hoa K\u1ef3<\/td><\/tr><tr><td>t\u1ed5ng_doanh_thu<\/td><td class=\"translation-block\">Doanh thu g\u1ed9p t\u1eeb \u0111\u1ee3t mua h\u00e0ng n\u00e0y t\u00ednh b\u1eb1ng USD <strong>cents<\/strong><\/td><td>350<\/td><\/tr><tr><td>doanh thu<\/td><td class=\"translation-block\">Doanh thu r\u00f2ng t\u1eeb \u0111\u1ee3t mua h\u00e0ng n\u00e0y t\u00ednh b\u1eb1ng USD <strong>cents<\/strong><\/td><td>245<\/td><\/tr><tr><td>site_id<\/td><td>ID nh\u00e0 xu\u1ea5t b\u1ea3n c\u1ee7a chi\u1ebfn d\u1ecbch n\u1ebfu \u0111\u00f3 l\u00e0 chi\u1ebfn d\u1ecbch tr\u1ea3 ph\u00ed<\/td><td>Instagram<\/td><\/tr><tr><td>id_thi\u1ebft_b\u1ecb_nh\u00e0_ph\u00e1t_tri\u1ec3n<\/td><td>IDFV cho iOS. \u0110\u1ec3 tr\u1ed1ng cho Android. Vi\u1ebft th\u01b0\u1eddng, kh\u00f4ng c\u00f3 d\u1ea5u g\u1ea1ch ngang.<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>tr\u1ea1ng_t\u00ecnh_mua_h\u00e0ng<\/td><td><ul><li>0: Kh\u00f4ng x\u00e1c \u0111\u1ecbnh \u2013 kh\u00f4ng nh\u1eadn \u0111\u01b0\u1ee3c h\u00f3a \u0111\u01a1n khi mua h\u00e0ng<\/li><li>1: Ch\u01b0a \u0111\u01b0\u1ee3c x\u00e1c minh \u2013 \u0111\u00e3 cung c\u1ea5p h\u00f3a \u0111\u01a1n nh\u01b0ng kh\u00f4ng th\u1ec3 x\u00e1c minh \u0111\u01b0\u1ee3c<\/li><li>2: Gian l\u1eadn \u2013 \u0111\u00e3 xu\u1ea5t tr\u00ecnh h\u00f3a \u0111\u01a1n gi\u1ea3 m\u1ea1o<\/li><li>3: \u0110\u00e3 x\u00e1c minh \u2013 bi\u00ean lai \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00e1c minh th\u00e0nh c\u00f4ng<\/li><li>4: Sandbox \u2013 h\u00f3a \u0111\u01a1n \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00e1c minh trong m\u00f4i tr\u01b0\u1eddng th\u1eed nghi\u1ec7m sandbox<\/li><li>5: Tr\u00f9ng l\u1eb7p \u2013 h\u00f3a \u0111\u01a1n n\u00e0y \u0111\u00e3 \u0111\u01b0\u1ee3c ghi nh\u1eadn trong m\u1ed9t giao d\u1ecbch mua h\u00e0ng tr\u01b0\u1edbc \u0111\u00f3<\/li><li>6: \u0110\u00e3 h\u1ebft h\u1ea1n \u2013 s\u1ef1 ki\u1ec7n mua h\u00e0ng di\u1ec5n ra c\u00e1ch \u0111\u00e2y 3 ng\u00e0y v\u00e0 kh\u00f4ng ph\u1ea3i theo th\u1eddi gian th\u1ef1c<\/li><\/ul><\/td><td>3<\/td><\/tr><tr><td>gi\u00e1 tr\u1ecb<\/td><td>Gi\u00e1 tr\u1ecb s\u1ef1 ki\u1ec7n t\u00f9y ch\u1ec9nh<\/td><td>1<\/td><\/tr><tr><td>uuid<\/td><td>ID s\u1ef1 ki\u1ec7n duy nh\u1ea5t<\/td><td>a3e3e535-a32c-4887-9c91-3160c91b3876<\/td><\/tr><tr><td>thi\u1ebft b\u1ecb<\/td><td>lo\u1ea1i thi\u1ebft b\u1ecb<\/td><td>iPad 2,5<\/td><\/tr><tr><td>t\u00ean_s\u00e1ng_t\u1ea1o<\/td><td>t\u00ean s\u00e1ng t\u1ea1o<\/td><td>test_creative<\/td><\/tr><tr><td>\u0111\u1ecba ch\u1ec9 IP<\/td><td>\u0111\u1ecba ch\u1ec9 IP c\u1ee7a ng\u01b0\u1eddi d\u00f9ng<\/td><td>71.165.85.114<\/td><\/tr><tr><td>source_uuid<\/td><td class=\"translation-block\">M\u00e3 UUID c\u1ee7a s\u1ef1 ki\u1ec7n nh\u1ea5p chu\u1ed9t ho\u1eb7c hi\u1ec3n th\u1ecb n\u1ebfu chi\u1ebfn d\u1ecbch l\u00e0 chi\u1ebfn d\u1ecbch tr\u1ea3 ph\u00ed. M\u00e3 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi <code>uuid<\/code> trong b\u1ea3ng ad_engagements<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">s\u1ed1 nguy\u00ean bi\u1ec3u th\u1ecb <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">tr\u1ea1ng th\u00e1i ATT<\/a> c\u1ee7a thi\u1ebft b\u1ecb iOS. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; ch\u01b0a x\u00e1c \u0111\u1ecbnh, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; b\u1ecb h\u1ea1n ch\u1ebf, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; b\u1ecb t\u1eeb ch\u1ed1i, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; \u0111\u01b0\u1ee3c ph\u00e9p<\/td><td>3<\/td><\/tr><tr><td>m\u00e3_c\u00e0i_\u0111\u1eb7t_ph\u00e2n_t\u00edch<\/td><td>Tenjin generated Application install-specific identifier. Lower case, without hyphen.<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><tr><td>id_kh\u00e1ch_h\u00e0ng_ng\u01b0\u1eddi_d\u00f9ng<\/td><td>ID ng\u01b0\u1eddi d\u00f9ng t\u1eeb \u1ee9ng d\u1ee5ng, \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp b\u1eb1ng ph\u01b0\u01a1ng th\u1ee9c setCustomerUserId c\u1ee7a SDK<\/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\">chi\u1ebfn d\u1ecbch<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>M\u00e3 \u0111\u1ecbnh danh duy nh\u1ea5t cho chi\u1ebfn d\u1ecbch<\/td><td>3b70e477-c151-4167-9174-cca6ffa2c7bc<\/td><\/tr><tr><td>t\u00ean<\/td><td>t\u00ean chi\u1ebfn d\u1ecbch<\/td><td>ki\u1ec3m tra @bYkiNAbrAOCpzETWviMILo<\/td><\/tr><tr><td>id_m\u1ea1ng_qu\u1ea3ng_c\u00e1o<\/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\">ID \u1ee9ng d\u1ee5ng n\u1ed9i b\u1ed9 c\u1ee7a Tenjin. ID n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi <code>id<\/code> trong b\u1ea3ng apps<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>remote_campaign_id<\/td><td>ID chi\u1ebfn d\u1ecbch m\u00e0 m\u1ea1ng qu\u1ea3ng c\u00e1o s\u1eed d\u1ee5ng. Ch\u00fang t\u00f4i thu th\u1eadp th\u00f4ng tin n\u00e0y th\u00f4ng qua API b\u00e1o c\u00e1o c\u1ee7a m\u1ea1ng qu\u1ea3ng c\u00e1o.<\/td><td>6026825090762<\/td><\/tr><tr><td>id_th\u00f9ng_chi\u1ebfn_d\u1ecbch<\/td><td class=\"translation-block\">ID bucket chi\u1ebfn d\u1ecbch cho c\u00e1c chi\u1ebfn d\u1ecbch bucket. Th\u00f4ng tin n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi <code>id<\/code> trong b\u1ea3ng campaign_buckets<\/td><td>fbbc74bd-8a73-472a-86f7-5e2a4642a201<\/td><\/tr><tr><td>c\u1eadp nh\u1eadt v\u00e0o<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a Tenjin<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/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\">m\u1ea1ng qu\u1ea3ng c\u00e1o<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>id <sup>(S)<\/sup><\/td><td>ID duy nh\u1ea5t cho m\u1ea1ng qu\u1ea3ng c\u00e1o<\/td><td>3<\/td><\/tr><tr><td>t\u00ean<\/td><td>ad network name<\/td><td>Facebook<\/td><\/tr><tr><td>c\u1eadp nh\u1eadt v\u00e0o<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a Tenjin<\/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\">\u1ee9ng d\u1ee5ng<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>ID duy nh\u1ea5t c\u1ee7a \u1ee9ng d\u1ee5ng<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>t\u00ean<\/td><td>T\u00ean \u1ee9ng d\u1ee5ng<\/td><td>T\u00ecm t\u1eeb<\/td><\/tr><tr><td>m\u00e3_c\u1eeda_h\u00e0ng<\/td><td>ID \u1ee9ng d\u1ee5ng tr\u00ean App Store<\/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>n\u1ec1n t\u1ea3ng<\/td><td>n\u1ec1n t\u1ea3ng c\u1ee7a \u1ee9ng d\u1ee5ng<\/td><td>iOS hay Android<\/td><\/tr><tr><td>c\u1eadp nh\u1eadt v\u00e0o<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a Tenjin<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/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\">chi ti\u00eau h\u00e0ng ng\u00e0y theo qu\u1ed1c gia<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>m\u00e3 \u0111\u1ecbnh danh duy nh\u1ea5t cho d\u1eef li\u1ec7u chi ti\u00eau<\/td><td>174491158<\/td><\/tr><tr><td>ng\u00e0y <sup>(S)<\/sup><\/td><td>ng\u00e0y th\u1ef1c hi\u1ec7n chi ti\u00eau<\/td><td>2018-07-01<\/td><\/tr><tr><td>qu\u1ed1c gia<\/td><td>qu\u1ed1c gia n\u01a1i kho\u1ea3n chi ti\u00eau \u0111\u00f3 di\u1ec5n ra<\/td><td>Hoa K\u1ef3<\/td><\/tr><tr><td>campaign_id <sup>(D)<\/sup><\/td><td class=\"translation-block\">M\u00e3 \u0111\u1ecbnh danh (ID) c\u1ee7a chi\u1ebfn d\u1ecbch. M\u00e3 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi <code>id<\/code> trong b\u1ea3ng campaigns<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>chi ti\u00eau<\/td><td>ad spend amount in USD cents.<\/td><td>400<\/td><\/tr><tr><td>c\u00e0i \u0111\u1eb7t<\/td><td>s\u1ed1 l\u01b0\u1ee3t c\u00e0i \u0111\u1eb7t \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o<\/td><td>8<\/td><\/tr><tr><td>l\u01b0\u1ee3t nh\u1ea5p<\/td><td>s\u1ed1 l\u1ea7n nh\u1ea5p chu\u1ed9t \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o<\/td><td>10<\/td><\/tr><tr><td>l\u01b0\u1ee3t xem<\/td><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o<\/td><td>126<\/td><\/tr><tr><td>chi ti\u00eau ban \u0111\u1ea7u<\/td><td>ad spend amount in original currency<\/td><td>4<\/td><\/tr><tr><td>\u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 g\u1ed1c<\/td><td>\u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 ban \u0111\u1ea7u<\/td><td>USD<\/td><\/tr><tr><td>c\u1eadp nh\u1eadt v\u00e0o<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a Tenjin<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>qu\u1ed1c_gia_thi\u1ebfu<\/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\">\u1ee9ng d\u1ee5ng c\u1ee7a nh\u00e0 xu\u1ea5t b\u1ea3n<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>ID duy nh\u1ea5t cho \u1ee9ng d\u1ee5ng c\u1ee7a nh\u00e0 xu\u1ea5t b\u1ea3n<\/td><td>b71ff0ab-f1b4-4ca6-98fc-0064a5b9d1d7<\/td><\/tr><tr><td>id_m\u1ea1ng_qu\u1ea3ng_c\u00e1o<\/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\">ID \u1ee9ng d\u1ee5ng n\u1ed9i b\u1ed9 c\u1ee7a Tenjin. ID n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi <code>id<\/code> trong b\u1ea3ng apps<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>t\u00ean<\/td><td>T\u00ean chi\u1ebfn d\u1ecbch c\u1ee7a nh\u00e0 xu\u1ea5t b\u1ea3n<\/td><td>T\u00ecm t\u1eeb! Mi\u1ec5n ph\u00ed - iOS - Tapjoy<\/td><\/tr><tr><td>c\u1eadp nh\u1eadt v\u00e0o<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a Tenjin<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/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\">doanh_thu_qu\u1ea3ng_c\u00e1o_h\u00e0ng_ng\u00e0y<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>M\u00e3 \u0111\u1ecbnh danh duy nh\u1ea5t cho doanh thu qu\u1ea3ng c\u00e1o<\/td><td>107852371<\/td><\/tr><tr><td>ng\u00e0y <sup>(S)<\/sup><\/td><td>ng\u00e0y ph\u00e1t sinh doanh thu qu\u1ea3ng c\u00e1o<\/td><td>2018-07-01<\/td><\/tr><tr><td>id_\u1ee9ng_d\u1ee5ng_nh\u00e0_xu\u1ea5t_b\u1ea3n <sup>(D)<\/sup><\/td><td class=\"translation-block\">ID c\u1ee7a chi\u1ebfn d\u1ecbch nh\u00e0 xu\u1ea5t b\u1ea3n. Th\u00f4ng tin n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi <code>id<\/code> trong b\u1ea3ng publisher_apps<\/td><td>b71ff0ab-f1b4-4ca6-98fc-0064a5b9d1d7<\/td><\/tr><tr><td>qu\u1ed1c gia<\/td><td>qu\u1ed1c gia \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0m c\u01a1 s\u1edf cho c\u00e1c ch\u1ec9 s\u1ed1<\/td><td>Hoa K\u1ef3<\/td><\/tr><tr><td>doanh thu<\/td><td>s\u1ed1 ti\u1ec1n doanh thu qu\u1ea3ng c\u00e1o t\u00ednh b\u1eb1ng xu USD<\/td><td>20000<\/td><\/tr><tr><td>s\u1ed1 ng\u01b0\u1eddi chuy\u1ec3n \u0111\u1ed5i<\/td><td>s\u1ed1 l\u01b0\u1ee3t chuy\u1ec3n \u0111\u1ed5i \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o<\/td><td>8<\/td><\/tr><tr><td>l\u01b0\u1ee3t nh\u1ea5p<\/td><td>s\u1ed1 l\u1ea7n nh\u1ea5p chu\u1ed9t \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o<\/td><td>10<\/td><\/tr><tr><td>l\u01b0\u1ee3t xem<\/td><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o<\/td><td>126<\/td><\/tr><tr><td>doanh thu t\u1eeb qu\u1ea3ng c\u00e1o xen k\u1ebd<\/td><td>ad revenue amount in USD cents for interstitial ads<\/td><td>20000<\/td><\/tr><tr><td>chuy\u1ec3n \u0111\u1ed5i gi\u1eefa c\u00e1c trang<\/td><td>number of conversions reported for interstitial ads<\/td><td>8<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n nh\u1ea5p v\u00e0o qu\u1ea3ng c\u00e1o gi\u1eefa c\u00e1c trang<\/td><td>number of clicks reported for interstitial ads<\/td><td>10<\/td><\/tr><tr><td>l\u01b0\u1ee3t hi\u1ec3n th\u1ecb gi\u1eefa c\u00e1c trang<\/td><td>number of impressions reported for interstitial ads<\/td><td>126<\/td><\/tr><tr><td>banner_doanh_thu<\/td><td>S\u1ed1 ti\u1ec1n doanh thu qu\u1ea3ng c\u00e1o (t\u00ednh b\u1eb1ng xu USD) t\u1eeb c\u00e1c qu\u1ea3ng c\u00e1o banner<\/td><td>20000<\/td><\/tr><tr><td>banner_chuy\u1ec3n \u0111\u1ed5i<\/td><td>s\u1ed1 l\u01b0\u1ee3t chuy\u1ec3n \u0111\u1ed5i \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o t\u1eeb qu\u1ea3ng c\u00e1o banner<\/td><td>8<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n nh\u1ea5p v\u00e0o banner<\/td><td>s\u1ed1 l\u1ea7n nh\u1ea5p chu\u1ed9t \u0111\u01b0\u1ee3c ghi nh\u1eadn \u0111\u1ed1i v\u1edbi qu\u1ea3ng c\u00e1o banner<\/td><td>10<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb banner<\/td><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o cho c\u00e1c qu\u1ea3ng c\u00e1o banner<\/td><td>126<\/td><\/tr><tr><td>doanh thu n\u1ed9i \u0111\u1ecba<\/td><td>S\u1ed1 ti\u1ec1n doanh thu qu\u1ea3ng c\u00e1o (t\u00ednh b\u1eb1ng xu USD) t\u1eeb qu\u1ea3ng c\u00e1o b\u1ea3n \u0111\u1ecba<\/td><td>20000<\/td><\/tr><tr><td>chuy\u1ec3n \u0111\u1ed5i g\u1ed1c<\/td><td>s\u1ed1 l\u01b0\u1ee3t chuy\u1ec3n \u0111\u1ed5i \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o \u0111\u1ed1i v\u1edbi qu\u1ea3ng c\u00e1o t\u00edch h\u1ee3p<\/td><td>8<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n nh\u1ea5p chu\u1ed9t c\u1ee7a ng\u01b0\u1eddi d\u00f9ng b\u1ea3n \u0111\u1ecba<\/td><td>s\u1ed1 l\u1ea7n nh\u1ea5p chu\u1ed9t \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o \u0111\u1ed1i v\u1edbi qu\u1ea3ng c\u00e1o b\u1ea3n \u0111\u1ecba<\/td><td>10<\/td><\/tr><tr><td>nh\u1eefng \u1ea5n t\u01b0\u1ee3ng b\u1ea3n \u0111\u1ecba<\/td><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o \u0111\u1ed1i v\u1edbi qu\u1ea3ng c\u00e1o b\u1ea3n \u0111\u1ecba<\/td><td>126<\/td><\/tr><tr><td>offerwall_doanh_thu<\/td><td>S\u1ed1 ti\u1ec1n doanh thu qu\u1ea3ng c\u00e1o (t\u00ednh b\u1eb1ng xu USD) t\u1eeb c\u00e1c qu\u1ea3ng c\u00e1o tr\u00ean Offerwall<\/td><td>20000<\/td><\/tr><tr><td>s\u1ed1 l\u01b0\u1ee3t chuy\u1ec3n \u0111\u1ed5i t\u1eeb Offerwall<\/td><td>s\u1ed1 l\u01b0\u1ee3t chuy\u1ec3n \u0111\u1ed5i \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o cho c\u00e1c qu\u1ea3ng c\u00e1o tr\u00ean Offerwall<\/td><td>8<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n nh\u1ea5p v\u00e0o Offerwall<\/td><td>s\u1ed1 l\u1ea7n nh\u1ea5p chu\u1ed9t \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o \u0111\u1ed1i v\u1edbi qu\u1ea3ng c\u00e1o tr\u00ean Offerwall<\/td><td>10<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb tr\u00ean Offerwall<\/td><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o cho c\u00e1c qu\u1ea3ng c\u00e1o tr\u00ean Offerwall<\/td><td>126<\/td><\/tr><tr><td>doanh thu t\u1eeb video<\/td><td>S\u1ed1 ti\u1ec1n doanh thu qu\u1ea3ng c\u00e1o t\u00ednh b\u1eb1ng cent USD cho qu\u1ea3ng c\u00e1o video<\/td><td>20000<\/td><\/tr><tr><td>chuy\u1ec3n \u0111\u1ed5i video<\/td><td>s\u1ed1 l\u01b0\u1ee3t chuy\u1ec3n \u0111\u1ed5i \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o t\u1eeb qu\u1ea3ng c\u00e1o video<\/td><td>8<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n nh\u1ea5p v\u00e0o video<\/td><td>s\u1ed1 l\u1ea7n nh\u1ea5p chu\u1ed9t \u0111\u01b0\u1ee3c ghi nh\u1eadn \u0111\u1ed1i v\u1edbi qu\u1ea3ng c\u00e1o video<\/td><td>10<\/td><\/tr><tr><td>l\u01b0\u1ee3t xem video<\/td><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o cho qu\u1ea3ng c\u00e1o video<\/td><td>126<\/td><\/tr><tr><td>doanh thu kh\u00e1c<\/td><td>S\u1ed1 ti\u1ec1n doanh thu qu\u1ea3ng c\u00e1o (t\u00ednh b\u1eb1ng xu USD) t\u1eeb c\u00e1c qu\u1ea3ng c\u00e1o kh\u00e1c<\/td><td>20000<\/td><\/tr><tr><td>c\u00e1c_h\u00ecnh_th\u1ee9c_chuy\u1ec3n \u0111\u1ed5i_kh\u00e1c<\/td><td>s\u1ed1 l\u01b0\u1ee3t chuy\u1ec3n \u0111\u1ed5i \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o cho c\u00e1c qu\u1ea3ng c\u00e1o kh\u00e1c<\/td><td>8<\/td><\/tr><tr><td>c\u00e1c_l\u1ea7n_nh\u1ea5p_kh\u00e1c<\/td><td>s\u1ed1 l\u1ea7n nh\u1ea5p chu\u1ed9t \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o \u0111\u1ed1i v\u1edbi c\u00e1c qu\u1ea3ng c\u00e1o kh\u00e1c<\/td><td>10<\/td><\/tr><tr><td>c\u00e1c_\u1ea5n_t\u01b0\u1ee3ng_kh\u00e1c<\/td><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o \u0111\u1ed1i v\u1edbi c\u00e1c qu\u1ea3ng c\u00e1o kh\u00e1c<\/td><td>126<\/td><\/tr><tr><td>c\u1eadp nh\u1eadt v\u00e0o<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a Tenjin<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/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\">s\u1ed1 l\u1ea7n t\u01b0\u01a1ng t\u00e1c qu\u1ea3ng c\u00e1o<\/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>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>th\u1eddi_gi\u1edd_t\u1ea1o <sup>(S)<\/sup><\/td><td>d\u1ea5u th\u1eddi gian khi s\u1ef1 ki\u1ec7n \u0111\u01b0\u1ee3c t\u1ea1o ra<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>id_qu\u1ea3ng_c\u00e1o<\/td><td>IDFA \u0111\u1ed1i v\u1edbi iOS ho\u1eb7c ID qu\u1ea3ng c\u00e1o c\u1ee7a Google \u0111\u1ed1i v\u1edbi Android. Vi\u1ebft th\u01b0\u1eddng, kh\u00f4ng c\u00f3 d\u1ea5u g\u1ea1ch ngang.<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>c\u00f3 th\u1ec3 quy cho<\/td><td class=\"translation-block\">if the click\/impression is used for attribution or not. <code>true<\/code> or <code>false<\/code><\/td><td>\u0111\u00fang<\/td><\/tr><tr><td>lo\u1ea1i s\u1ef1 ki\u1ec7n<\/td><td class=\"translation-block\">ho\u1eb7c <code>s\u1ed1 l\u1ea7n nh\u1ea5p chu\u1ed9t<\/code> ho\u1eb7c <code>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb<\/code><\/td><td>l\u01b0\u1ee3t nh\u1ea5p<\/td><\/tr><tr><td>campaign_id<\/td><td class=\"translation-block\">M\u00e3 \u0111\u1ecbnh danh (ID) c\u1ee7a chi\u1ebfn d\u1ecbch. M\u00e3 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi <code>id<\/code> trong b\u1ea3ng campaigns<\/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>n\u1ec1n t\u1ea3ng<\/td><td>n\u1ec1n t\u1ea3ng c\u1ee7a \u1ee9ng d\u1ee5ng<\/td><td>iOS hay Android<\/td><\/tr><tr><td>\u0111\u1ecba ch\u1ec9 IP<\/td><td>\u0111\u1ecba ch\u1ec9 IP c\u1ee7a ng\u01b0\u1eddi d\u00f9ng<\/td><td>71.165.85.114<\/td><\/tr><tr><td>gi\u1edbi h\u1ea1n theo d\u00f5i qu\u1ea3ng c\u00e1o<\/td><td>Gi\u1edbi h\u1ea1n theo d\u00f5i qu\u1ea3ng c\u00e1o c\u1ee7a ng\u01b0\u1eddi d\u00f9ng<\/td><td>(0,1)<\/td><\/tr><tr><td>uuid<\/td><td class=\"translation-block\">M\u00e3 \u0111\u1ecbnh danh duy nh\u1ea5t (unique ID) c\u1ee7a s\u1ef1 ki\u1ec7n. M\u00e3 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi b\u1ea3ng s\u1ef1 ki\u1ec7n <code>source_uuid<\/code><\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">ID \u1ee9ng d\u1ee5ng n\u1ed9i b\u1ed9 c\u1ee7a Tenjin. ID n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi <code>id<\/code> trong b\u1ea3ng apps<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>qu\u1ed1c gia<\/td><td>m\u00e3 qu\u1ed1c gia<\/td><td>Hoa K\u1ef3<\/td><\/tr><tr><td>site_id<\/td><td>ID nh\u00e0 xu\u1ea5t b\u1ea3n c\u1ee7a chi\u1ebfn d\u1ecbch n\u1ebfu \u0111\u00f3 l\u00e0 chi\u1ebfn d\u1ecbch tr\u1ea3 ph\u00ed<\/td><td>Instagram<\/td><\/tr><tr><td>user_agent<\/td><td>Tr\u00ecnh duy\u1ec7t<\/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>ID c\u1ee7a m\u1ea1ng qu\u1ea3ng c\u00e1o \u0111\u01b0\u1ee3c truy\u1ec1n qua URL nh\u1ea5p chu\u1ed9t.<\/td><td>DSGfaa<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">s\u1ed1 nguy\u00ean bi\u1ec3u th\u1ecb <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">tr\u1ea1ng th\u00e1i ATT<\/a> c\u1ee7a thi\u1ebft b\u1ecb iOS. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; ch\u01b0a x\u00e1c \u0111\u1ecbnh, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; b\u1ecb h\u1ea1n ch\u1ebf, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; b\u1ecb t\u1eeb ch\u1ed1i, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; \u0111\u01b0\u1ee3c ph\u00e9p<\/td><td>3<\/td><\/tr><tr><td>m\u00e3_c\u00e0i_\u0111\u1eb7t_ph\u00e2n_t\u00edch<\/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\">ch\u1ec9 s\u1ed1 b\u00e1o c\u00e1o<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>ng\u00e0y <sup>(S)<\/sup><\/td><td>ng\u00e0y m\u00e0 ch\u1ec9 s\u1ed1 n\u00e0y \u00e1p d\u1ee5ng<\/td><td>2018-11-01<\/td><\/tr><tr><td>id_m\u1ea1ng_qu\u1ea3ng_c\u00e1o<\/td><td>Tenjin ID of the ad network<\/td><td>3<\/td><\/tr><tr><td>n\u1ec1n t\u1ea3ng<\/td><td>n\u1ec1n t\u1ea3ng c\u1ee7a \u1ee9ng d\u1ee5ng<\/td><td>iOS hay Android<\/td><\/tr><tr><td>app_id<\/td><td>M\u00e3 ID Tenjin c\u1ee7a \u1ee9ng d\u1ee5ng<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>campaign_id<\/td><td>M\u00e3 ID Tenjin c\u1ee7a chi\u1ebfn d\u1ecbch<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>qu\u1ed1c gia<\/td><td>m\u00e3 qu\u1ed1c gia g\u1ed3m hai ch\u1eef c\u00e1i<\/td><td>Hoa K\u1ef3<\/td><\/tr><tr><td>site_id<\/td><td>M\u00e3 \u0111\u1ecbnh danh trang web<\/td><td>Instagram<\/td><\/tr><tr><td>s\u1ed1_ng\u01b0\u1eddi_d\u00f9ng_ho\u1ea1t_\u0111\u1ed9ng_h\u00e0ng_ng\u00e0y<\/td><td>s\u1ed1 l\u01b0\u1ee3ng thi\u1ebft b\u1ecb duy nh\u1ea5t \u0111\u01b0\u1ee3c ph\u00e1t hi\u1ec7n<\/td><td>105<\/td><\/tr><tr><td>bu\u1ed5i h\u1ecdc<\/td><td>s\u1ed1 l\u1ea7n \u1ee9ng d\u1ee5ng \u0111\u01b0\u1ee3c m\u1edf<\/td><td>23650<\/td><\/tr><tr><td>doanh thu iap<\/td><td>t\u1ed5ng doanh thu t\u1eeb mua h\u00e0ng trong \u1ee9ng d\u1ee5ng t\u00ednh b\u1eb1ng cent USD<\/td><td>245<\/td><\/tr><tr><td>chi ti\u00eau \u0111\u00e3 b\u00e1o c\u00e1o<\/td><td>allocated spend from ad network reporting APIs in cents<\/td><td>5323<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o<\/td><td>allocated impressions from ad network reporting APIs<\/td><td>13000<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n nh\u1ea5p \u0111\u01b0\u1ee3c b\u00e1o c\u00e1o<\/td><td>allocated clicks from ad network reporting APIs<\/td><td>3000<\/td><\/tr><tr><td>S\u1ed1 l\u01b0\u1ee3t c\u00e0i \u0111\u1eb7t \u0111\u00e3 b\u00e1o c\u00e1o<\/td><td>allocated installs from ad network reporting APIs<\/td><td>4000<\/td><\/tr><tr><td>doanh thu qu\u1ea3ng c\u00e1o t\u1eeb nh\u00e0 xu\u1ea5t b\u1ea3n<\/td><td>allocated sum of publisher ad revenue from ad network reporting API in USD cents<\/td><td>2000<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c theo d\u00f5i<\/td><td>count of impressions tracked by Tenjin attribution<\/td><td>13000<\/td><\/tr><tr><td>s\u1ed1 l\u1ea7n nh\u1ea5p \u0111\u01b0\u1ee3c theo d\u00f5i<\/td><td>count of clicks tracked by Tenjin attribution<\/td><td>4000<\/td><\/tr><tr><td>s\u1ed1 l\u01b0\u1ee3t c\u00e0i \u0111\u1eb7t \u0111\u01b0\u1ee3c theo d\u00f5i<\/td><td>count of installs tracked by Tenjin attribution<\/td><td>3000<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/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\">ch\u1ec9 s\u1ed1 nh\u00f3m \u0111\u1ed1i t\u01b0\u1ee3ng b\u00e1o c\u00e1o<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>ng\u00e0y_s\u1ef1_ki\u1ec7n <sup>(S)<\/sup><\/td><td>ng\u00e0y c\u1ee7a nh\u00f3m \u0111\u1ed1i t\u01b0\u1ee3ng hi\u1ec7n t\u1ea1i m\u00e0 c\u00e1c ch\u1ec9 s\u1ed1 n\u00e0y \u00e1p d\u1ee5ng<\/td><td>2018-11-01<\/td><\/tr><tr><td>ng\u00e0y c\u00e0i \u0111\u1eb7t<\/td><td>date of the install<\/td><td>2018-10-01<\/td><\/tr><tr><td>s\u1ed1_ng\u00e0y_k\u1ec3_t\u1eeb_khi_c\u00e0i_\u0111\u1eb7t<\/td><td>days since install<\/td><td>3<\/td><\/tr><tr><td>n\u1ec1n t\u1ea3ng<\/td><td>n\u1ec1n t\u1ea3ng c\u1ee7a \u1ee9ng d\u1ee5ng<\/td><td>iOS hay Android<\/td><\/tr><tr><td>app_id<\/td><td>M\u00e3 ID Tenjin c\u1ee7a \u1ee9ng d\u1ee5ng<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>campaign_id<\/td><td>M\u00e3 ID Tenjin c\u1ee7a chi\u1ebfn d\u1ecbch<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>qu\u1ed1c gia<\/td><td>m\u00e3 qu\u1ed1c gia g\u1ed3m hai ch\u1eef c\u00e1i<\/td><td>Hoa K\u1ef3<\/td><\/tr><tr><td>site_id<\/td><td>M\u00e3 \u0111\u1ecbnh danh trang web<\/td><td>Instagram<\/td><\/tr><tr><td>s\u1ed1_ng\u01b0\u1eddi_d\u00f9ng_ho\u1ea1t_\u0111\u1ed9ng_h\u00e0ng_ng\u00e0y<\/td><td>s\u1ed1 l\u01b0\u1ee3ng thi\u1ebft b\u1ecb duy nh\u1ea5t \u0111\u01b0\u1ee3c ph\u00e1t hi\u1ec7n<\/td><td>105<\/td><\/tr><tr><td>bu\u1ed5i h\u1ecdc<\/td><td>s\u1ed1 l\u1ea7n \u1ee9ng d\u1ee5ng \u0111\u01b0\u1ee3c m\u1edf<\/td><td>23650<\/td><\/tr><tr><td>doanh thu iap<\/td><td>t\u1ed5ng doanh thu t\u1eeb mua h\u00e0ng trong \u1ee9ng d\u1ee5ng t\u00ednh b\u1eb1ng cent USD<\/td><td>245<\/td><\/tr><tr><td>doanh thu qu\u1ea3ng c\u00e1o t\u1eeb nh\u00e0 xu\u1ea5t b\u1ea3n<\/td><td>allocated sum of publisher ad revenue from ad network reporting API in USD cents<\/td><td>2000<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u1ed1i v\u1edbi reporting_cohort_metrics, h\u00e3y s\u1eed d\u1ee5ng c\u00e1c tr\u01b0\u1eddng install_date v\u00e0 days_since_install \u0111\u1ec3 l\u1ea5y c\u00e1c ch\u1ec9 s\u1ed1 nh\u01b0 tr\u00ean b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n. V\u00ed d\u1ee5:<\/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_m\u1ea1ng_qu\u1ea3ng_c\u00e1o<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Vui l\u00f2ng li\u00ean h\u1ec7 v\u1edbi Ng\u01b0\u1eddi qu\u1ea3n l\u00fd t\u00e0i kho\u1ea3n c\u1ee7a qu\u00fd kh\u00e1ch \u0111\u1ec3 truy c\u1eadp b\u1ea3ng n\u00e0y.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/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>id_m\u1ea1ng_qu\u1ea3ng_c\u00e1o<\/td><td>Integer Tenjin-specific ID for the ad network. Can be joined via ad_networks.id<\/td><td>5<\/td><\/tr><tr><td>c\u1eadp nh\u1eadt v\u00e0o<\/td><td>D\u1ea5u th\u1eddi gian cho bi\u1ebft th\u1eddi \u0111i\u1ec3m b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt l\u1ea7n cu\u1ed1i.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>D\u1ea5u th\u1eddi gian cho bi\u1ebft th\u1eddi \u0111i\u1ec3m b\u1ea3n ghi \u0111\u01b0\u1ee3c t\u1ea3i v\u00e0o DataVault l\u1ea7n cu\u1ed1i.<\/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\">Vui l\u00f2ng li\u00ean h\u1ec7 v\u1edbi Ng\u01b0\u1eddi qu\u1ea3n l\u00fd t\u00e0i kho\u1ea3n c\u1ee7a qu\u00fd kh\u00e1ch \u0111\u1ec3 truy c\u1eadp b\u1ea3ng n\u00e0y.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>ng\u00e0y<sup>(S)<\/sup><\/td><td>Ng\u00e0y nh\u1eadn \u0111\u01b0\u1ee3c ph\u1ea3n h\u1ed3i t\u1eeb SK Ad Network.<\/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>id_m\u1ea1ng_qu\u1ea3ng_c\u00e1o<\/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>M\u00e3 chi\u1ebfn d\u1ecbch SK, m\u1ed9t s\u1ed1 nguy\u00ean t\u1eeb 0 \u0111\u1ebfn 99.<\/td><td>10<\/td><\/tr><tr><td>campaign_id<\/td><td>UUID \u2013 M\u00e3 \u0111\u1ecbnh danh ri\u00eang c\u1ee7a Tenjin d\u00e0nh cho Chi\u1ebfn d\u1ecbch. C\u00f3 th\u1ec3 truy c\u1eadp th\u00f4ng qua campaigns.id<\/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>lo\u1ea1i \u0111\u1ed9 trung th\u1ef1c<\/td><td>1 d\u00e0nh cho qu\u1ea3ng c\u00e1o StoreKit, 0 d\u00e0nh cho qu\u1ea3ng c\u00e1o view-through.<\/td><td>1<\/td><\/tr><tr><td>gi\u00e1 tr\u1ecb chuy\u1ec3n \u0111\u1ed5i<\/td><td>Gi\u00e1 tr\u1ecb chuy\u1ec3n \u0111\u1ed5i, m\u1ed9t s\u1ed1 nguy\u00ean t\u1eeb 0 \u0111\u1ebfn 63.<\/td><td>33<\/td><\/tr><tr><td>s\u1ed1_gi\u00e1_tr\u1ecb_chuy\u1ec3n_\u0111\u1ed5i<\/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>s\u1ed1 l\u1ea7n t\u1ea3i l\u1ea1i<\/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>s\u1ed1_l\u1ea7n_h\u1ed7_tr\u1ee3<\/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>s\u1ed1_l\u1ea7n_h\u1ed7_tr\u1ee3_t\u1ea3i_l\u1ea1i<\/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>th\u1eddi gian t\u1ea3i<\/td><td>D\u1ea5u th\u1eddi gian cho bi\u1ebft th\u1eddi \u0111i\u1ec3m b\u1ea3n ghi \u0111\u01b0\u1ee3c t\u1ea3i v\u00e0o DataVault l\u1ea7n cu\u1ed1i.<\/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>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>ng\u00e0y<sup>(S)<\/sup><\/td><td>Ng\u00e0y nh\u1eadn \u0111\u01b0\u1ee3c ph\u1ea3n h\u1ed3i t\u1eeb SK Ad Network.<\/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>id_m\u1ea1ng_qu\u1ea3ng_c\u00e1o<\/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>M\u00e3 chi\u1ebfn d\u1ecbch SK, m\u1ed9t s\u1ed1 nguy\u00ean t\u1eeb 0 \u0111\u1ebfn 99.<\/td><td>10<\/td><\/tr><tr><td>campaign_id<\/td><td>UUID \u2013 M\u00e3 \u0111\u1ecbnh danh ri\u00eang c\u1ee7a Tenjin d\u00e0nh cho Chi\u1ebfn d\u1ecbch. Gi\u00e1 tr\u1ecb n\u00e0y lu\u00f4n l\u00e0 null, v\u00ec Apple kh\u00f4ng cung c\u1ea5p b\u1ea5t k\u1ef3 c\u00e1ch n\u00e0o \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb n\u00e0y.<\/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>lo\u1ea1i \u0111\u1ed9 trung th\u1ef1c<\/td><td>1 d\u00e0nh cho qu\u1ea3ng c\u00e1o StoreKit, 0 d\u00e0nh cho qu\u1ea3ng c\u00e1o view-through.<\/td><td>1<\/td><\/tr><tr><td>gi\u00e1 tr\u1ecb chuy\u1ec3n \u0111\u1ed5i<\/td><td>Gi\u00e1 tr\u1ecb chuy\u1ec3n \u0111\u1ed5i, m\u1ed9t s\u1ed1 nguy\u00ean t\u1eeb 0 \u0111\u1ebfn 63.<\/td><td>33<\/td><\/tr><tr><td>s\u1ed1_gi\u00e1_tr\u1ecb_chuy\u1ec3n_\u0111\u1ed5i<\/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>s\u1ed1 l\u1ea7n t\u1ea3i l\u1ea1i<\/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>s\u1ed1_l\u1ea7n_h\u1ed7_tr\u1ee3<\/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>s\u1ed1_l\u1ea7n_h\u1ed7_tr\u1ee3_t\u1ea3i_l\u1ea1i<\/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>th\u1eddi gian t\u1ea3i<\/td><td>D\u1ea5u th\u1eddi gian cho bi\u1ebft th\u1eddi \u0111i\u1ec3m b\u1ea3n ghi \u0111\u01b0\u1ee3c t\u1ea3i v\u00e0o DataVault l\u1ea7n cu\u1ed1i.<\/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\">c\u00e0i \u0111\u1eb7t<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>th\u1eddi_gi\u1edd_t\u1ea1o<\/td><td>d\u1ea5u th\u1eddi gian khi s\u1ef1 ki\u1ec7n \u0111\u01b0\u1ee3c t\u1ea1o ra<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>id_qu\u1ea3ng_c\u00e1o<\/td><td>IDFA \u0111\u1ed1i v\u1edbi iOS ho\u1eb7c ID qu\u1ea3ng c\u00e1o c\u1ee7a Google \u0111\u1ed1i v\u1edbi Android. Vi\u1ebft th\u01b0\u1eddng, kh\u00f4ng c\u00f3 d\u1ea5u g\u1ea1ch ngang<\/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>n\u1ec1n t\u1ea3ng<\/td><td>n\u1ec1n t\u1ea3ng c\u1ee7a \u1ee9ng d\u1ee5ng<\/td><td>iOS hay Android<\/td><\/tr><tr><td>os_version<\/td><td>phi\u00ean b\u1ea3n h\u1ec7 \u0111i\u1ec1u h\u00e0nh c\u1ee7a thi\u1ebft b\u1ecb<\/td><td>8.0<\/td><\/tr><tr><td>phi\u00ean b\u1ea3n \u1ee9ng d\u1ee5ng<\/td><td>phi\u00ean b\u1ea3n \u1ee9ng d\u1ee5ng<\/td><td>1.0.3<\/td><\/tr><tr><td>gi\u1edbi h\u1ea1n theo d\u00f5i qu\u1ea3ng c\u00e1o<\/td><td>gi\u1edbi h\u1ea1n theo d\u00f5i qu\u1ea3ng c\u00e1o c\u1ee7a ng\u01b0\u1eddi d\u00f9ng (0,1)<\/td><td>1<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">ID \u1ee9ng d\u1ee5ng n\u1ed9i b\u1ed9 c\u1ee7a Tenjin. ID n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi <code>id<\/code> trong b\u1ea3ng apps<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>ID chi\u1ebfn d\u1ecbch ngu\u1ed3n<\/td><td class=\"translation-block\">M\u00e3 chi\u1ebfn d\u1ecbch n\u1ed9i b\u1ed9 c\u1ee7a Tenjin d\u00e0nh cho ng\u01b0\u1eddi d\u00f9ng chi\u1ebfn d\u1ecbch \u0111\u01b0\u1ee3c g\u00e1n cho. M\u00e3 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi <code>id<\/code> trong b\u1ea3ng campaigns<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>ng\u00e0y_mua<\/td><td>d\u1ea5u th\u1eddi gian khi ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c thu h\u00fat<\/td><td>2018-10-01 00:00:00<\/td><\/tr><tr><td>qu\u1ed1c gia<\/td><td>m\u00e3 qu\u1ed1c gia<\/td><td>Hoa K\u1ef3<\/td><\/tr><tr><td>site_id<\/td><td>ID nh\u00e0 xu\u1ea5t b\u1ea3n c\u1ee7a chi\u1ebfn d\u1ecbch n\u1ebfu \u0111\u00f3 l\u00e0 chi\u1ebfn d\u1ecbch tr\u1ea3 ph\u00ed<\/td><td>Instagram<\/td><\/tr><tr><td>id_thi\u1ebft_b\u1ecb_nh\u00e0_ph\u00e1t_tri\u1ec3n<\/td><td>IDFV cho iOS. \u0110\u1ec3 tr\u1ed1ng cho Android. Vi\u1ebft th\u01b0\u1eddng, kh\u00f4ng c\u00f3 d\u1ea5u g\u1ea1ch ngang<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>uuid<\/td><td>ID s\u1ef1 ki\u1ec7n duy nh\u1ea5t<\/td><td>a3e3e535-a32c-4887-9c91-3160c91b3876<\/td><\/tr><tr><td>thi\u1ebft b\u1ecb<\/td><td>lo\u1ea1i thi\u1ebft b\u1ecb<\/td><td>iPad 2,5<\/td><\/tr><tr><td>t\u00ean_s\u00e1ng_t\u1ea1o<\/td><td>t\u00ean s\u00e1ng t\u1ea1o<\/td><td>test_creative<\/td><\/tr><tr><td>\u0111\u1ecba ch\u1ec9 IP<\/td><td>\u0111\u1ecba ch\u1ec9 IP c\u1ee7a ng\u01b0\u1eddi d\u00f9ng<\/td><td>71.165.85.114<\/td><\/tr><tr><td>source_uuid<\/td><td class=\"translation-block\">M\u00e3 UUID c\u1ee7a s\u1ef1 ki\u1ec7n nh\u1ea5p chu\u1ed9t ho\u1eb7c hi\u1ec3n th\u1ecb n\u1ebfu chi\u1ebfn d\u1ecbch l\u00e0 chi\u1ebfn d\u1ecbch tr\u1ea3 ph\u00ed. M\u00e3 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi <code>uuid<\/code> trong b\u1ea3ng ad_engagements<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/td><td>2018-10-01 00:00:00<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">s\u1ed1 nguy\u00ean bi\u1ec3u th\u1ecb <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">tr\u1ea1ng th\u00e1i ATT<\/a> c\u1ee7a thi\u1ebft b\u1ecb iOS. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; ch\u01b0a x\u00e1c \u0111\u1ecbnh, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; b\u1ecb h\u1ea1n ch\u1ebf, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; b\u1ecb t\u1eeb ch\u1ed1i, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; \u0111\u01b0\u1ee3c ph\u00e9p<\/td><td>3<\/td><\/tr><tr><td>m\u00e3_c\u00e0i_\u0111\u1eb7t_ph\u00e2n_t\u00edch<\/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\">xem tr\u01b0\u1edbc s\u1ed1 l\u1ea7n hi\u1ec3n th\u1ecb qua n\u1ec1n t\u1ea3ng trung gian qu\u1ea3ng c\u00e1o<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Vui l\u00f2ng li\u00ean h\u1ec7 v\u1edbi Qu\u1ea3n l\u00fd t\u00e0i kho\u1ea3n c\u1ee7a qu\u00fd kh\u00e1ch \u0111\u1ec3 truy c\u1eadp b\u1ea3ng n\u00e0y<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>ng\u00e0y_mua<\/td><td>d\u1ea5u th\u1eddi gian khi ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c thu h\u00fat<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>ad_mediation_ad_format<\/td><td>\u0110\u1ecbnh d\u1ea1ng c\u1ee7a \u0111\u01a1n v\u1ecb qu\u1ea3ng c\u00e1o<\/td><td>Banner<\/td><\/tr><tr><td>m\u1ea1ng l\u01b0\u1edbi trung gian qu\u1ea3ng c\u00e1o<\/td><td>M\u1ea1ng l\u01b0\u1edbi \u0111\u00e3 hi\u1ec3n th\u1ecb qu\u1ea3ng c\u00e1o \u0111\u00f3<\/td><td>Applovin<\/td><\/tr><tr><td>v\u1ecb tr\u00ed qu\u1ea3ng c\u00e1o qua n\u1ec1n t\u1ea3ng trung gian<\/td><td>V\u1ecb tr\u00ed \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi m\u1ea1ng<\/td><td>v\u1ecb_tr\u00ed_banner_c\u1ee7a_t\u00f4i<\/td><\/tr><tr><td>nh\u00e0 cung c\u1ea5p d\u1ecbch v\u1ee5 trung gian qu\u1ea3ng c\u00e1o<\/td><td>Nh\u00e0 cung c\u1ea5p d\u1ecbch v\u1ee5 qu\u1ea3ng c\u00e1o<\/td><td>Applovin MAX<\/td><\/tr><tr><td>doanh_thu_t\u1eeb_qu\u1ea3n_l\u00fd_qu\u1ea3ng_c\u00e1o_microcents<\/td><td>Doanh thu qu\u1ea3ng c\u00e1o t\u00ednh b\u1eb1ng microscent do nh\u00e0 cung c\u1ea5p d\u1ecbch v\u1ee5 trung gian cung c\u1ea5p<\/td><td>22000<\/td><\/tr><tr><td>id_qu\u1ea3ng_c\u00e1o<\/td><td>IDFA \u0111\u1ed1i v\u1edbi iOS ho\u1eb7c ID qu\u1ea3ng c\u00e1o c\u1ee7a Google \u0111\u1ed1i v\u1edbi Android. Vi\u1ebft th\u01b0\u1eddng, kh\u00f4ng c\u00f3 d\u1ea5u g\u1ea1ch ngang.<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>m\u00e3_c\u00e0i_\u0111\u1eb7t_ph\u00e2n_t\u00edch<\/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\">ID \u1ee9ng d\u1ee5ng n\u1ed9i b\u1ed9 c\u1ee7a Tenjin. ID n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u1edbi <code>id<\/code> trong b\u1ea3ng apps<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>phi\u00ean b\u1ea3n \u1ee9ng d\u1ee5ng<\/td><td>phi\u00ean b\u1ea3n \u1ee9ng d\u1ee5ng<\/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>qu\u1ed1c gia<\/td><td>m\u00e3 qu\u1ed1c gia<\/td><td>Hoa K\u1ef3<\/td><\/tr><tr><td>th\u1eddi_gi\u1edd_t\u1ea1o<\/td><td>d\u1ea5u th\u1eddi gian khi s\u1ef1 ki\u1ec7n \u0111\u01b0\u1ee3c t\u1ea1o ra<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>t\u00ean_s\u00e1ng_t\u1ea1o<\/td><td>t\u00ean s\u00e1ng t\u1ea1o<\/td><td>test_creative<\/td><\/tr><tr><td>id_kh\u00e1ch_h\u00e0ng_ng\u01b0\u1eddi_d\u00f9ng<\/td><td>ID ng\u01b0\u1eddi d\u00f9ng t\u1eeb \u1ee9ng d\u1ee5ng, \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp b\u1eb1ng ph\u01b0\u01a1ng th\u1ee9c setCustomerUserId c\u1ee7a SDK<\/td><td>jdabGcerT32_d<\/td><\/tr><tr><td>id_thi\u1ebft_b\u1ecb_nh\u00e0_ph\u00e1t_tri\u1ec3n<\/td><td>IDFV cho iOS. \u0110\u1ec3 tr\u1ed1ng cho Android. Vi\u1ebft th\u01b0\u1eddng, kh\u00f4ng c\u00f3 d\u1ea5u g\u1ea1ch ngang<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>thi\u1ebft b\u1ecb<\/td><td>lo\u1ea1i thi\u1ebft b\u1ecb<\/td><td>iPad 2.5<\/td><\/tr><tr><td>th\u1eddi \u0111i\u1ec3m b\u1eaft \u0111\u1ea7u<\/td><td>D\u1ea5u th\u1eddi gian c\u1ee7a s\u1ef1 ki\u1ec7n nh\u1ea5p chu\u1ed9t\/hi\u1ec3n th\u1ecb m\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 t\u01b0\u01a1ng t\u00e1c tr\u01b0\u1edbc khi \u0111\u01b0\u1ee3c thu h\u00fat<\/td><td>2018-01-01 00:00:00<\/td><\/tr><tr><td>\u0111\u1ecba ch\u1ec9 IP<\/td><td>\u0111\u1ecba ch\u1ec9 IP c\u1ee7a ng\u01b0\u1eddi d\u00f9ng<\/td><td>71.165.85.114<\/td><\/tr><tr><td>gi\u1edbi h\u1ea1n theo d\u00f5i qu\u1ea3ng c\u00e1o<\/td><td>Gi\u1edbi h\u1ea1n theo d\u00f5i qu\u1ea3ng c\u00e1o c\u1ee7a ng\u01b0\u1eddi d\u00f9ng<\/td><td>(0,1)<\/td><\/tr><tr><td>th\u1eddi gian t\u1ea3i<\/td><td>d\u1ea5u th\u1eddi gian khi b\u1ea3n ghi \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>os_version<\/td><td>phi\u00ean b\u1ea3n h\u1ec7 \u0111i\u1ec1u h\u00e0nh c\u1ee7a thi\u1ebft b\u1ecb<\/td><td>8.0<\/td><\/tr><tr><td>n\u1ec1n t\u1ea3ng<\/td><td>n\u1ec1n t\u1ea3ng c\u1ee7a \u1ee9ng d\u1ee5ng<\/td><td>8.0<\/td><\/tr><tr><td>phi\u00ean b\u1ea3n SDK<\/td><td>Phi\u00ean b\u1ea3n Tenjin SDK c\u1ee7a ng\u01b0\u1eddi d\u00f9ng<\/td><td>12.2.22<\/td><\/tr><tr><td>site_id<\/td><td>ID nh\u00e0 xu\u1ea5t b\u1ea3n c\u1ee7a chi\u1ebfn d\u1ecbch n\u1ebfu \u0111\u00f3 l\u00e0 chi\u1ebfn d\u1ecbch tr\u1ea3 ph\u00ed<\/td><td>Instagram<\/td><\/tr><tr><td>ID chi\u1ebfn d\u1ecbch ngu\u1ed3n<\/td><td class=\"translation-block\">M\u00e3 chi\u1ebfn d\u1ecbch n\u1ed9i b\u1ed9 c\u1ee7a Tenjin d\u00e0nh cho ng\u01b0\u1eddi d\u00f9ng chi\u1ebfn d\u1ecbch \u0111\u01b0\u1ee3c g\u00e1n cho. M\u00e3 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi <code>id<\/code> trong b\u1ea3ng campaigns<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>source_uuid<\/td><td>UUID c\u1ee7a s\u1ef1 ki\u1ec7n hi\u1ec3n th\u1ecb n\u1ebfu chi\u1ebfn d\u1ecbch l\u00e0 chi\u1ebfn d\u1ecbch tr\u1ea3 ph\u00ed. Gi\u00e1 tr\u1ecb n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c gh\u00e9p n\u1ed1i v\u1edbi UUID trong b\u1ea3ng `ad_engagements`<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">s\u1ed1 nguy\u00ean bi\u1ec3u th\u1ecb <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">tr\u1ea1ng th\u00e1i ATT<\/a> c\u1ee7a thi\u1ebft b\u1ecb iOS. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; ch\u01b0a x\u00e1c \u0111\u1ecbnh, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; b\u1ecb h\u1ea1n ch\u1ebf, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; b\u1ecb t\u1eeb ch\u1ed1i, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; \u0111\u01b0\u1ee3c ph\u00e9p<\/td><td>3<\/td><\/tr><tr><td>uuid<\/td><td class=\"translation-block\">M\u00e3 \u0111\u1ecbnh danh duy nh\u1ea5t (unique ID) c\u1ee7a s\u1ef1 ki\u1ec7n. M\u00e3 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi b\u1ea3ng s\u1ef1 ki\u1ec7n <code>source_uuid<\/code><\/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\">thu\u1ed9c t\u00ednh ng\u01b0\u1eddi d\u00f9ng <\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>C\u1ed9t<\/th><th>M\u00f4 t\u1ea3<\/th><th>Gi\u00e1 tr\u1ecb v\u00ed d\u1ee5<\/th><\/tr><\/thead><tbody><tr><td>id_qu\u1ea3ng_c\u00e1o<\/td><td>IDFA \u0111\u1ed1i v\u1edbi iOS ho\u1eb7c ID qu\u1ea3ng c\u00e1o c\u1ee7a Google \u0111\u1ed1i v\u1edbi Android. Vi\u1ebft th\u01b0\u1eddng, kh\u00f4ng c\u00f3 d\u1ea5u g\u1ea1ch ngang.<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>gi\u1edbi h\u1ea1n theo d\u00f5i qu\u1ea3ng c\u00e1o<\/td><td>gi\u1edbi h\u1ea1n theo d\u00f5i qu\u1ea3ng c\u00e1o c\u1ee7a ng\u01b0\u1eddi d\u00f9ng (0,1)<\/td><td>1<\/td><\/tr><tr><td>ng\u00e0y_mua<\/td><td>d\u1ea5u th\u1eddi gian khi ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c thu h\u00fat<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>qu\u1ed1c gia<\/td><td>m\u00e3 qu\u1ed1c gia<\/td><td>Hoa K\u1ef3<\/td><\/tr><tr><td>site_id<\/td><td>ID nh\u00e0 xu\u1ea5t b\u1ea3n c\u1ee7a chi\u1ebfn d\u1ecbch n\u1ebfu \u0111\u00f3 l\u00e0 chi\u1ebfn d\u1ecbch tr\u1ea3 ph\u00ed<\/td><td>Instagram<\/td><\/tr><tr><td>id_thi\u1ebft_b\u1ecb_nh\u00e0_ph\u00e1t_tri\u1ec3n<\/td><td>IDFV cho iOS. \u0110\u1ec3 tr\u1ed1ng cho Android. Vi\u1ebft th\u01b0\u1eddng, kh\u00f4ng c\u00f3 d\u1ea5u g\u1ea1ch ngang.<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>m\u00e3_c\u00e0i_\u0111\u1eb7t_ph\u00e2n_t\u00edch<\/td><td>Tenjin generated Application install-specific identifier. Lower case, without hyphen.<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><tr><td>ID chi\u1ebfn d\u1ecbch ngu\u1ed3n<\/td><td class=\"translation-block\">M\u00e3 chi\u1ebfn d\u1ecbch n\u1ed9i b\u1ed9 c\u1ee7a Tenjin d\u00e0nh cho ng\u01b0\u1eddi d\u00f9ng chi\u1ebfn d\u1ecbch \u0111\u01b0\u1ee3c g\u00e1n cho. M\u00e3 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi <code>id<\/code> trong b\u1ea3ng campaigns<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">s\u1ed1 nguy\u00ean bi\u1ec3u th\u1ecb <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">tr\u1ea1ng th\u00e1i ATT<\/a> c\u1ee7a thi\u1ebft b\u1ecb iOS. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; ch\u01b0a x\u00e1c \u0111\u1ecbnh, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; b\u1ecb h\u1ea1n ch\u1ebf, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; b\u1ecb t\u1eeb ch\u1ed1i, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; \u0111\u01b0\u1ee3c ph\u00e9p<\/td><td>3<\/td><\/tr><tr><td>l\u1ea7n cu\u1ed1i truy c\u1eadp<\/td><td>d\u1ea5u th\u1eddi gian ghi l\u1ea1i l\u1ea7n cu\u1ed1i c\u00f9ng ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c ph\u00e1t hi\u1ec7n<\/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\">Kho\u1ea3ng th\u1eddi gian xem l\u1ea1i<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">C\u00e1c b\u1ea3ng d\u1eef li\u1ec7u n\u00e0y c\u00f3 l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1ecbch s\u1eed h\u1ea1n ch\u1ebf, t\u00f9y thu\u1ed9c v\u00e0o kho\u1ea3ng th\u1eddi gian xem l\u1ea1i nh\u01b0 \u0111\u00e3 n\u00eau trong h\u1ee3p \u0111\u1ed3ng Tenjin c\u1ee7a qu\u00fd v\u1ecb. N\u1ebfu qu\u00fd v\u1ecb mu\u1ed1n bi\u1ebft kho\u1ea3ng th\u1eddi gian xem l\u1ea1i cho DataVault c\u1ee7a m\u00ecnh, vui l\u00f2ng li\u00ean h\u1ec7 v\u1edbi ng\u01b0\u1eddi qu\u1ea3n l\u00fd t\u00e0i kho\u1ea3n c\u1ee7a qu\u00fd v\u1ecb t\u1ea1i Tenjin.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>s\u1ef1 ki\u1ec7n<\/li>\n\n\n\n<li>s\u1ed1 l\u1ea7n t\u01b0\u01a1ng t\u00e1c qu\u1ea3ng c\u00e1o<\/li>\n\n\n\n<li>ch\u1ec9 s\u1ed1 b\u00e1o c\u00e1o<\/li>\n\n\n\n<li>ch\u1ec9 s\u1ed1 nh\u00f3m \u0111\u1ed1i t\u01b0\u1ee3ng b\u00e1o c\u00e1o<\/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":"Anurag","author_nicename":"anurag","author_url":"https:\/\/tenjin.com\/vi\/blog\/author\/anurag\/"},"doc_category_info":[{"term_name":"DataVault","term_url":"https:\/\/tenjin.com\/vi\/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\/vi\/docs\/datavault-schema-and-tables\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\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\/vi\/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=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data1\" content=\"14 ph\u00fat\" \/>\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\":\"vi\"},{\"@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\":\"vi\",\"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\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/#organization\",\"name\":\"Tenjin\",\"url\":\"https:\\\/\\\/tenjin.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@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\":\"vi\",\"@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\\\/vi\\\/blog\\\/author\\\/anurag\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u1ea5u tr\u00fac v\u00e0 b\u1ea3ng c\u1ee7a DataVault | Tenjin","description":"C\u1ea5u tr\u00fac DataVault c\u1ee7a Tenjin ch\u00ednh l\u00e0 y\u1ebfu t\u1ed1 c\u1ed1t l\u00f5i t\u1ea1o n\u00ean \u201cb\u00ed quy\u1ebft\u201d c\u1ee7a n\u00f3. T\u1ea5t c\u1ea3 th\u00f4ng tin t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau \u0111\u1ec1u \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i m\u1ed9t c\u00e1ch m\u1ea1ch l\u1ea1c th\u00f4ng qua c\u00e1c m\u00e3 \u0111\u1ecbnh danh (ID).","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\/vi\/docs\/datavault-schema-and-tables\/","og_locale":"vi_VN","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\/vi\/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":{"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"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":"vi"},{"@type":"WebPage","@id":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/","url":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/","name":"C\u1ea5u tr\u00fac v\u00e0 b\u1ea3ng c\u1ee7a DataVault | Tenjin","isPartOf":{"@id":"https:\/\/tenjin.com\/#website"},"datePublished":"2026-02-20T07:06:12+00:00","dateModified":"2026-06-15T10:28:30+00:00","description":"C\u1ea5u tr\u00fac DataVault c\u1ee7a Tenjin ch\u00ednh l\u00e0 y\u1ebfu t\u1ed1 c\u1ed1t l\u00f5i t\u1ea1o n\u00ean \u201cb\u00ed quy\u1ebft\u201d c\u1ee7a n\u00f3. T\u1ea5t c\u1ea3 th\u00f4ng tin t\u1eeb nhi\u1ec1u ngu\u1ed3n kh\u00e1c nhau \u0111\u1ec1u \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i m\u1ed9t c\u00e1ch m\u1ea1ch l\u1ea1c th\u00f4ng qua c\u00e1c m\u00e3 \u0111\u1ecbnh danh (ID).","breadcrumb":{"@id":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/#breadcrumb"},"inLanguage":"vi","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":"Th\u1ea7n Tenjin","description":"Ph\u00e1t tri\u1ec3n \u0111\u01a1n gi\u1ea3n","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":"vi"},{"@type":"Organization","@id":"https:\/\/tenjin.com\/#organization","name":"Th\u1ea7n Tenjin","url":"https:\/\/tenjin.com\/","logo":{"@type":"ImageObject","inLanguage":"vi","@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":"vi","@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\/vi\/blog\/author\/anurag\/"}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/docs\/15474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/comments?post=15474"}],"version-history":[{"count":5,"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/docs\/15474\/revisions"}],"predecessor-version":[{"id":16790,"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/docs\/15474\/revisions\/16790"}],"wp:attachment":[{"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/media?parent=15474"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/doc_category?post=15474"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/glossaries?post=15474"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/tenjin.com\/vi\/wp-json\/wp\/v2\/doc_tag?post=15474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}