The Daily Stats Summary Report from Guru allows you to track the evolution of your business performance over time, consolidating essential sales metrics by date.
With it, you can quickly view indicators such as sales volume, quantity of products sold, and financial values, facilitating comparative analyses and decision-making.
How to access the Daily Stats Summary Report?
To view the report, you must access Guru's side menu, click on Reports and then, Daily Summary. After the page loads, the listing will display all sales organized by date, divided into the categories all sales, valid and refunded.
In addition to direct consultation on the platform, you can also configure automatic receipt of this information by email, with daily sending of your account statistics. To activate this receipt, locate the My Profile icon in the upper right corner of the page in Guru's admin. In the Detailsection, under Email receipt, select the option Daily Statistics.
On this page:
-
Overview of the Daily Stats Summary Report
-
Calculation of values in the Daily Stats Summary Report
-
Performance analysis and comparison
-
Best practices for analyzing and interpreting the Daily Stats Summary
Overview of the Daily Stats Summary Report
The Daily Stats Summary Report presents a consolidated view of sales organized by date, allowing you to track business performance over time.
Each line of the report corresponds to a specific day and gathers the main sales indicators for that period.
The data can be viewed in three categories, organized according to the transaction status. Each of them presents the same indicators, which consider the data for the visualized date, allowing consistent comparisons between different scenarios.
|
Category |
Includes |
DOES not include |
When to use in analysis |
Impact on analysis |
|---|---|---|---|---|
|
Approved sales, pending sales (such as generated and unpaid boletos and Pix), rejected transactions and refunded sales |
Considers all transaction statuses |
To analyze the overall volume of transactions and identify opportunities, for example, for cart recovery |
May overestimate results, as it includes sales that were not completed |
|
|
Only sales with confirmed payment |
Pending sales, rejected sales, unfinalized sales, and refunded sales |
To analyze the actual business performance and effective revenue |
Represents the most accurate scenario of generated revenue |
|
|
Approved sales that were subsequently reversed |
Unapproved sales, such as expired boletos, unpaid Pix, and transaction rejections |
To monitor losses and identify potential operational problems |
Highlights negative impacts on results and possible failures in the funnel |
Expenses and commissions are considered in the calculation if the marketplace sends this information to Guru. If sent, these fees are also displayed in the sale details.
It is possible to apply filters to select different periods in the daily stats summary, from shorter intervals to broader analyses, and switch between sales types (all, valid, or refunded), adapting the reading according to the scenario you wish to evaluate.
Additionally, you can manage the filters of the Daily Stats Summary reports and clear the filters to perform a new search.
Calculation of values in the Daily Stats Summary Report
The indicators presented in the daily Sales Summary report are calculated exclusively based on sales related to each day displayed in the report.
To correctly interpret the data, it is important to understand how each metric is formed and what criteria define the inclusion of sales in each category.
General calculation rules
All report indicators are calculated based on events occurring on the displayed date.
For the categories βAllβ and βValidβ, the sale creation date is always considered; for the category βRefundedβ, the reference becomes the date the refund was made, instead of the creation date.
The values displayed vary according to the selected category, as each applies specific criteria for including sales:
-
The category βAllβ includes all sales created on the day, regardless of status;
-
the category βValidβ considers only sales created on the day that were approved; and
-
the category βRefundedβ includes sales whose cancellation occurred on the day, regardless of the date they were originally created.
As a consequence, the same sale can impact different days within the report, depending on the category analyzed.
|
Indicator |
How it is calculated |
Rules by category |
|---|---|---|
|
Number of sales |
Total number of sales on the day, including different payment methods, such as credit card, boleto, and Pix |
|
|
Quantity of products |
Sum of the quantity of items from all sales of the day - regardless of the payment method |
Follows the same rule as the number of sales, considering the selected category: All (all sales created on the day); Valid (only approved); or Refunded (canceled on the day). |
|
Total sales (gross value) |
Sum of the gross values of all sales of the day, including sales by credit card, boleto, and Pix |
DOES not consider discounts for fees or commissions |
|
Net total |
Sum of the net values of sales for the day, considering values received after fees, commissions, and payment method conditions |
Considers deduction of fees, commissions from affiliates and other costs, when sent by the marketplace |
Percentage variation
In addition to absolute values, the report also presents the percentage variation of the indicators in relation to the previous day.
The calculation for this variation always considers the immediately preceding day as the basis for comparison.
Example: if the total sales (gross value) was R$ 100 on one day and R$ 120 on the next day, the displayed variation will be +20%.
This logic applies to all report indicators (number of sales, quantity of products, gross total, and net total).
The percentage variation always considers the previous day as the basis for comparison, regardless of the period selected in the filters.
How to interpret the Daily Stats Summary Report in practice
See an example of sales made below. In the table below, we present a fictitious example of sales made to illustrate how the data is displayed in the report.
For this analysis, observe the sale status, creation date, refund date (if any), quantity of products, and gross and net values:
|
Sale |
Creation date |
Status |
Refund date |
Quantity of products |
Gross value |
Net value |
|---|---|---|---|---|---|---|
|
Sale A |
10/04 |
Approved |
β |
2 |
R$ 100 |
R$ 85 |
|
Sale B |
10/04 |
Pending (boleto) |
β |
1 |
R$ 50 |
R$ 0 |
|
Sale C |
10/04 |
Approved |
11/04 |
1 |
R$ 80 |
R$ 70 |
The table above represents individual sales, while the table below shows how these same sales are consolidated in the daily Sales Summary report.
In other words, the values displayed in the report are the result of the sum and application of calculation rules on the sales data presented previously.
Based on these sales, the report presents the following results by day and by category:
|
Date |
Category |
Sales Qty. |
Product Qty. |
Gross total |
Net total |
|---|---|---|---|---|---|
|
10/04 |
All |
3 |
4 |
R$ 230 |
R$ 155 |
|
|
Valid |
2 |
3 |
R$ 180 |
R$ 155 |
|
|
Refunded |
0 |
0 |
R$ 0 |
R$ 0 |
|
11/04 |
Refunded |
1 |
1 |
R$ 80 |
R$ 70 |
This example demonstrates how the same sale can impact different days in the report, depending on the category analyzed and the date considered (creation or refund).
By understanding how the indicators are calculated and how the percentage variation is applied in the report, it is possible to interpret the data with greater precision and correctly analyze performance between days.
Performance analysis and comparison
The Daily Stats Summary Report allows you to track how results evolve over time, facilitating comparison between different days and periods.
You can track this evolution based on:
-
comparison with the previous day;
-
percentage variation of indicators; and
-
identification of growth or decline trends.
This reading is essential to validate sales strategies, identify performance fluctuations, and make quick data-driven decisions.
|
Observed scenario |
What to analyze |
Possible causes |
Recommended actions |
|---|---|---|---|
|
Drop in sales volume |
Reduction in the quantity of sales and revenue over the days |
Drop in traffic, low conversion, seasonality |
Review active campaigns, validate recent changes to pages/offers, and reinforce actions on days with better history |
|
Revenue growth with a drop in net total |
Difference between gross value and net value |
Increase in fees, commissions or refunds |
Monitor the proportion between gross and net, evaluate payment methods and review commercial conditions |
|
Increase in refunded sales |
Growth in volume or frequency of refunds |
Offer problems, expectation misalignment or post-purchase experience |
Review salespage, align communication, analyze feedback and adjust customer support |
|
Increase in the quantity of products per sale |
Relationship between quantity of products and number of sales |
Better performance of upsells or order bumps |
Identify offers that perform better, replicate strategies and test new combinations |
|
Frequent fluctuations between days |
Significant performance variations on close days |
Dependence on campaigns, inconsistency in traffic or behavior by day of the week |
Compare performance by day of the week, identify patterns and adjust campaign distribution |
Access to learn more about the information that makes up the daily stats summary report.
Understand the sales states (or statuses) and, for a detailed overview, access the Sales Dashboard.
Best practices for analyzing and interpreting the Daily Stats Summary
To extract the maximum value from the Daily Stats Summary Report, it is important to use the data not only for monitoring, but mainly as a basis for decision-making and optimizing results.
1 - Use the correct category for each analysis
To correctly interpret the report data, it is important to analyze each category according to your analysis objective, considering the value calculation rules presented in the report.
-
If you want to evaluate the actual revenue of the business, consider only approved sales (valid sales);
-
If you want to analyze the total volume of transactions and identify conversion opportunities (such as pending payment sales), consider all sales; and
-
If you want to monitor losses and identify possible operational problems, consider refunded sales.
Tip: These categories complement each other in the analysis: while βAllβ shows the potential of generated sales, βValidβ indicates what was effectively converted, and βRefundedβ highlights losses after conversion.
By cross-referencing these readings, you can identify, for example, payment bottlenecks, conversion drops, or increased refunds, connecting report data with practical actions in your business.
2 - Identify sales recovery opportunities
In the βAllβ category, you visualize sales that were not completed, such as generated and unpaid boletos, generated and unconcluded Pix, and pending transactions. These sales represent direct recovery opportunities within Guru.
Actions that can be taken based on recovery opportunities
-
In order to re-engage customers from uncompleted purchases, it is possible to use lead management to identify contacts with pending sales and resend the payment link via email or WhatsApp, encouraging the completion of the purchase;
-
In order to automate follow-ups, configure automations to trigger communications after the generation of uncompleted sales, thus ensuring contact at the right time, without the need for manual action;
-
In order to increase the conversion of pending sales, it is possible to segment leads based on the sales status and create specific sales recovery;campaigns;
-
Based on reducing abandonment due to forgetfulness, send payment reminders and schedule automatic sends with a deadline (for example, boletoexpiration);
-
Based on applying conversion triggers, stimulate quick customer decision, adjusting campaigns with urgency and scarcity; and
-
In order to increase conversions, use integrations with email or WhatsApp tools, where it is possible to expand the reach of recovery actions.
With Guru's tools, you can identify pending sales, automate customer contact and track the impact of actions in the report, making sales recovery continuous and scalable.
3 - Monitor performance drops
Drops in sales quantity or revenue can indicate problems in active campaigns, reduced traffic, and low conversion.
How to act in common scenarios, such as
-
Drop in sales quantity, with stable traffic indicates a reduction in the conversion rate - review the sales page (offer clarity, value proposition, and proofs), validate recent changes, and test variations in offer, price, or communication;
-
Drop in sales volume and traffic indicates problems in campaigns or acquisition channels - review active campaigns and budget, reactivate campaigns with better history, and validate channels such as affiliates, email, and ads;
-
Quantity of sales started but not completed indicates payment abandonment
- access pending sales and resend the payment link, identify customers in lead management and configure recovery automations; and -
Drop in total sales value, even with stable volume indicates a reduction in average ticket - review offers, combos, and strategies such as upsell and order bump.
Tip: When identifying a drop, analyze which stage of the process was impacted (traffic, conversion, or payment). This allows for faster and more assertive action.
4 - Monitor the relationship between gross and net value
You can identify out-of-pattern variations by analyzing the gross and net values displayed in the Daily Stats Summary Report. The difference between these values represents costs applied to sales, such as processing fees, affiliate commissions, and other charges. Variations in this relationship can indicate relevant operational changes.
By analyzing these indicators, you can:
-
compare values over the days to identify fluctuations, verify if these variations coincide with campaigns, new affiliates or changes in payment methods, and identify possible margin reductions even with increased sales.
In Guru, this analysis can be deepened by:
-
analyzing the sales details to identify the impact of fees and commissions; using affiliate management to track commissions applied to sales and observing how different payment methods influence the final result.
By continuously monitoring this relationship, you can identify impacts on the margin and adjust your strategies to improve business profitability.
5 - Analyze refund behavior
The increase in refunds may be related to misalignment in the offer; unmet expectations and after-sales problems.
See possible causes for this and how to use Guru's management tools to solve these cases:
-
Offer misalignment: the customer buys with an expectation different from what is delivered - to solve, review the sales page to ensure that the promise is clear and consistent with the delivery.
-
Unmet expectation: the product or service does not correspond to what the customer expected -adjust communication to better detail what is included and the offer conditions; and
-
After-sales problems: difficulties after purchase increase the chance of cancellation
- review the delivery flow and improve customer support at this stage.
With Guru's tools, it is possible to:
-
monitor the evolution of refunds in the report identifying increases and patterns over time;
-
analyze sales individually to identify products or offers with a higher cancellation rate;
-
use automations to improve communication in after-sales; and
-
manage leads and customers to monitor behavior after purchase.
By monitoring this data and applying adjustments, you can identify patterns, correct flaws, and reduce the volume of refunds over time.
6 - Identify opportunities to increase ticket size
Monitor the quantity of products per sale to identify the performance of upsells and acceptance of order bumps.
To do this, you can observe if customers are buying more than one product per sale, identify which offers have greater acceptance, such as combos, for example, and compare periods to validate the impact of new strategies.
Among the strategies you can apply are:
-
Order bump (additional offer at checkout) - allows you to add a complementary product at the time of purchase - to apply an order bump, you must configure a complementary product directly in the offer.
Tip: Use low-value, high-relevance offers and highlight quick and objective benefits.
-
Upsell (offer after purchase) - presents a new offer immediately after completing the purchase - to configure an upsell, you must configure an additional offer after payment.
Tip: Offer upgrades, full versions, or related products and keep communication simple and focused on additional gain.
Learn more about how offering order bump and upsell can help increase your revenue.
When analyzing your results, avoid analyzing isolated days - identify patterns of growth or decline and observe recurrent fluctuations. This way you maintain focus on consistent trends and comparisons, reduce punctual distortions, and can interpret results with greater precision.