Google Analytics for Catalog/Cloud

Description

Create an Input component for Talend Cloud Platform to fetch reports from Google Analytics.

More info on GA parameters for reports can be found here:

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

Environment can be setup using:

https://support.google.com/analytics/answer/1008015?hl=en

Demo account is accessible through https://support.google.com/analytics/answer/6367342?hl=en (cannot be reached by the APIs, but useful to manipulate environment).

Acceptance Criteria

• Name: Component name, in the connection, shall be "Google Analytics". Naming in the designer shall be "Google Analytics report".
• Authentication: GA shall support Service Account authentication
• Licensing: EE
• GA shall fetch data from Google Analytics, using following basic settings (required = *):
  • View ID *
  • Start Date * (documentation available here: https://developers.google.com/analytics/devguides/reporting/core/v3/reference#startDate)
  • End Date *
  • Dimensions
    • A list of Dimensions is fetched on demand, matching https://www.googleapis.com/analytics/v3/metadata/ga/columns
      • Dimensions deprecated are excluded
      • Templatized dimensions are excluded (templatized dimensions can be recognized with following parameters in above link "minTemplateIndex" & "maxTemplateIndex")

• • Metrics
    • Default value for Metrics when blank is ga:visits
    • A list of Metrics is fetched on demand, matching https://www.googleapis.com/analytics/v3/metadata/ga/columns
      • Metrics deprecated are excluded
      • Templatized metrics are excluded (templatized metrics can be recognized with following parameters in above link "minTemplateIndex" & "maxTemplateIndex")

• GA shall fetch data from Google Analytics, using following advanced settings (required = *):
  • Advanced metrics
  • Dimension filter clauses
  • Metric filter clauses
  • Filter expression
• GA shall support following Pipeline Configuration:
  • Toggle to enable Resource base quotas
  • Toggle to include empty rows
• All metric types can be read
  • Detail on metrics type can be found here: https://developers.google.com/analytics/devguides/reporting/core/v4/rest/v4/reports/batchGet#MetricType 

DoR

The feature is "Ready" when all DoR check marks are 

Possible status of the checkmarks:

•  ready, complete
•  missing some information
•  not started to complete

Topic	Description	DoR
Description	Is the description enough for all stakeholders?
Acceptance Criteria	Are they defined? Were they validated by PO, Dev and QA?
Jira information	Is the Jira information correct? (fix version, labels, security level)
Environment	Environment ready Support SSL Reachable for QA/Doc/automation(TTP, Junit)
License	Is license EE or SE clearly identified ?
Technical Analysis	Does the developer understand how it will be implemented? Do we have a solution? Approved/discussed with architecture (in-team, global or security, depending on the scope)?
Dependencies	Are all dependencies linked to JIRA (link "depends on")? Are they done? Including SRE/Devops/IT
Migrations	Is migration needed?
Doc	Is DOCT created and linked under the epic?
Communication channel	Is slack feat- created? With all the correct owner involved? (QA/Doc/PO/SM)		#feat-googleanalytics
UX	Are there changes in the UI & were they added in the DOCT? For new forms, was it approved by UX? For new connectors, was a TUX ticket created for a new Icon?