Search
Clear search
Close search
Google apps
Main menu
true

This help center content is for DFP sales management, which might not be enabled in your network.

Sales dimensions

This article describes Sales dimensions and how to use them to provide insight into various questions about your ad serving business. Sales dimensions are available under the Historical, Reach, and Sales report types and include:

  • Package
  • Product
  • Product package
  • Product template
  • Proposal
  • Proposal agency
  • Proposal line item
  • Rate card

Programmatic guaranteed

This feature is currently in beta and may not be enabled for your network.

If DFP programmatic guaranteed is enabled in your network, the following dimension is also available:

  • Programmatic buyer

Find this dimension under "Delivery". Similarly, it's available under the Historic, Reach, and Sales report types. Learn more about programmatic guaranteed in this help center.

The order in which you need to add dimensions to a report or query is represented as follows:

  • First dimension
    • ↳ Second dimension
      • ↳ Third dimension
        • ↳ Etc.

In this article we'll cover reports and queries you can run with metrics to answer some common questions and those you can run without metrics—'factless' reports and queries that can also yield useful information.

Reports and queries with metrics

The product package and package dimensions can be used in conjunction with the product and proposal line item dimensions to answer some questions about revenue and product package performance.

How do I get a hierarchical view of revenue between proposals and packages?

  • Proposal
    • ↳ Package
      • ↳ Proposal line item

Recommended metrics: Any metrics under the Unified revenue or Contracted revenue groups.

Good to know about objects with zero values

Any proposal or line item that has a value of zero for all the metrics in the query will be filtered out of the generated report. If you want to see these objects in your report, change the query to include a metric where the objects have a non-zero value. Alternatively, you can use a query that has no metrics (as described below) to report on all the objects without any filtering.

Reports and queries without metrics

Some reports and queries can be run without metrics and provide you with useful information. For example, you might want to simply see a list of all the products that belong to a given rate card. To do so, you'd simply add the relevant dimensions in the order desired and run the report or query. When you run these kinds of reports or queries, there is no need to add a date range—any dates specified will be ignored. DFP will simply return all the objects listed and their associations based on the dimensions selected and the order in which they were added.

Supported dimensions for these kind reports and queries are under the Sales dimension group:

  • Sales, Package, Product, Product package, Product template, Proposal, Proposal agency, Proposal line item, Rate card

Below are a few example questions you might have and how to get your answer. The use of dimensions, however, is quite flexible, and you can experiment with them to get the results most needed.

How do I see which products were used most to create proposal line items?

  • Product
    • ↳ Proposal line item

This could provide insight into which are your most popular products by the number of proposal line items under a given product.

How do I see which product packages were used most to create proposal line items?

  • Product package
    • ↳ Package

This query would show you the number of how many packages resulted from a sales representative selecting a product package. If you wanted more depth, showing you all the proposal line items that resulted, you could also add:

  • Product package
    • ↳ Package
      • ↳ Proposal line item

What is the performance of my products being sold in a product package versus standalone?

  • Product
    • ↳ Product package
      • ↳ Proposal line item

What are my most popular rate cards?

  • Rate cards
    • ↳ Proposal line item

This shows you how many proposal line items used which rate card. You could similarly run this for packages:

  • Rate card
    • ↳ Package
Was this article helpful?
How can we improve it?