🛠️Fixes

Klaviyo Edit Flow – Auto-Generated Columns Now Preserved

What was the issue

Editing Klaviyo integrations sometimes deselected auto-generated columns, causing data gaps in the warehouse.

What we fixed

We have updated the connector to preserve all necessary columns automatically when editing integrations.

Why this matters

Your Klaviyo integrations now reliably load all required data, even after source edits.

Do you need to do anything?

No action required.

TikTok Shop: Orders/Order Statement Transactions Table Data Inaccuracy

What was the issue

Fixed data inaccuracy issues in the TikTok Shop tables, where Orders API occasionally returned a response body without any next page cursor (token required for the next page call) and the 'orders'  key.

What we fixed

During certain date ranges, when the API response contained a total_count greater than zero but no orders and no token, Daton moved forward to the next date range, skipping valid records. To address this, we have added a validation check on total_count and introduced a retry condition.

Why this matters

Resolves missed order records caused by irregular API responses. It also ensures the reliability of data in the Orders and Order Statement Transactions tables.

Do you need to do anything?

No action required

🚀Enhancements

Enhanced AppLovin Connector with Creative Set Details

What was the Issue

Users had limited visibility into performance at the creative set level in AppLovin, making it harder to optimize campaigns and evaluate the effectiveness of different creative variations.

What we fixed

The AppLovin connector now includes two new fields: creative_set (name) and creative_set_id (ID). These fields are accessible via the Reporting API, allowing users to fetch data at a more granular level.

Why this matters

With creative set-level data, users can conduct more precise A/B testing, enhance ad personalization, and optimize ROAS by identifying which creative variations resonate most with their target audiences.

Do you need to do anything?

No action is required. The new fields are automatically available through the Reporting API. Please refer to the updated documentation for details.

SFTP Connector Now Supports SSH Key Authentication

What we improved

We’ve enhanced the SFTP connector to support SSH key authentication, enabling seamless Klaviyo file data ingestion and ensuring compatibility with other services that require SSH keys.

How it works

When you create an SFTP integration, our team generates a public/private SSH key pair:

• The public key is shared with you to update in your source system (e.g., Klaviyo).
• The connector uses the private key to authenticate and automatically manage the connection.
• Self-serve SSH key setup will be available in the upcoming quarters.

Why this matters

This update ensures reliable data transfer without authentication errors and simplifies integration workflows for services requiring SSH key authentication.

What you need to do

For sources that require SSH connectivity, create the integration in Daton and contact our support team. We will generate the SSH key pair, share the public key, and ensure your integration is configured correctly.

Shopify – Product Media Table

What we improved

We’ve added the product_media table to capture all media associated with Shopify products, including images and videos.

How it works

The table retrieves media objects via Shopify’s GraphQL API, including video URLs (MP4 and M3U8), media types (Image and Video), and alt text.

Why this matters

You can now access rich product media directly in your pipeline, enabling better marketing campaigns, enhanced product descriptions, and a more engaging Shopify store experience.

What you need to do

The new table product_media is available under the Shopify connector in Daton. Add it to your integration to start using it.

Subscription: No Usage Carryover on Upgrades

What we improved

When a user upgrades their plan mid-cycle, the company’s usage will now reset immediately, ensuring no usage from the previous plan carries over. This means customers receive the full benefit of their new plan’s limits right away.
Note: Your billing cycle can be monthly or yearly. However, your usage cycle is always monthly—usage is allotted and tracked every month based on your subscription start date. This enhancement is related to the monthly usage limit allotted in a usage cycle. 

How it works

Previously, when a Growth Plan user upgraded mid-cycle, their usage cycle continued unchanged, and any usage from the old plan rolled into the new one for the remaining days of the month. Now, when a user upgrades mid-cycle, the system resets their usage. They immediately gain access to the higher limits and full benefits of the new plan and get relief from any pending usage and overages.

Example: Your usage cycle runs from 1st to 30th September. You are on a 5M rows per month plan and by 15th September, you’ve already used 4M. On the same day, you upgrade to the 10M plan.

• Previously: The 10M plan started on 15th but carried over your 4M usage. You only received 6M additional usage for the rest of the cycle (15th to 30th September).
• Now: When you upgrade on 15th, your usage resets. You get the full 10M limit for the period from 15th to 30th September. 

Why this matters

Upgrading provides instant value. Usage is reset to 0 for the remainder of the billing cycle, allowing users to fully leverage the new plan’s limits without carrying over old usage.

What you need to do

No action required. The user only needs to upgrade. Usage limits reset automatically when a plan is upgraded.

Expanded Status Coverage in Facebook Ads Connector

What we improved

We’ve enhanced the Facebook Ads connector to provide more complete visibility into your ads data by expanding the ad statuses fetched and adding a new filtering option.

How it works

Previously, the ads table included only ads with these statuses:

• ACTIVE
• PAUSED
• ARCHIVED

Now, the ads table includes all statuses supported by the Facebook API, including:

• PENDING_REVIEW
• DISAPPROVED
• PREAPPROVED
• PENDING_BILLING_INFO
• CAMPAIGN_PAUSED
• ADSET_PAUSED
• IN_PROCESS
• WITH_ISSUES

Additionally, we’ve introduced a new column: effective_status, which reflects the current status of each ad. You can use this column to filter your data more flexibly, focusing on the statuses that matter to you.

Note: The DELETED status is not included, as the Facebook API does not support fetching deleted ads.

Why this matters

Your ads table now displays a broader set of ads, providing more comprehensive and accurate reporting. Existing dashboards and reports may display additional ads that were previously excluded if they were limited to ACTIVE, PAUSED, or ARCHIVED.

What you need to do

If you want to focus on specific statuses, add effective_status column in your integrations to filter your data accordingly.

✨New Features