Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Columns that are shown by default

Period

  • The period to show data.

  • Depends on the selected Interval. (Month/Year/Day)

Orders (New)

  • The number of orders from new customer (purchase for the first order during the period) during this row of period during the selected report period.

Grand Total (New)

  • The total Grand Total of all orders purchased by new customers during this row report period.

  • Grand Total = Subtotal + Tax - Discount + Shipping.

  • The currency will follow the Base Currency of the magento site.

Revenue (New)

  • The total revenue excluding the tax of all orders of new customer during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • Revenue (incl. Tax) = Total Paid - Total Refunded - Tax - Shipping.

Avg. Order Value (New)

  • The average order value of new customer during this row report period.

  • Value = Total / Number of Orders

  • The currency will follow the Base Currency of the magento site.

Orders (Returning)

  • The number of orders from returning customers (the first order purchased in the period is not the first order) during this row of period during the selected report period.

Grand Total (Returning)

  • The total Grand Total of all orders purchased by returning customers during this row report period.

  • Grand Total = Subtotal + Tax - Discount + Shipping.

  • The currency will follow the Base Currency of the magento site.

Revenue (Returning)

  • The total revenue excluding the tax of all orders during of this customer/customer group during the selected report period.

  • The currency will follow the Base Currency of the magento site.

  • Revenue (incl. Tax) = Total Paid - Total Refunded - Tax - Shipping.

Avg. Order Value (Returning)

  • The average order value of returning customer during this row report period.

  • Value = Total / Number of Orders

  • The currency will follow the Base Currency of the magento site.

Columns that are hidden by default

% of Grand Total (New)

  • Value = Grand Total of new customer / Grand Total of all customers * 100%.

  • This column is hidden by default.

% of Total Revenue (New)

  • Value = Revenue of new customer / Total Revenue of all customers * 100%.

  • This column is hidden by default.

% of Grand Total (Returning)

  • Value = Grand Total of returning customer / Grand Total of all customers * 100%.

  • This column is hidden by default.

% of Total Revenue (Returning)

  • Value = Revenue of returning customer / Total Revenue of all customers * 100%.

  • This column is hidden by default.

II/ Filter Report Data

There will be no filter in this report.

...