Stackline: Most-used fields

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