Lobyco Nexus - nex_*

Tables in the Lobyco Nexus data package (nex_*).

The Lobyco Nexus package contains data related to audience definitions, audience membership, contextual reference data, and orchestration flows used to activate and manage customer targeting across the platform. It serves as the foundation for defining who should be targeted, how audiences are structured, and how activation flows are configured and executed across channels.

Scope

This package includes:

• Audience-to-customer relationships
• Campaign-to-audience relationships
• Audience size and last execution references
• Product and store context reference data

It does not include detailed segmentation rule logic, property-level filtering configurations, destination mappings, or internal platform configuration settings.

Key Principle

The Lobyco Nexus package represents how customers are grouped in audiences and how those are linked to Orchestration campaigns. Campaigns are groups of activities (available in either Communication or Loyalty and Promotion data package), where each activity can be linked to an audience which is linked or triggered by an Orchestration campaign.

Audience — nex_audience

Definition

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

Sample data

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

Audience Customer — nex_audience_customer

Definition

Property	Type	Description
AudienceId	string	Unique identifier for each audience
CustomerId	string	Unique identifier for each customer

Sample data

AudienceId	CustomerId
091	021
032	052
043	083

Product — nex_product

Definition

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

Sample data

Id	Name	BrandName	ExternalId
001	Diet soda	Coca-Cola	013
002	Toothpaste	Colgate	043
003	Apple juice	Pfanner	054

Store — nex_store

Definition

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)

Sample data

Id	Name	Country	City	PostalCode	ChainId
001	Coop DK	Denmark	Copenhagen	1473	011
002	Southern Coop	England	Portsmouth	PO3	003
003	Coop DK	Denmark	Aarhus	8220	011

Campaign — nex_campaign

Definition

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

Sample data

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