• Courses
    • Paid courses
    • Course bundles
    • Free courses
  • Blog
  • Resources
    • Youtube channel
    • E-books and Guides
    • GTM Recipes
    • View All Resources
    • GTM Community
    • GA4 community
  • Services
  • About
    • About
    • Contact
  • Login
  • Courses
    • Paid courses
    • Course bundles
    • Free courses
  • Blog
  • Resources
    • Youtube channel
    • E-books and Guides
    • GTM Recipes
    • View All Resources
    • GTM Community
    • GA4 community
  • Services
  • About
    • About
    • Contact
  • Login

March 12, 2025

Free Form Reports in Google Analytics 4 (GA4 Explorations)

Updated: March 12th, 2025

In the Google Analytics 4 interface, you have several options for viewing data (Reports section, Explore, Advertising).

This time, we’ll focus on the Explore (a.k.a. Explorations). It’s the place where you can do ad-hoc analysis and dig deeper into your data. In today’s blog post, I wanted to focus on one particular part of it, Free Form Reports in Google Analytics 4.

Subscribe and Get the Ebook - working with reports in ga4

Table of Contents

– Hide table of contents –

  • Main components
    • Variables
      • Segments
      • Dimensions and metrics
    • Tab settings
      • Segment comparisons
      • Rows
      • Columns
      • Values
      • Filters
    • The Output (report)
  • Example of an Exploration report
    • Order coupon code report
  • Additional things
  • (not set) values in the report
  • Final words

 

Tutorials about other exploration reports in GA4

I have also published several other tutorials that you might find useful:

  • Funnel exploration in Google Analytics 4
  • Path exploration in Google Analytics 4

 

Video tutorial

If you prefer video content, look at this tutorial on my YouTube channel. However, remember that this blog post contains some additional tips (compared to the video).

Note: The GA4 interface has slightly changed since I recorded this video, but the main concept remains valid.

 

#1. Main components

To get started, log in to your Google Analytics 4 property and click Explore on the left sidebar. Then select Free Form (or Blank). If you choose Free Form, you will see a sample report with some configuration. And with Blank, well, you’ll get a blank piece of paper to start from scratch.

The interface in the Explorations is split into three main parts/columns:

  1. Variables
  2. Tab settings
  3. The output (the report that is generated based on your configuration)

Let’s take a closer look at each part.

 

#1.1. Variables

This has nothing to do with Google Tag Manager’s variables. The Variables section in the GA4 Free Form reports is the place where you select data that you plan to use in a report:

  • Date range
  • Segments
  • Dimensions
  • Metrics

Also, you can change the name of the analysis in the top-left corner of the interface.

To select a different date range, click the date in the top-left corner (below the analysis name) and select whatever you need (like “last 7 days”, “Last 30 days”, etc.).

 

#1.1.1. Segments

If you want to compare how different groups of your users/visitors are behaving, you should include those segments in the Segments section first (I will later show how to add them to the actual report).

You can choose from several segments that are already included, or you can add your own. You can do that by clicking the plus icon:

Then you can either create a custom segment or select a suggested one.

segments in google analytics 4 analysis hub

Speaking of custom segments, there are three types:

  • User segment where you can include data of all users that match certain user criteria. Example: show all events of users who are from the US. This is equivalent to user segments in Universal Analytics.
  • Session segment where you can include data of sessions that match certain criteria. Example: show all events of sessions where visitors downloaded an ebook. This is equivalent to session segments in Universal Analytics.
  • Event segment where you include ONLY events based on certain criteria. This was not available in Universal Analytics. Example: Show data of all events that are lead_generated.

 

#1.1.2. Dimensions and metrics

Dimensions in Google Analytics are parameters/attributes of an event, product, transaction, user, etc. Basically, they are attributes that describe something. For example:

  • Event name
  • Transaction ID
  • User’s pricing plan
  • Product category, etc.

Metrics help us measure. For example, how many events were made yesterday, how many transactions were completed last week, what the key event rate was last month, etc.

Speaking of the actual metric names (and examples) that you can find in GA4, here are some examples:

  • Event count
  • Number of active users
  • Number of transactions
  • Engagement rate

Now that we have some very basic information, here’s the catch in the Explorations. If you want to use a metric or a dimension in any analysis technique within that report, you have to include the dimension/metric in the Variables column first. You can do that by clicking the Plus icon and then selecting what you need.

After you select the needed metric/dimension, click the Apply button in the top-right corner.

add dimensions to ga4 analysis hub

By the way, some analysis techniques might not allow you to use certain parts of the Variables column. Example: Funnel report does not allow to include/use metrics.

