The Scenario
A marketing technologist just closed out a six-week seasonal promotion. Sixty Radar geofences were created at the campaign's start — one per participating location — and they have been live ever since. The campaign is over. The geofence IDs are already in an Excel workbook from the original creation run. Those 60 geofences need to be deleted before they start triggering alerts for a completely different campaign that goes live next week.
The bad version:
- Open Radar's dashboard, search for the first geofence ID, open it, click Delete, confirm. There is no bulk delete in the UI.
- Each deletion is three clicks. Sixty geofences, three clicks each, plus the time to search and confirm. Forty-five minutes at minimum, more if the dashboard is slow.
- Midway through, the question arises: is geofence ID "promo-store-42" in the list actually a seasonal geofence, or was it reused for the always-on program? Stop and cross-reference the workbook to check. Lose count of where you were in the deletion sequence.
The new campaign goes live Monday. It is Friday afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the ID column, calls Radar's deletion API for each geofence, and writes "Deleted" or the error back into the workbook — giving you a clean audit log for the campaign close-out report.
Delete all Radar geofences whose IDs are in column A of this Excel workbook and mark each row in column B as Deleted or Failed
What You Get
- Column B: "Deleted" for every successfully removed geofence
- Any geofence that couldn't be deleted gets the specific failure reason in column B — not a blank
- The column serves as the deletion log for the campaign wrap-up report and the handoff to the next campaign team
What If the Data Is Not Quite Ready
Some geofences in the workbook are tagged to stay and should not be deleted
For each row where column B is "Delete": delete the Radar geofence ID in column A and write Deleted or the error to column C — skip all rows where column B is "Keep" and write Skipped to column C
You want to verify the geofence tag before deleting to avoid removing wrong-campaign fences
For each ID in column A: call Radar to fetch the geofence and confirm its tag is "seasonal-promo-2026" before deleting — write Deleted if confirmed and removed, Skipped (wrong tag) if tag doesn't match, or the error message for any other outcome
Some IDs in the workbook may have already been deleted from a previous cleanup pass
For each geofence ID in column A: attempt deletion via Radar and write Deleted to column B if successful, Already Gone if Radar returns 404, or the error detail for any other failure
Validate the deletion list, run deletions, and produce a close-out summary in one pass
For each row in this workbook where column A has a geofence ID and column B is "Confirmed Delete": delete the geofence from Radar and write the outcome to column C — then add a summary below the last row: count of Deleted, count of Already Gone, count of Errors, and list any error rows by ID
The summary gives the campaign manager what they need for the close-out checklist without a manual count.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of Radar geofence IDs — ask it to delete each one and log the outcome per row. To create geofences for a new campaign from a workbook, see bulk geofence creation, or return to the Radar integration overview.