To see which plans include Glew integration please see our pricing page.
In this article:
Why Glew and LoyaltyLion?
Glew is a powerful, all-in-one business intelligence platform for ecommerce merchants, retailers, agencies and enterprises. By using Glew with LoyaltyLion you can connect, transform and visualize all your data in one place. Get powerful insights to grow your business through intuitive dashboards, automated reports and more.
Benefits of integrating with Glew
Get data-driven insights
Enable powerful ecommerce and multichannel reporting for everyone in your organization
Segment customers for targeted marketing campaings
See how your loyalty program impacts your bottom line
Automate any reporting task, from daily performance snapshots to scheduled weekly and monthly reports
Get a custom enterprise analytics solution built to scale, and find answers to the most complex questions in your data
Easily scale reporting and analytics across your entire team to ensure everyone has access to the data they need
How to integrate LoyaltyLion with Glew?
1. Make sure that you have an active or trial Glew account and an active LoyaltyLion subscription.
3. In your Glew account go to Store Settings and then Integrations. Find LoyaltyLion on the list. Click on the integration to begin.
4. Review the details and click Continue.
5. Review the connection details, and click to initiate the OAuth connection between Glew and LoyaltyLion. Here, you’ll be prompted to enter your LoyaltyLion credentials to verify the connection.
6. Good job! Your LoyaltyLion account is connected! You can return to the LoyaltyLion integration from Store Settings to review your integration details, reconnect your account or integrate a different LoyaltyLion account as needed.
7. When you are ready, click the Import banner at the top of your screen to begin synchronising your LoyaltyLion data into Glew.
Initial imports can take anywhere from a few hours to 24-74 hours or more, depending on how much historical data you’re importing.
If you experience any issues connecting your Glew and LoyaltyLion accounts, reach out to us at support@glew.io!
What fields are synchronised with Glew?
We currently sync the following merge fields:
dim_loyaltylion_customer:
customer_id
glew_account_id
first_name
last_name
birthday
points_pending
points_approved
points_spent
rewards_claimed
loyalty_tier_id
loyalty_tier
blocked
guest
enrolled
fact_loyaltylion_activity:
activity_id
glew_account_id
timestamp
customer_id
first_name
last_name
status value
rule
points_pending
points_approved
points_spent
customer_merchant_id
merchant_id manual
default hidden
segment
referral_url
merchant_id
enrolled_at
started_at
expires_at
created_at
updated_at
fact_loyaltylion_order:
order_id
glew_account_id
timestamp
customer_id
first_name
last_name
revenue
tax
shipping
discounts
amount_paid
refunded_amount
status
fulfillment_status
refund_status
cancellation_status
points_pending
points_approved
points_spent
customer_merchant_id
merchant_id
merchant_number
order_source
source_url
location_id
Don't be alarmed if you can't see the fields in Glew right away after you integrate. Initial sync might take a moment to push all the historical properties, however, once it's done, fields will be pushed hourly. You’ll receive an email notification when your import is complete.