PracHub
QuestionsCoachesLearningGuidesInterview Prep
|Home/System Design/Salesforce

Design a Chat Analytics Backend

Last updated: Mar 29, 2026

Quick Overview

This question evaluates a candidate's competence in designing large-scale analytics backends, covering data ingestion, event and metric schemas, near-real-time and historical analytics, metric computation and slicing, data freshness and deduplication, privacy and access control, operational monitoring, and the API/query layer.

  • easy
  • Salesforce
  • System Design
  • Backend Engineer

Design a Chat Analytics Backend

Company: Salesforce

Role: Backend Engineer

Category: System Design

Difficulty: easy

Interview Round: Onsite

Design the backend of an internal analytics system for a conversational AI product similar to ChatGPT. The goal is to power an analytical metrics dashboard used by product managers and backend engineers. The dashboard itself and the LLM serving stack are out of scope. Focus on the data platform and backend services that collect data from existing production databases and service logs, compute product and reliability metrics, and serve those metrics to the dashboard. Your design should address: - How to ingest data from existing services without overloading primary databases - What event and metric schemas you would use - How to support both near-real-time metrics and historical analysis - How to compute common metrics such as daily active users, number of conversations, request volume, latency percentiles, token usage, error rates, and feature adoption - How to slice metrics by dimensions such as time, model version, region, platform, and user segment - Data freshness, correctness, deduplication, and backfills - Privacy, access control, and operational monitoring - The APIs or query layer that a dashboard backend would call Assume the system must support large-scale traffic and multi-month historical retention.

Quick Answer: This question evaluates a candidate's competence in designing large-scale analytics backends, covering data ingestion, event and metric schemas, near-real-time and historical analytics, metric computation and slicing, data freshness and deduplication, privacy and access control, operational monitoring, and the API/query layer.

Related Interview Questions

  • Design a TikTok-like short video platform - Salesforce (medium)
  • Design a configurable monthly API rate limiter - Salesforce (medium)
  • Design a scalable coffee ordering notification system - Salesforce (medium)
  • Design a pipeline orchestration system on Kubernetes - Salesforce (medium)
  • Design an async job system and cache layer - Salesforce (hard)
|Home/System Design/Salesforce

Design a Chat Analytics Backend

Salesforce logo
Salesforce
Dec 4, 2025, 12:00 AM
easyBackend EngineerOnsiteSystem Design
4
0

Design the backend of an internal analytics system for a conversational AI product similar to ChatGPT. The goal is to power an analytical metrics dashboard used by product managers and backend engineers.

The dashboard itself and the LLM serving stack are out of scope. Focus on the data platform and backend services that collect data from existing production databases and service logs, compute product and reliability metrics, and serve those metrics to the dashboard.

Your design should address:

  • How to ingest data from existing services without overloading primary databases
  • What event and metric schemas you would use
  • How to support both near-real-time metrics and historical analysis
  • How to compute common metrics such as daily active users, number of conversations, request volume, latency percentiles, token usage, error rates, and feature adoption
  • How to slice metrics by dimensions such as time, model version, region, platform, and user segment
  • Data freshness, correctness, deduplication, and backfills
  • Privacy, access control, and operational monitoring
  • The APIs or query layer that a dashboard backend would call

Assume the system must support large-scale traffic and multi-month historical retention.

Submit Your Answer to Earn 20XP

Sign in to leave a comment

Loading comments...

Browse More Questions

More System Design•More Salesforce•More Backend Engineer•Salesforce Backend Engineer•Salesforce System Design•Backend Engineer System Design

Your design canvas — auto-saved

PracHub

Master your tech interviews with 8,000+ real questions from top companies.

Product

  • Questions
  • Learning Tracks
  • Interview Guides
  • Resources
  • Premium
  • For Universities
  • Student Access

Browse

  • By Company
  • By Role
  • By Category
  • Topic Hubs
  • SQL Questions
  • AI Coding Questions
  • Compare Platforms
  • Discord Community

Support

  • support@prachub.com
  • (916) 541-4762

Legal

  • Privacy Policy
  • Terms of Service
  • About Us

© 2026 PracHub. All rights reserved.