We have connected LinkedIn Ads, google Ads and Google Anallytics with Google Big Query through Skyvia. We are facing following issues in the 3 connectors:
Google Big Query is showing 53 campaign while in actual/source there are 40 campaigns. There are 12 campaign groups in actual/source while Google Big Query shows 16 and one of the 12 is not there in Big Query.
The number of capmpaigns in source and destination is correct and matches (8) but the details of the campaigns are not fetched/copied. Many datasets are empty or have shown "Object Error"
Slight differences are observed in data values throughout the datasets. e.g. On Nov 17 there are shown 8 users from Pakistan in Google Big Query while in source they are 11. The trend is same for many dates. Also, bounce rate is shown 44% while source shows it to be 51.755.
Please guide about what can be the underlying reasons for the inaccuracies and incompleteness of data and how can they be coorrected.
Images also attached along for values written during validation check.