📘

Marketing, Kampagnen & Provisionen

marketing core_platform 🛡️ RLS Protected

Marketing, Kampagnen & Provisionen — aus Code abgeleitete Prozess- und API-Dokumentation.

Fachliche Bestimmung: Marketing orchestriert die Kundenakquise und misst ihre Wirkung bis zur realen Zahlung: Kampagnen mit Vier-Augen-Freigabe und Budget, datenschutzfreundliches Tracking, Lead-Qualifizierung im CRM, versionierte Attribution, Gutscheine, Zielgruppen und Journeys mit Einwilligungsnachweis sowie eine wiederverwendbare Provisions-Engine mit Haltefrist, Storno-/Retourenkorrektur und Auszahlung über die Buchhaltung.

🧠 Fachprozess-Erzählung & KI-Architektur ⚡ Pracovné postupy a životné cykly (0) ⚙️ Fachprozesse & Capabilities (34) 🗄️ Modely údajov & Felder (25) 🔌 Úvodné body (UI & API) (119) 🛡️ Regulatory & Compliance

⚡ Pracovné postupy a životné cykly

Dieses Modul folgt dem standardisierten transaktionalen CRUD- und Event-Lifecycle.

⚙️ Fachprozesse & Capabilities (System-Fachlogik)

Registrierte Fachoperationen und System-Capabilities dieses Moduls zur Steuerung von Workflows, Kaskaden und KI-Agenten.

Gesamt: 34 manual_entry: 1 engine: 33

