[UA] Pivot Tables [Legacy]

You are viewing a legacy article about Universal Analytics. Learn more about Google Analytics 4 replacing Universal Analytics.

You can rearrange the information in the table for certain reports by pivoting your data on a second dimension. For example, let's say that you want to see the bounce rate and number of page views for each landing page, and then compare that data against each campaign. You would set up the following pivot table within the Behavior > Site Content > Landing Pages report.

  1. At top right of the table, select the Pivot graph button icon Pivot button.
    Three new selection menus appear above the table.
  2. From the Pivot by selector (top left of table), select Campaign.
  3. From the two Pivot metrics menus, select Bounce Rate and Pages/Session so those metrics appear alongside each keyword in the table.

Was this helpful?

How can we improve it?
true
Choose your own learning path

Check out google.com/analytics/learn, a new resource to help you get the most out of Google Analytics 4. The new website includes videos, articles, and guided flows, and provides links to the Google Analytics Discord, Blog, YouTube channel, and GitHub repository.

Start learning today!

Search
Clear search
Close search
Google apps
Main menu
16579853736994909553
true
Search Help Center
true
true
true
true
true
69256
true
false