Custom reporting allows you to select and customize all dimensions and metrics you wish to evaluate, providing an exportable CSV with Campaign data. You can choose Advertisers, Campaigns, Line Items, Dimensions, Metrics, and a Date Range to generate a report. All reports are created in UTC time zone.

Custom Report Types

• Custom Report
• IP Conversion Pixel: Path to Conversion
• IP Conversion Pixel: Page Visits
• IP Conversion Pixel: Conversion Rate
• Log Level Reporting
• Reach/Frequency Report

Report Availability

• Reports remain downloadable in the platform for 30 days.
• After expiration, reports must be rerun. Note that some data points may no longer be available.

Report Limitations

• Maximum Rows: Custom Reports are limited to 10,000,000 rows, depending on the delivery method and report type selected.
• Incomplete Data Warning: If a report exceeds this limit, a yellow caution symbol will appear next to the report name, indicating that the data is incomplete.
  • If you require additional data beyond this limit, you can:
    • Split the report into multiple smaller reports.
    • Reduce the number of selected dimensions to decrease row count.
    • Contact your Account Manager for assistance.

Custom Reporting Time Zone

The time zone for custom reports can be configured on each individual report. Note, metrics will only match billing if the report is pulled in UTC. Custom reports may not match the metrics shown in the platform if they are not pulled in the seat time zone.

User time zone will use the ‘user time zone offset’ from the bid request to adjust report metrics for each impression to the time zone where that impression was served. When the user’s time zone offset is not present in the bid request, it will be defaulted to UTC.

Seat Time Zone

The time zone for your account can be configured under the ‘Admin’ section of the platform in ‘Seat Settings’ under ‘Preferences’. This time zone setting will adjust the metrics in the advertiser tab (advertisers, campaign and line item metrics) as well as the reporting dashboard. Note: this does not apply to billing metrics in the account balance or the pacing and dayparts on campaigns or lines. All billing metrics and transactions are for account activity in UTC. Pacing and dayparting time zones can be configured on each campaign or line.

Note that all platform activity appears in the account balance and is billed in UTC time zone.

Custom reports can be automatically delivered to your email, FTP or S3 bucket, or Google Cloud Storage on the schedule of your choice. When creating a custom report, select the ‘Schedule Automated Report’ box, then open the ‘Scheduled Reports’ tab to choose the schedule and configure the delivery method.

When creating a new Custom Report and selecting Schedule Automated Report, the Scheduled Reports tab becomes editable. Complete the setup by selecting the following:

• Report Frequency:
  • Daily: Reports will be sent each morning for the previous day.
  • Weekly: Reports will be delivered on Monday mornings for the previous week.
  • Monthly: Reports will be delivered on the first of each month for the previous month.
  • Custom:
    • Set a specific day frequency. For example, every 2 days.
    • Set a specific week frequency on a specific day. For example, every 2 weeks on Monday.
• Reporting Interval: Yesterday, Last 7 days, Last 30 days, Month to Date, Previous Month, Custom
  • Custom: Last __ Days
