The Scenario
You are a product manager. The funnel review is at the end of January. You need to show how five key events performed every day across the month — sign_up, onboard_complete, first_export, upgrade_clicked, and cancel — so your team can see where daily drop-off happened and whether it trended worse or better through the month.
GoSquared has tracked every one of those events. But the dashboard shows aggregate totals, not a day-by-day breakdown per event you can put in an Excel chart. You need one row per event per day for all of January in a workbook — 31 days × 5 events = 155 rows — ready for the pivot table your team will build in the review.
The slow version:
- You open GoSquared, filter to the first event, set the date range to January, look for daily granularity
- The view shows a chart but not a table you can copy into Excel
- You switch to table view, copy five rows of daily data, paste into the workbook
- You repeat for the next event, reconcile the date columns, realize the date format changed between exports
- You finish the export on Sunday evening and spend twenty minutes cleaning up the date column before Monday's review.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads GoSquared event count data through the API, so you do not have to filter per event, switch views, or reconcile date formats.
Open the SheetXAI sidebar and type:
Fetch GoSquared event counts for 'sign_up', 'onboard_complete', 'first_export', 'upgrade_clicked', and 'cancel' for each day in January 2026. Write the results into the Events tab of this workbook with columns for date, event name, and count — one row per event per day. Sort by date ascending, then event name alphabetically within each date.
SheetXAI calls the GoSquared events API five times, once per event, with January date range and daily granularity, and writes 155 rows into the Events tab. The pivot table your team needs is two clicks away.
What You Get
A 155-row event frequency table, structured for pivot analysis:
- Date column — formatted consistently, one row per day per event
- Event name column — consistent across all rows
- Count column — how many times that event fired on that day
The sort puts dates in order with events alphabetical within each date. Your team can pivot by event to see the trend, or by date to see the daily funnel shape.
What If the Data Is Not Quite Ready
Event count exports rarely arrive in exactly the shape needed for funnel analysis.
When the event names use snake_case but your report uses Title Case
GoSquared stores events as "onboard_complete" but the funnel slide labels them "Onboard Complete."
Fetch GoSquared daily event counts for 'sign_up', 'onboard_complete', 'first_export', 'upgrade_clicked', and 'cancel' for January 2026. Before writing into the Events tab, convert event names to Title Case with underscores replaced by spaces. Write date, event name, and count — one row per event per day.
When you want daily counts plus a daily conversion rate
Your head of product wants to see the sign_up to onboard_complete conversion rate each day.
Fetch GoSquared daily counts for 'sign_up' and 'onboard_complete' for January 2026. Write date, sign_up count, and onboard_complete count into the Events tab — one row per day. Add a Completion Rate column showing onboard_complete ÷ sign_up as a percentage, rounded to one decimal place. If sign_up count is zero for a day, write 'N/A'.
When the quarter changed and you now need Q1, not just January
The funnel review expanded to all three months.
Fetch GoSquared daily event counts for 'sign_up', 'onboard_complete', 'first_export', 'upgrade_clicked', and 'cancel' for Q1 2026 (January through March). Write date, event name, and count into the Events tab — one row per event per day, sorted by date ascending.
When you need the event table, a monthly rollup, and a one-paragraph funnel summary
Your head of product wants the full picture before the review.
Fetch GoSquared daily counts for 'sign_up', 'onboard_complete', 'first_export', 'upgrade_clicked', and 'cancel' for January 2026. Write the full day-by-day table into the Events tab (date, event, count). Write a monthly rollup into the Summary tab — one row per event with the January total. In cell A1 of the Analysis tab, write a short paragraph identifying the step with the biggest absolute drop-off and whether that drop-off trended worse or better over the course of the month.
The pattern: pull the event data, structure it for analysis, add the interpretation. One prompt, one workbook, ready for the review.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull GoSquared event counts for your key funnel events into any Excel workbook. The GoSquared integration is included in every SheetXAI plan. See also how to pull GoSquared People event feeds for individual journey analysis or the GoSquared in Excel overview.