snipplrCallback({"id":45911,"title":"google-analytics-php-example","source":"
  1. <?php<\/span><\/div><\/li>
  2.  <\/div><\/li>
  3. \/\/ include the GAPI class from http:\/\/code.google.com\/p\/gapi-google-analytics-php-interface\/<\/span><\/div><\/li>
  4. require_once<\/span> 'gapi.class.php'<\/span>;<\/span><\/div><\/li>
  5.  <\/div><\/li>
  6. \/\/ login details for the account that has access to analytics reports.<\/span><\/div><\/li>
  7. define<\/span><\/a>(<\/span>'ga_web_email'<\/span>,<\/span> 'you@email.com'<\/span>)<\/span>;<\/span><\/div><\/li>
  8. define<\/span><\/a>(<\/span>'ga_web_pass'<\/span>,<\/span> 'password'<\/span>)<\/span>;<\/span><\/div><\/li>
  9.  <\/div><\/li>
  10. \/\/ use our caching function above to get some results in a nice array<\/span><\/div><\/li>
  11. \/\/ change 123456789 to your google analytics id.<\/span><\/div><\/li>
  12. $data<\/span> =<\/span> get_analytics_data(<\/span>'123456789'<\/span>,<\/span>array<\/span><\/a>(<\/span>'date'<\/span>)<\/span>,<\/span>array<\/span><\/a>(<\/span>'newVisits'<\/span>,<\/span>'visits'<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>
  13. \/\/ output the image:<\/span><\/div><\/li>
  14. output_image(<\/span>$data<\/span>)<\/span>;<\/span><\/div><\/li>
  15.  <\/div><\/li>
  16.  <\/div><\/li>
  17. function<\/span> get_analytics_data(<\/span><\/div><\/li>
  18. \t\t$profile_id<\/span>,<\/span><\/div><\/li>
  19. \t\t$dimensions<\/span>=<\/span>array<\/span><\/a>(<\/span>'browser'<\/span>)<\/span>,<\/span><\/div><\/li>
  20. \t\t$metrics<\/span>=<\/span>array<\/span><\/a>(<\/span>'pageviews'<\/span>,<\/span>'visits'<\/span>,<\/span>'UniquePageviews'<\/span>)<\/span>,<\/span><\/div><\/li>
  21. \t\t$sort<\/span>=<\/span>null<\/span>,<\/span><\/div><\/li>
  22. \t\t$start_date<\/span>=<\/span>null<\/span>,<\/span><\/div><\/li>
  23. \t\t$end_date<\/span>=<\/span>null<\/span><\/div><\/li>
  24. \t)<\/span>{<\/span><\/div><\/li>
  25. \t$cache_id<\/span> =<\/span> md5<\/span><\/a>(<\/span>serialize<\/span><\/a>(<\/span>func_get_args<\/span><\/a>(<\/span>)<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>
  26. \t$return<\/span> =<\/span> false<\/span>;<\/span><\/div><\/li>
  27. \t\/\/ check if the cache item exists.<\/span><\/div><\/li>
  28. \t$temp_folder<\/span> =<\/span> '\/tmp\/ga\/'<\/span>;<\/span><\/div><\/li>
  29. \tif<\/span>(<\/span>!<\/span>is_dir<\/span><\/a>(<\/span>$temp_folder<\/span>)<\/span>)<\/span>mkdir<\/span><\/a>(<\/span>$temp_folder<\/span>)<\/span>;<\/span><\/div><\/li>
  30. \t$filename<\/span> =<\/span> $temp_folder<\/span>.<\/span>$cache_id<\/span>;<\/span><\/div><\/li>
  31. \tif<\/span>(<\/span>is_file<\/span><\/a>(<\/span>$filename<\/span>)<\/span>)<\/span>{<\/span> \/\/ if cache entry exists<\/span><\/div><\/li>
  32. \t\tif<\/span>(<\/span>filemtime<\/span><\/a>(<\/span>$filename<\/span>)<\/span> ><\/span> (<\/span>time<\/span><\/a>(<\/span>)<\/span> -<\/span> 172800<\/span>)<\/span>)<\/span>{<\/span> \/\/ check if it's older than 2 days<\/span><\/div><\/li>
  33. \t\t\t$return<\/span> =<\/span> unserialize<\/span><\/a>(<\/span>file_get_contents<\/span><\/a>(<\/span>$filename<\/span>)<\/span>)<\/span>;<\/span> \/\/ grab the cached content.<\/span><\/div><\/li>
  34. \t\t}<\/span><\/div><\/li>
  35. \t}<\/span><\/div><\/li>
  36. \tif<\/span>(<\/span>!<\/span>$return<\/span>)<\/span>{<\/span><\/div><\/li>
  37. \t\t\/\/ no cache item found, so we grab it via gapi class.<\/span><\/div><\/li>
  38. \t\t$ga<\/span> =<\/span> new<\/span> gapi(<\/span>ga_web_email,<\/span>ga_web_pass)<\/span>;<\/span><\/div><\/li>
  39. \t\tif<\/span>(<\/span>!<\/span>$sort<\/span>)<\/span>$sort<\/span> =<\/span> current<\/span><\/a>(<\/span>$dimensions<\/span>)<\/span>;<\/span><\/div><\/li>
  40. \t\tini_set<\/span><\/a>(<\/span>'display_errors'<\/span>,<\/span>true<\/span>)<\/span>;<\/span><\/div><\/li>
  41. \t\t$ga<\/span>-><\/span>requestReportData<\/span>(<\/span>$profile_id<\/span>,<\/span>$dimensions<\/span>,<\/span>$metrics<\/span>,<\/span>$sort<\/span>,<\/span>null<\/span>,<\/span>$start_date<\/span>,<\/span>$end_date<\/span>,<\/span>null<\/span>,<\/span>100<\/span>)<\/span>;<\/span><\/div><\/li>
  42. \t\t$return<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  43. \t\t$return<\/span>[<\/span>'data'<\/span>]<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  44. \t\tforeach<\/span>(<\/span>$ga<\/span>-><\/span>getResults<\/span>(<\/span>)<\/span> as<\/span> $result<\/span>)<\/span>{<\/span><\/div><\/li>
  45. \t\t\t$data<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  46. \t\t\tforeach<\/span>(<\/span>$dimensions<\/span> as<\/span> $d<\/span>)<\/span>{<\/span><\/div><\/li>
  47. \t\t\t\t$data<\/span>[<\/span>$d<\/span>]<\/span> =<\/span> (<\/span>string)<\/span>$result<\/span>;<\/span><\/div><\/li>
  48. \t\t\t\tforeach<\/span>(<\/span>$metrics<\/span> as<\/span> $m<\/span>)<\/span>{<\/span><\/div><\/li>
  49. \t\t\t\t\t$data<\/span>[<\/span>$m<\/span>]<\/span> =<\/span> $result<\/span>-><\/span>{<\/span>'get'<\/span>.<\/span>$m<\/span>}<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>
  50. \t\t\t\t}<\/span><\/div><\/li>
  51. \t\t\t}<\/span><\/div><\/li>
  52. \t\t\t$return<\/span>[<\/span>'data'<\/span>]<\/span>[<\/span>]<\/span> =<\/span> $data<\/span>;<\/span><\/div><\/li>
  53. \t\t}<\/span><\/div><\/li>
  54. \t\t$return<\/span>[<\/span>'total'<\/span>]<\/span> =<\/span> $ga<\/span>-><\/span>getTotalResults<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>
  55. \t\tforeach<\/span>(<\/span>$metrics<\/span> as<\/span> $m<\/span>)<\/span>{<\/span><\/div><\/li>
  56. \t\t\t$return<\/span>[<\/span>$m<\/span>]<\/span> =<\/span> $ga<\/span>-><\/span>{<\/span>'get'<\/span>.<\/span>$m<\/span>}<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>
  57. \t\t}<\/span><\/div><\/li>
  58. \t\t$return<\/span>[<\/span>'timestamp'<\/span>]<\/span> =<\/span>  $ga<\/span>-><\/span>getUpdated<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>
  59. \t}<\/span><\/div><\/li>
  60. \t\/\/ save cache item.<\/span><\/div><\/li>
  61. \tfile_put_contents<\/span><\/a>(<\/span>$filename<\/span>,<\/span>serialize<\/span><\/a>(<\/span>$return<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>
  62. \treturn<\/span> $return<\/span>;<\/span><\/div><\/li>
  63. }<\/span><\/div><\/li>
  64.  <\/div><\/li>
  65.  <\/div><\/li>
  66. function<\/span> output_image(<\/span>$data<\/span>)<\/span>{<\/span><\/div><\/li>
  67. \t$max_y<\/span> =<\/span> 500<\/span>;<\/span><\/div><\/li>
  68. \t$width<\/span> =<\/span> 640<\/span>;<\/span><\/div><\/li>
  69. \t$height<\/span> =<\/span> 200<\/span>;<\/span><\/div><\/li>
  70. \t$attr<\/span>=<\/span>array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  71. \t$days<\/span> =<\/span> count<\/span><\/a>(<\/span>$data<\/span>[<\/span>'data'<\/span>]<\/span>)<\/span>-<\/span>1<\/span>;<\/span><\/div><\/li>
  72. \t\/\/ work out the width of 1 day<\/span><\/div><\/li>
  73. \t$day_width_percent<\/span> =<\/span> round<\/span><\/a>(<\/span>(<\/span>100<\/span> \/<\/span> $days<\/span>)<\/span>\/<\/span>100<\/span>,<\/span>4<\/span>)<\/span>;<\/span> \/\/ 15% will be 0.15  1% will be 0.01<\/span><\/div><\/li>
  74. \t$half_day_width<\/span> =<\/span> round<\/span><\/a>(<\/span>$day_width_percent<\/span>\/<\/span>2<\/span>,<\/span>4<\/span>)<\/span>;<\/span><\/div><\/li>
  75. \t$attr<\/span>[<\/span>'chxl'<\/span>]<\/span> =<\/span> '1:'<\/span>;<\/span> \/\/ the data point label text.<\/span><\/div><\/li>
  76. \t$attr<\/span>[<\/span>'chxp'<\/span>]<\/span> =<\/span> '1'<\/span>;<\/span> \/\/ the data point label positions.<\/span><\/div><\/li>
  77. \t$attr<\/span>[<\/span>'chxr'<\/span>]<\/span> =<\/span> '0,0,'<\/span>.<\/span>$max_y<\/span>.<\/span>'|1,0,'<\/span>.<\/span>$days<\/span>;<\/span> \/\/ the min\/max data range to graph over the space of the image.<\/span><\/div><\/li>
  78. \t$attr<\/span>[<\/span>'chxt'<\/span>]<\/span> =<\/span> 'y,x'<\/span>;<\/span> \/\/ ?<\/span><\/div><\/li>
  79. \t$attr<\/span>[<\/span>'chs'<\/span>]<\/span> =<\/span> $width<\/span>.<\/span>'x'<\/span>.<\/span>$height<\/span>;<\/span> \/\/ width x height of the image.<\/span><\/div><\/li>
  80. \t$attr<\/span>[<\/span>'cht'<\/span>]<\/span> =<\/span> 'lc'<\/span>;<\/span> \/\/ type of graph<\/span><\/div><\/li>
  81. \t$attr<\/span>[<\/span>'chco'<\/span>]<\/span> =<\/span> '3D7930,FF9900'<\/span>;<\/span> \/\/ colors of the graph lines.<\/span><\/div><\/li>
  82. \t$attr<\/span>[<\/span>'chds'<\/span>]<\/span> =<\/span> '0,'<\/span>.<\/span>$max_y<\/span>.<\/span>',0,'<\/span>.<\/span>$max_y<\/span>.<\/span>''<\/span>;<\/span> \/\/ data range of each data set (0 to 500 each)<\/span><\/div><\/li>
  83. \t$attr<\/span>[<\/span>'chdl'<\/span>]<\/span> =<\/span> 'Visits|New Visits'<\/span>;<\/span> \/\/ labels for each data set<\/span><\/div><\/li>
  84. \t$attr<\/span>[<\/span>'chg'<\/span>]<\/span> =<\/span>  (<\/span>100<\/span>\/<\/span>$days<\/span>)<\/span> .<\/span> ','<\/span> .<\/span> (<\/span>(<\/span>100<\/span>\/<\/span>$max_y<\/span>)<\/span>*<\/span>100<\/span>)<\/span> .<\/span> ',4,1,-'<\/span>.<\/span>(<\/span>$half_day_width<\/span>*<\/span>100<\/span>)<\/span>.<\/span>',0'<\/span>;<\/span> \/\/ (vert,horiz) how many step lines.<\/span><\/div><\/li>
  85. \t$attr<\/span>[<\/span>'chls'<\/span>]<\/span> =<\/span> '2,4,0|1'<\/span>;<\/span> \/\/ ?something about size of lines maybe?<\/span><\/div><\/li>
  86. \t$attr<\/span>[<\/span>'chtt'<\/span>]<\/span> =<\/span> 'Visits vs New Visits over past '<\/span>.<\/span>$data<\/span>[<\/span>'total'<\/span>]<\/span>.<\/span>' days.'<\/span>;<\/span> \/\/ graph label at the top.<\/span><\/div><\/li>
  87. \t\/\/ graph stripes. every saturday and sunday ?<\/span><\/div><\/li>
  88. \t\/\/ work out what day the graph starts on.<\/span><\/div><\/li>
  89. \t$first<\/span> =<\/span> current<\/span><\/a>(<\/span>$data<\/span>[<\/span>'data'<\/span>]<\/span>)<\/span>;<\/span><\/div><\/li>
  90. \t$start_day<\/span> =<\/span> date<\/span><\/a>(<\/span>'N'<\/span>,<\/span>strtotime<\/span><\/a>(<\/span>$first<\/span>[<\/span>'date'<\/span>]<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>
  91. \t\/\/ how big is the first bar?<\/span><\/div><\/li>
  92. \t\/\/ highlight white from first bar to first Saturday (6)<\/span><\/div><\/li>
  93. \t$attr<\/span>[<\/span>'chf'<\/span>]<\/span> =<\/span> 'c,ls,0'<\/span>;<\/span><\/div><\/li>
  94. \t$number_of_days<\/span> =<\/span> 6<\/span> -<\/span> $start_day<\/span>;<\/span><\/div><\/li>
  95. \tif<\/span>(<\/span>$number_of_days<\/span>><\/span>0<\/span>)<\/span>{<\/span><\/div><\/li>
  96. \t\t\/\/ we start with a white bar, because we're starting graph during the week.<\/span><\/div><\/li>
  97. \t\t$color<\/span>=<\/span>'FFFFFF'<\/span>;<\/span><\/div><\/li>
  98. \t\t$attr<\/span>[<\/span>'chf'<\/span>]<\/span> .=<\/span> ','<\/span>.<\/span>$color<\/span>.<\/span>','<\/span>.<\/span>(<\/span>round<\/span><\/a>(<\/span>$number_of_days<\/span>*<\/span>$day_width_percent<\/span>,<\/span>5<\/span>)<\/span>-<\/span>$half_day_width<\/span>)<\/span>;<\/span><\/div><\/li>
  99. \t}<\/span>else<\/span>{<\/span><\/div><\/li>
  100. \t\t\/\/ we're starting graph on a saturday or sunday.<\/span><\/div><\/li>
  101. \t\t$color<\/span>=<\/span>'EFEFEF'<\/span>;<\/span><\/div><\/li>
  102. \t\t$attr<\/span>[<\/span>'chf'<\/span>]<\/span> .=<\/span> ','<\/span>.<\/span>$color<\/span>.<\/span>','<\/span>.<\/span>(<\/span>round<\/span><\/a>(<\/span>(<\/span>8<\/span>-<\/span>6<\/span>)<\/span>*<\/span>$day_width_percent<\/span>,<\/span>5<\/span>)<\/span>-<\/span>$half_day_width<\/span>)<\/span>;<\/span><\/div><\/li>
  103. \t\t\/\/ then we do 5 days white.<\/span><\/div><\/li>
  104. \t\t$attr<\/span>[<\/span>'chf'<\/span>]<\/span> .=<\/span> ',FFFFFF,'<\/span>.<\/span>round<\/span><\/a>(<\/span>5<\/span>*<\/span>$day_width_percent<\/span>,<\/span>5<\/span>)<\/span>;<\/span><\/div><\/li>
  105. \t}<\/span><\/div><\/li>
  106. \t\/\/ loop over for the remaining days, every 7 days different colour.<\/span><\/div><\/li>
  107. \tfor<\/span>(<\/span>$x<\/span>=<\/span>0<\/span>;<\/span>$x<\/span><=<\/span>$days<\/span>;<\/span>$x<\/span>+=<\/span>7<\/span>)<\/span>{<\/span><\/div><\/li>
  108. \t\t\/\/ we're doing 2 days dark for weekend.<\/span><\/div><\/li>
  109. \t\t$attr<\/span>[<\/span>'chf'<\/span>]<\/span> .=<\/span> ',EFEFEF,'<\/span>.<\/span>round<\/span><\/a>(<\/span>2<\/span>*<\/span>$day_width_percent<\/span>,<\/span>5<\/span>)<\/span>;<\/span><\/div><\/li>
  110. \t\t\/\/ we're doing 5 days white.<\/span><\/div><\/li>
  111. \t\t$attr<\/span>[<\/span>'chf'<\/span>]<\/span> .=<\/span> ',FFFFFF,'<\/span>.<\/span>round<\/span><\/a>(<\/span>5<\/span>*<\/span>$day_width_percent<\/span>,<\/span>5<\/span>)<\/span>;<\/span><\/div><\/li>
  112. \t}<\/span><\/div><\/li>
  113.  <\/div><\/li>
  114. \t$p<\/span> =<\/span> $start_day<\/span>;<\/span><\/div><\/li>
  115.  <\/div><\/li>
  116. \t$x<\/span>=<\/span>0<\/span>;<\/span><\/div><\/li>
  117. \t$points1<\/span> =<\/span> $points2<\/span> =<\/span> ''<\/span>;<\/span><\/div><\/li>
  118. \tforeach<\/span>(<\/span>$data<\/span>[<\/span>'data'<\/span>]<\/span> as<\/span> $d<\/span>)<\/span>{<\/span><\/div><\/li>
  119. \t\tif<\/span>(<\/span>$p<\/span>%<\/span>7<\/span>==<\/span>1<\/span>)<\/span>{<\/span><\/div><\/li>
  120. \t\t\t\/\/ every monday put a date.<\/span><\/div><\/li>
  121. \t\t\t$attr<\/span>[<\/span>'chxl'<\/span>]<\/span> .=<\/span> '|Mon'<\/span> .<\/span> date<\/span><\/a>(<\/span>'jM'<\/span>,<\/span>strtotime<\/span><\/a>(<\/span>$d<\/span>[<\/span>'date'<\/span>]<\/span>)<\/span>)<\/span>;<\/span><\/div><\/li>
  122. \t\t\t$attr<\/span>[<\/span>'chxp'<\/span>]<\/span> .=<\/span> ','<\/span> .<\/span> $x<\/span>;<\/span><\/div><\/li>
  123. \t\t}<\/span><\/div><\/li>
  124. \t\t$points1<\/span> .=<\/span> $d<\/span>[<\/span>'visits'<\/span>]<\/span>.<\/span>','<\/span>;<\/span><\/div><\/li>
  125. \t\t$points2<\/span> .=<\/span> $d<\/span>[<\/span>'newVisits'<\/span>]<\/span>.<\/span>','<\/span>;<\/span><\/div><\/li>
  126. \t\t$x<\/span>++;<\/span><\/div><\/li>
  127. \t\t$p<\/span>++;<\/span><\/div><\/li>
  128. \t}<\/span><\/div><\/li>
  129.  <\/div><\/li>
  130. \t$attr<\/span>[<\/span>'chd'<\/span>]<\/span> =<\/span> 't:'<\/span> .<\/span> rtrim<\/span><\/a>(<\/span>$points1<\/span>,<\/span>','<\/span>)<\/span> .<\/span> '|'<\/span> .<\/span> rtrim<\/span><\/a>(<\/span>$points2<\/span>,<\/span>','<\/span>)<\/span>;<\/span><\/div><\/li>
  131. \t?><\/span><\/div><\/li>
  132. \t<img src="http:\/\/chart.apis.google.com\/chart?<?php<\/span> foreach<\/span>(<\/span>$attr<\/span> as<\/span> $k<\/span>=><\/span>$v<\/span>)<\/span> echo<\/span> $k<\/span> .<\/span>'='<\/span>.<\/span>urlencode<\/span><\/a>(<\/span>$v<\/span>)<\/span>.<\/span>'&<\/span><\/div><\/li>
  133. \t'<\/span>;<\/span>?><\/span>" width="<?php<\/span> echo<\/span> $width<\/span>;<\/span>?><\/span>"<\/div><\/li>
  134. \t\t height="<?php<\/span> echo<\/span> $height<\/span>;<\/span>?><\/span>" alt="<?php<\/span> echo<\/span> $attr<\/span>[<\/span>'chtt'<\/span>]<\/span>;<\/span>?><\/span>" \/><\/div><\/li>
  135. <?php<\/span><\/div><\/li>
  136. }<\/span><\/div><\/li>
  137. ?><\/span><\/div><\/li><\/ol><\/pre>","link":"https:\/\/snipplr.com\/view\/45911\/google-analytics-php-example"});