An oddly specific request but here we go — Wanting to automate two numbers from Builtwith.com paid plan to specific columns on a csv — 1st is the total # of website technologies a site uses — 2nd being a total # of technologies *but* only from a curated list we created of about 2k technologies

Category A on our google sheet:

– Total # of website technologies Builtwith.com found from a single company URL

– For context on builtwith, and I shared example below too, but you can search for this number on any site on the internet completely free. We have the paid plan but it's a really easy # to get from builtwith, in otherwords.

Category B:

– We have a list of 2k technologies that we want to know for each URL how many of those 2k technologies are listed underneath that URL

*

*

For more on Builtwith's free site as an example – the stripe.com page list on builtwith.com

Total listed technologies (Category A): 82

Total from our internal list (Category B): 3

– Clearbit

– Applepay

-Contentful

*

*

Anyone that's worked with builtwith's paid service knows there's a few ways to go about getting the information I listed from builtwith

However our requirement and 2 questions are specific to scale of thousands of domains where the results get displayed in specific columns on our CSV

  1. Getting both Category A and Category B #'s to to go in the correct column on the same row as the domain URL (this should be easy if the scale is figured out)
  2. Being able to automate the results to a CSV with Category A and B on a list of thousands of domain URLs

Help is so so much appreciated here it's unbelievable and I thank you for your time

submitted by /u/lololollololol
[link] [comments]

from Software Development – methodologies, techniques, and tools. Covering Agile, RUP, Waterfall + more! https://ift.tt/3mpcPnA

Leave a comment

Design a site like this with WordPress.com
Get started
search previous next tag category expand menu location phone mail time cart zoom edit close