How to Normalize and Count Sitemap URLs for a Company Website

·

I’ve used the [Find Sitemap URLs for a Company Website] enrichment and what I want to do is normalize those results into a new field that is simply a number, i.e. the result might be “3089 Pages Found” and I want a new column called “Total Pages” that would display “3,089.” How would I do that? Thanks!

✅1

4 comments

Nick Z.
·
·
https://app.clay.com/workspaces/183442/tables/t_bv0SFLZYxfhb/views/gv_tREnTcHMZS4a
Clay Team
APP
·
·
Hey Nick, thanks for reaching out! You can use the formula generator to clean up or format other columns, here's an example: https://www.loom.com/share/bbb329dcf708442b9abbdf26e870f596
Clay Team
APP
·
·
Let me know if you run into any issues!
Nick Z.
·
·
Cool. And with those results on the sitemap, would I be able to look for the appearance of a particular word in the URLs list like /blog?