Kamino
Use dashboards and reports

Get raw extracts of campaign insights data

Overview Categ_Analysis Daily deliv Exp_Buyers Global delivery ID analysis KSP NoExp_Buyers Recruitment Sales Table Top categ Top keywords UV

Overview

This document contains details about raw extracts of campaign insights data.

Categ_Analysis

Item	Definition	Formula
`Avg1D_After_Revenue`	The daily average revenue on the campaign products after the campaign.	`total_after_revenue / (campaign end_date + 1 / (campaign end_date - campaign start_date)`
`Avg1D_After_Units`	The daily average units on the campaign products after the campaign.	`total_after_units / (campaign end_date + 1 / (campaign end_date - campaign start_date)`
`Avg1D_Before_Revenue`	The daily average revenue on the campaign products before the campaign.	n/a
`Avg1D_Before_Units`	The daily average units on the campaign products before the campaign.	n/a
`Avg1D_During_Revenue`	The daily average revenue on the campaign products during the campaign.	`total_during_revenue / (cron_job - campaign start_date)`
`Avg1D_During_Units`	The daily average units on the campaign products during the campaign.	`total_during_units / (cron_job - campaign start_date)`
`campaign_ID`	The Campaign ID as it appears in the platform URL.	n/a
`category`	The category name provided by the platform stack.	n/a
`category_3_id`	The Product campaign category, as registered in the retailer catalog.	n/a
`nb_product`	The total of campaign or non-campaign products.	n/a
`Percent_avg1D_Revenue_After`	The percentage of daily revenues that occurred in the After period.	`total_after_revenue / (total_before_revenue + total_during_revenue + total_after_revenue)`
`Percent_avg1D_Revenue_Before`	The percentage of daily revenues that occurred in the Before period.	`total_before_revenue / (total_before_revenue + total_during_revenue + total_after_revenue)`
`Percent_avg1D_Revenue_During`	The percentage of daily revenues that occurred in the During period.	`total_during_revenue / (total_before_revenue + total_during_revenue + total_after_revenue)`
`Percent_Revenue_After`	The After revenue as a percentage of the combined revenue from the Before, During, and After periods.	`total_after_revenue / (total_before_revenue + total_during_revenue + total_after_revenue)`
`Percent_Revenue_Before`	The Before revenue as a percentage of the combined revenue from the Before, During, and After periods.	`total_before_revenue / (total_before_revenue + total_during_revenue + total_after_revenue)`
`Percent_Revenue_During`	The During revenue as a percentage of the combined revenue from the Before, During, and After periods.	`total_during_revenue / (total_before_revenue + total_during_revenue + total_after_revenue)`
`Percent_Units_After`	The After units as a percentage of the combined units from the Before, During, and After periods.	`total_after_Units / (total_before_Units + total_during_Units + total_after_Units)`
`Percent_Units_avg1D_After`	The percentage of daily units that occurred in the After period.	`total_after_units / (total_before_units + total_during_units + total_after_units)`
`Percent_Units_avg1D_Before`	The percentage of daily units that occurred in the Before period.	`total_before_units / (total_before_units + total_during_units + total_after_units)`
`Percent_Units_avg1D_During`	The percentage of daily units that occurred in the During period.	`total_during_units / (total_before_units + total_during_units + total_after_units)`
`Percent_Units_Before`	The Before units as a percentage of the combined units from the Before, During, and After periods.	`total_before_Units / (total_before_Units + total_during_Units + total_after_Units)`
`Percent_Units_During`	The During units as a percentage of the combined units from the Before, During, and After periods.	`total_during_Units / (total_before_Units + total_during_Units + total_after_Units)`
`Product_Type`	The product type. Campaign products are set up in the campaign. Non-campaign products are other products associated with the same category in the retailer catalog.	n/a
`queryname`	The name of the report.	n/a
`Total_After_Revenue`	The total revenue registered for the campaign product IDs in the After period. Matches the campaign duration.	n/a
`Total_After_Units`	The total units registered for the campaign product IDs in the After period. Matches the campaign duration.	n/a
`Total_Before_Revenue`	The total revenue registered for the campaign product IDs in the Before period. The Before period starts with the first buy event on at least one campaign product, limited to four times the campaign duration.	n/a
`Total_Before_Units`	The total units registered for the campaign product IDs in the Before period. The Before period starts with the first buy event on at least one campaign product, limited to four times the campaign duration.	n/a
`Total_During_Revenue`	The total revenue registered for the campaign product IDs in the During period. Matches the campaign start and end dates.	n/a
`Total_During_Units`	The total units registered for the campaign product IDs in the During period. Matches the campaign start and end dates.	n/a

