Send a segment of customers at risk of churn to Azure Blob Storage

Synerise allows you to collect data from any touchpoint with a customer. With advanced Synerise Analytics, you can create precise customer segments that you can use not only in Synerise, but also pass them to external tools. Using Synerise’s seamless integration with Azure Blob Storage, you can transfer any data collected in Synerise and use it in other Microsoft tools.

In this use case, we will export a database of customers at risk of churn to Azure Blob Storage. To create a segmentation of customers at risk of churn, we will use the RFM analysis results from this use case. This is just an example. You can export any other data types according to your needs, such as transactions, event data, metrics results, aggregates, expressions, reports, and much more.

Prerequisites

• You must have an account on Azure AD.
• Create an RFM analysis thanks to which you will be able to define the segmentation of customers at risk of churn. You’ll find a detailed process for creating the RFM analysis in this use case.

Process

In this use case, you will go through the following steps:

• Create a segmentation of customers at risk of churn.
• Create a workflow that sends selected customer profiles to Azure Blob Storage.

Create a segmentation of customers at risk of churn

In this part of the process, create a segmentation of customers at risk of churn based on the RFM segmentation you created earlier.

1. Go to Analytics > Segmentations V2 > New segmentation.
2. Enter the name of the segment.
3. Choose Has property and find the RFM segmentation you created earlier.
4. Select the Equal operator and in the right field enter the name of the sub-segment that defines the customers at risk of churn. In this use case, it’s Churn risk
5. Save the aggregate.

Prepare a workflow

As the final part of the process, create a workflow which sends the customers’ data to Azure Blob Storage every day.

1. Go to Automation > Workflows > New workflow.
2. Enter the name of the workflow.

Define the launch date

3. As the trigger node, add Scheduled Run.
4. In the configuration of the node:
   1. Leave the Run trigger option at default (all time).
   2. From the Timezone dropdown list, select the time zone consistent with the timezone selected for your workspace.
   3. Define the frequency of the workflow (for example, every day at 6.00 A.M.).
      The workflow will automatically launch at the scheduled time.
   4. Confirm by clicking Apply.

Select customers to export

5. Add a Get Profiles node.

6. In the configuration of the node:

   1. Select the segmentation you created in the first part of the process.
   2. In the Attributes section, select the profile attributes which you want to export.
      In the example, email and newsletter_agreement are selected.
   3. Confirm by clicking Apply.

   

Configure Send file to Azure Blob Storage node

1. Click Azure Blob Storage > Send file.
2. Click Select connection.
3. From the dropdown list, select the connection.
   • If no connections are available or you want to create a new one, see Create a connection.
   • If you selected an existing connection, proceed with the integration settings.
4. In the Container field, enter the name of an existing container in your storage.
   If this field is already filled out, it means that the URL used in the connection settings contains the name of the container.
5. In the Blob name field, enter the name of the blob (file) you want to send to the storage.
   If this field is already filled out, it means that the URL used in the connection settings contains the name of the blob. In such case, the contents of the blob will be overwritten.
6. From the File format dropdown list, select the format in which the file will be sent to the storage.
7. Confirm by clicking Apply.

Add the finishing node

12. Add the End node.

13. In the upper right corner, click Save & Run.

    

Check the use case set up on the Synerise Demo workspace

You can check the configuration of each item created in this use case on our Synerise Demo workspace:

• Segmentation
• Workflow

Read more

• RFM analysis
• Send file to Azure Blob Storage
• Segmentations
• Workflows