Brand Campaign Daily Metrics

Brand Campaign Metrics Daily

This table contains daily metrics for campaigns.

Grain: Each row in this table is a single day for a single campaign order element.

Key Name Description
P Campaign Order ID The campaign element order ID associated to the row.
P Date Key The date in the form YYYYMMDD.  Join this to date dimension to get additional date representations.
Google Actual Cost The current spend on a google campaign.
Google Average Position The average position of a google campaign.
Google Clicks The number of clicks on a google campaign for the day.
Google Impressions The number of impressions on a google campaign for the day.
Google Paid Search Calls The number of paid search calls of a google campaign.
Microsite Actions The amount of actions for the day on the Microsite.
Microsite Avg Time on Site The average time on site for the Microsite for all visits for the day.
Microsite Avg Time on Site (Non-Bounce) The average time on site for the Microsite for non-bounce visitors for the day.
Microsite Bounce Rate The bounce rate for the day is calculated as (Microsite Bounces) / (Microsite Visits)*100
Microsite Outlinks The number of outlinks for the day.
Microsite Total Time on Site The total time on site for all visitors on the Microsite for the day.
Microsite Total Time on Site (Non-Bounce) The total time on site for non-bounce visitors on the Microsite for the day.
Microsite Visits The number of visits on a microsite for the day where each page visit is at least 10 seconds.
Registered Leads The number of registered leads for the day.

Joins

Category Type
Brand Campaign Orders: Brand Campaign Daily Metrics Left Outer Join. Each record in Campaign Orders will have 0 or more records in Brand Campaign Daily Metrics.
Date Dimension:Brand Campaign Daily Metrics Left Outer Join. Each record in Date Dimension will have 0 or more records in Brand Campaign Daily Metrics.

Date Dimension

A populated table provided to be able to do date reports. This table can assist with building visualizations and tables that need the grain of one row per day.

Grain: Each row in this table is a single day.

Key Name Description
Comment The comments entered by the partner for the call.
Created Date The day the last call took place.
Created Date Key The last login date formatted as an integer (YYYYMMDD).
Length of Call (Minutes) The length of the call in minutes.
Partner ID The unique identifier for the partner. Join this table with the partners table for more information about the partner.
P Session ID The unique identifier for the tracked call.

Joins

Please see other categories for the joint to date dimension.