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

Published April 17, 2023
Modules
Difficulty

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.
Note: The churn risk segmentation shown in this use case is just an example. You can create any other segmentation using your own rules according to your specific assumptions and business needs.

Process


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

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 Add condition 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.
Segmentation settings
Segmentation settings

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 icon Automation > Workflows > New workflow.
  2. Enter the name of the workflow.

Define the launch date

  1. As the trigger node, add Scheduled Run.
  2. 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.
The configuration of the Scheduled Run node
The configuration of the Scheduled Run node

Select customers to export

  1. Add a Get Profiles node.

  2. 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.
    The configuration of the Get Profiles node
    The configuration of the Get Profiles node

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.
The configuration of the Send file to Azure Blob Storage node
The configuration of the Send file to Azure Blob Storage node

Add the finishing node

  1. Add the End node.

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

    The workflow configuration
    The workflow configuration

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:

Read more


😕

We are sorry to hear that

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

😉

Awesome!

Thank you for helping improve out documentation. If you need help or have any questions, please consider contacting support.

Close modal icon Placeholder alt for modal to satisfy link checker