> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://docs.pixalate.com/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.pixalate.com/_mcp/server. # Query language > Reference for the Pixalate Analytics Reports API query language, including syntax, filters, grouping, sorting, dates, URL encoding, dimensions and metrics. The `q` parameter of the [Analytics Reports API](/apis/analytics-reports-api) tells the API which data to return. It uses a simplified SQL `SELECT` syntax: you list the columns you want, then optionally filter, group and sort them. The value must be URL-encoded. ```text adDomain,impressions,givtSivtRate WHERE day>='2026-02-06' AND day<='2026-02-06' ORDER BY impressions DESC ``` ## Syntax ```text [column [,column...]] [WHERE expression] [GROUP BY column [,column...]] [ORDER BY column [DESC]] ``` > **Warning** > > All characters and their values are case sensitive. `impressions` is a metric; `Impressions` is not. The same applies to the values you compare against. | Element | Definition | | ------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | *column* | A *dimension* or a *metric*. | | *dimension* | One of the dimension identifiers available for the report. See [Dimensions](#dimensions). | | *metric* | One of the metric identifiers available for the report. See [Metrics](#metrics). | | *expression* | One of: *dimension operator literal*, *metric comparator literal*, `(`*expression*`)`, *expression* `AND` *expression*, *expression* `OR` *expression*, `CONTAINS(`*dimension*`,` *literal*`)` | | *operator* | `=` or `!=` | | *comparator* | `=` or `>` or `<` | | *literal* | A *number*, a *string* or a *date*. | | *number* | An integer or decimal number. | | *string* | A text string surrounded by single quotes. | | *date* | A date in *yyyy-mm-dd* format surrounded by single quotes. | ## Select columns Start the query with a comma-separated list of the dimensions and metrics you want. Each one becomes a property of every item in the response's `docs` array, or a column in a CSV export. ```text fraudType,impressions,sivtImpressions,sivtImpsRate,givtImpressions,givtImpsRate ``` The examples on this page list columns with no space after each comma. ## Filter with WHERE A `WHERE` clause filters the rows. Each condition compares a column to a literal: | Compare | Allowed | Example | | ------------------------ | ------------------------------------------------ | ------------------ | | A dimension to a literal | `=` (equal), `!=` (not equal) | `adultRisk='high'` | | A metric to a literal | `=` (equal), `>` (greater than), `<` (less than) | `impressions>1000` | Literals take three forms: | Literal | Format | Example | | ------- | ----------------------------- | ------------------- | | Number | An integer or decimal number | `1000`, `0.5` | | String | Text in single quotes | `'com.example.app'` | | Date | `yyyy-mm-dd` in single quotes | `'2026-02-01'` | ### Combine conditions Join conditions with `AND` and `OR`, and group them with parentheses: ```text WHERE day>='2026-02-01' AND day<='2026-02-01' AND adultRisk='high' ``` ```text WHERE day>='2026-02-01' AND day<='2026-02-01' AND (CONTAINS(LOWER(deviceMarketingName),LOWER('Iphone'))) ``` > **Tip** > > The syntax doesn't define whether `AND` or `OR` is evaluated first. Use parentheses whenever a filter mixes `AND` and `OR`, so the grouping is explicit. ### Match text with CONTAINS `CONTAINS(dimension, literal)` matches rows where the dimension's value contains the literal text. Because values are case sensitive, the [Contains specified value](#contains-a-specified-value) example wraps both arguments in `LOWER()`: ```text CONTAINS(LOWER(deviceMarketingName),LOWER('Iphone')) ``` ## Set the date range Filter on the `day` dimension. Dates are `yyyy-mm-dd` strings in single quotes. Every example on this page sets a start and end date like this: ```text WHERE day>='2026-02-01' AND day<='2026-02-01' ``` Use the same date twice for a single day. To choose the time zone the report data is synced in, use the `timeZone` request parameter (minutes from GMT; the default `0` is UTC). See [Set the date range](/apis/analytics-reports-api#set-the-date-range) in the API guide. ## Group with GROUP BY `GROUP BY` takes one or more comma-separated columns. The examples group by the dimension they report on: ```text advertiserId,reach,impressions WHERE day>='2026-02-01' AND day<='2026-02-01' GROUP BY advertiserId ``` ## Sort with ORDER BY `ORDER BY` takes one column, optionally followed by `DESC`: ```text ORDER BY impressions DESC ``` > **Note** > > When you export a large result with `isLargeResultSet=true`, `ORDER BY` may cause a `400 Bad Request`. If it does, remove the `ORDER BY` clause. See [Export a large result set](/apis/analytics-reports-api#export-a-large-result-set). ## URL-encode the query `q` must be URL-encoded. The query contains spaces, commas, quotes and comparison operators, and each one must be percent-encoded in the URL: | Character | Encoded | | --------- | ----------- | | space | `%20` | | `,` | `%2C` | | `'` | `%27` | | `=` | `%3D` | | `>` | `%3E` | | `<` | `%3C` | | `(` `)` | `%28` `%29` | For example, this query: ```text adDomain,impressions,givtSivtRate WHERE day>='2026-02-06' AND day<='2026-02-06' ORDER BY impressions DESC ``` is sent as: ```text q=adDomain%2Cimpressions%2CgivtSivtRate%20WHERE%20day%3E%3D%272026-02-06%27%20AND%20day%3C%3D%272026-02-06%27%20ORDER%20BY%20impressions%20DESC ``` You rarely need to encode by hand. curl's `--get` and `--data-urlencode` options encode the value for you: ```bash curl --get "https://api.pixalate.com/api/v2/analytics/reports/default" \ -H "x-api-key: YOUR_API_KEY" \ --data-urlencode "q=adDomain,impressions,givtSivtRate WHERE day>='2026-02-06' AND day<='2026-02-06' ORDER BY impressions DESC" \ --data-urlencode "limit=10" ``` ## Worked examples These queries match reports in the Pixalate dashboard. Send each one as `q` to the report ID shown. ### Dashboard (by advertiser) The *Dashboard* report, which is the default report when you first log in to the Pixalate dashboard. Report ID: `default`. ```text advertiserId,reach,impressions,viewability,views,viewsRate,adsAboveTheFold,givtImpsRate,sivtImpsRate WHERE day>='2026-02-01' AND day<='2026-02-01' GROUP BY advertiserId ORDER BY impressions DESC ``` ### Domain The *Domain* report listed under the Dashboard report in the main report section. Report ID: `default`. ```text adDomain,impressions,givtSivtRate WHERE day>='2026-02-06' AND day<='2026-02-06' ORDER BY impressions DESC ``` ### By fraud type The *By Fraud Type* report, listed under Pre-Set Reports in the dashboard. Report ID: `default`. ```text fraudType,impressions,sivtImpressions,sivtImpsRate,givtImpressions,givtImpsRate WHERE day>='2026-02-01' AND day<='2026-02-01' GROUP BY fraudType ORDER BY impressions DESC ``` Each row holds the data for one fraud type. A row with a fraud type value always reports 100% IVT. A row with no fraud type value is 100% IVT-free. ### By seller The *By Seller ID* report, listed under Pre-Set Reports in the dashboard. `kv7` is the Seller ID dimension. Report ID: `default`. ```text kv7,impressions,sivtImpressions,sivtImpsRate,givtImpressions,givtImpsRate WHERE day>='2026-02-01' AND day<='2026-02-01' GROUP BY kv7 ORDER BY impressions DESC ``` ### Specific bundle IDs Data for a specific set of app bundle IDs (`kv18`). Report ID: `default`. ```text kv18,impressions,sivtImpressions,sivtImpsRate,givtImpressions,givtImpsRate WHERE day>='2026-02-01' AND day<='2026-02-01' AND kv18='com.mobilityware.solitaire' OR kv18='1407852246' OR kv18='com.zynga.words' GROUP BY kv18 ORDER BY impressions DESC ``` ### Contains a specified value Data where a dimension's value contains specific text, here device marketing names that contain "iphone" in any case. Report ID: `default`. ```text kv18,deviceBrandName,deviceMarketingName,impressions,sivtImpressions,sivtImpsRate,givtImpressions,givtImpsRate WHERE day>='2026-02-01' AND day<='2026-02-01' AND (CONTAINS(LOWER(deviceMarketingName),LOWER('Iphone'))) GROUP BY kv18 ORDER BY impressions DESC ``` ### Supply path The *By Supply Path* report, listed under SPO Reports: Supply Path in the dashboard. Report ID: `spo`. ```text kv18,kv55,node1SellerId,node2SellerId,nodePathComplete,impressions,givtSivtRate WHERE day>='2026-02-01' AND day<='2026-02-01' ORDER BY impressions DESC ``` ### Source-destination traffic The *By Source-Destination Traffic* report, listed under SPO Reports: Source Destination Traffic in the dashboard. Report ID: `spoSrcDest`. ```text src,dest,impressions,givtSivtRate,givtImpsRate,sivtImpsRate WHERE day>='2026-02-01' AND day<='2026-02-01' ORDER BY impressions DESC ``` ### Brand safety App IDs with high adult risk, from the mobile Brand Safety report. Report ID: `mobileBrandSafety`. ```text kv18,adultRisk,impressions WHERE day>='2023-10-24' AND day<='2023-10-24' AND adultRisk='high' ORDER BY impressions DESC ``` ## Dimensions Dimensions are the attributes of the data, returned as rows. For example, the `adDomain` dimension returns each domain value in its own row. Many dimensions align with the dimensions in Pixalate's dashboard reporting. Which dimensions you can use depends on the report. > **Note** > > Some dimensions may not be enabled for your account by default, including `kv4`, `kv5`, `kv6`, `kv8`, `kv9`, `kv10`, `kv13`, `kv19` to `kv22`, `kv52`, `kv55`, high risk app status, and the SPO report dimensions. To have them enabled, contact your Pixalate account manager. ### Available dimensions | Dimension | Description | | --------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `adDomain` | Detected Domain of site where ad was displayed | | `adSize` | Size of the ad | | `adTrafficSource` | Domain of which referred visitor to ad domain | | `advertiserId` | Advertiser identifier | | `areaCode` | Visitor’s area code | | `browserName` | Visitor’s browser name | | `campaignId` | Campaign identifier | | `city` | Visitor’s city | | `countryCode` | Visitor’s country code | | `countryName` | Visitor’s country name | | `day` | Date | | `deviceBrandName` | Visitor’s device brand name | | `deviceModelId` | Visitor’s device identifier | | `deviceMarketingName` | Visitor’s device marketing name | | `deviceTrafficType` | Visitor’s Detected device Traffic type | | `deviceType` | Visitor’s device type | | `dma` | Designated Market Area | | `fraudType` | Fraud Traffic Type | | `ipv6Type` | IPv6 Type | | `isHighRiskApp` | A boolean (Yes/No) indicator in app-specific reports that identifies whether an app appears on the High Risk App (HRA) list. Column values are populated on request (contact [support@pixalate.com](mailto:support@pixalate.com)). | | `kv1` | Creative Size | | `kv2` | Page URL | | `kv3` | User ID | | `kv4` | User IP (can be IPv4 or IPv6) | | `kv5` | (Custom) | | `kv6` | (Custom UTM Value) | | `kv7` | Seller ID | | `kv8` | (Custom UTM Value) | | `kv9` | Content Duration | | `kv10` | ISP | | `kv12` | Placement ID | | `kv13` | Content ID | | `kv14` | MRAID Version | | `kv15` | Geographic Region | | `kv16` | Latitude | | `kv17` | Longitude | | `kv18` | App ID or Bundle ID | | `kv19` | Device ID | | `kv20` | Device ID (additional if needed) | | `kv21` | Device ID (additional if needed) | | `kv22` | Device ID (additional if needed) | | `kv23` | Carrier ID | | `kv24` | Supply Type | | `kv25` | App Name | | `kv26` | Device OS | | `kv27` | Useragent | | `kv28` | Device manufacturer/model | | `kv32` | App ID | | `kv44` | Video Play Status | | `kv52` | SSAI integration | | `kv55` | Serialized supply chain object | | `lineItemId` | Line item identifier | | `organization` | Organization Name | | `os` | Visitor’s operating system | | `partnerId` | Partner identifier | | `placementId` | Creative identifier | | `postalCode` | Visitor’s postal code | | `publisherId` | Publisher identifier | | `regionCode` | Visitor’s region code | | `segment` | Segment | | `siteId` | Site identifier | | `adultRisk` | Adult Risk (Brand Safety) - low/medium/high | | `drugRisk` | Drug Risk (Brand Safety) - low/medium/high | | `alcoholRisk` | Alcohol Risk (Brand Safety) - low/medium/high | | `advisoriesRisk` | Advisories Risk (Brand Safety) - low/medium/high | | `hateRisk` | Hate Risk (Brand Safety) - low/medium/high | | `offensiveRisk` | Offensive Risk (Brand Safety) - low/medium/high | | `gamblingRisk` | Gambling Risk (Brand Safety) - low/medium/high | | `violenceRisk` | Violence Risk (Brand Safety) - low/medium/high | ### SPO dimensions These dimensions describe the supply chain object (SCO) and are used in the SPO reports. `src` and `dest` apply to the `spoSrcDest` report. | Dimension | Description | | -------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `nodePathComplete` | The value of “Complete” flag supplied in the Supply Chain Object (SCO). Not validated | | `node1Name` | The “Ad System” listed in the 1st node of the Supply Chain Object (SCO) | | `node1SellerId` | The “Seller ID” listed in the 1st node of the Supply Chain Object (SCO) | | `node1SellerName` | The Name of seller that the SellerID in Node 1 points to (picked up from sellers.json of the Ad System in Node 1) | | `node1SellerType` | The Seller type of the seller that the SellerID in Node 1 points to (picked up from sellers.json of the Ad System in Node 1) | | `node1SellerDomain` | The Seller domain of the seller that the SellerID in Node 1 points to (picked up from sellers.json of the Ad System in Node 1) | | `node2Name` | The “Ad System” listed in the 2nd node of the Supply Chain Object (SCO) | | `node2SellerId` | The “Seller ID” listed in the 2nd node of the Supply Chain Object (SCO) | | `node2SellerName` | The Name of seller that the SellerID in Node 2 points to (picked up from sellers.json of the Ad System in Node 2) | | `node2SellerType` | The Seller type of the seller that the SellerID in Node 2 points to (picked up from sellers.json of the Ad System in Node 2) | | `node2SellerDomain` | The Seller domain of the seller that the SellerID in Node 2 points to (picked up from sellers.json of the Ad System in Node 2) | | `node3Name` | The “Ad System” listed in the 3rd node of the Supply Chain Object (SCO) | | `node3SellerId` | The “Seller ID” listed in the 3rd node of the Supply Chain Object (SCO) | | `node3SellerName` | The Name of seller that the SellerID in Node 3 points to (picked up from sellers.json of the Ad System in Node 3) | | `node3SellerType` | The Seller type of the seller that the SellerID in Node 3 points to (picked up from sellers.json of the Ad System in Node 3) | | `node3SellerDomain` | The Seller domain of the seller that the SellerID in Node 3 points to (picked up from sellers.json of the Ad System in Node 3) | | `node4Name` | The “Ad System” listed in the 4th node of the Supply Chain Object (SCO) | | `node4SellerId` | The “Seller ID” listed in the 4th node of the Supply Chain Object (SCO) | | `node4SellerName` | The Name of seller that the SellerID in Node 4 points to (picked up from sellers.json of the Ad System in Node 4) | | `node4SellerType` | The Seller type of the seller that the SellerID in Node 4 points to (picked up from sellers.json of the Ad System in Node 4) | | `node4SellerDomain` | The Seller domain of the seller that the SellerID in Node 4 points to (picked up from sellers.json of the Ad System in Node 4) | | `rNode1Name` | The “Ad System” listed in the R Node 1 - the 1st node of the reversed Supply Chain Object (SCO). The purpose of reversing is to more easily enable analysis from the opposite perspective. Recommend not combining reverse node dimensions with regular node dimensions | | `rNode1SellerId` | The “Seller ID” listed in R Node 1 of the reversed Supply Chain Object | | `rNode1SellerName` | The Name of seller that the SellerID in “R Node 1” points to (picked up from sellers.json of the Ad System in “R Node 1”) | | `rNode1SellerType` | The Seller type of the seller that the SellerID in “R Node 1” points to (picked up from sellers.json of the Ad System in “R Node 1”) | | `rNode1SellerDomain` | The Seller domain of the seller that the SellerID in “R Node 1” points to (picked up from sellers.json of the Ad System in “R Node 1”) | | `rNode2Name` | The “Ad System” listed in the R Node 2 - the 2nd node of the reversed Supply Chain Object (SCO). The purpose of reversing is to more easily enable analysis from the opposite perspective. Recommend not combining reverse node dimensions with regular node dimensions | | `rNode2SellerId` | The “Seller ID” listed in R Node 2 of the reversed Supply Chain Object | | `rNode2SellerName` | The Name of seller that the SellerID in “R Node 2” points to (picked up from sellers.json of the Ad System in “R Node 2”) | | `rNode2SellerType` | The Seller type of the seller that the SellerID in “R Node 2” points to (picked up from sellers.json of the Ad System in “R Node 2”) | | `rNode2SellerDomain` | The Seller domain of the seller that the SellerID in “R Node 2” points to (picked up from sellers.json of the Ad System in “R Node 2”) | | `rNode3Name` | The “Ad System” listed in the R Node 3 - the 3rd node of the reversed Supply Chain Object (SCO). The purpose of reversing is to more easily enable analysis from the opposite perspective. Recommend not combining reverse node dimensions with regular node dimensions | | `rNode3SellerId` | The “Seller ID” listed in R Node 3 of the reversed Supply Chain Object | | `rNode3SellerName` | The Name of seller that the SellerID in “R Node 3” points to (picked up from sellers.json of the Ad System in “R Node 3”) | | `rNode3SellerType` | The Seller type of the seller that the SellerID in “R Node 3” points to (picked up from sellers.json of the Ad System in “R Node 3”) | | `rNode3SellerDomain` | The Seller domain of the seller that the SellerID in “R Node 3” points to (picked up from sellers.json of the Ad System in “R Node 3”) | | `rNode4Name` | The “Ad System” listed in the R Node 4 - the 4th node of the reversed Supply Chain Object (SCO). The purpose of reversing is to more easily enable analysis from the opposite perspective. Recommend not combining reverse node dimensions with regular node dimensions | | `rNode4SellerId` | The “Seller ID” listed in R Node 4 of the reversed Supply Chain Object | | `rNode4SellerName` | The Name of seller that the SellerID in “R Node 4” points to (picked up from sellers.json of the Ad System in “R Node 4”) | | `rNode4SellerType` | The Seller type of the seller that the SellerID in “R Node 4” points to (picked up from sellers.json of the Ad System in “R Node 4”) | | `rNode4SellerDomain` | The Seller domain of the seller that the SellerID in “R Node 4” points to (picked up from sellers.json of the Ad System in “R Node 4”) | | `src` | (Source) Ad System for the source node regardless of location \[applicable for the report "spoSrcDest"] | | `dest` | (Destination) Ad System for the corresponding (from source) destination node \[applicable for the report "spoSrcDest"] | ## Metrics Metrics are the numbers measured for each row of dimension values. For example, the `impressions` metric is the total number of impressions for each row. Many metrics align with the metrics in Pixalate's dashboard reporting. The label is the name the metric has in the dashboard and in CSV exports. Rate metrics are returned as fractions, so `1` means 100%. | Metric | Label | Description | | ------------------------------------------- | ---------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `adExposure` | Ad Exposure | Percentage of total time spent on a web page in which the Ad was visible to the user | | `adExposureTime` | Ad Exposure Time | Amount of time Ad is visible to the user on the web page. Ad exposure is measured in minutes and seconds | | `adHoverTime` | Ad Hover | Average amount of time that users hovered over the Ad with the mouse cursor, expressed in minutes:seconds.milliseconds | | `adsAboveTheFold` | Ads Above The Fold | Total number of Ad Counts that were determined to be served within the user’s browser viewport before the removal of invalid traffic. | | `clickConvs` | Gross Matched C-Convs | Click-through Conversions. Total number of Matched Conversions in which users clicked on the Ad, visited the website and performed an action (such as purchasing an item). | | `totalClicks` | Gross Clicks | Total number of measured clicks before removal of Invalid Traffic | | `clicks` | Gross Matched Clicks | Total number of measured clicks that were matched to an Ad Count before removal of invalid traffic. | | `totalConversions` | Gross Conversions | Total number of measured actions (such as purchasing an item) related to Ads before the removal of Invalid Traffic | | `conversions` | Gross Matched Conversions | Total number of conversions that were matched to an Ad Count before the removal of invalid traffic | | `totalConvRate` | Gross Conversion Rate | Percentage of measured actions (such as purchasing an item) related to Ads before the removal of invalid traffic | | `ctr` | Gross CTR | Percentage of Gross Measured Clicks divided by Ad Counts | | `duplicateClicks` | Gross Duplicate Clicks | Total number of duplicate measured Clicks; before removal of IVT | | `duplicateClicksRate` | Gross Duplicate Clicks % | Percentage of duplicate measured Clicks; before removal of IVT | | `duplicateImps` | Gross Duplicate Ad Counts | Total number of duplicate Ad Counts before removal of invalid traffic (IVT) | | `duplicateImpsRate` | Gross Duplicate Ad Counts % | Percentage of duplicate Ad Counts in relation to total Ad Counts; before removal of IVT | | `duplicateMatchedClicks` | Gross Duplicate Matched Clicks | Total number of measured duplicate Clicks that were matched to an Ad Count; before removal of IVT | | `duplicateMatchedClicksRate` | Gross Duplicate Matched Clicks % | Percentage of measured duplicate Clicks that were matched to an Ad Counts; before removal of IVT | | `givtTotalClicks` | GIVT Clicks | Number of Clicks that were filtered as General Invalid Traffic | | `givtTotalClicksRate` | GIVT Clicks % | Percentage of Clicks that were filtered as General Invalid Traffic | | `givtClickRate` | GIVT Matched Clicks % | Percentage of Gross Matched Clicks that were filtered as General Invalid Traffic | | `givtClicks` | GIVT Matched Clicks | Number of Gross Matched Clicks that were filtered as General Invalid Traffic | | `givtTotalConversions` | GIVT Conversions | Number of Gross Conversions that were filtered as General Invalid Traffic | | `givtConversions` | GIVT Matched Conversions | Number of Gross Matched Conversions that were filtered as General Invalid Traffic | | `givtTotalConvsRate` | GIVT Conversions % | Percentage of Gross Conversions that were filtered as General Invalid Traffic | | `givtConvsRate` | GIVT Matched Conversions % | Percentage of Gross Matched Conversions that were filtered as General Invalid Traffic | | `givtImpressions` | GIVT Ad Counts | Number of Ad Counts that were filtered as General Invalid Traffic. | | `givtImpsRate` | GIVT Ad Counts % | Percentage of Ad Counts that were filtered as General Invalid Traffic. | | `givtIpv6Impressions` | IPv6 GIVT Ad Counts | Total number of IPv6 Ad Counts that were filtered as General Invalid Traffic | | `givtIpv6ImpressionsRate` | IPv6 GIVT Ad Counts % | Percentage of total number of IPv6 Ad Counts that were filtered as General Invalid Traffic. | | `givtRate` | GIVT % | Percentage of Ad Counts, Clicks, and Conversions that were filtered as General Invalid Traffic. | | `givtSivtIpv6Impressions` | IPv6 IVT Ad Counts | Total number of IPv6 Ad Counts that were filtered as Invalid Traffic | | `givtSivtIpv6ImpressionsRate` | IPv6 IVT Ad Counts % | Percentage of IPv6 Ad Counts that were filtered as Invalid Traffic | | `givtSivtRate` | IVT % | Total percentage of General Invalid Traffic and Sophisticated Invalid Traffic | | `givtTraffic` | GIVT Traffic | Total number of Ad Counts, Clicks, and Conversions that were filtered as General Invalid Traffic. | | `impressions` | Gross Ad Counts | Total number of Ad Counts before the removal of Invalid Traffic. | | `ipv6Impressions` | Gross IPv6 Ad Counts | Total number of IPv6 Ad Counts before removal of invalid traffic | | `ipv6ImpressionsRate` | Gross IPv6 Ad Counts % | Percentage of IPv6 Ad Counts from total Ad Counts before removal of invalid traffic | | `malwareTraffic` | Malware Traffic | Number of Gross Ad Counts that were determined to be generated by Malware | | `measuredImpressions` | Net Measured Impressions | Total number of Rendered Display Impressions in which Pixalate’s technology was capable of measuring for Viewability after the removal of all Invalid Traffic | | `measuredRate` | Net Measured Rate % | Percentage of Rendered Display Impressions in which Pixalate’s technology was capable of measuring for Viewability after the removal of all Invalid Traffic | | `mediaSpend` | Media Spend | Total media spend of all Ad Counts based on the recorded price paid. | | `nonGivtTotalClicks` | Clicks | Total number of measured clicks after removal of General Invalid Traffic | | `nonGivtClicks` | Matched Clicks | Total number of measured clicks that were matched to an Ad Count after removal of General Invalid Traffic | | `nonGivtTotalConversions` | Conversions | Total number of measured actions (such as purchasing an item) related to Ads after removal of General Invalid Traffic | | `nonGivtConversions` | Matched Conversions | Total number of conversions that were matched to an Ad Count after removal of General Invalid Traffic. | | `nonGivtCtr` | CTR | Percentage of matched clicks divided by Ad Counts after the removal of General Invalid Traffic | | `nonGivtDuplicateClicks` | Duplicate Clicks | Total number of duplicate measured clicks; net of GIVT | | `nonGivtDuplicateClicksRate` | Duplicate Clicks % | Percentage of duplicate Clicks after the removal of General Invalid Traffic in relation to total measured Clicks | | `nonGivtDuplicateImps` | Duplicate Ad Counts | Total number of duplicate Ad Counts after removal of General Invalid traffic (GIVT) | | `nonGivtDuplicateImpsRate` | Duplicate Ad Counts % | Percentage of duplicate Ad Counts after the removal of General Invalid Traffic in relation to total Ad Counts; net of GIVT. | | `nonGivtDuplicateMatchedClicks` | Duplicate Matched Clicks | Total number of measured duplicate Clicks that were matched to an Ad Count; net of GIVT | | `nonGivtDuplicateMatchedClicksRate` | Duplicate Matched Clicks % | Percentage of measured duplicate Clicks that were matched to an Ad Count; net of GIVT | | `nonGivtImpressions` | Ad Counts | Total number of Ad Counts after the removal of General Invalid Traffic | | `nonGivtIpv6Impressions` | IPv6 Ad Counts | Total number of IPv6 Ad Counts, excluding GIVT. | | `nonGivtIpv6ImpressionsRate` | IPv6 Ad Counts % | Percentage of IPv6 Ad Counts from total Ad Counts, excluding GIVT. | | `nonGivtMeasuredImpressions` | Measured Impressions | Total number of Rendered Display Impressions in which Pixalate’s technology was capable of measuring for Viewability after the removal of General Invalid Traffic | | `nonGivtMeasuredRate` | Measured Rate % | Percentage of Rendered Display Impressions in which Pixalate’s technology was capable of measuring for Viewability after the removal of General Invalid Traffic | | `nonGivtNonViews` | Non Views | Total number of Measured Impressions that were determined to not meet the requirements of a Viewable Impression after the removal of General Invalid Traffic. | | `nonGivtNonViewsRate` | Non Views % | Percentage of Rendered Display Impressions that were determined to not meet the requirements of a Viewable Impression after the removal of General Invalid Traffic | | `nonGivtReach` | Reach | Total number of uniquely identified visitors after removal of General Invalid Traffic | | `nonGivtRenderedImpressions` | Rendered Impressions | Total number of Rendered Ad Impressions (Display & Video) after removal of General Invalid Traffic | | `nonGivtRenderedVideoImpressions` | Rendered Video Impressions | Total number of Rendered Video Ad Impressions after removal of General Invalid Traffic | | `nonGivtScriptImpressions` | Rendered Display Impressions | Number of Rendered Display Impressions generated from Pixalate’s script technology (excludes 1x1 pixel impressions) after the removal of General Invalid Traffic | | `nonGivtSivtTotalClicks` | Net Clicks | Number of measured clicks net of all Invalid Traffic | | `nonGivtSivtClicks` | Net Matched Clicks | Number of measured clicks that were matched to an Ad Count after the removal of all invalid traffic. | | `nonGivtSivtTotalConversions` | Net Conversions | Total number of measured actions (such as purchasing an item) related to Ads net of all Invalid Traffic | | `nonGivtSivtConversions` | Net Matched Conversions | Total number of conversions that were matched to an Ad Count after the removal of all Invalid Traffic. | | `nonGivtSivtCtr` | Net CTR | Percentage of matched clicks divided by Ad Counts after the removal of all Invalid Traffic. | | `nonGivtSivtDuplicateClicks` | Net Duplicate Clicks | Number of duplicate measured Clicks; net of all IVT | | `nonGivtSivtDuplicateClicksRate` | Net Duplicate Clicks % | Percentage of duplicate Clicks after the removal of all Invalid Traffic in relation to total measured Clicks; net of all IVT | | `nonGivtSivtDuplicateImps` | Net Duplicate Ad Counts | Total number of duplicate Ad Counts after removal of all Invalid traffic (IVT) | | `nonGivtSivtDuplicateImpsRate` | Net Duplicate Ad Counts % | Percentage of duplicate Ad Counts after the removal of all Invalid Traffic in relation to total Net Ad Counts; net of all IVT | | `nonGivtSivtDuplicateMatchedClicks` | Net Duplicate Matched Clicks | Number of measured duplicate Clicks that were matched to an Ad Count; net of all IVT | | `nonGivtSivtDuplicateMatchedClicksRate` | Net Duplicate Matched Clicks % | Percentage of measured duplicate Clicks that were matched to an Ad Count; net of all IVT | | `nonGivtSivtImpressions` | Net Ad Counts | Total number of Ad Counts after the removal of all Invalid Traffic | | `nonGivtSivtIpv6Impressions` | Net IPv6 Ad Counts | Total number of IPv6 Ad Counts, excluding IVT. | | `nonGivtSivtIpv6ImpressionsRate` | Net IPv6 Ad Counts % | Percentage of IPv6 Ad Counts from total Ad Counts, excluding IVT. | | `nonGivtSivtReach` | TruReach | Number of uniquely identified visitors net of all Invalid Traffic | | `nonGivtSivtRenderedImpressions` | Net Rendered Impressions | Total number of Rendered Ad Impressions (Display & Video) after removal of all Invalid Traffic | | `nonGivtSivtRenderedVideoImpressions` | Net Rendered Video Impressions | Total number of Rendered Video Ad Impressions after removal of all Invalid Traffic | | `nonGivtSivtSsaiImpressions` | Net SSAI Ad Counts | Estimated total SSAI Ad Counts, excluding IVT | | `nonGivtSivtSsaiImpressionsRate` | Net SSAI Ad Counts % | Estimated percentage of Ad Counts that correspond to SSAI proxies, excluding IVT | | `nonGivtSivtSsaiTransparentImpressions` | Net SSAI Transparent Ad Counts | Estimated total SSAI Ad Counts that come from proxies passing X-Device-User-Agent headers for more transparency, excluding IVT. | | `nonGivtSivtSsaiTransparentImpressionsRate` | Net SSAI Transparent Ad Counts % | Estimated percentage of Ad Counts that correspond to SSAI and come from proxies passing X-Device-User-Agent headers for more transparency, excluding IVT. | | `nonGivtSivtViewConvs` | Net Matched V-Convs | View-through conversions. Total number of matched conversions in which users took action at a later time after seeing a viewable impression after removal of all invalid traffic | | `nonGivtSsaiImpressions` | SSAI Ad Counts | Estimated total SSAI Ad Counts, excluding GIVT | | `nonGivtSsaiImpressionsRate` | SSAI Ad Counts % | Estimated percentage of Ad Counts that correspond to SSAI proxies, excluding GIVT | | `nonGivtSsaiTransparentImpressions` | SSAI Transparent Ad Counts | Estimated total SSAI Ad Counts that come from proxies passing X-Device-User-Agent headers for more transparency, excluding GIVT. | | `nonGivtSsaiTransparentImpressionsRate` | SSAI Transparent Ad Counts % | Estimated percentage of Ad Counts that correspond to SSAI and come from proxies passing X-Device-User-Agent headers for more transparency, excluding GIVT. | | `nonGivtUndeterminedImps` | Undetermined Imps | Total number of Rendered Display Impressions in which Pixalate’s technology was NOT able to determine if the Ad Impression met the requirements of a Viewable Impression after the removal of General Invalid Traffic. | | `nonGivtUndeterminedImpsRate` | Undetermined Imps % | Percentage of Rendered Display Impressions in which Pixalate’s technology was NOT able to determine if the Ad Impression met the requirements of a Viewable Impression after the removal of General Invalid Traffic | | `nonGivtViewability` | Viewability % | Percentage of Measured Impressions that were determined to be Viewable Impressions after the removal of General Invalid Traffic | | `nonGivtViews` | Views | Total number of Measured Impressions that were determined to be Viewable Impressions after the removal of General Invalid Traffic | | `nonGivtViewsRate` | Views % | Percentage of Rendered Display Impressions that were determined to be Viewable Impressions after the removal of General Invalid Traffic | | `nonViews` | Net Non Views | Total number of Measured Impressions that were determined to not meet the requirements of a Viewable Impression net of all Invalid Traffic | | `nonViewsRate` | Net Non Views % | Percentage of Rendered Display Impressions that were determined to not meet the requirements of a Viewable Impression after the removal of all Invalid Traffic. | | `phishingTraffic` | Phishing Traffic | Number of Gross Ad Counts that were determined to be generated by Phishing activity. | | `priceBid` | Bid Price | Average bid price for Ad Counts. | | `reach` | Gross Reach | Total number of uniquely identified browser cookies before removal of Invalid Traffic | | `renderedImpressions` | Gross Rendered Impressions | Total number of Rendered Ad Impressions (Display & Video) before removal of invalid traffic | | `renderedVideoImpressions` | Gross Rendered Video Impressions | Total number of Rendered Video Ad Impressions before removal of invalid traffic | | `scriptImpressions` | Gross Rendered Display Impressions | Total number of Rendered Display Ad Impressions generated from Pixalate’s script technology (excludes 1x1 pixel impressions) before the removal of Invalid Traffic | | `shareOfGivtImpressions` | Share of GIVT Ad Counts % | Percentage of Ad Counts that were filtered as General Invalid Traffic in relation to total General Invalid Traffic filtered. | | `shareOfGivtSivtImpressions` | Share of IVT Ad Counts % | Percentage of Gross Ad Counts that were filtered as Invalid Traffic in relation to total Invalid Traffic filtered. | | `shareOfImpressions` | Share of Gross Ad Counts % | Percentage of Ad Counts before the removal of invalid traffic in relation to total Ad Counts. | | `shareOfNonGivtImpressions` | Share of Ad Counts % | Percentage of Ad Counts after the removal of General Invalid Traffic in relation to total Ad Counts after the removal of General Invalid Traffic. | | `shareOfNonGivtSivtImpressions` | Share of Net Ad Counts % | Percentage of Ad Counts after the removal of all Invalid Traffic in relation to total Net Ad Counts after removal of all Invalid Traffic | | `shareOfSivtImpressions` | Share of SIVT Ad Counts % | Percentage of Ad Counts that were filtered as Sophisticated Invalid Traffic in relation to total Sophisticated Invalid Traffic filtered. | | `sivtTotalClicks` | SIVT Clicks | Number of Clicks that were filtered as Sophisticated Invalid Traffic | | `sivtTotalClicksRate` | SIVT Clicks % | Percentage of Clicks that were filtered as Sophisticated Invalid Traffic | | `sivtClickRate` | SIVT Matched Clicks % | Percentage of Gross Matched Clicks that were filtered as Sophisticated Invalid Traffic | | `sivtClicks` | SIVT Matched Clicks | Number of Gross Matched Clicks that were filtered as Sophisticated Invalid Traffic | | `sivtTotalConversions` | SIVT Conversions | Number of Gross Conversions that were filtered as Sophisticated Invalid Traffic | | `sivtConversions` | SIVT Matched Conversions | Number of Gross Matched Conversions that were filtered as Sophisticated Invalid Traffic | | `sivtTotalConvsRate` | SIVT Conversions % | Percentage of Gross Conversions that were filtered as Sophisticated Invalid Traffic | | `sivtConvsRate` | SIVT Matched Conversions % | Percentage of Gross Matched Conversions that were filtered as Sophisticated Invalid Traffic | | `sivtImpressions` | SIVT Ad Counts | Number of Gross Ad Counts that were filtered as Sophisticated Invalid Traffic. | | `sivtImpsRate` | SIVT Ad Counts % | Percentage of Gross Ad Counts that were filtered as Sophisticated Invalid Traffic. | | `sivtIpv6Impressions` | IPv6 SIVT Ad Counts | Total number of IPv6 Ad Counts that were filtered as Sophisticated Invalid Traffic | | `sivtIpv6ImpressionsRate` | IPv6 SIVT Ad Counts % | Percentage of total number of IPv6 Ad Counts that were filtered as Sophisticated Invalid Traffic. | | `sivtRate` | SIVT % | Percentage of Ad Counts, Clicks, and Conversions that were filtered as Sophisticated Invalid Traffic. | | `sivtTraffic` | SIVT Traffic | Total number of Ad Counts, Clicks, and Conversions that were filtered as Sophisticated Invalid Traffic. | | `ssaiImpressions` | Gross SSAI Ad Counts | Estimated total SSAI Ad Counts, before removal of IVT | | `ssaiImpressionsRate` | Gross SSAI Ad Counts % | Estimated percentage of Ad Counts that correspond to SSAI proxies, before removal of IVT | | `ssaiTransparentImpressions` | Gross SSAI Transparent Ad Counts | Estimated total SSAI Ad Counts that come from proxies passing X-Device-User-Agent headers for more transparency, before removal of IVT | | `ssaiTransparentImpressionsRate` | Gross SSAI Transparent Ad Counts % | Estimated percentage of Ad Counts that correspond to SSAI and come from proxies passing X-Device-User-Agent headers for more transparency, before removal of IVT | | `timeSpentOnPage` | Time Spent On Page | Average amount of time that users spent on the web page, expressed in minutes:seconds | | `undeterminedImps` | Net Undetermined Imps | Total number of Rendered Display Impressions in which Pixalate’s technology was NOT able to determine if the Ad Impression met the requirements of a Viewable Impression after the removal of all Invalid Traffic | | `undeterminedImpsRate` | Net Undetermined Imps % | Percentage of Rendered Display Impressions in which Pixalate’s technology was NOT able to determine if the Ad Impression met the requirements of a Viewable Impression after the removal of all Invalid Traffic | | `viewability` | Net Viewability % | Percentage of Measured Impressions that were determined to be Viewable Impressions after the removal of all Invalid Traffic | | `viewConvs` | Gross Matched V-Convs | View-through Conversions. Total number of Matched Conversions in which users took action at a later time after seeing a Viewable Impression | | `views` | Net Views | Total number of Measured Impressions that were determined to be Viewable Impressions after the removal of all Invalid Traffic | | `viewsRate` | Net Views % | Percentage of Impressions that were determined to be Viewable Impressions net of all Invalid Traffic | The [Get analytics report](/api-reference/analytics-reports/get-analytics-report) reference also lists the dimensions and metrics in its response schema. If you need a dimension or metric that isn't listed here, contact [support@pixalate.com](mailto:support@pixalate.com). ## Related #### [Analytics Reports API](/apis/analytics-reports-api) Authentication, pagination, CSV export and errors. #### [API reference](/api-reference/analytics-reports/get-analytics-report) Every parameter and response field for the report endpoint.