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);
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();