Join the Community

Efficiently Writing Enriched Person Profile Data to a Table or CSV Export | Clay

Efficiently Writing Enriched Person Profile Data to a Table or CSV Export

·

How do I write a complete dataset of enriched person profile data to another table efficiently and thoroughly? (or export to CSV) Context -- Given the 70 column limit, I can't display very many columns of the enriched person data while still having enough columns to do other transformations and logic. I want to be able to see the data in tabular format (and secondarily, be able to download it). Goal -- I want to create a secondary table to and write all the enrichment data to it. I wish there was a "select all" for adding columns. I'm hoping there is an easier/faster way than choosing each data element individually and then having to manually add a corresponding column. Likewise, I don't know all enriched profiles have the exact same data schema so not sure I would correctly and fully capture everything. Is there an efficient way to accomplish this? Alternatively, is there a way to CSV export the data without having to create the full table in the first place...ie output all enriched cell details directly to CSV?

3 comments

Channeled
APP
·
·
To efficiently handle your enriched person profile data in Clay, you have two main options: 1. Use the "write to table" feature: • Create a new table as your destination. • Use the "write to table" action to transfer data. • Map out the columns you want to copy from the source to the destination table. 2. Export directly to CSV: • Go to 'Actions' > 'Export' > 'Download CSV'. • This will export all data, including hidden columns. • For a cleaner export, create a dedicated "CSV Export View": • a. Duplicate your current view. • b. Include only the columns you need. • c. Export this view to get a focused dataset. Both methods allow you to capture all data elements without the 70-column limit constraint.
Sources: Download as a CSV [Clay 101] - Clay University Write to Other Table | Documentation | Clay University Export and Download a File
Channeled
APP
·
·
Is that what you were looking for?
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 02 Support.