Skip to end of metadata
Go to start of metadata

Network Creative Frequency and Recency Report

The Network Creative Frequency & Recency report can be used to view creative data for a specific advertiser based on the frequency and recency of user views. This report is more granular than the Advertiser Creative Frequency & Recency report and is available to network users only.

For instructions on retrieving a report, please see Report Service or see the example below. This report requires specifying the advertiser ID as part of the URL, for example:

On This Page

Lookback window

Frequency and recency data is available for 120 days (no data before February 26, 2017). 

Time Frame

The report_interval field in the JSON request can be set to one of the following:

  • last_hour
  • today
  • yesterday
  • last_48_hours
  • last_2_days
  • last_7_days
  • last_14_days
  • month_to_date
  • last_30_days
  • last_month
  • last_100_days
  • custom

To run a report for a custom time frame, set the start_date and end_date fields in your report request. For more details about these fields, see Report Service.

Dimensions

Column

Type

Group?

Filter?

Example

Description

hour

time

yes

no

"2010-02-01 06:00:00"

The hour of the auction.

day

time

yes

no

"2010-02-01"

The day of the auction.

month

time

yes

no

"2010-02"

The month of the auction.

creative_id

int

yes

yes

554

The ID of the creative. Note: For external click or impression trackers, creative_id will be "External Clicks" or "External Imps".

creative_name

string

no

no

"Q1 2010 728x90"

The name of the creative. Note: For external click or impression trackers, creative_name will be "External Clicks" or "External Imps".

creative

string

no

no

"Q1 2010 728x90 (554)"

Deprecated (as of October 17, 2016).

 

string

yes

yes

"15-30 minutes"

The bucket for how recently the creative was displayed. See Creative Recency Buckets below for possible values.

creative_recency_bucket_id

string

no

no

"4"

The ID of the creative recency bucket. See Creative Recency Buckets below for possible values.

creative_frequency_bucket

string

yes

yes

"11-20"

The bucket for how frequently the creative was displayed. See Creative Frequency Buckets below for possible values.

creative_frequency_bucket_id

string

no

no

"3"

The ID of the creative frequency bucket. See Creative Frequency Buckets below for possible values.

buyer_member_id

int

yes

yes

123

The ID of the buying member. If the impression was not purchased, this field shows one of the following values: 229 = PSA, 0 = Blank, or 319 = Default.

advertiser_id

int

yes

yes

789

The ID of the advertiser. If the value is 0, either the impression was purchased by an external buyer, or a default or PSA was shown.

advertiser_name

string

no

no

"Verizon Wireless"

The name of the advertiser.

advertiser

string

yes

no

"Verizon Wireless (789)"

Deprecated (as of October 17, 2016).

advertiser_code

string

no

no

"Verizon Wireless Code"

The custom code for the advertiser.

insertion_order_id

int

yes

yes

321

The ID of the insertion order.

insertion_order_name

string

no

no

"Insertion Order"

The name of the insertion order.

insertion_order

string

yes

no

"Insertion Order (321)"

Deprecated (as of October 17, 2016).

insertion_order_code

string

no

no

"Insertion Order Code"

The custom code for the insertion order.

line_item_id

int

yes

yes

111

The ID of the line item.

line_item_name

string

no

no

"Default Line Item"

The name of the line item.

line_item

string

yes

no

"Default Line Item (111)"

Deprecated (as of October 17, 2016).

line_item_code

string

no

no

"Default Line Item Code"

The custom code for the line item.

campaign_id

int

yes

yes

222

The ID of the campaign.

campaign_name

string

no

no

"Default Campaign"

The name of the campaign.

campaign

string

yes

no

"Default Campaign (222)"

Deprecated (as of October 17, 2016).

campaign_code

string

no

no

"Default Campaign Code"

The custom code for the campaign.

campaign_priority

int

no

no

5

The bidding priority for a campaign that targets direct inventory (Customer login required).

Possible values: 1 - 10, where 10 is the highest priority.

split_idintnoyes342The ID of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items. For any reports that contain campaigns, the split_id (if included) will be null.
split_namestringnoyes"Mobile Split A"The name of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items. For any reports that contain campaigns, the split_name (if included) will be null.

size

string

yes

yes

"728x90"

The size of the placement/creative served.

is_remarketing

int

yes

yes

0, 1

If 1, the campaign is remarketing. If 0, the campaign is not remarketing.

bid_type

string

Yes

