$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);
$ispsMeta = getIsps($mysqli);
$opsMeta = getOps($mysqli);
$browsersMeta = getBrowsers($mysqli);
$socialsMeta = getSocials($mysqli);
$gendersMeta = getGenders($mysqli);
$GLOBALS["metrics"] = getMetrics($mysqli);
$metrics = $GLOBALS["metrics"];
/*
$metadata = $result->body->metadata;
foreach ($metadata as $key => $value) {
//print_r($key.'/');
foreach ($value as $idWeborama => $arrValues) {
//print_r("idWeborama ".$idWeborama.'-');
//print_r($arrValues);
$insertData = "";
$comments["comments"]["content"] = $survey["comments"];
$comments["comments"]["survey_id"] = $survey["survey_id"];
}
foreach ($comments as $comment) {
insertComment($comment);
}
// echo "<!-- Send the transaction and unlock the database. -->\n";
$app->commit();
header("location: /app/");
exit;
break;
// Reviews.
// Reviews.
case "review":
require 'model/audiences.php';
$ages = getAges();
require 'model/genres.php';
$genres = getGenres();
require 'model/games.php';
$games = getGames();
$title = "Comparative Review - Review";
$active = "app";
include '../view/head.php';
include '../view/header.php';
include 'content/video_game_review.php';
break;
case "submit_review":
// echo "<!-- Get the different answers from the form. -->\n";
$review["age_id"] = filter_input(INPUT_POST, "age", FILTER_VALIDATE_INT);
$review["like"] = trim(filter_input(INPUT_POST, "like", FILTER_SANITIZE_STRING));
$review["game"] = trim(filter_input(INPUT_POST, "game", FILTER_SANITIZE_STRING));
$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($connSqlsrv);
$campaignsMeta = getCampaigns($connSqlsrv);
$channelsMeta = getChannels($connSqlsrv);
$projectsMeta = getProjects($connSqlsrv);
$creativesMeta = getCreatives($connSqlsrv);
$adnetworksMeta = getAdnetworks($connSqlsrv);
$insertionsMeta = getInsertions($connSqlsrv);
$agesMeta = getAges($connSqlsrv);
$ispsMeta = getIsps($connSqlsrv);
$opsMeta = getOps($connSqlsrv);
$browsersMeta = getBrowsers($connSqlsrv);
$socialsMeta = getSocials($connSqlsrv);
$gendersMeta = getGenders($connSqlsrv);
$GLOBALS["metrics"] = getMetrics($connSqlsrv);
$metrics = $GLOBALS["metrics"];
$metadata = $result->body->metadata;
foreach ($metadata as $key => $value) {
//print_r($key.'/');
foreach ($value as $idWeborama => $arrValues) {
//print_r("idWeborama ".$idWeborama.'-');
//print_r($arrValues);
$insertData = "";
switch ($key) {
