geronimod

--- !ruby/object:ChartCampaignRollup 
attributes: 
  folder_count: \"1\"
  rollupable_id: \"1\"
  updated_at: 2013-04-15 13:30:53
  view_growth: \"148082\"
  rating_count: \"143152\"
  comment_count: \"29681\"
  name: Asset
  placement_growth: \"100\"

geronimod

 "Weeks on Chart" => ["Creative Agency Chart"]

 "Last Month's Rank" => ["Brand Chart"]

 "Views" => ["Variety Top Movies Chart", "Mashable Web Series ", "Visible Measures 100 Million Views Club", "Film Trailer Collection", "Video Games", "Political Ads", "Automotive News Chart"]

 "Demographic Pool Size" => ["Film Trailer Collection", "Video Games"]

 "Total Views" => ["Viral Video Collection", "Film Trailer Collection", "Super Bowl Collection", "Video Games", "Brand Chart", "Creative Agency Chart"]

geronimod

Ad Age Viral Video Chart
[Rank, Last Week's Rank, Brand, Campaign Name, Campaign ID, Agency, Placements, Current Week Views, Comments, Ratings, % Change in Views, Cumulative Views, Sparkline, Image, Video Url]

Variety Top Movies Chart
[Rank, Last Week's Rank, Campaign Name, Campaign ID, Studio, Genre, Placements, Views, Comments, Ratings, Weeks To Release, % Change in Views, Sparkline, Image, Video Url] 

Mashable Web Series 
[Rank, Last Week's Rank, Campaign Name, Campaign ID, Studio, Genre, Placements, Views, Comments, Ratings, % Change in Views, Sparkline, Image, Video Url] 

Visible Measures 100 Million Views Club

geronimod

SELECT distinct_clips.campaign_id, arizona_fill_clip.pk as clipKey, distinct_clips.clip_cat_id as category_id, distinct_clips.folder_type_id as folder_type_id, day, viewDelta as views, commentDelta as comments, rateDelta as ratings
        FROM arizona_fill_clip
        JOIN (
                  SELECT DISTINCT campaign_id, pk, clip_cat_id, folder_type_id, unified_clip_id, data_source
        FROM arizona 
        WHERE data_source = 'phx'
          AND campaign_id in (249,989,1021,1626,1706,1726,1742,1746,1750,1754,1718,1634,1542,1546,1498,1494,1502,1530,1550,1758,1766,1770,1778,1774,1526,1738,1534,1630,1786,1794,1814,1818,1822,1826,1834,1838,1842,1846,1890,1566,1898,1902,1910,1922,1930,1934,1938,1942,1946,1950,1954,1958,1962,1966,1970,1974,1978,1982,1986,1990,1994,1998,2006,693,1894,2010,2014,1762,2018,2022,2026,2030,2034,2038,2042,2046,2050,2058,2062,2066,2070,2074,2082,2090,2094,2098,2106,2110,2114,2118,2122,2126,2130,2134,2154,2158,2162,2166,2170,2174,2178,2190,2194,2202,2206,2210,2214,2218,2222,2226,2230

geronimod

Thread ID: 69894461524400
Total: 89.750827
Sort by: self_time

 %self      total      self      wait     child     calls  name
 14.51     13.018    13.018     0.000     0.000  1450780   String#unpack 
 10.56     35.807     9.480     0.000    26.327   131881   Integer#times 
  7.28     12.244     6.530     0.001     5.713  2389657   Vertica::BitHelper#readn 
  5.13      4.892     4.607     0.000     0.285   263778   Rational#initialize 
  4.40     29.836     3.947     0.000    25.889   923164   Proc#call 

geronimod

growth_data with 1 query with n campaigns

"load_folder_data(eligible_campaigns):   0.120000   0.020000   0.140000 (  4.050519)\n"
"load_summary_data(eligible_campaigns):   5.820000   0.250000   6.070000 ( 11.876990)\n"
"load_growth_data(eligible_campaigns):  42.090000   0.450000  42.540000 ( 50.433330)\n"

"load_folder_data(eligible_campaigns):   0.200000   0.050000   0.250000 (  3.153942)\n"
"load_summary_data(eligible_campaigns):   6.730000   0.160000   6.890000 ( 14.022160)\n"
"load_growth_data(eligible_campaigns):  37.800000   0.360000  38.160000 ( 62.451637)\n"

geronimod

{
"Total Unique Viewers (000)"=>"14.62531412",
"Average Daily Unique Viewers (000)"=>"0.544445168806451",
"Visits (Sessions) (000)"=>"17.007810779",
"Viewer Penetration"=>"0.00776004850452118",
"% Composition Unique Viewers"=>"100",
"Composition Index for Unique Viewers"=>"100",
"Videos (000)"=>"34.924943018",
"Share of Videos"=>"6.65328345734745E-05",
"Videos per Viewer"=>"2.38797900212211",

geronimod

geronimo@geronimo-Lenovo-G580 1171 ~/projects/vm/site-profile-tool (sp5-PUB-staging_setup)$ cap staging deploy
  * 2013-04-24 15:27:33 executing `staging'
    triggering start callbacks for `deploy'
  * 2013-04-24 15:27:33 executing `multistage:ensure'
  * 2013-04-24 15:27:33 executing `deploy'
  * 2013-04-24 15:27:33 executing `deploy:update'
 ** transaction: start
  * 2013-04-24 15:27:33 executing `deploy:update_code'
    executing locally: "git ls-remote git@github.com:vmcbos/site-profile-tool.git staging"
    command finished in 5066ms

geronimod

"statusCode":1,
"statusMessage":"La búsqueda fue exitosa!",
"licitacionesHtml":"
Resultados de búsqueda

Está viendo del resultado 1 al 1 de los 1 encontrados

Por fecha de cierre | Por estado | Por comprador
Ir a la página :

geronimod

 //-----------------------------------
    //     BUSQUEDA de LICITACIONES
    //-----------------------------------
    function executeAcquisitionsSearch() {

        var actionUrl = $('#urlBusqueda').val();
      var datosForm = $("#frm-search").serialize();
	    $("#frm-search").validate();
	    
	    var isValid = jQuery('#frm-search').valid();