mysqli_set_charset($mysqli, 'utf8');
 //echo $mysqli->host_info . "\n";
 $dates = array();
 $startDate = $current = strtotime('2015-05-09');
 $endDate = strtotime('2015-05-09');
 while ($current <= $endDate) {
     $dates[] = date('Y-m-d', $current);
     $current = strtotime('+1 days', $current);
 }
 foreach ($dates as $key => $processDate) {
     //echo '<br> Process DATE: '.$processDate;
     $startDate = $processDate;
     $endDate = $processDate;
     foreach ($dimensions as $key => $value) {
         print_r("---DIMENSIONS---" . json_encode($value));
         $result = $client->get_statistics(array('format' => 'json', 'account_id' => $account_id, 'dimensions' => json_encode($value), 'metrics' => json_encode(array('impression', 'click', 'click_rate', 'reach_impression', 'total_cost', 'confirmed_tracked_conversion', 'expand', 'event', 'average_expand_time', 'pageview', 'average_visibility_time', 'progress_100', 'progress_50', 'user_play', 'close', 'impression_adwords', 'click_adwords', 'cost_adwords', 'bounce_rate', 'average_time_spent_on_site', 'cost_per_pageview')), 'start_date' => $processDate, 'end_date' => $processDate));
         echo '<pre>';
         ////print_r($result->headers);
         //print_r($result);
         //die();
         /*
          ************* METADATA **************
          */
         $adspacesMeta = getAdspaces($mysqli);
         $campaignsMeta = getCampaigns($mysqli);
         $channelsMeta = getChannels($mysqli);
         $projectsMeta = getProjects($mysqli);
         $creativesMeta = getCreatives($mysqli);
         $adnetworksMeta = getAdnetworks($mysqli);
         $insertionsMeta = getInsertions($mysqli);
         $agesMeta = getAges($mysqli);
Esempio n. 2
0
     echo "Fallo al contenctar a MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
 }
 mysqli_set_charset($mysqli, 'utf8');
 echo $mysqli->host_info . "\n";
 $dates = array();
 $startDate = $current = strtotime('2015-02-01');
 $endDate = strtotime('2015-02-26');
 while ($current <= $endDate) {
     $dates[] = date('Y-m-d', $current);
     $current = strtotime('+1 days', $current);
 }
 foreach ($dates as $key => $processDate) {
     echo '<br> Process DATE: ' . $processDate;
     $startDate = $processDate;
     $endDate = $processDate;
     $result = $client->get_statistics(array('format' => 'json', 'account_id' => $account_id, 'dimensions' => json_encode(array('project', 'channel', 'campaign', 'ad_space', 'creative')), 'metrics' => json_encode(array('impression', 'click', 'click_rate')), 'start_date' => $processDate, 'end_date' => $processDate));
     echo '<pre>';
     print_r($result);
     /*
      ************* METADATA **************
      */
     $adspacesMeta = getAdspaces($mysqli);
     $campaignsMeta = getCampaigns($mysqli);
     $channelsMeta = getChannels($mysqli);
     $projectsMeta = getProjects($mysqli);
     $creativesMeta = getCreatives($mysqli);
     $sqlSelect = "SELECT id, label FROM metrics";
     if ($resultado = $mysqli->query($sqlSelect)) {
         /* obtener array asociativo */
         echo '<br> --- METRICS ---<br>';
         $metricsMeta = array();