Sessions data not pulling through correctly

[Shanil6]

Hi,

I've been working on transitioning our team data across to GA4.
Currently we use UA to track sessions and transactions data, using custom reports with the relevant fields into our warehouse.

Upon replicating this within the GA4 integration transactions QC'd correctly.
However for sessions there is siginifcant variance between GA4 web version (UI interface) and what is loaded into the stitch table.

We believe this to be an issue with the integration, having exhausted all possible explanations (pulling in the correct fields etc.)
GA4 web has approximately 2x the number of sessions than in Stitch.

We include only UK sessions filtered by country field.

Currently we load a custom report ga_sessions with fields

campaign_id
campaign_name
country
date
engaged_sessions
engagement_rate
landing_page
page_path
session_source
session_source_medium
sessions
sessions_per_user

We use field sessions to aggregate total sessions and have tried other fields like engaged_sessions just to check if it was this field I needed.

From investigation by zoning into sessions per source, medium, campaign and landing page for one day showed some landing pages were not showing in Stitch table but are in GA4 web. See screenshots attached.

Any further investigations into this would be welcomed, thank you.

[ProdigyMaster]

Same here, the numbers between UI and replicated data are diffrent.