To sum up, the Variables column is responsible for the data input. If you want to use some segments/metrics/dimensions, they must be included in that column. If you are missing something later down the line, you can add new items on-the-fly. Also, you can change the date range (which, obviously, also affects the scope of data input).

 

#1.2. Tab settings

In this column, you can configure what the report will look like. First, there is a Technique drop-down menu (where you can select from things like Free Form, Funnel Exploration, etc.). In this blog post, I focus only on the Free Form part.

Then you will find the visualization section where you can select from:

  • Table
  • Donut chart
  • Line chart
  • Scatterplot
  • Bar chart
  • Geo map

Each visualization method affects which customization options will be available in that very same column. I usually find myself working with the Table, thus it will get most of my attention in this blog post.

But before that, let me briefly mention some unique settings available in the Line Chart.

Line chart allows you to select the level of granularity (hour, day, week, month). Also, by default, anomaly detection is enabled. This means that you can quickly see if something is not right. There are even two ways you can tweak it:

  • Training period (the longer the period, the more data will be taken into account while calculating the expected value). That’s why I set higher values here.
  • Sensitivity. The higher it is, the narrower the area of the expected value will be.

anomaly detection in google analytics 4 exploration report

Now back to the Table visualization.

Subscribe and Get the Ebook - Mastering GA4 event tracking

#1.2.1. Segment comparisons

In the Segment comparisons section, you can include up to 4 segments that are already included in the Segments section of the Variables tab.

You can add segments to the Tab Settings column by dragging them from the Variables tab. Also, you can just do double-click in the Variables tab and they will be added automatically.

If you have at least one segment added to the comparisons section, a new field will appear, Pivot. This field is responsible for the placement of segments in the table. It offers 4 options: first row, last row, first column, last column. To better explain the difference, let me show you an example.

I have a Free Form report where:

  • Two segments are selected: US visitors and Non-US visitors
  • Browser dimension is in the Rows section
  • Device category dimension is in the Columns section
  • Active users is the only metric

All other settings are default. Now I will show you 4 different screenshots. One for each pivot option.

Pivot – first row. The segment is displayed first in every row.

Pivot – last row. Segment comes last after all dimensions in a row.

Pivot – first column. A segment is visible in the first row in each column.

Pivot – last column. The segment name is visible below all dimensions in every column.

 

#1.2.2. Rows

Here you can decide which dimensions you want to use in the rows of the table. In the screenshot below, you will see what the report looks like when the Browser dimension is inserted in the Rows section. Every row of that report contains a different browser name.

If you want, you can include multiple dimensions as rows. Then different combinations of all dimensions will be displayed as a separate row. Here’s an example of a report where I have device category and browser as two Row dimensions.

Also, you can select from which row to start and how many rows to display at the same time.

If you work with multiple dimensions, consider switching to nested rows.

Remember my previous report example with two dimensions, browser and device category? Both dimensions were displayed in the same row. If you switch to nested rows, it will look like this:

 

#1.2.3. Columns

Then you can also add dimensions as columns. Let’s continue the example of browsers and device categories. If I dragged the device category dimension from Rows to Columns, the report would look like this:

Now, every device category has its own column.

Additionally, you can choose which column you want to start displaying data.

Also, you can select the maximum number of columns per single dimension. For example, if a dimension has 10 unique values but you set the Show column groups to 5, only the first five dimensions will be displayed.

 

#1.2.4. Values

Here you can drag metrics that you want to display as columns in the report. The maximum number of metrics added to the Values section of a single report (tab) is 10.

Also, you can select the cell type:

  • Bar chart (this will show horizontal bar charts in every metric cell based on its value and the ratio to other rows in the same column)
  • Plain text (this will display all cells without any additional visual enhancements)
  • Heat map (this will color cells darker if their values are higher compared to other rows of the same dimension column)

 

#1.2.5. Filters

Here you can quickly narrow down the scope of data you are using. For example, maybe you want to exclude a certain event from the report? Then you can click on the placeholder and select the dimension that you are going to use in the filter.

filter in google analytics 4 exploration report

Let’s say that I have a report of events and I want to exclude scrolling events. In that case, I would have to select Event name exactly matches scroll (or whatever name you use for that event).

If multiple filters are included in the report, ALL of them apply to the data.

 

#1.3. The Output (report)

Once you configure all the necessary things in the Variables and Tab Settings columns, the report should appear. Here you can do several things.

Add new tabs if needed. Every tab can use a different analysis technique (free form, funnel exploration, etc.). Also, duplicate and delete them by clicking the Triangle icon next to a tab name:

Start over, undo, redo, share the report, download report:

Click the metric label to change the sorting:

Do the right-click on a cell to see additional options:

  1. Include selection
  2. Exclude selection
  3. Create segment from selection
  4. View users (in User Explorer report)

