Glew.io - Integration Manual
Mags Maras avatar
Written by Mags Maras
Updated over a week ago

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

email

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

email

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

email

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.

Did this answer your question?