Pivot Reports


Getting Started

Pivot reports contain lots of information. Refer to this guide to make sense of the data. Microsoft Excel, with Pivot Tables enabled, is required to view these in-depth reports.

Pivot Reports Tabs


  • This will show you raw data from all tabs below in one (non-pivot table format) view including added metrics like fold and device type.

    • Fold: This metric details where your ads have been shown: above or below-the-fold. You can adjust how much the system bids based on where inventory is located on a web page within the advanced settings of an ad group. 

    • Device Type: This metric shows the device type (desktop, mobile, tablet, or all) in which ads were served. To customize whether your ad group serves impressions to computers, mobile phones, or tablets, navigate to Ad Group > Action > Edit Ad Group. From the Edit Ad Group screen, scroll to Advanced Settings and expand Device Type. By default, all device types will be selected, but any may be deselected to prevent serving impressions to those devices.

  • This tab is useful for manually importing the raw data into third-party reporting systems. You can simply copy this tab into a new Excel sheet and then upload it from there.  

TAB 2: Ad Group Performance

  • Performance-based data within each ad group is visualized. This tab will show you much of the same information you can find in the Choozle dashboard with the added benefit of seeing your average bid for each impression. 

  • One option for optimization includes reallocating the budget to the higher-performing ad group(s).

  • Conversion details are listed after the cost-per-click (CPC) metric:
    • CTC: Click-through conversions meaning a user clicked on your ad and converted on your webpage upon the first visit.
    • VTC: View-through conversions meaning a user clicked on your ad, left your page without immediately converting, but came back to your page within the attribution window and converted at a later time. 

    • TC: Total conversions whether view-through or click-through. 

    •  The number corresponds to the order in which your conversion events are listed at the campaign level. If you have more than five conversion events, the pivot report will only include the first five conversion events. Use the Detailed Reports for data on all 25 conversion events. 

TAB 3: Creative

  • This tab will show you the breakdown of individual creative performance. Here you will see which creatives are facilitating the most interaction based on the number of times they have been served vs. clicked. Total bids and average bids are listed here as well, so you can assess the popularity of sizes and how competitive that inventory is.  

  • Look for trends in individual creative performance and remove poor-performing creatives.

TAB 4: Site

  • This tab will show a list of websites where ads have appeared. Seeing what inventory you have served impressions on and the consequent clicks garnished from each impression will give you a good idea of what sites are cohesive for your brand. 

  • Determine possible blocklists or whitelists by eliminating at-scale options with no clicks.

    • Create a blocklist for poor-performing sites, and/or

    • Create a whitelist of high-performing sites and consider a bid adjustment for higher-performing sites.

TAB 5: Ad Format

  • This tab breaks out creative performance by the size of the creative asset. The number of bids will show the variance in inventory for each size. 

  • See attached creative specifications sheet for top-performing creative asset sizes.

TAB 6: Contextual Category (if using contextual category targeting)

  • This tab will only show data if you are employing contextual category targeting at the ad group level. 

  • If you are using categories, you will see a list of publisher-defined categories of sites where ads have appeared. For example, “food and drink,” or “women’s health.”

  • Include or exclude categories in an ad group based on category performance.

  • Remember to adjust the order of categories, as they are targeted in the order in which they are listed in your ad group setup.

TAB 7: Date

  • View campaign performance by the date of impression delivery.

TAB 8: Brand Data (if using data targeting)

  • This tab breaks out impression delivery by data segment in the custom audience applied to each ad group.

  • Include or exclude data brands in a custom audience based on data segment performance.

  • Adjust the order of data brands, as they are targeted in the order in which they are listed in your custom audience.

TAB 9: Supply Vendor

  • This tab breaks out impression delivery by supply vendor

  • Include or exclude supply vendors in the advanced settings based on performance.

Understand Terms in the Pivot Reports

Tail Aggregate: The "Tail Aggregate" is compiled of all sites that have bid on 200 impressions or less. Once these sites surpass  200 impressions, they break out into their own line item. It is combined into one line item because there can be thousands of sites that make up the tail aggregate. To give each of these sites its own line item would make optimizing very difficult. Oftentimes, in the first few days of a campaign, only the tail aggregate will populate because no individual website has received 200 bids. If this is the case, you can reach out to the Growth Account team in the Support Center at help@choozle.com to request a tail aggregate report.

Understanding Site-Not-Provided: "Site-Not-Provided" is a phrase used when the publisher does not want their domain name shown in RTB reports. We frequently see "Site-Not-Provided" shown when higher-profile websites do not want their domain shown on the RTB reports, so brands may continue to buy ad placements directly from them.

Numbers: Numbers in your pivot report, listed under Sites, are often the ID numbers for apps. Run a quick Google search of the number, and you'll usually be able to identify the application.

Current Limitations

Currently, you will not be able to view connected TV and other PMP deal performance in the pivot reports. If you would like to view this information you can reach out to the Growth Account team in the Support Center at help@choozle.com to request a PMP deal performance report.