Building a Simple Company Scoring Model Using Leadforensics Data

·Jun 06, 2025 12:25 AM·

Hi! I want to build a very simple account/company scoring model using de-anonymized website data from leadforensics. The scoring model will be simple since this is mostly an exercise in learning to use Clay.

i have data being piped into an Activities table. it contains company name, URL, pages visited, page count, etc...
I figure i should create a table that contains unique accounts that will have the account identifier (website URL), name of account, and the score
Should i be copying rows into a Accounts table? How do I even do this?

There needs to be a process that dedupes accounts
A process to increment a score based on pages visited, e.g. +1 for a page, +2 for higher value page

Any guidance is greatly appreciated!

2 comments

· Sorted by Oldest

Channeled
APP
·
·
To create a deduplicated Accounts table from your Activities data: 1. Use the "write to table" integration to transfer your company/URL data from Activities to a new Accounts table. 2. Enable auto-dedupe on your Accounts table: • Click the Auto-dedupe icon at the bottom right • Select "Enable automatic deduplication" • Choose the URL column as your deduplication key • Click "Save Changes" 3. For scoring, add a Formula column to your Accounts table: • Create conditional formulas that add points based on pages visited • Example: IF(contains([Page Visited], "pricing"), 2, IF(contains([Page Visited], "homepage"), 1, 0)) You can also manually dedupe by right-clicking a column and selecting "Dedupe > Delete Duplicate Row".
Sources: Lead scoring overview | Documentation | Clay University Table management settings | Documentation | Clay University Table columns | Documentation | Clay University Auto-update and Auto-dedupe Table
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.

Building a Simple Company Scoring Model Using Leadforensics Data | Clay