Store Metrics
Title |
Type |
Data Source |
Description |
---|---|---|---|
Total Sales*** |
formula |
Shopify |
Total Sales = Net Sales + Taxes + Shipping - Returns - Discounts |
Gross Sales*** |
formula |
Shopify |
Gross Sales = Product Price × Quantity |
Net Sales*** |
formula |
Shopify |
Net Sales = Gross Sales - Discounts - Returns |
Total Conversions |
imported |
Shopify |
Total conversions = Number of orders placed |
Average Order Value (AOV) |
imported |
Shopify |
AOV = Total Sales / Number of Orders |
Returns % |
formula |
Shopify |
Returns % = Refund Value / Gross Sales x 100 |
***Shopify records returns on the date of the original order; ProfitPeak's formula counts returns on the date they are processed.
Store Performance
Title |
Type |
Data Source |
Description |
---|---|---|---|
Gross Profit |
formula |
Shopify |
Gross Profit = Net Sales - Product Cost
|
Gross Margin |
formula |
Shopify |
Gross Margin = Gross Profit / Gross Sales x 100 |
Contribution Profit |
formula |
Shopify, ProfitPeak's Expense Table, Advertising Platforms |
Contribution Profit = Gross Profit - Variable Cost - Advertising Spend |
Net Profit |
formula |
Shopify, ProfitPeak's Expense Table, Advertising Platforms |
Net Profit = Contribution Profit - Fixed Expenses |
Net Margin |
formula |
Shopify, ProfitPeak's Expense Table, Advertising Platforms |
Net Margin = Net Profit / Net Sales x 100 |
New Customer Performance
Title |
Type |
Data Source |
Description |
---|---|---|---|
Total New Customers |
formula |
ProfitPeak |
Total New Customers = Total Customers - Returning Customers** |
Total New Customers from Ads* |
formula |
ProfitPeak |
Total New Customers from Ads = Total New Customers with Ad Clicks |
New Customer Cost Per Acquisition* |
formula |
ProfitPeak, Advertising Platforms |
New Customer Cost Per Acquisition = Total Blended Advertising Spend / Total New Customers |
New Customer ROAS* |
formula |
ProfitPeak, Advertising Platforms |
NCROAS = Total Revenue Derived From Advertising to New Customers ÷ Total Blended Advertising Spend |
Ads Profit from New Customers* |
formula |
Shopify, ProfitPeak, Advertising Platforms |
Gross Profit = Net Sales from New Customers - Product Cost |
New Customer Gross Profit on Ad Spend* |
formula |
Shopify, ProfitPeak, Advertising Platforms |
New Customer PROAS= Gross Profit From New Customers with Advertising ÷ Total Blended Advertising Spend |
*A new customer is defined as having not shopped with you over the last 2 years.
**Returning customers are defined as having shopped with you over the last 2 years
Returning Customer Performance
Title |
Type |
Data Source |
Description |
---|---|---|---|
Total Returning Customers** |
formula |
ProfitPeak |
Total Returning Customers = Total Customers - New Customers* |
Total Returning Customers from Ads** |
formula |
ProfitPeak |
Total Returning Customers from Ads = Total Return Customers with Ad Clicks |
Returning Customer ROAS** |
formula |
ProfitPeak, Advertising Platforms |
Returning Customer ROAS = Net Sales Derived From Advertising to Returning Customers ÷ Total Blended Advertising Spend |
Ads Profit from Returning Customers** |
formula |
Shopify, ProfitPeak, Advertising Platforms |
Gross Profit = Net Sales from Returning Customers - Product Cost |
Returning Customer Gross Profit on Ad Spend |
formula |
Shopify, ProfitPeak, Advertising Platforms |
Returning Customer PROAS = Gross Profit From Returning Customers with Advertising ÷ Total Blended Advertising Spend |
*A new customer is defined as having not shopped with you over the last 2 years.
**Returning customers are defined as having shopped with you over the last 2 years
Advertising Efficiency
Title |
Type |
Data Source |
Description |
---|---|---|---|
ROAS |
formula |
Shopify, ProfitPeak, Advertising Platforms |
Net Sales Derived From Advertising / Total Blended Advertising Spend
|
PROAS |
formula |
Shopify, ProfitPeak, Advertising Platforms |
Gross Profit Derived From Advertising Spend / Total Blended Advertising Spend |
NPROAS (Net Profit on Ad Spend) |
formula |
Shopify, ProfitPeak, Advertising Platforms |
Net Profit Derived From Advertising Spend / Total Blended Advertising Spend
|
MER |
formula |
Shopify |
Net Sales / Total Blended Advertising Spend |
Advertising Performance
Title |
Type |
Data Source |
Description |
---|---|---|---|
Net Sales from Ads |
formula |
Shopify, ProfitPeak |
Net Sales from Ads = Gross Sales with Ad Clicks - Discounts - Returns
|
Blended Ads Spend |
formula |
Advertising Platforms |
Total Blended Advertising Spend |
Net Profit From Ads |
formula |
Shopify, ProfitPeak, Advertising Platforms |
Net Profit Derived From Advertising Spend
|
Net Margin From Ads |
formula |
Shopify, ProfitPeak, Advertising Platforms |
Net Profit Derived from Advertising Spend / Net Sales |
Blended Total Clicks |
formula |
ProfitPeak |
Total Advertising Platform Clicks |
Blended Conversions |
formula |
ProfitPeak |
Total Conversions Derived from Advertising Spend |