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 |
metric |
|
30clicks |
30clicks |
metric |
|
30costs |
30costs |
dimension |
|
30revenue |
30revenue |
metric |
|
365articlesSold |
365articlesSold |
metric |
|
365clicks |
365clicks |
metric |
|
365costs |
365costs |
dimension |
|
365revenue |
365revenue |
dimension |
|
90articlesSold |
90articlesSold |
metric |
|
90clicks |
90clicks |
metric |
|
90costs |
90costs |
dimension |
|
90revenue |
90revenue |
metric |
|
Action ID |
Action ID |
dimension |
|
ActionID |
ActionID |
dimension |
|
Date |
Date |
Date |
dimension |
ID |
ID |
dimension |
|
IMPRESSIONS |
IMPRESSIONS |
metric |
|
Master ID |
Master ID |
dimension |
|
MasterID |
MasterID |
dimension |
|
Portal Name |
Portal Name |
dimension |
|
Sale-Price |
Sale-Price |
dimension |
|
Shop Name |
Shop Name |
Name of the shop |
dimension |
Standard_Publisher |
Standard_Publisher |
dimension |
|
Standard_Shop_Name |
Standard_Shop_Name |
dimension |
|
Week |
Week |
metric |
|
action id |
action id |
dimension |
|
art_name |
art_name |
dimension |
|
articleTitle |
articleTitle |
dimension |
|
articlesSold |
articlesSold |
Actual number of articles sold |
metric |
brand |
brand |
dimension |
|
category |
category |
The category of the product |
dimension |
clicks |
clicks |
Number of clicks on the ad |
metric |
clothing_size |
clothing_size |
dimension |
|
color |
color |
dimension |
|
conversions |
conversions |
metric |
|
costs |
costs |
Amount spent in advertising |
metric |
currency |
currency |
dimension |
|
date |
date |
dimension |
|
deep_link |
deep_link |
dimension |
|
delivery_costs |
delivery_costs |
dimension |
|
delivery_time |
delivery_time |
dimension |
|
ean |
ean |
dimension |
|
filename |
filename |
dimension |
|
gender_age |
gender_age |
dimension |
|
id |
id |
Id of the shop |
dimension |
image_url |
image_url |
dimension |
|
keywords |
keywords |
dimension |
|
long_description |
long_description |
dimension |
|
margin |
margin |
Calculated by subtracting costs to revenues. Equivalent to profit. |
metric |
masterArticleId |
masterArticleId |
Article ID |
metric |
material |
material |
dimension |
|
month |
month |
dimension |
|
old_price |
old_price |
dimension |
|
orders |
orders |
Number of orders made by clients. It is similar to a conversion. |
metric |
parentSku |
parentSku |
A parent sku is used when you have different variations of the same product. It is another level of identification above SKU. |
metric |
price |
price |
dimension |
|
product_type |
product_type |
dimension |
|
publisher |
publisher |
dimension |
|
reference_price |
reference_price |
dimension |
|
reference_unit |
reference_unit |
dimension |
|
revenue |
revenue |
Revenue generated |
metric |
shop |
shop |
dimension |
|
sku |
sku |
Number assigned to a product to identify the price, product options and manufacturer of the merchandise. A unique identifier. Similar to a product ID |
metric |
source publisher |
source publisher |
dimension |
|
title |
title |
title |
dimension |