Wiki source code of Connecteur Google Analytics

Last modified by jhurst on 2021/04/21 10:01
Show last authors
1
2 {{ddtoc/}}
3
4 = Prerequisites =
5
6 * A Google Analytics account with the authentication information for Digdash (see next point)
7 * Follow the configuration document called « google_analytics_config_en.pdf » to get all the necessary identifiers (service account + .p12 file + Google Analytics’ ID account)
8
9 = Selecting a new datasource =
10
11 DigDash Enterprise allows you to retrieve information from your Google Analytics account.
12
13 Select the type of report you want to work with, in the toolbar at the bottom of the page.
14
15 [[image:google_analytics_connector_en_html_c62fa55dd31b2918.gif||alt="Flèche vers le bas 38"]]
16
17 [[image:google_analytics_connector_en_html_f61e0c2cd230f87d.png||height="141" width="430"]]
18
19
20
21 **OR** click on **New model** in the datasource manager tab and choose **Google Analytics Report**.
22
23 [[image:google_analytics_connector_en_html_c3b1283550702436.png||height="61" width="212"]]
24
25
26 [[image:google_analytics_connector_en_html_bed4999188f03471.png||height="351" width="254"]]
27
28
29 = Authentication =
30
31 Follow the configuration document called “google_analytics_config_en.pdf” and get the information to specify.
32
33 [[image:google_analytics_connector_en_html_881159a76d1b3cbc.gif||alt="Étoile à 8 branches 4"]] [[image:google_analytics_connector_en_html_7e08a691b7c81443.gif||alt="Étoile à 8 branches 4"]] [[image:google_analytics_connector_en_html_c447ffed9054f66b.gif||alt="Étoile à 8 branches 4"]] [[image:google_analytics_connector_en_html_a699fbfe021e0368.gif||alt="Étoile à 8 branches 4"]] [[image:google_analytics_connector_en_html_b2e307e365fd79ba.gif||alt="Étoile à 8 branches 4"]] [[image:google_analytics_connector_en_html_a5a54dcdd0121f9f.gif||alt="Étoile à 8 branches 4"]] Enter this information in the corresponding fields.
34
35 [[image:google_analytics_connector_en_html_b8930da4743e13c2.png||height="299" width="660"]]
36
37
38 //__Screenshot: Interface for authentication and loafing Google analytics objects__//
39
40 [[image:google_analytics_connector_en_html_881159a76d1b3cbc.gif||alt="Étoile à 8 branches 4"]] **Service account**: It is the account name in an email address form that you got at the creation of the service account in the Google Cloud console.
41
42 [[image:google_analytics_connector_en_html_7e08a691b7c81443.gif||alt="Étoile à 8 branches 4"]] **P12 file** : It is the secret key in a .p12 file form generated and that you downloaded at the creation of the service account in the Google Cloud console.
43
44 [[image:google_analytics_connector_en_html_c447ffed9054f66b.gif||alt="Étoile à 8 branches 4"]] **Account ID**: It is the Google Analytics’ account ID you want to work with.
45
46 [[image:google_analytics_connector_en_html_23cefd9b9060368e.gif||alt="Étoile à 8 branches 4"]] **View ID** (post- authentification) : A Google Analytics account can have multiple views, Choose the one you want to work with.
47
48 [[image:google_analytics_connector_en_html_642e927b271436ab.gif||alt="Étoile à 8 branches 4"]] **Time range** (post- authentification): You can get your data for a given time range.
49
50 [[image:google_analytics_connector_en_html_a5a54dcdd0121f9f.gif||alt="Étoile à 8 branches 4"]] **Data representation** (post-authentication): It is in this view that you will get to visualize your Google Analytics metrics and dimensions.
51
52 Once authenticated, click on the button “Load objects” to load information related to you Google Analytics account in Digdash.
53
54
55
56 After loading the objects, you will get this view:
57
58 [[image:google_analytics_connector_en_html_da88dbe1e4519e15.png||height="464" width="554"]]
59
60
61 //__Screenshot: Loading objects after authentication__//
62
63 = Date range =
64
65 You can specify a static period of time to get data related to this time range, mentioning two dates.
66
67 [[image:google_analytics_connector_en_html_e7c1171e6bc213df.png||height="180" width="554"]]
68
69
70 //__Screenshot: Selecting dates to define a static period of time__//
71
72
73 __**Note**__: In Digdash, the end date of a period of time is always excluded. The maximum for the end date is the day after the current day. Example: if you want to get your date from the 1^^st^^ of January 2016 (included) to the 31^^st^^ of January 2016 (included), you will need to mention the 1^^st^^ of January 2016 as start date and the 1^^st^^ of February 2016 as end date.
74
75 = Dimensions and measures =
76
77
78 [[image:google_analytics_connector_en_html_670a789cd21ee598.png||height="331" width="554"]]
79 [[image:google_analytics_connector_en_html_cdabf3a5fee7a975.gif||alt="Connecteur droit 48"]] [[image:google_analytics_connector_en_html_cdabf3a5fee7a975.gif||alt="Connecteur droit 48"]] [[image:google_analytics_connector_en_html_811d54569624bc07.gif||alt="Connecteur droit 50"]] [[image:google_analytics_connector_en_html_db2158d68b48d4a1.gif||alt="Ellipse 51"]] [[image:google_analytics_connector_en_html_afcdd47f93d22ed9.gif||alt="Ellipse 52"]] [[image:google_analytics_connector_en_html_c405236c224745ba.gif||alt="Ellipse 53"]] [[image:google_analytics_connector_en_html_70c302f3c3ce4047.gif||alt="Ellipse 54"]]
80
81
82 //__Screenshot : Description of the interface for metrics/dimensions selection
83 1 : Available measures zone 2 : selected measures zone
84 3 : Available dimensions zone 4 : Selected dimensions zone__//
85
86
87 The top side is related to Google Analytics measures/metrics.
88
89 [[image:google_analytics_connector_en_html_db2158d68b48d4a1.gif||alt="Ellipse 55"]] Measures are on the left side, in categories.
90
91 You can filter on the measures’ names (not the categories) in the search bar.
92
93 [[image:google_analytics_connector_en_html_5523fd29d6ac70da.gif||alt="Ellipse 56"]] You can drag and drop from the left side to the right side to select a measure.
94
95 The bottom side is related to Google Analytics dimensions.
96
97 [[image:google_analytics_connector_en_html_c405236c224745ba.gif||alt="Ellipse 58"]] Dimensions are on the left side, in categories.
98
99 You can filter on the dimensions’ names (not the categories) in the search bar.
100
101 [[image:google_analytics_connector_en_html_70c302f3c3ce4047.gif||alt="Ellipse 59"]] You can drag and drop from the left side to the right side to select a dimension.
102
103
104 [[image:google_analytics_connector_en_html_6243c51239236530.png||height="409" width="248"]]
105
106
107 //__Screenshot: Metrics and dimensions are grouped into categories__//
108
109 == Combinations possibilities ==
110
111 It is possible to combine:
112
113 metrics and dimensions
114
115 only metrics
116
117 It is not possible to have only dimensions, though.
118
119 == Valid combinations ==
120
121 All combinations metrics-dimensions or metrics-metrics are not always valid.
122
123 Digdash is able to give you some hints on the valid combinations.
124
125 You can still go the Google documentation to make sure the combinations of metrics-dimensions you selected are valid.
126
127 __[[https:~~/~~/developers.google.com/analytics/devguides/reporting/core/dimsmets>>url:https://developers.google.com/analytics/devguides/reporting/core/dimsmets]]__
128
129 When selecting a metric or a dimension on the right side, you can see on the left side the non compatible dimensions and metrics with the selected dimension or metric.
130
131 There are three representations for a measure:
132
133 [[image:google_analytics_connector_en_html_c33b15cb62f719e9.png]] Selected measure
134
135 [[image:google_analytics_connector_en_html_a72e9cd82081ca5e.png]] Available measure
136 [[image:google_analytics_connector_en_html_b81c95a1f64cf43f.png]] Non compatible measure with one of the selected columns
137 \\
138
139 There are three representations for a dimension:
140 [[image:google_analytics_connector_en_html_eb775712396c1bbc.png]] Selected dimension
141 [[image:google_analytics_connector_en_html_3199d5cb5b6efc55.png]] Available dimension
142 [[image:google_analytics_connector_en_html_b81c95a1f64cf43f.png]] Non compatible dimension with one of the selected columns
143
144 [[image:google_analytics_connector_en_html_8d76a952a753fff5.png||height="530" width="633"]]
145
146
147 //__Screenshot : When selecting metric **1 Day Active Users **:
148 Among other metrics, measures like **7 Day Active Users**__ __and__ __**14 Day Active Users**__ __are not compatible with the selected metric__ __Among other dimensions, dimensions like__ __**User Type**__ __and__ __**Count of Sessions**__ __are not compatible with the selected metric__//
149
150
151 Digdash lets you select all the columns you want anyways, even invalid. A status icon exist in the interface letting you know that your query might not be valid.
152
153 [[image:google_analytics_connector_en_html_7ae18d7d97055aee.png||height="508" width="605"]]
154 [[image:google_analytics_connector_en_html_46576acb1a47359c.gif||alt="Rectangle 62"]]
155
156 //__Screenshot: Activation of the status icon when Digdash detects incompatibilities between the selected columns__//
157
158 = Advanced options =
159
160 You can configure your Google Analytics data source with more advanced options.
161
162 [[image:google_analytics_connector_en_html_5d287f6d413d713d.png||height="511" width="609"]]
163
164
165 //__Screenshot: Advanced options for Google Analytics datasource__//
166
167 Click on « Advanced options… ».
168
169 The advanced options dialog shows:
170
171 [[image:google_analytics_connector_en_html_bdb7e4a320757b35.png||height="220" width="364"]]
172
173
174 //__Screenshot: Advanced options dialog__//
175
176
177 == Dynamic date range ==
178
179 It is possible for you to define dynamic periods of time mentioning a time frame from the current date.
180
181 To activate this option, select the checkbox “Dynamic date range”.
182
183 [[image:google_analytics_connector_en_html_d31f3ae79b494ad2.png||height="235" width="387"]]
184
185
186 //__Screenshot: Description of the definition of a dynamic date range__//
187
188
189
190 Definition of a dynamic date range:
191
192 * Definition of the **initial date**: it is the current date to which you are **SUBSTRACTING** X steps of time.
193 * Definition of the **end date**: it is the initial date previously defined to which you are **ADDING** Y steps of time.
194
195 With:
196
197 * X and Y two positive integers ≥ 0
198 * steps of time that can be days, months, years.
199
200 == Sampling level ==
201
202 When it comes to non Premium Google Analytics accounts (that are not Google Analytics 360 accounts, free), Google applies a sampling level on the retrieved data to get a faster response. This sampling level has a role on the precison of the returned data.
203
204 You are suggested three options if you own a non Premium Google Analytics account:
205
206 [[image:google_analytics_connector_en_html_14b0cec136f59a43.png||height="209" width="346"]]
207
208
209 //__Screenshot: Description of the different sampling levels__//
210
211
212 * **Default**: returns a response with a sample size that balances speed and accuracy.
213 * **Faster**: returns a fast response with a smaller sample size.
214 * **Higher precision**: returns a more accurate response using a large sample size, but this may result in the response being slower.
215
216