[ANALYTICS-61] Should support pageSize and filter config in GoogleDataSupplier Created: 18/Apr/19  Updated: 16/May/19  Resolved: 09/May/19

Status: Closed
Project: Analytics
Component/s: None
Affects Version/s: None
Fix Version/s: 1.0

Type: Improvement Priority: Neutral
Reporter: Oanh Thai Hoang Assignee: Oanh Thai Hoang
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: 0d
Time Spent: 1d 4.5h
Original Estimate: Not Specified

Template:
Acceptance criteria:
Empty
Task DoD:
[ ]* Doc/release notes changes? Comment present?
[ ]* Downstream builds green?
[ ]* Solution information and context easily available?
[ ]* Tests
[ ]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Documentation update required:
Yes
Epic Link: Analytics backend
Sprint: Add-Ons 11
Story Points: 3

 Description   

See https://developers.google.com/analytics/devguides/reporting/core/v4/rest/v4/reports/batchGet

I wanna configure filtersExpression or pageSize in Option of ChartDefinition to filtering in GoogleDataSupplier. 

 

We don't support for our GoogleDataSupplier now. MatomoSupplier can configure filtering easily

 

 

 

 



 Comments   
Comment by Oanh Thai Hoang [ 08/May/19 ]

For document:

 

filtersExpression, pageSize, pageToken follows: https://developers.google.com/analytics/devguides/reporting/core/v4/rest/v4/reports/batchGet

filtersExpression: Dimension or metric filters that restrict the data returned for your request. For example, the following expression selects ga:browser dimension which starts with Firefox; ga:browser=~^Firefox.

pageSize: Page size is for paging and specifies the maximum number of returned rows. Page size should be >= 0

pageToken: A continuation token to get the next page of the results. Adding this to the request will return the rows after the pageToken

 

pageSize example configuration:

chartDefinitions:
  line2GA1:
    class: info.magnolia.analytics.amcharts.data.AmChartDefinition
    label: Session by date from GA GA
    dataSupplier: googleSupplier1
    columnDisplays:
      xCategory:
        jsonPath: $.reports[*].data.rows[*].dimensions[*]
        columnType: Category_X
        title: user
      yCategory:
        jsonPath: $.reports[*].data.rows[*].metrics[*].values[*]
        columnType: Value_Y
        title: country
    options:
      - name: viewId
        value: 191451330
      - name: startDate
        value: 30DaysAgo
      - name: endDate
        value: today
      - name: dimensionName
        value: ga:browser
      - name: metricExpression
        value: ga:pageviews
      - name: metricAlias
        value: pageviews
      - name: pageSize
        value: 3 

ex for filtering:

 

    options:
      - name: viewId
        value: 191451330
      - name: startDate
        value: 30DaysAgo
      - name: endDate
        value: today
      - name: dimensionName
        value: ga:browser
      - name: metricExpression
        value: ga:pageviews
      - name: metricAlias
        value: pageviews
      - name: filtersExpression
        value: ga:browser=~^Firefox
 

for pageToken:

 

    options:
      - name: viewId
        value: 191451330
      - name: startDate
        value: 30DaysAgo
      - name: endDate
        value: today
      - name: dimensionName
        value: ga:browser
      - name: metricExpression
        value: ga:pageviews
      - name: metricAlias
        value: pageviews
      - name: pageSize
        value: 3
      - name: pageToken
        value: 4
Generated at Sun Feb 11 23:15:07 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.