Yes

"Manual"

The optimization phase the node was in when it bid for this impression. Note that the term "give up" is appended to the bid types below if the valuation for that impression falls below the venue's "give up price". For more information, see Venues and Give Up (Customer login required). Allowed values:

  • "Manual": Applies when you are bidding with a CPM goal, whether it's Base, EAP, or ECP.
  • "Learn": Applies when you are bidding with optimization (CPA, CPC, or margin) and we do not yet have enough data to bid optimized.
  • "Optimized": Applies when you are bidding with optimization (CPA, CPC, or margin) and we have enough data to bid optimized.
  • "Unknown": The node was in an unknown optimization phase.
  • "Optimized give up"
  • "Learn give up"
  • "Manual give up"

media_type

string

no

no

"Banner", "Pop", "Interstitial", "Video", "Text", "Expandable", "Skin"

The general display style of a creative. You can use the Media Type Service to view the complete list of media types.

mediatype_id

int

Yes

Yes

1

The ID of the general display style of a creative.

trafficker_for_line_item

string

yes

yes

"Maurice Truman"

The trafficker for the line item. See the "labels" field in the Line Item Service for more details.

salesrep_for_line_item

string

yes

yes

"Beverly Heller"

The sales rep for the line item. See the "labels" field in the Line Item Service for more details.

user_group_for_campaign

string

yes

yes

"Test"

The test/control user group for the campaign. See the "labels" field in the Campaign Service for more details.

Metrics

Column

Type

Example

Formula

Description

imps

int

2340

imps

The total number of impressions (served and resold).

clicks

int

1

clicks

The total number of clicks across all impressions.

total_convs

int

9

post_click_convs + post_view_convs

The total number of post-view and post-click conversions.

convs_rate

double

0.000221877080097626

total_convs / imps

The rate of conversions to impressions.

click_convs_rate

double

0.1651376

total_convs / clicks

The rate of conversions to clicks.

click_conv_rate

double

0.000064

total_convs / clicks

The rate of conversions to clicks. Note: This field is identical to click_convs_rate.

ctr

double

0.000221877080097626

clicks / imps

The rate of clicks to impressions.

click_thru_pct

double

1.12359550561797%

(clicks / imps) * 100

The rate of clicks to impressions as a percentage.

post_click_convs

int

4

post_click_convs

The total number of recorded post-click conversions.

post_click_convs_rate

double

0.0002

post_click_convs / imps

The rate of post-click conversion to impressions.

post_click_revenue

money

150.00

post_click_revenue

The total amount of recorded post-click conversion revenue.

post_view_convs

int

5

post_view_convs

The total number of recorded post-view conversions.

post_view_convs_rate

double

0.00013

post_view_convs / imps

The rate of post-view conversions to impressions.

post_view_revenue

money

300.00

post_view_revenue

The total amount of recorded post-view conversion revenue.

media_cost

money

100

media_cost

The total amount spent.

cost_ecpm

money

0.4271259

(media_cost / imps) * 1000

The cost per 1000 impressions.

cost_ecpc

money

0.1834

media_cost / clicks

The cost per click.

cost_ecpa

money

0.1834

media_cost / total_convs

The cost per attribution/conversion.

booked_revenue

money

25.767257

booked_revenue

The total revenue booked through direct advertisers (line item).

profit_ecpm

money

0.7778

((booked_revenue - media_cost) / imps) * 1000

The profit as a percentage of the revenue.

Creative Frequency Buckets

Bucket ID

Bucket Name

-2

"no-cookie-date

-1

"no-cookie"

0

"0"

1

1"

2

"2-5"

3

"6-10"

4

"11-20"

5

"21-40"

6

"41-60

7

"61-100"

8

"101-150"

9

"151-250"

10

"251-500"

11

"500+"


Creative Recency Buckets

Bucket ID

Bucket Name

-2

"no-cookie-date

-1

"no-cookie"

0

"< 1 minute"

1

"1-5 minutes"

2

"5-15 minutes"

3

"15-30 minutes"

4

"30-60 minutes"

5

"1-4 hours"

6

"4-12 hours"

7

"12-24 hours"

8

"1-2 days"

9

"2-7 days"

10

"8-14 days"

11

"14-30 days"

Example

1. Create the JSON-formatted report request
2. POST the request to the Reporting Service
3. Use the Report ID to retrieve the report data
4. Use the Download URL to save the report data to a file
  • No labels