Create a Dashboard: Your Content
What content engages your audience?
Within each of your campaigns you will most likely add content or clickable links. This article shows you how to create a Dashboard that tracks the performance of your content across your Automations and Campaigns. This allows you to track which content is working for your business. When combined with other metrics from other systems such as Google Analytics, it can start to paint a powerful picture of the role that email marketing plays inside of your business.
Template: Your Content
To get started you can copy the template from this location Your Content
Create your data sources
Standard Data sources
For this Dashboard you will need to create two standard data sources from the following resources. These contain no custom dimensions or metrics.
Data source resources.
- Campaigns
- Links of all Campaigns
If you recall, we previously created the Data Source, "Campaign". This means there is no requirement to add the data source to data studio again. If you check your Data Sources from the "Data source" tab as per screenshot below the Campaigns data source is already created (or your Looker Studio Navigation Page)
VIDEO: Create "Links of all Campaigns"
This short video discusses the the creation of only one data sources to be used for "Your Content" Dashboards as we have previously created the "Campaigns" data source.
Data blend design
Create Data Blend for "Your Content"
This data blend requires two data sources that you have previously created. One of the great features of Looker Studio is that provided you set up the data sources as per the instructions, you will not have to create any of the custom metrics as Looker studio "remembers" all of the design and as soon as you map the data sources the data blend automatically populates these.
- Campaigns
- Links of All Campaigns.
Join Conditions:
The Data blend will also have the following 4 join conditions prepopulated into the Blend as soon as you map the data sources into the Dashboard.
The joins are as follows
inner join "campaigns"."id" and "links of all campaigns"."campaignid"
Metrics
The data blend will require you to create the following metrics as per below.
| Name | Type | Formula |
|---|---|---|
| Link Clicks | Metric | sum(linkclicks) |
| Unique Link Clicks | Metric | sum(uniquelinkclicks) |
| Length | Metric | LENGTH(name) |
Dimensions
You will also need to add the following dimensions to your data blend.
| Name | Source |
|---|---|
| Send Date | sdate |
| Campaign Name | campaigns.name |
| Automation Name | automation |
| Link Ref | ref |
| Link Name | name |
| Link | link |
Filters
This data blend also has a filter to remove the read tracker links. This removes all the read trackers at the data blend level, rather than at the dashboard.
