The Scenario
You are a mobile marketing manager. The channel review meeting is Thursday. Your director wants push notification campaigns from the last 6 months compared against email campaigns from the same period — open rates, click rates, delivery side by side.
Your push notification data is in ActiveTrail. Your email data is in the adjacent tab of the Excel workbook you already have open. You just need the push data in the workbook.
The slow version:
- You find the push campaigns section in ActiveTrail — different from email campaigns
- You export the push report — a CSV with 22 columns you do not need
- You import it into Excel, delete the irrelevant columns, rename the ones that remain
- You try to align the metrics with the email tab but the headers do not match
- You spend 20 minutes normalizing the structure so both tabs can feed the same chart
- The chart breaks 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 Excel workbook that pulls push notification campaign data from ActiveTrail and writes it in the exact structure you need — normalized to match the email tab you already have.
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 the Push Campaigns tab of this workbook 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 Push Campaigns tab in the format you specified. The comparison against the email tab is immediately possible.
What You Get
A clean push notification performance table for the channel review:
- Campaign name, send date, sent count, delivered count, opened count, click rate — one row per push campaign
- Dates formatted as YYYY-MM-DD — consistent with the email tab
- Ready for comparison — same column structure as the adjacent email tab
Open rate is calculable from the data. If you want an Open Rate percentage column, add it to the prompt and SheetXAI 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
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 to the Push Campaigns tab — 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.
When you want to flag campaigns with low delivery
Some push campaigns had delivery issues — delivered count below 80% of sent count.
Pull all ActiveTrail push campaigns from the last 6 months to the Push Campaigns tab — name, send date, sent count, delivered count, click rate. Add a Delivery Rate column (delivered divided by sent). Flag any campaign where delivery rate is below 80% with "LOW DELIVERY" in column G.
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 the Campaign Data tab. Add a Channel column: "Push" for new rows, "Email" for existing rows. Normalize all dates to YYYY-MM-DD. Sort the combined table by send date descending.
When you want the full cross-channel analysis — push data, open rate, comparison against email, and a chart in one prompt
The Thursday deck needs the chart ready.
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 (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). Create a bar chart on the Comparison tab comparing the two channels.
The pattern: instead of a CSV import session and 20 minutes of column normalization, you describe the output you need for Thursday and SheetXAI builds it into the right tab.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, 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 in Excel or the ActiveTrail in Excel overview.