Wiki source code of Connecteur Google Analytics
Last modified by jhurst on 2021/04/21 10:01
Show last authors
author | version | line-number | content |
---|---|---|---|
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 |