The Scenario
The migration went live last Tuesday. 120 product pages moved from the old URL structure to the new one. Your Keyword.com project is still tracking the old paths — which means the rank data is measuring URLs that now 301-redirect, not the canonical pages that Google is actually indexing. And 40 of those keywords need to flip from desktop to mobile tracking at the same time, because the new pages are mobile-first.
The migration mapping lives in a Google Sheet: old URL in column B, new URL in column C, device type in column D, keyword ID in column A. Column E is empty and waiting for a status update.
The bad version:
- Open Keyword.com, find keyword 1, click edit, update the tracked URL, save, move on to keyword 2.
- Repeat 120 times.
- Go back through the 40 that need device changes, update those too, separately.
- Realize halfway through that the keyword IDs in your sheet don't match the order they appear in Keyword.com, lose your place, start counting from the beginning.
This is three hours of mechanical clicking on a task that has exactly zero strategic value.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your migration mapping sheet and sends the updates to Keyword.com for you — using the keyword IDs in column A to find each record, and the new URL and device in columns C and D to apply the changes.
For every row in this sheet where column E says 'UPDATE', call Keyword.com to update the tracked URL for keyword ID in column A to the new URL in column C and the device type to the value in column D.
What You Get
- Tracked URLs updated in Keyword.com for every row where column E says 'UPDATE'.
- Device type applied from column D at the same time — no second pass.
- Any row that fails (keyword ID not found, invalid device value) written as an error message in column F.
- Rows that succeed get 'Done' written to column E, so the next time you run the prompt it skips them.
What If the Data Is Not Quite Ready
Device values in column D are inconsistent — some say 'Mobile', some say 'mobile', some say 'mob'
Before updating Keyword.com, normalize every value in column D: 'Mobile', 'mob', and 'MOBILE' should all become 'mobile'. 'Desktop', 'desk', and 'DESKTOP' should all become 'desktop'. Then for every row where column E says 'UPDATE', update the tracked URL and device type in Keyword.com using the normalized values.
Some rows have new URLs that are relative paths, not absolute URLs
For every row in this sheet where column E says 'UPDATE' and column C starts with '/', prepend 'https://www.example.com' to the value in column C before calling Keyword.com to update the tracked URL. Use the device type in column D and the keyword ID in column A.
You also need to add a new region to 40 keywords at the same time
For every row in this sheet where column E says 'UPDATE', update the tracked URL in Keyword.com to column C and the device type to column D. Then, for every keyword in the sheet where column G says 'ADD-GB', also add 'en-GB' as a tracked region.
Full post-migration update: normalize, update URLs and devices, add region, write status
Normalize column D so all mobile variants become 'mobile' and all desktop variants become 'desktop'. For every row where column E says 'UPDATE', update the tracked URL in Keyword.com to column C and the device type to normalized column D. For rows where column G says 'ADD-GB', also add 'en-GB' as a tracked region. Write 'Done' to column E for successful rows and the error message to column F for any failures.
One prompt handles the normalization, the URL updates, the device changes, and the region additions — the migration mapping sheet becomes the source of truth for the whole operation.
Try It
Get the 7-day free trial of SheetXAI and open your migration mapping sheet, then ask SheetXAI to push the URL and device updates to Keyword.com in one pass. Also see Bulk Import Keywords Into Keyword.com From a Google Sheet or the full Keyword.com + Google Sheets overview.