Daily deliv

Item	Definition
`campaign_id`	The campaign ID, as it appears in the platform URL.
`click`	The number of click tracking events. For more information, see Ad-centric trackers.
`page_type`	The page types where the event occurred, such as home, search, universe, category, product, or confirmation.
`queryname`	The name of the report.
`toDate(timestamp)`	The day when the event was tracked.
`total_spend`	The total budget spent on the `toDate(timestamp)`.

Exp_Buyers

Item	Definition
`campaign_id`	The campaign ID, as it appears in the platform URL.
`cnt`	The total of unique user IDs (attributed buyers), that were exposed to the campaign.
`queryname`	The name of the report.

Global delivery

Item	Definition
`campaign_id`	The campaign ID as it appears in the platform URL.
`click_zone`	The tracked click zone. For more information, see Ad-centric trackers.
`count()`	The number of events tracked.
`line_item_id`	The line item ID as it appears in the platform URL.
`queryname`	The name of the report.
`retailer`	The website where the line item displays.
`tracking_type`	The tracked event. For more information, see Ad-centric trackers.

ID analysis

Item	Definition
`after`	The total organic revenues registered for all campaign products for the After period. Matches the campaign duration.
`before`	Total organic revenues registered for all campaign products for the Before period. The Before period starts with the first buy event on at least one campaign product, limited to four times the campaign duration.
`campaign_id`	The campaign ID as it appears in the platform URL.
`during`	The total organic revenues registered for all campaign products for the During period. Matches the campaign start and end dates.
`queryname`	The name of the report.

KSP

Item	Definition
`average_cpc`	The average CPC price paid for the creative ID associated with the product. Formula: `spends/clicks`.
`campaign_budget`	The campaign budget set up in the platform.
`campaign_end_date`	The campaign end date set up in the platform.
`campaign_id`	The Campaign ID as it appears in the platform URL.
`campaign_name`	The Campaign ID set up in the platform.
`campaign_start_date`	The Campaign start date set up in the platform.
`clicks`	The number of clicks tracked for the creative ID associated with the product.
`creative_id`	The ID of the creative associated with the displayed product.
`cron_job_data`	The day the report was downloaded.
`format`	The line item format, such as totem, native, masthead, sword, or billboard.
`imps`	The number of impressions tracked for the creative ID associated with the product.
`line_item_budget`	The line item budget set up in the platform.
`line_item_id`	The line item ID as it appears in the platform URL.
`line_item_name`	The line item name set up in the platform.
`max_bid`	The maximum bid set up in the platform when the report was downloaded.
`page_type`	The page types where the event occurred, such as home, search, universe, category, product, or confirmation.
`product_id`	The product ID as reported in the retailer catalog.
`product_name`	The name of the product displayed in the creative as it appears in the retailer catalog.
`queryname`	The name of the report.
`spends`	The budget spent for the creative ID associated with the product.

NoExp_Buyers

Item	Definition
`campaign_id`	The campaign ID as it appears in the platform URL.
`cnt`	The total of unique user IDs (attributed buyers), that weren't exposed to the campaign.
`queryname`	The name of the report.

Recruitment

Item	Definition
`campaign_id`	The campaign ID as it appears in the platform URL.
`queryname`	The name of the report.
`recruited`	The total of unique users considered recruited because they bought a campaign product for the first time. These users were exposed to the campaign, received a view tracker and generated a buy event with a campaign product during the campaign and attribution window. The users didn't generate a buy event with any campaign product in the 90 days before the campaign start date.

Sales

Item	Definition
`campaign_id`	The campaign ID as it appears in the platform URL.
`product_id`	The product ID as reported in the retailer catalog.
`product_name`	The name of the product displayed in the creative as it appears in the retailer catalog.
`queryname`	The name of the report.
`revenue_click`	The sum of the attributed sales prices for the product ID that occurred after the user_id received a click tracker, within the window set in the platform.*
`revenue_noexp`	The sum of the attributed sales prices for the product ID that occurred after the user_id received a non-exposed tracker, within the window set in the platform.*
`revenue_view`	The sum of the attributed sales prices for the product ID that occurred after the user_id received a view tracker, within the window set in the platform.*
`total_qty_click`	The sum of the attributed sales in units for the product ID that occurred after the user_id received a click tracker, within the window set in the platform.*
`total_qty_noexp`	The sum of the attributed sales in units for the product ID that occurred after the user_id received a noexp tracker, within the window set in the platform.*
`total_qty_view`	The sum of the attributed sales in units for the product ID that occurred after the user_id received a view tracker, within the window set in the platform.*

