TikTok Shop: Most-used fields

TikTok Shop: Most-used fields#

The table below gives information about most-used fields that you can import from TikTok Shop. 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

actual_return_shipping_fee_amount

actual_return_shipping_fee_amount

The actual shipping fee amount for a returned item.

metric

actual_shipping_fee_amount

actual_shipping_fee_amount

The actual shipping fee amount for an item.

metric

adjustment_amount

adjustment_amount

The amount of any adjustments made.

metric

affiliate_ads_commission_amount

affiliate_ads_commission_amount

The commission amount earned from affiliate advertisements.

metric

affiliate_commission_amount

affiliate_commission_amount

The total commission amount earned by affiliates.

metric

affiliate_commission_before_pit

affiliate_commission_before_pit

The affiliate commission amount calculated before the deduction of personal income tax.

metric

affiliate_partner_commission_amount

affiliate_partner_commission_amount

The commission amount earned by affiliate partners.

metric

after_seller_discounts_subtotal_amount

after_seller_discounts_subtotal_amount

The subtotal amount after applying seller discounts.

metric

amount.currency

amount.currency

The currency of the transaction amount.

dimension

amount.value

amount.value

The numerical value of the transaction amount.

dimension

bank_account

bank_account

Bank account details associated with the transaction.

dimension

child_title

child_title

The title of the child product variation.

dimension

cost_of_goods_sold

cost_of_goods_sold

The direct costs attributable to the production of the goods sold.

metric

create_time

create_time

The timestamp when the record was created.

dimension

create_time_date

create_time_date

The date when the record was created.

dimension

currency

currency

The currency code relevant to the transaction or record.

dimension

customer_order_refund_amount

customer_order_refund_amount

The total refund amount issued to the customer for an order.

metric

customer_paid_shipping_fee_amount

customer_paid_shipping_fee_amount

The amount of shipping fee paid by the customer.

metric

customer_paid_shipping_fee_refund_amount

customer_paid_shipping_fee_refund_amount

The refund amount for the shipping fee paid by the customer.

metric

customer_payment_amount

customer_payment_amount

The total amount paid by the customer.

metric

customer_refund_amount

customer_refund_amount

The total refund amount provided to the customer.

metric

customer_shipping_fee_amount

customer_shipping_fee_amount

The total shipping fee amount applicable to the customer.

metric

customer_shipping_fee_offset_amount

customer_shipping_fee_offset_amount

The offset amount applied to the customer’s shipping fee.

metric

exchange_rate

exchange_rate

The exchange rate used for currency conversion.

dimension

fbm_shipping_cost_amount

fbm_shipping_cost_amount

The shipping cost amount for items fulfilled by the merchant (FBM).

metric

fbt_fulfillment_fee_amount

fbt_fulfillment_fee_amount

The fulfillment fee amount for items fulfilled by TikTok (FBT).

metric

fbt_shipping_cost_amount

fbt_shipping_cost_amount

The shipping cost amount for items fulfilled by TikTok (FBT).

metric

fee_amount

fee_amount

The amount of fees charged for a transaction.

metric

gross_sales

gross_sales

The total sales revenue before any deductions.

metric

gross_sales_amount

gross_sales_amount

The total gross sales amount before any deductions.

metric

gross_sales_refund_amount

gross_sales_refund_amount

The total refund amount deducted from gross sales.

metric

id

id

A unique identifier for the record.

dimension

line_items.cancel_reason

line_items.cancel_reason

The reason provided for the cancellation of a specific line item within an order.

dimension

line_items.cancel_user

line_items.cancel_user

The user who initiated the cancellation of a specific line item.

dimension

line_items.currency

line_items.currency

The currency in which the line item prices are denominated.

dimension

line_items.display_status

line_items.display_status

dimension

line_items.id

line_items.id

A unique identifier for the individual line item.

metric

line_items.is_gift

line_items.is_gift

Indicates whether the line item is marked as a gift.

dimension

line_items.original_price

line_items.original_price

The original price of the line item before any discounts or promotions.

metric

line_items.package_status

line_items.package_status

The current status of the package associated with this line item.

