Most survey takers have no idea what they actually earn per hour. They know they "made about $150 last month" but couldn't tell you whether that was from 10 hours of work or 30. Without tracking, you can't identify which platforms, survey types, and time slots are actually worth your time — and which are quietly wasting it.

The fix takes five minutes to set up and about 30 seconds per survey to maintain. Here's the system.

What to Track

For every survey you complete, log these five data points:

  • Platform — Which survey site was it on?
  • Survey type — Standard, focus group, product test, medical, B2B?
  • Time spent — Actual minutes from start to completion (not the estimate).
  • Reward amount — Points, dollars, or the cash value of a product.
  • Completion status — Completed, disqualified, or pending?

Setting Up the Spreadsheet

Open Google Sheets (free) or Excel and create these columns:

Date | Platform | Survey Type | Time (min) | Reward ($) | Status | Notes

Then add three summary formulas below or on a second tab:

  • Total earnings: =SUMIF(F:F,"Completed",E:E)
  • Total time (hours): =SUMIF(F:F,"Completed",D:D)/60
  • Effective hourly rate: =Total earnings / Total time

That hourly rate number is the most valuable metric you'll ever generate from survey taking. Most people are shocked by it — and that shock is exactly the motivation needed to improve.

How to Use the Data

Identify Your Best Platforms

Sort your data by platform and calculate the hourly rate for each. You'll likely find that one or two platforms consistently pay better than the others — either because they have higher-paying surveys or because your demographic matches their client base. Double down on those platforms.

Find Your Best Time Slots

Add the time of day to your notes column (e.g., "9 AM," "7 PM"). After a few weeks, patterns emerge. Some platforms release their highest-paying surveys on weekday mornings; others have more inventory on evenings. Schedule your sessions during your highest-paying windows.

Know Your Minimum Acceptable Rate

Once you know your overall hourly rate, you can set a personal minimum. If your average is $12/hour, don't accept surveys paying less than $8/hour — skip them and wait for better ones. This alone can boost your monthly earnings by 20–30% without adding a single minute of work.

Protect Against Missing Payments

Your spreadsheet is also a payment record. If a platform claims you didn't complete a survey that you have logged, your spreadsheet (with date, time, and reward) is evidence. Most platforms honor completions with valid records.

Tracking Disqualifications Too

Log disqualified surveys as well (status = "Disqualified," reward = $0). Over time, you'll see your disqualification rate per platform and per survey type. If one platform disqualifies you 70% of the time, it might not be worth your time — your spreadsheet will tell you.

Weekly Review Habit

Every Sunday, spend five minutes reviewing the week:

  • What was my hourly rate this week vs. last week?
  • Which platform paid the best?
  • Which survey types should I prioritize next week?
  • Are any pending rewards overdue?

This five-minute habit is the difference between randomly clicking surveys and systematically earning money.

Bottom Line: What gets measured gets improved. A simple spreadsheet tracking platform, time, reward, and status transforms survey taking from a guessing game into a optimized side income. Start tracking today — your future self will thank you when your hourly rate doubles. See our main survey guide for the complete system.