{"id":67007,"date":"2026-08-18T16:08:55","date_gmt":"2026-08-18T16:08:55","guid":{"rendered":"https:\/\/www.sogolytics.com\/help\/?page_id=67007"},"modified":"2026-08-19T00:34:12","modified_gmt":"2026-08-19T00:34:12","slug":"create-and-configure-derived-fields","status":"publish","type":"page","link":"https:\/\/www.sogolytics.com\/help\/create-and-configure-derived-fields\/","title":{"rendered":"Create and Configure Derived Fields"},"content":{"rendered":"<style>\n\/* Offset anchor jumps so headings aren't hidden behind the fixed help header *\/\nh2[id], h3[id] {\n  scroll-margin-top: 100px;\n}\n<\/style>\n<p>A <strong>Derived Field<\/strong> is a Directory field whose value is calculated automatically from the value held in your other fields, rather than entering it manually; define the formula once and watch the magic happen!<\/p>\n<p>It operates in the same way as a spreadsheet formula: when the values it references change, the result is recalculated automatically. There is no need to export your contacts, calculate the values in a separate tool, and import them back in.<\/p>\n<p>For example, if your Customer Directory records each Purchase and its Product Cost, a Derived Field can automatically total how much a customer has spent into a <strong>Total Expense<\/strong> field. You can also go a step further and use that total to automatically sort each customer into an <strong>Expense Category<\/strong> \u2014 for example, Platinum, Gold, Silver, or Bronze. Both fields keep themselves up to date whenever a purchase is added or a cost changes.<\/p>\n<p>With Derived Fields you can:<\/p>\n<ul>\n<li>Calculate new values from data already held in your Directory \u2014 for example, a customer&rsquo;s days since their last purchase, total spend, or age \u2014 with no manual calculation.<\/li>\n<li>Have AI review your Directory and propose ready-made fields \u2014 each with its formula already defined.<\/li>\n<li>Describe the field you want to create in plain English as a prompt, and have AI generate its formula; no knowledge of formula syntax is required.<\/li>\n<li>Compose your own formula in a dedicated editor, selecting from a searchable list of your fields and ready-made functions.<\/li>\n<li>Preview the values a field would produce against a sample of real records before saving, to confirm that the results are correct.<\/li>\n<li>Use the completed field anywhere your other Directory fields are already used \u2014 in filters, dashboards, reports, exports, surveys, and distribution.<\/li>\n<\/ul>\n<p><img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/derivedfield1.png\" \/><\/p>\n<p><em>The Customer Directory with derived columns \u2014 customer_age, purchase_recency_bucket, and days_since_last_purchase \u2014 each marked with the fx badge.<\/em><\/p>\n<h3>In this article<\/h3>\n<ul>\n<li><a href=\"#how-derived-fields-work\">How Derived Fields work<\/a><\/li>\n<li><a href=\"#where-to-find\">Where to find Derived Fields<\/a><\/li>\n<\/ul>\n<h2 id=\"how-derived-fields-work\">How Derived Fields work<\/h2>\n<ul>\n<li>Choose how to build the field \u2014 let AI suggest one, create it manually by describing it in plain English, or write your own formula.<\/li>\n<li>Preview the result against a sample of real records to confirm it is correct.<\/li>\n<li>Save. The platform calculates the value and refreshes it on the schedule you select.<\/li>\n<\/ul>\n<p>Throughout this article we follow one retail company planning retention and reactivation campaigns. To target them, it needs to know how recently each customer last bought something and to group customers accordingly \u2014 impractical to calculate by hand across thousands of customers.<\/p>\n<p>The data already exists: the Retail Customer Directory shown above holds one record per customer, and a linked Purchase History activity holds one record per purchase (with fields such as Purchase Date and Amount). From this, the company creates two Derived Fields \u2014 generated automatically rather than entered manually:<\/p>\n<ul>\n<li><strong>Days Since Last Purchase<\/strong> \u2014 for each customer, the feature finds the latest Purchase Date in Purchase History and counts the days to today.<\/li>\n<li><strong>Purchase Recency Bucket<\/strong> \u2014 applies a rule to that count: 0&ndash;30 days is Recent, 31&ndash;90 is Warm, 91+ is Lapsed.<\/li>\n<\/ul>\n<p>Both appear as new columns against every customer in the directory, marked with the fx badge, and refresh automatically as purchases come in. The table below shows the result for three customers.<\/p>\n<table>\n<thead>\n<tr>\n<th>Customer<\/th>\n<th>Purchases<\/th>\n<th>Days Since Last Purchase<\/th>\n<th>Recency Bucket<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Customer 1<\/td>\n<td>12<\/td>\n<td>8<\/td>\n<td>Recent<\/td>\n<\/tr>\n<tr>\n<td>Customer 2<\/td>\n<td>8<\/td>\n<td>60<\/td>\n<td>Warm<\/td>\n<\/tr>\n<tr>\n<td>Customer 3<\/td>\n<td>3<\/td>\n<td>200<\/td>\n<td>Lapsed<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h2 id=\"where-to-find\">Where to find Derived Fields<\/h2>\n<ol>\n<li>Open the Directory you want to work in. In this example, that is the Retail Customer Directory.<\/li>\n<li>Click the three-dot menu and select <strong>Manage Fields<\/strong>. The modal lists every field in the Directory.<br \/>\n  <img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/derivedfield2.png\" \/><\/li>\n<li>Click <strong>Create Derived Field<\/strong>. This opens the creation screen.<br \/>\n  <img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/derivedfield3.png\" \/><\/li>\n<li>Choose how you want to build the field: <strong>AI Suggestions<\/strong> or <strong>Create Manually<\/strong>.<br \/>\n  <img decoding=\"async\" src=\"\/help\/wp-content\/uploads\/derivedfield4.png\" \/><\/li>\n<\/ol>\n<div class=\"sogo-help-info-box\">\n<i class=\"fal fa-info-circle\"><\/i><\/p>\n<p class=\"sogo-info-text\"><strong>Tip:<\/strong> To return to Manage Fields without creating a field, click <strong>Back<\/strong> in the header. Nothing is saved until you create the field.<\/p>\n<\/div>\n<hr \/>\n<h2 id=\"see-also\">See also<\/h2>\n<ul>\n<li><a href=\"\/help\/create-derived-fields-from-ai-suggestions\/\" rel=\"noopener\">Create Derived Fields from AI Suggestions<\/a><\/li>\n<li><a href=\"\/help\/define-a-derived-field-manually\/\" rel=\"noopener\">Define a Derived Field Manually<\/a><\/li>\n<li><a href=\"\/help\/derived-field-function-reference\/\" rel=\"noopener\">Function Reference<\/a><\/li>\n<li><a href=\"\/help\/managing-and-using-derived-fields\/\" rel=\"noopener\">Managing and Using Derived Fields<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>A Derived Field is a Directory field whose value is calculated automatically from the value held in your other fields, rather than entering it manually; define the formula once and watch the magic happen! It operates in the same way as a spreadsheet formula: when the values it references change, the result is recalculated automatically. There is no need to export your contacts, calculate the values in a separate tool, and import them back in. For example, if your Customer Directory records each Purchase and its Product Cost, a Derived Field can automatically total how much a customer has spent into a Total Expense field. You can also go a step further and use that total to automatically sort each customer into an Expense Category \u2014 for example, Platinum, Gold, Silver, or Bronze. Both fields keep themselves up to date whenever a purchase is added or a cost changes. With Derived Fields you can: Calculate new values from data already held in your Directory \u2014 for example, a customer&rsquo;s days since their last purchase, total spend, or age \u2014 with no manual calculation. Have AI review your Directory and propose ready-made fields \u2014 each with its formula already defined. Describe the field you want to create in plain English as a prompt, and have AI generate its formula; no knowledge of formula syntax is required. Compose your own formula in a dedicated editor, selecting from a searchable list of your fields and ready-made functions. Preview the values a field would [&hellip;]<\/p>\n","protected":false},"author":30,"featured_media":0,"parent":0,"menu_order":66,"comment_status":"closed","ping_status":"closed","template":"sogo_new_design.php","meta":{"_acf_changed":false,"footnotes":""},"categories":[526],"tags":[465,463],"class_list":["post-67007","page","type-page","status-publish","hentry","category-derived-fields","tag-build-directory-using-a-file","tag-directory"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Create and Configure Derived Fields | Sogolytics<\/title>\n<meta name=\"description\" content=\"Learn how Derived Fields calculate Directory values automatically from your other fields, how they work, and where to find them in your Directory.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sogolytics.com\/help\/create-and-configure-derived-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create and Configure Derived Fields | Sogolytics\" \/>\n<meta property=\"og:description\" content=\"Learn how Derived Fields calculate Directory values automatically from your other fields, how they work, and where to find them in your Directory.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sogolytics.com\/help\/create-and-configure-derived-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"Sogolytics\" \/>\n<meta property=\"article:modified_time\" content=\"2026-08-19T00:34:12+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/create-and-configure-derived-fields\\\/\",\"url\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/create-and-configure-derived-fields\\\/\",\"name\":\"Create and Configure Derived Fields | Sogolytics\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/#website\"},\"datePublished\":\"2026-08-18T16:08:55+00:00\",\"dateModified\":\"2026-08-19T00:34:12+00:00\",\"description\":\"Learn how Derived Fields calculate Directory values automatically from your other fields, how they work, and where to find them in your Directory.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/create-and-configure-derived-fields\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/create-and-configure-derived-fields\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/create-and-configure-derived-fields\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create and Configure Derived Fields\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/#website\",\"url\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/\",\"name\":\"Sogolytics\",\"description\":\"Sogolytics - Online Survey Tool\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sogolytics.com\\\/help\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create and Configure Derived Fields | Sogolytics","description":"Learn how Derived Fields calculate Directory values automatically from your other fields, how they work, and where to find them in your Directory.","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:\/\/www.sogolytics.com\/help\/create-and-configure-derived-fields\/","og_locale":"en_US","og_type":"article","og_title":"Create and Configure Derived Fields | Sogolytics","og_description":"Learn how Derived Fields calculate Directory values automatically from your other fields, how they work, and where to find them in your Directory.","og_url":"https:\/\/www.sogolytics.com\/help\/create-and-configure-derived-fields\/","og_site_name":"Sogolytics","article_modified_time":"2026-08-19T00:34:12+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sogolytics.com\/help\/create-and-configure-derived-fields\/","url":"https:\/\/www.sogolytics.com\/help\/create-and-configure-derived-fields\/","name":"Create and Configure Derived Fields | Sogolytics","isPartOf":{"@id":"https:\/\/www.sogolytics.com\/help\/#website"},"datePublished":"2026-08-18T16:08:55+00:00","dateModified":"2026-08-19T00:34:12+00:00","description":"Learn how Derived Fields calculate Directory values automatically from your other fields, how they work, and where to find them in your Directory.","breadcrumb":{"@id":"https:\/\/www.sogolytics.com\/help\/create-and-configure-derived-fields\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sogolytics.com\/help\/create-and-configure-derived-fields\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sogolytics.com\/help\/create-and-configure-derived-fields\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sogolytics.com\/help\/"},{"@type":"ListItem","position":2,"name":"Create and Configure Derived Fields"}]},{"@type":"WebSite","@id":"https:\/\/www.sogolytics.com\/help\/#website","url":"https:\/\/www.sogolytics.com\/help\/","name":"Sogolytics","description":"Sogolytics - Online Survey Tool","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sogolytics.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"seo_meta_info":{"yoast_noindex":"","rankmath_noindex":"","yoast_title":"Create and Configure Derived Fields | Sogolytics","yoast_desc":"Learn how Derived Fields calculate Directory values automatically from your other fields, how they work, and where to find them in your Directory.","rankmath_title":"Create and Configure Derived Fields","rankmath_desc":"\/* Offset anchor jumps so headings aren't hidden behind the fixed help header *\/ h2[id], h3[id] { scroll-margin-top: 100px; } A Derived Field is a&hellip;"},"_links":{"self":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/67007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/users\/30"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/comments?post=67007"}],"version-history":[{"count":5,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/67007\/revisions"}],"predecessor-version":[{"id":67085,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/pages\/67007\/revisions\/67085"}],"wp:attachment":[{"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/media?parent=67007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/categories?post=67007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sogolytics.com\/help\/wp-json\/wp\/v2\/tags?post=67007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}