Klaviyo Fields Beginning With $ Are Missing from the Destination

Issue

Values for Klaviyo fields that begin with a $ symbol are missing from the destination. This occurs when the Klaviyo API returns both a $value field and a Value field for the same property, causing a column naming collision during normalization.

Environment

Connector: Klaviyo

Resolution

To resolve this issue:

1. In Fivetran, create a new Klaviyo connection.
2. In the connection setup form, under Destination schema names, select Source naming.
3. Click Authorize, then Save & Test.

When you use the source naming convention, Fivetran preserves the original Klaviyo API field names instead of applying Fivetran naming rules. This allows fields such as $value and Value to appear as separate columns in your destination.

For more information, see Naming Conventions.

Cause

This issue occurs when you set up a Klaviyo connection to use the Fivetran naming convention and the Klaviyo API returns fields that normalize to the same destination column name.

For example, the API may return both $value and Value for the same property. With Fivetran naming, these fields can both normalize to property_value, causing a column naming collision. As a result, Fivetran syncs one field's values and drops the other, resulting in missing or null values in your destination.