{"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\/tr\/docs\/datavault-schema-and-tables\/","title":{"rendered":"DataVault Schema and Tables"},"content":{"rendered":"<p class=\"wp-block-paragraph translation-block\">Tenjin\u2019s DataVault schema lies at the heart of its special sauce. All information from various places is nicely joined together through <code>id<\/code>s. With information organized in this way, DataVault makes it easy to build models and analyses in a deterministic way.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">List of tables<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#0\" style=\"text-decoration:none\">events<\/a>\n<ul class=\"wp-block-list\">\n<li>device level data that comes from Tenjin SDK or 3rd party attribution provider<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#1\" style=\"text-decoration:none\">campaigns<\/a>\n<ul class=\"wp-block-list\">\n<li>campaigns that users are attributed to, or campaigns from ad-networks API<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#3\" style=\"text-decoration:none\">ad_networks<\/a>\n<ul class=\"wp-block-list\">\n<li>list of ad networks<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#4\" style=\"text-decoration:none\">apps<\/a>\n<ul class=\"wp-block-list\">\n<li>list of apps<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#5\" style=\"text-decoration:none\">daily_country_spend<\/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=\"\/tr\/v1\/#6\" style=\"text-decoration:none\">publisher_apps<\/a>\n<ul class=\"wp-block-list\">\n<li>publisher campaigns that we get from ad-network API<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#7\" style=\"text-decoration:none\">daily_ad_revenue<\/a>\n<ul class=\"wp-block-list\">\n<li>includes ad revenue data by publisher campaigns, date, and country<\/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>includes click or impression data for each device. It only has data for non-self attributing ad-networks. Note: this table is not enabled by default; please ask your Tenjin account manager if you want to use it.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#11\" style=\"text-decoration:none\">reporting_metrics<\/a>\n<ul class=\"wp-block-list\">\n<li>includes all non-cohorted metrics that are synced with dashboard data<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#12\" style=\"text-decoration:none\">reporting_cohort_metrics<\/a>\n<ul class=\"wp-block-list\">\n<li>includes all cohorted metrics that are synced with dashboard data<\/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>A mapping of SK Ad Network IDs to Tenjin-specific IDs for ad networks.<\/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\">Columns are the same as for <code>sk_ad_network_metrics<\/code>. However, <code>campaign_id<\/code> is always <code>null<\/code> due to limitations on data received from Apple.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#17\" style=\"text-decoration:none\">installs<\/a>\n<ul class=\"wp-block-list\">\n<li>App install events, as provided by Tenjin SDK.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#18\" style=\"text-decoration:none\">ad_mediation_impressions_preview<\/a>\n<ul class=\"wp-block-list\">\n<li>Your Impression-level Ad Revenue from the Mediation Provider. Note: this table is not enabled by default; please ask your Tenjin account manager if you want to use it.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#19\" style=\"text-decoration:none\">user_attributes<\/a>\n<ul class=\"wp-block-list\">\n<li>includes user&#8217;s attributes<\/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\">List of table fields<\/h3>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p class=\"wp-block-paragraph\">(S): Sort Key <br>(D): Dist Key<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"0\">events<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>created_at <sup>(S)<\/sup><\/td><td>timestamp when the event was created<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>advertising_id<\/td><td>IDFA for iOS or Google advertising ID for Android. Lower case, without hyphen.<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>bundle_id<\/td><td>app&#8217;s bundle ID(we convert bundle_id to lowercase)<\/td><td>com.tenjin.wordfinder<\/td><\/tr><tr><td>platform<\/td><td>app&#8217;s platform<\/td><td>ios or android<\/td><\/tr><tr><td>os_version<\/td><td>device&#8217;s os_version<\/td><td>8.0<\/td><\/tr><tr><td>app_version<\/td><td>app version<\/td><td>1.0.3<\/td><\/tr><tr><td>limit_ad_tracking<\/td><td>user&#8217;s limit ad tracking (0,1)<\/td><td>1<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin\u2019s internal app id. It can be joined with <code>id<\/code> in apps table<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>event_type<\/td><td class=\"translation-block\">either <code>event<\/code> or <code>purchase<\/code><\/td><td>event<\/td><\/tr><tr><td>event<\/td><td class=\"translation-block\">when event_type = <code>event<\/code>, then this value is either <code>open<\/code>, or a custom event name.<\/td><td>open<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">Tenjin\u2019s internal campaign id for the campaign user is attributed to. It can be joined with <code>id<\/code> in campaigns table<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>acquired_at<\/td><td>timestamp when the user was acquired<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>price<\/td><td>raw purchase price for the purchase event<\/td><td>1.99<\/td><\/tr><tr><td>quantity<\/td><td>purchase quantity for the purchase event<\/td><td>2<\/td><\/tr><tr><td>product_id<\/td><td>product id for the purchase event<\/td><td>com.tenjin.wordfinder.package50<\/td><\/tr><tr><td>currency<\/td><td>currency code for the purchase event<\/td><td>USD<\/td><\/tr><tr><td>country<\/td><td>country code<\/td><td>US<\/td><\/tr><tr><td>total_revenue<\/td><td class=\"translation-block\">gross revenue for the purchase event in USD <strong>cents<\/strong><\/td><td>350<\/td><\/tr><tr><td>revenue<\/td><td class=\"translation-block\">net revenue for the purchase event in USD <strong>cents<\/strong><\/td><td>245<\/td><\/tr><tr><td>site_id<\/td><td>campaign&#8217;s publisher ID if the campaign is paid campaign<\/td><td>Instagram<\/td><\/tr><tr><td>developer_device_id<\/td><td>IDFV for iOS. Empty for Android. Lower case, without hyphen.<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>purchase_state<\/td><td><ul><li>0: Unknowable &#8211; no receipt was received with the purchase<\/li><li>1: Unverified &#8211; a receipt was provided but not able to be verified<\/li><li>2: Fraudulent &#8211; a fraudulent receipt was provided<\/li><li>3: Verified &#8211; the receipt was successfully verified<\/li><li>4: Sandbox &#8211; the receipt was verified in the test sandbox<\/li><li>5: Duplicate &#8211; the receipt was already received with an earlier purchase<\/li><li>6: Stale &#8211; the purchase event happened 3 days ago and not in real time<\/li><\/ul><\/td><td>3<\/td><\/tr><tr><td>value<\/td><td>Custom event value<\/td><td>1<\/td><\/tr><tr><td>uuid<\/td><td>unique event ID<\/td><td>a3e3e535-a32c-4887-9c91-3160c91b3876<\/td><\/tr><tr><td>device<\/td><td>device type<\/td><td>iPad2,5<\/td><\/tr><tr><td>creative_name<\/td><td>creative name<\/td><td>test_creative<\/td><\/tr><tr><td>ip_address<\/td><td>user&#8217;s IP address<\/td><td>71.165.85.114<\/td><\/tr><tr><td>source_uuid<\/td><td class=\"translation-block\">UUID for the click or impression event if the campaign was paid campaign. It can be joined with <code>uuid<\/code> in ad_engagements table<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">integer for the iOS device\u2019s <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">ATT status<\/a>. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; not determined, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; restricted, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; denied, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; authorized<\/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>User ID from the app, as set by setCustomerUserId SDK method<\/td><td>jdabGcerT32_d<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"1\">campaigns<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>unique ID for the campaign<\/td><td>3b70e477-c151-4167-9174-cca6ffa2c7bc<\/td><\/tr><tr><td>name<\/td><td>campaign name<\/td><td>test @bYkiNAbrAOCpzETWviMILo<\/td><\/tr><tr><td>ad_network_id<\/td><td class=\"translation-block\">id for the ad network, campaign is assigned to. It can be joined with <code>id<\/code> in ad_networks table<\/td><td>3<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin\u2019s internal app id. It can be joined with <code>id<\/code> in apps table<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>remote_campaign_id<\/td><td>campaign_id ad-network uses. We get this through ad-network reporting API.<\/td><td>6026825090762<\/td><\/tr><tr><td>campaign_bucket_id<\/td><td class=\"translation-block\">campaign bucket id to bucket campaigns. This can be joined with <code>id<\/code> in campaign_buckets table<\/td><td>fbbc74bd-8a73-472a-86f7-5e2a4642a201<\/td><\/tr><tr><td>updated_at<\/td><td>timestamp when the record is updated in Tenjin&#8217;s database<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in 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\">ad_networks<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>id <sup>(S)<\/sup><\/td><td>unique ID for the ad_network<\/td><td>3<\/td><\/tr><tr><td>name<\/td><td>ad network name<\/td><td>Facebook<\/td><\/tr><tr><td>updated_at<\/td><td>timestamp when the record is updated in Tenjin&#8217;s database<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4\">apps<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>unique ID for the app<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>name<\/td><td>app name<\/td><td>Word Search<\/td><\/tr><tr><td>store_id<\/td><td>app&#8217;s store ID<\/td><td>887212194<\/td><\/tr><tr><td>bundle_id<\/td><td>app&#8217;s bundle ID<\/td><td>com.tenjin.wordfinder<\/td><\/tr><tr><td>platform<\/td><td>app&#8217;s platform<\/td><td>ios or android<\/td><\/tr><tr><td>updated_at<\/td><td>timestamp when the record is updated in Tenjin&#8217;s database<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in 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\">daily_country_spend<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>unique ID for the spend data<\/td><td>174491158<\/td><\/tr><tr><td>date <sup>(S)<\/sup><\/td><td>date when the spend happens<\/td><td>2018-07-01<\/td><\/tr><tr><td>country<\/td><td>country where the spend happens<\/td><td>US<\/td><\/tr><tr><td>campaign_id <sup>(D)<\/sup><\/td><td class=\"translation-block\">ID for the campaign. This can be joined with <code>id<\/code> in the campaigns table<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>spend<\/td><td>ad spend amount in USD cents.<\/td><td>400<\/td><\/tr><tr><td>installs<\/td><td>number of installs reported<\/td><td>8<\/td><\/tr><tr><td>clicks<\/td><td>number of clicks reported<\/td><td>10<\/td><\/tr><tr><td>impressions<\/td><td>number of impressions reported<\/td><td>126<\/td><\/tr><tr><td>original_spend<\/td><td>ad spend amount in original currency<\/td><td>4<\/td><\/tr><tr><td>original_currency<\/td><td>original currency<\/td><td>USD<\/td><\/tr><tr><td>updated_at<\/td><td>timestamp when the record is updated in Tenjin&#8217;s database<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>missing_country<\/td><td>if country info was missing for the spend that the ad network sent<\/td><td>false<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"6\">publisher_apps<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>unique ID for the publisher app<\/td><td>b71ff0ab-f1b4-4ca6-98fc-0064a5b9d1d7<\/td><\/tr><tr><td>ad_network_id<\/td><td class=\"translation-block\">id for the ad network publisher campaign is attributed to. It can be joined with <code>id<\/code> in ad_networks table<\/td><td>1<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin\u2019s internal app id. It can be joined with <code>id<\/code> in apps table<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>name<\/td><td>name of the publisher campaign<\/td><td>Word Search! Free-ios-Tapjoy<\/td><\/tr><tr><td>updated_at<\/td><td>timestamp when the record is updated in Tenjin&#8217;s database<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in 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\">daily_ad_revenue<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>id<\/td><td>unique ID for the ad revenue<\/td><td>107852371<\/td><\/tr><tr><td>date <sup>(S)<\/sup><\/td><td>date when the ad revenue happens<\/td><td>2018-07-01<\/td><\/tr><tr><td>publisher_app_id <sup>(D)<\/sup><\/td><td class=\"translation-block\">ID for the publisher campaign. This can be joined with <code>id<\/code> in the publisher_apps table<\/td><td>b71ff0ab-f1b4-4ca6-98fc-0064a5b9d1d7<\/td><\/tr><tr><td>country<\/td><td>country for the metrics<\/td><td>US<\/td><\/tr><tr><td>revenue<\/td><td>ad revenue amount in USD cents<\/td><td>20000<\/td><\/tr><tr><td>conversions<\/td><td>number of conversions reported<\/td><td>8<\/td><\/tr><tr><td>clicks<\/td><td>number of clicks reported<\/td><td>10<\/td><\/tr><tr><td>impressions<\/td><td>number of impressions reported<\/td><td>126<\/td><\/tr><tr><td>interstitial_revenue<\/td><td>ad revenue amount in USD cents for interstitial ads<\/td><td>20000<\/td><\/tr><tr><td>interstitial_conversions<\/td><td>number of conversions reported for interstitial ads<\/td><td>8<\/td><\/tr><tr><td>interstitial_clicks<\/td><td>number of clicks reported for interstitial ads<\/td><td>10<\/td><\/tr><tr><td>interstitial_impressions<\/td><td>number of impressions reported for interstitial ads<\/td><td>126<\/td><\/tr><tr><td>banner_revenue<\/td><td>ad revenue amount in USD cents for banner ads<\/td><td>20000<\/td><\/tr><tr><td>banner_conversions<\/td><td>number of conversions reported for banner ads<\/td><td>8<\/td><\/tr><tr><td>banner_clicks<\/td><td>number of clicks reported for banner ads<\/td><td>10<\/td><\/tr><tr><td>banner_impressions<\/td><td>number of impressions reported for banner ads<\/td><td>126<\/td><\/tr><tr><td>native_revenue<\/td><td>ad revenue amount in USD cents for native ads<\/td><td>20000<\/td><\/tr><tr><td>native_conversions<\/td><td>number of conversions reported for native ads<\/td><td>8<\/td><\/tr><tr><td>native_clicks<\/td><td>number of clicks reported for native ads<\/td><td>10<\/td><\/tr><tr><td>native_impressions<\/td><td>number of impressions reported for native ads<\/td><td>126<\/td><\/tr><tr><td>offerwall_revenue<\/td><td>ad revenue amount in USD cents for offerwall ads<\/td><td>20000<\/td><\/tr><tr><td>offerwall_conversions<\/td><td>number of conversions reported for offerwall ads<\/td><td>8<\/td><\/tr><tr><td>offerwall_clicks<\/td><td>number of clicks reported for offerwall ads<\/td><td>10<\/td><\/tr><tr><td>offerwall_impressions<\/td><td>number of impressions reported for offerwall ads<\/td><td>126<\/td><\/tr><tr><td>video_revenue<\/td><td>ad revenue amount in USD cents for video ads<\/td><td>20000<\/td><\/tr><tr><td>video_conversions<\/td><td>number of conversions reported for video ads<\/td><td>8<\/td><\/tr><tr><td>video_clicks<\/td><td>number of clicks reported for video ads<\/td><td>10<\/td><\/tr><tr><td>video_impressions<\/td><td>number of impressions reported for video ads<\/td><td>126<\/td><\/tr><tr><td>other_revenue<\/td><td>ad revenue amount in USD cents for other ads<\/td><td>20000<\/td><\/tr><tr><td>other_conversions<\/td><td>number of conversions reported for other ads<\/td><td>8<\/td><\/tr><tr><td>other_clicks<\/td><td>number of clicks reported for other ads<\/td><td>10<\/td><\/tr><tr><td>other_impressions<\/td><td>number of impressions reported for other ads<\/td><td>126<\/td><\/tr><tr><td>updated_at<\/td><td>timestamp when the record is updated in Tenjin&#8217;s database<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in 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>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>created_at <sup>(S)<\/sup><\/td><td>timestamp when the event was created<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>advertising_id<\/td><td>IDFA for iOS or Google advertising ID for Android. Lower case, without hyphen.<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>attributable<\/td><td class=\"translation-block\">if the click\/impression is used for attribution or not. <code>true<\/code> or <code>false<\/code><\/td><td>true<\/td><\/tr><tr><td>event_type<\/td><td class=\"translation-block\">either <code>clicks<\/code> or <code>impressions<\/code><\/td><td>clicks<\/td><\/tr><tr><td>campaign_id<\/td><td class=\"translation-block\">ID for the campaign. This can be joined with <code>id<\/code> in the campaigns table<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>bundle_id<\/td><td>app&#8217;s bundle ID<\/td><td>com.tenjin.wordfinder<\/td><\/tr><tr><td>platform<\/td><td>app&#8217;s platform<\/td><td>ios or anroid<\/td><\/tr><tr><td>ip_address<\/td><td>user&#8217;s IP address<\/td><td>71.165.85.114<\/td><\/tr><tr><td>limit_ad_tracking<\/td><td>user&#8217;s limit ad tracking<\/td><td>(0,1)<\/td><\/tr><tr><td>uuid<\/td><td class=\"translation-block\">unique ID for the event. It can be joined with <code>source_uuid<\/code> events table<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin\u2019s internal app id. It can be joined with <code>id<\/code> in apps table<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>country<\/td><td>country code<\/td><td>US<\/td><\/tr><tr><td>site_id<\/td><td>campaign&#8217;s publisher ID if the campaign is paid campaign<\/td><td>Instagram<\/td><\/tr><tr><td>user_agent<\/td><td>User Agent<\/td><td>Dalvik\/2.1.0 (Linux; U; Android 8.0.0; SM-G570M Build\/R16NW)<\/td><\/tr><tr><td>remote_click_id<\/td><td>click id ad-networks passes through the click url.<\/td><td>DSGfaa<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">integer for the iOS device\u2019s <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">ATT status<\/a>. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; not determined, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; restricted, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; denied, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; authorized<\/td><td>3<\/td><\/tr><tr><td>analytics_installation_id<\/td><td>Tenjin generated Application install-specific identifier. Lower case, without hyphen.<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"11\">reporting_metrics<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>date <sup>(S)<\/sup><\/td><td>date the metric applies to<\/td><td>2018-11-01<\/td><\/tr><tr><td>ad_network_id<\/td><td>Tenjin ID of the ad network<\/td><td>3<\/td><\/tr><tr><td>platform<\/td><td>app&#8217;s platform<\/td><td>ios or android<\/td><\/tr><tr><td>app_id<\/td><td>Tenjin ID of the app<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>campaign_id<\/td><td>Tenjin ID of the campaign<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>country<\/td><td>two-letter country code<\/td><td>US<\/td><\/tr><tr><td>site_id<\/td><td>Site ID<\/td><td>Instagram<\/td><\/tr><tr><td>daily_active_users<\/td><td>unique devices seen<\/td><td>105<\/td><\/tr><tr><td>sessions<\/td><td>count of app open events<\/td><td>23650<\/td><\/tr><tr><td>iap_revenue<\/td><td>sum of in-app purchase revenue in USD cents<\/td><td>245<\/td><\/tr><tr><td>reported_spend<\/td><td>allocated spend from ad network reporting APIs in cents<\/td><td>5323<\/td><\/tr><tr><td>reported_impressions<\/td><td>allocated impressions from ad network reporting APIs<\/td><td>13000<\/td><\/tr><tr><td>reported_clicks<\/td><td>allocated clicks from ad network reporting APIs<\/td><td>3000<\/td><\/tr><tr><td>reported_installs<\/td><td>allocated installs from ad network reporting APIs<\/td><td>4000<\/td><\/tr><tr><td>publisher_ad_revenue<\/td><td>allocated sum of publisher ad revenue from ad network reporting API in USD cents<\/td><td>2000<\/td><\/tr><tr><td>tracked_impressions<\/td><td>count of impressions tracked by Tenjin attribution<\/td><td>13000<\/td><\/tr><tr><td>tracked_clicks<\/td><td>count of clicks tracked by Tenjin attribution<\/td><td>4000<\/td><\/tr><tr><td>tracked_installs<\/td><td>count of installs tracked by Tenjin attribution<\/td><td>3000<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in 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\">reporting_cohort_metrics<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>event_date <sup>(S)<\/sup><\/td><td>date current cohort the metrics apply to<\/td><td>2018-11-01<\/td><\/tr><tr><td>install_date<\/td><td>date of the install<\/td><td>2018-10-01<\/td><\/tr><tr><td>days_since_install<\/td><td>days since install<\/td><td>3<\/td><\/tr><tr><td>platform<\/td><td>app&#8217;s platform<\/td><td>ios or anroid<\/td><\/tr><tr><td>app_id<\/td><td>Tenjin ID of the app<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>campaign_id<\/td><td>Tenjin ID of the campaign<\/td><td>b1d67331-204b-4ee3-9cac-7c0f0f33b5bf<\/td><\/tr><tr><td>country<\/td><td>two-letter country code<\/td><td>US<\/td><\/tr><tr><td>site_id<\/td><td>Site ID<\/td><td>Instagram<\/td><\/tr><tr><td>daily_active_users<\/td><td>unique devices seen<\/td><td>105<\/td><\/tr><tr><td>sessions<\/td><td>count of app open events<\/td><td>23650<\/td><\/tr><tr><td>iap_revenue<\/td><td>sum of in-app purchase revenue in USD cents<\/td><td>245<\/td><\/tr><tr><td>publisher_ad_revenue<\/td><td>allocated sum of publisher ad revenue from ad network reporting API in USD cents<\/td><td>2000<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For reporting_cohort_metrics use the install_date and days_since_install to get metrics as in the dashboard. ex:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:1rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.5rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\" data-no-translation=\"\" data-no-auto-translation=\"\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#39404f;color:#c8d0e0\">Plaintext<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\" data-no-translation=\"\" data-no-auto-translation=\"\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>SELECT install_date AS DATE, apps.name as app_name, ad_networks.name as ad_network, country, SUM(CASE WHEN days_since_install <= 1 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d1_total_LTV, SUM(CASE WHEN days_since_install <= 2 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d2_total_LTV, SUM(CASE WHEN days_since_install <= 3 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d3_total_LTV, SUM(CASE WHEN days_since_install = 1 THEN daily_active_users ELSE 0 END) AS d1_retained_users, SUM(CASE WHEN days_since_install = 2 THEN daily_active_users ELSE 0 END) AS d2_retained_users, SUM(CASE WHEN days_since_install = 3 THEN daily_active_users ELSE 0 END) AS d3_retained_users FROM reporting_cohort_metrics LEFT JOIN apps ON apps.id = reporting_cohort_metrics.app_id LEFT JOIN bucket_campaign_info ON bucket_campaign_info.id = reporting_cohort_metrics.campaign_id LEFT JOIN ad_networks ON ad_networks.id = bucket_campaign_info.ad_network_id WHERE install_date = '2018-10-11' GROUP BY 1, 2, 3, 4 LIMIT 10 <\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewbox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\" data-no-translation=\"\" data-no-auto-translation=\"\"><code data-no-translation=\"\" data-no-auto-translation=\"\"><span class=\"line\"><span style=\"color: #d8dee9ff\">SELECT install_date AS DATE, apps.name as app_name, ad_networks.name as ad_network, country, SUM(CASE WHEN days_since_install <= 1 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d1_total_LTV, SUM(CASE WHEN days_since_install <= 2 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d2_total_LTV, SUM(CASE WHEN days_since_install <= 3 THEN (publisher_ad_revenue + iap_revenue) \/ 100.0 ELSE 0 END) AS d3_total_LTV, SUM(CASE WHEN days_since_install = 1 THEN daily_active_users ELSE 0 END) AS d1_retained_users, SUM(CASE WHEN days_since_install = 2 THEN daily_active_users ELSE 0 END) AS d2_retained_users, SUM(CASE WHEN days_since_install = 3 THEN daily_active_users ELSE 0 END) AS d3_retained_users FROM reporting_cohort_metrics LEFT JOIN apps ON apps.id = reporting_cohort_metrics.app_id LEFT JOIN bucket_campaign_info ON bucket_campaign_info.id = reporting_cohort_metrics.campaign_id LEFT JOIN ad_networks ON ad_networks.id = bucket_campaign_info.ad_network_id WHERE install_date = &#39;2018-10-11&#39; GROUP BY 1, 2, 3, 4 LIMIT 10 <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"14\">sk_ad_networks<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Contact your Account Manager to access this table.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>id<sup>(S)<\/sup><\/td><td>Lowercase string SK Ad Network ID for the ad network.<\/td><td>&#8220;cstr6suwn9.skadnetwork&#8221;<\/td><\/tr><tr><td>ad_network_id<\/td><td>Integer Tenjin-specific ID for the ad network. Can be joined via ad_networks.id<\/td><td>5<\/td><\/tr><tr><td>updated_at<\/td><td>Timestamp representing when the record was last updated.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><tr><td>loaded_at<\/td><td>Timestamp representing when the record was last loaded into DataVault.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p 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\">Contact your Account Manager to access this table.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>date<sup>(S)<\/sup><\/td><td>Date the SK Ad Network postback was received.<\/td><td>2021-01-01<\/td><\/tr><tr><td>sk_ad_network_id<\/td><td>Lowercase string SK Ad Network ID for the ad network.<\/td><td>&#8220;cstr6suwn9.skadnetwork&#8221;<\/td><\/tr><tr><td>ad_network_id<\/td><td>Integer Tenjin-specific ID for the ad network. Can be joined via ad_networks.id<\/td><td>5<\/td><\/tr><tr><td>sk_app_id<\/td><td>Integer SK App ID of the App being advertised. Equivalent to <code data-no-translation=\"\" data-no-auto-translation=\"\">apps.store_id<\/code> for iOS Apps.<\/td><td>1478027094<\/td><\/tr><tr><td>app_id<\/td><td>UUID Tenjin-specific ID for the App. Can be joined via <code data-no-translation=\"\" data-no-auto-translation=\"\">apps.id<\/code>.<\/td><td>&#8220;9668185b-da2e-4638-b15f-e03431377ac5&#8221;<\/td><\/tr><tr><td>sk_campaign_id<\/td><td>SK Campaign ID, an Integer from 0-99.<\/td><td>10<\/td><\/tr><tr><td>campaign_id<\/td><td>UUID Tenjin-specific ID for the Campaign. Can be joined via campaigns.id<\/td><td>&#8220;61817a78-0a8f-4e83-98c0-8106f7a6ea92&#8221;<\/td><\/tr><tr><td>sk_source_app_id<\/td><td>String representing the App that showed the advertisement that led to a conversion.<\/td><td>&#8220;284882215&#8221;<\/td><\/tr><tr><td>fidelity_type<\/td><td>1 for StoreKit Ads, 0 for view-through ads.<\/td><td>1<\/td><\/tr><tr><td>conversion_value<\/td><td>Conversion Value, an Integer from 0-63.<\/td><td>33<\/td><\/tr><tr><td>conversion_value_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code>.<\/td><td>250<\/td><\/tr><tr><td>redownload_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were redownloads.<\/td><td>11<\/td><\/tr><tr><td>assist_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were assists.<\/td><td>2<\/td><\/tr><tr><td>redownload_assist_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were both redownloads and assists.<\/td><td>1<\/td><\/tr><tr><td>loaded_at<\/td><td>Timestamp representing when the record was last loaded into DataVault.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"16\">skan_apple_metrics<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>date<sup>(S)<\/sup><\/td><td>Date the SK Ad Network postback was received.<\/td><td>2021-01-01<\/td><\/tr><tr><td>sk_ad_network_id<\/td><td>Lowercase string SK Ad Network ID for the ad network.<\/td><td>&#8220;cstr6suwn9.skadnetwork&#8221;<\/td><\/tr><tr><td>ad_network_id<\/td><td>Integer Tenjin-specific ID for the ad network. Can be joined via ad_networks.id<\/td><td>5<\/td><\/tr><tr><td>sk_app_id<\/td><td>Integer SK App ID of the App being advertised. Equivalent to <code data-no-translation=\"\" data-no-auto-translation=\"\">apps.store_id<\/code> for iOS Apps.<\/td><td>1478027094<\/td><\/tr><tr><td>app_id<\/td><td>UUID Tenjin-specific ID for the App. Can be joined via <code data-no-translation=\"\" data-no-auto-translation=\"\">apps.id<\/code>.<\/td><td>&#8220;9668185b-da2e-4638-b15f-e03431377ac5&#8221;<\/td><\/tr><tr><td>sk_campaign_id<\/td><td>SK Campaign ID, an Integer from 0-99.<\/td><td>10<\/td><\/tr><tr><td>campaign_id<\/td><td>UUID Tenjin-specific ID for the Campaign. Always null, as Apple does not provide any way to get this value.<\/td><td><code data-no-translation=\"\" data-no-auto-translation=\"\">null<\/code><\/td><\/tr><tr><td>sk_source_app_id<\/td><td>String representing the App that showed the advertisement that led to a conversion.<\/td><td>&#8220;284882215&#8221;<\/td><\/tr><tr><td>fidelity_type<\/td><td>1 for StoreKit Ads, 0 for view-through ads.<\/td><td>1<\/td><\/tr><tr><td>conversion_value<\/td><td>Conversion Value, an Integer from 0-63.<\/td><td>33<\/td><\/tr><tr><td>conversion_value_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code>.<\/td><td>250<\/td><\/tr><tr><td>redownload_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were redownloads.<\/td><td>11<\/td><\/tr><tr><td>assist_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were assists.<\/td><td>2<\/td><\/tr><tr><td>redownload_assist_count<\/td><td>Integer count of occurrences of the <code data-no-translation=\"\" data-no-auto-translation=\"\">conversion_value<\/code> that were both redownloads and assists.<\/td><td>1<\/td><\/tr><tr><td>loaded_at<\/td><td>Timestamp representing when the record was last loaded into DataVault.<\/td><td>2021-01-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"17\">installs<\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>created_at<\/td><td>timestamp when the event was created<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>advertising_id<\/td><td>IDFA for iOS or Google advertising ID for Android. Lower case, without hyphen<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>bundle_id<\/td><td>app&#8217;s bundle ID(we convert bundle_id to lowercase)<\/td><td>com.tenjin.wordfinder<\/td><\/tr><tr><td>platform<\/td><td>app&#8217;s platform<\/td><td>ios or android<\/td><\/tr><tr><td>os_version<\/td><td>device&#8217;s os_version<\/td><td>8.0<\/td><\/tr><tr><td>app_version<\/td><td>app version<\/td><td>1.0.3<\/td><\/tr><tr><td>limit_ad_tracking<\/td><td>user&#8217;s limit ad tracking (0,1)<\/td><td>1<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin\u2019s internal app id. It can be joined with <code>id<\/code> in apps table<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">Tenjin\u2019s internal campaign id for the campaign user is attributed to. It can be joined with <code>id<\/code> in campaigns table<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>acquired_at<\/td><td>timestamp when the user was acquired<\/td><td>2018-10-01 00:00:00<\/td><\/tr><tr><td>country<\/td><td>country code<\/td><td>US<\/td><\/tr><tr><td>site_id<\/td><td>campaign&#8217;s publisher ID if the campaign is paid campaign<\/td><td>Instagram<\/td><\/tr><tr><td>developer_device_id<\/td><td>IDFV for iOS. Empty for Android. Lower case, without hyphen<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>uuid<\/td><td>unique event ID<\/td><td>a3e3e535-a32c-4887-9c91-3160c91b3876<\/td><\/tr><tr><td>device<\/td><td>device type<\/td><td>iPAD 2,5<\/td><\/tr><tr><td>creative_name<\/td><td>creative name<\/td><td>test_creative<\/td><\/tr><tr><td>ip_address<\/td><td>user&#8217;s IP address<\/td><td>71.165.85.114<\/td><\/tr><tr><td>source_uuid<\/td><td class=\"translation-block\">UUID for the click or impression event if the campaign was paid campaign. It can be joined with <code>uuid<\/code> in ad_engagements table<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in DataVault<\/td><td>2018-10-01 00:00:00<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">integer for the iOS device\u2019s <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">ATT status<\/a>. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; not determined, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; restricted, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; denied, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; authorized<\/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\">Contact your Account Manager to access this table<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>acquired_at<\/td><td>timestamp when the user was acquired<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>ad_mediation_ad_format<\/td><td>Format of the Ad unit<\/td><td>Banner<\/td><\/tr><tr><td>ad_mediation_network<\/td><td>Network that displayed the ad<\/td><td>Applovin<\/td><\/tr><tr><td>ad_mediation_placement<\/td><td>Network defined placement<\/td><td>my_banner_placement<\/td><\/tr><tr><td>ad_mediation_provider<\/td><td>Ad mediation provider<\/td><td>Applovin MAX<\/td><\/tr><tr><td>ad_mediation_revenue_microcents<\/td><td>Ad revenue in microscents as provided by the mediation provider<\/td><td>22000<\/td><\/tr><tr><td>advertising_id<\/td><td>IDFA for iOS or Google advertising ID for Android. Lower case, without hyphen.<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>analytics_installation_id<\/td><td>Application install-specific identifier for Android devices. Used for analytics when a user does not consent to sharing their Google advertising id. (Empty for iOS.) Lower case, without hyphen.<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><tr><td>app_id<\/td><td class=\"translation-block\">Tenjin\u2019s internal app id. It can be joined with <code>id<\/code> in apps table<\/td><td>ee270433-b7da-4e0f-9b03-8dd25d89da49<\/td><\/tr><tr><td>app_version<\/td><td>app version<\/td><td>1.0.3<\/td><\/tr><tr><td>bundle_id<\/td><td>app&#8217;s bundle ID(we convert bundle_id to lowercase)<\/td><td>com.tenjin.wordfinder<\/td><\/tr><tr><td>country<\/td><td>country code<\/td><td>US<\/td><\/tr><tr><td>created_at<\/td><td>timestamp when the event was created<\/td><td>2018-11-01 00:00:00<\/td><\/tr><tr><td>creative_name<\/td><td>creative name<\/td><td>test_creative<\/td><\/tr><tr><td>customer_user_id<\/td><td>User ID from the app, as set by setCustomerUserId SDK method<\/td><td>jdabGcerT32_d<\/td><\/tr><tr><td>developer_device_id<\/td><td>IDFV for iOS. Empty for Android. Lower case, without hyphen<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>device<\/td><td>device type<\/td><td>iPAD 2.5<\/td><\/tr><tr><td>engaged_at<\/td><td>Timestamp for the click\/impression event the user interacted with before acquisition<\/td><td>2018-01-01 00:00:00<\/td><\/tr><tr><td>ip_address<\/td><td>user&#8217;s IP address<\/td><td>71.165.85.114<\/td><\/tr><tr><td>limit_ad_tracking<\/td><td>user&#8217;s limit ad tracking<\/td><td>(0,1)<\/td><\/tr><tr><td>loaded_at<\/td><td>timestamp when the record is updated in DataVault<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>os_version<\/td><td>device&#8217;s os_version<\/td><td>8.0<\/td><\/tr><tr><td>platform<\/td><td>app&#8217;s platform<\/td><td>8.0<\/td><\/tr><tr><td>sdk_version<\/td><td>User&#8217;s Tenjin SDK version<\/td><td>12.2.22<\/td><\/tr><tr><td>site_id<\/td><td>campaign&#8217;s publisher ID if the campaign is paid campaign<\/td><td>instagram<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">Tenjin\u2019s internal campaign id for the campaign user is attributed to. It can be joined with <code>id<\/code> in campaigns table<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>source_uuid<\/td><td>UUID for the impression event if the campaign was paid campaign. It can be joined with uuid in ad_engagements table<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">integer for the iOS device\u2019s <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">ATT status<\/a>. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; not determined, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; restricted, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; denied, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; authorized<\/td><td>3<\/td><\/tr><tr><td>uuid<\/td><td class=\"translation-block\">unique ID for the event. It can be joined with <code>source_uuid<\/code> events table<\/td><td>0df8ccda-372b-4e9e-8fdc-dfa0eb0c333e<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"19\">user_attributes <\/h4>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Column<\/th><th>Description<\/th><th>Example value<\/th><\/tr><\/thead><tbody><tr><td>advertising_id<\/td><td>IDFA for iOS or Google advertising ID for Android. Lower case, without hyphen.<\/td><td>29eeb1610fe74997b6d53f02e9711f8c<\/td><\/tr><tr><td>limit_ad_tracking<\/td><td>user&#8217;s limit ad tracking (0,1)<\/td><td>1<\/td><\/tr><tr><td>acquired_at<\/td><td>timestamp when the user was acquired<\/td><td>2018-07-01 00:00:00<\/td><\/tr><tr><td>country<\/td><td>country code<\/td><td>US<\/td><\/tr><tr><td>site_id<\/td><td>campaign&#8217;s publisher ID if the campaign is paid campaign<\/td><td>Instagram<\/td><\/tr><tr><td>developer_device_id<\/td><td>IDFV for iOS. Empty for Android. Lower case, without hyphen.<\/td><td>b6bc48fe0ce949e4b229ce6c55663fca<\/td><\/tr><tr><td>analytics_installation_id<\/td><td>Tenjin generated Application install-specific identifier. Lower case, without hyphen.<\/td><td>f024e65f3dd94f16983726bcef192d68<\/td><\/tr><tr><td>source_campaign_id<\/td><td class=\"translation-block\">Tenjin\u2019s internal campaign id for the campaign user is attributed to. It can be joined with <code>id<\/code> in campaigns table<\/td><td>18a0c1d6-02a2-4188-bbc0-0fe38dbcc37e<\/td><\/tr><tr><td>tracking_status<\/td><td class=\"translation-block\">integer for the iOS device\u2019s <a href=\"https:\/\/developer.apple.com\/documentation\/apptrackingtransparency\/attrackingmanager\/3547038-trackingauthorizationstatus\" target=\"_blank\">ATT status<\/a>. <code data-no-translation=\"\" data-no-auto-translation=\"\">0<\/code> =&gt; not determined, <code data-no-translation=\"\" data-no-auto-translation=\"\">1<\/code> =&gt; restricted, <code data-no-translation=\"\" data-no-auto-translation=\"\">2<\/code> =&gt; denied, <code data-no-translation=\"\" data-no-auto-translation=\"\">3<\/code> =&gt; authorized<\/td><td>3<\/td><\/tr><tr><td>last_seen<\/td><td>timestamp when the user was last seen<\/td><td>2018-07-01 00:00:00<\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Lookback window<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">These tables have limited historical data depending on the lookback window as mentioned in your Tenjin contract. If you want to know the lookback window for your DataVault, please contact your account manager at Tenjin.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>events<\/li>\n\n\n\n<li>ad_engagements<\/li>\n\n\n\n<li>reporting_metrics<\/li>\n\n\n\n<li>reporting_cohort_metrics<\/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\/tr\/blog\/author\/anurag\/"},"doc_category_info":[{"term_name":"DataVault","term_url":"https:\/\/tenjin.com\/tr\/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\/tr\/docs\/datavault-schema-and-tables\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\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\/tr\/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=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"14 dakika\" \/>\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\":\"tr\"},{\"@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\":\"tr\",\"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\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/tenjin.com\\\/#organization\",\"name\":\"Tenjin\",\"url\":\"https:\\\/\\\/tenjin.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@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\":\"tr\",\"@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\\\/tr\\\/blog\\\/author\\\/anurag\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DataVault Schema and Tables | Tenjin","description":"Tenjin's DataVault schema lies at the heart of its special sauce. All information from various places is nicely joined together through ids.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/tenjin.com\/tr\/docs\/datavault-schema-and-tables\/","og_locale":"tr_TR","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\/tr\/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":{"Est. reading time":"14 dakika"},"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":"tr"},{"@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":"tr","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":"tr"},{"@type":"Organization","@id":"https:\/\/tenjin.com\/#organization","name":"Tenjin","url":"https:\/\/tenjin.com\/","logo":{"@type":"ImageObject","inLanguage":"tr","@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":"tr","@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\/tr\/blog\/author\/anurag\/"}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/docs\/15474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/comments?post=15474"}],"version-history":[{"count":5,"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/docs\/15474\/revisions"}],"predecessor-version":[{"id":16790,"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/docs\/15474\/revisions\/16790"}],"wp:attachment":[{"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/media?parent=15474"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/doc_category?post=15474"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/glossaries?post=15474"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/tenjin.com\/tr\/wp-json\/wp\/v2\/doc_tag?post=15474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}