Exporting your data
Mags Maras avatar
Written by Mags Maras
Updated over a week ago

In this article:


Customer export

How to export customers' data

1. Go to Customers

2. Click Export in the top right corner

3. Choose the email the export should be sent to

4. Check your mailbox :)

Customer export fields

When you perform a customer export from LoyaltyLion, you'll receive an email with a CSV file containing the following fields:

  • id: id of the customer in your store system (e.g. their Shopify or Magento id)

  • name: Full name of the customer, if we have it

  • email: Email address of the customer, if we have one

  • points_approved: The customer's current number of approved points. Approved points are those that are currently available to spend, and are not pending from a recent purchase

  • points_pending: Current number of pending points (i.e. those from a purchase that have not yet been approved). Read more about these.

  • points_spent: Current number of spent points (i.e. those redeemed on rewards). You can add all three-point totals together to get the customer's "lifetime" points.

  • loyalty_tier_name: Customer's current tier name, or blank if tiers are not active

  • loyalty_tier_position: The numeric position of the customer's current tier

  • loyalty_tier_spend: If tiers are enabled and are based on spend, this will be their current "countable" spend for the purpose of calculating their tier, i.e. their spend in the last 12 months (or until the date tiers were launched, whichever is sooner)

  • loyalty_tier_points: If tiers are enabled and based on points, this will be their current "countable" points for the purpose of calculating their tier, i.e. the sum of their earned approved points in the last 12 months (or until the date tiers were launched, whichever is sooner)

  • enrolled_at: Date this customer enrolled in the program, or blank if they are not currently enrolled

  • blocked: ''TRUE'' if this customer has been blocked from the program, ''FALSE'' if not

  • birthday: The customer's birthdate, if they have provided it to LoyaltyLion, in the format "YYYY-MM-DD"

  • referral_url: The customer's unique referral URL

  • rewards_claimed: Total number of rewards claimed by this customer

  • receives_loyalty_emails: Boolean indicating if the customer receives emails. If this is false, then the customer has unsubscribed


Rewards export

LoyaltyLion gives you an option to export all claimed rewards. This way you can clearly identify unclaimed rewards, or see the amount rewards are costing you.


In order to download a report follow the steps below:

1. Login to your LoyaltyLion account
2. Click on the tab Manage

3. On the left find Rewards and click View rewards

4. You'll see an overview of all your set rewards. In the top right corner, you'll see an Export button. Click on it and fill YOUR email address you'd like us to send the file to.

Shortly, you'll receive a file with all additional information about your claimed rewards.

Rewards export fields

  • customer_id: id of the customer in your store system (e.g. their Shopify or Magento id)

  • email: customer's email

  • cost: the cost of the reward in LoyaltyLion

  • state: if the voucher is enabled (approved) or disabled (void)

  • method: type of reward (eg. voucher, free product)

  • applies_to: where the voucher is applied (eg. cart)

  • target_product_id: (if applicable) ID of the product the voucher is restricted to

  • target_product_sku: (if applicable) SKU of the product the voucher is restricted to

  • target_collection_id: (if applicable) ID of the collection the voucher is restricted to

  • discount_type: type of discount provided (eg. flat or percentage)

  • amount: the discount amount of the voucher

  • claimed_at: when the customer claimed their voucher

  • code: the code of the voucher

  • usable_on_store_url: URL of the store's customers can use the vouchers at

  • used_with_order_numbers: (if applicable) which order the customer used the voucher with

  • currency: currency of the voucher

  • order_total: (if applicable) the order total associated with a used voucher


Insights export

You can see which customers are loyal to your brand, who you might need to win back, and who's at risk of churning. In order to find out more about our insights please click on the button below:
โ€‹

1. Log in to your LoyaltyLion account and click on the Insights tab

2. On the right side you'll see three tabs: Loyal Customers, At Risk, and Win Back. Click on one to see more data.

3. In the Customers section you'll see an overview of your customers and data connected to their purchasing habits. In order to download this data click on the Export users as CSV button.

Insights export fields

When you click on the Export users as a CSV button, you'll receive a CSV file containing the following fields:

  • id: id of the customer in your store system (e.g. their Shopify or Magento id)

  • first_name: first name of the customer, if we have it

  • last_name: last name of the customer if we have it

  • email: customer's email

  • frequency: purchasing frequency of the customers

  • last_order_date: the date and time of the last order placed by the customer

  • total_spend_cents: total spend per customer, viewed in cents


Referral export

1. Login to your LoyaltyLion account

2. Go to Analytics and select Referrals on the drop-down menu

3. In the top right corner, you can request an export file of all successful referrals

Referral export fields.

When you click on the Export button, you'll receive a CSV file containing the following fields:

  • Referrer's email address and ID

  • Referee's email address and ID

  • Voucher code used

  • Order number

  • Order total

  • Order date


Points transactions export

In order to download a point transaction export follow the steps below:

1. Login to your LoyaltyLion account
2. Click on the tab Manage

3. Scroll down to Data exports and click on Exports

4. On the next page you'll see an option to select the date range of the export you wish to download. Click on the button Export after you set the dates.

Once the export is ready, we'll send you an email. The status will change from Pending to Processed and you'll be able to download the file.

Point transaction export fields

When you click on the Export button, you'll receive a CSV file containing the following fields:

  • id: id of the transaction

  • customer_id: id of your customer

  • customer_email: customer's email address

  • resource: the type of activity

  • activity_title: the identifier of the activity

  • points_approved: number of approved points involved in this transaction (either added or deducted)

  • points_pending: number of pending points involved in this transaction (either added or deducted)

  • order_id: id of the order involved in the transaction

  • created_at: date and time when the transaction was created

If you're trying to find out what type of activity got points, it is best to look at the activity_title column


Tiers export

In case you need to export your loyalty tiers data, you will need to follow the next steps:

  1. Login to your LoyaltyLion account

  2. Go to the Manage tab

  3. Click on Loyalty Tiers > Manage tiers

  4. Go to the Analytics tab

  5. Choose the dates for your export in the top left corner

  6. Click on the arrow in the top right corner of your dashboard to download your CSV file


Frequently asked questions

When I try to download the transactions export, I see a message saying access denied. Is something wrong?

You might be trying to download a report that you exported a long time ago and is now expired. You can access the data by producing a new report and this should work correctly.

The customers export does not note if the customers are enrolled or guests. How can we account for these segments in the export?

You can filter out guest customers in the customers export by the property enroll_date. Any customers where this is blank won't be enrolled members of the program

Did this answer your question?