$date1 = date("Y-m-d H:i:s", strtotime("- 2 day")); // $date2 = date("Y-m-d H:i:s", strtotime("- 1 day")); $date2 = date("Y-m-d H:i:s"); echo $date1 ." ~ ".$date2 ."<br>"; $mng = new MongoDB\Driver\Manager("mongodb://localhost:27017"); $filter = [ 'date' => [ '$gte' => $date1, '$lte' => $date2] ]; $options = [ 'projection' => ['_id' => 0], 'sort' => ['_id' => -1], ]; $query = new MongoDB\Driver\Query($filter, $options); $cursor = $mng->executeQuery('app.na007', $query); foreach ($cursor as $document) { // var_dump($document); $pv[] = $document->date; $cookie[] = $document->cookie; $session[] = $document->session; if(!is_null($document->referrer)){ $referrer = $document->referrer; } } // var_dump($session); $uu = array_unique($cookie); $session = array_unique($session); $bounce = (count($pv) - count($referrer))/ count($pv) * 100; $exit = (count($pv) - count($session))/ count($pv) * 100; echo "<br>Users :".count($uu)."<br>"; echo "Pageviews :".count($pv)."<br>"; echo "Bounce rate :" .sprintf('%.2f',$bounce)."%<br>"; echo "Exit rate:" .sprintf('%.2f',$exit)."%<br>";
直帰率、離脱率のところまで一通りできたので、これをAzureに載せたい。