Stephen的SEM博客

写的很不错，国内关于GA API的文章很少，参考了贵博客的文章才得以实现。

stephen,可以说一下，通过GA API获得数据的基础上， 怎样去把数据保存到本地数据库， 然后怎样通过UA新出的User ID功能，用来跟已有的CRM数据库里面的用户表文件打通关联吗？ 简单来说就是怎样让用户的行为数据表和客户关系表打通。谢谢。

业界良心好文章！

最后一步报连接错：
Traceback (most recent call last):
File “hello_analytics_api_v3.py”, line 162, in
main(sys.argv)
File “hello_analytics_api_v3.py”, line 51, in main
scope=’https://www.googleapis.com/auth/analytics.readonly’)
File “D:\software\Python34\lib\site-packages\google_api_python_client-1.5.1-py3.4.egg\googleapiclient\sample_tools.py”, line 90, in init
File “D:\software\Python34\lib\site-packages\oauth2client-2.2.0-py3.4.egg\oauth2client\util.py”, line 135, in positional_wrapper
File “D:\software\Python34\lib\site-packages\oauth2client-2.2.0-py3.4.egg\oauth2client\tools.py”, line 235, in run_flow
File “D:\software\Python34\lib\site-packages\oauth2client-2.2.0-py3.4.egg\oauth2client\util.py”, line 135, in positional_wrapper
File “D:\software\Python34\lib\site-packages\oauth2client-2.2.0-py3.4.egg\oauth2client\client.py”, line 2117, in step2_exchange
File “D:\software\Python34\lib\site-packages\httplib2-0.9.2-py3.4.egg\httplib2\__init__.py”, line 1314, in request
(response, content) = self._request(conn, authority, uri, request_uri, method, body, headers, redirections, cachekey)
File “D:\software\Python34\lib\site-packages\httplib2-0.9.2-py3.4.egg\httplib2\__init__.py”, line 1064, in _request
(response, content) = self._conn_request(conn, request_uri, method, body, headers)
File “D:\software\Python34\lib\site-packages\httplib2-0.9.2-py3.4.egg\httplib2\__init__.py”, line 987, in _conn_request
conn.connect()
File “D:\software\Python34\lib\http\client.py”, line 1279, in connect
super().connect()
File “D:\software\Python34\lib\http\client.py”, line 871, in connect
self.timeout, self.source_address)
File “D:\software\Python34\lib\socket.py”, line 516, in create_connection
raise err
File “D:\software\Python34\lib\socket.py”, line 507, in create_connection
sock.connect(sa)
TimeoutError: [WinError 10060] 由于连接方在一段时间后没有正确答复或连接的主机没有反应，连接尝试失败。

E:\true_tmp\API>

验证成功后再运行报错
Traceback (most recent call last):
File “E:/360Downloads/google-api-python-client-samples-1.2/samples/analytics/hello_analytics_api_v3.py”, line 177, in
main(sys.argv)
File “E:/360Downloads/google-api-python-client-samples-1.2/samples/analytics/hello_analytics_api_v3.py”, line 58, in main
scope=’https://www.googleapis.com/auth/analytics.readonly’)
File “C:\Python27\lib\site-packages\googleapiclient\sample_tools.py”, line 95, in init
service = discovery.build(name, version, http=http)
File “C:\Python27\lib\site-packages\oauth2client\_helpers.py”, line 133, in positional_wrapper
return wrapped(*args, **kwargs)
File “C:\Python27\lib\site-packages\googleapiclient\discovery.py”, line 228, in build
requested_url, discovery_http, cache_discovery, cache)
File “C:\Python27\lib\site-packages\googleapiclient\discovery.py”, line 275, in _retrieve_discovery_doc
resp, content = http.request(actual_url)
File “C:\Python27\lib\site-packages\oauth2client\transport.py”, line 175, in new_request
redirections, connection_type)
File “C:\Python27\lib\site-packages\oauth2client\transport.py”, line 282, in request
connection_type=connection_type)
File “C:\Python27\lib\site-packages\httplib2\__init__.py”, line 1659, in request
(response, content) = self._request(conn, authority, uri, request_uri, method, body, headers, redirections, cachekey)
File “C:\Python27\lib\site-packages\httplib2\__init__.py”, line 1399, in _request
(response, content) = self._conn_request(conn, request_uri, method, body, headers)
File “C:\Python27\lib\site-packages\httplib2\__init__.py”, line 1355, in _conn_request
response = conn.getresponse()
File “C:\Python27\lib\httplib.py”, line 1108, in getresponse
raise ResponseNotReady()
httplib.ResponseNotReady
不知道是什么原因，请楼主帮忙看一下

我按照操作设置了python 但是google 验证点击同意之后，shell里面没有google的数据，好像身份验证没有成功，不知道是不是VPN的问题，vpn需要做什么设置吗