How Did You Hear Documentation¶
Menu Location: Reports > Acquisition > How Did You Hear
Access Level: Customer Service / Manager
Last Updated: 2026-03-01
Overview¶
The How Did You Hear page tracks customer acquisition sources by analyzing responses to the "How did you hear about us?" question during signup. This report helps you understand which marketing channels are most effective and where to focus your marketing efforts.
Primary Functions:
- View acquisition source data and trends
- Generate visual charts showing acquisition channels
- Filter by date range to analyze specific periods
- Export data for further analysis
- Track marketing campaign effectiveness
Page Layout¶
Header Section¶
- Page Title: How Did You Hear with Summary Graphs link
- Revenue Button: View revenue by acquisition source
- Date Range Filters: From/To date selectors
Two View Modes¶
Summary Graphs Mode (click "Summary Graphs" button):
- Pie charts showing acquisition sources
- Category breakdown (Friend/Family, Google, Social Media, etc.)
- "Other" responses breakdown
Detailed List Mode (default view):
- Table of individual customer responses
- Date, customer name, acquisition source, expanded text
- Sortable and searchable
Acquisition Source Categories¶
Standard Categories¶
The system provides predefined categories customers select from:
- A friend told me! / Friend/Family: Word-of-mouth referrals
- Google: Search engine discovery
- Social Media: Facebook, Instagram, Twitter, etc.
- Living Social / Groupon: Deal sites
- Media Promotions: Advertising campaigns
- Other: Free-text entry
"Other" Responses¶
When customers select "Other", they provide free-text explanation. These are tracked separately and shown in the detailed breakdown charts.
Using the Report¶
Date Range Selection¶
Default Range: Last 3 weeks
Custom Range:
- Enter "From" date (MM/DD/YYYY format)
- Enter "To" date
- Click "Search"
- Charts and table update to show selected period
Use Cases for Date Ranges:
- Week-by-week to track trends
- Month-by-month for reporting
- Campaign duration to measure specific marketing efforts
- Year-over-year comparison
Summary Graphs View¶
Left Chart: How Did You Hear By Category
- Pie chart of main acquisition sources
- Shows percentage of each category
- Includes count for each source
- Edit categories via link at bottom
Right Chart: How Did You Hear By 'Other'
- Breakdown of free-text "Other" responses
- Helps identify patterns not covered by standard categories
- May reveal need for new category options
Table Below Charts:
- Row count and category name
- Exportable to CSV
- Use for detailed analysis
Detailed List View¶
Table Columns:
- Date: When customer signed up
- Customer: Name and link to account
- How: Category selected
- Expanded: Full text entered (for "Other" responses)
Features:
- Click customer name to view full account
- Search/filter capabilities via DataTable
- Export to CSV for spreadsheet analysis
- Sort by any column
Common Use Cases¶
Use Case 1: Measure Marketing Campaign Effectiveness¶
Goal: Determine if a Facebook ad campaign drove signups
Steps:
- Note campaign start and end dates
- Go to How Did You Hear page
- Set date range to campaign period
- Click "Summary Graphs"
- Check "Social Media" percentage and count
- Compare to typical percentage for Social Media
- If significantly higher, campaign was effective
Example: Normal Social Media = 15% of signups. During 2-week Facebook campaign, Social Media = 35% of signups. Campaign drove significant traffic.
Use Case 2: Identify Top Acquisition Channel¶
Goal: Understand primary customer source for budget allocation
Steps:
- Set date range to last 3-6 months
- View Summary Graphs
- Note highest percentage category
- Click "Revenue" button to see which source has highest customer value
- Allocate marketing budget to top-performing channels
Tips:
- Word-of-mouth (Friend/Family) = focus on referral program
- Google = invest in SEO and search ads
- Social Media = increase social presence and ads
- Combine percentage with revenue per source
Use Case 3: Clean Up "Other" Responses¶
Goal: Add new category based on common "Other" responses
Steps:
- View Summary Graphs
- Check "Other" breakdown chart
- Identify repeated responses (e.g., "Podcast" appearing frequently)
- Click "Edit Categories" link
- Add "Podcast" as new standard category
- Update signup form to include new option
- Future customers can select "Podcast" instead of "Other"
Revenue Analysis¶
Click "Revenue" button to view revenue attribution by acquisition source.
Shows:
- Total revenue per acquisition channel
- Average order value by source
- Customer lifetime value by source
Use for:
- ROI calculation on marketing spend
- Identifying highest-value customers
- Budget allocation decisions
Editing Categories¶
Link at bottom of Summary Graphs: "Edit Categories"
Leads to: Settings page for how_did_you_hear_cats table
You Can:
- Add new acquisition source options
- Edit existing category names
- Disable outdated categories
- Reorder options in signup form
After Changes:
- Update signup form to match new categories
- Communicate changes to marketing team
- Historical data remains unchanged
Export & Reporting¶
CSV Export¶
All tables have CSV export button (via DataTables plugin):
Exports Include:
- All visible rows
- Current date range filter
- All columns shown in table
Use Exports For:
- Executive reports and presentations
- Detailed analysis in Excel
- Sharing with marketing team
- Historical tracking and trends
Troubleshooting¶
No Data Showing¶
Check:
- Date range includes period with signups
- Customer signup form includes "How did you hear" question
- Data is being captured in database
Solutions:
- Expand date range
- Verify signup form configuration
- Check that question is not optional/hidden
Charts Not Loading¶
Symptoms: Pie charts show as blank or don't render
Solutions:
- Refresh page
- Check browser console for JavaScript errors
- Ensure date range has data
- Verify Frappe Charts library is loading
Inaccurate Data¶
Symptoms: Numbers don't match expectations or known campaign results
Check:
- Date range is correct (including time zones)
- Filter logic excluding certain responses
- Duplicate entries in database
- Test vs production data
Related Pages¶
- Referrals (
admin-referrals.php) - Manage friend/family referrals - Customers - View individual customer acquisition source
- Revenue Report (
how-did-you-hear-revenue.php) - Revenue by source - Edit Categories (
admin-edit.php?table=how_did_you_hear_cats) - Manage options
Permissions & Access¶
Required Access Level: Customer Service or higher
All levels can:
- View reports and charts
- Filter by date range
- Export data
- Access revenue information
Best Practices¶
Regular Monitoring¶
- Review weekly to spot trends
- Track month-over-month changes
- Set up regular export cadence for records
Data Quality¶
- Keep categories current and relevant
- Periodically review "Other" responses
- Update signup form when adding categories
- Train team on importance of data quality
Marketing Insights¶
- Combine with revenue data for ROI
- Share insights with marketing team
- Use to justify budget requests
- Test and measure all campaigns
Things to Avoid¶
- Don't change categories mid-campaign (skews data)
- Don't delete historical categories (breaks reports)
- Don't ignore "Other" patterns
- Don't make decisions on short date ranges
Quick Reference Card¶
| Task | Action/Location |
|---|---|
| View acquisition breakdown | Summary Graphs button |
| Set date range | Enter From/To dates > Search |
| Export data | Click CSV button on table |
| See revenue by source | Click Revenue button |
| Add new category | Edit Categories link > Add new |
| View customer details | Click customer name in table |
| Compare time periods | Run report twice with different dates |
| Share with team | Export CSV > Email |
FAQs¶
How far back does data go?¶
As far back as customers have been signing up and answering the question. No historical limit.
Can we track UTM parameters?¶
This page shows self-reported acquisition. UTM tracking requires additional analytics setup.
What if customers skip the question?¶
If optional, blank responses won't appear in report. Make question required for complete data.
Can we segment by other factors?¶
This report focuses on acquisition source. Use customer filters or custom reports for segmentation by route, plan, etc.
How accurate is self-reported data?¶
Generally reliable but has limitations. Customers may not remember exact source or may be influenced by most recent touchpoint.
Change Log¶
2026-03-01¶
- Initial documentation created
- Documented chart views and detailed list
- Added export and analysis guidance
- Included marketing use cases
End of Documentation
For additional help, contact your system administrator or Kiva Logic support.