* If you selected 0 days, the query registers all sales that occurred on the same day. All sales use a last view or last click methodology.

Table

Item	Definition
`brand_id`	The brand ID collected through the platform.
`brand_name`	The brand name as it appears in the retailer catalog.
`campaign_budget`	The campaign budget set up in the platform.
`campaign_end_date`	The campaign end date set up in the platform.
`campaign_id`	The campaign ID as it appears in the platform URL.
`campaign_name`	The campaign ID set up in the platform.
`campaign_start_date`	The campaign start date set up in the platform.
`clicks`	The total number of click trackers and `click_zone=product` for the line item ID. For more information, see Ad-centric trackers.
`format`	The platform format set up in the line item.
`imps`	The number of impressions.
`interactions`	The total number of click trackers for the line item ID. For more information, see Ad-centric trackers.
`line_item_id`	The line item ID as it appears in the platform URL.
`line_item_name`	The line item ID set up in the platform.
`page_type`	The Page types where the line item displays, such as home, search, universe, category, product, or confirmation.
`queryname`	The name of the report.
`retailer`	The website where the line item displays.
`sum(delivered_budget)`	The budget spent for the line item ID.
`sum(S0)`	The total number of video trackers and `st=0` for the line item ID. For more information, see Ad-centric trackers.
`sum(S100)`	The total number of video trackers and `st=100` for the line item ID. For more information, see Ad-centric trackers.
`sum(S25)`	The total number of video trackers and `st=25` for the line item ID. For more information, see Ad-centric trackers.
`sum(S50)`	The total number of video trackers and `st=50` for the line item ID. For more information, see Ad-centric trackers.
`sum(S75)`	The total number of video trackers and `st=75` for the line item ID. For more information, see Ad-centric trackers.
`views`	The total number of impression trackers for the line item ID. For more information, see Ad-centric trackers.

Top categ

Item	Definition
`campaign_id`	The campaign ID as it appears in the platform URL.
`category`	The category name provided by the platform stack.
`clicks`	The total clicks tracked on the specific page ID. For more information, see Ad-centric trackers.
`clicks_weight`	The share of clicks on the page ID. Formula: `clicks/total_clicks`
`impressions`	The total impressions tracked on the specific page ID. For more information, see Ad-centric trackers.
`impressions_weight`	The share of impressions on the page ID. Formula: `impressions/total_impressions`
`page_id`	The tracked page ID.
`page_type`	The page types where the line item displays, such as home, search, universe, category, product, or confirmation.
`queryname`	The name of the report.
`total_clicks`	The total clicks where `click_zone=product` was tracked on the category page type.
`total_impressions`	The total impressions tracked on the category page type.
`total_views`	The total views tracked on the category page type.
`views`	The total views tracked on the specific page ID. For more information, see Ad-centric trackers.
`views_weight`	The share of views on the page ID. Formula:`views/total_views`

Top keywords

Item	Definition
`campaign_id`	The campaign ID as it appears in the platform URL.
`clicks`	The total clicks tracked on the specific keyword. For more information, see Ad-centric trackers.
`clicks_weight`	The share of clicks on the keyword. Formula: `clicks/total_clicks`
`impressions`	The total impressions tracked on the specific keyword. For more information, see Ad-centric trackers.
`impressions_weight`	The share of impressions on the keyword. Formula: `impressions/total_impressions`
`keywords`	The tracked keyword.
`page_type`	The page types where the line item displays, such as home, search, universe, category, product, or confirmation.
`queryname`	The name of the report.
`total_clicks`	The total clicks where `click_zone=product` was tracked on the search page type.
`total_impressions`	The total impressions tracked on the search page type.
`total_views`	The total views tracked on the search page type.
`views`	The total views tracked on the specific keyword. For more information, see Ad-centric trackers.
`views_weight`	The share of views on the keyword. Formula: `views/total_views`

UV

Item	Definition
`campaign_id`	The campaign ID as it appears in the platform URL.
`queryname`	The name of the report.
`tracking_type`	The tracking event that defines the user status. View means the user was exposed. Noexp means the user was unexposed. For more information, see Ad-centric trackers.
`uniqExact(user_id)`	The number of unique tracked user IDs based on their tracking type (View or Noexp). For more information, see Ad-centric trackers.