dimension

line_items.platform_discount

line_items.platform_discount

The discount amount applied to the line item by the platform.

metric

line_items.product_id

line_items.product_id

A unique identifier for the product associated with the line item.

dimension

line_items.product_name

line_items.product_name

The name of the product in the line item.

dimension

line_items.retail_delivery_fee

line_items.retail_delivery_fee

metric

line_items.rts_time

line_items.rts_time

The Ready-To-Ship (RTS) time for the line item.

dimension

line_items.sale_price

line_items.sale_price

The final sale price of the line item after all discounts.

metric

line_items.seller_discount

line_items.seller_discount

The discount amount applied to the line item by the seller.

metric

line_items.seller_sku

line_items.seller_sku

The Stock Keeping Unit (SKU) identifier assigned by the seller for the product.

dimension

line_items.shipping_provider_id

line_items.shipping_provider_id

A unique identifier for the shipping provider handling this line item.

dimension

line_items.shipping_provider_name

line_items.shipping_provider_name

The name of the shipping provider handling this line item.

dimension

line_items.sku_id

line_items.sku_id

A unique identifier for the SKU of the product in the line item.

dimension

line_items.sku_image

line_items.sku_image

The URL or identifier for the image of the SKU.

dimension

line_items.sku_name

line_items.sku_name

The name of the SKU in the line item.

dimension

line_items.sku_type

line_items.sku_type

The type of the SKU (e.g., physical, digital).

dimension

line_items.tracking_number

line_items.tracking_number

The tracking number for the shipment associated with the line item.

dimension

master_title

master_title

The main title of the product or product group.

dimension

net_sales

net_sales

The total sales revenue after deducting returns, allowances, and discounts.

metric

net_sales_amount

net_sales_amount

The total net sales amount after all deductions.

metric

order_amount

order_amount

The total monetary amount of the order.

metric

order_create_time

order_create_time

The timestamp when the order was created.

dimension

order_create_time_date

order_create_time_date

The date when the order was created.

dimension

order_id

order_id

A unique identifier for the order.

dimension

orders.buyer_email

orders.buyer_email

The email address of the buyer who placed the order.

dimension

orders.buyer_message

orders.buyer_message

Any message or special instructions provided by the buyer for the order.

dimension

orders.cancel_order_sla_time

orders.cancel_order_sla_time

The Service Level Agreement (SLA) time for order cancellation.

dimension

orders.cancel_reason

orders.cancel_reason

The reason provided for the cancellation of the order.

dimension

orders.cancel_time

orders.cancel_time

The timestamp when the order was cancelled.

dimension

orders.cancellation_initiator

orders.cancellation_initiator

The entity (e.g., buyer, seller, platform) that initiated the order cancellation.

dimension

orders.collection_due_time

orders.collection_due_time

The due time for the collection of the order.

dimension

orders.collection_time

orders.collection_time

The actual time when the order was collected.

dimension

orders.commerce_platform

orders.commerce_platform

dimension

orders.create_time

orders.create_time

The timestamp when the order was created.

dimension

orders.create_time_date

orders.create_time_date

The date when the order was created.

dimension

orders.delivery_option_id

orders.delivery_option_id

A unique identifier for the selected delivery option.

dimension

orders.delivery_option_name

orders.delivery_option_name

The name of the selected delivery option.

dimension

orders.delivery_sla_time

orders.delivery_sla_time

The Service Level Agreement (SLA) time for order delivery.

dimension

orders.delivery_time

orders.delivery_time

The actual time when the order was delivered.

dimension

orders.delivery_type

orders.delivery_type

The type of delivery selected for the order.

dimension

orders.fulfillment_type

orders.fulfillment_type

The method of fulfillment for the order (e.g., shipped by seller, fulfilled by TikTok).

dimension

orders.id

orders.id

A unique identifier for the order.

metric

orders.is_cod

orders.is_cod

Indicates if the order is Cash On Delivery (COD).

dimension

orders.is_on_hold_order

orders.is_on_hold_order

Indicates if the order is currently on hold.

dimension

orders.is_replacement_order

