Collaborative Filtering on Google Analytics data Reviews
3185 reviews
Alexander W. · Reviewed about 6 years ago
Shidqi Akram H. · Reviewed about 6 years ago
Giannis P. · Reviewed about 6 years ago
Earl D. · Reviewed about 6 years ago
I find it overly complicated
Luis B. · Reviewed about 6 years ago
ZAKARIA L. · Reviewed about 6 years ago
Eddy C. · Reviewed about 6 years ago
Enrico R. · Reviewed about 6 years ago
He L. · Reviewed about 6 years ago
The bigquery was not working. The following error was presented: Forbidden Traceback (most recent call last) <ipython-input-17-866b4cdf5da4> in <module> 39 """ 40 ---> 41 df = bq.query(sql).to_dataframe() 42 df.head() /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/client.py in query(self, query, job_config, job_id, job_id_prefix, location, project, retry, timeout) 2359 job_ref = job._JobReference(job_id, project=project, location=location) 2360 query_job = job.QueryJob(job_ref, query, client=self, job_config=job_config) -> 2361 query_job._begin(retry=retry, timeout=timeout) 2362 2363 return query_job /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/job.py in _begin(self, client, retry, timeout) 3149 3150 try: -> 3151 super(QueryJob, self)._begin(client=client, retry=retry, timeout=timeout) 3152 except exceptions.GoogleCloudError as exc: 3153 exc.message += self._format_for_exception(self.query, self.job_id) /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/job.py in _begin(self, client, retry, timeout) 638 # job has an ID. 639 api_response = client._call_api( --> 640 retry, method="POST", path=path, data=self.to_api_repr(), timeout=timeout 641 ) 642 self._set_properties(api_response) /opt/conda/lib/python3.7/site-packages/google/cloud/bigquery/client.py in _call_api(self, retry, **kwargs) 554 if retry: 555 call = retry(call) --> 556 return call() 557 558 def get_dataset(self, dataset_ref, retry=DEFAULT_RETRY, timeout=None): /opt/conda/lib/python3.7/site-packages/google/api_core/retry.py in retry_wrapped_func(*args, **kwargs) 284 sleep_generator, 285 self._deadline, --> 286 on_error=on_error, 287 ) 288 /opt/conda/lib/python3.7/site-packages/google/api_core/retry.py in retry_target(target, predicate, sleep_generator, deadline, on_error) 182 for sleep in sleep_generator: 183 try: --> 184 return target() 185 186 # pylint: disable=broad-except /opt/conda/lib/python3.7/site-packages/google/cloud/_http.py in api_request(self, method, path, query_params, data, content_type, headers, api_base_url, api_version, expect_json, _target_object, timeout) 421 422 if not 200 <= response.status_code < 300: --> 423 raise exceptions.from_http_response(response) 424 425 if expect_json and response.content: Forbidden: 403 POST https://bigquery.googleapis.com/bigquery/v2/projects/cloud-training-demos/jobs: Access Denied: Project cloud-training-demos: User does not have bigquery.jobs.create permission in project cloud-training-demos. (job ID: a42d42de-74e9-498c-8dbb-5ee816fe01e0) -----Query Job SQL Follows----- | . | . | . | . | . | . | . | . | . | . | . | 1: 2:#standardSQL 3:WITH CTE_visitor_page_content AS ( 4: SELECT 5: fullVisitorID, 6: (SELECT MAX(IF(index=10, value, NULL)) FROM UNNEST(hits.customDimensions)) AS latestContentId, 7: (LEAD(hits.time, 1) OVER (PARTITION BY fullVisitorId ORDER BY hits.time ASC) - hits.time) AS session_duration 8: FROM 9: `cloud-training-demos.GA360_test.ga_sessions_sample`, 10: UNNEST(hits) AS hits 11: WHERE 12: # only include hits on pages 13: hits.type = "PAGE" 14: 15: GROUP BY 16: fullVisitorId, 17: latestContentId, 18: hits.time ) 19: 20:-- Aggregate web stats 21:SELECT 22: fullVisitorID as visitorId, 23: latestContentId as contentId, 24: SUM(session_duration) AS session_duration 25:FROM 26: CTE_visitor_page_content 27:WHERE 28: latestContentId IS NOT NULL 29:GROUP BY 30: fullVisitorID, 31: latestContentId 32:HAVING 33: session_duration > 0 34:ORDER BY 35: latestContentId | . | . | . | . | . | . | . | . | . | . | . |
Lucas T. · Reviewed about 6 years ago
good but tough
Roudabeh G. · Reviewed about 6 years ago
Preethika A. · Reviewed about 6 years ago
Mahmmoud M. · Reviewed about 6 years ago
Madhuri I. · Reviewed about 6 years ago
Paulina M. · Reviewed about 6 years ago
Anas A. · Reviewed about 6 years ago
Revalino J. · Reviewed about 6 years ago
Yilun C. · Reviewed about 6 years ago
Joe A. · Reviewed about 6 years ago
Ade Guntur R. · Reviewed about 6 years ago
LEI W. · Reviewed about 6 years ago
khairul a. · Reviewed about 6 years ago
MOHANAD I. · Reviewed about 6 years ago
MOHANAD I. · Reviewed about 6 years ago
Howard S. · Reviewed about 6 years ago
We do not ensure the published reviews originate from consumers who have purchased or used the products. Reviews are not verified by Google.