Salesforce Commerce Cloud

Salesforce Commerce Cloud#

The table below gives information about all the data fields that you can import from Salesforce Commerce Cloud.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs. As a result, the fields shown here may not be the same as the fields available in Adverity. If you notice a difference between this documentation and the fields you see in Adverity, please contact your Adverity account manager for more information.

To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.

Field UI name

Field API name

Use in Adverity

adjusted_merchandize_total_tax

adjusted_merchandize_total_tax

metric

adjusted_shipping_total_tax

adjusted_shipping_total_tax

metric

billing_address._type

billing_address._type

dimension

billing_address.address1

billing_address.address1

dimension

billing_address.address2

billing_address.address2

dimension

billing_address.city

billing_address.city

dimension

billing_address.country_code

billing_address.country_code

dimension

billing_address.first_name

billing_address.first_name

dimension

billing_address.full_name

billing_address.full_name

dimension

billing_address.id

billing_address.id

dimension

billing_address.last_name

billing_address.last_name

dimension

billing_address.phone

billing_address.phone

metric

billing_address.postal_code

billing_address.postal_code

dimension

billing_address.state_code

billing_address.state_code

dimension

c_authReversal

c_authReversal

dimension

c_csStatus

c_csStatus

metric

c_isBillingHasStoreAddress

c_isBillingHasStoreAddress

dimension

c_narvarExportOrder

c_narvarExportOrder

dimension

c_narvarFailedExportAttempts

c_narvarFailedExportAttempts

metric

c_narvarOrderAPILastCall

c_narvarOrderAPILastCall

dimension

c_nodeID

c_nodeID

metric

c_orderConfirmationSent

c_orderConfirmationSent

dimension

c_orderCreatedInNarvar

c_orderCreatedInNarvar

dimension

c_orderType

c_orderType

dimension

c_sendShipStatusToNarvar

c_sendShipStatusToNarvar

dimension

c_siteID

c_siteID

dimension

c_storeNo

c_storeNo

metric

channel_type

channel_type

dimension

confirmation_status

confirmation_status

dimension

created_by

created_by

dimension

creation_date

creation_date

dimension

creation_date_date

creation_date_date

dimension

currency

currency

dimension

customer_info._type

customer_info._type

dimension

customer_info.customer_id

customer_info.customer_id

dimension

customer_info.customer_name

customer_info.customer_name

dimension

customer_info.email

customer_info.email

dimension

customer_name

customer_name

dimension

export_status

export_status

dimension

guest

guest

dimension

last_modified

last_modified

dimension

last_modified_date

last_modified_date

dimension

merchandize_total_tax

merchandize_total_tax

metric

order_no

order_no

dimension

order_token

order_token

dimension

order_total

order_total

metric

payment_status

payment_status

dimension

product_sub_total

product_sub_total

metric

product_total

product_total

metric

shipping_status

shipping_status

dimension

shipping_total

shipping_total

metric

shipping_total_tax

shipping_total_tax

metric

site_id

site_id

dimension

status

status

dimension

tax_rounded_at_group

tax_rounded_at_group

dimension

tax_total

tax_total

metric

taxation

taxation

dimension