orders.is_replacement_order

dimension

orders.order_type

orders.order_type

The type of order (e.g., standard, return).

dimension

orders.packages

orders.packages

Details about the packages associated with the order.

dimension

orders.paid_time

orders.paid_time

The timestamp when the order was paid.

dimension

orders.payment_card_type

orders.payment_card_type

The type of payment card used for the order.

dimension

orders.payment_method_code

orders.payment_method_code

The code for the payment method used for the order.

dimension

orders.payment_method_name

orders.payment_method_name

The name of the payment method used for the order.

dimension

orders.pick_up_cut_off_time

orders.pick_up_cut_off_time

The cut-off time for picking up the order.

dimension

orders.replaced_order_id

orders.replaced_order_id

dimension

orders.rts_sla_time

orders.rts_sla_time

The Service Level Agreement (SLA) time for the order to be Ready-To-Ship.

dimension

orders.rts_time

orders.rts_time

The actual time when the order was marked as Ready-To-Ship (RTS).

dimension

orders.shipping_provider

orders.shipping_provider

The name of the shipping provider for the order.

dimension

orders.shipping_provider_id

orders.shipping_provider_id

A unique identifier for the shipping provider handling the order.

dimension

orders.shipping_type

orders.shipping_type

The type of shipping selected for the order.

dimension

orders.status

orders.status

The current status of the order (e.g., PENDING, SHIPPED, DELIVERED).

dimension

orders.tracking_number

orders.tracking_number

The tracking number for the order’s shipment.

dimension

orders.tts_sla_time

orders.tts_sla_time

The Service Level Agreement (SLA) time for the order to be delivered.

dimension

orders.update_time

orders.update_time

The timestamp when the order was last updated.

dimension

orders.update_time_date

orders.update_time_date

The date when the order was last updated.

dimension

orders.user_id

orders.user_id

A unique identifier for the user who placed the order.

dimension

orders.warehouse_id

orders.warehouse_id

A unique identifier for the warehouse from which the order is shipped.

dimension

package.create_time

package.create_time

The timestamp when the package was created.

dimension

package.delivery_option_id

package.delivery_option_id

A unique identifier for the delivery option selected for the package.

dimension

package.delivery_option_name

package.delivery_option_name

The name of the delivery option selected for the package.

dimension

package.has_multi_skus

package.has_multi_skus

dimension

package.last_mile_tracking_number

package.last_mile_tracking_number

dimension

package.order_line_item_ids

package.order_line_item_ids

A list of order line item identifiers included in this package.

dimension

package.orders

package.orders

Details about the orders associated with this package.

dimension

package.package_id

package.package_id

A unique identifier for the package.

dimension

package.package_status

package.package_status

The current status of the package.

dimension

package.recipient_address.address_detail

package.recipient_address.address_detail

Additional details for the recipient’s address for the package.

dimension

package.recipient_address.address_line1

package.recipient_address.address_line1

The first line of the recipient’s address for the package.

dimension

package.recipient_address.address_line2

package.recipient_address.address_line2

The second line of the recipient’s address for the package.

dimension

package.recipient_address.address_line3

package.recipient_address.address_line3

The third line of the recipient’s address for the package.

dimension

package.recipient_address.address_line4

package.recipient_address.address_line4

The fourth line of the recipient’s address for the package.

dimension

package.recipient_address.full_address

package.recipient_address.full_address

The complete formatted address of the package recipient.

dimension

package.recipient_address.name

package.recipient_address.name

The name of the recipient for the package.

dimension

package.recipient_address.phone_number

package.recipient_address.phone_number

The phone number of the recipient for the package.

dimension

package.recipient_address.postal_code

package.recipient_address.postal_code

The postal code of the recipient’s address for the package.

dimension

package.recipient_address.region_code

package.recipient_address.region_code

The region code (e.g., country code) of the recipient’s address for the package.

dimension

package.sender_address.address_detail

package.sender_address.address_detail

Additional details for the sender’s address for the package.

dimension

package.sender_address.address_line1

package.sender_address.address_line1

The first line of the sender’s address for the package.

dimension

