search

📠Account Names to Facility Match using PeeringDB

This playbook uses Google Search, PeeringDB and TableOps

Business question: which organizations have data centers located in a given list of locations?

hashtag
Playbook

Link to the playbookarrow-up-right

circle-exclamation

Please pay attention to the spaces between words in each query. There must be only 1 blank space.

hashtag
1. Search Google to get the correct organization names of the accounts

Cell 2 - Tool: Google Search

Search @1.AccountName on site peeringdb.com/org. If "organic" field has more than one item, then look at the first result. If the first result's title has " - " then return the text before " - ". Otherwise return empty.

Cell 3 - Tool: TableOps

Remove rows where @2.search_account_on_peeringdb is empty. Changing column name @2.search_account_on_peeringdb to corrected_name and return the table.
circle-exclamation

Note that in the table generated by the previous cell, the name of the column might be different, not "search_account_on_peeringdb". Use @ to get the right name.

hashtag
2. Get organization id of the accounts

Cell 4 - Tool: PeeringDB

Get organization whose name contains @3.corrected_name. Sleep 3s between requests.

Cell 5 - Tool: TableOps

Return a table with @4.AccountName , @4.corrected_name and org id with 1 org id per row.

hashtag
3. Get network id of the accounts

Cell 6 - Tool: PeeringDB

Cell 7 - Tool: TableOps

hashtag
4. Get facilities of the networks

Cell 8 - Tool: PeeringDB

Cell 9 - Tool: TableOps

hashtag
5. Match the facility name with some facilities

Cell 10 - Tool: TableOps

hashtag
Notes

circle-exclamation

When the number of rows is large, add this prompt to the query to avoid PeeringDB throttling error message.

"Sleep 3s between requests."

PreviousSales ProspectingNext[Long list] Account Names to Facility Match using PeeringDB

Last updated