Monthly Detailed E-commerce Report Template

Monthly Detailed E-commerce Report | Reportz

Our detailed version of E-commerce dashboards contains a much longer list of metrics and KPIs, therefore providing a thorough, all-inclusive insight into E-commerce data. This type of E-Commerce report template is tailored to be used by agencies and those who need a bird’s eye view of the E-commerce data.  

This template contains the following 4 sets of KPIs and widgets:

Note: A detailed explanation of each widget and KPI is available through jump links. Simply click on each KPI set below and jump directly onto the explanation for that particular set of widgets.

  • Google Analytics KPIs by Month
    → Revenue by Month
    → Transactions by Month
    → Average Order Value by Month
    → E-commerce Conversion Rate by Month
  • Facebook KPIs by Month
    → Facebook Purchases & Cost per Purchase by Month
    → Facebook Spend & Purchase Value by Month
    → Facebook Purchase ROAS by Month
    → Facebook ROI by Month
    → Facebook KPIs by Month
  • Google Ads KPIs by Month
    → Google Ads All Conversions & Cost per All Conversions by Month
    → Google Ads Spend & Purchase Value by Month
    → Google Ads ROAS by Month
    → Google Ads ROI by Month
    → Google Ads KPIs by Month
  • Shopping Behavior & Top Selling Products from Google Analytics
    → Top Selling Products
    → Shopping Behavior
    → Shopping Behavior (Percentage)
    → Shopping Behavior per Product
    → KPIs by Device Category
    → KPIs by User Type
    → KPIs by Gender
    → Users by Gender
    → Revenue by Gender
    → KPIs by Age Group
    → Users by Age
    → Revenue by Age
    → KPIs by Country
    → KPIs by City
    → KPIs by Channel
    → Users by Channel
    → Revenue by Channel
    → KPIs by Source/Medium
    → KPIs by Campaign
    → Coupon Performance Report

Now, let’s cover each KPI widget within these data sets. 

E-commerce KPI Widgets Explained

Widgets Explained | Reportz

Google Analytics KPIs by Month/Day

→ Revenue by Month/Day

Shows total monthly or daily revenue of all the transactions made on your website.

Revenue by Month/Day | Reportz

→ Transactions by Month/Day

Displays data on how your E-commerce sales are performing.

Transactions by Month/Day | Reportz

→ Average Order Value by Month/Day

Not all purchases are worth the same – but you can still gain valuable insight into how much an individual transaction (on average) contributed to your total monthly or daily revenue by observing this graph.

Average Order Value by Month/Day | Reportz

→ E-commerce Conversion Rate by Month/Day

E-commerce Conversion Rate informs you of how many transactions were made per session – expressed by percentage.

Pro Tip: If this rate is very low, that might indicate poor website’s user experience or wrong audience targeting.

 

E-commerce Conversion Rate by Month/Day | Reportz

Facebook KPIs by Month

→ Facebook Purchases & Cost per Purchase by Month/Day

The Facebook Purchases metric counts purchase events tracked by your Facebook Business Tool that attributed to your ads. Cost per Purchase shows the average cost of each purchase and is calculated as the total amount spent divided by purchases.

Facebook Purchases & Cost per Purchase by Month/Day | Reportz

→ Facebook Spend & Purchase Value by Month/Day

Facebook Spend shows the estimated total amount of money you’ve spent on your campaign, ad set or ad during its schedule. Purchase Value displays the total value of purchases tracked with the conversion objective. This KPI is calculated by adding the value parameters you set for the purchase conversion standard event.

Facebook Spend & Purchase Value by Month/Day | Reportz

→ Facebook Purchase ROAS by Month/Day

This widget shows the total return on ad spend (ROAS) from website purchases. This metric is based on the value of all conversions recorded by the Facebook pixel on your website and attributed to your ads. It is calculated as the website purchases conversion value divided by the total amount spent.

Facebook Purchase ROAS by Month/Day | Reportz

→ Facebook ROI by Month/Day

Shows your Facebook Ads ROI (Return on Investment). This is a custom metric calculated as: 

((total purchase value – total amount spent) / total amount spent)*100 

It shows how many dollars you’ve gained for each dollar spent on your Facebook Ads, expressed as a percentage.

Facebook ROI by Month/Day | Reportz

→ Facebook Ads KPIs by Month/Day

Displays all of your Fb Ads KPIs in one place.

Facebook Ads KPIs by Month/Day | Reportz

Google Ads KPIs by Month/Day

→ Google Ads All Conversions & Cost per All Conversions by Month/Day

