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 [e-mail] 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.