Unified customer profile

Segment export and bulk audience import

Export any segment to CSV with tag values and per-channel counts, or bring data in: a list of IDs, a batch of tag or event updates, or a live query against your own warehouse. Use it like any other segment once it lands.

Control Panel segments list with a segment's action menu open on Refresh & Export to CSV

A segment rarely stays where it was built

A segment built in Pushwoosh is useful right up until someone needs it somewhere else: a spreadsheet for a stakeholder, an upload for an ad platform, a list from another system that has to become a segment here. None of that is one person retyping IDs by hand or updating a tag row by row.

Segment export and bulk audience ops moves a segment out as a file, and a file in as a segment, a batch of tags, or a batch of events, instead of turning a data problem into an afternoon of manual updates.

What it does

A saved segment can leave Pushwoosh as a CSV file, tag values and per-channel counts included. Data can come back in five different shapes, depending on what you’re moving.

ModeWhat it movesLimit
Export to CSVAny saved segment, with tag values and counts per channelNo published cap
Import as list segmentA file of user or device IDs becomes a segment100MB per file
Bulk tag updateThe same tag applied to every ID in the file at once100MB per file
Bulk event importAn event loaded for many users in one batch instead of one postEvent call each100MB per file
Bulk SMS importSMS contacts loaded as a batch instead of added one at a time100MB per file
Warehouse-based segmentA segment defined as a live query against your own BigQuery or Postgres dataBigQuery or Postgres only
Mode
1 / 6
Export to CSV
What it moves
Any saved segment, with tag values and counts per channel
Limit
No published cap
Mode
2 / 6
Import as list segment
What it moves
A file of user or device IDs becomes a segment
Limit
100MB per file
Mode
3 / 6
Bulk tag update
What it moves
The same tag applied to every ID in the file at once
Limit
100MB per file
Mode
4 / 6
Bulk event import
What it moves
An event loaded for many users in one batch instead of one postEvent call each
Limit
100MB per file
Mode
5 / 6
Bulk SMS import
What it moves
SMS contacts loaded as a batch instead of added one at a time
Limit
100MB per file
Mode
6 / 6
Warehouse-based segment
What it moves
A segment defined as a live query against your own BigQuery or Postgres data
Limit
BigQuery or Postgres only

The warehouse-based segment is the one that doesn’t move a file at all. Point it at a BigQuery or Postgres table you already run, and Pushwoosh queries it directly to keep the segment current, a self-serve option most platforms in this space don’t offer.

A segment can query your own warehouse directly

Every other mode on this page moves a file. This one queries BigQuery or Postgres directly, so the segment reflects your own data without anyone exporting or importing anything first.

What ties it back to Advanced segmentation

Advanced segmentation is only as useful as the data it can reach. A segment built entirely from tags and events already in Pushwoosh is one kind of audience. A segment that can also start from a spreadsheet, get tagged in bulk after a migration, or query a warehouse table your data team already maintains is a wider one.

Segment export and bulk audience ops is what lets Advanced segmentation reach a spreadsheet, a migration, or a warehouse table the same way it already reaches tags and events built inside Pushwoosh.

How it works

  1. Export a segment

    Open any saved segment and choose Refresh and Export to CSV. The file includes tag values and a count per channel.

  2. Import data in

    Upload a CSV to create a list-based segment, update a tag across every ID in the file, or bulk-load events or SMS contacts.

  3. Or connect a warehouse

    Point a segment at a BigQuery or Postgres table instead of a file, and it queries the source directly.

Export and CSV import are no-code, in the Control Panel. Connecting a warehouse is usually a job for whoever manages it. It needs read access to the table the segment will query.

One import, three places it lands

A CSV import rarely stops at creating a list. The same file can update tags across every ID at once, or bulk-load events a Journey can react to the moment they land. The list segment it creates behaves like any other saved segment afterward: reference it inside Advanced segmentation, point a Condition split at it, or export it again once it has been enriched.

Built to feed the rest of the platform

One file, three destinations: a list segment, a tag update, and an event a Journey can trigger on, all from the same import.

How to tell it is working

A CSV import creates a segment like any other. Refresh its size the same way you would for a segment built from conditions, and you can see how many of the IDs in the file matched a real user or device.

What to keep in mind

A few things worth checking before you build on this.

  • CSV import is capped at 100MB per file, whether it’s a list segment, a bulk tag update, a bulk event import, or a bulk SMS import.
  • The file name becomes a tag applied to every ID it imports, so name the file with that in mind.
  • IDs in the file that don’t match a real user or device are skipped silently, and nothing tells you which ones didn’t make it.
  • CSV export has no published size or row cap.
  • A warehouse-based segment reads BigQuery or Postgres only, no other warehouse today.
  • No native sync from a segment to an ad platform like Meta or Google. Export the CSV and upload it there instead.

Move data as easily as you build a segment

A segment that can leave the platform, and data that can come back in bulk, is what keeps advanced segmentation from stopping at the edge of Pushwoosh.