This widget displays all conversions (“All conv.”) i.e. the total number of conversions that Google Ads measures for each conversion action. “All conv.” includes data from your “Conversions” column, plus additional data, such as conversions that have their “Include in ‘Conversions’” setting unticked.

Cost per all conversions (Cost/all conv.) shows the average cost of conversion included in the “All conversions” column. It’s your total cost divided by “All conv.”

If you track multiple conversion actions, your overall cost/all conv. may be lower than the cost/all conv. for each action. The cost in this metric only includes ad interactions that could lead to conversions.

Google Ads All Conversions & Cost per All Conversions by Month/Day | Reportz

→ Google Ads Spend & Purchase Value by Month

Spend – the total amount of money you’ve spent on your campaigns.

Purchase Value – the sum of all conversion values for all conversions.

Google Ads Spend & Purchase Value by Month | Reportz

→ Google Ads ROAS by Month

ROAS, or Return on Ad Spend, shows the average conversion value you receive in return for every dollar you spend on your Google ads. It is calculated via this formula:

Return on Ad Spend = Revenue / Ad Spend x 100

 

→ Google Ads KPIs by Month/Day

See all of your Google Ads KPIs in one place using this comprehensive table widget.

 

Shopping Behavior & Top Selling Products from Google Analytics

→ Top Selling Products

This widget displays the data on the products that sell best and make up the most of your revenue (and which don’t).

Pro Tip: You should use this information to adjust your online advertising tactics.

 

Top Selling Products | Reportz

→ Shopping Behavior

Visualizations of the overall funnel activity of users through a site’s E-commerce experience, from the number of sessions that viewed a product, to the number of sessions that engaged in the checkout process, to the sessions completing transactions.

Pro Tip: This widget is very informative in terms of gaining insights into where your potential customers drop off, which you can use to improve the overall check-out process.

Note: Though we do not offer the funnel type chart, Shopping Behavior can be shown just as nicely via bar charts. 

 

→ Shopping Behavior (Percentage)

Visualizations of the overall funnel activity of users through a site’s E-commerce experience, from the percentage of sessions that viewed a product, to the percentage of sessions that engaged in the checkout process, to the sessions completing transactions.

Pro Tip: This widget is quite informative and useful for gaining insights into where your potential customers drop off, which you can use to improve the overall check-out process.

 

→ Shopping Behavior per Product

Shows data on the overall funnel activity of users through a site’s E-commerce experience, broken down by each product.

 

→ KPIs by Device Category

Displays the most important E-commerce KPIs broken down by device category. 

Pro Tip: Use this data to gain insight into your user experiences across devices.

 

→ KPIs by User Type

Displays data revealing which type of visitors, the new or the returning ones, convert more often and contribute more to your revenue. 

 

→ KPIs by Gender

Shows the most important E-commerce metrics by Gender. Get to know your audience better and use this data to improve your targeting in the future.

 

→ Users by Gender

This chart shows your users presented by gender.

 

→ Revenue by Gender

See your revenue by the gender of users it was generated by.

 

→ KPIs by Age Group

Shows the most important E-commerce metrics broken down by age-group. Get to know your audience better and use this data to improve your targeting in the future.

 

→ Users by Age

This colorful doughnut chart shows your website’s visitors broken down by age.

 

→ Revenue by Age

Shows how each age group contributes to your revenue.

Pro Tip: You can use this data to learn which age groups are your top paying customers and make sure to adjust your targeting accordingly.

 

→ KPIs by Country

Learn where your visitors are located geographically, and make sure to place your products to the right markets, expand to new ones, and communicate to the right audience.

 

→ KPIs by City

Learn where your visitors are located geographically, and make sure to place your products to the right markets, expand to new ones, and communicate to the right audience.

 

→ KPIs by Channel

Shows the most important E-commerce KPIs by Channel.

Pro Tip: You can use this data to identify which channels are your customers coming from the most and use this data to improve your online marketing efforts.

 

→ Users by Channel

Shows the number of your website visitors broken down by the channel they came from. 

 

→ KPIs by Source/Medium

Shows your most important KPIs by Source/Medium. The “Source/Medium” dimension helps you understand where your traffic is coming from. The Source shows the location from where the users came to your content, for example, a search engine, another website, etc. The Medium describes how users arrived at your content.

Pro Tip: Use this data to figure out which Sources/Mediums perform best and adjust your campaigns to better suit your goals.

 

→ KPIs by Campaign

Allocate your budget better by inspecting which of your campaigns are performing the best.

→ Coupon Performance Report

Track which coupons are performing the best with this detailed table chart.