Loom Explainer
Setup Custom Events Sheet
Open the adtribute App.
Go to "Connections" and click on "Create Connection".
Search for "Custom Event" and select it.
Name the Connection as the event name, e.g. Spryker Orders.
Define the "Event Source" and "Event Object", e.g. Spryker & Order
Click "Connect".
Now, a new sheet is created. This sheet will be used to fill in the necessary event data that we will then push to the dashboards.
You can fill the sheet in two ways:
manually or with an export and update the data regularly (daily, weekly, monthly).
automatically, with a tool like Zapier or make.
Manually fill out the sheet
Example Screenshot
In this example dataset, you can see 10 entries of order events with their ids, timestamps and linked email. As well as one custom column with revenue values for the particular order events.
Fill out the following columns with your datapoints & values - you can do so manually (optionally supported by an export):
Event ID
event_id
The ID that the event holds in the system you are integrating.
Event Timestamp
event_timestamp
The timestamp when the event occured.
Important: This is not a date time but a timestamp - keep this in mind while filling it out!
Event Email
event_email
The email that is linked to the event.
Additional datapoints
If you want to track and maintain more datapoints for an event, you can simply insert new columns to configure and fill in the data, e.g. order_revenue.
Those additional columns are not available in the dashboard automatically. You have to create new Configurations or Attributes within Definitions of Entities and Conversions.
Note: If you need help with pushing data from additional columns to the dashboards, reach out to us!
Automatically fill out the sheet
You can use any automation tool like Zapier or make to automatically push data into the sheet. In order for this to work, you need to build a setup that is not interfering with the protected ranges A1 to D7 otherwise you will run into errors.
If you have problems with the protected ranges throwing errors in your automation tool, you can use an input sheet as a workaround. This video explains it for Channel sheets, the process is the same for Events sheets:
Create a new sheet and name it "input-event"
Copy and paste your custom events sheet into the new sheet.
Setup the automation for the events and the input sheet.
Connect the two sheets with the QUERY formula, e.g
=QUERY(input_event!B8:K)to push the input sheet data into the custom events sheet.