Trigger Query Portal
Pit Crew Loyalty — Trigger Queries — Updated May 2026
All (12)
Email (5)
SMS (7)
Email
→
Balance Expiration
Customers whose reward balance is approaching expiration based on their award level's expiry duration.
Tables
5
CTEs
4
Key param
minBalance
Email
→
Balance Reminder
Customers with a balance projected to return within 4 weeks, based on their average visit interval.
Tables
4
CTEs
5
Key param
shouldBeIn
Email
→
Oil Change Earned
Customers who earned a free oil change award on the previous open business day.
Tables
5
CTEs
5
Key param
nDays
Email
→
Referral Thank You
Customers who made a referral within the last nDays days. Shows individual and cumulative referral amounts.
Tables
4
CTEs
4
Key param
nDays
Email
→
Welcome to the Loyalty Program
Customers whose loyalty card was activated nDays open business days ago. RSA and rewards URL dynamically included.
Tables
6
CTEs
6
Key param
roadAssist
SMS
→
Balance Expiration
Customers whose reward balance is approaching expiration based on their award level's expiry duration.
Tables
5
CTEs
4
Key param
minBalance
SMS
→
Balance Reminder
Customers with a balance projected to return within 4 weeks, based on their average visit interval.
Tables
4
CTEs
5
Key param
shouldBeIn
SMS
→
Day of Appointment — Balance Reminder
Customers with appointments today who have a loyalty balance at or above the minimum threshold.
Tables
5
CTEs
2
Key param
minBalance
SMS
→
Oil Change Earned
Customers who earned a free oil change award on the previous open business day.
Tables
5
CTEs
5
Key param
nDays
SMS
→
Referral Gift Card (CLAP)
Customers who completed a visit in the target window and qualify to receive a referral gift card offer.
Tables
4
CTEs
5
Key param
afterVisit
SMS
→
Referral Thank You
Customers who made a referral within the last nDays days. Shows individual and cumulative referral amounts.
Tables
4
CTEs
4
Key param
nDays
SMS
→
Welcome to the Loyalty Program
Customers whose loyalty card was activated nDays open business days ago. RSA and rewards URL dynamically included.
Tables
6
CTEs
6
Key param
roadAssist