What is a marketing cloud data extension

A data extension refers to a table in the Salesforce Marketing Cloud containing information about your subscribers such as name, address, age, gender, email, city. It allows you to track and update your customer’s data via, for instance, a form of data submitted through a home page or through Salesforce object records.

Where are data extension in Marketing Cloud?

Here is how to create a Data Extension using Email Studio. Once you’re inside Email Studio, you can navigate to ‘ Subscribers’ → Data Extensions in the drop down. This brings me to the overview screen. If you’re new to Marketing Cloud, these data extensions may be there by default because they are system generated.

How do I use data extension in Marketing Cloud?

1. Click Subscribers.
2. Click Data Extensions.
3. Click Create and choose an option: …
4. Enter information in the Properties section: …
5. Complete the information in the Type section: …
6. Complete the information in the Fields section for each field. …
7. Click Save.

What are data extensions?

A data extension is simply a table with fields of data about your contacts. Data extensions can be standalone or related to other data extensions. … Standard data extensions are used for building a custom set of fields. Filtered data extensions are used to create a subset/segment from an existing data extension.

What are the types of data extensions?

• Text – letters, numbers, and spaces.
• Number – Decimal values are not supported.
• Date – A system date. …
• Boolean – A 0 or 1 value.
• Email Address – An email address.
• Phone – A phone number. …
• Decimal – A number with a decimal point.

What is a random data extension?

A random data extension splits up subscribers from a selected standard data extension and places the subscribers into new data extensions in Marketing Cloud Email Studio. You can create as many as 12 data extensions at a time. … Select a source data extension of records to split. Click OK.

What is the difference between list and data extension in marketing cloud?

There are two different methods to store and segment subscriber data within Marketing Cloud: Lists and Data Extensions. Lists have limited functionality, whereas Data Extensions provide full flexibility to store and relate subscriber information.

What three methods are used to import data into a data extension?

• File Name: Type MasterSubscriber. csv.
• Delimiter: Comma.
• Date Format: English.

How do I create a filtered data extension?

1. Hover over Subscribers.
2. Click Data Extensions.
3. Click Create.
4. Select Filtered Data Extension.
5. Click OK.
6. Select a standard data extension to filter as the source data extension.
7. Click OK.
8. Drag Fields, Filters, or Measure from the left column to the Create Filter canvas.

What is email Studio in marketing cloud?

Email Studio is a very important part of the Salesforce Marketing Cloud, it is used to build and send personalized emails from basic newsletters to the most complex campaigns, deliver promotional, transactional, and triggered messages and also track and optimize to drive performance.

Article first time published on

What is Salesforce Marketing Cloud Connect?

Marketing Cloud Connect combines the digital marketing capabilities of Marketing Cloud with the data management, segmentation, and campaign management tools in Salesforce. Create unitary customer relationships with more data-driven, personalized conversations and the ability to automate the customer journey.

Where is contact builder in marketing cloud?

Within Salesforce Marketing Cloud, click on your name (top right), and then click on ‘Setup’. There, under ‘Users’, you can assign roles to define access to Contact Builder. As recommended earlier, you can also create customer roles. To do so, click on ‘Roles’, and click on ‘Create’ to define a new custom role.

What is a list in marketing cloud?

Lists are a default method of storing data in Marketing Cloud Email Studio. You can set different attributes to your subscribers using lists, which represent a collection of subscribers and provide a simple method for audience segmentation. These attributes are used to store a subscriber’s status within a given list.

Is Sendable and is testable?

Is Sendable – Indicates whether you intend this data extension to have messages sent to it. This checkbox determines whether the data extension is available to use as part of sends. Is Testable – If you select Is Sendable, this field indicates whether you intend this data extension to have test messages sent to it.

How do I create a list in marketing cloud?

1. Hover over Subscribers.
2. Click Lists.
3. Click Create.
4. Complete the Define Name & Location section: Name -This name identifies the list when sending. …
5. Click Next.
6. Optional, complete the Set Double Opt-in section, as follows: …
7. Click Next.
8. Optional, complete the Select Welcome Email section, as follows:

How do I create an automation in Marketing Cloud?

