#application.rbFactory.getKeyValue(session.rb,'advertising.campaignplacementreport')#

#application.rbFactory.getKeyValue(session.rb,'advertising.campaignplacementinformation')#

#application.rbFactory.getKeyValue(session.rb,'advertising.company')#: #request.userBean.getcompany()#
#application.rbFactory.getKeyValue(session.rb,'advertising.campaign')#: #request.campaignBean.getName()#
#application.rbFactory.getKeyValue(session.rb,'advertising.campaigndaterange')#: #LSDateFormat(request.campaignBean.getStartDate(),session.dateKeyFormat)# - #LSDateFormat(request.campaignBean.getEndDate(),session.dateKeyFormat)#
#application.rbFactory.getKeyValue(session.rb,'advertising.creative')#: #request.creativeBean.getName()# (#request.creativeBean.getCreativeType()#)
#application.rbFactory.getKeyValue(session.rb,'advertising.adzone')#: #request.adZoneBean.getName()#
#application.rbFactory.getKeyValue(session.rb,'advertising.placementdaterange')#: #LSDateFormat(request.placementBean.getStartDate(),session.dateKeyFormat)# - #LSDateFormat(request.placementBean.getEndDate(),session.dateKeyFormat)#
#application.rbFactory.getKeyValue(session.rb,'advertising.reportdaterange')#: #LSDateFormat(attributes.date1,session.dateKeyFormat)# - #LSDateFormat(attributes.date2,session.dateKeyFormat)#
#application.rbFactory.getKeyValue(session.rb,'advertising.reportdatetime')#: #LSDateFormat(now(),session.dateKeyFormat)# #LSTimeFormat(now(),"short")#
#application.rbFactory.getKeyValue(session.rb,'advertising.budget')#: #LSCurrencyFormat(request.placementBean.getBudget())#
#application.rbFactory.getKeyValue(session.rb,'advertising.costper1000impressions')#: #dollarFormat(request.placementBean.getCostPerImp())#
#application.rbFactory.getKeyValue(session.rb,'advertising.costperclick')#: #dollarFormat(request.placementBean.getCostPerClick())#

#application.rbFactory.getKeyValue(session.rb,'advertising.reportdaterange')#

#application.rbFactory.getKeyValue(session.rb,'advertising.month')#

#request.rsdataImps.reportMonth#/#request.rsdataImps.reportYear#

select sum(counter) as Clicks from tadstats where placementid='#request.placementBean.getPlacementID()#' and type='Click' and stathour=#request.rsdataImps.stathour# and statdate >= #createodbcdatetime(createdatetime(year(attributes.date1),month(attributes.date1),day(attributes.date1),0,0,0))# and statdate <= #createodbcdatetime(createdatetime(year(attributes.date2),month(attributes.date2),day(attributes.date2),23,59,9))#

#application.rbFactory.getKeyValue(session.rb,'advertising.hour')#	#application.rbFactory.getKeyValue(session.rb,'advertising.impressions')#	#application.rbFactory.getKeyValue(session.rb,'advertising.cpmtotal')#	#application.rbFactory.getKeyValue(session.rb,'advertising.clicks')#	#application.rbFactory.getKeyValue(session.rb,'advertising.cpctotal')#	#application.rbFactory.getKeyValue(session.rb,'advertising.total')#	#application.rbFactory.getKeyValue(session.rb,'advertising.clickratio')#
#LSTimeFormat(createTime(request.rsdataImps.stathour,0,0),"short")#	#imps#	#LSCurrencyFormat(request.rsdataImps.qty*request.placementBean.getCostPerImp())#	#clicks#	#LSCurrencyFormat(clicks*request.placementBean.getCostPerClick())#	#LSCurrencyFormat((request.rsdataImps.qtyrequest.placementBean.getCostPerImp()) + (clicksrequest.placementBean.getCostPerClick()))#	#evaluate(round((clicks/imps)*100))#%
#application.rbFactory.getKeyValue(session.rb,'advertising.subtotal')#	#cTotalImps#	#LSCurrencyFormat(cTotalImps*request.placementBean.getCostPerImp())#	#cTotalClicks#	#LSCurrencyFormat(cTotalClicks*request.placementBean.getCostPerClick())#	#LSCurrencyFormat((cTotalImpsrequest.placementBean.getCostPerImp()) + (cTotalClicksrequest.placementBean.getCostPerClick()))#	#evaluate(round((cTotalClicks/cTotalImps)*100))#%

#application.rbFactory.getKeyValue(session.rb,'advertising.total')#

	#application.rbFactory.getKeyValue(session.rb,'advertising.impressions')#	#application.rbFactory.getKeyValue(session.rb,'advertising.cpmtotal')#	#application.rbFactory.getKeyValue(session.rb,'advertising.clicks')#	#application.rbFactory.getKeyValue(session.rb,'advertising.cpctotal')#	#application.rbFactory.getKeyValue(session.rb,'advertising.total')#	#application.rbFactory.getKeyValue(session.rb,'advertising.clickratio')#
#application.rbFactory.getKeyValue(session.rb,'advertising.total')#	#fTotalImps#	#LSCurrencyFormat(fTotalImps*request.placementBean.getCostPerImp())#	#fTotalClicks#	#LSCurrencyFormat(fTotalClicks*request.placementBean.getCostPerClick())#	#LSCurrencyFormat((fTotalImpsrequest.placementBean.getCostPerImp()) + (fTotalClicksrequest.placementBean.getCostPerClick()))#	#evaluate(round((fTotalClicks/fTotalImps)*100))#%

#application.rbFactory.getKeyValue(session.rb,'advertising.noplacementactivity')#