What are marketing cloud data extensions

A data extension is a table that contains your data. With Marketing Cloud Connect, push tracking data from the Marketing Cloud back to your Sales or Service Cloud orgs using Salesforce data extensions (SFDEs). … Data extensions created from sends to reports or campaigns have a hard-coded retention policy of five days.

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.

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.

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 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 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.

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 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. Hover over Subscribers.

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

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

What are lists 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.

Article first time published on

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:

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.

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.

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.

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.

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.

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.

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.

What is a send relationship?

Send Relationship – A Send Relationship defines a field in the Sendable data extension to map to Subscriber Key in All Subscribers when sending. E.G. a Data Extension may use Email Address to map to the Subscriber Key in the All Subscribers table, which houses the entire database in Marketing Cloud.

What is a suppression list in Marketing Cloud?

A suppression list is a list of subscribers that you don’t want to receive your communications. … Suppression lists filter out email addresses and prevent those addresses from receiving your messages. Suppression lists serve as a “do not contact” list for your email sends.

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 I import data from Salesforce to Marketing Cloud?

1. Hover over Subscribers.
2. Click Data Extensions.
3. Under Actions click Import for the data extension to import into.
4. Complete the Import Into Data Extension dialog box: …
5. Click Next.
6. Complete the Configure Mapping dialog box that appears. …
7. Click Next.

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.

How do you split data extensions in marketing cloud?

1. Hover over Subscribers.
2. Click Data Extensions.
3. Click Create.
4. Select Random Data Extension.
5. Click OK.
6. Select a source data extension of records to split.
7. Click OK.
8. Click Add Data Extension. Enter a name for the data extension.

How do I select random records in Salesforce?

First get a count of the records created that day. Integer size = Database. getCountQuery(‘select count() from Opportunity where CreatedDate = TODAY’); Then use OFFSET to get your random record.

What are profile attributes marketing cloud?

Email Studio uses profile and preference attributes to store information about subscribers. The profile attribute contains information to characterize a subscriber profile. For example, each subscriber is asked to provide their birth date, and email address.

How many subscribers can you have in a list Marketing Cloud?

We recommend sending to a maximum of 50 lists. If you exceed 50 lists, you can have trouble viewing tracking for that send. When sending to data extensions or an audience check De-duplicate subscribers by email address if you do not want subscribers to receive multiple emails.

What is Subscriber key in marketing cloud?

A subscriber key is a text field that contains a value that uniquely identifies a subscriber in your Marketing Cloud account. Marketing Cloud Connect uses subscriber key to identify the Sales or Service Cloud record associated with the tracking data returned from the Marketing Cloud.