# US 2025/0165897 A1 · Computer-implemented Method for Real-Time Group Membership Tracking and Related System

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2025/0165897 A1
- Document ID: US20250165897A1
- Status: Published application
- Kind: A1
- Application number: 18/518,238
- Filed: 2023-11-22
- Published: 2025-05-22
- Earliest claimed: 2023-11-22
- Assignees: Klaviyo, Inc
- Applicants: Klaviyo, Inc.
- Inventors: Michael Boker; Anton Rodionov; Dave Hagman
- Web page: https://patentgrep.com/patent/US20250165897A1

## CPC

- G06Q 10/06393: {Score-carding, benchmarking or key performance indicator [KPI] analysis}
- G06F 16/2365: {Ensuring data consistency and integrity}
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A computer-implemented method for tracking membership of a collection based on new records corresponding to new membership change events. The method comprises receiving a batch of new records for membership change events from a segmentation engine; preprocessing the new records and historic records to exclude invalid membership change events; creating a normalized data table of the valid membership change events; and sending the normalized data table to an analytics processing database for computing at least one metric for the collection based on the normalized data table. Optionally, the collection is an audience and the metric is segment growth. Related computer systems are described.

## Claims

### Claim 1

A computer-implemented method for improving the processing speed of an analytics processing database for tracking membership of a collection based on new records corresponding to new membership change events, the method comprising:
receiving the new records for membership change events;
preprocessing, on a server, the new records to create a normalized data table, wherein the preprocessing comprises:
determining invalid records by reading historic records for memberships present in the new records;
creating normalized records by filtering out invalid records from the historic records and the new records; and
writing the normalized records to the normalized data table;
sending the normalized data table to the analytics processing database;
receiving a user selection via a user input device; and
computing, on the analytics processing database, at least one metric for the collection based on the user selection and the normalized data table.

### Claim 2 (depends on 1)

The method of claim 1, wherein the computing comprises computing at least one metric from the following: size of the collection, population of the collection, and population for the collection for a time period.

### Claim 3 (depends on 1)

The method of claim 1, wherein the computing comprises computing size of the collection, and the method further comprises displaying growth of the collection.

### Claim 4 (depends on 2)

The method of claim 2, comprising displaying at least one channel performance metric selected from the group comprising revenue attributed to email, email open rate, click rate, and placed order rate.

### Claim 5 (depends on 1)

The method of claim 1, wherein the membership change events comprise members added and members removed, and wherein the determining invalid records comprises:
grouping historic records and new records by profile ID and Segment ID;
chronologically arranging the historic records and new records together per group;
identifying the invalid records, in each group, as:
(i) each removed change event that is not preceded by an added change event; and
(ii) each added change event if preceded by an unclosed added change event.

### Claim 6 (depends on 1)

The computer-implemented method of claim 1, wherein the collection is an audience.

### Claim 7 (depends on 1)

The computer-implemented method of claim 1, further comprising continuously reading new records, and generating an initial set of records of membership change events after reading new records.

### Claim 8 (depends on 7)

The computer-implemented method of claim 7, wherein the initial set of records are generated based on previously stored membership data of the collection.

### Claim 9 (depends on 1)

The method of claim 1, further comprising creating a history table comprising the historical records, and wherein the new records are written to the history table.

### Claim 10 (depends on 9)

The method of claim 9, further comprising purging the history table.

### Claim 11 (depends on 1)

The method of claim 1, wherein the computing step is performed in under 1 second.

### Claim 12

A system for improving the processing speed of a database management system operable to compute a metric of a collection, the system comprising:
a new change event data repository where new membership change events are received and recorded to a raw event table;
a historical change event data repository where the new membership change events and existing membership change events are saved in a historical event table;
a normalizer module operable to create a normalized event table by filtering out invalid membership change events from the historical event table;
a normalized change event data repository for recording the normalized event table; and
a database management system operable to compute at least one metric based on the normalized event table from the normalized change event data repository.

### Claim 13 (depends on 12)

The system of claim 12, wherein the normalizer module is operable to:
group historic membership change events and new membership change events by profile ID and Segment ID;
chronologically arrange the historic membership change events and new membership change events together per group;
identify the invalid membership change events, in each group, as:
(i) each removed change event that is not preceded by an added change event; and
(ii) each added change event if preceded by an unclosed added change event; and
filter out the invalid membership change events.

### Claim 14 (depends on 12)

The system of claim 12, wherein the processor is programmed and operable to display growth of the collection responsive to a user selection.

### Claim 15 (depends on 12)

The system of claim 12, further comprising a computing device programmed and operable with the database management system to receive a user selection, and to display the metric.

### Claim 16 (depends on 15)

The system of claim 15, wherein the computing device is a portable computing device selected from the group consisting of a tablet and mobile phone.

### Claim 17 (depends on 12)

The system of claim 12, further comprising a segmentation engine programmed and operable to define a member segment based on a user instruction.

### Claim 18 (depends on 17)

The system of claim 17, wherein the segmentation engine is further programmed and operable to determine a new membership change event based on automatically detecting an action of a sub-user, and to write the new membership change event to the raw data repository for preprocessing.

### Claim 19 (depends on 12)

The system of claim 12, wherein the normalized change event data repository applies a time-based partitioning scheme for recording a normalized event table.

### Claim 20 (depends on 19)

The system of claim 19, wherein the historical change event data repository applies a data clustering scheme for saving the new membership change events and existing membership change events in the historical event table.
