Blank columns in CSV exports typically occur when integration fields show "run condition not met" in Clay or when object fields don't display raw data values.
To fix this, create a dedicated CSV Export View by duplicating your current view, then hide columns you don't need and focus on including only raw values.
If your State column contains complex data or formulas, check if it's referencing an entire object instead of a specific key - you may need to adjust the formula to target the specific data field you want.
Hi Steven - thanks so much for reaching out. To confirm - are you talking about the "Billing State" column?" From what I can see, this is blank within your table currently and checking the parent column it also has a null value there
Is it possible that there's a different state column you were hoping to export out that isn't getting populated?
Ah that makes sense! When you export and have a certain filter set (e.g. billing state as null), your exported list will also show that same behavior, which is why you noticed that column as empty in the export.
Would recommend setting the filter either to "Billing state has results" if you only want the results with that field filled in to be exported.