Scope
This package includes:- Audience-to-customer relationships
- Campaign-to-audience relationships
- Audience size and last execution references
- Product and store context reference data
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Tables in the Lobyco Nexus data package (nex_*).
nex_audience| Property | Type | Description |
|---|---|---|
| Id | string | Unique identifier for each audience segment |
| AudienceId | string | Unique audience identifier |
| AudienceName | string | Name of the audience segment |
| Description | string | Description of the audience segment |
| LastExecutionId | string | Identifier for the last execution of the audience segment |
| Size | int | Number of customers in the audience |
| Id | AudienceId | AudienceName | Description | LastExecutionId | Size |
|---|---|---|---|---|---|
| 001 | 061 | Regulars | Frequent store visitors | 001 | 25000 |
| 002 | 032 | Teens | Customers aged 13-19 | 002 | 12000 |
| 003 | 083 | First-timers | New customers | 003 | 5400 |
nex_audience_customer| Property | Type | Description |
|---|---|---|
| AudienceId | string | Unique identifier for each audience |
| CustomerId | string | Unique identifier for each customer |
| AudienceId | CustomerId |
|---|---|
| 091 | 021 |
| 032 | 052 |
| 043 | 083 |
nex_product| Property | Type | Description |
|---|---|---|
| Id | string | Unique identifier for the product |
| Name | string | Name of the product |
| BrandName | string | Name of the brand associated with the product |
| ExternalId | string | External identifier for the product |
| Id | Name | BrandName | ExternalId |
|---|---|---|---|
| 001 | Diet soda | Coca-Cola | 013 |
| 002 | Toothpaste | Colgate | 043 |
| 003 | Apple juice | Pfanner | 054 |
nex_store| Property | Type | Description |
|---|---|---|
| Id | string | Id of the store (Primary Key) |
| Name | string | Name of the store |
| Country | string | Country where the store is located |
| City | string | City where the store is located |
| PostalCode | string | Postal code of the store location |
| ChainId | string | Id of the store chain (Primary Key) |
| Id | Name | Country | City | PostalCode | ChainId |
|---|---|---|---|---|---|
| 001 | Fjordco | Denmark | Copenhagen | 1473 | 011 |
| 002 | Harbour Foods | England | Portsmouth | PO3 | 003 |
| 003 | Fjordco | Denmark | Aarhus | 8220 | 011 |
nex_campaign| Property | Type | Description |
|---|---|---|
| Id | string | Internal surrogate key for the campaign record (Primary Key) |
| Name | string | Campaign name |
| Description | string | Campaign description |
| StartDate | timestamp | Date when a campaign starts |
| EndDate | timestamp | Date when a campaign ends |
| CreatedAt | timestamp | Created date |
| UpdatedAt | timestamp | Last update date |
| IsDeleted | boolean | Flag indicating whether the campaign is deleted |
| LastSuccessExecutionId | string | ID referencing the last successfully completed execution |
| Id | Name | Description | StartDate | EndDate | CreatedAt | UpdatedAt | IsDeleted | LastSuccessExecutionId |
|---|---|---|---|---|---|---|---|---|
| 001 | Winter Deal | Winter campaign | 2026‑01‑10 00:00:00 | 2026‑01‑31 23:59:59 | 2026‑01‑01 00:00:00 | 2026‑01‑20 10:00:00 | false | 001 |
| 002 | Spring Promo | Spring campaign | 2026‑02‑15 08:00:00 | 2026‑03‑01 23:59:59 | 2026‑02‑01 00:00:00 | 2026‑02‑25 14:30:00 | false | 002 |
| 003 | Summer Deal | Summer campaign | 2026‑03‑05 12:00:00 | 2026‑06‑30 23:59:59 | 2026‑03‑01 00:00:00 | 2026‑03‑18 09:45:00 | true | 003 |