ChannelPilot: Most-used fields

The table below gives information about most-used fields that you can import from ChannelPilot. 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
30articlesSold	30articlesSold	The total number of articles or products sold within the last 30 days, reflecting recent sales performance.	metric
30clicks	30clicks	The total number of clicks on product listings or marketing advertisements within the last 30 days. This metric is used to evaluate marketing channel performance.	metric
30costs	30costs	The aggregated costs associated with marketing campaigns or product listings within the last 30 days.	dimension
30revenue	30revenue	The total revenue generated from sales within the last 30 days. This is a key performance indicator for sales and marketing effectiveness.	metric
365articlesSold	365articlesSold	The number of distinct articles (products) sold within the last 365 days. This metric provides a long-term view of product sales performance.	metric
365clicks	365clicks	The total number of clicks on product listings or marketing advertisements within the last 365 days, indicating long-term user engagement.	metric
365costs	365costs	The aggregated costs associated with marketing campaigns or product listings within the last 365 days.	dimension
365revenue	365revenue	The total revenue generated from sales within the last 365 days, offering a comprehensive view of annual sales performance.	dimension
90articlesSold	90articlesSold	The number of distinct articles (products) sold within the last 90 days. This metric is useful for quarterly performance reviews.	metric
90clicks	90clicks	The total number of clicks on product listings or marketing advertisements within the last 90 days.	metric
90costs	90costs	The aggregated costs associated with marketing campaigns or product listings within the last 90 days.	dimension
90revenue	90revenue	The total revenue generated from sales within the last 90 days, providing insights into short-to-medium term sales trends.	metric
Action ID	Action ID	A unique identifier assigned to a specific action or event, such as a user interaction or a system-generated activity, typically found in raw analytics data.	dimension
ActionID	ActionID	A unique identifier assigned to a specific action or event, such as a user interaction or a system-generated activity, typically found in raw analytics data.	dimension
Date	Date	The specific date associated with an event or data record.	dimension
ID	ID	A generic unique identifier for a record or entity.	dimension
IMPRESSIONS	IMPRESSIONS	The total number of times an advertisement or product listing was displayed to users.	metric
Master ID	Master ID	A primary, central identifier used to uniquely reference a key entity (e.g., product, order, or customer) across various data sets within the platform.	dimension
MasterID	MasterID	A primary, central identifier used to uniquely reference a key entity (e.g., product, order, or customer) across various data sets within the platform.	dimension
Portal Name	Portal Name	The name of the specific online portal, marketplace, or sales channel through which products are marketed or sold.	dimension
Sale-Price	Sale-Price	The discounted or promotional price of a product during a sale event.	dimension
Shop Name	Shop Name	The name of the online shop or merchant associated with the product data.	dimension
Standard_Publisher	Standard_Publisher	The name of the entity or platform responsible for publishing or distributing product data to various channels.	dimension
Standard_Shop_Name	Standard_Shop_Name	The standardized name of the online shop or merchant associated with the collected data.	dimension
Week	Week	The calendar week number for which the reported data is aggregated or filtered.	metric
action id	action id	A unique identifier assigned to a specific action or event, such as a user interaction or a system-generated activity, typically found in raw analytics data.	dimension
art_name	art_name	The name or title of the article or product being referenced.	dimension
articleTitle	articleTitle	The title of an article or product, as displayed to customers.	dimension
articlesSold	articlesSold	The total number of individual articles or products sold.	metric
brand	brand	The brand name of the product.	dimension
category	category	The product category or classification.	dimension
clicks	clicks	The total number of clicks received on a product listing or advertisement.	metric
clothing_size	clothing_size	The size attribute for clothing products.	dimension
color	color	The color attribute of the product.	dimension
conversions	conversions	The number of successful desired actions (e.g., purchases, sign-ups) resulting from marketing efforts.	metric
costs	costs	The total costs associated with marketing campaigns or product operations.	metric
currency	currency	The currency code used for pricing and financial data.	dimension
date	date	The specific date associated with an event or data record.	dimension
deep_link	deep_link	A URL that directs users to a specific product page or content within an application or website.	dimension
delivery_costs	delivery_costs	The cost charged for delivering the product to the customer.	dimension
delivery_time	delivery_time	The estimated time required for product delivery.	dimension
ean	ean	The European Article Number (EAN), a unique identifier for products.	dimension
filename	filename	The name of the file, typically a product data feed, from which the information was imported into the system.	dimension
gender_age	gender_age	The target gender and/or age group for which the product is intended.	dimension
id	id	A generic unique identifier for a record or entity.	dimension
image_url	image_url	The URL of the main image for the product.	dimension
keywords	keywords	Keywords associated with the product for search engine optimization and ad targeting.	dimension
long_description	long_description	A detailed and extended description of the product.	dimension
margin	margin	The profit margin earned on a product or sale.	metric
masterArticleId	masterArticleId	A unique identifier for the main or master version of a product or article, often used for product variations.	metric
material	material	The material composition of the product.	dimension
month	month	The calendar month for which the reported data is aggregated or filtered.	dimension
old_price	old_price	The original price of a product before any discounts or sales.	dimension
orders	orders	The total number of orders placed by customers.	metric
parentSku	parentSku	The Stock Keeping Unit (SKU) that identifies the parent product for items with variations.	metric
price	price	The current selling price of the product.	dimension
product_type	product_type	The classification or type of the product.	dimension
publisher	publisher	The name of the platform or channel publishing product data or advertisements.	dimension
reference_price	reference_price	A comparative price point for a product, used for benchmarking or dynamic pricing strategies.	dimension
reference_unit	reference_unit	The unit of measurement associated with a product’s reference price or quantity.	dimension
revenue	revenue	The total sales revenue generated from product sales.	metric
shop	shop	The name of the online shop or merchant.	dimension
sku	sku	The Stock Keeping Unit (SKU), a unique identifier for a specific product variation.	metric
source publisher	source publisher	The entity or platform that originally provided or published the product data.	dimension
title	title	The title of the product or article.	dimension