GA4 Data API - How to set multiple dimensions and metrics

Question

I am trying to generate a report using the Data API of GA4. However, I could not manage to add multiple metrics or dimensions to my report builder.

This is how I try to achieve this functionality:

           RunReportRequest request =
                RunReportRequest.newBuilder()
                .setProperty("properties/" + propertyId)
                .addAllDimensions(new ArrayList<Dimension>(Arrays.asList(Dimension.newBuilder().setName("date").build(), Dimension.newBuilder().setName("day").build())))
//                .addDimensions(Dimension.newBuilder().setName("date"))
//                .addMetrics(Metric.newBuilder().setName("totalUsers").setName("screenPageViews"))
                .addAllMetrics(new ArrayList<Metric>(Arrays.asList(Metric.newBuilder().setName("totalUsers").build(), Metric.newBuilder().setName("screenPageViews").build())))
                .addDateRanges(DateRange.newBuilder().setStartDate("yesterday").setEndDate("today"))
                .build();

Any help is appreciated.

I tried to get my report with 2 dimensions and 2 metrics, but instead got it with 1 dimension and 1 metric, which is the first one in both cases.

Answer 1

This is a java and / or filter for what I created,Remember filtering of events and dimensions should be in a compatible way. Log in Here and play with your events, dimensions and metrics to find out.

of course, you can change date range as well.

`GoogleCredentials credentials =
                    GoogleCredentials.fromStream(new FileInputStream(credentialsJsonPath));

            BetaAnalyticsDataSettings betaAnalyticsDataSettings =
                    BetaAnalyticsDataSettings.newBuilder()
                    .setCredentialsProvider(FixedCredentialsProvider.create(credentials))
                    .build();    

            try (BetaAnalyticsDataClient analyticsData =
                    BetaAnalyticsDataClient.create(betaAnalyticsDataSettings)) {



                RunReportRequest request =
                        RunReportRequest.newBuilder()
                        .setProperty("properties/" + your propertyId)
                        .addDateRanges(DateRange.newBuilder().setStartDate("365daysAgo").setEndDate("yesterday"))
                         


                        .addDimensions(Dimension.newBuilder().setName("date")) 
                        .addDimensions(Dimension.newBuilder().setName("eventName"))
                        .addDimensions(Dimension.newBuilder().setName("customEvent:XXXXX")) // instead of XXXXX write your custom dimension
                        .addDimensions(Dimension.newBuilder().setName("fullPageUrl")) // this is not a customised dimension



                        .addMetrics(Metric.newBuilder().setName("eventCount"))
                        .addMetrics(Metric.newBuilder().setName("eventsPerSession"))
                        .addMetrics(Metric.newBuilder().setName("eventValue"))


                        .setDimensionFilter(FilterExpression.newBuilder()
                                .setOrGroup(FilterExpressionList.newBuilder()
                                        .addExpressions(FilterExpression.newBuilder()
                                                .setFilter(Filter.newBuilder()
                                                        .setFieldName("eventName")
                                                        .setStringFilter(Filter.StringFilter.newBuilder()
                                                                .setMatchType(Filter.StringFilter.MatchType.EXACT)
                                                                .setValue("your 1st event to filter"))))  // for example page_view
                                        .addExpressions(FilterExpression.newBuilder()
                                                .setFilter(Filter.newBuilder()
                                                        .setFieldName("eventName")
                                                        .setStringFilter(Filter.StringFilter.newBuilder()
                                                                .setMatchType(Filter.StringFilter.MatchType.EXACT)
                                                                .setValue("your 2nd event")))))
                                
                                
                                
                                
                                .setAndGroup(FilterExpressionList.newBuilder().addExpressions(FilterExpression.newBuilder()
                                                .setFilter(Filter.newBuilder()
                                                        .setFieldName("eventName")
                                                        .setStringFilter(Filter.StringFilter.newBuilder()
                                                                .setMatchType(Filter.StringFilter.MatchType.EXACT)
                                                                .setValue("your 3rd event"))))))

                        .setLimit(100000)
                        .build();

                 
                RunReportResponse response = analyticsData.runReport(request);`

The Request Body as an example could be like this:

property: "properties/write your propertId"
dimensions {
  name: "date"
}
dimensions {
  name: "eventName"
}
dimensions {
  name: "customEvent:category" // my custom dimensions is category that should be written after "customEvent:" 
}
dimensions {
  name: "customEvent:action" // my custom dimensions is action that should be written after "customEvent:" 
}
dimensions {
  name: "customEvent:label" // my custom dimensions is label that should be written after "customEvent:" 
}
metrics {
  name: "eventCount"
}
metrics {
  name: "eventsPerSession"
}
metrics {
  name: "eventValue"
}
date_ranges {
  start_date: "2023-05-22" 
  end_date: "2023-05-23"
}
dimension_filter {
  or_group {
    expressions {
      filter {
        field_name: "eventName"
        string_filter {
          match_type: EXACT
          value: "Something"  
        }
      }
    }
    expressions {
      filter {
        field_name: "eventName"
        string_filter {
          match_type: EXACT
          value: "myCustomEventName " // as an example I wrote my customised event name
        }
      }
    }
    expressions {
      and_group {
        expressions {
          filter {
            field_name: "eventName"
            string_filter {
              match_type: EXACT
              value: "SOMETHING"   
            }
          }
        }
      }
    }
  }
}