{"id":22733,"date":"2024-08-29T12:00:00","date_gmt":"2024-08-29T10:00:00","guid":{"rendered":"https:\/\/www.marketinet.com\/blog\/how-to-create-and-automate-a-filtered-data-extension-in-salesforce-marketing-cloud\/"},"modified":"2024-09-26T11:07:21","modified_gmt":"2024-09-26T09:07:21","slug":"how-to-create-automate-filtered-data-extension","status":"publish","type":"post","link":"https:\/\/www.marketinet.com\/en\/blog\/how-to-create-automate-filtered-data-extension\/","title":{"rendered":"How to create and automate a Filtered Data Extension in Salesforce Marketing Cloud"},"content":{"rendered":"

Salesforce Marketing Cloud is a leading digital marketing tool that helps you manage your marketing campaigns more efficiently and effectively<\/strong>. One of the most important features of Marketing Cloud is the ability to create and manage data extensions <\/strong>to optimize the segmentation and personalization of marketing campaigns.<\/p>\n

<\/p>\n

In this article, I will explain how to create a filtered data extension<\/strong> in Salesforce Marketing Cloud from scratch to improve the segmentation of your email marketing campaigns<\/strong>.<\/span><\/p>\n

Step 1: Create a \u201cFiltered Data Extension\u201d<\/strong><\/h2>\n

To get started, you must create a \u201cFiltered Data Extension\u201d in Marketing Cloud<\/strong>. A \u201cFiltered Data Extension\u201d allows you to filter your audience data from the beginning, without the need to create a filter in the original Data Extension.<\/p>\n

To create a \u201cFiltered Data Extension\u201d, select \u201cCreate\u201d<\/strong> in the \u201cData Extensions\u201d section, and then select \u201cFiltered Data Extension\u201d<\/strong>. Next, select a \u201cSource Data Extension\u201d <\/strong>(the original Data Extension that will be filtered) and create the filter.<\/p>\n

The process to create a filter is: select the \u201cFilter\u201d tab at the top of the page and define the filter criteria.<\/p>\n

Once you have created the filter, a filtered Data Extension will automatically be generated<\/strong>. You can use this filtered Data Extension to send your marketing campaigns directly, without the need to create a filter in the original Data Extension.<\/p>\n

\"Data<\/span><\/p>\n

Once you have created the filter, a filtered Data Extension will automatically be generated<\/strong>. You can use this filtered Data Extension to send your marketing campaigns directly, without the need to create a filter in the original Data Extension.<\/p>\n

Step 2: Verify and Save the Filter as a Data Filter<\/strong><\/h2>\n

Once you have added your filter, make sure to verify that the results of your filter are what you expect<\/strong>. Finally, save your filter by clicking on the \u201cSave as Filter<\/strong>\u201d button at the bottom left of the page.<\/p>\n

\u00a0\"Verificar<\/span><\/span><\/p>\n

Creating a \u201cFiltered Data Extension\u201d from scratch in Salesforce Marketing Cloud is an excellent way to segment and personalize your email marketing campaigns more efficiently.<\/strong> With this feature, you can significantly improve the effectiveness of your email marketing campaigns and increase your return on investment<\/strong>.<\/strong><\/p>\n

One of the advantages of the filtered Data Extension is that it can be automated to update regularly with data that meets the filtering criteria <\/strong>you have defined. This means you don\u2019t have to worry about manually updating your filtered Data Extension, which allows you to save time and resources.<\/p>\n

Next, I will explain how you can automate a filtered Data Extension in Salesforce Marketing Cloud.<\/p>\n

\"Guide<\/a><\/p>\n

Step 3: Create an Activity<\/strong><\/h2>\n

Before automating your filtered Data Extension, you must create an activity of the \u201cFilter\u201d type<\/strong>, which will later be step 1 of the automation. We have seen this in point 2 of the previous step.<\/p>\n

Once you have defined your filtering criteria, you must create an \u201cAutomation\u201d to automate the process of updating your filtered Data Extension. To do this, you must go to <\/strong>\u201cAutomation Studio\u201d and create an activity from the filter performed.<\/strong><\/p>\n

\"Crear<\/span><\/p>\n

Step 4: Set Up the Automation<\/strong><\/h2>\n

In the Automations section, select \u201cCreate Automation\u201d<\/strong> and as a trigger or start resource we put \u201cScheduled Automation\u201d<\/strong>. Then, set the frequency with which you want your filtered Data Extension to be updated<\/strong>, for example, every week or every month. Next, select the filtered Data Extension that you want to update and link it to a filtering activity.<\/p>\n

\"Configura<\/span><\/p>\n

Step 5: Execute the Automation<\/strong><\/h2>\n

Once you have set up your Automation, you can schedule it to run automatically<\/strong> according to the frequency you have defined. This means that your filtered Data Extension will automatically update<\/strong> with the data that meets the filtering criteria you have established, without the need for you to manually intervene in the process.<\/p>\n

We\u2019ve got it! Automating a filtered Data Extension in Salesforce Marketing Cloud<\/strong> allows you to save time and resources by automatically updating the data that meets the filtering criteria you have defined. This makes it easier for you to send personalized messages tailored to the needs and preferences of your customers<\/strong>, which can significantly improve the effectiveness of your marketing campaigns.<\/strong><\/p>\n

Anyway, you will surely see it much clearer if you visualize how to do it in this video (in spanish).<\/strong><\/p>\n

\n