Capability & Schlüssel	Fachliche Bezeichnung	Ausführung / Coverage	Risikostufe & Freigabe	Effekte & Kaskaden
Agent-Einstieg campaign_strategist_agent `agent_entry:campaign_strategist_agent`	Agent-Einstieg campaign_strategist_agent Quelle: `code:module_agent_map`	manual_entry	✓ Auto	Keine Seiteneffekte deklariert
Provision korrigieren `capability:commission.entitlement.adjust` Op: `commission.entitlement.adjust`	Intent: `commission_entitlement_adjust` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`commission_ledger.adjusted`
Provisionen freigeben `capability:commission.entitlement.approve` Op: `commission.entitlement.approve`	Intent: `commission_entitlement_approve` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`commission_entitlement.approved`
Auszahlungslauf freigeben `capability:commission.payout.approve` Op: `commission.payout.approve`	Intent: `commission_payout_approve` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `irreversible`	`commission_payout.invoiced` `invoice.drafted`
Auszahlungslauf bilden `capability:commission.payout.create` Op: `commission.payout.create`	Intent: `commission_payout_create` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`commission_payout.created`
Provisionsregel simulieren `capability:commission.rule.evaluate` Op: `commission.rule.evaluate`	Intent: `commission_rule_evaluate` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `read_only`	Keine Seiteneffekte deklariert
Provisionsregel versionieren `capability:commission.rule.version` Op: `commission.rule.version`	Intent: `commission_rule_version` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `metadata`	`commission_rule.versioned`
Zielgruppe auswerten `capability:marketing.audience.evaluate` Op: `marketing.audience.evaluate`	Intent: `marketing_audience_evaluate` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `metadata`	`marketing_audience.evaluated`
Zielgruppe exportieren `capability:marketing.audience.export` Op: `marketing.audience.export`	Intent: `marketing_audience_export` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `external_effect`	`marketing_audience.exported`
Budget prüfen `capability:marketing.budget.alert` Op: `marketing.budget.alert`	Intent: `marketing_budget_alert` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `metadata`	`marketing_alert.raised`
Budgetprognose `capability:marketing.budget.forecast` Op: `marketing.budget.forecast`	Intent: `marketing_budget_forecast` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `read_only`	Keine Seiteneffekte deklariert
Kampagne aktivieren `capability:marketing.campaign.activate` Op: `marketing.campaign.activate`	Intent: `marketing_campaign_activate` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_campaign.activated`
Kampagne freigeben `capability:marketing.campaign.approve` Op: `marketing.campaign.approve`	Intent: `marketing_campaign_approve` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_campaign.approved`
Kampagne beenden `capability:marketing.campaign.complete` Op: `marketing.campaign.complete`	Intent: `marketing_campaign_complete` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_campaign.completed`
Kampagne anlegen `capability:marketing.campaign.create` Op: `marketing.campaign.create`	Intent: `marketing_campaign_create` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_campaign.created`
Kampagne aus Branchenvorlage `capability:marketing.campaign.instantiate_template` Op: `marketing.campaign.instantiate_template`	Intent: `marketing_campaign_instantiate_template` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_campaign.created`
Kampagne pausieren `capability:marketing.campaign.pause` Op: `marketing.campaign.pause`	Intent: `marketing_campaign_pause` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_campaign.paused`
Kampagnen-Kennzahlen `capability:marketing.campaign.report` Op: `marketing.campaign.report`	Intent: `marketing_campaign_report` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `read_only`	Keine Seiteneffekte deklariert
Kampagne zur Freigabe einreichen `capability:marketing.campaign.submit` Op: `marketing.campaign.submit`	Intent: `marketing_campaign_submit` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_campaign.submitted`
Prüffall entscheiden `capability:marketing.fraud.resolve` Op: `marketing.fraud.resolve`	Intent: `marketing_fraud_resolve` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_fraud_case.resolved`
Journey starten `capability:marketing.journey.execute` Op: `marketing.journey.execute`	Intent: `marketing_journey_execute` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_journey.started`
Journeys stoppen `capability:marketing.journey.stop` Op: `marketing.journey.stop`	Intent: `marketing_journey_stop` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_journey.stopped`
Lead erfassen `capability:marketing.lead.capture` Op: `marketing.lead.capture`	Intent: `marketing_lead_capture` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`crm_lead.created` `marketing_touchpoint.recorded`
Lead qualifizieren `capability:marketing.lead.qualify` Op: `marketing.lead.qualify`	Intent: `marketing_lead_qualify` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `metadata`	`marketing_lead.qualified`
Lead zuweisen `capability:marketing.lead.route` Op: `marketing.lead.route`	Intent: `marketing_lead_route` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_lead.routed`
Partner anlegen `capability:marketing.partner.create` Op: `marketing.partner.create`	Intent: `marketing_partner_create` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_partner.created`
Partnerstatus ändern `capability:marketing.partner.transition` Op: `marketing.partner.transition`	Intent: `marketing_partner_transition` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_partner.status_changed`
Marketing-Abgleich `capability:marketing.reconciliation.run` Op: `marketing.reconciliation.run`	Intent: `marketing_reconciliation_run` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `metadata`	`marketing_reconciliation.run`
Attribution neu berechnen `capability:marketing.tracking.attribute` Op: `marketing.tracking.attribute`	Intent: `marketing_tracking_attribute` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `metadata`	`marketing_attribution.computed`
Tracking-Link erzeugen `capability:marketing.tracking.create_link` Op: `marketing.tracking.create_link`	Intent: `marketing_tracking_create_link` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_tracking_link.created`
Conversion als Dublette verwerfen `capability:marketing.tracking.deduplicate` Op: `marketing.tracking.deduplicate`	Intent: `marketing_tracking_deduplicate` Quelle: `code:capability_registry`	⚙️ Engine	🔒 Freigabe nötig Risiko: `business_record`	`marketing_conversion.invalidated`
Tracking-Ereignis übernehmen `capability:marketing.tracking.ingest` Op: `marketing.tracking.ingest`	Intent: `marketing_tracking_ingest` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_touchpoint.recorded`
Gutschein einlösen `capability:promotion.code.redeem` Op: `promotion.code.redeem`	Intent: `promotion_code_redeem` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `business_record`	`marketing_promotion.redeemed`
Gutscheine prüfen `capability:promotion.rule.evaluate` Op: `promotion.rule.evaluate`	Intent: `promotion_rule_evaluate` Quelle: `code:capability_registry`	⚙️ Engine	✓ Auto Risiko: `read_only`	Keine Seiteneffekte deklariert

🧠 Fachprozess-Erzählung & Dual Knowledge Architektur

Synthese aus der ideologischen Blaupause (Meta-Fachlogik / Soll), der faktischen System-Implementierung (System-Fachlogik / Ist) und No-Code Customizing für KI-Consultants.

Dual Knowledge Layer

📖

Der durchgängige Businessprozess im Detail (End-to-End Fließtext-Erzählung)

Von der Werbeausgabe bis zur Provisionsauszahlung

1. Kampagne planen und freigeben

Eine Kampagne (marketing_campaigns) entsteht als Entwurf – frei oder aus einer Branchenvorlage (cap:marketing.campaign.instantiate_template; Vorlagen E-Commerce, Handwerk, Industrie/B2B, Dienstleister). Zur Freigabe braucht sie Startdatum und Gesamtbudget (cap:marketing.campaign.submit). Freigeben darf nur eine andere Person als die Einreichende (cap:marketing.campaign.approve); erst dann wird aktiviert (cap:marketing.campaign.activate). Aktive Kampagnen sind eingefroren; Änderungen erfordern den Weg zurück in den Entwurf. Kanäle tragen ein Budget und ein deklariertes Connector-Fähigkeitsprofil (spend.import gilt erst als „verifiziert“, wenn eine Connector-Operation gebunden ist).

2. Kontaktpunkte erfassen – ohne Überwachung

Tracking-Links (cap:marketing.tracking.create_link) haben einen zufälligen Code; der Redirect /m/r/{code} zählt den Klick, speichert aber weder IP-Adresse noch User-Agent und setzt kein Cookie. Der Zielseite wird eine zufällige Klick-ID (mkt_click) angehängt. Server-Ereignisse (POST /api/v1/marketing/events, cap:marketing.tracking.ingest) sind idempotent je Schlüssel; ohne Tracking-Einwilligung werden sie ohne Klick- und Sitzungsbezug gespeichert. Bots erhalten keine Klick-ID.

3. Leads gewinnen und qualifizieren

Leads entstehen ausschließlich über CrmService.create_lead (Dublettenprüfung per E-Mail); LeadMarketingService.capture legt daneben das Marketingprofil (marketing_lead_profiles) an, verknüpft Klick und Lead, erfasst Einwilligungen mit Nachweis und bewertet transparent (CRM-Score plus erklärte Marketingpunkte). MQL und SQL folgen den Mandantenschwellen; die Zuweisung erzeugt eine CRM-Aufgabe mit SLA.

4. Abschlüsse werden Conversions

Die MarketingEventBridge hört am Outbox-Worker auf QUOTE_ACCEPTED (auch E-Commerce-Bestellungen mit eigenen Gutschein- oder Empfehlungscodes im Bestell-Snapshot), CONTRACT_STATUS_CHANGED → active, INVOICE_STATUS_CHANGED und CRM_LEAD_STATUS_CHANGED. Eine Conversion entsteht nur mit Marketingbezug (Kampagnenkontakt, Partner oder Code). Zustände: observed → validated → attributed → financially_confirmed, Sonderpfade invalidated und reversed.

5. Attribution – analytisch und vertraglich getrennt

Analytisch verteilt jedes aktive, versionierte Modell (First, Last, Linear, Positionsbasiert, Time Decay) den Betrag auf die Kontaktpunkte im Fenster. Vertraglich erhält genau ein Partner die Provision: manuelle Zuordnung vor Empfehlungscode vor partnergebundenem Gutschein vor Partnerklick im Fenster der Vereinbarung.

6. Provision berechnen, prüfen, auszahlen

Die CommissionEngine (Paket app.modules.commissions) sucht die Vereinbarung und die Regelversion zum Stichtag, prüft Partnerstatus, Währung und Filter, berechnet (CPL, CPA, CPS, Fix, Umsatz-/Deckungsbeitragsprozent, wiederkehrend, Staffel, Bonus, Hybrid, Split, mehrstufig) und speichert Eingangsgrößen und Rechenweg. Nach bestätigter Zahlung beginnt die Haltefrist; danach ist der Anspruch freigabefähig (cap:commission.entitlement.approve). Der Auszahlungslauf (cap:commission.payout.create) saldiert je Partner; die Freigabe durch eine zweite Person (cap:commission.payout.approve) erzeugt je Partner einen Lieferantenrechnungs-Entwurf. „Ausgezahlt“ wird erst gebucht, wenn die Buchhaltung diese Rechnung bezahlt.

7. Korrigieren statt überschreiben

Storno einer Rechnung kehrt die Conversion vollständig um, eine Gutschrift mit Bezug zur Rechnung anteilig. Das Provisionsledger (commission_ledger_entries) ist append-only: Vorläufig, Korrektur, Storno, Auszahlung. Nach einer Auszahlung entsteht ein negativer Saldo, der mit dem nächsten Lauf verrechnet wird.

8. Schützen und abgleichen

Fraud-Signale (Self-Referral, Klickflut, Bots, schnelle Conversion, Dubletten, Auffälligkeiten) erzeugen Prüffälle; betroffene Provisionen werden nur zurückgehalten. Entscheidung und Partnersperre bleiben menschlich. Der Abgleich (cap:marketing.reconciliation.run) stellt Plattform-, attribuierte und bezahlte Conversions gegenüber und prüft Auszahlungsrechnungen gegen das Ledger.

🏛️

Meta-Fachlogik: Ideologische Blaupause, Soll-Weltbild & Normen

Meta-Fachlogik

Verantwortungsteilung: Marketing misst, CRM führt Leads, Verkauf Aufträge, Finanzen die finanzielle Wahrheit, Verträge die Vereinbarungen, die Provisions-Engine die Ansprüche.
Wahrheit vor Plattformzahlen: Erfolg zählt erst mit Zahlung; Plattform-Conversions sind Information.
Historie ist unantastbar: Regeln, Modelle und Einwilligungen werden versioniert, Korrekturen gebucht.
Privacy by Design: Kein Fingerprinting, keine probabilistische Identität, Einwilligung je Zweck.
KI assistiert: Vorschläge mit Konfidenz und Begründung; Freigaben, Exporte, Zahlungen bleiben menschlich.

⚙️

Systemische Fachlogik: Faktische Umsetzung in Centurio ERP & Capabilities

Systemische Fachlogik

Services: CampaignService, TrackingService, LeadMarketingService, ConsentService, PartnerService, PromotionService, AudienceService, JourneyService, FraudService, MarketingAnalytics, CommissionEngine.
Ereignisse: MarketingEventBridge (Outbox), MarketingLoop (Haltefristen, Journeys, SLA, Budget, Klick-Scan).
Append-only: marketing_touchpoints, marketing_consent_records, marketing_message_dispatches, commission_rule_versions, commission_ledger_entries.
Rechte: Modul marketing; Vertriebsleitung verwaltet, Vertrieb und Büro schreiben, Buchhaltung liest.
Öffentlich: /m/r/{code} (Redirect), /m/u/{token} (Abmeldung, nur per POST wirksam).

🤖

KI-Consultant Leitfaden: Customizing- & No-Code-Konzept (Soll-Ist-Synthese)

AI Solution Architect Blueprint

KI-Consultant Blueprint

Branche des Mandanten lesen (tool:get_marketing_process_template) und die passende Vorlage vorschlagen.
Provisionsregel mit tool:simulate_commission_rule an einem Beispielbetrag erklären.
Kampagnenentwurf aus Vorlage anlegen lassen (tool:create_campaign_from_template) – nur nach Bestätigung.
Hinweise zu Pflichtentscheidungen geben: Haltefrist, Zahlungsempfänger und Steuersatz der Abrechnung, MQL-/SQL-Schwellen, Einwilligungsnachweise.
Keine Behauptungen über Rechtmäßigkeit; Werbeplattform-Anbindungen nur über gebundene Connector-Operationen.

📚 Operative Prozessbegriffe & Transaktionsschnittstellen

Zentrale Fachbegriffe im Prozesszusammenhang (Operatives Modell)

Tracking-Link

Kampagnenlink mit UTM-Parametern und zufälligem Code

Conversion

Marketingrelevanter Abschluss mit Zustandsautomat

Attribution

Analytische Verteilung der Wirkung auf Kontaktpunkte

Vertragliche Zuordnung

Ein provisionsberechtigter Partner je Abschluss

Haltefrist

Wartezeit nach Zahlung vor der Provisionsfreigabe

Clawback

Rückforderung nach Storno/Retoure einer ausgezahlten Provision

ROAS

Attribuierter Umsatz je Werbeausgabe

MQL/SQL

Marketing- bzw. vertriebsqualifizierter Lead

📥 Eingänge & Trigger (Inputs)

Kampagnenziele und Budgets
Werbeausgaben (manuell, CSV, API, Connector)
Klicks und Server-Ereignisse
Leads, Angebote, Verträge, Rechnungen, Gutschriften
Partnervereinbarungen
Einwilligungsnachweise

📤 Ausgänge & Arbeitsergebnisse (Outputs)

Kampagnenkennzahlen (CTR, CPC, CPL, CPA, ROAS, ROI, tatsächlicher Gewinn)
Qualifizierte Leads mit Herkunft
Provisionsansprüche und Auszahlungsläufe
Lieferantenrechnungs-Entwürfe
Abgleichsberichte und Prüffälle

⚡ Kaskaden & Folgeprozesse (Cascades)

QUOTE_ACCEPTED -> order_conversion
INVOICE_STATUS_CHANGED paid -> commission_hold_starts
credit_note issued -> proportional_reversal
invoice cancelled -> full_reversal
supplier_invoice paid -> payout_posted
consent withdrawn -> journeys_stopped

🛡️ Nebenprozesse & Resilienz

Fraud-Prüffall
Budgetwarnung mit Aufgabe
Lead-SLA-Hinweis
Zielgruppenexport

💡 No-Code Checkliste & Praxistipps

Schwellen unter Marketing → Einstellungen
Attributionsmodelle als neue Versionen
Haltefrist je Regel
Zahlungsempfänger je Partner
Journeys mit zweiter Person aktivieren

🗄️ Modely údajov & Felder

MarketingAlerts marketing_alerts RLS Aktiv

17 Poľy / stĺpce

Tabelle marketing_alerts

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`kind`	`VARCHAR(24)`	Ja *	-	Feld kind
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`message`	`TEXT`	Ja *	-	Feld message
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`task_id`	`UUID`	Nein	-	Feld task_id
`acknowledged_by`	`UUID`	Nein	-	Feld acknowledged_by
`acknowledged_at`	`DATETIME`	Nein	-	Feld acknowledged_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingAttributionPolicies marketing_attribution_policies RLS Aktiv

19 Poľy / stĺpce

Tabelle marketing_attribution_policies

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`key`	`VARCHAR(48)`	Ja *	-	Feld key
`version`	`INTEGER`	Ja *	-	Feld version
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`model`	`VARCHAR(16)`	Ja *	-	Feld model
`window_days`	`INTEGER`	Ja *	-	Feld window_days
`first_weight_pct`	`NUMERIC(5, 2)`	Ja *	-	Feld first_weight_pct
`last_weight_pct`	`NUMERIC(5, 2)`	Ja *	-	Feld last_weight_pct
`half_life_days`	`NUMERIC(6, 2)`	Ja *	-	Feld half_life_days
`include_impressions`	`BOOLEAN`	Ja *	-	Feld include_impressions
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingAttributionResults marketing_attribution_results RLS Aktiv

14 Poľy / stĺpce

Tabelle marketing_attribution_results

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`conversion_id`	`UUID`	Ja *	FK ➔ marketing_conversions.id	Feld conversion_id
`policy_id`	`UUID`	Ja *	FK ➔ marketing_attribution_policies.id	Feld policy_id
`touchpoint_id`	`UUID`	Ja *	FK ➔ marketing_touchpoints.id	Feld touchpoint_id
`campaign_id`	`UUID`	Nein	-	Feld campaign_id
`channel_id`	`UUID`	Nein	-	Feld channel_id
`partner_id`	`UUID`	Nein	-	Feld partner_id
`weight`	`NUMERIC(9, 6)`	Ja *	-	Feld weight
`credited_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld credited_amount
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingAudienceMembers marketing_audience_members RLS Aktiv

