Microsoft Invest - Vendor Usage report
The Vendor Usage report is a Member-level report that provides details about data or platform usage powered by third-party vendors (for example, user segment providers), the costs of that data or feature usage, and the line items/campaigns where vendor costs were applicable.
Time frame
All dates and times are given in UTC.
Time ranges
Time ranges define the time period of the data extracted for the report. The following is a complete list of time ranges available for reports. However, all time ranges are not available for every report.
- Custom
- Current Hour
- Last Available Day
- Last Hour
- Today
- Last 24 Hours
- Last 48 Hours
- Yesterday
- Last 2 Days
- Last 7 Days
- Last 7 Available Days
- Last 14 Days
- Last 14 Available Days
- Last 30 Days
- Last 30 Available Days
- Last Month
- Last 100 Days
- Last 365 Days
- Quarter to Date
- Month to Date
- Month to Yesterday
- Lifetime
Intervals
Intervals determine how your data is grouped together into rows in the report response. The following is a complete list of intervals available for reports. However, all intervals are not available for every report.
- Hourly: Data is grouped into rows by the hour.
- Daily: Data is grouped into rows by the day.
- Monthly: Data is grouped into rows by the month.
- Cumulative: Data is grouped together in one figure, covering the entire selected time range.
For more information about how quickly report data is processed, see Availability of Reporting Data.
Data retention period
Data retention period for this report is 60 days.
Dimensions
| Column | Filter? | Description |
|---|---|---|
| Advertiser | Yes | The name and ID of the advertiser associated with the impression. |
| Buying Currency | Yes | The buying currency used for the transaction that incurred the third-party vendor usage costs. Typically, this is the advertiser's preferred currency. |
| Campaign | Yes | The name and ID of the campaign associated with an impression that used third-party data targeting and incurred these costs. |
| Campaign Group Type Id | No | The ID of the campaign group type which purchased the impression. This dimension is used in split reporting. |
| Cost Type | No | The type of cost incurred towards the data usage provided by the third party vendors. Allowed values are : - Feature Costs: Costs incurred when using a platform feature such as Nielsen Digital Ad Ratings (DAR), Nielsen Catalina Solutions (NCS) and Cross Device. - Segment Data Costs: Costs related to the use of segments in the data marketplace. This metric is applicable when specific segments are applied in line items and associated pricing is displayed in the platform. |
| Country | Yes | The name of the country associated with the impression. |
| Insertion Order | Yes | The name and ID of the insertion order associated with the impression. |
| Line Item | Yes | The name and ID of the line item associated with the impression that used third-party data targeting. |
| Split | Yes | The name and ID of the split that purchased the impressions in this data set. Splits are only supported for augmented line items. For any rows with a campaign name, the Split column (if included) will be null. |
| Targeted Segment Ids | No | A comma-separated list of IDs for each of the segments used to target inventory via the line item/campaign. |
| Vendor | Yes | The name and ID of the third party vendor (for example, user segment providers) that provided the data. |
| Vendor Type | No | The type of vendor providing data. Possible values are Segment Marketplace, Offline Attribution, Measurement and Cross Device Graph. |
Metrics
Note
When values of a metric are displayed as percentages in the UI, they will be displayed as decimals when you export the report.
| Column | Description |
|---|---|
| Imps | The number of impressions where a cost was incurred for third-party vendor data. If multiple third-party vendors were used for a single impression, that impression will be listed for each third-party vendor. |
| Sales Tax | The amount of sales tax collected. This field is only populated when the buyer's billing address is located in one of the following U.S. states: NY, TX or NJ. Microsoft Advertising is required to collect this tax by the relevant local state regulator. |
| Vendor Costs | The total costs, including but not limited to segment data costs,and feature costs. |
Warning
Cross-device functionality is available to sellers when running line items that purchase inventory from the ad exchange using RTB. It's not available when sellers are running managed campaigns on their own inventory.
To run your report
Follow these steps to run your report.
Select Reporting from the appropriate top menu (depending on how your account has been configured).
Or
From the Publishers top menu, click on Prebid Server Premium > Analytics > Prebid Server Analytics.Select the relevant report from the list. The Report screen shows the available filters, dimensions, and delivery options for the report. The selections you make here will determine what report data is delivered to you, and how.
Important
For an explanation of how grouping and filtering work, see Dimensions, Metrics, Filtering, and Grouping.
Select the relevant filters to limit the data displayed to just the information you want. For example, rather than running a report that shows impressions for all inventory sources, you may want to list results for just a select few. When you select a filter (by clicking Edit), a selection panel appears. Select items in the Available list (left), then click Add to include them in the Chosen list (right).
Group by Dimension. Grouping allows you to display rows of data in the order you prefer.
Warning
The more dimensions you group by, the larger the data set that is returned. Larger data sets can take substantially longer to process. Be sure to group using only the dimensions you need.
Choose a delivery option. Once you've selected your filters and grouped by your chosen dimensions, you need to choose a delivery method. Available delivery methods include:
Run now, show results in screen: For smaller amounts of data, you may want to view the report as soon as possible in your browser. You can download the report in XLSX, CSV, Excel/TSV and JSON format. However, there is a limit of 100,000 rows per report when downloading as XLSX and Excel file.
Run in background, notify me when results are ready to view: A popup notification will let you know when the report is ready to view or download.
Tip
The maximum size of the report that can be downloaded from the UI is 100 MB. Also, there is a limit of 100,000 rows per report when downloading as XLSX and Excel file. If the size of the report is more than that, you can try to download it using the API for that reporting service (The limit here is 10 million rows).
Export, send results via email: Run the report in the background and email the results to one or more email addresses.
Save as report template: Save your selected report settings so that you can run this report again in the future. You can name this template using the text entry field under Name this report (its checkbox is auto-selected when you choose this option). A saved report can be rerun from the Your Reports screen.
Add to scheduled reports: Run this report automatically at specified times and have it sent to one or more email addresses.
Name this report: Give this report with its current settings a name for future reference.
Click Run report to send your report request.