Set Up Datasets

In this article, you'll configure your first Dataset in GrowthLoop. Adding a dataset takes seconds to begin using for activation. We'll walk through each step together.

Create Dataset

1. Navigate to Datasets in the left menu rail
2. You can see all Datasets your team has connected to GrowthLoop
3. Select Add Dataset
4. Select your Dataset Type
5. Select your Table or Model you'd like to use for this Dataset

Configure Dataset

1. Provide Table Alias: Table aliases will appear in the Audience and Journey builders to make it easier for others to recognize and use your Dataset. We recommend putting in a name others in your organization will recognize.

2. Add Table Description: Insert a table description so others on your team will know what type of data they can find and use in this Dataset when creating Audiences and Journeys.

3. Select unique key: Your unique key is a field on your table that is distinctive for each row in the table.

   The reason why a unique is needed is simply to avoid duplicating data which results in wrong queries. This happened to our customers a lot before we added this feature. The goal would be to de-duplicate data in the warehouse with a query or to use a unique key combination.
   Keep in mind that you can also set composite key by adding additional keys in the image below.

1. We will check your table to ensure your key is unique.

📘

Don't have a Unique Key?

If your table does not have a unique key, you can use a Composite Key. You can select multiple fields on your table. Our platform will append those fields and check if the composite key is unique to every record on your table. This is a great way to leverage our platform even when you do not have a single unique column on a table.

4. Configure fields: Configure the fields in your dataset.
   1. Type: This shows the data type of the column that we detected for your Dataset. This is detected directly from your source schema.
   2. Show by Default: Select fields you will want to show up in the Audience Builder and Journey Canvas when a user selects targeting. All fields will be available from your Dataset, but the fields designate as Show by default will appear on the page, always making them more accessible to users.

5. Tag PII Fields: Protect certain columns from being viewed in platform.
   1. GrowthLoop blocks PII Fields from appearing as filters in your Audience Builder.
   2. Tagging columns as PII Fields also prevents users from downloading any CSVs with this data.
   3. Note: PII Fields can still be used as personalization signals that are sent to marketing destinations to personalize messages. To restrict this ability, you should Exclude from Personalization.
6. Exclude from Personalization: You can exclude fields from being used as personalization in exports. Users will not be able to add these as fields for audience exports. This is valuable if there is certain data, like revenue, you do not want going to any marketing destinations or CSV.

7. Label: Label the fields in your Datasets so they are easier to use in the application for your team. This helps your team know what type of data is in each column and unlocks Recipes for your team to use in the platform. More details on Recipes can be found here.

---

👍

Your dataset is now configured in GrowthLoop

Your dataset can now be used to create:

• Overview Must add your dataset to a specific Dataset Group
• Audiences: Must add your dataset to a specific Dataset Group
• Journeys: Must add your dataset to a specific Dataset Group

If you are experiencing any issues with GrowthLoop? Reach out to us at [email protected] and we’ll be in touch shortly!