Data export

You can use dedicated API endpoints to export your data or download CSV files straight from the dashboard. 

Contents

  1. Exports overview
  2. Publications
  3. Redemptions
  4. Vouchers
  5. Customers
  6. Metadata
  7. Referral program exports
  8. Loyalty campaign exports

Exports overview

You can export vouchers, redemptions, publications, and customers data. Whether you choose to use API or the dashboard, it is a two-step process:

1. Prepare an export file with filters and decide which attributes you would like to include.

2. Download your file once it's ready.

Using the API, you can use this endpoint to prepare and schedule export, and then this endpoint lets you download the file. In the dashboard, you can use the export tool to schedule the data export and download a CSV file from the notification center. 

Besides standard exports, Voucheify enables you to download: 

  • List of loyalty program members.
  • List of referrers.

Publications

Publication assigns a unique code to a particular customer. You can download publications in the campaign dashboard. The CSV file includes a list of all publications.

Go to the campaign dashboard > Publications history, and click on the export tool. 

Choose which publication details you would like to download, and confirm with Export.


Redemptions

You can download all redemptions that were made in your account or use additional filters to select export data. 

To download all redemptions, go to the Redemptions tab and click on the export tool.

You can decide which redemption details will be included in your CSV file. Besides standard attributes (1), you can download metadata assigned to redemptions (2). 

Expand the defined fields to get an overview of included attributes.

If you would like to download only specific redemption records, you can use the following customization:

I. Campaign/code redemptions

Redemptions coming from a particular campaign/standalone code can be downloaded directly from the campaign/code dashboard. Go to the Redemptions history (1), and click Export (2).

II. Advanced filters

You can use advanced filters to browse particular redemptions and download them in a CSV file. Go to the Redemptions tab and choose Find and apply filters.

The filters let you browse redemptions using their status (successful, failed), creation date, redeeming User (team member), related voucher, and custom metadata attributes. When it comes to failed redemptions, you can group them using particular failure reasons. You can apply many filters in a single query to list required redemptions. 

Once you filter redemptions and confirm with Export, Voucherify starts preparing your file. You will be notified in the dashboard and via email once the CSV file is ready. Go to the dashboard > notifications, and click Download next to the notification to save the file on your device. 


Vouchers

You can download all vouchers created in your account or use additional filters to select export data. 

To download all vouchers, go to the Vouchers tab and click on the export tool.

You can decide which voucher attributes will be included in your CSV file. Besides standard attributes (1), you can download metadata assigned to vouchers (2). 

Expand the defined fields to get an overview of included attributes.

Advanced filters

If you would like to download only specific vouchers belonging to a particular campaign or sharing the same metadata attributes, you can use filters and list vouchers that meet predefined criteria. Go to the Vouchers tab and choose Find and apply filters.

Filters browse vouchers using their standard and custom metadata attributes. You can apply many filters in a single query. When all filters are set, confirm with Apply to view results. Read more about filters.

Once you filter vouchers, click on the export tool and decide which voucher attributes will be included in your CSV file. 

When you confirm with Export, Voucherify starts preparing your file. You will be notified in the dashboard and via email once the CSV file is ready. Go to the dashboard > notifications, and click Download next to the notification to save the file on your device. 


Customers

You can download the entire list of customers saved in your account or use additional filters to select export data. 

To download all customers, go to the Customers tab and click on the export tool.

You can decide which attributes will be included in your CSV file. Besides standard attributes (1), you can download metadata assigned to customers (2). 

Expand the defined fields to get an overview of included attributes.

Advanced filters

If you would like to filter and export data of a particular customer group, use filters and list customers that meet predefined criteria. Go to the Customers tab and choose Find and apply filters.

Filters browse customers using their activity, standard (profile) data, and custom metadata. You can apply many filters in a single query. When all filters are set, confirm with Apply to view results. Read more about filters.

Once you filter customers, click Export and decide which attributes will be included in your CSV file. 

When you confirm with  Export, Voucherify starts preparing your file. You will be notified in the dashboard and via email once the CSV file is ready. Go to the dashboard > notifications, and click Download next to the notification to save the file on your device. 


Metadata

You can export custom attributes added as metadata to customers, redemptions, vouchers, and publications. Voucherify lets you choose which metadata attributes should be included in the file or download all metadata assigned to a particular object type (like customers metadata, redemptions metadata, and so on). 

When choosing the export fields, you can see all metadata defined in the metadata schema.  

When you choose a single metadata attribute, it will be included in your CSV file headers. For example, for metadata attribute channels, the CSV file column will be named metadata.channels. 

If you choose to download all metadata properties, then each metadata defined in the schema and assigned to the exported object will be a separate column header, named after the metadata attribute (for example, for channel attribute, there will be a channel CSV column).


Referral program exports

In the referral program dashboard, you can download referral codes redemptions and the list of referrers (referral codes publications). Likewise, for each export, you can define what attributes, redemption data, or referrers you would like to include in your file.

Click on the referral program name and go to:

  • Redemptions history tab to export all redemptions of referral codes.
  • Referrers tab to download data of referral codes publications, including owners (referrers) details.

If you would like to export only referrers that have successful referrals, you need to go to the Customers tab in your dashboard and use filters.

  1. Choose Activity
  2. Filter by Referred customers.
  3. Choose a referral campaign from the list.
  4. Define the condition (number of referrals).

Loyalty program exports

In the loyalty program dashboard, you can download a list of loyalty cards publications. Moreover, with filters in the Customers tab, you can group customers using points balance and export filtering results. Likewise, for each export, you can define what attributes and data of loyalty cards or customers you would like to include in your file.

Click on the loyalty program name and go to the Participants tab to export all loyalty cards and their owners.

If you would like to export participants with a particular score, you need to go to the Customers tab in your dashboard and use filters.

  1. Choose Activity.
  2. Filter by Loyalty points.
  3. Choose a loyalty program from the list.
  4. Define the condition (number of points on the customers' cards).
API exports

Visit our API reference to learn about exports data via API.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us