Filter Formatting

[skibradshaw]

I am using the ->get method on Analytics to customize specific GA4 Queries. Does anyone know what the filter format should be? The sixth parameter in the Analytics::get() method is a FilterExpression $dimensionFilter but no where can I find the format for these filters. Any help would be greatly appreciated!

[polearnik]

$dimensionFilter = new FilterExpression([
			'filter' => new Filter([
				'field_name'    => 'fullPageUrl',
				'string_filter' => new StringFilter([
					'match_type' => MatchType::CONTAINS,
					'value'      => $request->site,
				]),
			]),
		]);

[ahmadharminto]

is it possible to use multiple filter expressions here?

[roarkmccolgan]

Yes:

$filters = 'filters' => new FilterExpression([
                'and_group' => new FilterExpressionList([
                    'expressions' => [
                        new FilterExpression([
                            'filter' => new Filter([
                                'field_name' => 'hostName',
                                'string_filter' => new StringFilter([
                                    'match_type' => MatchType::EXACT,
                                    'value' => 'yourhostname',
                                ]),
                            ]),
                        ]),
                        new FilterExpression([
                            'not_expression' => new FilterExpression([
                                'filter' => new Filter([
                                    'field_name' => 'pageReferrer',
                                    'string_filter' => new StringFilter([
                                        'match_type' => MatchType::CONTAINS,
                                        'value' => 'mustnothavethisin',
                                    ]),
                                ]),
                            ]),
                        ]),                    
                    ],
                ]),
            ])

[DmitrySidorenkoShim]

and one example with 'or_group' FilterExpression
maybe it will save some time for whom want to use it 😄

            $interval = 7; // days for Period

            $analyticsData = Analytics::get(
                Period::days($interval),
                ['screenPageViews'],
                ['pagePath'],
                100,
                [
                    OrderBy::metric('screenPageViews', true),
                ],
                0,
                new FilterExpression([
                    'or_group' => new FilterExpressionList([
                        'expressions' => [
                            new FilterExpression([
                                'filter' => new Filter([
                                    'field_name' => 'pagePath',
                                    'string_filter' => new StringFilter([
                                        'match_type' => MatchType::BEGINS_WITH,
                                        'value' => '<yourFilter1>',
                                    ]),
                                ]),
                            ]),
                            new FilterExpression([
                                'filter' => new Filter([
                                    'field_name' => 'pagePath',
                                    'string_filter' => new StringFilter([
                                        'match_type' => MatchType::BEGINS_WITH,
                                        'value' => '<yourFilter2>',
                                    ]),
                                ]),
                            ]),
                        ]
                    ]),
                ])
            );