I am using php and mysql. I need to get data from other sites using google sdk api, and most importantly, I do not need to enter the api. without login I need to go get analytical data.
please see below code in which I can get the object "Google_AnalyticsService" and encounter an error while receiving data. He says Login is required ...
require 'apigp/Google_Client.php'; require 'apigp/contrib/Google_PlusService.php'; require 'apigp/contrib/Google_AnalyticsService.php'; date_default_timezone_set('UTC'); $date_beforeonemoth = date("Ymd", mktime(0,0,0,date("m"),date("d")-30,date("Y"))); $date_today = date("Ymd", mktime(0,0,0,date("m"),date("d"),date("Y"))); $google = new Google_Client(); $google->setDeveloperKey('Google AppKey here'); $google->setClientSecret('Google ClientSecretKey here'); $google->setClientId('Google ClientID here'); $analytics = new Google_AnalyticsService($google); $profileURL=""; $pageName=""; $brandId=""; $sql="select * from profiles where APIType='Google Plus'"; $result=mysql_query($sql); while($rs = mysql_fetch_assoc($result)) { $profileURL='https://plus.google.com/105932700878744xxxxxx'; $brandId=4; $pageName=basename($profileURL); $accounts = $analytics->management_accounts->listManagementAccounts(); if(isset($accounts['totalResults'])){ if($accounts['totalResults']>0){ $firstAccountId = $accounts['items'][0]['id']; $webproperties = $analytics->management_webproperties->listManagementWebproperties($firstAccountId); if(count($webproperties['items'])>0){ $firstWebpropertyId = $webproperties['items'][0]['id']; $profiles = $analytics->management_profiles->listManagementProfiles($firstAccountId, $firstWebpropertyId); if (count($profiles['items']) > 0) { $profileId = $profiles['items'][0]['id']; $profileId = $pageName; $results = $analytics->data_ga->get( 'ga:' . $profileId, $date_beforeonemoth, $date_today, 'ga:visits,ga:pageviews,ga:pageviewsPerVisit,ga:avgTimeOnPage,ga:visitBounceRate,ga:percentNewVisits,ga:uniquePageviews', array( 'dimensions' => 'ga:source,ga:keyword,ga:browser,ga:date,ga:month,ga:day,ga:year', 'sort' => '-ga:visits,ga:keyword', // 'filters' => 'ga:medium==organic', 'max-results' => '25')); $visits = ""; $unique_visitors = ""; $pageviews = ""; $pages_visit = ""; $avg_visit_duration = ""; $bounce_rate = ""; $new_visits = ""; echo "<br>".$visits = $results['totalsForAllResults']['ga:visits']; echo "<br>".$unique_visitors = $results['totalsForAllResults']['ga:uniquePageviews']; echo "<br>".$pageviews = $results['totalsForAllResults']['ga:pageviews']; $pages_visit = $results['totalsForAllResults']['ga:pageviewsPerVisit']; $avg_visit_duration = $results['totalsForAllResults']['ga:avgTimeOnPage']; $bounce_rate = $results['totalsForAllResults']['ga:visitBounceRate']; $new_visits = $results['totalsForAllResults']['ga:percentNewVisits']; $profileName = $results['profileInfo']['profileName']; }else{print"No profiles found for this user.";} }else{print"No webproperties found for this user.";} //close webproperties result if condition }else{print"No accounts found for this user.";} //close total result if condition } }
Error:
Fatal error: Throw a "Google_ServiceException" exception with the message "GET call error https://www.googleapis.com/analytics/v3/management/accounts?key=AIzaSyBeh0Aevex7q3iRIY5bV3N9gx0WAkNBMi4 : (401) DAT XTAM Required \\ APP \ ITEM \ apigp \ io \ Google_REST.php: 66 Stack trace: # 0 E: \ xampp \ htdocs \ DATAPOINTS \ apigp \ io \ Google_REST.php (36): Google_REST :: decodeHttpResponse (object (Google_HttpRequest)) # 1 E: \ xampp \ htdocs \ DATAPOINTS \ apigp \ service \ Google_ServiceResource.php (186): Google_REST :: execute (object (Google_HttpRequest)) # 2 E: \ xampp \ htdocs \ DATAPOINTS \ apigp \ contrib \ Google_AnalyticsService.php (13) → __ call ('list', Array) # 3 E: \ xampp \ htdocs \ DATAPOINTS \ anatest.php (33): Google_ManagementAccountsServiceResource-> listManagementAccounts () # 4 {main} selected in E: \ xampp \ htdocs \ DATAPOINTS apigp \ io \ Google_REST.php line 66
How to get analytical data without entering the api?