Exports

Allegro can export large lists — your purchases, your audience members, and the members of a segment — as CSV files. Exports are generated in the background, so you can start one and keep working: when the file is ready, Allegro emails you a download link and the export appears on the Exports page, ready to download.

To see your exports, go to Exports in the main navigation.

Starting an export

You start an export from the page whose data you want:

Export	Where to start it
Purchases	The Export button on the Purchases page.
Audience members	The Export button on the Audience page.
Segment members	Export CSV on a segment, on the Segments page or in the segment editor.

Purchase and audience-member exports reflect the filters and search active on that page when you click Export — so to export a subset, narrow the list first, then export. The whole matching set is included, not just the page you are viewing. A segment export includes every member of the segment as last saved.

After you click Export, Allegro confirms that the export is being generated and that it will email you a link when it's ready. You don't need to stay on the page.

How many exports you can start

To keep the queue healthy, you can start up to three exports per minute. If you go over, Allegro asks you to wait a few seconds before trying again.

The Exports page

The Exports page lists every export across your organization, most recent first, and refreshes on its own while any export is still being generated. Each row shows:

Column	Description
Type	What was exported — Purchases, Audience members, or Segment members with the segment's name.
Status	Where the export is in its lifecycle (see below).
Requested by	The admin who started the export.
Rows	The number of records in the file, once it has finished.
Size	The size of the generated file.
Created	When the export was started.
Download	A Download button, shown only while the file is available.

Statuses

Status	Meaning
Pending	The export is queued and waiting to start.
Processing	Allegro is building the file.
Completed	The file is ready to download.
Failed	Something went wrong while generating the file. Start a new export.
Expired	The file was completed but has passed its download window (see below).

Downloading and retention

When an export completes, Allegro emails the admin who started it a link to the file, and a Download button appears on the export's row. Each file stays available for 7 days after it was created. After that the export is marked Expired, the file is removed, and the Download button no longer appears — start a new export to get a fresh copy.

Exports are standard CSV files you can open in any spreadsheet.

Purchase columns

For the exact columns in a purchases export, see Purchases.

Audience member columns

An audience-member export is named audience-members-YYYY-MM-DD.csv and starts with these columns:

Column	Description
Member ID	The member's unique ID.
Name	The member's display name, or blank if none is set.
Email	The member's email address.
Email Verified	Yes or No.
Created At	When the member was first created (ISO 8601).
Last Active At	When the member last generated an event, or blank if never.
Active Products	Names of the products the member currently has an active entitlement to, comma-separated.
Active Product Slugs	The same products by slug, comma-separated.
Active Entitlements	The number of active entitlements the member holds.
Entitlement Expires At	The soonest expiry among the member's active entitlements, or blank when they never expire.
Login Providers	The login providers the member has connected (for example apple, google), comma-separated.
Completed Purchases	The number of completed purchases.
Lifetime Value	The total of all completed purchases as a plain decimal (for example 40.00).
Lifetime Value Currency	The currency of the member's purchases (for example usd).
Last Purchase At	When the member's most recent completed purchase was made, or blank if none.
Properties	Names of the properties the member has signed in on, comma-separated.
Property Slugs	The same properties by slug, comma-separated.

After these fixed columns, the file adds one column per user attribute your organization has defined, ordered by attribute name. Each cell holds that member's value for the attribute (a boolean attribute reads Yes or No), and is left blank when the member has no value.

Segment member columns

A segment export is named segment-{segment-name}-YYYY-MM-DD.csv and has one row per member of the segment, with these columns:

Column	Description
audience_member_id	The member's unique ID.
email	The member's email address.
signed_up_at	When the member signed up.
member_level	The member's membership level.
total_donations	The total amount the member has donated.
is_donor	Whether the member has made a donation.
sign_up_gate_type	The kind of sign-up gate the member registered through.
lifetime_page_views	Pages viewed since the member joined.
lifetime_days_visited	Distinct days visited since the member joined.
lifetime_logins	Logins since the member joined.
pages_per_visit	Average pages viewed per visit.
top_content_section	The site section the member reads most.
primary_device	The device type the member uses most.
first_seen	When the member was first seen.
last_seen	When the member was last seen.
days_since_last_visit	Days since the member's last visit.
page_views_last_30d	Pages viewed over the last 30 days.
days_visited_last_30d	Distinct days visited over the last 30 days.
logins_last_30d	Logins over the last 30 days.
engaged_seconds_last_30d	Time spent actively reading over the last 30 days, in seconds.

A cell is blank when the member has no value for that field.

Related

• Purchases — Browse, filter, and export transactions
• Audience — Browse, filter, and export members
• Segments — Build and export saved groups of members