Include only selection will add an Include filter (or multiple filters if needed) to the report based on which cell did you click. For example, you can quickly narrow down your report to users, events, etc.

Exclude selection will add an Exclude filter (or multiple filters if needed) to the report based on which cell did you click.

If you accidentally included or excluded selection, you can delete those newly added filters from the Filters section in the Tab Settings column. Or you can click the Undo icon in the top-left corner of the report.

If you click the Create segment option, you will see an interface of segment creation will some conditions will be prefilled.

View users option will open a user explorer report with users that belong to that particular selection. In my screenshot, that option is disabled because I was working with the official GA4 demo account where this feature is not available.

 

#2. Example of a Free Form exploration in Google Analytics 4

Let’s create a sample report that will help you better understand how Free Form exploration (with Table visualization) works.

 

#2.1. Order coupon code report

If you have implemented Ecommerce tracking in Google Analytics 4, you might be tracking not only purchases but also order coupons that were used at checkout. If you want to see the report of coupon codes in GA4, here’s what you could do.

This report will show the list of coupon codes that were used and the total value of all orders where those coupons were applied.

Obviously, keep in mind that Google Analytics reports will not be as accurate as your payment gateway’s reports or something else that allows you to view the data in the backend.

So here are the settings of the order coupon code report in GA4:

  • Technique: Free Form
  • Visualization: Table
  • Segment comparisons: None
  • Rows: Order coupon (you will need to add it to the Variables column)
  • Values: Transactions, Total Revenue
  • Filters: Event name exactly matches purchase
  • Then you might see a lot of (not set) values. Right-click on them and select Exclude selection. This will automatically create an additional filter Order coupon does not exactly match (not set)

 

#3. Additional things

Some of the following tips were already mentioned in this guide, but I just wanted to quickly remind you about them.

  • If you go too far with the report and want to quickly start from scratch, click Start over in the top-right corner of the exploration.
  • Want to undo one change? Use the undo button (arrow back) in the top-right corner of the Exploration. Undid too much? Click the redo button (arrow forward).
  • By default, your Explorations are visible only to you. If you want to share the report (with Read-only permissions), click the Share icon in the top-right corner. Then, other users who have access to the property will be able to see it as well (but not edit it) in the list of Explorations. If you want to make changes to a report (created by someone else), you will have to duplicate the report first.
  • A green shield in the top-right corner means no sampling was applied to the report. If the shield is yellow, then sampling has kicked in.
  • If you want to unshare the report that is already shared, in the top right corner, you will see an un-share icon. You can also go to the list of all Explorations, click three dots next to that report, and then un-share.
  • Double-click on a segment/dimension/metric in the Variables tab, and it will be automatically added to the Tab Settings column.
  • Drag a segment/dimension/metric over another metric (in the Tab Settings tab) and it will be replaced.
  • Remember to right-click on the actual report to see what options are available. This applies not only to the Exploration reports.

 

#4. Seeing (not set) values in GA4 reports?

Also, it’s likely that once you build the report, you will see some mysterious (not set) value in one of the rows. There are various reasons for that. If you want to troubleshoot the (not set) issue, read this guide.

 

Free Form reports in Google Analytics 4: Final words

I hope that you are now more familiar with the Free Form reports in Google Analytics 4. It can definitely be tricky to get started (especially if you are not experienced with doing ad-hoc reports), but practice makes it perfect.

Eventually, you will get used to it. Also, I really hope that in the future, we will have a community template gallery for reports in the Explore section. That would save us a lot of time. If you are reading this paragraph and you already have the community template gallery, well, then good for you 🙂 I wish I had it sooner.

 

Julius Fedorovicius
In Google Analytics Tips
22 COMMENTS
Eva
  • Feb 9 2021
  • Reply

Very useful, easy to follow and well-illustrated guide, thank you Julius.
The "landing pages report" is handy, and I was looking into adding the "Content Group" dimension. But its output appears as "not set" .
How can I configure "content groups" in GA4 - it does not seem to be a similar functionality to what is available in Universal analytics account "View" level.
thanks

    Julius
    • Feb 9 2021
    • Reply

    It is still unknown what that dimension is in the interface. But most likely, you will have just have to use some custom parameter (like content_group) and come up with your own structure.

Ilia
  • Feb 20 2021
  • Reply

Hello! Thanks for answer. How to pass data in GA4 utm parameters? utm_content, utm_source, utm_medium, utm_term, utm_campaign in view in reports?

    Julius Fedorovicius
    • Feb 20 2021
    • Reply

    utm_term and utm_content is not available in reports (yet). As for other utms, I would recommend sticking with Universal Analytics. GA4 still sucks for anything related to traffic sources. I mean, you are much more limited than in Universal Analytics.