1. In Marketing Cloud, navigate to Automation Studio.
2. Click New Automation.
3. Select Schedule.
4. Click Ok.
5. Name the Automation.
6. Drag Salesforce Email Send activity onto the canvas.
7. Click Choose.
8. Select Day 1 Test.

How do you refresh a filtered data extension in Marketing Cloud?

1. Select the checkbox next to the filtered data extension to refresh.
2. Click Refresh under Actions.
3. Click OK in the confirmation dialog box that appears. The application scans all records data and rebuilds the filtered data extension.

How do data filters work in Marketing Cloud?

1. Choose Subscribers | Data Filters.
2. Click Create.
3. To filter records from a data extension, choose Data Extension. …
4. Click OK.
5. Choose a source data extension to filter.
6. Click OK.
7. Drag Fields, Measure, or saved filters to the Create Filter canvas.

What is shared extension?

Shared Data Extension: are data extensions that can be shared across business units. They have specific permissions setting which allows to define to which business units, the data extension and its’ data can be shared.

How can you segment a data extension?

1. Hover over the Salesforce blue cloud to display the main Marketing Cloud navigation bar.
2. Hover over Email Studio.
3. Click Email.
4. Hover over Subscribers.
5. Select Data Filters.
6. Click Create.
7. Select Data Extension.
8. Select the source data extension: MasterSubscriber.

How is data stored in Salesforce Marketing Cloud?

In most databases, data is stored in a table with columns to define the data stored in rows. … In Marketing Cloud, a table is called a data extension. A column is an attribute, and a row of data is a record. Sales Cloud contains objects and fields to talk about tables and columns.

What is a filtered data extension?

A filtered data extension is generated by filtering fields, filters, and measures. Filtered data extension takes on the same characteristics as the source data extension. To update a filtered data extension to sendable or non-sendable, change the source data extension to sendable or non-sendable. … Click Data Extensions.

What is the difference between Automation Studio and Journey builder?

With Automation Studio, marketers can create highly-complex segmentation across a high volume of data and from multiple sources. … Journey Builder is where you send your segmented audiences through highly-specific, customized journeys based on the data within the Marketing Cloud.

Where is automation studio in Marketing Cloud?

Getting Started with Automation Studio At the top, you will see the various studios and builders that are available based on your Marketing Cloud edition. Find Automation Studio under the ‘Journey Builder’. Inside Automation Studio there are two primary tabs – the overview, and the activities.

How do you add data to data extension?

1. Click Data Extensions.
2. Click the applicable data extension.
3. Click the Records tab.
4. Click Add Records.
5. Enter information for the available fields.
6. Save your work.

How are publication lists used in the Marketing Cloud?

Publication Lists in Marketing Cloud help you manage how subscribers receive different categories of emails or SMS messages. … When a Subscriber opts-out from a publication list, then their subscription status is updated against that corresponding list.

In which of the following cases is it appropriate to use a data extension as a data model?

Use data extensions when: Your lists contain more than 500,000 subscribers. You support multiple subscriber data sets, with separate values. You send global messages.

What is Web Studio in Marketing Cloud?

Web Studio let you collect customer data and create personalised content for landing pages, microsites and mobile apps. From here you will be able to create and manage all your web content and publish it across the web or your mobile apps.

How do I access Salesforce Marketing Cloud?

1. Navigate to Email Studio —> Click Admin ——> Click Salesforce Integration —–> Click Edit.
2. Select Scope by User if applicable for your data access configuration.
3. If prompted, click Upgrade to Connected App ——->Click Connect Account.

What is Journey builder in Marketing Cloud?

Salesforce Journey Builder is a feature of the company’s Marketing Cloud that manages the customer life cycle: the progression of steps a customer goes through when considering, purchasing, using and maintaining loyalty to a brand.

How do I connect marketing cloud to service cloud?

1. In Service Cloud, navigate to Setup.
2. Click Create.
3. Click Apps.
4. Click New.
5. Enter Marketing Cloud for the app label and name to create the app.
6. Add a logo if desired.
7. Customize tabs and add Marketing Cloud , Email Sends , and Send Analytics .