It is not possible to subscribe to a table in Adobe Campaign and receive notifications when a recipient opens an email or a message is delivered. These types of events are specific to email and messaging interactions and are not directly related to changes in a database table.
However, Adobe Campaign does provide a mechanism for tracking email and message interactions using tracking logs. The tracking logs capture data about each email or message that is sent from Adobe Campaign, including information about opens, clicks, and deliveries.
To use this feature, you can enable tracking for the delivery activity that sends the email or message, and then use a query to retrieve data from the tracking logs. The query can be scheduled to run at regular intervals and send the results to an external system using a webhook.
Here are the basic steps to set up tracking and retrieve data using a webhook:
- In Adobe Campaign, create a delivery activity and enable tracking for the activity.
- Create a query to retrieve data from the tracking logs, filtering on the events you are interested in (e.g. opens, clicks, deliveries).
- In the query configuration, select the "Export" option and specify the URL for your webhook endpoint.
- Save the query configuration and make sure that it is enabled.
When the query runs, Adobe Campaign will send the results to your webhook endpoint, providing information about the email or message interactions. You can then process this information in your external system as needed.
Note that to use this feature, you need to have access to the Adobe Campaign Administration console and have the necessary permissions to create deliveries and queries. Additionally, you will need to have a system set up to receive and process the webhook notifications.