How to Normalize and Count Sitemap URLs for a Company Website

Nick Z. · 2024-01-02T20:58:16.580387+00:00

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!

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?

4 comments