{"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\/pt\/docs\/datavault-schema-and-tables\/","title":{"rendered":"Esquema e tabelas do DataVault"},"content":{"rendered":"<p class=\"wp-block-paragraph translation-block\">O esquema DataVault do Tenjin est\u00e1 no cerne do seu segredo. Toda a informa\u00e7\u00e3o proveniente de v\u00e1rias fontes \u00e9 perfeitamente integrada atrav\u00e9s de <code>id<\/code>s. Com a informa\u00e7\u00e3o organizada desta forma, o DataVault facilita a cria\u00e7\u00e3o de modelos e an\u00e1lises de forma determin\u00edstica.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Lista de tabelas<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#0\" style=\"text-decoration:none\">eventos<\/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\">campanhas<\/a>\n<ul class=\"wp-block-list\">\n<li>campanhas \u00e0s quais os utilizadores s\u00e3o atribu\u00eddos, ou campanhas provenientes da API das redes de publicidade<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#3\" style=\"text-decoration:none\">redes de publicidade<\/a>\n<ul class=\"wp-block-list\">\n<li>lista de redes de publicidade<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#4\" style=\"text-decoration:none\">aplica\u00e7\u00f5es<\/a>\n<ul class=\"wp-block-list\">\n<li>lista de aplica\u00e7\u00f5es<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#5\" style=\"text-decoration:none\">despesas_di\u00e1rias_por_pa\u00eds<\/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=\"\/pt\/v1\/#6\" style=\"text-decoration:none\">aplica\u00e7\u00f5es de editores<\/a>\n<ul class=\"wp-block-list\">\n<li>campanhas de editores que recebemos atrav\u00e9s da API da rede de publicidade<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#7\" style=\"text-decoration:none\">receitas_di\u00e1rias_de_publicidade<\/a>\n<ul class=\"wp-block-list\">\n<li>inclui dados sobre receitas publicit\u00e1rias por campanhas dos editores, data e pa\u00eds<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#8\" style=\"text-decoration:none\">ad_engagements<\/a>\n<ul class=\"wp-block-list\">\n<li>inclui dados de cliques ou impress\u00f5es para cada dispositivo. Apenas cont\u00e9m dados relativos a redes publicit\u00e1rias que n\u00e3o atribuem a si pr\u00f3prias os cliques. Nota: esta tabela n\u00e3o est\u00e1 ativada por predefini\u00e7\u00e3o; por favor, contacte o seu gestor de conta da Tenjin se pretender utiliz\u00e1-la.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#11\" style=\"text-decoration:none\">m\u00e9tricas_de_relat\u00f3rios<\/a>\n<ul class=\"wp-block-list\">\n<li>inclui todas as m\u00e9tricas n\u00e3o agrupadas por coorte que s\u00e3o sincronizadas com os dados do painel<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#12\" style=\"text-decoration:none\">relat\u00f3rios_de_m\u00e9tricas_da_coorte<\/a>\n<ul class=\"wp-block-list\">\n<li>inclui todas as m\u00e9tricas agrupadas por coorte que est\u00e3o sincronizadas com os dados do painel de controlo<\/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>Um mapeamento dos IDs da SK Ad Network para os IDs espec\u00edficos da Tenjin para redes de publicidade.<\/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\">As colunas s\u00e3o as mesmas que as de <code>sk_ad_network_metrics<\/code>. No entanto, <code>campaign_id<\/code> \u00e9 sempre <code>null<\/code>, devido a limita\u00e7\u00f5es nos dados recebidos da Apple.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#17\" style=\"text-decoration:none\">instala<\/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>As suas receitas publicit\u00e1rias ao n\u00edvel da impress\u00e3o provenientes do fornecedor de media\u00e7\u00e3o. Nota: esta tabela n\u00e3o est\u00e1 ativada por predefini\u00e7\u00e3o; se pretender utiliz\u00e1-la, contacte o seu gestor de conta da Tenjin.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#19\" style=\"text-decoration:none\">atributos_do_utilizador<\/a>\n<ul class=\"wp-block-list\">\n<li>inclui os atributos do utilizador<\/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\">Lista de campos da tabela<\/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): Chave de ordena\u00e7\u00e3o <br>(D): Chave de Dist<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"0\">eventos<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>created_at <sup>(S)<\/sup><\/td><td>data e hora em que o evento foi criado<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>id_publicit\u00e1rio<\/td><td>IDFA para iOS ou ID de publicidade do Google para Android. Em min\u00fasculas, sem h\u00edfen.<\/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>plataforma<\/td><td>plataforma da aplica\u00e7\u00e3o<\/td><td>iOS ou Android<\/td><\/tr><tr><td>os_version<\/td><td>vers\u00e3o do sistema operativo do dispositivo<\/td><td>8.0<\/td><\/tr><tr><td>app_version<\/td><td>vers\u00e3o da aplica\u00e7\u00e3o<\/td><td>1.0.3<\/td><\/tr><tr><td>limitar_o_rastreio_de_publicidade<\/td><td>limite de rastreamento de an\u00fancios do utilizador (0,1)<\/td><td>1<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">ID interno da aplica\u00e7\u00e3o do Tenjin. Pode ser associado a <code>id<\/code> na tabela de aplica\u00e7\u00f5es<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>tipo_de_evento<\/td><td class=\"translation-block\">ou <code>evento<\/code> ou <code>compra<\/code><\/td><td>evento<\/td><\/tr><tr><td>evento<\/td><td class=\"translation-block\">Quando event_type = <code>event<\/code>, este valor \u00e9 <code>open<\/code> ou um nome de evento personalizado.<\/td><td>abrir<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">O ID interno da campanha da Tenjin \u00e9 atribu\u00eddo ao utilizador da campanha. Pode ser associado a <code>id<\/code> na tabela \u00abcampaigns\u00bb<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>adquirido_em<\/td><td>data e hora em que o utilizador foi registado<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>pre\u00e7o<\/td><td>pre\u00e7o de compra bruto relativo \u00e0 transa\u00e7\u00e3o de compra<\/td><td>1.99<\/td><\/tr><tr><td>quantidade<\/td><td>quantidade de compra para o evento de compra<\/td><td>2<\/td><\/tr><tr><td>product_id<\/td><td>ID do produto para o evento de compra<\/td><td>com.tenjin.wordfinder.package50<\/td><\/tr><tr><td>moeda<\/td><td>c\u00f3digo da moeda para a transa\u00e7\u00e3o de compra<\/td><td>USD<\/td><\/tr><tr><td>pa\u00eds<\/td><td>c\u00f3digo do pa\u00eds<\/td><td>EUA<\/td><\/tr><tr><td>receita_total<\/td><td class=\"translation-block\">receita bruta do evento de compra em USD <strong>c\u00eantimos<\/strong><\/td><td>350<\/td><\/tr><tr><td>receitas<\/td><td class=\"translation-block\">receita l\u00edquida do evento de compra em USD <strong>c\u00eantimos<\/strong><\/td><td>245<\/td><\/tr><tr><td>site_id<\/td><td>ID do editor da campanha, caso se trate de uma campanha paga<\/td><td>Instagram<\/td><\/tr><tr><td>identificador_do_dispositivo_do_desenvolvedor<\/td><td>IDFV para iOS. Em branco para Android. Min\u00fasculas, sem h\u00edfen.<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>estado_da_compra<\/td><td><ul><li>0: Desconhecido \u2013 n\u00e3o foi recebido qualquer recibo aquando da compra<\/li><li>1: N\u00e3o verificado \u2013 foi apresentado um recibo, mas n\u00e3o foi poss\u00edvel verific\u00e1-lo<\/li><li>2: Fraudulento \u2013 foi apresentado um recibo fraudulento<\/li><li>3: Verificado \u2013 o recibo foi verificado com sucesso<\/li><li>4: Sandbox \u2013 o recibo foi verificado no ambiente de teste<\/li><li>5: Duplicado \u2013 o recibo j\u00e1 tinha sido recebido numa compra anterior<\/li><li>6: Desatualizado \u2013 a compra ocorreu h\u00e1 3 dias e n\u00e3o em tempo real<\/li><\/ul><\/td><td>3<\/td><\/tr><tr><td>valor<\/td><td>Valor de evento personalizado<\/td><td>1<\/td><\/tr><tr><td>uuid<\/td><td>ID \u00fanico do evento<\/td><td>a3e3e535-a32c-4887-9c91-3160c91b3876<\/td><\/tr><tr><td>dispositivo<\/td><td>tipo de dispositivo<\/td><td>iPad 2,5<\/td><\/tr><tr><td>nome_criativo<\/td><td>nome criativo<\/td><td>test_creative<\/td><\/tr><tr><td>endere\u00e7o_IP<\/td><td>endere\u00e7o IP do utilizador<\/td><td>71.165.85.114<\/td><\/tr><tr><td>source_uuid<\/td><td class=\"translation-block\">UUID do evento de clique ou impress\u00e3o, caso a campanha tenha sido paga. Pode ser associado a <code>uuid<\/code> na tabela ad_engagements<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>loaded_at<\/td><td>carimbo de data e hora em que o registo \u00e9 atualizado no DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>estado_do_rastreio<\/td><td class=\"translation-block\">n\u00famero inteiro para o <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">estado ATT<\/a> do dispositivo iOS. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; n\u00e3o determinado, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; restrito, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; recusado, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; autorizado<\/td><td>3<\/td><\/tr><tr><td>analytics_installation_id<\/td><td>Tenjin generated Application install-specific identifier. Lower case, without hyphen.<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><tr><td>customer_user_id<\/td><td>ID do utilizador da aplica\u00e7\u00e3o, tal como definido pelo m\u00e9todo setCustomerUserId do 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\">campanhas<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>ID \u00fanico da campanha<\/td><td>3b70e477-c151-4167-9174-cca6ffa2c7bc<\/td><\/tr><tr><td>nome<\/td><td>nome da campanha<\/td><td>teste @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\">ID interno da aplica\u00e7\u00e3o do Tenjin. Pode ser associado a <code>id<\/code> na tabela de aplica\u00e7\u00f5es<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>remote_campaign_id<\/td><td>campaign_id utilizado pela rede de publicidade. Obtemos este valor atrav\u00e9s da API de relat\u00f3rios da rede de publicidade.<\/td><td>6026825090762<\/td><\/tr><tr><td>campaign_bucket_id<\/td><td class=\"translation-block\">ID do bucket da campanha para as campanhas do bucket. Isto pode ser associado a <code>id<\/code> na tabela campaign_buckets<\/td><td>fbbc74bd-8a73-472a-86f7-5e2a4642a201<\/td><\/tr><tr><td>atualizado_em<\/td><td>data e hora em que o registo \u00e9 atualizado na base de dados do Tenjin<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>carimbo de data e hora em que o registo \u00e9 atualizado no 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\">redes de publicidade<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>id <sup>(S)<\/sup><\/td><td>ID \u00fanico para a rede de publicidade<\/td><td>3<\/td><\/tr><tr><td>nome<\/td><td>ad network name<\/td><td>Facebook<\/td><\/tr><tr><td>atualizado_em<\/td><td>data e hora em que o registo \u00e9 atualizado na base de dados do 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\">aplica\u00e7\u00f5es<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>ID \u00fanico da aplica\u00e7\u00e3o<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>nome<\/td><td>nome da aplica\u00e7\u00e3o<\/td><td>Ca\u00e7a-palavras<\/td><\/tr><tr><td>store_id<\/td><td>ID da aplica\u00e7\u00e3o na loja<\/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>plataforma<\/td><td>plataforma da aplica\u00e7\u00e3o<\/td><td>iOS ou Android<\/td><\/tr><tr><td>atualizado_em<\/td><td>data e hora em que o registo \u00e9 atualizado na base de dados do Tenjin<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>carimbo de data e hora em que o registo \u00e9 atualizado no 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\">despesas_di\u00e1rias_por_pa\u00eds<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>identificador \u00fanico para os dados de despesas<\/td><td>174491158<\/td><\/tr><tr><td>data <sup>(S)<\/sup><\/td><td>data em que a despesa ocorre<\/td><td>2018-07-01<\/td><\/tr><tr><td>pa\u00eds<\/td><td>pa\u00eds onde a despesa \u00e9 efetuada<\/td><td>EUA<\/td><\/tr><tr><td>campaign_id <sup>(D)<\/sup><\/td><td class=\"translation-block\">ID da campanha. Este pode ser associado a <code>id<\/code> na tabela de campanhas<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>gastar<\/td><td>ad spend amount in USD cents.<\/td><td>400<\/td><\/tr><tr><td>instala<\/td><td>n\u00famero de instala\u00e7\u00f5es registadas<\/td><td>8<\/td><\/tr><tr><td>cliques<\/td><td>n\u00famero de cliques registados<\/td><td>10<\/td><\/tr><tr><td>impress\u00f5es<\/td><td>n\u00famero de impress\u00f5es registadas<\/td><td>126<\/td><\/tr><tr><td>despesa_original<\/td><td>ad spend amount in original currency<\/td><td>4<\/td><\/tr><tr><td>moeda_original<\/td><td>moeda original<\/td><td>USD<\/td><\/tr><tr><td>atualizado_em<\/td><td>data e hora em que o registo \u00e9 atualizado na base de dados do Tenjin<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>carimbo de data e hora em que o registo \u00e9 atualizado no DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>pa\u00eds_ausente<\/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\">aplica\u00e7\u00f5es de editores<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>ID \u00fanico da aplica\u00e7\u00e3o do editor<\/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\">ID interno da aplica\u00e7\u00e3o do Tenjin. Pode ser associado a <code>id<\/code> na tabela de aplica\u00e7\u00f5es<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>nome<\/td><td>nome da campanha da editora<\/td><td>Ca\u00e7a-palavras! Gr\u00e1tis - iOS - Tapjoy<\/td><\/tr><tr><td>atualizado_em<\/td><td>data e hora em que o registo \u00e9 atualizado na base de dados do Tenjin<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>carimbo de data e hora em que o registo \u00e9 atualizado no 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\">receitas_di\u00e1rias_de_publicidade<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>ID \u00fanico para as receitas publicit\u00e1rias<\/td><td>107852371<\/td><\/tr><tr><td>data <sup>(S)<\/sup><\/td><td>data em que a receita publicit\u00e1ria \u00e9 gerada<\/td><td>2018-07-01<\/td><\/tr><tr><td>publisher_app_id <sup>(D)<\/sup><\/td><td class=\"translation-block\">ID da campanha do editor. Este pode ser associado a <code>id<\/code> na tabela publisher_apps<\/td><td>b71ff0ab-f1b4-4ca6-98fc-0064a5b9d1d7<\/td><\/tr><tr><td>pa\u00eds<\/td><td>pa\u00eds para os indicadores<\/td><td>EUA<\/td><\/tr><tr><td>receitas<\/td><td>montante das receitas publicit\u00e1rias em c\u00eantimos de USD<\/td><td>20000<\/td><\/tr><tr><td>convers\u00f5es<\/td><td>n\u00famero de convers\u00f5es registadas<\/td><td>8<\/td><\/tr><tr><td>cliques<\/td><td>n\u00famero de cliques registados<\/td><td>10<\/td><\/tr><tr><td>impress\u00f5es<\/td><td>n\u00famero de impress\u00f5es registadas<\/td><td>126<\/td><\/tr><tr><td>receitas_intersticiais<\/td><td>ad revenue amount in USD cents for interstitial ads<\/td><td>20000<\/td><\/tr><tr><td>convers\u00f5es_intersticiais<\/td><td>number of conversions reported for interstitial ads<\/td><td>8<\/td><\/tr><tr><td>cliques_intersticiais<\/td><td>number of clicks reported for interstitial ads<\/td><td>10<\/td><\/tr><tr><td>impress\u00f5es_intersticiais<\/td><td>number of impressions reported for interstitial ads<\/td><td>126<\/td><\/tr><tr><td>banner_receitas<\/td><td>valor das receitas publicit\u00e1rias em c\u00eantimos de USD para banners publicit\u00e1rios<\/td><td>20000<\/td><\/tr><tr><td>convers\u00f5es_de_banners<\/td><td>n\u00famero de convers\u00f5es registadas para os an\u00fancios em banner<\/td><td>8<\/td><\/tr><tr><td>cliques_no_banner<\/td><td>n\u00famero de cliques registados para os an\u00fancios em banner<\/td><td>10<\/td><\/tr><tr><td>impress\u00f5es de banners<\/td><td>n\u00famero de impress\u00f5es registadas para os an\u00fancios em banner<\/td><td>126<\/td><\/tr><tr><td>receitas_nacionais<\/td><td>valor das receitas publicit\u00e1rias em c\u00eantimos de USD para an\u00fancios nativos<\/td><td>20000<\/td><\/tr><tr><td>convers\u00f5es_nativas<\/td><td>n\u00famero de convers\u00f5es registadas para an\u00fancios nativos<\/td><td>8<\/td><\/tr><tr><td>cliques_nativos<\/td><td>n\u00famero de cliques registados para an\u00fancios nativos<\/td><td>10<\/td><\/tr><tr><td>impress\u00f5es_nativas<\/td><td>n\u00famero de impress\u00f5es registadas para an\u00fancios nativos<\/td><td>126<\/td><\/tr><tr><td>receitas_do_offerwall<\/td><td>montante das receitas publicit\u00e1rias em c\u00eantimos de USD para an\u00fancios do Offerwall<\/td><td>20000<\/td><\/tr><tr><td>convers\u00f5es_do_offerwall<\/td><td>n\u00famero de convers\u00f5es registadas para os an\u00fancios do Offerwall<\/td><td>8<\/td><\/tr><tr><td>offerwall_clicks<\/td><td>n\u00famero de cliques registados para os an\u00fancios do Offerwall<\/td><td>10<\/td><\/tr><tr><td>impress\u00f5es do Offerwall<\/td><td>n\u00famero de impress\u00f5es registadas para os an\u00fancios do Offerwall<\/td><td>126<\/td><\/tr><tr><td>receitas_de_v\u00eddeo<\/td><td>valor das receitas publicit\u00e1rias em c\u00eantimos de USD para an\u00fancios em v\u00eddeo<\/td><td>20000<\/td><\/tr><tr><td>convers\u00f5es_de_v\u00eddeo<\/td><td>n\u00famero de convers\u00f5es registadas para an\u00fancios em v\u00eddeo<\/td><td>8<\/td><\/tr><tr><td>cliques_em_v\u00eddeos<\/td><td>n\u00famero de cliques registados para an\u00fancios em v\u00eddeo<\/td><td>10<\/td><\/tr><tr><td>impress\u00f5es de v\u00eddeo<\/td><td>n\u00famero de impress\u00f5es registadas para an\u00fancios em v\u00eddeo<\/td><td>126<\/td><\/tr><tr><td>outras_receitas<\/td><td>valor das receitas publicit\u00e1rias em c\u00eantimos de USD para outros an\u00fancios<\/td><td>20000<\/td><\/tr><tr><td>outras_convers\u00f5es<\/td><td>n\u00famero de convers\u00f5es registadas para outros an\u00fancios<\/td><td>8<\/td><\/tr><tr><td>outros_cliques<\/td><td>n\u00famero de cliques registados para outros an\u00fancios<\/td><td>10<\/td><\/tr><tr><td>outras_impress\u00f5es<\/td><td>n\u00famero de impress\u00f5es registadas para outros an\u00fancios<\/td><td>126<\/td><\/tr><tr><td>atualizado_em<\/td><td>data e hora em que o registo \u00e9 atualizado na base de dados do Tenjin<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>carimbo de data e hora em que o registo \u00e9 atualizado no 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\">ad_engagements<\/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>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>created_at <sup>(S)<\/sup><\/td><td>data e hora em que o evento foi criado<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>id_publicit\u00e1rio<\/td><td>IDFA para iOS ou ID de publicidade do Google para Android. Em min\u00fasculas, sem h\u00edfen.<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>atribu\u00edvel<\/td><td class=\"translation-block\">if the click\/impression is used for attribution or not. <code>true<\/code> or <code>false<\/code><\/td><td>verdadeiro<\/td><\/tr><tr><td>tipo_de_evento<\/td><td class=\"translation-block\">ou <code>cliques<\/code> ou <code>impress\u00f5es<\/code><\/td><td>cliques<\/td><\/tr><tr><td>campaign_id<\/td><td class=\"translation-block\">ID da campanha. Este pode ser associado a <code>id<\/code> na tabela de campanhas<\/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>plataforma<\/td><td>plataforma da aplica\u00e7\u00e3o<\/td><td>iOS ou Android<\/td><\/tr><tr><td>endere\u00e7o_IP<\/td><td>endere\u00e7o IP do utilizador<\/td><td>71.165.85.114<\/td><\/tr><tr><td>limitar_o_rastreio_de_publicidade<\/td><td>limite de rastreamento de an\u00fancios do utilizador<\/td><td>(0,1)<\/td><\/tr><tr><td>uuid<\/td><td class=\"translation-block\">ID \u00fanico do evento. Pode ser associado \u00e0 tabela de eventos <code>source_uuid<\/code><\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">ID interno da aplica\u00e7\u00e3o do Tenjin. Pode ser associado a <code>id<\/code> na tabela de aplica\u00e7\u00f5es<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>pa\u00eds<\/td><td>c\u00f3digo do pa\u00eds<\/td><td>EUA<\/td><\/tr><tr><td>site_id<\/td><td>ID do editor da campanha, caso se trate de uma campanha paga<\/td><td>Instagram<\/td><\/tr><tr><td>user_agent<\/td><td>Agente do utilizador<\/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>O ID da rede de publicidade \u00e9 transmitido atrav\u00e9s do URL do clique.<\/td><td>DSGfaa<\/td><\/tr><tr><td>loaded_at<\/td><td>carimbo de data e hora em que o registo \u00e9 atualizado no DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>estado_do_rastreio<\/td><td class=\"translation-block\">n\u00famero inteiro para o <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">estado ATT<\/a> do dispositivo iOS. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; n\u00e3o determinado, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; restrito, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; recusado, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; autorizado<\/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\">m\u00e9tricas_de_relat\u00f3rios<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>data <sup>(S)<\/sup><\/td><td>data a que a m\u00e9trica se aplica<\/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>plataforma<\/td><td>plataforma da aplica\u00e7\u00e3o<\/td><td>iOS ou Android<\/td><\/tr><tr><td>app_id<\/td><td>ID Tenjin da aplica\u00e7\u00e3o<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>campaign_id<\/td><td>ID Tenjin da campanha<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>pa\u00eds<\/td><td>c\u00f3digo de pa\u00eds de duas letras<\/td><td>EUA<\/td><\/tr><tr><td>site_id<\/td><td>ID do local<\/td><td>Instagram<\/td><\/tr><tr><td>utilizadores_ativos_di\u00e1rios<\/td><td>dispositivos \u00fanicos detetados<\/td><td>105<\/td><\/tr><tr><td>sess\u00f5es<\/td><td>contagem de eventos de abertura da aplica\u00e7\u00e3o<\/td><td>23650<\/td><\/tr><tr><td>iap_receitas<\/td><td>total das receitas provenientes de compras na aplica\u00e7\u00e3o, em c\u00eantimos de d\u00f3lar americano<\/td><td>245<\/td><\/tr><tr><td>despesas_declaradas<\/td><td>allocated spend from ad network reporting APIs in cents<\/td><td>5323<\/td><\/tr><tr><td>impress\u00f5es registadas<\/td><td>allocated impressions from ad network reporting APIs<\/td><td>13000<\/td><\/tr><tr><td>cliques_registados<\/td><td>allocated clicks from ad network reporting APIs<\/td><td>3000<\/td><\/tr><tr><td>instala\u00e7\u00f5es_registadas<\/td><td>allocated installs from ad network reporting APIs<\/td><td>4000<\/td><\/tr><tr><td>receitas_publicit\u00e1rias_do_editor<\/td><td>allocated sum of publisher ad revenue from ad network reporting API in USD cents<\/td><td>2000<\/td><\/tr><tr><td>impress\u00f5es_rastreadas<\/td><td>count of impressions tracked by Tenjin attribution<\/td><td>13000<\/td><\/tr><tr><td>cliques_rastreados<\/td><td>count of clicks tracked by Tenjin attribution<\/td><td>4000<\/td><\/tr><tr><td>instala\u00e7\u00f5es_rastreadas<\/td><td>count of installs tracked by Tenjin attribution<\/td><td>3000<\/td><\/tr><tr><td>loaded_at<\/td><td>carimbo de data e hora em que o registo \u00e9 atualizado no 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\">relat\u00f3rios_de_m\u00e9tricas_da_coorte<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>data_do_evento <sup>(S)<\/sup><\/td><td>data da coorte atual a que as m\u00e9tricas se aplicam<\/td><td>2018-11-01<\/td><\/tr><tr><td>data_de_instala\u00e7\u00e3o<\/td><td>date of the install<\/td><td>2018-10-01<\/td><\/tr><tr><td>dias_desde_a_instala\u00e7\u00e3o<\/td><td>days since install<\/td><td>3<\/td><\/tr><tr><td>plataforma<\/td><td>plataforma da aplica\u00e7\u00e3o<\/td><td>iOS ou Android<\/td><\/tr><tr><td>app_id<\/td><td>ID Tenjin da aplica\u00e7\u00e3o<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>campaign_id<\/td><td>ID Tenjin da campanha<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>pa\u00eds<\/td><td>c\u00f3digo de pa\u00eds de duas letras<\/td><td>EUA<\/td><\/tr><tr><td>site_id<\/td><td>ID do local<\/td><td>Instagram<\/td><\/tr><tr><td>utilizadores_ativos_di\u00e1rios<\/td><td>dispositivos \u00fanicos detetados<\/td><td>105<\/td><\/tr><tr><td>sess\u00f5es<\/td><td>contagem de eventos de abertura da aplica\u00e7\u00e3o<\/td><td>23650<\/td><\/tr><tr><td>iap_receitas<\/td><td>total das receitas provenientes de compras na aplica\u00e7\u00e3o, em c\u00eantimos de d\u00f3lar americano<\/td><td>245<\/td><\/tr><tr><td>receitas_publicit\u00e1rias_do_editor<\/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>carimbo de data e hora em que o registo \u00e9 atualizado no DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Para o reporting_cohort_metrics, utilize o install_date e o days_since_install para obter as m\u00e9tricas tal como no painel de controlo. Ex.:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\" data-no-translation=\"\" data-no-auto-translation=\"\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#39404f;color:#c8d0e0\">Plaintext<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\" data-no-translation=\"\" data-no-auto-translation=\"\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT install_date AS DATE, apps.name as app_name, ad_networks.name as ad_network, country, SUM(CASE WHEN days_since_install <= 1 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d1_total_LTV, SUM(CASE WHEN days_since_install <= 2 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d2_total_LTV, SUM(CASE WHEN days_since_install <= 3 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d3_total_LTV, SUM(CASE WHEN days_since_install = 1 THEN daily_active_users ELSE 0 END) AS d1_retained_users, SUM(CASE WHEN days_since_install = 2 THEN daily_active_users ELSE 0 END) AS d2_retained_users, SUM(CASE WHEN days_since_install = 3 THEN daily_active_users ELSE 0 END) AS d3_retained_users FROM reporting_cohort_metrics LEFT JOIN apps ON apps.id = reporting_cohort_metrics.app_id LEFT JOIN bucket_campaign_info ON bucket_campaign_info.id = reporting_cohort_metrics.campaign_id LEFT JOIN ad_networks ON ad_networks.id = bucket_campaign_info.ad_network_id WHERE install_date = '2018-10-11' GROUP BY 1, 2, 3, 4 LIMIT 10 <\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewbox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\" data-no-translation=\"\" data-no-auto-translation=\"\"><code data-no-translation=\"\" data-no-auto-translation=\"\"><span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT install_date AS DATE, apps.name as app_name, ad_networks.name as ad_network, country, SUM(CASE WHEN days_since_install <= 1 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d1_total_LTV, SUM(CASE WHEN days_since_install <= 2 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d2_total_LTV, SUM(CASE WHEN days_since_install <= 3 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d3_total_LTV, SUM(CASE WHEN days_since_install = 1 THEN daily_active_users ELSE 0 END) AS d1_retained_users, SUM(CASE WHEN days_since_install = 2 THEN daily_active_users ELSE 0 END) AS d2_retained_users, SUM(CASE WHEN days_since_install = 3 THEN daily_active_users ELSE 0 END) AS d3_retained_users FROM reporting_cohort_metrics LEFT JOIN apps ON apps.id = reporting_cohort_metrics.app_id LEFT JOIN bucket_campaign_info ON bucket_campaign_info.id = reporting_cohort_metrics.campaign_id LEFT JOIN ad_networks ON ad_networks.id = bucket_campaign_info.ad_network_id WHERE install_date = &#39;2018-10-11&#39; GROUP BY 1, 2, 3, 4 LIMIT 10 <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"14\">sk_ad_networks<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Contacte o seu gestor de conta para aceder a esta tabela.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/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>atualizado_em<\/td><td>Carimbo temporal que indica quando o registo foi atualizado pela \u00faltima vez.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>Carimbo temporal que indica a data e hora em que o registo foi carregado pela \u00faltima vez no DataVault.<\/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\">Contacte o seu gestor de conta para aceder a esta tabela.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>data<sup>(S)<\/sup><\/td><td>Data em que foi recebida a resposta da 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>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>ID da campanha SK, um n\u00famero inteiro compreendido entre 0 e 99.<\/td><td>10<\/td><\/tr><tr><td>campaign_id<\/td><td>UUID: Identificador espec\u00edfico do Tenjin para a campanha. Pode ser associado atrav\u00e9s de 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>tipo_de_fidelidade<\/td><td>1 para an\u00fancios do StoreKit, 0 para an\u00fancios de view-through.<\/td><td>1<\/td><\/tr><tr><td>valor_de_convers\u00e3o<\/td><td>Valor de convers\u00e3o, um n\u00famero inteiro entre 0 e 63.<\/td><td>33<\/td><\/tr><tr><td>conversion_value_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code>.<\/td><td>250<\/td><\/tr><tr><td>n\u00famero de novas transfer\u00eancias<\/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>Carimbo temporal que indica a data e hora em que o registo foi carregado pela \u00faltima vez no DataVault.<\/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>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>data<sup>(S)<\/sup><\/td><td>Data em que foi recebida a resposta da 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>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>ID da campanha SK, um n\u00famero inteiro compreendido entre 0 e 99.<\/td><td>10<\/td><\/tr><tr><td>campaign_id<\/td><td>UUID: Identificador espec\u00edfico de Tenjin para a campanha. \u00c9 sempre nulo, uma vez que a Apple n\u00e3o disponibiliza qualquer forma de obter este valor.<\/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>tipo_de_fidelidade<\/td><td>1 para an\u00fancios do StoreKit, 0 para an\u00fancios de view-through.<\/td><td>1<\/td><\/tr><tr><td>valor_de_convers\u00e3o<\/td><td>Valor de convers\u00e3o, um n\u00famero inteiro entre 0 e 63.<\/td><td>33<\/td><\/tr><tr><td>conversion_value_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code>.<\/td><td>250<\/td><\/tr><tr><td>n\u00famero de novas transfer\u00eancias<\/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>Carimbo temporal que indica a data e hora em que o registo foi carregado pela \u00faltima vez no DataVault.<\/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\">instala<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>created_at<\/td><td>data e hora em que o evento foi criado<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>id_publicit\u00e1rio<\/td><td>IDFA para iOS ou ID de publicidade do Google para Android. Em min\u00fasculas, sem h\u00edfen<\/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>plataforma<\/td><td>plataforma da aplica\u00e7\u00e3o<\/td><td>iOS ou Android<\/td><\/tr><tr><td>os_version<\/td><td>vers\u00e3o do sistema operativo do dispositivo<\/td><td>8.0<\/td><\/tr><tr><td>app_version<\/td><td>vers\u00e3o da aplica\u00e7\u00e3o<\/td><td>1.0.3<\/td><\/tr><tr><td>limitar_o_rastreio_de_publicidade<\/td><td>limite de rastreamento de an\u00fancios do utilizador (0,1)<\/td><td>1<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">ID interno da aplica\u00e7\u00e3o do Tenjin. Pode ser associado a <code>id<\/code> na tabela de aplica\u00e7\u00f5es<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">O ID interno da campanha da Tenjin \u00e9 atribu\u00eddo ao utilizador da campanha. Pode ser associado a <code>id<\/code> na tabela \u00abcampaigns\u00bb<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>adquirido_em<\/td><td>data e hora em que o utilizador foi registado<\/td><td>2018-10-01 00:00:00<\/td><\/tr><tr><td>pa\u00eds<\/td><td>c\u00f3digo do pa\u00eds<\/td><td>EUA<\/td><\/tr><tr><td>site_id<\/td><td>ID do editor da campanha, caso se trate de uma campanha paga<\/td><td>Instagram<\/td><\/tr><tr><td>identificador_do_dispositivo_do_desenvolvedor<\/td><td>IDFV para iOS. Em branco para Android. Min\u00fasculas, sem h\u00edfen<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>uuid<\/td><td>ID \u00fanico do evento<\/td><td>a3e3e535-a32c-4887-9c91-3160c91b3876<\/td><\/tr><tr><td>dispositivo<\/td><td>tipo de dispositivo<\/td><td>iPAD 2,5<\/td><\/tr><tr><td>nome_criativo<\/td><td>nome criativo<\/td><td>test_creative<\/td><\/tr><tr><td>endere\u00e7o_IP<\/td><td>endere\u00e7o IP do utilizador<\/td><td>71.165.85.114<\/td><\/tr><tr><td>source_uuid<\/td><td class=\"translation-block\">UUID do evento de clique ou impress\u00e3o, caso a campanha tenha sido paga. Pode ser associado a <code>uuid<\/code> na tabela ad_engagements<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>loaded_at<\/td><td>carimbo de data e hora em que o registo \u00e9 atualizado no DataVault<\/td><td>2018-10-01 00:00:00<\/td><\/tr><tr><td>estado_do_rastreio<\/td><td class=\"translation-block\">n\u00famero inteiro para o <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">estado ATT<\/a> do dispositivo iOS. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; n\u00e3o determinado, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; restrito, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; recusado, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; autorizado<\/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\">Contacte o seu gestor de conta para aceder a esta tabela<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>adquirido_em<\/td><td>data e hora em que o utilizador foi registado<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>ad_mediation_ad_format<\/td><td>Formato do bloco de an\u00fancios<\/td><td>Banner<\/td><\/tr><tr><td>rede_de_media\u00e7\u00e3o_publicit\u00e1ria<\/td><td>Rede que exibiu o an\u00fancio<\/td><td>Applovin<\/td><\/tr><tr><td>ad_mediation_placement<\/td><td>Coloca\u00e7\u00e3o definida pela rede<\/td><td>my_banner_placement<\/td><\/tr><tr><td>fornecedor_de_media\u00e7\u00e3o_publicit\u00e1ria<\/td><td>Fornecedor de servi\u00e7os de media\u00e7\u00e3o publicit\u00e1ria<\/td><td>Aplica\u00e7\u00e3o MAX<\/td><\/tr><tr><td>receitas_de_media\u00e7\u00e3o_publicit\u00e1ria_em_microcents<\/td><td>Receitas publicit\u00e1rias em microscents, conforme fornecidas pelo prestador de servi\u00e7os de media\u00e7\u00e3o<\/td><td>22000<\/td><\/tr><tr><td>id_publicit\u00e1rio<\/td><td>IDFA para iOS ou ID de publicidade do Google para Android. Em min\u00fasculas, sem h\u00edfen.<\/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\">ID interno da aplica\u00e7\u00e3o do Tenjin. Pode ser associado a <code>id<\/code> na tabela de aplica\u00e7\u00f5es<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>app_version<\/td><td>vers\u00e3o da aplica\u00e7\u00e3o<\/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>pa\u00eds<\/td><td>c\u00f3digo do pa\u00eds<\/td><td>EUA<\/td><\/tr><tr><td>created_at<\/td><td>data e hora em que o evento foi criado<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>nome_criativo<\/td><td>nome criativo<\/td><td>test_creative<\/td><\/tr><tr><td>customer_user_id<\/td><td>ID do utilizador da aplica\u00e7\u00e3o, tal como definido pelo m\u00e9todo setCustomerUserId do SDK<\/td><td>jdabGcerT32_d<\/td><\/tr><tr><td>identificador_do_dispositivo_do_desenvolvedor<\/td><td>IDFV para iOS. Em branco para Android. Min\u00fasculas, sem h\u00edfen<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>dispositivo<\/td><td>tipo de dispositivo<\/td><td>iPAD 2.5<\/td><\/tr><tr><td>engaged_at<\/td><td>Data e hora do evento de clique\/impress\u00e3o com o qual o utilizador interagiu antes da aquisi\u00e7\u00e3o<\/td><td>2018-01-01 00:00:00<\/td><\/tr><tr><td>endere\u00e7o_IP<\/td><td>endere\u00e7o IP do utilizador<\/td><td>71.165.85.114<\/td><\/tr><tr><td>limitar_o_rastreio_de_publicidade<\/td><td>limite de rastreamento de an\u00fancios do utilizador<\/td><td>(0,1)<\/td><\/tr><tr><td>loaded_at<\/td><td>carimbo de data e hora em que o registo \u00e9 atualizado no DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>os_version<\/td><td>vers\u00e3o do sistema operativo do dispositivo<\/td><td>8.0<\/td><\/tr><tr><td>plataforma<\/td><td>plataforma da aplica\u00e7\u00e3o<\/td><td>8.0<\/td><\/tr><tr><td>sdk_version<\/td><td>Vers\u00e3o do Tenjin SDK do utilizador<\/td><td>12.2.22<\/td><\/tr><tr><td>site_id<\/td><td>ID do editor da campanha, caso se trate de uma campanha paga<\/td><td>Instagram<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">O ID interno da campanha da Tenjin \u00e9 atribu\u00eddo ao utilizador da campanha. Pode ser associado a <code>id<\/code> na tabela \u00abcampaigns\u00bb<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>source_uuid<\/td><td>UUID do evento de impress\u00e3o, caso a campanha tenha sido paga. Pode ser associado ao UUID na tabela ad_engagements<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>estado_do_rastreio<\/td><td class=\"translation-block\">n\u00famero inteiro para o <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">estado ATT<\/a> do dispositivo iOS. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; n\u00e3o determinado, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; restrito, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; recusado, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; autorizado<\/td><td>3<\/td><\/tr><tr><td>uuid<\/td><td class=\"translation-block\">ID \u00fanico do evento. Pode ser associado \u00e0 tabela de eventos <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\">atributos_do_utilizador <\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Coluna<\/th><th>Descri\u00e7\u00e3o<\/th><th>Valor de exemplo<\/th><\/tr><\/thead><tbody><tr><td>id_publicit\u00e1rio<\/td><td>IDFA para iOS ou ID de publicidade do Google para Android. Em min\u00fasculas, sem h\u00edfen.<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>limitar_o_rastreio_de_publicidade<\/td><td>limite de rastreamento de an\u00fancios do utilizador (0,1)<\/td><td>1<\/td><\/tr><tr><td>adquirido_em<\/td><td>data e hora em que o utilizador foi registado<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>pa\u00eds<\/td><td>c\u00f3digo do pa\u00eds<\/td><td>EUA<\/td><\/tr><tr><td>site_id<\/td><td>ID do editor da campanha, caso se trate de uma campanha paga<\/td><td>Instagram<\/td><\/tr><tr><td>identificador_do_dispositivo_do_desenvolvedor<\/td><td>IDFV para iOS. Em branco para Android. Min\u00fasculas, sem h\u00edfen.<\/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\">O ID interno da campanha da Tenjin \u00e9 atribu\u00eddo ao utilizador da campanha. Pode ser associado a <code>id<\/code> na tabela \u00abcampaigns\u00bb<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>estado_do_rastreio<\/td><td class=\"translation-block\">n\u00famero inteiro para o <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">estado ATT<\/a> do dispositivo iOS. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; n\u00e3o determinado, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; restrito, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; recusado, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; autorizado<\/td><td>3<\/td><\/tr><tr><td>\u00faltima_visita<\/td><td>data e hora da \u00faltima vez que o utilizador foi visto<\/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\">Per\u00edodo de refer\u00eancia<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Estas tabelas cont\u00eam dados hist\u00f3ricos limitados, dependendo do per\u00edodo de an\u00e1lise, tal como mencionado no seu contrato com a Tenjin. Se pretender saber qual \u00e9 o per\u00edodo de an\u00e1lise do seu DataVault, contacte o seu gestor de conta na Tenjin.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>eventos<\/li>\n\n\n\n<li>ad_engagements<\/li>\n\n\n\n<li>m\u00e9tricas_de_relat\u00f3rios<\/li>\n\n\n\n<li>relat\u00f3rios_de_m\u00e9tricas_da_coorte<\/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\/pt\/blog\/author\/anurag\/"},"doc_category_info":[{"term_name":"DataVault","term_url":"https:\/\/tenjin.com\/pt\/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\/pt\/docs\/datavault-schema-and-tables\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\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\/pt\/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=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"14 minutos\" \/>\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\":\"pt-PT\"},{\"@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\":\"pt-PT\",\"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\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/#organization\",\"name\":\"Tenjin\",\"url\":\"https:\\\/\\\/tenjin.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\":\"pt-PT\",\"@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\\\/pt\\\/blog\\\/author\\\/anurag\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Esquema e tabelas do DataVault | Tenjin","description":"O esquema do DataVault da Tenjin est\u00e1 no cerne do seu segredo. Toda a informa\u00e7\u00e3o proveniente de v\u00e1rias fontes \u00e9 perfeitamente integrada atrav\u00e9s de identificadores.","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\/pt\/docs\/datavault-schema-and-tables\/","og_locale":"pt_PT","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\/pt\/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":{"Tempo estimado de leitura":"14 minutos"},"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":"pt-PT"},{"@type":"WebPage","@id":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/","url":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/","name":"Esquema e tabelas do 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":"O esquema do DataVault da Tenjin est\u00e1 no cerne do seu segredo. Toda a informa\u00e7\u00e3o proveniente de v\u00e1rias fontes \u00e9 perfeitamente integrada atrav\u00e9s de identificadores.","breadcrumb":{"@id":"https:\/\/tenjin.com\/docs\/datavault-schema-and-tables\/#breadcrumb"},"inLanguage":"pt-PT","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":"Crescimento Simplificado","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":"pt-PT"},{"@type":"Organization","@id":"https:\/\/tenjin.com\/#organization","name":"Tenjin","url":"https:\/\/tenjin.com\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@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":"pt-PT","@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\/pt\/blog\/author\/anurag\/"}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/docs\/15474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/comments?post=15474"}],"version-history":[{"count":5,"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/docs\/15474\/revisions"}],"predecessor-version":[{"id":16790,"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/docs\/15474\/revisions\/16790"}],"wp:attachment":[{"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/media?parent=15474"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/doc_category?post=15474"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/glossaries?post=15474"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/tenjin.com\/pt\/wp-json\/wp\/v2\/doc_tag?post=15474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}