Combining Google Analytics UA and GA4 data

[BobbyO]

Hi all, 

I'm building out a workflow to combine Google Analytics Universal Analytics (UA) and GA4 data, attempting to duplicate the engagement report (pageviews, time on page, avg. session duration) and the events report. I'm using the prep (union, filter, formula) and join (append, find replace) tools. The GA4 connector is not working for me, so I'm connecting to a csv. Is anyone in this community working on solving the same problem? Thanks in advance!

[Raj · Accepted solution]

@BobbyO 
find the document attached this should help
Connect to Google Analytics 4 (GA4) and Extract with Alteryx | Insights Through Data

mark done if solved.