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 workbook 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 Excel, wrestle with the timestamp format that 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 workbook, 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 Excel workbook. It connects to Proofly's activity log and writes the data into your workbook in the shape you need — including the rollup — without a CSV in sight.
Fetch the Proofly activity log and paste all events from the past 7 days into this Excel sheet, 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 Excel 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 Excel 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 worksheet that has your conversion rates by page
Pull the last 200 Proofly activity log events into columns A–D of this Excel sheet. Then look at the "Conversion Rates" worksheet 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 worksheet
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 Excel 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 Excel workbook 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 an Excel workbook and the Proofly integration hub.