The Scenario
It's the third week of the quarter and your growth team's Dub links from two paid campaigns have been live for 90 days. Your manager pinged you an hour ago asking for a performance table for the quarterly review — click counts, expiration dates, and geo-targeting settings for each link, formatted for the slide deck.
You've had the link IDs in a spreadsheet since the campaigns launched. You never got around to pulling the analytics back into it.
The bad version:
- Open Dub, search for link ID 1, open the details panel, note the click count, note the expiry date, note the geo-target, tab back to your sheet, type it all in, repeat.
- Realize the Dub UI shows click counts in a slightly different format depending on whether the link has geo splits, and you have to manually normalize them.
- Get through 20 of 80 links before the review prep call starts and have to show up with an incomplete table.
The review is at 2 PM. You are supposed to be interpreting the data, not transcribing it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your link IDs and fetches the details from Dub for each one, writing every field back to the correct column.
Open your "Campaign Links" sheet, open SheetXAI in the sidebar, and type:
For each Dub link ID in column A of my "Q2 Campaigns" tab, fetch its details and fill in click count, creation date, and expiry date into columns B, C, and D. If a link has geo-targeting enabled, note the target countries in column E.
What You Get
- Columns B through E fill with click count, creation date, expiry date, and geo-targeting data per row.
- Rows where the link ID is no longer active or not found in the workspace receive a note in column F instead of blank cells.
- Click counts are normalized to plain integers — no formatting variation from the Dub UI.
- The geo-targeting column lists the country codes as a comma-separated string if geo is enabled, or "none" if it isn't.
What If the Data Is Not Quite Ready
Some link IDs in column A are short keys, not full IDs — I need to resolve them first
For each value in column A of "Q2 Campaigns," determine whether it looks like a full Dub link ID or a short key. Look up each one using the appropriate Dub API method, then fetch the click count, creation date, and expiry into columns B, C, and D.
I only want to pull data for links where the "Campaign" column B says "Paid Search"
Filter the "Q2 Campaigns" tab to rows where column B equals "Paid Search," then fetch the Dub link details for each link ID in column A and write click count, creation date, and expiry into columns C, D, and E.
I want to calculate the click-through rate by dividing click count by the impression count in column F
After fetching the Dub click count for each link ID in column A and writing it to column C, calculate click-through rate as column C divided by column F (impressions) and write the result as a percentage to column G. Skip rows where column F is zero or empty.
Pull the details, flag links that expire within 30 days, and sort the table by click count descending — all at once
For each Dub link ID in column A of "Q2 Campaigns," fetch click count, creation date, and expiry date into columns B, C, and D. In column E, write "expiring soon" if the expiry date is within 30 days of today. Then sort the entire table by column B (click count) descending.
One ask — the fetch, the flag logic, and the sort happen in sequence without you touching the sheet between steps.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of Dub link IDs, then ask it to pull the performance data you need for your next review. You can also ask it to bulk-tag links based on your sheet data or browse the full Dub integration overview.