package.sender_address.address_line2

package.sender_address.address_line2

The second line of the sender’s address for the package.

dimension

package.sender_address.address_line3

package.sender_address.address_line3

The third line of the sender’s address for the package.

dimension

package.sender_address.address_line4

package.sender_address.address_line4

The fourth line of the sender’s address for the package.

dimension

package.sender_address.full_address

package.sender_address.full_address

The complete formatted address of the package sender.

dimension

package.sender_address.name

package.sender_address.name

The name of the sender for the package.

dimension

package.sender_address.phone_number

package.sender_address.phone_number

The phone number of the sender for the package.

dimension

package.sender_address.postal_code

package.sender_address.postal_code

The postal code of the sender’s address for the package.

dimension

package.sender_address.region_code

package.sender_address.region_code

The region code (e.g., country code) of the sender’s address for the package.

dimension

package.shipping_provider_id

package.shipping_provider_id

A unique identifier for the shipping provider handling this package.

dimension

package.shipping_provider_name

package.shipping_provider_name

The name of the shipping provider handling this package.

dimension

package.shipping_type

package.shipping_type

The type of shipping used for the package.

dimension

package.tracking_number

package.tracking_number

The tracking number for the package’s shipment.

dimension

package.update_time

package.update_time

The timestamp when the package details were last updated.

dimension

paid_time

paid_time

The timestamp when the payment was made.

dimension

paid_time_date

paid_time_date

The date when the payment was made.

dimension

payment.buyer_service_fee

payment.buyer_service_fee

The service fee charged to the buyer as part of the payment.

dimension

payment.currency

payment.currency

The currency used for the payment.

dimension

payment.handling_fee

payment.handling_fee

The fee incurred for handling the payment.

dimension

payment.item_insurance_fee

payment.item_insurance_fee

The fee for insuring individual items within an order.

dimension

payment.original_shipping_fee

payment.original_shipping_fee

The original shipping fee charged for the order.

metric

payment.original_total_product_price

payment.original_total_product_price

The original total price of all products in the order before any discounts.

metric

payment.platform_discount

payment.platform_discount

The discount amount applied to the payment by the platform.

metric

payment.product_tax

payment.product_tax

The tax amount applied to the products in the payment.

metric

payment.retail_delivery_fee

payment.retail_delivery_fee

The retail delivery fee included in the payment.

metric

payment.seller_discount

payment.seller_discount

The discount amount applied to the payment by the seller.

metric

payment.shipping_fee

payment.shipping_fee

The shipping fee charged for the order.

metric

payment.shipping_fee_cofunded_discount

payment.shipping_fee_cofunded_discount

The shipping fee discount amount co-funded by multiple parties.

metric

payment.shipping_fee_platform_discount

payment.shipping_fee_platform_discount

The platform’s discount applied to the shipping fee.

metric

payment.shipping_fee_seller_discount

payment.shipping_fee_seller_discount

The seller’s discount applied to the shipping fee.

metric

payment.shipping_fee_tax

payment.shipping_fee_tax

The tax amount applied to the shipping fee.

metric

payment.shipping_insurance_fee

payment.shipping_insurance_fee

The fee for insuring the shipping of an order.

dimension

payment.small_order_fee

payment.small_order_fee

A fee applied to orders that do not meet a certain minimum value.

dimension

payment.sub_total

payment.sub_total

The subtotal amount of the payment before taxes and shipping fees.

metric

payment.tax

payment.tax

The total tax amount applied to the payment.

metric

payment.total_amount

payment.total_amount

The total amount of the payment.

metric

payment_amount_before_exchange.currency

payment_amount_before_exchange.currency

The currency of the payment amount before any exchange rate is applied.

dimension

payment_amount_before_exchange.value

payment_amount_before_exchange.value

The numeric value of the payment amount before any currency exchange.

dimension

payment_id

payment_id

A unique identifier for the payment.

dimension

payment_method_name

payment_method_name

The name of the payment method used for the transaction, such as ‘Credit Card’ or ‘PayPal’.

dimension

payment_status

payment_status

The current status of the payment.

dimension

pit_amount

