Send customer profiles to GCS with agreement to marketing communications

Published September 18, 2023
Modules
Difficulty
Powered by
OChK logo

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 Google Cloud Storage (GCS), you can transfer any data collected in Synerise and use it in other Google tools.

In this use case, we will send a customer database with a marketing communications agreement to Google Cloud Storage. Before creating the workflow, we will also create a Data Transformation rule, which will modify the value of one of the exported attributes to another format. This is not a mandatory step, you can export the data in the format you store it in the platform, in accordance with your needs.

Prerequisites


  • Implement solutions that collect marketing agreements from various touch points with your customers.
  • Prepare a sample of data that will be used in data transformation.
    Click here to see an example file

    email,newsletter_agreement
    john.doe@synerise.com,enabled
    kathy.smith@synerise.com,enabled
    lily.novak@synerise.com,enabled
    matt.turner@synerise.com,enabled

  • Make sure you meet all prerequisites to integrate Synerise with Google Cloud Storage.

Process


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

  1. Create a segmentation of customers whose data you want to send to the GCS.
  2. Create a data transformation diagram to prepare the data for sending to Google Cloud Storage.
    This is an optional step. If you don’t need to change the exported data, you can skip it.
  3. Create a workflow that will send selected customer profiles to GCS.

Prepare a segmentation


As the first part of the process, create a segmentation of customers who agreed to receive emails. The data of these customers will be sent to the external resource.

  1. Go to Analytics icon Analytics > Segmentations v2 > New segmentation.

  2. Define the name of the segmentation.

  3. Click Has property.

  4. From the dropdown list, select newsletter_agreement.

  5. As the logical operator, select Equal.

  6. In the text field, enter enabled.

  7. Click Save.

    The configuration of the segmentation
    The configuration of the segmentation

Prepare data transformation


This step is not mandatory, you can skip it in case you don’t need to make any changes to the exported data.

In this part of the process, you define the rules of modifying data before sending it to GCS. For the purposes of this case, the newsletter_agreement parameter value will be changed from enabled to true.

The data transformation diagram which is the output of this part of the process is used later to automate sending the data.

  1. Go to Automation icon Automation > Data Transformation > Create transformation.
  2. Enter the name of the transformation.
  3. Click Add input.

Add file with sample data

Add the Data input node to add a data sample. In further steps, you define how the data must be modified. Later, when this transformation is used in the Automation workflow, the system uses the rules created with the sample data as a pattern for modifying actual data.

  1. On the pop-up, upload the file with the sample data you prepared earlier.
  2. Click Apply.
The configuration of the Data input node
The configuration of the Data input node

Edit the newsletter_agreement value

In this part of the process, you will use the Edit value node. This node allows you to replace the enabled value of the newsletter_agreement attribute with true.

  1. On the canvas, click the right mouse button.
  2. From the dropdown list, select Edit values.
  3. Click the Edit values node.
  4. In the configuration of the node:
    1. Click Add rule.
    2. Click Add column.
    3. Select the newsletter_agreement column.
    4. Under Edit values by, from the dropdown list, select Replacing.
    5. In the left dropdown, leave the Static value option at default.
    6. In the text field, enter true.
    7. Confirm by clicking Apply.
The configuration of the Edit values node
The configuration of the Edit values node

Add the finishing node

To complete the transformation, use the Data Output node, which allows you to preview the output of the modifications to the sample data.

  1. On the canvas, click the right mouse button.

  2. From the dropdown list, select Data output.

  3. In the upper right corner, click Save and publish.

    The diagram of data transformation
    The diagram of data transformation

Prepare a workflow


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

  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 newsletter_agreement and email.
    3. Confirm by clicking Apply.
    The configuration of the Get Profiles node
    The configuration of the Get Profiles node

Select the data transformation rules

  1. Add a Data Transformation node.
  2. In the configuration of the node, select the data transformation you have created before.
  3. Confirm by clicking Apply.

Configure Send file to Google Cloud Storage node

  1. Add Google Cloud Storage > Send file node.
  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 Project ID field, enter the unique identifier of your project in Google Cloud.
    You can learn how to find the project ID here.
  5. In the Bucket field, enter the name of an existing bucket (container) to which you will send a file with data.
  6. In the Path to directory field, enter the path to which the file will be saved in the bucket.
  7. In the File name field, enter the name of the file you want to send to the storage. If the file already exists, the contents of the file will be overwritten.
  8. From the File format dropdown list, select the format in which the file will be saved in the storage.
  9. Confirm by clicking Apply.
The configuration of the Send file to Google Cloud Storage node
The configuration of the Send file to Google Cloud 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

You can monitor the flow of the workflow in the Transformation logs tab. It contains information about each execution of the workflow.

The logs for the workflow
The logs for the workflow

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