Login to GA4
Go to Explore from the left menu
Start a new exploration
On the left menu on Variables column, add:
DIMENSIONS
Hour
Date
METRICS
Active users
Average session duration
On the left menu on Settings column, add:
ROWS
Hour
Date
VALUES
Active users
Average session duration
The final report will look like this
Note: To extract these values specifically for paid traffic, click the “+” icon next to Segment on the left side and select “Paid traffic” (or any other traffic segment you want). Then, click on Segment comparison and choose Paid traffic (or the segment selected in the previous step) to apply the filter.