pit_amount

The amount of Personal Income Tax (PIT) applicable to the transaction.

metric

platform_commission_amount

platform_commission_amount

The commission amount charged by the TikTok Shop platform for the transaction.

metric

platform_discount_amount

platform_discount_amount

The total discount amount provided by the platform.

metric

platform_discount_refund_amount

platform_discount_refund_amount

The amount of discount refunded by the platform.

metric

platform_refund_subsidy_amount

platform_refund_subsidy_amount

The subsidy amount provided by the platform for a refund.

metric

platform_shipping_fee_discount_amount

platform_shipping_fee_discount_amount

The discount amount applied by the platform to the shipping fee.

metric

product_name

product_name

The name of the product.

dimension

profit_margin

profit_margin

The percentage of revenue that exceeds costs.

metric

promo_shipping_incentive_amount

promo_shipping_incentive_amount

The incentive amount related to promotional shipping offers.

metric

quantity

quantity

The number of items in the order or line item.

metric

recipient_address.address_detail

recipient_address.address_detail

Additional details for the recipient’s address.

dimension

recipient_address.address_line1

recipient_address.address_line1

The first line of the recipient’s address.

dimension

recipient_address.address_line2

recipient_address.address_line2

The second line of the recipient’s address.

dimension

recipient_address.address_line3

recipient_address.address_line3

The third line of the recipient’s address.

dimension

recipient_address.address_line4

recipient_address.address_line4

The fourth line of the recipient’s address.

dimension

recipient_address.district_info

recipient_address.district_info

Information about the district of the recipient’s address.

dimension

recipient_address.first_name

recipient_address.first_name

The first name of the recipient.

dimension

recipient_address.first_name_local_script

recipient_address.first_name_local_script

The first name of the recipient in local script.

dimension

recipient_address.full_address

recipient_address.full_address

The complete formatted address of the recipient.

dimension

recipient_address.last_name

recipient_address.last_name

The last name of the recipient.

dimension

recipient_address.last_name_local_script

recipient_address.last_name_local_script

The last name of the recipient in local script.

dimension

recipient_address.name

recipient_address.name

The full name of the recipient.

dimension

recipient_address.phone_number

recipient_address.phone_number

The phone number of the recipient.

dimension

recipient_address.post_town

recipient_address.post_town

The post town of the recipient’s address.

dimension

recipient_address.postal_code

recipient_address.postal_code

The postal code of the recipient’s address.

dimension

recipient_address.region_code

recipient_address.region_code

The region code (e.g., country code) of the recipient’s address.

dimension

referral_fee_amount

referral_fee_amount

The fee paid for a referral that led to a sale.

metric

refund_administration_fee_amount

refund_administration_fee_amount

The administrative fee incurred for processing a refund.

metric

refund_amount

refund_amount

The total monetary amount refunded for an order or item.

metric

refund_amount.currency

refund_amount.currency

The currency of the refund amount.

dimension

refund_amount.refund_shipping_fee

refund_amount.refund_shipping_fee

The portion of the refund corresponding to the shipping fee.

metric

refund_amount.refund_subtotal

refund_amount.refund_subtotal

The subtotal amount of the refund, excluding tax and shipping.

metric

refund_amount.refund_tax

refund_amount.refund_tax

The tax amount included in the refund.

metric

refund_amount.refund_total

refund_amount.refund_total

The total amount of the refund, including subtotal, tax, and shipping.

metric

refund_shipping_cost_discount_amount

refund_shipping_cost_discount_amount

The discounted amount of shipping cost applied to a refund.

metric

reserve_amount.currency

reserve_amount.currency

The currency of the reserved amount.

dimension

reserve_amount.value

reserve_amount.value

The numeric value of the amount held in reserve.

dimension

retail_delivery_fee_amount

retail_delivery_fee_amount

The fee charged for retail delivery.

metric

retail_delivery_fee_payment_amount

retail_delivery_fee_payment_amount

The amount paid for the retail delivery fee.

metric

retail_delivery_fee_refund_amount

retail_delivery_fee_refund_amount

The refunded amount of the retail delivery fee.

