Website Sales Dashboard

• Real-time online revenue tracking

• Analyze conversion funnel: visitors → cart → checkout → orders

• Calculate conversion rate, cart abandonment rate

• Track Average Order Value (AOV) and Revenue Per Visitor (RPV)

• Analyze customer behavior: new vs returning customers

• Dashboard for bestselling products and revenue by category

• Track traffic sources: organic, paid, social, direct

• Trend charts for revenue and orders by day, week, month

• Multi-dimensional pivot tables by product, customer segment, channel

• Export Excel reports with detailed e-commerce metrics

• Visitors: Number of website visitors

• Sessions: Number of visits (one visitor can have multiple sessions)

• Conversion Rate: Conversion rate = Orders / Visitors × 100%

• Cart Abandonment Rate: Cart abandonment = (Carts - Orders) / Carts × 100%

• Average Order Value (AOV): Average order value

• Revenue Per Visitor (RPV): Revenue per visitor

• Customer Acquisition Cost (CAC): Cost to acquire a new customer

• Customer Lifetime Value (CLV): Customer value over lifetime

• Bounce Rate: Rate of visitors leaving immediately

• Add-to-Cart Rate: Add to cart rate / Visitors

1. Go to Spreadsheet > Dashboards, click Create

2. Select "Website Sales Analysis" template or create from scratch

3. Add Pivot Table: Insert > Pivot, select Sales Orders (online)

4. Configure Pivot: Rows = Date, Columns = Product Category, Values = Revenue

5. Add 2nd Pivot: Website Analytics, Values = Visitors, Sessions

6. Create charts: Insert > Chart, revenue trends and conversion funnel

7. Add KPI cards: Total revenue, Orders, AOV, Conversion rate

8. Set up filters: Date range, Traffic source, Customer segment

9. Add formulas: Conversion rate, Cart abandonment, RPV

10. Save dashboard and share with marketing team

• Line Chart: Revenue and orders trends by day

• Funnel Chart: Conversion funnel from visitors to orders

• Bar Chart: Compare revenue by product category or traffic source

• Pie Chart: Revenue distribution by customer segment

• Combo Chart: Revenue (bars) and Conversion rate (line) by week

• Heatmap: Orders by day of week and hour of day

• Gauge Chart: Conversion rate vs target

• Stacked Area: Revenue breakdown by traffic source

• Total Revenue: Total website revenue

• Total Orders: Total online orders

• Conversion Rate: (Orders / Visitors) × 100%

• Average Order Value: Total Revenue / Total Orders

• Revenue Per Visitor: Total Revenue / Total Visitors

• Cart Abandonment Rate: (Carts - Orders) / Carts × 100%

• New vs Returning Customers: Ratio of new and returning customers

• Customer Acquisition Cost: Marketing Spend / New Customers

• Customer Lifetime Value: Average Revenue × Purchase Frequency × Lifespan

• Traffic by Source: Organic, Paid, Social, Direct, Referral

• E-commerce store: Track 1000+ orders/month, $200K revenue

• B2C marketplace: Analyze conversion rate by product category

• Fashion retailer: Dashboard for bestsellers and seasonal trends

• Digital products: Track instant downloads and subscription revenue

• Marketing Manager: Analyze ROI of paid campaigns and traffic sources

• Product Manager: Identify top-selling products and optimize catalog

• CEO: Weekly revenue report with key e-commerce metrics

• Customer Success: Track customer retention and repeat purchase rate

• Stage 1 - Visitors: Total website visitors

• Stage 2 - Product Views: Number viewing product details

• Stage 3 - Add to Cart: Number adding products to cart

• Stage 4 - Checkout: Number starting checkout

• Stage 5 - Orders: Number of completed orders

• Drop-off analysis: Identify which stage loses most customers

• Optimization: Focus on stage with highest drop-off rate

• A/B testing: Test changes and measure impact on conversion

• Multiple data sources: Sales Orders, Website Analytics, Customer Data

• Calculated fields: AOV = Revenue / Orders, RPV = Revenue / Visitors

• Conditional formatting: Green for high conversion, Red for low

• Drill-down: Click date to view detailed orders and traffic

• Grouping: Group by week, month, product category, traffic source

• Sorting: Sort by revenue or conversion rate descending

• Filters: Filter by date, device type, customer segment, location

• Subtotals: Display totals by category and time period

• =ODOO.PIVOT("Sales Orders", "Revenue", "Date", "Category")

• =ODOO.PIVOT("Website Analytics", "Visitors", "Date", "Source")

• =Orders / Visitors × 100 - Calculate Conversion Rate

• =Revenue / Orders - Calculate Average Order Value

• =Revenue / Visitors - Calculate Revenue Per Visitor

• =(Carts - Orders) / Carts × 100 - Cart Abandonment Rate

• =IF(Conversion_Rate < 2, "Low", "OK") - Low conversion alert

• =COUNTIF(Customers, "New") / COUNT(Customers) - New customer ratio

• Website: Get traffic data, page views, and user behavior

• Sales: Connect with online orders and revenue data

• CRM: Track leads from website and conversion to customers

• Marketing Automation: Track campaign performance and ROI

• Inventory: Monitor stock levels for bestselling products

• Shipping: Analyze delivery performance and shipping costs

• Payment: Track payment methods and transaction success rate

• Customer Portal: Analyze customer engagement and self-service usage

• Reduce cart abandonment: Email reminders, exit-intent popups

• Improve product pages: Better images, descriptions, reviews

• Optimize checkout: Simplify steps, guest checkout, multiple payment options

• Mobile optimization: Responsive design, fast loading, easy navigation

• Trust signals: Security badges, customer reviews, return policy

• Personalization: Product recommendations, dynamic pricing

• A/B testing: Test headlines, CTAs, layouts, colors

• Speed optimization: Reduce page load time to decrease bounce rate

• Daily monitoring: Review dashboard every morning to catch trends

• Set benchmarks: Establish baseline metrics and track improvements

• Segment analysis: Analyze separately for mobile vs desktop, new vs returning

• Cohort analysis: Track customer behavior by cohorts

• Attribution modeling: Understand which channels drive conversions

• Seasonal planning: Prepare for peak seasons with historical data

• Competitor benchmarking: Compare metrics with industry standards

• Regular testing: Continuous A/B testing to improve conversion

• Customer feedback: Combine quantitative data with qualitative insights

• Cross-functional review: Weekly meetings with marketing, product, ops teams

• Traffic data not updating: Check website analytics integration

• Unusually low conversion rate: Review recent website changes

• Orders don't match: Verify date filters and order status

• Revenue doesn't match: Ensure include/exclude taxes consistently

• Slow pivot table: Reduce date range or aggregate data

• Chart not displaying: Check data has values and correct format

• Export error: Verify formulas and data permissions

• Attribution issues: Check UTM parameters and tracking setup

• Spreadsheet Dashboard module must be installed

• Website and E-commerce modules must be activated

• Sales module must be configured for online orders

• Website Analytics tracking must be set up

• Access rights: User (view), Marketing Manager (edit), Admin (configure)

• Browser: Latest Chrome, Firefox, Safari versions