• Deliver by: Choose delivery method by selecting the checkbox for each.
  • Email
    • Email addresses should be separated by comma.
  • FTP
    • FTP Server
    • FTP Path
    • FTP Port
    • FTP Username
      FTP Password
  • AWS S3
    • Bucket: This is the name of the bucket, e.g. example.bucket. Bucket name does not contain a leading backslash or the s3:// prefix.
      • Creating a bucket in AWS S3:
        • In AWS S3 click Create Bucket
        • Chose a bucket name that is available and the desired AWS Region.
        • Change Object Ownership to ACLs enabled.
        • Uncheck Block all public access field and check “I acknowledge that the current settings might result in this bucket and the objects within becoming public”.
        • Click Create bucket.
        • Navigate to the newly created bucket and click Create folder with the output path that we chose in Pontiac (“output-path”). Confirm to create the folder.
      • Setting up the report in Pontiac:
        • Go to Reporting tab and then click New Custom Report.
        • Select Log Level Report from the Report Type Drop Down
        • Go to Scheduled Reports tab and check Deliver by S3 box.
        • In the expandable section fill out the Bucket field with the AWS S3 Bucket name. Example: S3-test-bucket.
        • Fill out the Path field with a desired output path location and file name (To include the date macro use dateInt (YYYYMMDD) like xxx/filename-%dateInt% otherwise your file will be overwritten each day). Example: output-path/Pontiac-reports.csv or output-path/Pontiac-reports-%dateInt%.csv
        • Click View security policy and copy the full text area.
        • Go to Amazon AWS S3 and modify permissions for the bucket we chose earlier. In the Permissions tab click Edit and paste the policy text from earlier and Save.
        • Back in Pontiac reports screen click Verify and wait for a successful confirmation message.
    • Path: This will be the full location that the report is saved to. To include the date macro use dateInt (YYYYMMDD) like xxx/filename-%dateInt% otherwise your file will be overwritten each day.
    • View Security Policy
    • Verify your configured bucket policy.
  • Google Cloud Storage
    • Bucket: This is the name of the bucket, e.g. example.bucket. Bucket name does not contain a leading backslash or the gs:// prefix.
    • Path: This will be the full location that the report is saved to. To include the date macro use dateInt (YYYYMMDD) like xxx/filename-%dateInt% otherwise your file will be overwritten each day.
    • Credentials: Valid json object.

Overview

Custom reporting allows you to customize all the dimensions and metrics you wish to evaluate, providing an exportable csv with all the data from your campaigns.

Create a Standard Custom Report:

1. Navigate to the Reporting Tab and open the Custom Reporting dropdown section.
2. Click ‘New Custom Report’.
3. Select ‘Custom Report’ as the Type.
4. Fill out the required report details.
5. Click ‘Save’.
6. Expand the Custom Reporting dropdown section and click the ‘Download’ button associated with the name of your custom report.
   • If Scheduled Automated Reports were selected, the report will be accessible via your chosen delivery method.

Below are the customizations available when creating the report:

• Name: Enter a title for your report.
• Schedule Automated Report: Choose this option to have the report sent to you on regular intervals. See the section for setup details Scheduled Reports
• Advertiser ID: Select the Advertiser IDs that you would like to include in your report. By default, all Advertisers are included.
• Campaign ID: Select the Campaign IDs that you would like to include in your report. By default, all Campaigns under the selected Advertisers are included.
• Line ID: Select the Line IDs that you would like to include in your report. By default, all Lines under the selected Advertisers and Campaigns are included.
• Start Date: Define the start date for the report interval.
• End Date: Define the end date for the report interval.
• Type: Choose the type of report. See each section for more details on report types.
  • Custom Report
  • IP Conversion Pixel: Path to Conversion
  • IP Conversion Pixel: Page Visits
  • IP Conversion Pixel: Conversion Rate
  • Log Level Report
  • Reach/Frequency Report.
• Timezone: Select the timezone that the report will generate, such as Seat Time Zone, User Time Zone, UTC, etc.
• Dimensions: Categorical values that define how data is grouped and segmented in reports, such as Campaign Name, Advertiser, and Exchange.
• Metrics: Quantitative values that measure performance, such as impressions, clicks, conversions, spend, and CTR.

Dimensions:

• Date
• Advertiser ID
• Advertiser Name
• Advertiser Code
• Campaign ID
• Campaign Name
• Campaign Code
• Line ID
• Line Name
• Line Code
• Creative ID
• Creative Name
• Creative Size
• Region/State Code
• Region/State Name
• Country Code
• Country Name
• DMA Code
• DMA Name
• Zip Code
• Browser
• Operating System
• Site Domain
• Exchange
• App Domain
• App Bundle
• App Name
• Publisher Name
• Device Type
• Device Model
• Deal ID
• Deal Name
• Content Genre
• Content Episode
• Content Title
• Content Series
• Content Channel
• Content Network
• Hour
• Device Type Name
• Inventory Type
• Multi Field