9 Poľy / stĺpce

Tabelle marketing_audience_members

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`audience_id`	`UUID`	Ja *	FK ➔ marketing_audiences.id	Feld audience_id
`customer_id`	`UUID`	Ja *	-	Feld customer_id
`evaluated_at`	`DATETIME`	Ja *	-	Feld evaluated_at
`facts`	`JSONB`	Ja *	-	Feld facts
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingAudiences marketing_audiences RLS Aktiv

16 Poľy / stĺpce

Tabelle marketing_audiences

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`purpose`	`VARCHAR(24)`	Ja *	-	Feld purpose
`rules`	`JSONB`	Ja *	-	Feld rules
`exclusions`	`JSONB`	Ja *	-	Feld exclusions
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`member_count`	`INTEGER`	Ja *	-	Feld member_count
`last_evaluated_at`	`DATETIME`	Nein	-	Feld last_evaluated_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingCampaignChannels marketing_campaign_channels RLS Aktiv

20 Poľy / stĺpce

Tabelle marketing_campaign_channels

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`campaign_id`	`UUID`	Ja *	FK ➔ marketing_campaigns.id	Feld campaign_id
`channel`	`VARCHAR(16)`	Ja *	-	Feld channel
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`budget`	`NUMERIC(14, 2)`	Nein	-	Feld budget
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`external_platform`	`VARCHAR(64)`	Nein	-	Feld external_platform
`external_id`	`VARCHAR(128)`	Nein	-	Feld external_id
`capability_profile`	`JSONB`	Ja *	-	Feld capability_profile
`spend_operation_id`	`UUID`	Nein	-	Feld spend_operation_id
`sync_status`	`VARCHAR(16)`	Ja *	-	Feld sync_status
`last_sync_at`	`DATETIME`	Nein	-	Feld last_sync_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingCampaigns marketing_campaigns RLS Aktiv

