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: Current number of approved

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

  • 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 to 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 birth date, 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.

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 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

  • Order number

  • Voucher code used

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: type of the activity

  • activity_title: title of the activity/rule

  • 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

Did this answer your question?