The Scenario
It's a Monday morning debrief and your growth team just wrapped a two-week campaign where you ran Proofly across four landing pages simultaneously — different notification types, different visitor segments. Your manager wants to know which notification type drove the most engagement, broken down by page.
The data exists in Proofly's activity log. Two hundred events, timestamped, with page URL and notification type attached. You just need it in the sheet where you've been tracking conversion rates by page.
The bad version:
- Navigate to Proofly's activity log, filter by the campaign date range, and manually export whatever format is available
- Import the CSV into Google Sheets, wrestle with the timestamp format that Excel-imported as a plain number, and rebuild the date column
- Write a COUNTIF formula to tally events per page URL, realize it's case-sensitive and your URLs have inconsistent trailing slashes, and spend twenty minutes normalizing them
The conversion data is already in the sheet, waiting. The longer this takes, the later the debrief slides.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Proofly's activity log and writes the data into your sheet in the shape you need — including the rollup — without a CSV in sight.
Pull the Proofly activity log and write the last 200 events into this sheet — columns for event type, timestamp, page URL, and visitor country — then add a column E that counts total events per unique page URL
What You Get
- Column A: Event type (notification shown, notification clicked, etc.)
- Column B: Timestamp in ISO 8601 format, one event per row
- Column C: The page URL the notification appeared on
- Column D: Visitor country from Proofly's geo data
- Column E: A count of total events sharing the same page URL as that row, so you can sort and filter by volume immediately
What If the Data Is Not Quite Ready
The timestamps are coming in as UTC but your conversion data uses Eastern Time
Pull the last 200 Proofly activity log events into columns A–D of this sheet with event type, timestamp, page URL, and visitor country. Convert all timestamps in column B from UTC to Eastern Time before writing them
You only want events from notification clicks, not impressions
Fetch the Proofly activity log and write only click events from the past 14 days into this sheet — columns for event type, timestamp, page URL, and visitor country. Skip any events where the event type is not a click
You need to join the activity log against a second tab that has your conversion rates by page
Pull the last 200 Proofly activity log events into columns A–D of this sheet. Then look at the "Conversion Rates" tab where column A is page URL and column B is conversion rate — add column F that looks up the conversion rate for each event's page URL, or writes "NO DATA" if the page isn't in that tab
You want the full kill-chain: pull the log, normalize URLs, aggregate by notification type and page, and flag the highest-performing combination
Fetch the Proofly activity log for the past 14 days into this sheet with event type, timestamp, page URL, and visitor country. Normalize all URLs in column C to remove trailing slashes. Add column E counting events per unique normalized URL. Then create a summary block starting at row 210 that groups by both notification type and page URL and shows total events for each combination, sorted by count descending
Combining the pull, normalization, and aggregation in a single prompt saves you three separate passes through the same data.
Try It
Get the 7-day free trial of SheetXAI and open whatever sheet you're using to track campaign performance, then ask it to pull your Proofly activity log with whatever filters and rollups you need for the debrief. For the campaign-level view, see Audit Your Proofly Campaign Inventory in a Google Sheet and the Proofly integration hub.