Pricing Analysis Field Names

Created by Support Administrator, Modified on Fri, 6 Jun at 5:00 PM by Support Administrator

Field Name	Type (Store)	Description
product_name	Text	Name of the product.
product_sku	Text	Stock Keeping Unit (internal ID).
promo_status	Text	Promotion status of the product.
price	Decimal	Current product price.
brand	Text	Brand name.
category	Text	Product category.
sub_category	Text	Sub-category under main category.
gtin	Text	Global Trade Item Number.
mpn	Text	Manufacturer Part Number.
item_id	Text	Unique product identifier.
item_group_id	Text	Group ID for variants.
your_cost	Decimal	Your cost to acquire the product.
stock_qty	Whole Number	Units currently in stock.
minimal_retail	Decimal	Minimum retail price allowed.
visibility	Text	Visibility setting (e.g., public, hidden).
product_url	Text	Product page URL.
item_viewed_30	Whole Number	Views in last 30 days.
item_viewed_90	Whole Number	Views in last 90 days.
item_purchased_30	Whole Number	Purchases in last 30 days.
item_purchased_90	Whole Number	Purchases in last 90 days.
revenue_30	Decimal	Revenue in last 30 days.
revenue_90	Decimal	Revenue in last 90 days.
buy_detail_30	Decimal	Purchase/view rate (30 days).
buy_detail_90	Decimal	Purchase/view rate (90 days).
add_to_card_30	Whole Number	Add-to-cart actions (30 days).
add_to_card_90	Whole Number	Add-to-cart actions (90 days).
label1	Text	Custom label 1.
label2	Text	Custom label 2.
marketing_note	Text	Notes related to marketing.
cost_ads	Decimal	Ad spend amount.
impressions	Whole Number	Number of ad impressions.
clicks	Whole Number	Number of ad clicks.
CTR	Decimal	Click-through rate.
CPC	Decimal	Cost per click.
all_conversions	Decimal	All types of conversions.
all_conversions_rates	Decimal	Rate of all conversions.
all_conversions_values	Decimal	Value of all conversions.
conversions	Decimal	Standard conversions.
total_conversions_value	Decimal	Value from all conversions.
value_per_conversion	Decimal	Avg. value per conversion.
conversions_rate	Decimal	Conversion rate.
ROAS	Decimal	Return on ad spend.
CPM	Decimal	Cost per 1000 impressions.
your_price_vs	Decimal	Your price vs competitor.
most_competitive_price	Decimal	Market’s lowest competitor price.
nb_competitors	Whole Number	Number of competitors.
most_competitive	Text	Whether your price is most competitive.
avg_price	Decimal	Market average price.
day_since	Whole Number	Days since a key event.
Google_ID	Text	Product ID used in Google Ads.
Stock_status	Text	Stock availability.
cart_to_view_30_days	Decimal	Cart/view ratio (30 days).
check_out_30_days	Whole Number	Checkouts in last 30 days.
cart_to_view_90_days	Decimal	Cart/view ratio (90 days).
check_out_90_days	Whole Number	Checkouts in last 90 days.
last_update_date	Text (Date format)	Last update timestamp.
promo_price	Decimal	Promotional price.
offline_purchases	Decimal	Offline purchases.
offline_revenue	Decimal	Offline revenue.
offline_qty	Decimal	Quantity sold offline.
offline_stock_value	Decimal	Offline inventory value.
offline_stock_status	Text	Offline stock status.
offline_notes	Text	Offline product notes.
offline_profit	Decimal	Profit from offline sales.
featured	Text	Featured item status.
condition_product	Text	Product condition (e.g., new, used).
description	Text	Product description.
image_url	Text	Image URL.
was_price	Decimal	Previous product price.
difference	Decimal	Price difference amount.
decrease	Decimal	Decrease in price.
decreasepercent	Decimal	Percentage of price decrease.
profit	Whole Number	Profit earned.
margin	Decimal	Profit margin.
markup	Decimal	Markup over cost.
stock_value	Whole Number	Total value of stock.
added	Text	Date or user that added item.
source_medium	Text	Campaign source and medium.
campaign_name	Text	Name of the ad campaign.
competitor_name	Text	Competitor being compared.