Metrics:

• Impressions
• Media Cost
• Total Cost
• Revenue
• Media Cost CPM
• Total Cost CPM
• Revenue CPM
• Profit
• Video Starts
• 25% Video Complete
• 50% Video Complete
• 75% Video Complete
• Video Completions
• Video Clicks
• Chrome Conversions
• Data Costs
• Art Fee
• DCM Hosting Fee
• CC Fee
• Foot Traffic Fee
• Contextual Fee
• Chalice Fee

Overview

The ‘Path to Conversion’ report provides data on IP conversions and impressions served to users who later converted. It shows the complete journey from an impression view to the conversion action on your website, helping you understand how impressions influence conversions over time.

Key Columns:

• Impression Time: Indicates when the impression was served to a user who later visited or converted on the site where the pixel is placed. The total number of ‘imp_times’ shows how many impressions were served to users who then converted, corresponding to the ‘Attributed Imps’ field in the IP Conversion Pixel metrics under the Advertiser.
• Conversion Time: Shows the time the conversion or action occurred. The total number of unique ‘conv_times’ represents the total number of conversions or visits driven by the campaign, corresponding to the ‘Total Convs’ field in the IP Conversion Pixel metrics under the Advertiser.

Lookback Window:

• By default, the IP conversion pixels use a 30-day lookback window. However, if you need to pull data with a custom lookback window, you can select a value up to 30 days from the ‘Lookback Window’ dropdown.

Create an IP Conversion Pixel: Path to Conversion Report

1. Navigate to the Reporting tab and open the Custom Reporting dropdown section.
2. Click ‘New Custom Report’.
3. Select ‘IP Conversion Pixel: Path to Conversion’ as the Type.
4. Fill out the required report details.
5. Click ‘Save’.
6. Expand the Custom Reporting dropdown section and click the ‘Download’ button next to the name of your custom report.
   • If Scheduled Automated Reports were selected, the report will be delivered via your chosen delivery method.

Below are the customizations available when creating the report:

• Name: Enter a title for your report.
• Schedule Automated Report: Choose this option to have the report sent to you on regular intervals. See the section for setup details Scheduled Reports
• Advertiser ID: Select the Advertiser IDs that you would like to include in your report. By default, all Advertisers are included.
• Campaign ID: Select the Campaign IDs that you would like to include in your report. By default, all Campaigns under the selected Advertisers are included.
• Line ID: Select the Line IDs that you would like to include in your report. By default, all Lines under the selected Advertisers and Campaigns are included.
• Pixel ID: Select the Pixel IDs that you would like to include in your report. By default, all Pixels are included.
• Start Date: Define the start date for the report interval.
• End Date: Define the end date for the report interval.
• Type: Choose the type of report. See each section for more details on report types.
  • Custom Report
  • IP Conversion Pixel: Path to Conversion
  • IP Conversion Pixel: Page Visits
  • IP Conversion Pixel: Conversion Rate
  • Log Level Report
  • Reach/Frequency Report.
• Timezone: Select the timezone that the report will generate, such as Seat Time Zone, User Time Zone, UTC, etc.
• Lookback window: By default, the IP conversion pixels use a 30-day lookback window.
• Dimensions: Categorical values that define how data is grouped and segmented in reports, such as Campaign Name, Advertiser, and Impression Time.
• Metrics: Quantitative values that measure performance, such as fractional attribution.

Dimensions:

