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 you aggregate totals, not a day-by-day breakdown per event. You need one row per event per day for all of January in a Sheet — that is 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
- You switch to the table view, copy five rows of data for January, paste them into the Sheet
- 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 more minutes cleaning up the date column.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet 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 this sheet with columns for date, event name, and count — one row per event per day. Sort by date ascending, then by 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 sheet in the structure you described. 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 — the event identifier, 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 pivot by date to see the daily funnel shape, without any manual reformatting.
What If the Data Is Not Quite Ready
Event count exports rarely arrive in the exact shape needed for funnel analysis.
When the event names in GoSquared 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 this sheet, 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 the daily counts plus a daily conversion rate
Your head of product wants to see the conversion rate from sign_up to onboard_complete each day, not just the raw counts.
Fetch GoSquared daily counts for 'sign_up' and 'onboard_complete' for January 2026. Write date, sign_up count, and onboard_complete count into this sheet — one row per day. Add a fourth column called Completion Rate 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' in the rate column.
When the quarter changed and you now need Q1, not just January
The funnel review expanded. You now need January, February, and March — all 90 days — not just January.
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 this sheet — 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
The head of product wants the full picture before the review: the daily table, January totals per event, and a paragraph about where the biggest drop-off is.
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 Daily 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 in the funnel where the biggest absolute drop-off occurs 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 sheet, 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 sheet, with whatever date range and structure your analysis needs. 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 Google Sheets overview.