Skip to main content

Understanding Reports in Pulse Commerce

Updated

The Reports section in Pulse Commerce provides comprehensive data analysis tools to track sales, inventory, purchasing, returns, and customer behavior. Understanding how reports work—including the differences between Simple and Advanced reports, update frequencies, and customization options—will help you make data-driven business decisions and efficiently track key performance indicators.

Important: Reports are powered by a central reporting engine that drives analytics throughout your admin panel, including the Dashboard, Marketing insights, and the dedicated Reports tab. This engine analyzes your store's transaction data to deliver both real-time snapshots and historical analysis.
🔍 Understanding Report Types

Report Categories and Organization

Standard reports are organized into five main categories, each focusing on a different aspect of your business:

  • Sales (10 reports): Analyze orders, revenue, customer behavior, payment methods, and sales channels
  • Inventory (10 reports): Monitor stock levels, backorders, pending fulfillment, and inventory profitability
  • Purchasing (5 reports): Review purchase orders, vendor performance, and product costs
  • Returns (4 reports): Examine return patterns by product, customer, or date
  • Site Search (4 reports): Track customer search behavior, abandoned carts, wish lists, and loyalty programs

Each category contains specialized reports designed to answer specific business questions. For detailed information about individual reports within each category, see the category-specific guides.

📋 Simple vs. Advanced Reports - Key Differences

Pulse Commerce offers two distinct report types with different capabilities and use cases:

Simple Reports: Real-Time Data

  • Updated instantly when you click "Search" - shows data as of this exact moment
  • Limited customization - cannot change columns, grouping, or filtering options
  • Export to Excel only
  • Best for operational decisions requiring current information

Examples of Simple Reports:

  • Current Inventory Status
  • Items Backordered (Simple)
  • Items Pending Fulfillment (Simple)
  • Item Sell Through

Advanced Reports: Historical Snapshots

  • Updated once every 24 hours (typically early morning)
  • Display "as of" timestamp in top-right corner showing last update
  • Full customization capabilities including filtering, grouping, sorting, and column management
  • Multiple export formats - Excel, Word, PDF, CSV
  • Create custom reports to save your settings for recurring analysis

Examples of Advanced Reports:

  • Sales Order Analysis
  • Sales by Customer Summary
  • Inventory - Profitability
  • Returns Item Summary
  • Purchase Order Analysis

When to Use Each Type

Use Simple Reports when you need:

  • Real-time, up-to-the-second data accuracy
  • Quick answers for immediate operational decisions
  • Current status information without historical analysis
  • Basic data export to Excel only

Use Advanced Reports when you need:

  • Historical analysis and trend identification
  • Ability to filter, group, sort, and customize column views
  • Multiple export format options (Excel, PDF, Word, CSV)
  • Saved custom reports for recurring analysis
  • Complex data aggregation and calculations
How to Identify Report Type: Advanced reports display an "as of [date and time]" timestamp in the top-right corner and feature a blue bar across column headers with customization options. Simple reports show neither of these elements and generate fresh data with each search.
📅 Update Frequencies and Data Freshness

Understanding when reports update helps you access the most accurate data for your needs:

Real-Time Reports (Simple)

Generate fresh data with every search and include transactions up to the current moment. Best for inventory checks, fulfillment decisions, and customer service inquiries requiring up-to-the-second accuracy.

Daily Updated Reports (Advanced)

Refresh once every 24 hours, typically during early morning hours. Always check the "as of" timestamp in the top-right corner to see when the report was last updated. These reports may not include same-day transactions until the next daily refresh.

Important for Daily Reconciliation: If you need end-of-day reporting for yesterday's activity, run Advanced reports the following morning after they have refreshed. For quarterly tax reports, wait until the day after quarter-end to ensure all transactions are included.

Why Advanced Reports Use Snapshots

Advanced reports create indexed snapshots of your data to enable powerful features like grouping, complex filtering, and aggregations. This snapshot approach:

  • Improves performance for large data sets with thousands of orders
  • Ensures consistency when multiple users view the same report
  • Enables complex analysis without impacting your live store performance
  • Provides historical accuracy - yesterday's report shows yesterday's reality
💾 Export Format Options and Uses

Choose the export format based on how you plan to use the data:

Excel (.xlsx)

  • Best for: Data manipulation, pivot tables, charts, and calculations
  • Available for: All reports (Simple and Advanced)
  • Use when: You need to perform calculations, create visualizations, or combine with other data

CSV (Comma-Separated Values)

  • Best for: Importing into other systems, databases, or accounting software
  • Available for: Advanced reports only
  • Use when: You need raw data for system integration or automated processing

PDF

  • Best for: Presentations, executive summaries, printing, and archival
  • Available for: Advanced reports only
  • Use when: You need a polished, printable format or permanent record

Word (.docx)

  • Best for: Adding narrative context, internal documentation, or detailed notes
  • Available for: Advanced reports only
  • Use when: You need to add commentary or combine data with written analysis
Export Tip for Pivot Tables: Before exporting to Excel for pivot table analysis, remove all groupings in the report (click the X on grouped column tabs). This creates a flat data structure that works best with Excel pivot tables.
📊 Standard Reports vs. Custom Reports

Custom reports are personalized versions of standard reports that save your specific settings for recurring use:

What Custom Reports Save

  • Filtered data - Show only orders from specific states, customers, or products
  • Custom columns - Display only the fields relevant to your analysis
  • Grouping preferences - Organize by customer, state, product, or other dimensions
  • Date range presets - Use dynamic ranges like "Previous Calendar Quarter" that update automatically
  • Aggregation settings - Sum, average, count, or other calculations
  • Role-based sharing - Control which admin users can access the report

Custom Reports Locations

Access your saved custom reports in two places:

  • Reports Custom Reports tab - Lists all custom reports you have access to
  • Load Custom Report dropdown - Available within each standard report to load saved versions based on that report
Critical Limitation: Once created, custom reports cannot be edited, renamed, or have their permissions changed. To make changes, you must create a new custom report with your updated settings and delete the old version.

For detailed instructions on creating and managing custom reports, see the Creating Custom Reports guide.

📆 Date Range Selection and Presets

Reports offer flexible date range options to match your business cycles:

Preset Ranges (Dynamic - Automatically Update)

  • Current Calendar Quarter
  • Previous Calendar Quarter
  • Current Calendar Year
  • Previous Calendar Year
  • Current Month
  • Previous Month
  • Last Month
  • This Week
  • Last Week

Why Use Preset Ranges?

When you save a custom report with a preset range like "Previous Calendar Quarter," the report automatically updates each quarter. This is perfect for:

  • Quarterly tax filings (always shows last complete quarter)
  • Monthly performance reviews (always shows last complete month)
  • Recurring executive reports
  • Consistent period-over-period comparisons

Custom Date Ranges (Fixed - Stay the Same)

Enter specific Begin Date and End Date for one-time analysis or event-specific reporting:

  • Holiday sales campaigns (e.g., Nov 20 - Dec 31)
  • Promotional period analysis
  • Historical comparisons to specific past periods
Planning Tip: Use preset ranges for recurring reports you'll run monthly or quarterly. Use custom fixed dates for one-time analysis or when comparing to specific historical periods.

Video Tutorial: Reports Overview

Webinar: Using Pulse Commerce Reports

Related articles