metric

return_line_items.order_line_item_id

return_line_items.order_line_item_id

The identifier for the original order line item associated with the returned item.

dimension

return_line_items.product_image.height

return_line_items.product_image.height

The height of the product image for the returned item.

metric

return_line_items.product_image.url

return_line_items.product_image.url

The URL of the product image for the returned item.

dimension

return_line_items.product_image.width

return_line_items.product_image.width

The width of the product image for the returned item.

metric

return_line_items.product_name

return_line_items.product_name

The name of the product that was returned.

dimension

return_line_items.refund_amount.currency

return_line_items.refund_amount.currency

The currency of the refund amount for this specific returned line item.

dimension

return_line_items.refund_amount.refund_shipping_fee

return_line_items.refund_amount.refund_shipping_fee

The shipping fee portion of the refund for this returned line item.

metric

return_line_items.refund_amount.refund_subtotal

return_line_items.refund_amount.refund_subtotal

The subtotal amount of the refund for this returned line item, excluding tax and shipping.

metric

return_line_items.refund_amount.refund_tax

return_line_items.refund_amount.refund_tax

The tax amount included in the refund for this returned line item.

metric

return_line_items.refund_amount.refund_total

return_line_items.refund_amount.refund_total

The total refund amount for this returned line item, including subtotal, tax, and shipping.

metric

return_line_items.return_line_item_id

return_line_items.return_line_item_id

A unique identifier for the specific line item within a return.

dimension

return_line_items.seller_sku

return_line_items.seller_sku

The Seller SKU (Stock Keeping Unit) for the returned item.

dimension

return_line_items.sku_id

return_line_items.sku_id

The unique identifier for the SKU (Stock Keeping Unit) of the returned product.

dimension

return_line_items.sku_name

return_line_items.sku_name

The name of the SKU (Stock Keeping Unit) for the returned product.

dimension

return_orders.arbitration_status

return_orders.arbitration_status

The current status of arbitration for the return order.

dimension

return_orders.can_buyer_keep_item

return_orders.can_buyer_keep_item

Indicates whether the buyer is allowed to keep the item even after a refund.

dimension

return_orders.combined_return_id

return_orders.combined_return_id

The identifier for a combined return order, if multiple returns are grouped.

dimension

return_orders.create_time

return_orders.create_time

The timestamp when the return order was created.

dimension

return_orders.create_time_date

return_orders.create_time_date

The date when the return order was created.

dimension

return_orders.discount_amount

return_orders.discount_amount

The total discount amount applied to the return order.

dimension

return_orders.handover_method

return_orders.handover_method

The method used for handing over the returned item, e.g., ‘Pickup’, ‘Drop-off’.

dimension

return_orders.is_combined_return

return_orders.is_combined_return

A boolean indicating if this return order is part of a combined return.

dimension

return_orders.next_return_id

return_orders.next_return_id

The ID of the subsequent return order in a sequence, if applicable.

dimension

return_orders.order_id

return_orders.order_id

The identifier of the original order associated with this return.

dimension

return_orders.pre_return_id

return_orders.pre_return_id

The ID of the previous return order in a sequence, if applicable.

dimension

return_orders.return_id

return_orders.return_id

A unique identifier for the return order.

dimension

return_orders.return_method

return_orders.return_method

The method specified for the return, such as ‘Refund Only’ or ‘Return and Refund’.

dimension

return_orders.return_provider_id

return_orders.return_provider_id

The identifier of the service provider handling the return process.

dimension

return_orders.return_provider_name

return_orders.return_provider_name

The name of the service provider handling the return process.

dimension

return_orders.return_reason

return_orders.return_reason

The coded reason for the return, e.g., ‘DEFECTIVE_ITEM’, ‘WRONG_SIZE’.

dimension

return_orders.return_reason_text

return_orders.return_reason_text

A descriptive text explaining the reason for the return.

dimension

return_orders.return_status

return_orders.return_status

The current status of the return order, such as ‘Pending Approval’, ‘Item Received’, ‘Refunded’.

dimension

return_orders.return_tracking_number

return_orders.return_tracking_number

