To use the data transfer capabilities of Exchange, you must first register Digital Analytics and Campaign as endpoint providers on your Exchange account. A business solution or application cannot exchange data through Exchange until they are registered. This can be done by completing the endpoint registration process through the use of the endpoint registration wizard in the UI.
Register Digital Analytics as an endpoint
Ensure that you are signed in to your Exchange account.
- In the Exchange dashboard, go to Endpoints tab.
- The Endpoints tab displays a list of all currently registered endpoints. To register Digital Analytics, select Register new endpoint. The endpoint registration wizard displays.
- Select Acoustic Digital Analytics from the list and click Next.
- Enter the Digital Analytics User ID, password and client ID for the Digital Analytics account you want to connect the endpoint with. Note that the User ID and Password provided must be for a user with administrator access.
- Select Register.
Note: The Digital Analytics endpoint appears as Pending until Exchange Provisioning completes the endpoint registration process.
Register Campaign as an endpoint
Ensure that you are signed in to your Exchange account and have your Campaign refresh token and your marketing database ID available.
- In the Exchange dashboard, go to Endpoints tab.
- The Endpoints tab displays a list of all currently registered endpoints. Select the Register new endpoint icon in the upper right corner of the tab. The endpoint registration wizard displays.
- Select Acoustic Campaign from the list and then select Next.
- In the new window, use the Deployment section to select the deployment for the Campaign endpoint.
- In the Instructions section, enter your Campaign refresh token and your marketing database ID. Click Next.
- The endpoint registration wizard is complete.
Subscribe to cart abandonment or cart purchase events in Exchange
By subscribing to events, such as cart abandonment or cart purchase, with Digital Analytics and Campaign in Exchange, event data can be shared from Digital Analytics to Campaign via Exchange.
Ensure that both Digital Analytics and Campaign have been registered as endpoints and are listed as Active on the Endpoints tab.
When subscribing to an event, you select the endpoint that publishes the event, the event, and the event destinations. In this case, Digital Analytics is the event publisher, cart abandonment or cart purchase is the event, and Campaign is the event destination.
- From the Exchange dashboard, go to the Events tab.
- Select Subscribe to events. The Event subscription window displays.
- In the Select events column, choose the following options:
- Acoustic Exchange as the provider
- Acoustic Digital Analytics as the endpoint
- Cart abandonment, Cart abandonment item, and Add item to cart as the web events
- Under the Select destinations column, select Acoustic Campaign as your destination endpoint. The endpoint displays in the Subscription summary column.
- Select Subscribe.
Once you complete the subscription procedure, Campaign creates a relational table on your behalf. It is the repository of all cart abandonment or cart purchase event data received by Campaign from Exchange and Digital Analytics.
The following table shows the relational table schema:
Relational table field name |
Type |
Description |
*cartId (key) |
Text |
ID of the Cart |
*itemId (key) |
Numeric |
ID of the Item in the Cart |
cartDate |
Date Time |
Date of the Activity on Cart |
activityType |
Text |
Abandoned or Purchased |
|
Text |
Email Address. (Joined with Master DB) |
itemCategory |
Text |
Category of the item |
itemProductId |
Text |
Product ID |
itemProductName |
Text |
Product Name |
itemDescription |
Text |
Product Description |
itemColor |
Text |
Product Color |
itemSize |
Text |
Product Size |
productURL |
Text |
Product URL |
productImageURL |
Text |
Product Image URL |
itemQuantity |
Numeric |
Quantity of the item in the Cart |
itemBasePrice |
Numeric |
Product Base Price |