36 Poľy / stĺpce

Tabelle marketing_campaigns

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`code`	`VARCHAR(40)`	Ja *	-	Feld code
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`description`	`TEXT`	Nein	-	Feld description
`parent_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld parent_id
`goal`	`VARCHAR(16)`	Ja *	-	Feld goal
`status`	`VARCHAR(20)`	Ja *	-	Feld status
`industry_process_key`	`VARCHAR(32)`	Nein	-	Feld industry_process_key
`start_date`	`DATE`	Nein	-	Feld start_date
`end_date`	`DATE`	Nein	-	Feld end_date
`regions`	`JSONB`	Ja *	-	Feld regions
`languages`	`JSONB`	Ja *	-	Feld languages
`product_ids`	`JSONB`	Ja *	-	Feld product_ids
`category_ids`	`JSONB`	Ja *	-	Feld category_ids
`audience_id`	`UUID`	Nein	FK ➔ marketing_audiences.id	Feld audience_id
`owner_id`	`UUID`	Nein	-	Feld owner_id
`budget_total`	`NUMERIC(14, 2)`	Nein	-	Feld budget_total
`budget_daily`	`NUMERIC(14, 2)`	Nein	-	Feld budget_daily
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`cost_center`	`VARCHAR(64)`	Nein	-	Feld cost_center
`target_kpis`	`JSONB`	Ja *	-	Feld target_kpis
`external_ids`	`JSONB`	Ja *	-	Feld external_ids
`version`	`INTEGER`	Ja *	-	Feld version
`submitted_by`	`UUID`	Nein	-	Feld submitted_by
`submitted_at`	`DATETIME`	Nein	-	Feld submitted_at
`approved_by`	`UUID`	Nein	-	Feld approved_by
`approved_at`	`DATETIME`	Nein	-	Feld approved_at
`status_reason`	`TEXT`	Nein	-	Feld status_reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingConsentRecords marketing_consent_records RLS Aktiv

15 Poľy / stĺpce

Tabelle marketing_consent_records

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`subject_type`	`VARCHAR(12)`	Ja *	-	Feld subject_type
`subject_id`	`UUID`	Nein	-	Feld subject_id
`email_hash`	`VARCHAR(64)`	Nein	-	Feld email_hash
`purpose`	`VARCHAR(24)`	Ja *	-	Feld purpose
`action`	`VARCHAR(12)`	Ja *	-	Feld action
`legal_basis`	`VARCHAR(24)`	Ja *	-	Feld legal_basis
`source`	`VARCHAR(16)`	Ja *	-	Feld source
`evidence`	`TEXT`	Nein	-	Feld evidence
`recorded_at`	`DATETIME`	Ja *	-	Feld recorded_at
`recorded_by`	`UUID`	Nein	-	Feld recorded_by
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingConversions marketing_conversions RLS Aktiv

37 Poľy / stĺpce

Tabelle marketing_conversions

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`conversion_type`	`VARCHAR(16)`	Ja *	-	Feld conversion_type
`status`	`VARCHAR(24)`	Ja *	-	Feld status
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`occurred_at`	`DATETIME`	Ja *	-	Feld occurred_at
`source_module`	`VARCHAR(32)`	Ja *	-	Feld source_module
`entity_type`	`VARCHAR(48)`	Nein	-	Feld entity_type
`entity_id`	`UUID`	Nein	-	Feld entity_id
`invoice_id`	`UUID`	Nein	-	Feld invoice_id
`customer_id`	`UUID`	Nein	-	Feld customer_id
`lead_id`	`UUID`	Nein	-	Feld lead_id
`click_id`	`VARCHAR(40)`	Nein	-	Feld click_id
`amount`	`NUMERIC(14, 2)`	Ja *	-	Feld amount
`margin_amount`	`NUMERIC(14, 2)`	Nein	-	Feld margin_amount
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`confirmed_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld confirmed_amount
`reversed_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld reversed_amount
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`partner_rule`	`VARCHAR(24)`	Nein	-	Feld partner_rule
`promotion_code_id`	`UUID`	Nein	-	Feld promotion_code_id
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`product_ids`	`JSONB`	Ja *	-	Feld product_ids
`region`	`VARCHAR(16)`	Nein	-	Feld region
`consent_state`	`VARCHAR(12)`	Ja *	-	Feld consent_state
`validated_at`	`DATETIME`	Nein	-	Feld validated_at
`attributed_at`	`DATETIME`	Nein	-	Feld attributed_at
`financially_confirmed_at`	`DATETIME`	Nein	-	Feld financially_confirmed_at
`reversed_at`	`DATETIME`	Nein	-	Feld reversed_at
`status_reason`	`TEXT`	Nein	-	Feld status_reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingCreatives marketing_creatives RLS Aktiv

26 Poľy / stĺpce

Tabelle marketing_creatives

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`campaign_id`	`UUID`	Ja *	FK ➔ marketing_campaigns.id	Feld campaign_id
`channel_id`	`UUID`	Nein	FK ➔ marketing_campaign_channels.id	Feld channel_id
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`kind`	`VARCHAR(16)`	Ja *	-	Feld kind
`variant_key`	`VARCHAR(16)`	Nein	-	Feld variant_key
`headline`	`VARCHAR(255)`	Nein	-	Feld headline
`body`	`TEXT`	Nein	-	Feld body
`landing_url`	`VARCHAR(1024)`	Nein	-	Feld landing_url
`document_id`	`UUID`	Nein	-	Feld document_id
`product_id`	`UUID`	Nein	-	Feld product_id
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`version`	`INTEGER`	Ja *	-	Feld version
`approved_by`	`UUID`	Nein	-	Feld approved_by
`approved_at`	`DATETIME`	Nein	-	Feld approved_at
`ai_generated`	`BOOLEAN`	Ja *	-	Feld ai_generated
`ai_confidence`	`NUMERIC(4, 3)`	Nein	-	Feld ai_confidence
`ai_rationale`	`TEXT`	Nein	-	Feld ai_rationale
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingFraudCases marketing_fraud_cases RLS Aktiv

21 Poľy / stĺpce

Tabelle marketing_fraud_cases

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`kind`	`VARCHAR(20)`	Ja *	-	Feld kind
`severity`	`VARCHAR(8)`	Ja *	-	Feld severity
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`link_id`	`UUID`	Nein	FK ➔ marketing_tracking_links.id	Feld link_id
`conversion_id`	`UUID`	Nein	FK ➔ marketing_conversions.id	Feld conversion_id
`lead_id`	`UUID`	Nein	-	Feld lead_id
`evidence`	`JSONB`	Ja *	-	Feld evidence
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`resolved_by`	`UUID`	Nein	-	Feld resolved_by
`resolved_at`	`DATETIME`	Nein	-	Feld resolved_at
`resolution_note`	`TEXT`	Nein	-	Feld resolution_note
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingIdentityLinks marketing_identity_links RLS Aktiv

11 Poľy / stĺpce

Tabelle marketing_identity_links

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`click_id`	`VARCHAR(40)`	Nein	-	Feld click_id
`session_key`	`VARCHAR(64)`	Nein	-	Feld session_key
`lead_id`	`UUID`	Nein	-	Feld lead_id
`customer_id`	`UUID`	Nein	-	Feld customer_id
`method`	`VARCHAR(20)`	Ja *	-	Feld method
`created_by`	`UUID`	Nein	-	Feld created_by
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingJourneyExecutions marketing_journey_executions RLS Aktiv

19 Poľy / stĺpce

Tabelle marketing_journey_executions

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`journey_id`	`UUID`	Ja *	FK ➔ marketing_journeys.id	Feld journey_id
`journey_version`	`INTEGER`	Ja *	-	Feld journey_version
`customer_id`	`UUID`	Nein	-	Feld customer_id
`lead_id`	`UUID`	Nein	-	Feld lead_id
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`current_step`	`INTEGER`	Ja *	-	Feld current_step
`next_run_at`	`DATETIME`	Nein	-	Feld next_run_at
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`log`	`JSONB`	Ja *	-	Feld log
`stop_reason`	`VARCHAR(64)`	Nein	-	Feld stop_reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingJourneys marketing_journeys RLS Aktiv

22 Poľy / stĺpce

Tabelle marketing_journeys

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`trigger`	`VARCHAR(24)`	Ja *	-	Feld trigger
`trigger_filter`	`JSONB`	Ja *	-	Feld trigger_filter
`steps`	`JSONB`	Ja *	-	Feld steps
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`version`	`INTEGER`	Ja *	-	Feld version
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`audience_id`	`UUID`	Nein	FK ➔ marketing_audiences.id	Feld audience_id
`required_consent_purpose`	`VARCHAR(24)`	Nein	-	Feld required_consent_purpose
`frequency_cap_per_7d`	`INTEGER`	Nein	-	Feld frequency_cap_per_7d
`stop_on_conversion`	`BOOLEAN`	Ja *	-	Feld stop_on_conversion
`approved_by`	`UUID`	Nein	-	Feld approved_by
`approved_at`	`DATETIME`	Nein	-	Feld approved_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingLeadProfiles marketing_lead_profiles RLS Aktiv

23 Poľy / stĺpce

Tabelle marketing_lead_profiles

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`lead_id`	`UUID`	Ja *	FK ➔ crm_leads.id	Feld lead_id
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`first_touchpoint_id`	`UUID`	Nein	-	Feld first_touchpoint_id
`capture_channel`	`VARCHAR(16)`	Ja *	-	Feld capture_channel
`lifecycle`	`VARCHAR(16)`	Ja *	-	Feld lifecycle
`score`	`INTEGER`	Ja *	-	Feld score
`score_reasons`	`JSONB`	Ja *	-	Feld score_reasons
`mql_at`	`DATETIME`	Nein	-	Feld mql_at
`sql_at`	`DATETIME`	Nein	-	Feld sql_at
`routed_to`	`UUID`	Nein	-	Feld routed_to
`routed_at`	`DATETIME`	Nein	-	Feld routed_at
`sla_due_at`	`DATETIME`	Nein	-	Feld sla_due_at
`duplicate_count`	`INTEGER`	Ja *	-	Feld duplicate_count
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingMessageDispatches marketing_message_dispatches RLS Aktiv

15 Poľy / stĺpce

Tabelle marketing_message_dispatches

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`channel`	`VARCHAR(12)`	Ja *	-	Feld channel
`customer_id`	`UUID`	Nein	-	Feld customer_id
`lead_id`	`UUID`	Nein	-	Feld lead_id
`journey_id`	`UUID`	Nein	-	Feld journey_id
`execution_id`	`UUID`	Nein	-	Feld execution_id
`subject`	`VARCHAR(255)`	Nein	-	Feld subject
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`error`	`VARCHAR(255)`	Nein	-	Feld error
`sent_at`	`DATETIME`	Ja *	-	Feld sent_at
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingPartners marketing_partners RLS Aktiv

26 Poľy / stĺpce

Tabelle marketing_partners

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`partner_type`	`VARCHAR(20)`	Ja *	-	Feld partner_type
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`email`	`VARCHAR(320)`	Nein	-	Feld email
`referral_code`	`VARCHAR(32)`	Nein	-	Feld referral_code
`parent_partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld parent_partner_id
`supplier_id`	`UUID`	Nein	FK ➔ suppliers.id	Feld supplier_id
`customer_id`	`UUID`	Nein	FK ➔ customers.id	Feld customer_id
`sales_agent_id`	`UUID`	Nein	FK ➔ sales_agents.id	Feld sales_agent_id
`contract_id`	`UUID`	Nein	-	Feld contract_id
`employee_user_id`	`UUID`	Nein	-	Feld employee_user_id
`payout_currency`	`VARCHAR(3)`	Ja *	-	Feld payout_currency
`payout_tax_rate`	`NUMERIC(5, 2)`	Nein	-	Feld payout_tax_rate
`verified_at`	`DATETIME`	Nein	-	Feld verified_at
`verified_by`	`UUID`	Nein	-	Feld verified_by
`verification_note`	`TEXT`	Nein	-	Feld verification_note
`status_reason`	`TEXT`	Nein	-	Feld status_reason
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingPromotionCodes marketing_promotion_codes RLS Aktiv

