When using Google Analytics API (PHP Client library - as server to server service) many times it returns empty result set. My code look like this:
public function getLeadDetails($view, $gauid, $lead_id,$refresh_token,$dates = [])
{
Log::info("*****************GA Service - GAUID: ".$gauid." **********************************");
$options['dimensions'] = implode(',',config('analytics.dimensions'));
$options['filters'] = "ga:eventAction==".$gauid;
$metrics = "ga:users";
$view = "ga:".$view;
$yesterday = date('Y-m-d',strtotime('yesterday'));
$tomorrow = date("Y-m-d",strtotime('tomorrow'));
if(count($dates)){
$yesterday = $dates['yesterday'];
$tomorrow = $dates['tomorrow'];
}
Log::info('GA_Service@getLeadDetails(), Request Params: ?ids='.$view.'&start-date='.$yesterday.'&end-date='.$tomorrow.'&metrics='.$metrics.'&dimensions='.$options['dimensions'].'&filters='.$options['filters']);
try{
$this->client->setAccessType('offline');
$this->client->setAccessToken($refresh_token);
$this->client->setClientId(config('analytics.client_id'));
$this->client->setScopes([
\Google_Service_Analytics::ANALYTICS,
\Google_Service_Analytics::ANALYTICS_EDIT,
]);
$analytics = new \Google_Service_Analytics($this->client);
$data = $analytics->data_ga->get($view,$yesterday,$tomorrow,$metrics,$options);
if($data['totalResults'] && $data['totalResults'] > 0){
Log::info('Inside GA_Service@getLeadDetails has totalResults');
$rtn = [];
$i = 0;
foreach ($data['rows'] as $row) {
$rtn['uacid'] = $gauid;
$rtn['user_type'] = $row[0];
$rtn['device_category'] = $row[1];
$rtn['source'] = $row[2];
$rtn['medium'] = $row[3];
$rtn['campaign'] = $row[4];
$rtn['ad_group'] = $row[5];
$rtn['path'] = $row[6];
$i++;
}
Log::info('Inside GA_Service@getLeadDetails lead '.$lead_id.' should be update');
return $this->insertLeadDetails($rtn , $lead_id);
}
Log::info('GA_Service::getLeadDetails() returned empty results for lead: '.$lead_id);
if(!count($dates)){
$this->throwException('empty results for lead: '.$lead_id.' in GA_Service::getLeadDetails()',275);
return false;
}
return 'empty results for lead: '.$lead_id.' in GA_Service::getLeadDetails()';
}catch (\Google_Service_Exception $e){
Log::info('Google service exception from GA_Service::getLeadDetails() - '. $e->getErrors()[0]['message']);
$this->throwException($e->getErrors()[0]['message'], 335);
}
return false;
}
this function fire again every 5 minutes if the result was empty (5 times) and still misses some results.
any idea why and how to resolve it?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire