Docs
  • LogicLoop Documentation
  • LogicLoop Quickstart
  • Data Sources
    • Connect your data source
      • Deployment options
    • Supported data sources
      • API data (JSON)
      • AWS CloudWatch
      • BigQuery
      • Databricks
      • Google Analytics
      • Google Sheets
      • MongoDB
      • Microsoft SQL Server
      • MySQL
      • Oracle
      • PostgreSQL
      • Snowflake
      • Combine Results
      • LogicLoop Data Source
  • Queries
    • Write a rule
      • More rule options
      • A/B testing rules
      • Version history
      • Query Snippets
    • Visualizations & dashboards
      • Visualizations
      • Dashboards
  • Actions
    • Set up an action
    • Action destinations
      • Email
      • Slack
      • Webhooks & APIs
      • Microsoft Teams
      • Salesforce
      • Zapier
      • PagerDuty
      • Write to Database
      • Chain Rules
      • Google Sheets
      • Bento
    • Templating
  • Case Management
    • Case Management
      • Ticket Generation
      • Case Triage
      • Custom Fields and Attachments
  • AI
    • AI Query Helper
    • Ask AI
  • Teams & Settings
    • Integrations
      • Slack
      • Google Sheets
    • Invite your teammate
    • Groups & Permissions
  • Changelog
  • FAQs
  • Troubleshooting
  • Templates
    • Templates Home
    • Risk & Fraud Rules
    • AML Transaction Monitoring Rules
    • Logistics & Marketplace Ops
    • Customer Success & Growth
    • Systems Observability
    • Data Quality Monitoring
    • Healthcare
    • HTML Email Templates
      • Annual Review
      • Weekly Performance Table
      • Invoice Recap
  • BETA
    • AI SQL API
    • Approving rules
    • Render Data as JSON
    • Case Analytics
    • Python
  • Security & Legal
    • Security
    • AI Security
    • Terms of use
    • Privacy policy
    • Services description
Powered by GitBook
On this page
  • Alert when an API is down
  • Monitor a drop in new user sign ups
  • Monitor drop in a critical business unit
  • Monitor applications stuck in processing
  • Monitor invalid database fields
  • Monitor children database objects with no parent

Was this helpful?

  1. Templates

Systems Observability

PreviousCustomer Success & GrowthNextData Quality Monitoring

Last updated 2 years ago

Was this helpful?

You can use LogicLoop to monitor systems uptime. Your company may already be using tools like Sentry and Datadog for infrastructure monitoring. In addition, users have found LogicLoop useful to monitor data-driven metrics and external APIs that aren't easily captured by Sentry or Datadog. See below for some examples.

Alert when an API is down

Every 10 minutes, query an API your service relies on. The API can be an external or internal service.

If the request fails, LogicLoop will send you an email notifying you of the failure.

Monitor a drop in new user sign ups

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.

Monitor drop in a critical business unit

Similarly, you can use LogicLoop to monitor when there's a drop or change in a unit critical to your business.

Digital health companies: monitor a drop in the number of appointments scheduled today.

Recruiting companies: monitor a drop in the number of candidates who were scheduled for interviews today.

E-commerce companies: monitor a drop in the number of orders placed in the past hour.

Ride-share marketplace: monitor the number of rides completed in the past hour.

Monitor applications stuck in processing

Select all applications that are still processing after a certain amount of time.

View SQL Query
SELECT
  *
FROM
  applications
WHERE
  status = 'pending'
HAVING
  AND created_at > current_date - interval '7 days'

Create an Asana ticket for an analyst to review.

Monitor invalid database fields

Query for fields that should not be Null

View SQL Query
SELECT
  *
FROM
  users
WHERE
  email is NULL

Create a JIRA ticket for an engineer to review.

Monitor children database objects with no parent

Query for children objects that are orphaned.

View SQL Query
SELECT
  *
FROM
  children
WHERE
  parent is NULL

Create a PagerDuty alert for an engineer to review immediately.

Page cover image