Stackline: Most-used fields#
The table below gives information about most-used fields that you can import from Stackline. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
API name |
Adverity UI name |
Description |
Use in Adverity |
|---|---|---|---|
A-Plus Score |
A-Plus Score |
A score representing the quality and effectiveness of a product’s A+ Content (Enhanced Brand Content) on retail platforms. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
ASP |
ASP |
Average Selling Price: The average price at which a product was sold over a period. This is analogous to ‘Retail Price’. |
metric |
Ad Clicks |
Ad Clicks |
The number of clicks on a product’s paid advertisements. This is a key metric in ‘beacon-advertising’ reports and ‘ad analytics’. |
metric |
Ad Sales |
Ad Sales |
The total sales revenue directly attributed to paid advertising campaigns. This is a key metric in ‘beacon-advertising’ reports and ‘ad analytics’. |
metric |
Ad Spend |
Ad Spend |
The total amount spent on advertising for a product or brand. This is a key metric in ‘beacon-advertising’ reports and ‘ad analytics’. |
metric |
Ad Units Sold |
Ad Units Sold |
The number of product units sold that are directly attributed to paid advertising campaigns. This is a key metric in ‘beacon-advertising’ reports and ‘ad analytics’. |
metric |
AdCostOfSales |
AdCostOfSales |
The total cost of advertising directly attributable to generating sales. |
metric |
Availability Status |
Availability Status |
The current status of a product’s availability, indicating whether it is in stock, out of stock, or available for pre-order. |
dimension |
Availability Status Code |
Availability Status Code |
A numerical or categorical code representing the specific availability status of a product. |
dimension |
Brand |
Brand |
The name of the brand associated with a product or data point. |
dimension |
Brand Gross Margin |
Brand Gross Margin |
The total gross profit generated by a specific brand. |
metric |
Brand Gross Margin per Unit |
Brand Gross Margin per Unit |
The gross profit generated by a specific brand per unit sold. |
metric |
BrandId |
BrandId |
A unique identifier for a brand. |
metric |
BrandName |
BrandName |
The full name of the brand. |
dimension |
Bullet Score |
Bullet Score |
A score representing the quality and effectiveness of a product’s bullet points (key features) in its listing. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
Buy Box - Loss |
Buy Box - Loss |
Indicates instances or periods when a product lost the ‘Buy Box’ on a retail platform. |
metric |
Buy Box - Rate |
Buy Box - Rate |
The percentage of time a product wins the ‘Buy Box’ against competitors. This is a key metric in ‘beacon-buybox’ reports. |
metric |
Category |
Category |
The general category a product belongs to. |
dimension |
CategoryId |
CategoryId |
A unique identifier for a product category. |
metric |
CategoryMarketShare |
CategoryMarketShare |
The brand’s share of the total market within a specific product category. |
metric |
CategoryName |
CategoryName |
The name of the product category. |
dimension |
ClickThroughRate |
ClickThroughRate |
The percentage of impressions that result in a click. This is a key metric for advertising performance. |
metric |
Content Score |
Content Score |
An overall score evaluating the quality, completeness, and effectiveness of a product’s content (e.g., titles, images, descriptions). This is a key metric in ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
ConversionRate |
ConversionRate |
The percentage of website visitors or ad clicks that result in a desired action, such as a purchase. |
metric |
CostPerAcquisition |
CostPerAcquisition |
The average cost incurred to acquire a new customer or generate a new sale. |
metric |
CostPerClick |
CostPerClick |
The average cost incurred for each click on a paid advertisement. |
metric |
Image Score |
Image Score |
A score representing the quality and effectiveness of a product’s images in its listing. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
Impressions |
Impressions |
The number of times an advertisement or product listing was displayed to users. |
metric |
In-Stock Rate |
In-Stock Rate |
The percentage of time a product is available for purchase (in stock). |
metric |
Inventory Retail Value |
Inventory Retail Value |
The total retail value of all products currently in inventory. |
metric |
Model Number |
Model Number |
Unique identifier assigned to a specific product model, often used for inventory management and sales tracking. |
dimension |
Organic Traffic |
Organic Traffic |
The volume of non-paid traffic (e.g., clicks, views) to a product or brand page resulting from organic search engine results. This is a key metric in ‘atlas-traffic-keywords’ and ‘beacon-traffic-products’ reports. |
metric |
OrganicTraffic |
OrganicTraffic |
The volume of non-paid traffic (e.g., clicks, views) to a product or brand page resulting from organic search engine results. This is a key metric in ‘atlas-traffic-keywords’ and ‘beacon-traffic-products’ reports. |
metric |
OtherTraffic |
OtherTraffic |
Data related to website traffic, page views, or other consumer engagement metrics on retail sites, excluding specific categories like keyword or product traffic if those are tracked separately. |
metric |
PaidAdSpend |
PaidAdSpend |
The total amount of money spent on paid advertising campaigns. |
metric |
PaidTraffic |
PaidTraffic |
The volume of traffic (e.g., clicks, views) to a product or brand page generated by paid advertising efforts. This is a key metric in ‘atlas-traffic-keywords’ and ‘beacon-traffic-products’ reports. |
metric |
PromotionDate |
PromotionDate |
The date when a specific promotion was active or started. This is relevant for ‘atlas-promotions’ and ‘promotion analytics’ reports. |
dimension |
PromotionType |
PromotionType |
The type of promotion offered, such as a discount, deal, or other incentive. This is relevant for ‘atlas-promotions’ and ‘promotion analytics’ reports. |
dimension |
ROAS |
ROAS |
Return On Ad Spend: A metric that measures the effectiveness of advertising campaigns by calculating the revenue generated for every dollar spent on advertising. This is a key metric in ‘beacon-advertising’ reports and ‘ad analytics’. |
metric |
Retail Price |
Retail Price |
The selling price of a product to the end consumer. This is a key metric in ‘pricing analytics’ reports. |
dimension |
Retail Sales |
Retail Sales |
The total revenue generated from product sales to consumers through retail channels. This is a key metric in ‘atlas-sales’ and ‘beacon-sales’ reports. |
dimension |
RetailPrice |
RetailPrice |
The selling price of a product to the end consumer. This is a key metric in ‘pricing analytics’ reports. |
metric |
RetailPriceChange |
RetailPriceChange |
The change in a product’s retail price over a specified period. This is relevant for ‘pricing analytics’ reports. |
metric |
RetailSales |
RetailSales |
The total revenue generated from product sales to consumers through retail channels. This is a key metric in ‘atlas-sales’ and ‘beacon-sales’ reports. |
metric |
RetailSalesChange |
RetailSalesChange |
The change in total retail sales over a specified period. |
metric |
Retailer Gross Margin |
Retailer Gross Margin |
The total gross profit generated by the retailer from product sales. |
metric |
Retailer ID |
Retailer ID |
A unique identifier for the retailer where the product is sold. Stackline integrates with 18 major retailers (e.g., Amazon, Walmart, Target), identified by integer IDs (e.g., 1 for Amazon.com). |
dimension |
Retailer Margin per Unit |
Retailer Margin per Unit |
The profit margin earned by the retailer per unit sold. |
metric |
Retailer Name |
Retailer Name |
The name of the retailer selling the product (e.g., Amazon, Walmart, Target). |
dimension |
Retailer SKU |
Retailer SKU |
The Stock Keeping Unit (SKU) identifier assigned by the specific retailer for a product. |
dimension |
RetailerId |
RetailerId |
A unique identifier for the retailer where the product is sold. Stackline integrates with 18 major retailers (e.g., Amazon, Walmart, Target), identified by integer IDs (e.g., 1 for Amazon.com). |
metric |
RetailerName |
RetailerName |
The name of the retailer selling the product (e.g., Amazon, Walmart, Target). |
dimension |
RetailerSku |
RetailerSku |
The Stock Keeping Unit (SKU) identifier assigned by the specific retailer for a product. |
dimension |
Return Inventory Value |
Return Inventory Value |
The total value of inventory that has been returned by customers. |
metric |
Return Rate |
Return Rate |
The percentage of sold products that are returned by customers. |
metric |
Review Date |
Review Date |
The date when a customer review was submitted. This is relevant for ‘atlas-ratings-reviews’ and ‘beacon-ratings-reviews’ reports. |
dimension |
Review ID |
Review ID |
A unique identifier for a customer review. This is relevant for ‘atlas-ratings-reviews’ and ‘beacon-ratings-reviews’ reports. |
dimension |
Review Stars |
Review Stars |
The star rating (e.g., 1-5) given by a customer in a review. This is relevant for ‘atlas-ratings-reviews’ and ‘beacon-ratings-reviews’ reports. |
metric |
Review Text |
Review Text |
The textual content of a customer’s review. This is relevant for ‘atlas-ratings-reviews’ and ‘beacon-ratings-reviews’ reports. |
dimension |
Review Title |
Review Title |
The title provided by a customer for their review. This is relevant for ‘atlas-ratings-reviews’ and ‘beacon-ratings-reviews’ reports. |
dimension |
Reviewer |
Reviewer |
Information about the individual who submitted a product review or rating on e-commerce platforms. |
dimension |
Reviews Url |
Reviews Url |
The URL linking to the product’s reviews page on a retail website. This is relevant for ‘atlas-ratings-reviews’ and ‘beacon-ratings-reviews’ reports. |
dimension |
SalesPlatform |
SalesPlatform |
The e-commerce platform or retailer where sales activity is being tracked (e.g., Amazon, Walmart). |
dimension |
StacklineSku |
StacklineSku |
A unique Stock Keeping Unit (SKU) identifier assigned by Stackline to a product for tracking and analysis. |
dimension |
SubCategoryId |
SubCategoryId |
A unique identifier for a product sub-category. |
metric |
SubCategoryMarketShare |
SubCategoryMarketShare |
The brand’s share of the total market within a specific product sub-category. |
metric |
SubCategoryName |
SubCategoryName |
The name of the product sub-category. |
dimension |
SubTitle |
SubTitle |
The secondary title or subtitle of a product listing, often used for additional descriptive information. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
dimension |
Subcategory |
Subcategory |
The sub-category a product belongs to. |
dimension |
Title |
Title |
The main title of a product listing. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
dimension |
Title Score |
Title Score |
A score representing the quality and effectiveness of a product’s title in its listing. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
Total Traffic |
Total Traffic |
The aggregate volume of traffic (e.g., clicks, views) to a product or brand page, combining organic and paid sources. This is a key metric in ‘atlas-traffic-keywords’ and ‘beacon-traffic-products’ reports. |
metric |
TotalTraffic |
TotalTraffic |
The aggregate volume of traffic (e.g., clicks, views) to a product or brand page, combining organic and paid sources. This is a key metric in ‘atlas-traffic-keywords’ and ‘beacon-traffic-products’ reports. |
metric |
UPC |
UPC |
The Universal Product Code, a 12-digit barcode symbology that is widely used in the United States, Canada, the United Kingdom, Australia, New Zealand, and other countries for tracking trade items in stores. |
dimension |
Units Returned |
Units Returned |
The total number of product units returned by customers. |
metric |
Units Sold |
Units Sold |
The total number of individual product units sold over a specified period. This is a key metric in ‘atlas-sales’ and ‘beacon-sales’ reports. |
dimension |
Units on Hand |
Units on Hand |
The number of product units currently in inventory (on hand). |
metric |
UnitsSold |
UnitsSold |
The total number of individual product units sold over a specified period. This is a key metric in ‘atlas-sales’ and ‘beacon-sales’ reports. |
metric |
UnitsSoldChange |
UnitsSoldChange |
The change in the number of units sold over a specified period. |
metric |
Video Score |
Video Score |
A score representing the quality and effectiveness of a product’s videos in its listing. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
Week Ending |
Week Ending |
The end date of the week for which the data is reported. Stackline uses weekly periods (ISO YYYYWW format). |
dimension |
Week ID |
Week ID |
A unique identifier representing a specific ISO week for which data is collected. |
dimension |
Weeks On-Hand |
Weeks On-Hand |
A metric indicating how many weeks of sales can be covered by the current inventory levels. |
metric |
Wholesale Inventory Value |
Wholesale Inventory Value |
The total wholesale value of all products currently in inventory. |
metric |
Wholesale Price |
Wholesale Price |
The price at which a product is sold to retailers or distributors, rather than to the end consumer. |
metric |
Wholesale Sales |
Wholesale Sales |
The total revenue generated from product sales to retailers or distributors. |
metric |
aPlusScore |
aPlusScore |
A score representing the quality and effectiveness of a product’s A+ Content (Enhanced Brand Content) on retail platforms. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
adClicks |
adClicks |
The number of clicks on a product’s paid advertisements. This is a key metric in ‘beacon-advertising’ reports and ‘ad analytics’. |
metric |
adSpend |
adSpend |
The total amount spent on advertising for a product or brand. This is a key metric in ‘beacon-advertising’ reports and ‘ad analytics’. |
metric |
availabilityStatus |
availabilityStatus |
The current status of a product’s availability, indicating whether it is in stock, out of stock, or available for pre-order. |
dimension |
availabilityStatusCode |
availabilityStatusCode |
A numerical or categorical code representing the specific availability status of a product. |
dimension |
averageCostOfSales |
averageCostOfSales |
The average cost directly associated with the sale of products or services over a specified period. |
metric |
averageSellPrice |
averageSellPrice |
The average price at which a product was sold over a period. This is analogous to ‘Retail Price’. |
metric |
brandId |
brandId |
A unique identifier for a brand. |
metric |
brandid |
brandid |
A unique identifier for a brand. |
metric |
brandname |
brandname |
The full name of the brand. |
dimension |
bulletScore |
bulletScore |
A score representing the quality and effectiveness of a product’s bullet points (key features) in its listing. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
buyBoxWon |
buyBoxWon |
Indicates whether a product won the ‘Buy Box’ on a retail platform, meaning it was the primary option for purchase. This is a key metric in ‘beacon-buybox’ reports. |
metric |
campaignId |
campaignId |
A unique identifier for an advertising campaign. |
dimension |
campaignName |
campaignName |
The name of the advertising campaign. |
dimension |
campaignType |
campaignType |
The classification or category of an advertising campaign (e.g., Sponsored Products, Brand Ads). |
dimension |
clickThroughRate |
clickThroughRate |
The percentage of impressions that result in a click. This is a key metric for advertising performance. |
metric |
clicks |
clicks |
The total number of clicks on a product listing or advertisement. |
metric |
contentscore |
contentscore |
An overall score evaluating the quality, completeness, and effectiveness of a product’s content (e.g., titles, images, descriptions). This is a key metric in ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
conversionRate |
conversionRate |
The percentage of website visitors or ad clicks that result in a desired action, such as a purchase. |
metric |
costPerClick |
costPerClick |
The average cost incurred for each click on a paid advertisement. |
metric |
end_date_week |
end_date_week |
The end date of the week for which the data is reported. Stackline uses weekly periods (ISO YYYYWW format). |
dimension |
imageScore |
imageScore |
A score representing the quality and effectiveness of a product’s images in its listing. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
impressions |
impressions |
The number of times an advertisement or product listing was displayed to users. |
metric |
inStock |
inStock |
A boolean indicator specifying whether a product is currently available in inventory. |
metric |
isActive |
isActive |
A boolean indicator representing whether a product listing, campaign, or other entity is currently active. |
metric |
matchingType |
matchingType |
The keyword matching strategy used in advertising campaigns (e.g., exact, phrase, broad). |
dimension |
merchantId |
merchantId |
A unique identifier for the merchant or seller on an e-commerce platform. |
dimension |
merchantName |
merchantName |
The name of the merchant or seller on an e-commerce platform. |
dimension |
onHandRetailValue |
onHandRetailValue |
The total retail value of inventory currently available (on hand). |
metric |
onHandWholesaleValue |
onHandWholesaleValue |
The total wholesale value of inventory currently available (on hand). |
metric |
organicClicks |
organicClicks |
The number of clicks on a product listing that originated from organic search results. |
metric |
retailerMargin |
retailerMargin |
The profit margin earned by the retailer from the sale of a product. |
metric |
retailerMarginPercent |
retailerMarginPercent |
The retailer’s profit margin expressed as a percentage of the retail price. |
metric |
retailerid |
retailerid |
A unique identifier for the retailer where the product is sold. Stackline integrates with 18 major retailers (e.g., Amazon, Walmart, Target), identified by integer IDs (e.g., 1 for Amazon.com). |
metric |
retailername |
retailername |
The name of the retailer selling the product (e.g., Amazon, Walmart, Target). |
dimension |
retailersku |
retailersku |
The Stock Keeping Unit (SKU) identifier assigned by the specific retailer for a product. |
dimension |
retailprice |
retailprice |
The selling price of a product to the end consumer. This is a key metric in ‘pricing analytics’ reports. |
metric |
retailsales |
retailsales |
The total revenue generated from product sales to consumers through retail channels. This is a key metric in ‘atlas-sales’ and ‘beacon-sales’ reports. |
metric |
returnOnAdSpend |
returnOnAdSpend |
A metric that measures the effectiveness of advertising campaigns by calculating the revenue generated for every dollar spent on advertising. This is a key metric in ‘beacon-advertising’ reports and ‘ad analytics’. |
metric |
returnRate |
returnRate |
The percentage of sold products that are returned by customers. |
metric |
returnRetailValue |
returnRetailValue |
The total retail value of products that have been returned. |
metric |
reviewsCount |
reviewsCount |
The total number of customer reviews for a product. This is a key metric in ‘atlas-ratings-reviews’ and ‘beacon-ratings-reviews’ reports. |
metric |
reviewsaveragerating |
reviewsaveragerating |
The average star rating given by customers in their reviews for a product. This is a key metric in ‘atlas-ratings-reviews’ and ‘beacon-ratings-reviews’ reports. |
metric |
sales |
sales |
The total revenue generated from product sales. |
metric |
searchKeyword |
searchKeyword |
The specific keyword used by consumers in a search query. This is relevant for ‘atlas-traffic-keywords’ and ‘beacon-traffic-products’ reports. |
dimension |
searchTerm |
searchTerm |
The specific term or phrase consumers use when searching for products on retail sites. This is relevant for ‘atlas-traffic-keywords’ and ‘beacon-traffic-products’ reports. |
dimension |
searchterm |
searchterm |
The specific term or phrase consumers use when searching for products on retail sites. This field is used in ‘atlas-traffic-keywords’ and ‘beacon-traffic-products’ reports to analyze organic and paid search performance. |
dimension |
spend |
spend |
The total amount of money spent on advertising or other marketing activities. |
metric |
start_date_week |
start_date_week |
The start date of the week for which the data is reported. Stackline uses weekly periods (ISO YYYYWW format). |
dimension |
subTitle |
subTitle |
The secondary title or subtitle of a product listing, often used for additional descriptive information. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
dimension |
subtitle |
subtitle |
The secondary title or subtitle of a product listing, often used for additional descriptive information. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
dimension |
title |
title |
The main title of a product listing. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
dimension |
titleScore |
titleScore |
A score representing the quality and effectiveness of a product’s title in its listing. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
totalClicks |
totalClicks |
The aggregate number of clicks on a product listing or advertisement, combining both organic and paid clicks. |
metric |
unitsOnHand |
unitsOnHand |
The number of product units currently in inventory (on hand). |
metric |
unitsReturned |
unitsReturned |
The total number of product units returned by customers. |
metric |
unitsSold |
unitsSold |
The total number of individual product units sold over a specified period. This is a key metric in ‘atlas-sales’ and ‘beacon-sales’ reports. |
metric |
unitssold |
unitssold |
The total number of individual product units sold over a specified period. This is a key metric in ‘atlas-sales’ and ‘beacon-sales’ reports. |
metric |
upc |
upc |
The Universal Product Code, a 12-digit barcode symbology that is widely used in the United States, Canada, the United Kingdom, Australia, New Zealand, and other countries for tracking trade items in stores. |
metric |
videoScore |
videoScore |
A score representing the quality and effectiveness of a product’s videos in its listing. This is relevant for ‘atlas-content-score’ and ‘beacon-content-score’ reports. |
metric |
weekId |
weekId |
A unique identifier representing a specific ISO week for which data is collected. |
metric |
weeksOnHand |
weeksOnHand |
A metric indicating how many weeks of sales can be covered by the current inventory levels. |
metric |
wholesaleprice |
wholesaleprice |
The price at which a product is sold to retailers or distributors, rather than to the end consumer. |
metric |
wholesalesales |
wholesalesales |
The total revenue generated from product sales to retailers or distributors. |
metric |
winPercentage |
winPercentage |
The percentage of time a product wins the ‘Buy Box’ against competitors. This is a key metric in ‘beacon-buybox’ reports. |
metric |