Video by Leila Gharani on YouTube · 13 min. We did not make this video and we do not host it — watching it here still counts as a view for the creator.
After importing raw GA rows, you’ll need to aggregate sessions by campaign and channel. A common mistake is forgetting the GROUP BY clause, which returns the same number of rows as the source. Use QUERY to sum sessions and rename columns for readability.
Build a new tab called "Summary" that shows total sessions, users, and bounce rate per campaign. This tab will feed the visualisations later.
Sign in with your email, Google or GitHub. No password to remember. The same account carries your progress, your certificates and anything else you do with Nexgino later.
Sign in to continueIt takes about fifteen seconds.