Complex Events Processor Trigger (Database Triggers)

If you store derived events in your database, such as an Abandoned Cart or Refund, you can choose to run triggered marketing campaigns off of these events directly from your database.

With Complex Events Processor Triggers (aka Database Triggers), we can scan your database every 30 minutes to pull in and ingest new events to run event triggered flows. The custom properties associated with this event will be pulled in alongside the event that can be used to personalize your communications.

To use these triggers in a flow:

1. Create a Complex Events Processor Trigger dataset.
2. Submit a support center ticket to have an event triggered dataset created.
3. Once your account manager confirms that event triggered dataset is created, continue on to configure a flow:

If you have any questions with regards to cadence, requirements, or you just simply want to get started - please reach out to your account manager.

🚧

Required fields in your complex events processor trigger

The fields outlined in the prompt are required for Simon to process your database trigger.

SELECT
	event_timestamp,
	sd_processed_timestamp,
	event_type,
	identifier,
	identifier_type
FROM your_table
WHERE event_timestamp > {cursor_start_time} AND event_timestamp <= {cursor_end_time};

Explanation of sample query structure