13 Poľy / stĺpce

Tabelle marketing_promotion_codes

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`promotion_id`	`UUID`	Ja *	FK ➔ marketing_promotions.id	Feld promotion_id
`code`	`VARCHAR(32)`	Ja *	-	Feld code
`max_redemptions`	`INTEGER`	Nein	-	Feld max_redemptions
`active`	`BOOLEAN`	Ja *	-	Feld active
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingPromotionRedemptions marketing_promotion_redemptions RLS Aktiv

19 Poľy / stĺpce

Tabelle marketing_promotion_redemptions

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`promotion_id`	`UUID`	Ja *	FK ➔ marketing_promotions.id	Feld promotion_id
`code_id`	`UUID`	Nein	FK ➔ marketing_promotion_codes.id	Feld code_id
`customer_id`	`UUID`	Nein	-	Feld customer_id
`order_ref`	`VARCHAR(128)`	Ja *	-	Feld order_ref
`order_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld order_amount
`discount_amount`	`NUMERIC(14, 2)`	Ja *	-	Feld discount_amount
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`reversed_at`	`DATETIME`	Nein	-	Feld reversed_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingPromotions marketing_promotions RLS Aktiv

28 Poľy / stĺpce

Tabelle marketing_promotions

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`name`	`VARCHAR(255)`	Ja *	-	Feld name
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`kind`	`VARCHAR(16)`	Ja *	-	Feld kind
`value`	`NUMERIC(14, 2)`	Ja *	-	Feld value
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`valid_from`	`DATETIME`	Nein	-	Feld valid_from
`valid_to`	`DATETIME`	Nein	-	Feld valid_to
`min_order_amount`	`NUMERIC(14, 2)`	Nein	-	Feld min_order_amount
`max_discount_amount`	`NUMERIC(14, 2)`	Nein	-	Feld max_discount_amount
`include_product_ids`	`JSONB`	Ja *	-	Feld include_product_ids
`include_category_ids`	`JSONB`	Ja *	-	Feld include_category_ids
`exclude_product_ids`	`JSONB`	Ja *	-	Feld exclude_product_ids
`customer_ids`	`JSONB`	Ja *	-	Feld customer_ids
`combinable`	`BOOLEAN`	Ja *	-	Feld combinable
`priority`	`INTEGER`	Ja *	-	Feld priority
`max_redemptions`	`INTEGER`	Nein	-	Feld max_redemptions
`max_per_customer`	`INTEGER`	Nein	-	Feld max_per_customer
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingReconciliationRuns marketing_reconciliation_runs RLS Aktiv

14 Poľy / stĺpce

Tabelle marketing_reconciliation_runs

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`period_start`	`DATE`	Ja *	-	Feld period_start
`period_end`	`DATE`	Ja *	-	Feld period_end
`status`	`VARCHAR(12)`	Ja *	-	Feld status
`results`	`JSONB`	Ja *	-	Feld results
`findings`	`JSONB`	Ja *	-	Feld findings
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingSettings marketing_settings RLS Aktiv

20 Poľy / stĺpce

Tabelle marketing_settings

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`default_attribution_policy_id`	`UUID`	Nein	-	Feld default_attribution_policy_id
`click_dedup_seconds`	`INTEGER`	Ja *	-	Feld click_dedup_seconds
`click_burst_threshold`	`INTEGER`	Ja *	-	Feld click_burst_threshold
`budget_alert_percent`	`INTEGER`	Ja *	-	Feld budget_alert_percent
`require_tracking_consent`	`BOOLEAN`	Ja *	-	Feld require_tracking_consent
`mql_score`	`INTEGER`	Ja *	-	Feld mql_score
`sql_score`	`INTEGER`	Ja *	-	Feld sql_score
`lead_sla_hours`	`INTEGER`	Ja *	-	Feld lead_sla_hours
`default_lead_owner_id`	`UUID`	Nein	-	Feld default_lead_owner_id
`frequency_cap_per_7d`	`INTEGER`	Ja *	-	Feld frequency_cap_per_7d
`conversion_window_days`	`INTEGER`	Ja *	-	Feld conversion_window_days
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingSpend marketing_spend RLS Aktiv

21 Poľy / stĺpce

Tabelle marketing_spend

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`campaign_id`	`UUID`	Ja *	FK ➔ marketing_campaigns.id	Feld campaign_id
`channel_id`	`UUID`	Nein	FK ➔ marketing_campaign_channels.id	Feld channel_id
`spend_date`	`DATE`	Ja *	-	Feld spend_date
`amount`	`NUMERIC(14, 2)`	Ja *	-	Feld amount
`currency`	`VARCHAR(3)`	Ja *	-	Feld currency
`impressions`	`INTEGER`	Ja *	-	Feld impressions
`clicks`	`INTEGER`	Ja *	-	Feld clicks
`platform_conversions`	`INTEGER`	Ja *	-	Feld platform_conversions
`platform_conversion_value`	`NUMERIC(14, 2)`	Ja *	-	Feld platform_conversion_value
`source`	`VARCHAR(16)`	Ja *	-	Feld source
`external_key`	`VARCHAR(128)`	Ja *	-	Feld external_key
`invoice_id`	`UUID`	Nein	-	Feld invoice_id
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingTouchpoints marketing_touchpoints RLS Aktiv

28 Poľy / stĺpce

Tabelle marketing_touchpoints

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`event_type`	`VARCHAR(16)`	Ja *	-	Feld event_type
`schema_version`	`INTEGER`	Ja *	-	Feld schema_version
`occurred_at`	`DATETIME`	Ja *	-	Feld occurred_at
`source`	`VARCHAR(12)`	Ja *	-	Feld source
`idempotency_key`	`VARCHAR(160)`	Ja *	-	Feld idempotency_key
`campaign_id`	`UUID`	Nein	FK ➔ marketing_campaigns.id	Feld campaign_id
`channel_id`	`UUID`	Nein	FK ➔ marketing_campaign_channels.id	Feld channel_id
`link_id`	`UUID`	Nein	FK ➔ marketing_tracking_links.id	Feld link_id
`creative_id`	`UUID`	Nein	FK ➔ marketing_creatives.id	Feld creative_id
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`click_id`	`VARCHAR(40)`	Nein	-	Feld click_id
`session_key`	`VARCHAR(64)`	Nein	-	Feld session_key
`lead_id`	`UUID`	Nein	-	Feld lead_id
`customer_id`	`UUID`	Nein	-	Feld customer_id
`entity_type`	`VARCHAR(48)`	Nein	-	Feld entity_type
`entity_id`	`UUID`	Nein	-	Feld entity_id
`amount`	`NUMERIC(14, 2)`	Nein	-	Feld amount
`currency`	`VARCHAR(3)`	Nein	-	Feld currency
`consent_state`	`VARCHAR(12)`	Ja *	-	Feld consent_state
`consent_reference`	`VARCHAR(128)`	Nein	-	Feld consent_reference
`bot_suspected`	`BOOLEAN`	Ja *	-	Feld bot_suspected
`duplicate_of_id`	`UUID`	Nein	-	Feld duplicate_of_id
`props`	`JSONB`	Ja *	-	Feld props
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

MarketingTrackingLinks marketing_tracking_links RLS Aktiv

23 Poľy / stĺpce

Tabelle marketing_tracking_links

Feldname	Typ údajov	Povinnosť	Schlüssel	Využitie
`code`	`VARCHAR(16)`	Ja *	-	Feld code
`label`	`VARCHAR(255)`	Nein	-	Feld label
`campaign_id`	`UUID`	Ja *	FK ➔ marketing_campaigns.id	Feld campaign_id
`channel_id`	`UUID`	Nein	FK ➔ marketing_campaign_channels.id	Feld channel_id
`creative_id`	`UUID`	Nein	FK ➔ marketing_creatives.id	Feld creative_id
`partner_id`	`UUID`	Nein	FK ➔ marketing_partners.id	Feld partner_id
`target_url`	`VARCHAR(1024)`	Ja *	-	Feld target_url
`utm_source`	`VARCHAR(128)`	Nein	-	Feld utm_source
`utm_medium`	`VARCHAR(128)`	Nein	-	Feld utm_medium
`utm_campaign`	`VARCHAR(128)`	Nein	-	Feld utm_campaign
`utm_content`	`VARCHAR(128)`	Nein	-	Feld utm_content
`utm_term`	`VARCHAR(128)`	Nein	-	Feld utm_term
`active`	`BOOLEAN`	Ja *	-	Feld active
`expires_at`	`DATETIME`	Nein	-	Feld expires_at
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`created_by`	`UUID`	Nein	-	Feld created_by
`updated_by`	`UUID`	Nein	-	Feld updated_by
`source_type`	`VARCHAR(32)`	Nein	-	Feld source_type
`source_id`	`UUID`	Nein	-	Feld source_id
`metadata`	`JSONB`	Ja *	-	Feld metadata

🔌 Úvodné body (UI & API)

Art	Metód	Koniec / cesta	Titel & Zweck	Uprava
⚡ REST API	GET	`/api/v1/marketing/agreements`	list_agreements Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/attribution-policies`	list_policies Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/audiences`	list_audiences Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/campaigns`	list_campaigns Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/campaigns/{campaign_id}`	get_campaign Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/campaigns/{campaign_id}/kpis`	campaign_kpis Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/consents`	consent_history Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/conversions`	list_conversions Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/entitlements`	list_entitlements Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/entitlements/{entitlement_id}/explain`	explain_entitlement Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/fraud-cases`	list_fraud Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/journeys`	list_journeys Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/leads/{lead_id}/profile`	lead_profile Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/links`	list_links Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/overview`	Prehľad Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/partners`	list_partners Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/partners/{partner_id}/statement`	partner_statement Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/payouts`	list_payouts Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/promotions`	list_promotions Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/settings`	get_settings Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/api/v1/marketing/templates`	templates Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing`	overview_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/audiences`	audiences_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/campaigns`	campaigns_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/campaigns/{campaign_id}`	campaign_detail Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/commissions`	commissions_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/fraud`	fraud_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/journeys`	journeys_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/leads`	leads_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/partners`	partners_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/promotions`	promotions_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/settings`	settings_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	GET	`/marketing/tracking`	tracking_page Semantic binding: inventory_only; mutation=False	`marketing`
⚡ REST API	PATCH	`/api/v1/marketing/campaigns/{campaign_id}`	patch_campaign Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	PATCH	`/api/v1/marketing/partners/{partner_id}`	patch_partner Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/agreements`	create_agreement Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/agreements/{agreement_id}/activate`	activate_agreement Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/agreements/{agreement_id}/rules`	add_rule Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/alerts/{alert_id}/acknowledge`	acknowledge_alert Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/attribution-policies`	save_policy Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/audiences`	save_audience Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/audiences/{audience_id}/evaluate`	evaluate_audience Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/audiences/{audience_id}/export`	export_audience Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/campaigns`	create_campaign Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/campaigns/from-template`	campaign_from_template Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/campaigns/{campaign_id}/channels`	add_channel Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/campaigns/{campaign_id}/creatives`	add_creative Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/campaigns/{campaign_id}/transition`	transition_campaign Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/consents`	record_consent Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/conversions/{conversion_id}/attribute`	attribute_conversion Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/conversions/{conversion_id}/invalidate`	invalidate_conversion Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/creatives/{creative_id}/review`	review_creative Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/entitlements/approve`	approve_entitlements Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/entitlements/{entitlement_id}/adjust`	adjust_entitlement Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/entitlements/{entitlement_id}/dispute`	dispute_entitlement Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/entitlements/{entitlement_id}/reject`	reject_entitlement Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/events`	ingest_events Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/fraud-cases/{case_id}/resolve`	resolve_fraud Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/journeys`	save_journey Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/journeys/{journey_id}/start`	journey_start Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/journeys/{journey_id}/status`	journey_status Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/leads`	capture_lead Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/leads/{lead_id}/qualify`	qualify_lead Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/leads/{lead_id}/route`	route_lead Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/links`	create_link Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/links/{link_id}/deactivate`	deactivate_link Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/partners`	create_partner Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/partners/{partner_id}/transition`	transition_partner Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/payouts`	create_payout Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/payouts/{batch_id}/approve`	approve_payout Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/payouts/{batch_id}/cancel`	cancel_payout Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/promotions`	create_promotion Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/promotions/evaluate`	evaluate_promotions Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/promotions/redeem`	redeem_promotions Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/promotions/{promotion_id}/codes`	add_codes Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/promotions/{promotion_id}/status`	promotion_status Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/reconciliation`	reconcile Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/rules/simulate`	simulate_rule Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/spend`	import_spend Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/api/v1/marketing/spend/csv`	import_spend_csv Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/agreements`	agreement_create Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/agreements/{agreement_id}/activate`	agreement_activate Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/agreements/{agreement_id}/rules`	agreement_rule Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/alerts/{alert_id}/acknowledge`	alert_ack Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/audiences`	audience_save Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/audiences/{audience_id}/evaluate`	audience_evaluate Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/audiences/{audience_id}/export`	audience_export Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/campaigns`	campaign_create Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/campaigns/{campaign_id}/channels`	campaign_channel Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/campaigns/{campaign_id}/creatives`	campaign_creative Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/campaigns/{campaign_id}/links`	campaign_link Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/campaigns/{campaign_id}/spend`	campaign_spend Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/campaigns/{campaign_id}/transition`	campaign_transition Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/campaigns/{campaign_id}/update`	campaign_update Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/commissions/approve`	commissions_approve Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/commissions/{entitlement_id}/{action}`	commission_action Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/consents`	consent_record Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/conversions/{conversion_id}/invalidate`	conversion_invalidate Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/creatives/{creative_id}/review`	creative_review Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/fraud/{case_id}/resolve`	fraud_resolve Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/journeys`	journey_save Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/journeys/{journey_id}/status`	journey_status Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/leads`	lead_capture Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/leads/{lead_id}/nurture`	lead_nurture Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/leads/{lead_id}/qualify`	lead_qualify Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/leads/{lead_id}/route`	lead_route Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/links/{link_id}/deactivate`	link_deactivate Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/partners`	partner_create Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/partners/{partner_id}/payee`	partner_payee Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/partners/{partner_id}/transition`	partner_transition Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/payouts`	payout_create Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/payouts/{batch_id}/{action}`	payout_action Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/promotions`	promotion_create Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/promotions/{promotion_id}/codes`	promotion_codes Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/promotions/{promotion_id}/status`	promotion_status Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/reconciliation`	reconciliation_run Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/settings`	settings_save Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	POST	`/marketing/tracking/policies`	tracking_policy Semantic binding: operator_surface; mutation=True	`marketing`
⚡ REST API	PUT	`/api/v1/marketing/settings`	put_settings Semantic binding: operator_surface; mutation=True	`marketing`

🛡️ Regulatory & Compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

Prehľadateľnosť
Zároveň sa môže použiť aj pre výpočet na účely výpočtu hodnoty.