The tracking number for the shipment of the returned item.

dimension

return_orders.return_type

return_orders.return_type

The type of return, e.g., ‘Full Refund’, ‘Partial Refund’, ‘Exchange’.

dimension

return_orders.role

return_orders.role

The role associated with the return order, such as ‘Seller’ or ‘Buyer’.

dimension

return_orders.seller_next_action_response

return_orders.seller_next_action_response

The seller’s response regarding the next action to be taken for the return.

dimension

return_orders.shipment_type

return_orders.shipment_type

The type of shipment for the return, e.g., ‘Standard’, ‘Express’.

dimension

return_orders.shipping_fee_amount

return_orders.shipping_fee_amount

The shipping fee amount associated with the return order.

dimension

return_orders.update_time

return_orders.update_time

The timestamp when the return order record was last updated.

dimension

return_orders.update_time_date

return_orders.update_time_date

The date when the return order record was last updated.

dimension

return_shipping_fee_amount

return_shipping_fee_amount

The fee associated with shipping an item back for a return.

metric

return_warehouse_address.full_address

return_warehouse_address.full_address

The complete address of the warehouse where returned items are sent.

dimension

revenue_amount

revenue_amount

The total revenue generated.

metric

sales_tax_amount

sales_tax_amount

The amount of sales tax applied to the transaction.

metric

sales_tax_payment_amount

sales_tax_payment_amount

The amount of sales tax paid for the transaction.

metric

sales_tax_refund_amount

sales_tax_refund_amount

The refunded amount of sales tax.

metric

seller_discount_amount

seller_discount_amount

The total discount amount provided by the seller.

metric

seller_discount_refund_amount

seller_discount_refund_amount

The refund amount specifically for seller-provided discounts.

metric

settlement_amount

settlement_amount

The amount of money settled to the seller.

metric

settlement_amount.currency

settlement_amount.currency

The currency of the settlement amount.

dimension

settlement_amount.value

settlement_amount.value

The numerical value of the settlement amount.

dimension

shipping_cost_amount

shipping_cost_amount

The total cost associated with shipping the order.

metric

shipping_cost_discount_amount

shipping_cost_discount_amount

The discount amount applied to the shipping cost.

metric

shipping_fee_amount

shipping_fee_amount

The fee charged for shipping the items.

metric

shipping_fee_subsidy_amount

shipping_fee_subsidy_amount

The subsidy amount provided for the shipping fee.

metric

shipping_insurance_fee_amount

shipping_insurance_fee_amount

The amount paid for shipping insurance.

metric

signature_confirmation_fee_amount

signature_confirmation_fee_amount

The fee for requiring a signature upon delivery confirmation.

metric

sku

sku

The Stock Keeping Unit (SKU) identifier for a product.

dimension

sku_id

sku_id

A unique identifier for the Stock Keeping Unit (SKU).

dimension

sku_name

sku_name

The name of the Stock Keeping Unit (SKU).

dimension

sku_sales_amount

sku_sales_amount

The total sales amount for a specific SKU.

metric

sku_transactions.product_name

sku_transactions.product_name

The name of the product involved in the SKU transaction.

dimension

sku_transactions.sku_id

sku_transactions.sku_id

A unique identifier for the SKU involved in the SKU transaction.

dimension

sku_transactions.sku_name

sku_transactions.sku_name

The name of the SKU involved in the SKU transaction.

dimension

sku_transactions.statement_id

sku_transactions.statement_id

A unique identifier for the financial statement associated with the SKU transaction.

dimension

statement_id

statement_id

A unique identifier for the financial statement.

dimension

statement_time

statement_time

The timestamp when the financial statement was generated.

dimension

statement_time_date

statement_time_date

The date when the financial statement was generated.

dimension

status

status

The current status of the record or entity.

dimension

transaction_fee_amount

transaction_fee_amount

The fee charged for processing the transaction.

metric

transaction_id

transaction_id

A unique identifier for the transaction.

dimension

update_time

update_time

The timestamp when the record was last updated.

dimension

update_time_date

update_time_date

The date when the record was last updated.

dimension