Microsoft Azure Blob Storage

Use GrowthLoop audiences for CSV file exports to Azure Blob Storage.

Connect this destination to export audience membership as a CSV in Azure Blob Storage over SFTP, for use in your downstream tools.

This destination writes to your Azure Blob Storage container and is a good fit when you want to:

  • Use a file export in Azure rather than a paid-media or messaging API
  • Match contacts on email

This maps to GrowthLoop Audiences and Journeys:

Use it forAudiencesJourneys
Dropping audience CSVs in Azure Blob Storage✓✓

Do not use the generic SFTP destination for Azure Blob Storage. This destination applies Azure's host and username format.

Prerequisites

Make sure you have:

  • An Azure account and a storage account. See Microsoft's create a storage account help.
  • SFTP enabled on that storage account.
  • A local user with password authentication and permission to write to a home directory or container. GrowthLoop does not use SSH keys for this destination. See Microsoft's SFTP local user help.

Set up Microsoft Azure Blob Storage as a destination

  1. In GrowthLoop, click the Destinations tab on the left sidebar.
  2. Click New Destination in the top right corner.
  3. Search for Azure Blob Storage and click Add Azure Blob Storage.
Destination picker with Azure Blob Storage selected
  1. Enter the required information, then click Create.
Azure Blob Storage destination setup form with account, username, and password
FieldDescription
Destination NameName this destination in GrowthLoop. Use a name so your team recognizes its purpose, like "Azure Blob Storage".
Sync FrequencySet the default export frequency (for example, daily or weekly). You can override this setting for individual exports.
AccountThe Azure storage account name only. Do not enter the .blob.core.windows.net host.
UsernameThe local user name only. Do not enter {account}.{user}. GrowthLoop adds the storage account prefix.
PasswordThe password you set on that local user.
Prefix for Personalization Fields (optional)Prefix GrowthLoop adds to personalization fields. The default value is fw. Leave this blank for no prefix. If you set one, it must start with a letter and use up to 5 letters or numbers.

GrowthLoop validates the connection. Azure Blob Storage then appears in your list of connected destinations.

Export to Microsoft Azure Blob Storage

From within GrowthLoop, export from an audience or from a journey Destination Node. See Export an audience or Build a journey if you need more information on these steps.

After building or selecting an audience, click Export, then search for Azure Blob Storage. In a journey, add a Destination Node under SFTP and select Azure Blob Storage.

Journey Destination Node with export name, match fields, and personalization signals

Map contact identifiers

On an audience or in a journey Destination Node, map Email address. This field is required.

You can also map additional fields, including custom attributes from the audience or from the journey.

Configure the export

This is where you set the campaign type and schedule for audience exports. On a journey Destination Node, you set timing on the journey canvas.

SettingAudience exportJourney Destination Node
Export NameDefaults to the audience name. GrowthLoop uses this in the CSV filename.Required. Enter a name so you can find the export in GrowthLoop and in the filename.
Campaign typeChoose a one-time or ongoing export.The journey schedule controls when the journey runs and contacts are sent to Azure Blob Storage.
ScheduleSet frequency, start date, end date, and days of the week for ongoing exports.Users reach this node when the journey runs. Add a Delay Node or set Criteria Evaluation to control timing.
Personalization fieldsOptional. GrowthLoop adds these columns to the CSV.Optional. GrowthLoop adds these columns to the CSV.

Export behavior

This is what GrowthLoop writes when you export an audience.

BehaviorWhat happens
What GrowthLoop writesA CSV over SFTP into the local user's home directory or container. Direction is GrowthLoop → Azure Blob Storage.
When it runsGrowthLoop sends the export as a batch on the next successful run. An export that starts Now runs within about 15 minutes. Journeys send exports on demand when users reach the Destination Node.
HostGrowthLoop connects to {account}.blob.core.windows.net on port 22.
UsernameGrowthLoop authenticates as {account}.{local user}.
Match fieldEmail address.
File formatCSV.
Filename{export name}-{timestamp}.csv, with the export name slugified.
One-time exportsGrowthLoop uploads current membership once.
Ongoing exportsEach run uploads a new timestamped file.
DeletesGrowthLoop does not delete blobs.

Confirm the export was successful

When the run finishes, confirm you can use the data in Azure Blob Storage.

  • Audience export: Open the Azure portal, go to the storage account, and open the container or home directory you assigned to the local user. Look up the latest {export name}-{timestamp}.csv.
  • Journey Destination Node: Open that container or home directory and look up the CSV named after the export.
Azure storage account Containers page

In GrowthLoop, review counts on the audience Exports tab, or open the Activity tab on the journey Destination Node. See Export an audience or Monitor a journey for more information.

Congrats on successfully exporting to Azure Blob Storage!

Troubleshooting

These are the issues we see most often. You can always email us at [email protected] for help.

ProblemCauseResolution
Connection fails to validateSFTP is off, Account includes the host, or Username already includes the account prefixEnable SFTP on the storage account. Enter the storage account name only and the local user name only
Authentication failsThe local user uses an SSH key, or the password is wrongCreate or update the local user with password authentication and paste that password
You cannot find the fileYou opened a different container than the local user's homeOpen the container or directory assigned to that local user
The filename does not match the audience nameGrowthLoop slugifies Export Name and appends a timestampSearch the container for the slugified export name
Rows fail to exportEmail address is not mappedMap Email address

What’s Next

Export an audience after you connect a destination

Did this page help you?