The events team at Northern Trail Outfitters (NTO) sets a goal on a webinar campaign to
reach 2,000 registrations. The registrations come from an external system, with no campaign
field. They want the goal to track registrations automatically, without manual updates. So, the
admin ingests the registrations as a custom data object, joins that object to the campaign, and
then creates a metric that counts registrations. Use this example when your metric's data has no
campaign field, so you join it to the campaign in the semantic model.
Required Editions
| User Permissions Needed |
| To model data and create metrics: |
Data Cloud Architect permission set
OR
MI Data Specialist permission set group
|
-
Ingest your data into Data 360 as a custom data model object and include a column that
names the campaign.
-
Add the custom object to your semantic model.
-
In the semantic model, join your object's campaign column to the campaign.
-
Create a metric on the custom object for the result your goal tracks.
-
Include a time dimension on the metric so that each linked goal pulls its actual within
the goal's start and end dates.
For example, base the metric on the registration date so that a campaign goal
running from January 1 to March 31 counts the registrations in that quarter.
A goal owner links the registrations metric to the webinar campaign's goal. The goal
then uses that join to find its campaign's registrations, and counts only the registrations
within its start and end dates. If the join can't tie the data to a campaign, the goal counts nothing, and
its actual stays 0.