Lightspeed Retail
Filament

Ask questions about your Lightspeed Retail data

Connect Lightspeed Retail to Filament and turn complex dashboards, analytics, and business intelligence into a simple conversation. No spreadsheets. No setup. Just instant answers.

Sign up freeBook a demo
Free 14-day trial
No credit card required
Setup in minutes

Lightspeed Retail shows you daily sales and inventory levels, but understanding which marketing campaigns drive in-store purchases or how online promotions affect foot traffic requires connecting to your ad platforms and email tools. Filament links your Lightspeed Retail transactions to your marketing data and answers questions about customer acquisition, campaign performance, and cross-channel attribution in plain English.

Metrics dashboard
Finance dashboard
SEO dashboard

Track Lightspeed Retail KPIs with Filament Analytics

Connect your Lightspeed Retail account to Filament and instantly track your most important KPIs. All in plain English dashboards that update automatically.

View documentation

Key Lightspeed Retail metrics you can track in Filament:

Sales
Track individual transactions with sale_id, total_amount, payment_method, sale_date, register_id, and location details. Analyze daily revenue patterns, payment preferences, and location performance.
records:
sale_idtotal_amountpayment_methodsale_dateregister_idlocation_id
Sale Line Items
Track product-level transaction details with line_item_id, product_sku, quantity_sold, unit_price, discount_amount, and tax_amount. Understand which products drive revenue and how discounts affect margins.
records:
line_item_idsale_idproduct_skuquantity_soldunit_pricediscount_amount
Products
Track your catalog with product_id, sku, product_name, category, supplier_id, retail_price, and cost_price. Build a kpi dashboard tracking product performance and margin analysis.
records:
product_idskuproduct_namecategoryretail_pricecost_price
Inventory
Track stock levels with inventory_id, product_id, quantity_on_hand, reorder_point, location_id, and last_updated. Monitor inventory turnover and identify slow-moving products across locations.
records:
inventory_idproduct_idquantity_on_handreorder_pointlocation_id
Customers
Track customer profiles with customer_id, email, phone, first_purchase_date, total_purchases, and lifetime_value. Analyze retention patterns and identify your highest-value customer segments.
records:
customer_idemailfirst_purchase_datetotal_purchaseslifetime_value
Refunds
Track returns with refund_id, original_sale_id, refund_amount, refund_date, reason, and product_sku. Understand return patterns and which products or categories generate the most refunds.
records:
refund_idoriginal_sale_idrefund_amountrefund_datereason
Locations
Track store performance with location_id, location_name, address, opening_date, and register_count. Compare sales performance and inventory efficiency across your retail locations.
records:
location_idlocation_nameaddressopening_date
Suppliers
Track vendor relationships with supplier_id, supplier_name, contact_info, payment_terms, and product_count. Analyze supplier performance and product margins by vendor.
records:
supplier_idsupplier_namepayment_termsproduct_count
Filament Pixel Logo

Combine Lightspeed Retail with other data sources

Your business runs on more than one app, and your analytics should too. With Filament, Lightspeed Retail lives side-by-side with sales, finance, and customer tools. Bring it all together in one intelligent workspace and finally see the full picture.

attio
hubspot
intercom
raisely
salesforce-connector
stripe
xero
facebook-ads
google-ads
ga4
gsc
campaign-monitor
customerio
instagram-business
linkedin-ad-analytics
mailchimp
snapchat-ads
tiktok-ads
twitter-ads
airtable
google_sheets
mysql
postgres
quickbooks
shopify
woocommerce
amplitude
asana
eventbrite
freshdesk
github
jira
klaviyo
mixpanel
notion
segment
slack
trello
zendesk-support
attio
hubspot
intercom
raisely
salesforce-connector
stripe
xero
facebook-ads
google-ads
ga4
gsc
campaign-monitor
customerio
instagram-business
linkedin-ad-analytics
mailchimp
snapchat-ads
tiktok-ads
twitter-ads
airtable
google_sheets
mysql
postgres
quickbooks
shopify
woocommerce
amplitude
asana
eventbrite
freshdesk
github
jira
klaviyo
mixpanel
notion
segment
slack
trello
zendesk-support

Your Lightspeed Retail data gets even more powerful when combined with other tools:

Lightspeed Retail
Klaviyo

Lightspeed Retail + Klaviyo

Connect Lightspeed Retail sales with Klaviyo email campaigns to see which email flows drive in-store purchases and which customer segments respond to promotions. Track revenue per campaign and identify your most valuable email subscribers.

Lightspeed Retail
Google Ads

Lightspeed Retail + Google Ads

Connect Lightspeed Retail transactions with Google Ads campaign data to track which search and display campaigns drive foot traffic and in-store revenue. Build a kpi dashboard showing cost per acquisition and return on ad spend for each campaign.

Lightspeed Retail
Xero

Lightspeed Retail + Xero

Connect Lightspeed Retail sales with Xero accounting data to reconcile daily transactions, track actual margins after expenses, and understand cash flow patterns. See how inventory purchases affect profitability across locations.

Benefits of Filament's Lightspeed Retail Integration

Ask in plain English

Start with a question like 'How did MRR trend last year?' and you'll get an instant dashboard from across your apps. No configuration, no code.

chatMRR

No setup

Filament is like Looker Studio or PowerBI, but it will set itself up. It understands your data, and automatically connects the dots.

easy setup

Gets smarter over time

Filament remembers your context and preferences, so you spend less time explaining and answers that align with your goals.

memories

How it works

Step 1: Connect your Lightspeed Retail account

Connect your Lightspeed Retail account to Filament and get instant access to your data. No technical setup required.

Step 2: Ask questions about your Lightspeed Retail data

Start asking questions like "Which campaigns drive the most qualified leads?"

Step 3: Build Lightspeed Retail dashboards in minutes

Get tailored insights instantly and share them with your team.

Filament Pixel Logo

Better business decisions with AI Analytics

How to get more from your data

Most teams only scratch the surface of what's possible with their data. Reports get buried in dashboards, exports pile up in spreadsheets, and critical insights never reach decision-makers. Filament changes that.

With Filament, your data is analyzed by an AI data analyst that understands plain English. Instead of struggling with complex BI tools or waiting for reports, you can instantly ask questions about revenue, marketing performance, customer engagement, or retention, and get clear answers in seconds.

Because Filament connects data across marketing, product, CRM, and finance systems, it helps you answer the bigger questions that traditional dashboards can't:

  • Which campaigns and channels actually drive revenue growth?
  • How does user engagement translate into pipeline or sales performance?
  • Where are we losing efficiency between acquisition, retention, and finance?

By combining AI-powered reporting, conversational dashboards, and cross-platform integration, Filament helps you move beyond surface-level metrics and uncover the insights that drive smarter, faster business decisions.

Enterprise-grade security

Complete data isolation, data encryption at rest and in-transit, and secure, accredited cloud providers keep your organisation's data protected. We never use your data for AI training or share it with third parties.

Learn more about security

Lightspeed Retail integration FAQ

Everything you need to know about connecting Lightspeed Retail with Filament and getting the most out of your data.