• Pixel ID
• Pixel Name
• Conversion Time
• Impression Time
• IP Address Truncated
• IP Address Hashed
• Home or Business
• Zip Code
• Site Domain
• Exchange
• Region/State Code
• User ID
• Advertiser ID
• Advertiser Name
• Line ID
• Line Name
• Date
• Device Type
• Creative ID
• Creative Name
• App Domain
• App Bundle
• App Name
• Order ID: Reporting on this field requires this value to be dynamically passed on the IP Pixel using the Order Value or Order ID parameters. Check the Order ID or Order Value boxes when creating the IP Pixel for further guidance.
• Order Value: Reporting on this field requires this value to be dynamically passed on the IP Pixel using the Order Value or Order ID parameters. Check the Order ID or Order Value boxes when creating the IP Pixel for further guidance.
• Deal Name
• Publisher Name
• Content Network
• Content Channel
• Content Series
• Content Title
• Content Genre
• Custom Variable 1
• Custom Variable 2
• Custom Variable 3
• Custom Variable 4
• Other Parameters
• Consumer ID
• Campaign ID
• Campaign Name
• Conversion Date
• Impression Date
• Operating System
• Browser
• User Agent
• Device Type Name
• Inventory Type

Metrics:

• Fractional Attribution: Assigns an evenly weighted conversion value to each impression event that leads to a conversion.

Overview

The IP Conversion Pixel: Page Visits report pulls data on page visits associated with the IP Conversion Pixel. It only includes visit data at the advertiser level and is not tied to specific lines. Each record in this report represents a user visiting your page, independent of any media served.

Create an IP Conversion Pixel: Page Visits Report:

1. Navigate to the Reporting Tab and open the Custom Reporting dropdown section.
2. Click ‘New Custom Report’.
3. Select ‘IP Conversion Pixel: Page Visits’ as the Type.
4. Fill out the required report details.
5. Click ‘Save’.
6. Expand the Custom Reporting dropdown section and click the ‘Download’ button associated with the name of your custom report.
   • If Scheduled Automated Reports were selected, the report will be accessible via your chosen delivery method.

Below are the customizations available when creating the report:

• Name: Enter a title for your report.
• Schedule Automated Report: Choose this option to have the report sent to you on regular intervals. See the section for setup details Scheduled Reports
• Advertiser ID: Select the Advertiser IDs that you would like to include in your report. By default, all Advertisers are included.
• Pixel ID: Select the Pixel IDs that you would like to include in your report. By default, all Pixels are included.
• Start Date: Define the start date for the report interval.
• End Date: Define the end date for the report interval.
• Type: Choose the type of report. See each section for more details on report types.
  • Custom Report
  • IP Conversion Pixel: Path to Conversion
  • IP Conversion Pixel: Page Visits
  • IP Conversion Pixel: Conversion Rate
  • Log Level Report
  • Reach/Frequency Report.
• Timezone: Select the timezone that the report will generate, such as Seat Time Zone, User Time Zone, UTC, etc.
• Dimensions: Categorical values that define how data is grouped and segmented in reports, such as Campaign Name, Advertiser, and Impression Time.

Dimensions:

• Pixel ID
• Pixel Name
• Conversion Time
• Impression Time
• IP Address Truncated
• IP Address Hashed
• Home or Business
• Zip Code
• Region/State Code
• Advertiser ID
• Date
• Custom Variable 1
• Custom Variable 2
• Custom Variable 3
• Custom Variable 4
• Other Parameters
• Order ID: Reporting on this field requires this value to be dynamically passed on the IP Pixel using the Order Value or Order ID parameters. Check the Order ID or Order Value boxes when creating the IP Pixel for further guidance.
• Order Value: Reporting on this field requires this value to be dynamically passed on the IP Pixel using the Order Value or Order ID parameters. Check the Order ID or Order Value boxes when creating the IP Pixel for further guidance.
• Consumer ID

Overview

The ‘Conversion Rate Report’ helps track the effectiveness of your ads by analyzing conversion rates day over day. To calculate the conversion rate for each day, divide ‘Conversions’ by ‘Imps’.

The conversion metric in this report matches the UI metrics when the ‘Line’ dimension is included. When this dimension is selected, conversions are not de-duplicated across line items. For example, if a user sees ads from two Lines under the same Campaign and completes one purchase, this will count as a conversion for both Line Items, and the Campaign will show two conversions.

