The Scenario
You are a mobile marketing manager. The channel review meeting is Thursday. Your director wants to know whether the push notification campaigns from the last 6 months are worth the investment — and she wants to see them compared against email campaigns from the same period.
Your push notification data is in ActiveTrail. Your email campaign data is in a tab you already built. You just need the push data in the adjacent tab.
The slow version:
- You log into ActiveTrail and look for push campaign reports — it is a different section from email campaigns
- You find the push campaigns but the export is a flat CSV with 22 columns you do not need
- You import it into Google Sheets, delete the irrelevant columns, rename the ones that remain
- You try to line up the metrics with the email tab but the column headers do not match
- You spend 20 minutes normalizing the structure so the comparison chart can use both tabs
- The chart still will not work because the date formats are different between the two tabs.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls push notification campaign data from ActiveTrail and writes it in the exact structure you need — normalized to match whatever is already in your sheet.
Open the SheetXAI sidebar and type:
Pull all ActiveTrail push notification campaigns from the last 6 months and write campaign name, send date, sent count, delivered count, opened count, and click rate to this sheet starting at row 2. Format send dates as YYYY-MM-DD.
SheetXAI fetches every push campaign from the last 6 months and writes them into the sheet in the format you specified. If you already have email campaign data in an adjacent tab with the same column structure, the comparison is immediately possible.
What You Get
A clean push notification campaign table for the channel review:
- Campaign name, send date, sent count, delivered count, opened count, click rate — one row per push campaign
- Dates in YYYY-MM-DD format — consistent with whatever format your email tab uses
- Ready for comparison — the column structure matches the adjacent email tab
Open rate is calculable. If you want a percentage column for opened count divided by delivered count, add it to the prompt and SheetXAI writes the formula or calculates it inline.
What If the Data Is Not Quite Ready
Push campaign data has its own structure quirks. SheetXAI handles them in the same prompt.
When you need an open rate percentage column added
The raw data has sent and opened as counts, but the chart needs a percentage.
Pull all ActiveTrail push campaigns from the last 6 months — campaign name, send date, sent count, delivered count, opened count, click rate. Add an Open Rate column calculated as opened count divided by delivered count, formatted as a percentage. Write all columns to this sheet.
When you want to add a column flagging campaigns with low delivery
Some push campaigns had delivery issues — delivered count was less than 80% of sent count. You want to flag those.
Pull all ActiveTrail push campaigns from the last 6 months and write campaign name, send date, sent count, delivered count, and click rate to this sheet. Add a Delivery Rate column (delivered divided by sent). Flag any campaign where delivery rate is below 80% with "LOW DELIVERY" in a separate column.
When you want push and email data combined in one table for the chart
The director wants a single chart with both channels, not two separate tabs.
Pull all ActiveTrail push notification campaigns from the last 6 months. Append the rows below the existing email campaign rows in this sheet. Add a Channel column: "Push" for the new rows, "Email" for the existing rows. Normalize the date format to YYYY-MM-DD across all rows. Sort the combined table by send date descending.
When you want the full cross-channel analysis — push data, open rate calculation, comparison against email, and a chart in one prompt
The director wants the Thursday deck ready, not a draft.
Pull all ActiveTrail push campaigns from the last 6 months and write them to the Push tab with campaign name, send date, sent count, delivered count, open rate (as a percentage), and click rate. On the Comparison tab, write average open rate and average click rate for push campaigns and for email campaigns (from the Email tab). Then create a bar chart on the Comparison tab comparing average open rate and click rate between the two channels.
The pattern: instead of a CSV import session and 20 minutes of column normalization, you describe the output you need for the director and SheetXAI builds it.
Try It
Get the 7-day free trial of SheetXAI and open any sheet, then ask it to pull your ActiveTrail push notification campaign data. The ActiveTrail integration is included in every SheetXAI plan. For related workflows, see how to pull SMS campaign performance data or the ActiveTrail in Google Sheets overview.