# Data doesn't match between the Source, Coupler preview, and Destination

When pulling data from a Source app, you see that you get different values in the Coupler.io preview (aka "Data sets" step), or in the Destination app after import.

***

### General suggestions <a href="#general-suggestions" id="general-suggestions"></a>

To understand where the issue is -  *in raw data, destination settings, used template, etc. -*  compare the following to understand where the mismatch starts:

* Your original data in the Source app <> data you get in the Destination after Coupler.io import
* Your original data in the Source app <> Preview in Coupler.io ("Data sets" step)
* Preview in Coupler.io ("Data sets" step) <> data you get in Destination after Coupler.io import

#### **Data mismatch between Source <> Coupler.io preview ("Data sets" step)**

Mind that the data shown in the Coupler.io preview ("Data sets" step) is the same data Coupler.io receives from your source app API. If the data in the Data Set doesn't match what you see in your source, please ensure the dataset you're looking at in your source app matches the settings you used in the "Sources" step.&#x20;

For example, consider reviewing these settings:

* **Dates** - you must select the same dates in your source UI and in Coupler.io Source settings
* Same **data entity** - you must select the same data entity or report type -  *e.g., if you are checking the campaign-level stats in your source UI, you must also fetch the campaign-level data in your Coupler.io Source settings*
* Same **columns** - you must check the same columns in your source UI and in Coupler.io
* **Date aggregation** - make sure to select the same date aggregation (Split by) setting in Coupler. E.g. you may be checking daily results in Coupler.io and monthly/totals in Facebook Ads;
* **Filters** you applied both in the "Source" step and "Data sets" step (filter feature) - make sure to select the same filters applied in the UI and on the filters applied in Coupler
* other settings are the same.

{% hint style="info" icon="note" %}
Please note that the **Coupler.io preview ("Data sets" step)** shows the first 500 rows returned by the source app's API only, and you must consider this when comparing the data on the source UI and on the preview.
{% endhint %}

#### **Data mismatch between Source <> Destination**&#x20;

If you see a data mismatch between your Source UI and the Destination app after import with Coupler.io:

1\. Make sure you are looking at the correct destination file. E.g. you might have selected one sheet/report as your destination in Coupler.io, but are looking at a different sheet/report for the result

* Open your data flow >> Run >> follow the green "View results" button after the run is successful. This will open the correct destination file.&#x20;

2\. Open your data flow >> Edit >> go to "Data sets" step >> check if the data there matches your Source data or not.

* If the data in the "Data sets" step is correct (matches your Source data) >> check the settings used in your Destination. E.g. if it's a Looker Studio report you're looking at, make sure you're looking at the same dates, metrics, etc.
* If data in Data sets is not correct (matches your data in Destination and doesn't match your Source data) >> then it's a case with data mismatch between Source <> Coupler.io preview (aka "Data sets" step). Check the corresponding steps from the above section.&#x20;

***

### Source-Specific Data Mismatch Reasons <a href="#facebook-a-ds" id="facebook-a-ds"></a>

Below is a table outlining selected source-specific data mismatch scenarios, along with links to detailed troubleshooting guidance or solutions for each case.&#x20;

For additional scenarios not listed here, please refer to the documentation of your affected source and review its ‘Common Issues’ article.

<table><thead><tr><th width="178.97265625">Source</th><th width="650.1640625">Cases</th></tr></thead><tbody><tr><td>Facebook Ads</td><td><ul><li><a href="https://docs.coupler.io/sources/category/ppc/facebook-ads/common-issues#reach-metric-appears-inflated-in-dashboards">Reach metric appears inflated in dashboards</a></li><li><a href="https://docs.coupler.io/sources/category/ppc/facebook-ads/common-issues#ctr-cpc-cpm-and-other-ratio-metrics-show-incorrect-totals">CTR, CPC, CPM and other ratio metrics show incorrect totals</a></li><li><a href="https://docs.coupler.io/sources/category/ppc/facebook-ads/common-issues#roas-values-are-different">ROAS values are different</a></li><li><a href="https://docs.coupler.io/sources/category/ppc/facebook-ads/common-issues#numbers-dont-match-a-ds-manager">Numbers don't match Ads Manager</a></li><li><a href="https://docs.coupler.io/sources/category/ppc/facebook-ads/common-issues#overinflated-numbers-with-breakdowns">Overinflated numbers with breakdowns</a></li><li><a href="https://docs.coupler.io/sources/category/ppc/facebook-ads/common-issues#daily-vs.-monthly-totals-dont-add-up">Daily vs. monthly totals don't add up</a></li><li><a href="https://docs.coupler.io/sources/category/ppc/facebook-ads/common-issues#filters-hiding-deleted-or-archived-entities">Filters hiding deleted or archived entities</a></li><li><a href="https://docs.coupler.io/sources/category/ppc/facebook-ads/common-issues#conversion-counts-lower-than-a-ds-manager-1-day-engaged-view-attribution">Conversion counts lower than Ads Manager (1-day engaged-view attribution)</a></li></ul></td></tr><tr><td>Tableau</td><td><ul><li><a href="https://docs.coupler.io/sources/category/files-and-tables/tableau/common-issues#data-in-coupler.io-export-differs-from-tableau-visualization">Data in Coupler.io export differs from Tableau visualization</a></li><li><a href="https://docs.coupler.io/sources/category/files-and-tables/tableau/common-issues#only-the-first-tab-sheet-graph-is-exported-on-a-multi-sheet-dashboard">Only the first tab/sheet/graph is exported on a multi-sheet dashboard</a></li><li><a href="https://docs.coupler.io/sources/category/files-and-tables/tableau/common-issues#columns-are-returned-as-rows-under-columns-measure-names-and-measure-values">Columns are returned as rows, under columns "Measure Names" and "Measure Values"</a></li></ul></td></tr><tr><td>TikTok Organic</td><td><ul><li><a href="https://docs.coupler.io/sources/category/social-media/tiktok-public/common-issues#follower-count-in-the-data-doesnt-match-tiktok-app">Follower count in the data doesn't match TikTok app</a></li><li><a href="https://docs.coupler.io/sources/category/social-media/tiktok-public/common-issues#video-view-counts-differ-between-tiktok-and-coupler">Video view counts differ between TikTok and Coupler</a></li><li><a href="https://docs.coupler.io/sources/category/social-media/tiktok-public/common-issues#duplicate-rows-when-using-append-mode">Duplicate rows when using Append mode</a></li><li><a href="https://docs.coupler.io/sources/category/social-media/tiktok-public/common-issues#likes-and-audience_countries-data-latency"><code>likes</code> and <code>audience_countries</code> data latency</a></li><li><a href="https://docs.coupler.io/sources/category/social-media/tiktok-public/common-issues#data-discrepancy-on-shares-field">Data discrepancy on <code>shares</code> field</a></li></ul></td></tr></tbody></table>

***

If you can't identify the data mismatch reason after going through the above troubleshooting steps, [contact our support team](mailto:support@coupler.io) with the following information, and we'll help you troubleshoot further: &#x20;

* Your Coupler.io data flow ID (link);
* Screenshots from the source UI showing the filters (date filters or other settings) applied and the data you're expecting to also get from Coupler.io;
* If possible, share your destination file with the data imported with Coupler.io.