{"id":29279,"date":"2022-05-23T10:45:00","date_gmt":"2022-05-23T10:45:00","guid":{"rendered":"https:\/\/www.emizentech.com\/blog\/?p=29279"},"modified":"2022-05-23T10:45:04","modified_gmt":"2022-05-23T10:45:04","slug":"data-extension-in-email-studio-salesforce-marketing-cloud","status":"publish","type":"post","link":"https:\/\/multisitelocal.ezxdemo.com\/blog\/data-extension-in-email-studio-salesforce-marketing-cloud.html","title":{"rendered":"Data Extension in Email Studio: Salesforce Marketing Cloud"},"content":{"rendered":"\n<p>In Marketing Cloud, creating a Data Extension is an important aspect that you need to learn.&nbsp;<\/p>\n\n\n\n<p>Well, it may be tricky to learn this topic, but let you know that there are various ways to create a Data Extension. However, you can get confused when adding contacts to it.&nbsp;<\/p>\n\n\n\n<p>In this post, we will put forward an easy way to set up a Data Extension through Email Studio. However, you can create a Data Extension using Contact Builder also.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Know_about_Data_Extension\"><\/span>Know about Data Extension<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The Data Extensions application in <a href=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/build-emails-with-content-builder-in-salesforce-marketing-cloud.html\">Marketing Cloud Email<\/a> Studio is a table within the database that contains your customer data. Data extensions can be standalone and also related to other data extensions. You can <a href=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/data-loader-vs-import-wizard.html\">import data<\/a> extensions manually, or you can automate the import functionality through Automation Studio or the Marketing Cloud API. With the SOAP API, You can update, create and delete rows in a data extension.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Introduction to Marketing Cloud Email Studio\" width=\"770\" height=\"433\" src=\"https:\/\/www.youtube.com\/embed\/nRhftldmmyc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"527\" src=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image5-2-1024x527.png\" alt=\"Data Extension\" class=\"wp-image-29284\" srcset=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image5-2-1024x527.png 1024w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image5-2-300x154.png 300w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image5-2-768x395.png 768w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image5-2.png 1210w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Data extensions from Contact Creator and Email Studio can be used, but the data extensions permissions, sharing, and other functionality are contained in Email Studio. The data extension consists of information either entered manually or imported through a file.<\/p>\n\n\n\n<p>Note: You can also create a data extension from the contact creator.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Types_of_Data_Extensions\"><\/span>Types of Data Extensions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There are three types of data extensions in the Marketing Cloud which we will discuss below:-<\/p>\n\n\n\n<p><strong>Standard &#8211;<\/strong> A standard data extension allows the user to create various fields that allow you to store your customer&#8217;s data.<\/p>\n\n\n\n<p><strong>Filtered &#8211; <\/strong>The filtered data extension is essentially a filtered view over another data extension. It is refreshed to update its data based on any changes to the original extension.<\/p>\n\n\n\n<p><strong>Random &#8211; <\/strong>Random data extension enables the segmentation of clients contained in a data extension into several other data extensions. This is especially useful for creating A\/B tests.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"593\" height=\"611\" src=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image2-3.png\" alt=\"create data extension\" class=\"wp-image-29281\" srcset=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image2-3.png 593w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image2-3-291x300.png 291w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Steps_to_Create_a_Data_Extension\"><\/span>Steps to Create a Data Extension<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>In <a href=\"https:\/\/multisitelocal.ezxdemo.com\/salesforce-marketing-cloud.html\">Marketing Cloud<\/a>, Email Studio on the top left menu and click Email.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"957\" height=\"402\" src=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image6-2.png\" alt=\" Marketing Cloud, Email Studio\" class=\"wp-image-29285\" srcset=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image6-2.png 957w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image6-2-300x126.png 300w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image6-2-768x323.png 768w\" sizes=\"(max-width: 957px) 100vw, 957px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\"><li>Hover over Subscribers and click on Data Extensions.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"527\" src=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image5-2-1024x527.png\" alt=\"Data Extension\" class=\"wp-image-29284\" srcset=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image5-2-1024x527.png 1024w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image5-2-300x154.png 300w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image5-2-768x395.png 768w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image5-2.png 1210w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li>Navigate to the top right of your screen and click on the Create button.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"476\" src=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image7-2-1024x476.png\" alt=\"Navigate to the top right\" class=\"wp-image-29286\" srcset=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image7-2-1024x476.png 1024w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image7-2-300x139.png 300w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image7-2-768x357.png 768w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image7-2.png 1065w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li>You will get a popup and here, you can select the standard data extension.<\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"593\" height=\"611\" src=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image2-3.png\" alt=\"create data extension\" class=\"wp-image-29281\" srcset=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image2-3.png 593w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image2-3-291x300.png 291w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/figure><\/div>\n\n\n\n<p>After clicking on the OK button, you will form to fill.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Create Method &#8211;<\/strong> Choose whether you want to create a new data extension, copy from an existing data extension, and create a data extension based on the template.<\/li><li><strong>Name &#8211; <\/strong>Give your data extension a name from the Name field.<\/li><li><strong>External Key \u2013<\/strong> It is used to uniquely identify the data extension using API calls.<\/li><li><strong>Description &#8211; <\/strong>This field is used to give details about the data extension.<\/li><li><strong>Type &#8211; <\/strong>This is the data extension type that you have selected.<\/li><li><strong>Sendable\/Testable \u2013 <\/strong>Selecting these fields means whether you want to send the data extension as a direct communication or not. The testable field is for whether to send test message with a data extension or not.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"685\" src=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image1-4-1024x685.png\" alt=\"create new data extension\" class=\"wp-image-29280\" srcset=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image1-4-1024x685.png 1024w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image1-4-300x201.png 300w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image1-4-768x514.png 768w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image1-4-600x400.png 600w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image1-4-270x180.png 270w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image1-4-770x515.png 770w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image1-4.png 1073w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Retention setting \u2013 <\/strong>This option is used to set how long you want to keep your data in the data extension.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"680\" src=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image4-2-1024x680.png\" alt=\"create new data extensions\" class=\"wp-image-29283\" srcset=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image4-2-1024x680.png 1024w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image4-2-300x199.png 300w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image4-2-768x510.png 768w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image4-2-270x180.png 270w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image4-2-370x245.png 370w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image4-2.png 1081w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Fields Tab &#8211; <\/strong>Here, you can create your own data fields with their data types as per your requirement.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"681\" src=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image3-2-1024x681.png\" alt=\"Fields Tab\" class=\"wp-image-29282\" srcset=\"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image3-2-1024x681.png 1024w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image3-2-300x199.png 300w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image3-2-768x511.png 768w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image3-2-600x400.png 600w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image3-2-270x180.png 270w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image3-2-370x245.png 370w, https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/image3-2.png 1074w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How to create a Data Extension using Email Studio (SFMC Data Tutorial #01)\" width=\"770\" height=\"433\" src=\"https:\/\/www.youtube.com\/embed\/lpLEjb3iLkw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>At last, we can say the data extension is handy and essential for creating. It permits access to details about contacts and uses that information to filter segments and target contacts with related sends. Also, this information is best to target contacts across various channels, like social, email, and mobile messaging.&nbsp;<\/p>\n\n\n\n<p>We hope this guide appears to be helpful for you and may allow you to quickly learn essential tips to create Data Extension in Email Studio. For any other professional <a href=\"https:\/\/multisitelocal.ezxdemo.com\/salesforce.html\">Salesforce development service<\/a> please get in touch with us.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Marketing Cloud, creating a Data Extension is an important aspect that you need to learn.&nbsp; Well, it may be tricky to learn this topic, but let you know that there are various ways to create a Data Extension. However, you can get confused when adding contacts to it.&nbsp; In this post, we will put<\/p>\n","protected":false},"author":39,"featured_media":29360,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"MSN_Categories":"Uncategorized","MSN_Publish_Option":false,"MSN_Is_Local_News":false,"MSN_Is_AIAC_Included":"Empty","MSN_Location":"[]","MSN_Add_Feature_Img_On_Top_Of_Post":false,"MSN_Has_Custom_Author":false,"MSN_Custom_Author":"","MSN_Has_Custom_Canonical_Url":false,"MSN_Custom_Canonical_Url":"","_lmt_disableupdate":"no","_lmt_disable":"no","footnotes":""},"categories":[87],"tags":[],"class_list":{"0":"post-29279","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-salesforce-development"},"modified_by":"Marketing EmizenTech","featured_image_src":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/Data-Extension-in-Email-Studio-Salesforce-Marketing-Cloud-600x400.jpg","featured_image_src_square":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/05\/Data-Extension-in-Email-Studio-Salesforce-Marketing-Cloud-600x600.jpg","author_info":{"display_name":"Virendra Sharma","author_link":"https:\/\/multisitelocal.ezxdemo.com\/blog\/author\/salesforce"},"_links":{"self":[{"href":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-json\/wp\/v2\/posts\/29279","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-json\/wp\/v2\/comments?post=29279"}],"version-history":[{"count":0,"href":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-json\/wp\/v2\/posts\/29279\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-json\/wp\/v2\/media\/29360"}],"wp:attachment":[{"href":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-json\/wp\/v2\/media?parent=29279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-json\/wp\/v2\/categories?post=29279"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/multisitelocal.ezxdemo.com\/blog\/wp-json\/wp\/v2\/tags?post=29279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}