Payment Gateway Costs

payment_gateway_costs

Overview

Payment Gateway Costs refer to the costs and fees charged by the payment gateway provider for processing transactions (not including currency conversion fees).

📘

Payment Gateway Costs = Total amount of payment gateway costs to seller

The calculation is based on data from the Orders table.

---

Detailed Breakdown

The formula above is derived from the following components:

• Payment Gateway Costs = sum(payment_gateway_costs) --> Orders table

Insights and Actions

Payment Gateway Costs represent the fees charged by payment gateway providers for processing transactions, offering insights into a key operational expense:

• Monitor Transaction Costs: Regularly review payment gateway costs to identify trends or increases in fees that may affect your profitability.
• Compare Gateway Providers: Use cost data to evaluate and negotiate better rates with payment gateway providers or consider switching to a more cost-effective provider.
• Optimize Payment Options: Analyze these costs in relation to transaction volume and value to ensure the most efficient payment methods are being offered to customers.

Related Metrics

• Order Revenue: Helps contextualize payment gateway costs as a percentage of total revenue, providing a clearer view of their impact on profitability.
• Shipping Costs: Offers insights into other operational expenses, enabling a holistic view of transaction-related costs.
• Net Profit: Tracks overall profitability, helping assess the impact of payment gateway costs on your bottom line.

Example Use

Prompt

What were my payment gateway fees yesterday?

Response

Query

SQL

SELECT
  SUM(ot.payment_gateway_costs) AS total_payment_gateway_fees
FROM
  orders_table AS ot
WHERE
  ot.event_date = CURRENT_DATE() - 1;