For unique conversions across an advertiser or campaign, you can run a custom ‘IP Conversion Rate’ report without selecting the ‘Line ID’ dimension. This report will show unique conversions on the selected date(s). For unique conversions across a campaign flight, run the ‘IP Path to Conversion Report’ and de-duplicate the hashed IP address across all dates.

Create an IP Conversion Pixel: Conversion Rate Report

1. Navigate to the Reporting tab and open the Custom Reporting dropdown section.
2. Click ‘New Custom Report’.
3. Select ‘IP Conversion Pixel: Conversion Rate’ as the Type.
4. Fill out the required report details.
5. Click ‘Save’.
6. Expand the Custom Reporting dropdown section and click the ‘Download’ button next to the name of your custom report.
   • If Scheduled Automated Reports were selected, the report will be delivered via your chosen delivery method.

Below are the customizations available when creating the report:

• Name: Enter a title for your report.
• Schedule Automated Report: Choose this option to have the report sent to you on regular intervals. See the section for setup details Scheduled Reports
• Advertiser ID: Select the Advertiser IDs that you would like to include in your report. By default, all Advertisers are included.
• Campaign ID: Select the Campaign IDs that you would like to include in your report. By default, all Campaigns under the selected Advertisers are included.
• Line ID: Select the Line IDs that you would like to include in your report. By default, all Lines under the selected Advertisers and Campaigns are included.
• Pixel ID: Select the Pixel IDs that you would like to include in your report. By default, all Pixels are included.
• Start Date: Define the start date for the report interval.
• End Date: Define the end date for the report interval.
• Type: Choose the type of report. See each section for more details on report types.
  • Custom Report
  • IP Conversion Pixel: Path to Conversion
  • IP Conversion Pixel: Page Visits
  • IP Conversion Pixel: Conversion Rate
  • Log Level Report
  • Reach/Frequency Report.
• Timezone: Select the timezone that the report will generate, such as Seat Time Zone, User Time Zone, UTC, etc.
• Lookback window: By default, the IP conversion pixels use a 30-day lookback window.
• Dimensions: Categorical values that define how data is grouped and segmented in reports, such as Line ID and Line Name.

Overview

Log level reporting provides advertisers with detailed bid request data for purchased inventory, with IP addresses and IFAs encrypted for privacy. Reports are delivered daily in UTC for the previous day’s activity. The user time zone offset is included in these reports and can be utilized to adjust the report time zone if needed. To receive log level reports, you must have either an AWS or Google Cloud account and have a scheduled report configured for delivery to s3 or Google Storage. Additionally, certain bid request fields contain numerical values that correspond to specific descriptions. The tables below provide mappings for device type, geo type, video protocol, and livestream values.

Device Type

Geo Type

Video Protocol

Livestream

Download the CTV log level report schema for a full list of available fields.

Create a Log Level Report:

1. Navigate to the Reporting tab and open the Custom Reporting dropdown section.
2. Click ‘New Custom Report’.
3. Select ‘Log Level’ as the Type.
4. Fill out the required report details.
5. Click ‘Save’.
6. To receive log level reports you must have either an AWS or Google Cloud account and have a scheduled report configured for delivery to s3 or Google Storage.

Below are the customizations available when creating the report:

• Name: Enter a title for your report.
• Schedule Automated Report: Choose this option to have the report sent to you on regular intervals. See the section for setup details Scheduled Reports
• Advertiser ID: Select the Advertiser IDs that you would like to include in your report. By default, all Advertisers are included.
• Campaign ID: Select the Campaign IDs that you would like to include in your report. By default, all Campaigns under the selected Advertisers are included.
• Line ID: Select the Line IDs that you would like to include in your report. By default, all Lines under the selected Advertisers and Campaigns are included.
• Type: Choose the type of report. See each section for more details on report types.
  • Custom Report
  • IP Conversion Pixel: Path to Conversion
  • IP Conversion Pixel: Page Visits
  • IP Conversion Pixel: Conversion Rate
  • Log Level Report
  • Reach/Frequency Report.
• Columns: Categorical values (dimensions) and quantitative values (metrics).

