"Import finished successfully, but data was truncated" warning

After running a data flow, the following warning is shown:

Data was partially imported because you have exceeded your current plan limit. Import finished successfully, but data was truncated.

Warning samples:

This warning indicates you have hit the Data Volume limit . This limit differs per billing plan. 

There can be an edge case where you receive this warning even when your rows in the destination file are within your limit. Why it happens:

There are 4 stages your data undergoes when you set up an integration in Coupler.io:

• Step 1 - Sources setup 
• Step 2 - Data Sets (Transformations)
• Step 3 - Destinations setup
• Step 4 - Flow Settings

This edge case may happen when you reduce your dataset during step 2 - Data Sets, but your original dataset from step 1 - Sources is bigger.

Coupler.io fetches your data fully based on the parameters you've set in step 1 - Sources setup, before showing your data on step 2 - Data Sets. In the Destinations, you see the data that matches the data in step 2 - Data Sets.

This is why your Data Volume limit is getting reached. Because internally, Coupler.io still uses resources to pull all your data during the first stage. The filter is applied later, in the second stage.

Example scenario:

You are on a plan with a 100 rows/run Data Volume limit. 

You are running 2 Campaigns in Facebook Ads and want to pull insights for 1 Campaign for the last week. On Step 1 - Sources setup, you used only the date settings. On Step 2 - Transformations, you applied a filter by campaign name 

and ran the data flow to a spreadsheet. 

The destination spreadsheet showed 70 rows of data, yet you received the "Import finished successfully, but data was truncated" warning.

Why? Your original dataset before Transformations was 150 rows, as it had data for all your Facebook Ads Campaigns for the past week. 

To not receive this warning, you can apply all filters on Step 1 - Sources setup instead, so your original dataset is under 100 rows. In our example case, you can apply both date filters & filter by campaign name there. 

See more about how to filter Facebook Ads data on Step 1 here.