snippet.rb

    #Find all the location records by that advertiser
    location_records_for_advertiser = Locations.find_by_advertiser_id(@advertiser.id)
    #make an array of just IDs 
    location_ids = location_records_for_advertiser.collect { |l| l.id }
    #Find all the placement records by the location ids
    placements_for_advertiser = Placements.find(:all, :conditions => {:location_id => location_ids})
    #make another array of just ids
    placement_ids = placements_for_advertiser.collect { |p| p.id }
    
    pushed_count = PushedDeal.find(:all, :conditions => {:placement_id => placement_ids}).length
    impressed_count = EngagedDeal.find(:all, :conditions => {:placement_id => placement_ids}).length
    engaged_count = ImpressedDeal.find(:all, :conditions => {:placement_id => placement_ids}).length
    @total_delivered = pushed_count + impressed_count + engaged_count