Below are the column customizations available when creating the report:

• Exchange
• Auction ID
• Impression ID
• Impression Tag ID
• Impression Bid Floor
• Impression Bid Floor Currency
• Advertiser ID
• Advertiser Code
• Campaign ID
• Campaign Code
• Line ID
• Line Code
• Creative ID
• Bid Price Millicents
• Win Price Millicents
• Impression Timestamp
• Source FD
• Source Pchain
• Creative Type
• Creative Categories
• Creative Duration
• Creative Domain
• Width
• Height
• Video Placement
• Video Start Delay
• Video Protocols
• Device Type
• Device Connection Type
• Device IFA
• Device Make
• Device Model
• Geo Country
• Geo Region
• Geo Zip
• Geo Metro
• Geo Latitude
• Geo Longitude
• UTC Offset
• Geo Type
• Geo IP Service
• IP Address Truncated
• IP Address Hashed
• IP Address Hashed Std
• Device Language
• Operating System
• OS Version
• Hardware Version
• Auction Type
• BCAT
• Currency
• User Agent
• Browser
• Site Domain
• App Bundle
• App ID
• App Domain
• App Name
• App Category
• App Store URL
• Content ID
• Content Livestream
• Content Content
• Content Length
• Content Genre
• Content Episode
• Content Season
• Content Title
• Content Series
• Content URL
• Content Category
• Content Network
• Content Channel
• Content Content Rating
• Content Producer Name
• Publisher ID
• Publisher Name
• Publisher Domain
• Private Auction
• Deal ID
• Deal At
• Deal Bid Floor
• Deal Bid Floor Currency
• Data Cost
• Revenue
• Total Cost
• Fees
• Chrome Conversion
• Conversion Pixel ID
• Site Page
• Foot Traffic Fee
• Data Comm
• Art Fee
• Contextual Fee
• DCM Hosting Fee
• CC Fee
• Chalice Fee
• Advertiser Name
• Campaign Name
• Line Name
• Creative Name

Overview

The Reach/Frequency Report provides insights into the number of unique users reached by a campaign. Select the Advertisers, Campaigns, Lines, and Date Range to generate the report, which includes the following metrics:

• Unique Device IDs (IFAs)
• Unique IP Addresses
• Impressions Served

Estimate frequency by dividing total impressions served by either unique device IDs or unique IP addresses.

Create a Reach/Frequency Report:

1. Navigate to the Reporting Tab and open the Custom Reporting dropdown section.
2. Click ‘New Custom Report’.
3. Select ‘Reach/Frequency’ as the Type.
4. Fill out the required report details.
5. Click ‘Save’.
6. Expand the Custom Reporting dropdown section and click the ‘Download’ button associated with the name of your custom report.
   • If Scheduled Automated Reports were selected, the report will be accessible via your chosen delivery method.

Below are the customizations available when creating the report:

• Name: Enter a title for your report.
• Schedule Automated Report: Choose this option to have the report sent to you on regular intervals. See the section for setup details Scheduled Reports
• Advertiser ID: Select the Advertiser IDs that you would like to include in your report. By default, all Advertisers are included.
• Pixel ID: Select the Pixel IDs that you would like to include in your report. By default, all Pixels are included.
• Start Date: Define the start date for the report interval.
• End Date: Define the end date for the report interval.
• Type: Choose the type of report. See each section for more details on report types.
  • Custom Report
  • IP Conversion Pixel: Path to Conversion
  • IP Conversion Pixel: Page Visits
  • IP Conversion Pixel: Conversion Rate
  • Log Level Report
  • Reach/Frequency Report.
• Timezone: Select the timezone that the report will generate, such as Seat Time Zone, User Time Zone, UTC, etc.
• Dimensions: Categorical values that define how data is grouped and segmented in reports, such as Campaign Name, Advertiser ID, and Line ID.

Dimensions:

• Advertiser ID
• Advertiser Name
• Campaign ID
• Campaign Name
• Line ID
• Line Name