Docs
Search…
⌃K

Customer Success & Growth

LogicLoop can help your company automate your customer engagement & outreach. Oftentimes, information about a user's behavior on your platform lives in your company's database. LogicLoop empowers operations people to write rules directly on top of your product data in order to send reporting information to your internal team, or even direct outreach to your customers at the right time. First, connect your company's data sources. Then, you can use sample industry templates below as guidance to bootstrap your program. Contact us at [email protected] to access our full suite of templates.

Acquisition & Onboarding

Track dip in website signups

Detect if number of signups on the website has been low.
SELECT
count(*)
FROM
user_signups
WHERE
created_at < interval - '60 minutes'
HAVING
count(*) < 10
Send a Slack alert to your team to investigate.

Sending onboarding reminder emails

Select users who signed up within the past week but are stuck between Step 2 and Step 3 of onboarding.
SELECT
*
FROM
users
WHERE
last_onboarded_stage = 'Step 2'
For each user, send them an email to remind them to complete Step 3. You can use HTML to stylize your email with custom branding.

Engagement & Retention

Send weekly product usage summary emails

Retrieve customers and their key metrics on your platform.
SELECT
id,
company_name,
JSON_BUILD_OBJECT(
'number_of_logins', num_logins,
'number_of_conversions', num_conversions,
'monthly_spend', monthly_spend,
'amount_saved', amount_saved
) as product_usage_data
FROM
users
For each customer, send a weekly email to show them their top stats on your platform. You can use HTML to present your email in an aesthetically pleasing table or image.

Send milestone notifications

Select customers who've reached a certain milestone on your platform. You can use our deduplication feature to not re-send the same notification to the same customer.
SELECT
count(*),
user_id
FROM
orders
GROUP BY
user_id
HAVING
count(*) > 3
For each customer, send them a congratulatory text

Upsell the most active users

Select the most active users on your platform.
SELECT
count(*),
user_id
FROM
events
GROUP BY
user_id
HAVING
count(*) > 100
Send a Slack message to the Sales team for an account manager to reach out and upsell.

Send churning users discounts

Select users who have been inactive on your platform.
SELECT
count(*),
user_id
FROM
events
WHERE
created_at > current_date - interval '30 days'
GROUP BY
user_id
HAVING
count(*) = 0
For each user, email them a discount to encourage them to re-engage.

Support

Response time too high

Detect if average response time of your support team is too high.
SELECT
avg(first_responded_at - created_at) as avg
FROM
tickets
HAVING
avg(first_responded_at - created_at) > interval '1 day'
Send an email report to a support manager.

CSAT is low

Detect if the average CSAT is too low
SELECT
avg(csat_score) as avg
FROM
tickets
HAVING
avg(csat_score) < 5
Send an email report to a support manager.

Agent supply does not meet demand

Detect if number of support agents is not enough to fulfill incoming tickets.
WITH tickets_count AS (
SELECT
count(*) as num_tickets
FROM
transaction
WHERE
created_at > current_date - interval '1 hour'
)
SELECT
*
FROM
tickets_count
JOIN agent_stats_query on True
WHERE
num_tickets > 10 * agent_stats_query.number_of_agents
Send Slack message to #support-agents channel to find backup agents.