Pricing Analysis Field Names

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

Field NameType (Store)Description
product_nameTextName of the product.
product_skuTextStock Keeping Unit (internal ID).
promo_statusTextPromotion status of the product.
priceDecimalCurrent product price.
brandTextBrand name.
categoryTextProduct category.
sub_categoryTextSub-category under main category.
gtinTextGlobal Trade Item Number.
mpnTextManufacturer Part Number.
item_idTextUnique product identifier.
item_group_idTextGroup ID for variants.
your_costDecimalYour cost to acquire the product.
stock_qtyWhole NumberUnits currently in stock.
minimal_retailDecimalMinimum retail price allowed.
visibilityTextVisibility setting (e.g., public, hidden).
product_urlTextProduct page URL.
item_viewed_30Whole NumberViews in last 30 days.
item_viewed_90Whole NumberViews in last 90 days.
item_purchased_30Whole NumberPurchases in last 30 days.
item_purchased_90Whole NumberPurchases in last 90 days.
revenue_30DecimalRevenue in last 30 days.
revenue_90DecimalRevenue in last 90 days.
buy_detail_30DecimalPurchase/view rate (30 days).
buy_detail_90DecimalPurchase/view rate (90 days).
add_to_card_30Whole NumberAdd-to-cart actions (30 days).
add_to_card_90Whole NumberAdd-to-cart actions (90 days).
label1TextCustom label 1.
label2TextCustom label 2.
marketing_noteTextNotes related to marketing.
cost_adsDecimalAd spend amount.
impressionsWhole NumberNumber of ad impressions.
clicksWhole NumberNumber of ad clicks.
CTRDecimalClick-through rate.
CPCDecimalCost per click.
all_conversionsDecimalAll types of conversions.
all_conversions_ratesDecimalRate of all conversions.
all_conversions_valuesDecimalValue of all conversions.
conversionsDecimalStandard conversions.
total_conversions_valueDecimalValue from all conversions.
value_per_conversionDecimalAvg. value per conversion.
conversions_rateDecimalConversion rate.
ROASDecimalReturn on ad spend.
CPMDecimalCost per 1000 impressions.
your_price_vsDecimalYour price vs competitor.
most_competitive_priceDecimalMarket’s lowest competitor price.
nb_competitorsWhole NumberNumber of competitors.
most_competitiveTextWhether your price is most competitive.
avg_priceDecimalMarket average price.
day_sinceWhole NumberDays since a key event.
Google_IDTextProduct ID used in Google Ads.
Stock_statusTextStock availability.
cart_to_view_30_daysDecimalCart/view ratio (30 days).
check_out_30_daysWhole NumberCheckouts in last 30 days.
cart_to_view_90_daysDecimalCart/view ratio (90 days).
check_out_90_daysWhole NumberCheckouts in last 90 days.
last_update_dateText (Date format)Last update timestamp.
promo_priceDecimalPromotional price.
offline_purchasesDecimalOffline purchases.
offline_revenueDecimalOffline revenue.
offline_qtyDecimalQuantity sold offline.
offline_stock_valueDecimalOffline inventory value.
offline_stock_statusTextOffline stock status.
offline_notesTextOffline product notes.
offline_profitDecimalProfit from offline sales.
featuredTextFeatured item status.
condition_productTextProduct condition (e.g., new, used).
descriptionTextProduct description.
image_urlTextImage URL.
was_priceDecimalPrevious product price.
differenceDecimalPrice difference amount.
decreaseDecimalDecrease in price.
decreasepercentDecimalPercentage of price decrease.
profitWhole NumberProfit earned.
marginDecimalProfit margin.
markupDecimalMarkup over cost.
stock_valueWhole NumberTotal value of stock.
addedTextDate or user that added item.
source_mediumTextCampaign source and medium.
campaign_nameTextName of the ad campaign.
competitor_nameTextCompetitor being compared.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article