Creating a Device Report

This DSP report shows how a set of tactics performed by device.

Note: DSP Total Spend retrieves and shows data up to a maximum of 400 days.

To create a device report:

  1. Go to Main Menu > Campaigns.

  2. Select a campaign.

  3. Click Reports in the upper-right corner. The Reports modal appears.

  4. Select Actions > Create Report.

  5. Select Type > Device Report.

  6. Select the dimensions. This report can show results by:

    • Device type
    • Carrier
    • Device operating system
    • Make and model
  7. Select the Interval: Lifetime, Monthly, Weekly, or Daily.

  8. When you set the Start Date and End Date, you define the dates to include in the report.

    The maximum length of the date range is 400 days. This is the maximum interval between selected dates. Report data is available as far back in time as 1 January 2017, depending on when delivery began for your selected tactics.

  9. Enable Include conversion pixels to select the pixels you want in your report.

Report Data

Dimensions

When you set up a device report, you choose the dimensions that should be included.

Column Name   Example   Description

Date

2016-03-07

The date. Daily reports only.

Month

3

The month, expressed as an integer. Monthly, weekly, and daily reports only.

Week

20

The week, expressed as an integer. Weekly and daily reports only.

Campaign ID

300833

The campaign ID.

Campaign Name

SuperCool Scooters SummerBlast 2016 - Audience Soccer Moms

The name of the tactic.

Start Date

20160301

The tactic's start date.

End Date

20160315

The tactic's end date.

Ad ID

1292276

 

Ad reports only.

Unique identifier for one ad.

Ad Label

SuperCoolSummerBlast300x250

Ads reports only.

The name of the ad.

Device Type

Phone

Device type, device OS, and ad reports only.

Valid values:

  • Phone
  • Tablet
  • Desktop

OS

 

ANDROID

 

Device OS reports only. The operating system. Valid values include these:

  • ANDROID: Android for mobile devices.
  • IOS: iOS for mobile devices
  • MAC_OS: OS X for desktop devices
  • BLACKBERRY: BlackBerry OS
  • WINDOWS: Operating Systems produced by Microsoft: Windows Mobile for mobile devices and Windows for desktop devices
  • LINUX: Various Linux distributions, only available for targeting desktop devices
  • UNKNOWN: Other operating systems

Carrier

T-Mobile USA

 

Carrier reports only. The name of the mobile carrier.

Make

Samsung

Make/model reports only.

Valid values for makes, including these:

  • Apple
  • Samsung
  • Lg
  • Generic
  • Google
  • Amazon
  • Nokia
  • Sony
  • HTC
  • Motorola
  • Asus
  • Blackberry
  • Huawei
  • Unknown

Model

Galaxy Tab 3

Model names

Metrics

Column Name Example Description

Imps. Won

20979

The number of impressions won.

Clicks

3

The number of ad clicks.

CTR

0.11%

Click-through rate, calculated by this formula:

Clicks / Impressions

Net eCPM

$4.57

Total effective cost per mille:

eCPM (Gross view) = (Total Spend / Delivered Imps) X 1000

eCPM (Net view) = (Total Spend / Delivered Imps) X 1000

Media eCPM = Media Spend / (Imps Won / 1000) [DSP]

Data eCPM = Data Spend / (Imps Won / 1000) [DSP]

Net eCPC

$3.35

Effective cost per click:

eCPC (Gross view) = Total Spend / Delivery Clicks

eCPC (Net view) = Total Spend / Delivery Clicks

Net eCPA

$5.31

Effective cost per conversion:

eCPA (Gross view) = Total Spend / Total Conversions

eCPA (Net view) = Total Spend / Total Conversions

Events

432

User actions that are tracked for a campaign. See Conversion Pixels Overview for details.

Event Rate

.03%

Events / Clicks

CTC

1

Click-through conversions: conversions recorded after a user clicked an ad in the campaign.

VTC

1

View-through conversions: conversions recorded after a user saw an ad from the campaign but did not click through.

Total Conversions

2

All click-through and view-through conversions added together:

CTC + VTC

Click CVR

33.33%

Click-through conversion rate, calculated by this formula:

CTC / Clicks

View CVR

33.33%

View-through conversion rate, calculated by this formula:

VTC / Clicks

Total CVRM

0.0950

Total conversions per Mille:

(Total Conversions) / (Impressions Won / 1000)

CTC Revenue

$423.82

Click-through revenue: revenue associated with click-through conversions.

VTC Revenue

$115.76

View-through revenue: revenue associated with view-through conversions.

Total Revenue

$539.58

Revenue associated with all conversions:

CTC Revenue + VTC Revenue

Media Spend

$44.80

Amount spent on media.

Data Spend

$23.27

Amount spent on audience data.

Total Spend

$68.07

Total amount spent, equal to

Media Spend + Data Spend

Video Starts

2776

Calculated for video impressions only.

The number of times the video was started.

25% Complete

1509

Calculated for video impressions only.

The number of video impressions that reached the first quartile marker.

50% Complete

1386

Calculated for video impressions only.

The number of video impressions that reached the second quartile marker.

75% Complete

841

Calculated for video impressions only.

The number of video impressions that reached the third quartile marker.

100% Complete

672

Calculated for video impressions only.

The number of video impressions that completed (reached the fourth quartile marker).

Completion Rate

24.21%

Calculated for video impressions only.

What percentage of video impressions completed? Calculated by this formula:

100% Complete / Video Starts

eCPCV

$15.43

Calculated for video impressions only.

Cost per completed view (video), calculated by this formula:

(Total Spend) / (100% Complete)

{Conversion Name} - CTC

1

If you enable conversion pixel reporting, this column gives click-through conversions for one pixel ID.

{Conversion Name} - VTC

1

If you enable conversion pixel reporting, this column gives view-through conversions for one pixel ID.

{Conversion Name} - Total Conversions

2

If you enable conversion pixel reporting, this column gives total conversions for one pixel ID.