A user macro for Confluence server for integrating Google Data Studio dashboards.

[Vincent Blain]

This user macro give ability to insert a GDS's report into a Confluence page. To see a GDS's report or dashboard in Confluence, don't forget to give access to it in GDS administration. Only user with a valid and activate Google Account can see a GDS's document.

As an embed document, the user can interact with it in Confluence's page, and especially to select the date range or choose another filter in the report.

View on github : https://github.com/v20100v/ConfluenceUserMacro-GoogleDataStudio

Features

Insert and interact with a Google Data Studio's report into a Confluence Page

• Set URL of GoogleDataStudio's report. When the macro is used, it checks if given URL is valid ;
• Set height and widht with pixel or percent ;
• Add border and set its color ;
• Set background color ;

User macro code

• Macro name : google_data_studio_report
• Macro title : Google Data Studio
• Description: Embed Google Data Studio's report or dashboard into a Confluence page.
• Macro body processing: No
• Velocity Template code: view code on github
• Version: 1.0.0
• Last modification: 09/04/2019

User macro parameters

ConfluenceUserMacroGoogleDataStudio uses a lot of different parameters to modify its behavior, define as follows :

## @param GoogleDataStudioUrl:title=URL|type=string|required=true|desc=URL vers le tableau de bord GDS à incorporer (https://datastudio.google.com/embed/reporting/1se-9ZRSukdgQUiRqYTSjT8nFLTV0v8Uq/page/y5MR)
## @param width:title=Largeur|type=string|desc=En pixels ou en pourcentage. Par exemple, 600 ou 80%.|default=100%
## @param height:title=Hauteur|type=string|desc=En pixels ou en pourcentage. Par exemple, 400 ou 50%.|default=400
## @param border:title=Ajoute une bordure|type=boolean|default=false
## @param blocBgColor:title=Couleur de fond du bloc|type=string|desc=Pour changer la couleur de fond.
## @param blocBorderColor:title=Couleur de la bordure du bloc|type=string|desc=Pour changer la couleur de la bordure.

Example usage

To add the GDS's report example https://datastudio.google.com/embed/reporting/1se-9ZRSukdgQUiRqYTSjT8nFLTV0v8Uq/page/y5MR, just fill the form of this macro.

If given URL is valid, we obtain :

And if given URL is not valid, we obtain :