Thekra
  • Jun 22 2022
  • Reply

Hello, thank you for everything you do for us newbies Julius!

I searched everywhere and I can't find an Answer, is there a way for us to get exploration reports to reflect the custom tags we create using GTM?

    Julius Fedorovicius
    • Jul 13 2022
    • Reply

    Only if you manually send tag names with each tag as a custom dimension

James
  • Nov 22 2022
  • Reply

Does explorations only let you use the past 90 days of data? I just tried to run an older report and it told me I had to update the dates. Is this a setting I can change?

    Julius Fedorovicius
    • Nov 23 2022
    • Reply

    You need to change the data retention settings in the property

Jenn
  • Nov 23 2022
  • Reply

I need assistance setting up promo code tracking. I have multiple events set up but none of them are triggering when a promotional code is used. Can you provide one on one assistance with my account?

    Julius Fedorovicius
    • Nov 24 2022
    • Reply

    Hi, a paid one-on-one troubleshooting call can be booked here analyticsmania.com/call

Illarion
  • Mar 16 2023
  • Reply

Your table is sorted by active user count. Can the table be sorted by city names?
IOW,
Bengaluru 650
Berlin 739
...
Thanks!

Annie
  • Apr 9 2023
  • Reply

I need this too.

Understanding traffic rates by the city is much more critical to our multi-location/ local SEO efforts.

In addition to this kind of report, I'm still unclear on understanding engagement rate by source/medium. How can this report be generated?

Jeanet
  • Apr 14 2023
  • Reply

Hi Julius

I'm doing an exploration report where I need the dates to come in the right order in the table and not sorted by the metric I'm using, which means that the dates are order by the day with most or least traffic. I can't seem to get the sorting arrow on the dates, isn't that possible? I've also tried using the different date dimensions.

Olivia
  • Apr 18 2023
  • Reply

I'm setting up a freeform report, but I can't apply both Item name (dimension) and event count, conversions, total revenue, e-commerce revenue, add to baskets etc (metrics). Is this something you've encountered and found a solution for?

Samantha Strachan
  • Jun 2 2023
  • Reply

This is a great tutorial! I currently have my event name in the column rows but want to reorganize the events in a different order across the top. Is it possible to move these around to be in a different order other than by results?

James
  • Jun 7 2023
  • Reply

The Free-form explorations exclude rows with 0 values, like there is a default filter of "exclude =0"

Is there a way to make these show?
I am building an exploration showing number of conversions/event name for each Source/Medium (similar to a custom report I set up in UA), so I want to see which of my acquisition sources have no conversions.

I have already switched Reporting Identity to "Device-based" to stop the threshold issue, so that isn't causing the problem.

Martin
  • Jun 19 2023
  • Reply

Hi, Julius Fedorovicius! This in-depth exploration of reports in Google Analytics 4 was truly insightful. The step-by-step approach and practical examples made it easy to grasp the concepts. I appreciate your expertise in this area. But I want to ask one thing that How can the new features in Google Analytics 4 help businesses make more informed data-driven decisions?

Hobbie
  • Jun 19 2023
  • Reply

Thank you for sharing your knowledge. Could you explain how Google Analytics 4 differs from Universal Analytics and how businesses can benefit from transitioning to the new version?

Anto
  • Jun 29 2023
  • Reply

Hi, Julius, any reasons why my free-form shows troubleshooting? I have activated google signals and Identity for Reporting is based on Devide ID.

    Julius Fedorovicius
    • Jun 29 2023
    • Reply

    You probably mean thresholding. Maybe your report includes demographics data.

    Sometimes that warning still persists. but check the report - if you see rows with small numbers, you should be ok.

Aastha Goel
  • Aug 3 2023
  • Reply

Hi, I created free form reports but want to export it to dashboard style. Is there a way it is possible? Pls let me know! Thanks

Mary
  • Nov 1 2023
  • Reply

Thank you. So useful like always

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *


 

Hi, I'm Julius Fedorovicius and I'm here to help you learn Google Tag Manager and Google Analytics. Join thousands of other digital marketers and digital analysts in this exciting journey. Read more
Analytics Mania
  • Google Tag Manager Courses
  • Google Tag Manager Recipes
  • Google Tag Manager Resources
  • Google Tag Manager Community
  • Login to courses
Follow Analytics Mania
  • Subscribe to newsletter
Recent Posts
  • Google Tag Manager Server-Side Tagging with Stape
  • How to Preserve Ad Click IDs with Server-side Tagging
  • LinkedIn Conversions API with Google Tag Manager. The Guide.
Analytics Mania - Google Tag Manager and Google Analytics Blog | Privacy Policy
Manage Cookie Settings