Quick Start: Where Does Feedback Go?

Quick Start: Where Does Feedback Go?

Current Status

Right now, submissions are logged to the browser console only (development mode).

To start receiving actual submissions, set up Google Sheets integration (5-10 minutes, free forever).

What Data is Collected? 📊

Every submission includes:

Field Example Description
rating 4 Star rating (1-5)
feedback "Great calculator but needs more examples" User’s text feedback
calculator "working capital" Calculator name (from URL)
page_url https://businessinitiative.org/tools/calculator/working-capital/ Full page URL
email [email protected] User email (optional)
newsletter_signup "true" or "false" Whether email was provided
timestamp 2025-01-15T10:30:00.000Z When submitted (ISO format)

Setup: Google Sheets (Free Forever)

Quick Setup (5-10 minutes)

  1. Create Google Sheet:
    • Go to Google Sheets
    • Create new sheet named “Calculator Feedback”
    • Add headers in Row 1: Timestamp, Page URL, Calculator Name, Rating, Feedback, Email, Newsletter Signup
  2. Create Google Apps Script:
    • In your sheet: Extensions → Apps Script
    • Delete default code, paste this:
function doPost(e) {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
  
  const data = [
    new Date(),
    e.parameter.url || "",
    e.parameter.calc || "",
    e.parameter.rating || "",
    e.parameter.comment || "",
    e.parameter.email || "",
    e.parameter.newsletter_signup || ""
  ];
  
  sheet.appendRow(data);
  
  return ContentService.createTextOutput("OK")
    .setMimeType(ContentService.MimeType.TEXT);
}
  1. Deploy as Web App:
    • Click Deploy → New deployment
    • Choose Web app
    • Set: Execute as Me, Who has access: Anyone
    • Click Deploy → Copy the Web App URL
  2. Update Your Code:
    • Open assets/js/calculator-exit-intent.js
    • Find line 21 and replace YOUR_SCRIPT_ID with your Web App URL

Result:

  • ✅ All submissions appear in your Google Sheet instantly
  • ✅ Free forever
  • ✅ Easy to analyze with filters/pivot tables
  • ✅ Export to CSV anytime

How to Track Submissions

View by Calculator

Filter by the calculator field to see:

  • Which calculators get feedback
  • Average rating per calculator
  • Common issues per calculator

View by Rating

Group by rating to see:

  • Overall satisfaction (average)
  • How many 1-2 star ratings (needs improvement)
  • How many 4-5 star ratings (satisfied)

View by Page

The page_url field shows exactly which page:

  • Track feedback for specific calculator pages
  • Identify pages with issues
  • Compare different versions

Testing

  1. Visit any calculator: /tools/calculator/[any-calculator]/
  2. Trigger exit intent (move mouse to top of browser)
  3. Submit feedback
  4. Check your Google Sheet - new row should appear!

Need More Details?

See GOOGLE_SHEETS_SETUP.md for:

  • Step-by-step setup instructions
  • Troubleshooting
  • Advanced analysis tips
  • Pivot table examples

Current Code Location

  • JavaScript: assets/js/calculator-exit-intent.js (line 21 for endpoint config)
  • Setup Guide: GOOGLE_SHEETS_SETUP.md