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.
View SQL Query
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.
View SQL Query
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.
View SQL Query
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. 
View SQL Query
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.
View SQL Query
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.
View SQL Query
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. 
View SQL Query
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
View SQL Query
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.
View SQL Query
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.

Last modified 1yr ago