###################################################################### # Open AdStream Log Processing Script # # $Id: Impress.ini,v 3.34.2.3 2005/01/26 22:23:59 arund Exp $ # # Copyright (c) 1996 to 2003 by 24/7 Real Media, Inc. # ALL RIGHTS RESERVED # # By installing this software, you are accepting all of the terms # and conditions of the 24/7 Real Media, Inc. licensing agreement. # # If you have not signed a licensing agreement with 24/7 Real Media, Inc., # you may NOT install or use this software. # ###################################################################### [Impress] # # The format for the input file now supports two log file directory # naming conventions. If you specify "%y%m" you get the old format. # yymm. if you use %Y you get a four digit year. %M will give you a # two digit month. NOTE that it is possible to use all in the same # log file string. InputFiles=Logs/%Y-%M/%d/*.log^x OutputFilePath=%Y-%M/%d/ Passes=0,1,2,3,4,5,6,7,8,9,10 DerivedEntities=accountkey ExtendedDate=no # Filter known robots from all passes # EntityFilters=RobotFilter # Section Counting is used to determine if a section is in a campaign # SectionCounting=campaign # Search Term Processing attributes SearchTermEntities=tkeywords,tnames,keywords,names,keyelements DbToLogLineRatio = 0.001 [ModulePasses] Address=31 Cookie=11 Geotargeting=20,21,22 Network=51 #Remote Search=12,13,14,15,16,17 Segment=71,72 ReachAndFreq=91,92,93 ############################################################################### [DataPrune] # List of tables that have been configured for pruning. PruneTables = rCamAre,rCamCit,rCamDma,rCamDom,rCamMsa,rCamPag,rCamSta,rCamUrl,rCamZip,rSecAre,rSecCit,rSecSitDma,rSecSitMsa,rSecSta,rSecZip,rSitAre,rSitCit,rSitDma,rSitDom,rSitMsa,rSitSta,rSitUrl,rSitZip DataFilePath = Reports ############################################################################### [SegmentTool] HistoryPeriod = 7 [Weights] HistoryPeriod = 7 [Search] HistoryPeriod = 7 ######################### PASS DEFINITIONS #################################### [0] ###KeyFields = Cam,Sit OutputFiles=rCam.db EntityFilters=RobotFilter BadInputExtension=out [1] ###KeyFields = Ban,Hod,Pos,Sec OutputFiles=rGlobal.db,rHod.db,rPos.db,rSec.db EntityFilters=RobotFilter [2] ###KeyFields = Pag,Pos,Sec (...Inventory data here...) OutputFiles=rPagPos.db,rSecPos.db,rPagSec.db EntityFilters=RobotFilter [3] ###KeyFields = Cam,Sit,Sec,Pos OutputFiles=rCamSecPos.db,rSitSecPos.db EntityFilters=RobotFilter [4] ###KeyFields = Cam,Ban,Sec,Pos,Hod OutputFiles=rCamBanPos.db,rCamBanSec.db,rCamBan.db,rCamSec.db,rCamPos.db,rBanSecPos.db EntityFilters=RobotFilter [5] ###KeyFields = Sit,Ban,Sec,Pos OutputFiles=rSitSec.db,rSitPos.db,rSit.db EntityFilters=RobotFilter [6] ###KeyFields = Cam,Sit,Ban,Hod OutputFiles=rCamSit.db,rCamHod.db,rSitHod.db,rCamSitBan.db EntityFilters=RobotFilter [7] ###KeyFields = Cam,Sit,Bro,Brv,Os OutputFiles=rCamBro.db,rCamBrv.db,rCamOs.db,rSitBro.db,rSitBrv.db,rSitOs.db EntityFilters=RobotFilter [8] ###KeyFields = Cam,Sit,Top,Dom OutputFiles=rCamTop.db,rCamDom.db,rSitTop.db,rSitDom.db EntityFilters=RobotFilter [9] ###KeyFields = Cam,Sit,Pag,Url OutputFiles=rCamPag.db,rCamUrl.db,rSitPag.db,rSitUrl.db EntityFilters=RobotFilter [10] ###KeyFields = Cam,Sit,Sec OutputFiles=rCamFil.db,rSecFil.db,rSitFil.db EntityFilters=RobotOnlyFilter ############# RDB Cooke Module : Pass 11 ###################################### [11] ###KeyFields = Cam,Sit,Sec,Age,Inc,Gen OutputFiles=rCamAge.db,rCamGen.db,rCamInc.db,rSitAge.db,rSitGen.db,rSitInc.db,rSecAge.db,rSecGen.db,rSecInc.db EntityFilters=RobotFilter ############# Keyword Module : Passes 12 thro 17 ############################## [12] OutputFiles=rQry.db EntityFilters=RobotFilter [13] OutputFiles=rCamKe.db,rCamBanKe.db,rCamSitKe.db,rCamSecKe.db,rCamPosKe.db EntityFilters=RobotFilter [14] OutputFiles=rKw.db,rSitKw.db,rSecKw.db,rPosKw.db,rSitSecKw.db,rSitPosKw.db,rSecPosKw.db EntityFilters=RobotFilter [15] OutputFiles=rCamKwt.db,rCamBanKwt.db,rCamSitKwt.db,rCamSecKwt.db,rCamPosKwt.db EntityFilters=RobotFilter [16] OutputFiles=rKp.db,rSitKp.db,rSecKp.db,rPosKp.db,rSitSecKp.db,rSitPosKp.db,rSecPosKp.db EntityFilters=RobotFilter [17] OutputFiles=rCamKpt.db,rCamBanKpt.db,rCamSitKpt.db,rCamSecKpt.db,rCamPosKpt.db EntityFilters=RobotFilter ############# Geotargeting Module : Pass 20 thro 22 ########################### [20] ###KeyFields = Cam,Are,Bw,Cit,Con,Dma,Msa OutputFiles=rCamAre.db,rCamBw.db,rCamCit.db,rCamCon.db,rCamDma.db,rCamMsa.db EntityFilters=RobotFilter [21] ###KeyFields = Sit,Are,Bw,Cit,Con,Dma,Msa OutputFiles=rSitAre.db,rSitBw.db,rSitCit.db,rSitCon.db,rSitDma.db,rSitMsa.db EntityFilters=RobotFilter [22] ###KeyFields = Sit,Sec,Are,Bw,Cit,Con,Dma,Msa OutputFiles=rSecAre.db,rSecBw.db,rSecCit.db,rSecCon.db,rSecDma.db,rSecMsa.db,rSecSitBw.db,rSecSitCon.db,rSecSitDma.db,rSecSitMsa.db EntityFilters=RobotFilter ############# Address Module : Pass 31 ######################################## [31] ###KeyFields = Cam,Sit,Sec,Cou,Sta,Zip OutputFiles=rCamCou.db,rCamSta.db,rCamZip.db,rSitCou.db,rSitSta.db,rSitZip.db,rSecCou.db,rSecSta.db,rSecZip.db EntityFilters=RobotFilter ############# Network Module : Pass 51 ######################################## [51] ###KeyFields = Cam,Sit,Sec,Pos OutputFiles = rCamSitSecPos.db EntityFilters = RobotFilter ############# Insight ACT : Pass 71,72 ######################################## [71] ###KeyFields = Segc OutputFiles = rSegc.act EntityFilters = RobotFilter [72] ###KeyFields = Cam,Ban,Sit,Sec,Pos,Segm OutputFiles = wCamBanSitSegm.act,wCamBanSecSegm.act,wCamBanPosSegm.act EntityFilters = RobotFilter ############# Reach and Freq : Pass 91######################################## [91] ###KeyFields = Cam,Ban,Sit,Sec,Pos,Segm OutputFiles = rAdvARF.db,rCamARF.db,rCamGrpARF.db,rSecARF.db,rSitARF.db,rSitGrpARF.db EntityFilters = RobotFilter [92] ###KeyFields = Cam,Ban,Sit,Sec,Pos,Segm OutputFiles = rAdvRF.db,rAdvSitRF.db,rCamCamGrpRF.db,rCamGrpRF.db,rCamGrpSitRF.db,rCamRF.db,rCamSecRF.db,rCamSitGrpRF.db,rCamSitRF.db,rSecRF.db,rSecSitRF.db,rSitGrpRF.db,rSitGrpSitRF.db,rSitRF.db EntityFilters = RobotFilter [93] ###KeyFields = Cam,Ban,Sit,Sec,Pos,Segm OutputFiles = rAdvSitSitRF.db,rCamCamGrpCamGrpRF.db,rCamGrpSitSitRF.db,rCamSecSecRF.db,rCamSitGrpSitGrpRF.db,rCamSitSitRF.db,rSecSitSitRF.db,rSitGrpSitSitRF.db EntityFilters = RobotFilter ############################################################################### [uniqueentries] OutputFiles= [domainentries] OutputFiles= ############################################################################### [rGlobal.db] KeyEntities=account OutputFields=accountkey:rGlobal.Account,impX:rGlobal.Impressions,cts:rGlobal.Clickthrus ############################################################################### [rCam.db] KeyEntities=account,camp OutputFields=accountkey:rCam.Account,camp:rCam.Campaign,impX:rCam.Impressions,cts:rCam.Clickthrus [rHod.db] KeyEntities=account,hour OutputFields=accountkey:rHod.Account,hour:rHod.HourOfDay,impX:rHod.Impressions,cts:rHod.Clickthrus [rPos.db] KeyEntities=account,position OutputFields=accountkey:rPos.Account,position:rPos.Position,impX:rPos.Impressions,cts:rPos.Clickthrus [rSec.db] KeyEntities=account,section OutputFields=accountkey:rSec.Account,section:rSec.Section,impX:rSec.Impressions,cts:rSec.Clickthrus [rSit.db] KeyEntities=account,site OutputFields=accountkey:rSit.Account,site:rSit.Site,impX:rSit.Impressions,cts:rSit.Clickthrus ############################################################################### [rCamAge.db] KeyEntities=account,camp,age OutputFields=accountkey:rCamAge.Account,camp:rCamAge.Campaign,age:rCamAge.Age,impX:rCamAge.Impressions,cts:rCamAge.Clickthrus [rCamAre.db] KeyEntities=account,camp,areacode OutputFields=accountkey:rCamAre.Account,camp:rCamAre.Campaign,areacode:rCamAre.Area,impX:rCamAre.Impressions,cts:rCamAre.Clickthrus PrintHeader = yes PruneKeyField = Area PruneValueField = Impressions PruneMethod = Top-500 [rCamBan.db] KeyEntities=account,camp,banner OutputFields=accountkey:rCamBan.Account,camp:rCamBan.Campaign,banner:rCamBan.Creative,impX:rCamBan.Impressions,cts:rCamBan.Clickthrus [rCamBro.db] KeyEntities=account,camp,browser OutputFields=accountkey:rCamBro.Account,camp:rCamBro.Campaign,browser:rCamBro.Browser,impX:rCamBro.Impressions,cts:rCamBro.Clickthrus [rCamBrv.db] KeyEntities=account,camp,browserv OutputFields=accountkey:rCamBrv.Account,camp:rCamBrv.Campaign,browserv:rCamBrv.Browserv,impX:rCamBrv.Impressions,cts:rCamBrv.Clickthrus [rCamBw.db] KeyEntities=account,camp,bandwidth OutputFields=accountkey:rCamBw.Account,camp:rCamBw.Campaign,bandwidth:rCamBw.Bw,impX:rCamBw.Impressions,cts:rCamBw.Clickthrus [rCamCit.db] KeyEntities=account,camp,city OutputFields=accountkey:rCamCit.Account,camp:rCamCit.Campaign,city:rCamCit.City,impX:rCamCit.Impressions,cts:rCamCit.Clickthrus PrintHeader = yes PruneKeyField = City PruneValueField = Impressions PruneMethod = Top-500 [rCamCon.db] KeyEntities=account,camp,continent OutputFields=accountkey:rCamCon.Account,camp:rCamCon.Campaign,continent:rCamCon.Continent,impX:rCamCon.Impressions,cts:rCamCon.Clickthrus [rCamCou.db] KeyEntities=account,camp,country OutputFields=accountkey:rCamCou.Account,camp:rCamCou.Campaign,country:rCamCou.Country,impX:rCamCou.Impressions,cts:rCamCou.Clickthrus [rCamDma.db] KeyEntities=account,camp,dma OutputFields=accountkey:rCamDma.Account,camp:rCamDma.Campaign,dma:rCamDma.Dma,impX:rCamDma.Impressions,cts:rCamDma.Clickthrus PrintHeader = yes PruneKeyField = Dma PruneValueField = Impressions PruneMethod = Top-500 [rCamDom.db] KeyEntities=account,camp,domain OutputFields=accountkey:rCamDom.Account,camp:rCamDom.Campaign,domain:rCamDom.Domain,impX:rCamDom.Impressions,cts:rCamDom.Clickthrus PrintHeader = yes PruneKeyField = Domain PruneValueField = Impressions PruneMethod = Top-500 [rCamFil.db] KeyEntities=account,camp OutputFields=accountkey:rCamFil.Account,camp:rCamFil.Campaign,impX:rCamFil.Impressions,cts:rCamFil.Clickthrus [rCamGen.db] KeyEntities=account,camp,gender OutputFields=accountkey:rCamGen.Account,camp:rCamGen.Campaign,gender:rCamGen.Gender,impX:rCamGen.Impressions,cts:rCamGen.Clickthrus [rCamHod.db] KeyEntities=account,camp,hour OutputFields=accountkey:rCamHod.Account,camp:rCamHod.Campaign,hour:rCamHod.HourOfDay,impX:rCamHod.Impressions,cts:rCamHod.Clickthrus [rCamInc.db] KeyEntities=account,camp,income OutputFields=accountkey:rCamInc.Account,camp:rCamInc.Campaign,income:rCamInc.Income,impX:rCamInc.Impressions,cts:rCamInc.Clickthrus [rCamMsa.db] KeyEntities=account,camp,msa OutputFields=accountkey:rCamMsa.Account,camp:rCamMsa.Campaign,msa:rCamMsa.Msa,impX:rCamMsa.Impressions,cts:rCamMsa.Clickthrus PrintHeader = yes PruneKeyField = Msa PruneValueField = Impressions PruneMethod = Top-500 [rCamOs.db] KeyEntities=account,camp,os OutputFields=accountkey:rCamOs.Account,camp:rCamOs.Campaign,os:rCamOs.Os,impX:rCamOs.Impressions,cts:rCamOs.Clickthrus [rCamPag.db] KeyEntities=account,camp,page OutputFields=accountkey:rCamPag.Account,camp:rCamPag.Campaign,page:rCamPag.Page,impX:rCamPag.Impressions,cts:rCamPag.Clickthrus PrintHeader = yes PruneKeyField = Page PruneValueField = Impressions PruneMethod = Top-500 [rCamPos.db] KeyEntities=account,camp,position OutputFields=accountkey:rCamPos.Account,camp:rCamPos.Campaign,position:rCamPos.Position,impX:rCamPos.Impressions,cts:rCamPos.Clickthrus [rCamRef.db] KeyEntities=account,camp,refer OutputFields=accountkey:rCamRef.Account,camp:rCamRef.Campaign,refer:rCamRef.RefererUrl,impX:rCamRef.Impressions,cts:rCamRef.Clickthrus [rCamSec.db] KeyEntities=account,camp,section OutputFields=accountkey:rCamSec.Account,camp:rCamSec.Campaign,section:rCamSec.Section,impX:rCamSec.Impressions,cts:rCamSec.Clickthrus [rCamSit.db] KeyEntities=account,camp,site OutputFields=accountkey:rCamSit.Account,camp:rCamSit.Campaign,site:rCamSit.Site,impX:rCamSit.Impressions,cts:rCamSit.Clickthrus [rCamSta.db] KeyEntities=account,camp,state OutputFields=accountkey:rCamSta.Account,camp:rCamSta.Campaign,state:rCamSta.State,impX:rCamSta.Impressions,cts:rCamSta.Clickthrus PrintHeader = yes PruneKeyField = State PruneValueField = Impressions PruneMethod = Top-500 [rCamTop.db] KeyEntities=account,camp,top OutputFields=accountkey:rCamTop.Account,camp:rCamTop.Campaign,top:rCamTop.TopDomain,impX:rCamTop.Impressions,cts:rCamTop.Clickthrus [rCamUrl.db] KeyEntities=account,camp,url OutputFields=accountkey:rCamUrl.Account,camp:rCamUrl.Campaign,url:rCamUrl.Url,impX:rCamUrl.Impressions,cts:rCamUrl.Clickthrus PrintHeader = yes PruneKeyField = Url PruneValueField = Impressions PruneMethod = Top-500 [rCamZip.db] KeyEntities=account,camp,zip OutputFields=accountkey:rCamZip.Account,camp:rCamZip.Campaign,zip:rCamZip.Zip,impX:rCamZip.Impressions,cts:rCamZip.Clickthrus PrintHeader = yes PruneKeyField = Zip PruneValueField = Impressions PruneMethod = Top-500 ############################################################################### [rSitAge.db] KeyEntities=account,site,age OutputFields=accountkey:rSitAge.Account,site:rSitAge.Site,age:rSitAge.Age,impX:rSitAge.Impressions,cts:rSitAge.Clickthrus [rSitAre.db] KeyEntities=account,site,areacode OutputFields=accountkey:rSitAre.Account,site:rSitAre.Site,areacode:rSitAre.Area,impX:rSitAre.Impressions,cts:rSitAre.Clickthrus PrintHeader = yes PruneKeyField = Area PruneValueField = Impressions PruneMethod = Top-500 [rSitBro.db] KeyEntities=account,site,browser OutputFields=accountkey:rSitBro.Account,site:rSitBro.Site,browser:rSitBro.Browser,impX:rSitBro.Impressions,cts:rSitBro.Clickthrus [rSitBrv.db] KeyEntities=account,site,browserv OutputFields=accountkey:rSitBrv.Account,site:rSitBrv.Site,browserv:rSitBrv.Browserv,impX:rSitBrv.Impressions,cts:rSitBrv.Clickthrus [rSitBw.db] KeyEntities=account,site,bandwidth OutputFields=accountkey:rSitBw.Account,site:rSitBw.Site,bandwidth:rSitBw.Bw,impX:rSitBw.Impressions,cts:rSitBw.Clickthrus [rSitCit.db] KeyEntities=account,site,city OutputFields=accountkey:rSitCit.Account,site:rSitCit.Site,city:rSitCit.City,impX:rSitCit.Impressions,cts:rSitCit.Clickthrus PrintHeader = yes PruneKeyField = City PruneValueField = Impressions PruneMethod = Top-500 [rSitCon.db] KeyEntities=account,site,continent OutputFields=accountkey:rSitCon.Account,site:rSitCon.Site,continent:rSitCon.Continent,impX:rSitCon.Impressions,cts:rSitCon.Clickthrus [rSitCou.db] KeyEntities=account,site,country OutputFields=accountkey:rSitCou.Account,site:rSitCou.Site,country:rSitCou.Country,impX:rSitCou.Impressions,cts:rSitCou.Clickthrus [rSitDma.db] KeyEntities=account,site,dma OutputFields=accountkey:rSitDma.Account,site:rSitDma.Site,dma:rSitDma.Dma,impX:rSitDma.Impressions,cts:rSitDma.Clickthrus PrintHeader = yes PruneKeyField = Dma PruneValueField = Impressions PruneMethod = Top-500 [rSitDom.db] KeyEntities=account,site,domain OutputFields=accountkey:rSitDom.Account,site:rSitDom.Site,domain:rSitDom.Domain,impX:rSitDom.Impressions,cts:rSitDom.Clickthrus PrintHeader = yes PruneKeyField = Domain PruneValueField = Impressions PruneMethod = Top-500 [rSitFil.db] KeyEntities=account,site OutputFields=accountkey:rSitFil.Account,site:rSitFil.Site,impX:rSitFil.Impressions,cts:rSitFil.Clickthrus [rSitGen.db] KeyEntities=account,site,gender OutputFields=accountkey:rSitGen.Account,site:rSitGen.Site,gender:rSitGen.Gender,impX:rSitGen.Impressions,cts:rSitGen.Clickthrus [rSitHod.db] KeyEntities=account,site,hour OutputFields=accountkey:rSitHod.Account,site:rSitHod.Site,hour:rSitHod.HourOfDay,impX:rSitHod.Impressions,cts:rSitHod.Clickthrus [rSitInc.db] KeyEntities=account,site,income OutputFields=accountkey:rSitInc.Account,site:rSitInc.Site,income:rSitInc.Income,impX:rSitInc.Impressions,cts:rSitInc.Clickthrus [rSitMsa.db] KeyEntities=account,site,msa OutputFields=accountkey:rSitMsa.Account,site:rSitMsa.Site,msa:rSitMsa.Msa,impX:rSitMsa.Impressions,cts:rSitMsa.Clickthrus PrintHeader = yes PruneKeyField = Msa PruneValueField = Impressions PruneMethod = Top-500 [rSitOs.db] KeyEntities=account,site,os OutputFields=accountkey:rSitOs.Account,site:rSitOs.Site,os:rSitOs.Os,impX:rSitOs.Impressions,cts:rSitOs.Clickthrus [rSitPag.db] KeyEntities=account,site,page OutputFields=accountkey:rSitPag.Account,site:rSitPag.Site,page:rSitPag.Page,impX:rSitPag.Impressions,cts:rSitPag.Clickthrus [rSitPos.db] KeyEntities=account,site,position OutputFields=accountkey:rSitPos.Account,site:rSitPos.Site,position:rSitPos.Position,impX:rSitPos.Impressions,cts:rSitPos.Clickthrus [rSitRef.db] KeyEntities=account,site,refer OutputFields=accountkey:rSitRef.Account,site:rSitRef.Site,refer:rSitRef.RefererUrl,impX:rSitRef.Impressions,cts:rSitRef.Clickthrus [rSitSec.db] KeyEntities=account,site,section OutputFields=accountkey:rSitSec.Account,site:rSitSec.Site,section:rSitSec.Section,impX:rSitSec.Impressions,cts:rSitSec.Clickthrus [rSitSta.db] KeyEntities=account,site,state OutputFields=accountkey:rSitSta.Account,site:rSitSta.Site,state:rSitSta.State,impX:rSitSta.Impressions,cts:rSitSta.Clickthrus PrintHeader = yes PruneKeyField = State PruneValueField = Impressions PruneMethod = Top-500 [rSitTop.db] KeyEntities=account,site,top OutputFields=accountkey:rSitTop.Account,site:rSitTop.Site,top:rSitTop.TopDomain,impX:rSitTop.Impressions,cts:rSitTop.Clickthrus [rSitUrl.db] KeyEntities=account,site,url OutputFields=accountkey:rSitUrl.Account,site:rSitUrl.Site,url:rSitUrl.Url,impX:rSitUrl.Impressions,cts:rSitUrl.Clickthrus PrintHeader = yes PruneKeyField = Url PruneValueField = Impressions PruneMethod = Top-500 [rSitZip.db] KeyEntities=account,site,zip OutputFields=accountkey:rSitZip.Account,site:rSitZip.Site,zip:rSitZip.Zip,impX:rSitZip.Impressions,cts:rSitZip.Clickthrus PrintHeader = yes PruneKeyField = Zip PruneValueField = Impressions PruneMethod = Top-500 ############################################################################### [rPagPos.db] KeyEntities=account,page,position OutputFields=accountkey:rPagPos.Account,page:rPagPos.Page,position:rPagPos.Position,imp:rPagPos.Impressions,cts:rPagPos.Clickthrus [rPagSec.db] KeyEntities=account,page,section OutputFields=accountkey:rPagSec.Account,page:rPagSec.Page,section:rPagSec.Section,impX:rPagSec.Impressions,cts:rPagSec.Clickthrus [rSecAge.db] KeyEntities=account,section,age OutputFields=accountkey:rSecAge.Account,section:rSecAge.Section,age:rSecAge.Age,impX:rSecAge.Impressions,cts:rSecAge.Clickthrus [rSecAre.db] KeyEntities=account,section,areacode OutputFields=accountkey:rSecAre.Account,section:rSecAre.Section,areacode:rSecAre.Area,impX:rSecAre.Impressions,cts:rSecAre.Clickthrus PrintHeader = yes PruneKeyField = Area PruneValueField = Impressions PruneMethod = Top-500 [rSecBw.db] KeyEntities=account,section,bandwidth OutputFields=accountkey:rSecBw.Account,section:rSecBw.Section,bandwidth:rSecBw.Bw,impX:rSecBw.Impressions,cts:rSecBw.Clickthrus [rSecCit.db] KeyEntities=account,section,city OutputFields=accountkey:rSecCit.Account,section:rSecCit.Section,city:rSecCit.City,impX:rSecCit.Impressions,cts:rSecCit.Clickthrus PrintHeader = yes PruneKeyField = City PruneValueField = Impressions PruneMethod = Top-500 [rSecCon.db] KeyEntities=account,section,continent OutputFields=accountkey:rSecCon.Account,section:rSecCon.Section,continent:rSecCon.Continent,impX:rSecCon.Impressions,cts:rSecCon.Clickthrus [rSecCou.db] KeyEntities=account,section,country OutputFields=accountkey:rSecCou.Account,section:rSecCou.Section,country:rSecCou.Country,impX:rSecCou.Impressions,cts:rSecCou.Clickthrus [rSecDma.db] KeyEntities=account,section,dma OutputFields=accountkey:rSecDma.Account,section:rSecDma.Section,dma:rSecDma.Dma,impX:rSecDma.Impressions,cts:rSecDma.Clickthrus [rSecFil.db] KeyEntities=account,section OutputFields=accountkey:rSecFil.Account,section:rSecFil.Section,impX:rSecFil.Impressions,cts:rSecFil.Clickthrus [rSecGen.db] KeyEntities=account,section,gender OutputFields=accountkey:rSecGen.Account,section:rSecGen.Section,gender:rSecGen.Gender,impX:rSecGen.Impressions,cts:rSecGen.Clickthrus [rSecInc.db] KeyEntities=account,section,income OutputFields=accountkey:rSecInc.Account,section:rSecInc.Section,income:rSecInc.Income,impX:rSecInc.Impressions,cts:rSecInc.Clickthrus [rSecMsa.db] KeyEntities=account,section,msa OutputFields=accountkey:rSecMsa.Account,section:rSecMsa.Section,msa:rSecMsa.Msa,impX:rSecMsa.Impressions,cts:rSecMsa.Clickthrus [rSecPos.db] KeyEntities=account,section,position OutputFields=accountkey:rSecPos.Account,section:rSecPos.Section,position:rSecPos.Position,impX:rSecPos.Impressions,cts:rSecPos.Clickthrus [rSecSitBw.db] KeyEntities=account,section,site,bandwidth OutputFields=accountkey:rSecSitBw.Account,section:rSecSitBw.Section,site:rSecSitBw.Site,bandwidth:rSecSitBw.Bw,impX:rSecSitBw.Impressions,cts:rSecSitBw.Clickthrus [rSecSitCon.db] KeyEntities=account,section,site,continent OutputFields=accountkey:rSecSitCon.Account,section:rSecSitCon.Section,site:rSecSitCon.Site,continent:rSecSitCon.Continent,impX:rSecSitCon.Impressions,cts:rSecSitCon.Clickthrus [rSecSitDma.db] KeyEntities=account,section,site,dma OutputFields=accountkey:rSecSitDma.Account,section:rSecSitDma.Section,site:rSecSitDma.Site,dma:rSecSitDma.Dma,impX:rSecSitDma.Impressions,cts:rSecSitDma.Clickthrus PrintHeader = yes PruneKeyField = Dma PruneValueField = Impressions PruneMethod = Top-500 [rSecSitMsa.db] KeyEntities=account,section,site,msa OutputFields=accountkey:rSecSitMsa.Account,section:rSecSitMsa.Section,site:rSecSitMsa.Site,msa:rSecSitMsa.Msa,impX:rSecSitMsa.Impressions,cts:rSecSitMsa.Clickthrus PrintHeader = yes PruneKeyField = Msa PruneValueField = Impressions PruneMethod = Top-500 [rSecSta.db] KeyEntities=account,section,state OutputFields=accountkey:rSecSta.Account,section:rSecSta.Section,state:rSecSta.State,impX:rSecSta.Impressions,cts:rSecSta.Clickthrus PrintHeader = yes PruneKeyField = State PruneValueField = Impressions PruneMethod = Top-500 [rSecZip.db] KeyEntities=account,section,zip OutputFields=accountkey:rSecZip.Account,section:rSecZip.Section,zip:rSecZip.Zip,impX:rSecZip.Impressions,cts:rSecZip.Clickthrus PrintHeader = yes PruneKeyField = Zip PruneValueField = Impressions PruneMethod = Top-500 ############################################################################### [rBanSecPos.db] KeyEntities=account,banner,section,position OutputFields=accountkey:rBanSecPos.Account,banner:rBanSecPos.Creative,section:rBanSecPos.Section,position:rBanSecPos.Position,impX:rBanSecPos.Impressions,cts:rBanSecPos.Clickthrus [rCamBanPos.db] KeyEntities=account,camp,banner,position OutputFields=accountkey:rCamBanPos.Account,camp:rCamBanPos.Campaign,banner:rCamBanPos.Creative,position:rCamBanPos.Position,impX:rCamBanPos.Impressions,cts:rCamBanPos.Clickthrus [rCamBanSec.db] KeyEntities=account,camp,banner,section OutputFields=accountkey:rCamBanSec.Account,camp:rCamBanSec.Campaign,banner:rCamBanSec.Creative,section:rCamBanSec.Section,impX:rCamBanSec.Impressions,cts:rCamBanSec.Clickthrus [rCamSecPos.db] KeyEntities=account,camp,section,position OutputFields=accountkey:rCamSecPos.Account,camp:rCamSecPos.Campaign,section:rCamSecPos.Section,position:rCamSecPos.Position,impX:rCamSecPos.Impressions,cts:rCamSecPos.Clickthrus [rCamSecHod.db] KeyEntities=account,camp,section,hour OutputFields=accountkey:rCamSecHod.Account,camp:rCamSecHod.Campaign,section:rCamSecHod.Section,hour:rCamSecHod.HourOfDay,impX:rCamSecHod.Impressions,cts:rCamSecHod.Clickthrus [rCamSitBan.db] KeyEntities=account,camp,site,banner OutputFields=accountkey:rCamSitBan.Account,camp:rCamSitBan.Campaign,site:rCamSitBan.Site,banner:rCamSitBan.Creative,impX:rCamSitBan.Impressions,cts:rCamSitBan.Clickthrus [rSitSecPos.db] KeyEntities=account,site,section,position OutputFields=accountkey:rSitSecPos.Account,site:rSitSecPos.Site,section:rSitSecPos.Section,position:rSitSecPos.Position,impX:rSitSecPos.Impressions,cts:rSitSecPos.Clickthrus ############################################################################### [rCamSitSecPos.db] KeyEntities=account,camp,site,section,position OutputFields=accountkey:rCamSitSecPos.Account,camp:rCamSitSecPos.Campaign,site:rCamSitSecPos.Site,section:rCamSitSecPos.Section,position:rCamSitSecPos.Position,impX:rCamSitSecPos.Impressions,cts:rCamSitSecPos.Clickthrus ############################################################################### # # Search Term Processing Summaries # ############################################################################### [rQry.db] KeyEntities=account,search OutputFields=accountkey:rQry.Account,search:rQry.Search,impX:rQry.Impressions,cts:rQry.Clickthrus [rKw.db] KeyEntities=account,keyword OutputFields=accountkey:rKw.Account,keyword:rKw.KeywordKey,impX:rKw.Impressions,cts:rKw.Clickthrus [rKp.db] KeyEntities=account,name,value OutputFields=accountkey:rKp.Account,name:rKp.KeynameKey,value:rKp.KeyvalueKey,impX:rKp.Impressions,cts:rKp.Clickthrus ############################################################################### # # Campaign Based Search Term Processing Summaries # Aggregated on targeted keywords or keypairs for a given campaign # ############################################################################### [rCamSqs.db] KeyEntities=account,camp,sortedqs OutputFields=accountkey:rCamSqs.Account,camp:rCamSqs.Campaign,sortedqs:rCamSqs.SqsKey,impX:rCamSqs.Impressions,cts:rCamSqs.Clickthrus [rCamKe.db] KeyEntities=account,camp,keyelement OutputFields=accountkey:rCamKe.Account,camp:rCamKe.Campaign,keyelement:rCamKe.Keyelement,impX:rCamKe.Impressions,cts:rCamKe.Clickthrus [rCamKwt.db] KeyEntities=account,camp,tkeyword OutputFields=accountkey:rCamKwt.Account,camp:rCamKwt.Campaign,tkeyword:rCamKwt.KeywordKey,impX:rCamKwt.Impressions,cts:rCamKwt.Clickthrus [rCamKpt.db] KeyEntities=account,camp,tname,tvalue OutputFields=accountkey:rCamKpt.Account,camp:rCamKpt.Campaign,tname:rCamKpt.KeynameKey,tvalue:rCamKpt.KeyvalueKey,impX:rCamKpt.Impressions,cts:rCamKpt.Clickthrus [rCamBanSqs.db] KeyEntities=account,camp,banner,sortedqs OutputFields=accountkey:rCamBanSqs.Account,camp:rCamBanSqs.Campaign,banner:rCamBanSqs.Creative,sortedqs:rCamBanSqs.SqsKey,impX:rCamBanSqs.Impressions,cts:rCamBanSqs.Clickthrus [rCamBanKe.db] KeyEntities=account,camp,banner,keyelement OutputFields=accountkey:rCamBanKe.Account,camp:rCamBanKe.Campaign,banner:rCamBanKe.Creative,keyelement:rCamBanKe.Keyelement,impX:rCamBanKe.Impressions,cts:rCamBanKe.Clickthrus [rCamBanKwt.db] KeyEntities=account,camp,banner,tkeyword OutputFields=accountkey:rCamBanKwt.Account,camp:rCamBanKwt.Campaign,banner:rCamBanKwt.Creative,tkeyword:rCamBanKwt.KeywordKey,impX:rCamBanKwt.Impressions,cts:rCamBanKwt.Clickthrus [rCamBanKpt.db] KeyEntities=account,camp,banner,tname,tvalue OutputFields=accountkey:rCamBanKpt.Account,camp:rCamBanKpt.Campaign,banner:rCamBanKpt.Creative,tname:rCamBanKpt.KeynameKey,tvalue:rCamBanKpt.KeyvalueKey,impX:rCamBanKpt.Impressions,cts:rCamBanKpt.Clickthrus [rCamSitSqs.db] KeyEntities=account,camp,site,sortedqs OutputFields=accountkey:rCamSitSqs.Account,camp:rCamSitSqs.Campaign,site:rCamSitSqs.Site,sortedqs:rCamSitSqs.SqsKey,impX:rCamSitSqs.Impressions,cts:rCamSitSqs.Clickthrus [rCamSitKe.db] KeyEntities=account,camp,site,keyelement OutputFields=accountkey:rCamSitKe.Account,camp:rCamSitKe.Campaign,site:rCamSitKe.Site,keyelement:rCamSitKe.Keyelement,impX:rCamSitKe.Impressions,cts:rCamSitKe.Clickthrus [rCamSitKwt.db] KeyEntities=account,camp,site,tkeyword OutputFields=accountkey:rCamSitKwt.Account,camp:rCamSitKwt.Campaign,site:rCamSitKwt.Site,tkeyword:rCamSitKwt.KeywordKey,impX:rCamSitKwt.Impressions,cts:rCamSitKwt.Clickthrus [rCamSitKpt.db] KeyEntities=account,camp,site,tname,tvalue OutputFields=accountkey:rCamSitKpt.Account,camp:rCamSitKpt.Campaign,site:rCamSitKpt.Site,tname:rCamSitKpt.KeynameKey,tvalue:rCamSitKpt.KeyvalueKey,impX:rCamSitKpt.Impressions,cts:rCamSitKpt.Clickthrus [rCamSecSqs.db] KeyEntities=account,camp,section,sortedqs OutputFields=accountkey:rCamSecSqs.Account,camp:rCamSecSqs.Campaign,section:rCamSecSqs.Section,sortedqs:rCamSecSqs.SqsKey,impX:rCamSecSqs.Impressions,cts:rCamSecSqs.Clickthrus [rCamSecKe.db] KeyEntities=account,camp,section,keyelement OutputFields=accountkey:rCamSecKe.Account,camp:rCamSecKe.Campaign,section:rCamSecKe.Section,keyelement:rCamSecKe.Keyelement,impX:rCamSecKe.Impressions,cts:rCamSecKe.Clickthrus [rCamSecKwt.db] KeyEntities=account,camp,section,tkeyword OutputFields=accountkey:rCamSecKwt.Account,camp:rCamSecKwt.Campaign,section:rCamSecKwt.Section,tkeyword:rCamSecKwt.KeywordKey,impX:rCamSecKwt.Impressions,cts:rCamSecKwt.Clickthrus [rCamSecKpt.db] KeyEntities=account,camp,section,tname,tvalue OutputFields=accountkey:rCamSecKpt.Account,camp:rCamSecKpt.Campaign,section:rCamSecKpt.Section,tname:rCamSecKpt.KeynameKey,tvalue:rCamSecKpt.KeyvalueKey,impX:rCamSecKpt.Impressions,cts:rCamSecKpt.Clickthrus [rCamPosSqs.db] KeyEntities=account,camp,position,sortedqs OutputFields=accountkey:rCamPosSqs.Account,camp:rCamPosSqs.Campaign,position:rCamPosSqs.Position,sortedqs:rCamPosSqs.SqsKey,impX:rCamPosSqs.Impressions,cts:rCamPosSqs.Clickthrus [rCamPosKe.db] KeyEntities=account,camp,position,keyelement OutputFields=accountkey:rCamPosKe.Account,camp:rCamPosKe.Campaign,position:rCamPosKe.Position,keyelement:rCamPosKe.Keyelement,impX:rCamPosKe.Impressions,cts:rCamPosKe.Clickthrus [rCamPosKwt.db] KeyEntities=account,camp,position,tkeyword OutputFields=accountkey:rCamPosKwt.Account,camp:rCamPosKwt.Campaign,position:rCamPosKwt.Position,tkeyword:rCamPosKwt.KeywordKey,impX:rCamPosKwt.Impressions,cts:rCamPosKwt.Clickthrus [rCamPosKpt.db] KeyEntities=account,camp,position,tname,tvalue OutputFields=accountkey:rCamPosKpt.Account,camp:rCamPosKpt.Campaign,position:rCamPosKpt.Position,tname:rCamPosKpt.KeynameKey,tvalue:rCamPosKpt.KeyvalueKey,impX:rCamPosKpt.Impressions,cts:rCamPosKpt.Clickthrus ############################################################################### # # Site, Section and Position Based Search Term Processing Summaries # ############################################################################### [rSitSqs.db] KeyEntities=account,site,sortedqs OutputFields=accountkey:rSitSqs.Account,site:rSitSqs.Site,sortedqs:rSitSqs.SqsKey,impX:rSitSqs.Impressions,cts:rSitSqs.Clickthrus [rSitKw.db] KeyEntities=account,site,keyword OutputFields=accountkey:rSitKw.Account,site:rSitKw.Site,keyword:rSitKw.KeywordKey,impX:rSitKw.Impressions,cts:rSitKw.Clickthrus [rSitKp.db] KeyEntities=account,site,name,value OutputFields=accountkey:rSitKp.Account,site:rSitKp.Site,name:rSitKp.KeynameKey,value:rSitKp.KeyvalueKey,impX:rSitKp.Impressions,cts:rSitKp.Clickthrus [rSecSqs.db] KeyEntities=account,section,sortedqs OutputFields=accountkey:rSecSqs.Account,section:rSecSqs.Section,sortedqs:rSecSqs.SqsKey,impX:rSecSqs.Impressions,cts:rSecSqs.Clickthrus [rSecKw.db] KeyEntities=account,section,keyword OutputFields=accountkey:rSecKw.Account,section:rSecKw.Section,keyword:rSecKw.KeywordKey,impX:rSecKw.Impressions,cts:rSecKw.Clickthrus [rSecKp.db] KeyEntities=account,section,name,value OutputFields=accountkey:rSecKp.Account,section:rSecKp.Section,name:rSecKp.KeynameKey,value:rSecKp.KeyvalueKey,impX:rSecKp.Impressions,cts:rSecKp.Clickthrus [rPosSqs.db] KeyEntities=account,position,sortedqs OutputFields=accountkey:rPosSqs.Account,position:rPosSqs.Position,sortedqs:rPosSqs.SqsKey,impX:rPosSqs.Impressions,cts:rPosSqs.Clickthrus [rPosKw.db] KeyEntities=account,position,keyword OutputFields=accountkey:rPosKw.Account,position:rPosKw.Position,keyword:rPosKw.KeywordKey,impX:rPosKw.Impressions,cts:rPosKw.Clickthrus [rPosKp.db] KeyEntities=account,position,name,value OutputFields=accountkey:rPosKp.Account,position:rPosKp.Position,name:rPosKp.KeynameKey,value:rPosKp.KeyvalueKey,impX:rPosKp.Impressions,cts:rPosKp.Clickthrus [rSitSecSqs.db] KeyEntities=account,site,section,sortedqs OutputFields=accountkey:rSitSecSqs.Account,site:rSitSecSqs.Site,section:rSitSecSqs.Section,sortedqs:rSitSecSqs.SqsKey,impX:rSitSecSqs.Impressions,cts:rSitSecSqs.Clickthrus [rSitSecKw.db] KeyEntities=account,site,section,keyword OutputFields=accountkey:rSitSecKw.Account,site:rSitSecKw.Site,section:rSitSecKw.Section,keyword:rSitSecKw.KeywordKey,impX:rSitSecKw.Impressions,cts:rSitSecKw.Clickthrus [rSitSecKp.db] KeyEntities=account,site,section,name,value OutputFields=accountkey:rSitSecKp.Account,site:rSitSecKp.Site,section:rSitSecKp.Section,name:rSitSecKp.KeynameKey,value:rSitSecKp.KeyvalueKey,impX:rSitSecKp.Impressions,cts:rSitSecKp.Clickthrus [rSitPosSqs.db] KeyEntities=account,site,position,sortedqs OutputFields=accountkey:rSitPosSqs.Account,site:rSitPosSqs.Site,position:rSitPosSqs.Position,sortedqs:rSitPosSqs.SqsKey,impX:rSitPosSqs.Impressions,cts:rSitPosSqs.Clickthrus [rSitPosKw.db] KeyEntities=account,site,position,keyword OutputFields=accountkey:rSitPosKw.Account,site:rSitPosKw.Site,position:rSitPosKw.Position,keyword:rSitPosKw.KeywordKey,impX:rSitPosKw.Impressions,cts:rSitPosKw.Clickthrus [rSitPosKp.db] KeyEntities=account,site,position,name,value OutputFields=accountkey:rSitPosKp.Account,site:rSitPosKp.Site,position:rSitPosKp.Position,name:rSitPosKp.KeynameKey,value:rSitPosKp.KeyvalueKey,impX:rSitPosKp.Impressions,cts:rSitPosKp.Clickthrus [rSecPosSqs.db] KeyEntities=account,section,position,sortedqs OutputFields=accountkey:rSecPosSqs.Account,section:rSecPosSqs.Section,position:rSecPosSqs.Position,sortedqs:rSecPosSqs.SqsKey,impX:rSecPosSqs.Impressions,cts:rSecPosSqs.Clickthrus [rSecPosKw.db] KeyEntities=account,section,position,keyword OutputFields=accountkey:rSecPosKw.Account,section:rSecPosKw.Section,position:rSecPosKw.Position,keyword:rSecPosKw.KeywordKey,impX:rSecPosKw.Impressions,cts:rSecPosKw.Clickthrus [rSecPosKp.db] KeyEntities=account,section,position,name,value OutputFields=accountkey:rSecPosKp.Account,section:rSecPosKp.Section,position:rSecPosKp.Position,name:rSecPosKp.KeynameKey,value:rSecPosKp.KeyvalueKey,impX:rSecPosKp.Impressions,cts:rSecPosKp.Clickthrus ############################################################################### # Geo-Inventory table definitions # [City.db] OutputFields=X:City.Country,X:City.State,X:City.City,X:City.CityKey [Continent.db] OutputFields=X:Continent.Code,X:Continent.Name,X:Continent.ContinentKey [Msa.db] OutputFields=X:Msa.Code,X:Msa.Name,X:Msa.MsaKey [Dma.db] OutputFields=X:Dma.Code,X:Dma.Name,X:Dma.Rank,X:Dma.DmaKey [iSecAre.db] OutputFields=X:iSecAre.Account,X:iSecAre.Section,X:iSecAre.Area,X:iSecAre.Impressions,X:iSecAre.Clickthrus [iSecBw.db] OutputFields=X:iSecBw.Account,X:iSecBw.Section,X:iSecBw.Bw,X:iSecBw.Impressions,X:iSecBw.Clickthrus [iSecCit.db] OutputFields=X:iSecCit.Account,X:iSecCit.Section,X:iSecCit.City,X:iSecCit.Impressions,X:iSecCit.Clickthrus [iSecCon.db] OutputFields=X:iSecCon.Account,X:iSecCon.Section,X:iSecCon.Continent,X:iSecCon.Impressions,X:iSecCon.Clickthrus [iSecCou.db] OutputFields=X:iSecCou.Account,X:iSecCou.Section,X:iSecCou.Country,X:iSecCou.Impressions,X:iSecCou.Clickthrus [iSecDma.db] OutputFields=X:iSecDma.Account,X:iSecDma.Section,X:iSecDma.Dma,X:iSecDma.Impressions,X:iSecDma.Clickthrus [iSecMsa.db] OutputFields=X:iSecMsa.Account,X:iSecMsa.Section,X:iSecMsa.Msa,X:iSecMsa.Impressions,X:iSecMsa.Clickthrus [iSecSta.db] OutputFields=X:iSecSta.Account,X:iSecSta.Section,X:iSecSta.State,X:iSecSta.Impressions,X:iSecSta.Clickthrus [iSecZip.db] OutputFields=X:iSecZip.Account,X:iSecZip.Section,X:iSecZip.Zip,X:iSecZip.Impressions,X:iSecZip.Clickthrus [iSitAre.db] OutputFields=X:iSitAre.Account,X:iSitAre.Site,X:iSitAre.Area,X:iSitAre.Impressions,X:iSitAre.Clickthrus [iSitBw.db] OutputFields=X:iSitBw.Account,X:iSitBw.Site,X:iSitBw.Bw,X:iSitBw.Impressions,X:iSitBw.Clickthrus [iSitCit.db] OutputFields=X:iSitCit.Account,X:iSitCit.Site,X:iSitCit.City,X:iSitCit.Impressions,X:iSitCit.Clickthrus [iSitCon.db] OutputFields=X:iSitCon.Account,X:iSitCon.Site,X:iSitCon.Continent,X:iSitCon.Impressions,X:iSitCon.Clickthrus [iSitCou.db] OutputFields=X:iSitCou.Account,X:iSitCou.Site,X:iSitCou.Country,X:iSitCou.Impressions,X:iSitCou.Clickthrus [iSitDma.db] OutputFields=X:iSitDma.Account,X:iSitDma.Site,X:iSitDma.Dma,X:iSitDma.Impressions,X:iSitDma.Clickthrus [iSitMsa.db] OutputFields=X:iSitMsa.Account,X:iSitMsa.Site,X:iSitMsa.Msa,X:iSitMsa.Impressions,X:iSitMsa.Clickthrus [iSitSta.db] OutputFields=X:iSitSta.Account,X:iSitSta.Site,X:iSitSta.State,X:iSitSta.Impressions,X:iSitSta.Clickthrus [iSitZip.db] OutputFields=X:iSitZip.Account,X:iSitZip.Site,X:iSitZip.Zip,X:iSitZip.Impressions,X:iSitZip.Clickthrus ############################################################################### # Insight ACT summary tables ############################################################################### [wCamBanSitSegm.act] KeyEntities=account,camp,banner,site,mseg OutputFields=accountkey:wCamBanSitSegm.Account,camp:wCamBanSitSegm.Campaign,banner:wCamBanSitSegm.Creative,site:wCamBanSitSegm.Site,mseg:wCamBanSitSegm.Segm,impX:wCamBanSitSegm.Impressions,cts:wCamBanSitSegm.Clickthrus [wCamBanSecSegm.act] KeyEntities=account,camp,banner,section,mseg OutputFields=accountkey:wCamBanSecSegm.Account,camp:wCamBanSecSegm.Campaign,banner:wCamBanSecSegm.Creative,section:wCamBanSecSegm.Section,mseg:wCamBanSecSegm.Segm,impX:wCamBanSecSegm.Impressions,cts:wCamBanSecSegm.Clickthrus [wCamBanPosSegm.act] KeyEntities=account,camp,banner,position,mseg OutputFields=accountkey:wCamBanPosSegm.Account,camp:wCamBanPosSegm.Campaign,banner:wCamBanPosSegm.Creative,position:wCamBanPosSegm.Position,mseg:wCamBanPosSegm.Segm,impX:wCamBanPosSegm.Impressions,cts:wCamBanPosSegm.Clickthrus [rSegc.act] KeyEntities=account,segcomp OutputFields=accountkey:rSegc.Account,segcomp:rSegc.Segc,impX:rSegc.Impressions,cts:rSegc.Clickthrus ############################################################################### # Reach and Freq summary tables ############################################################################### [rAdvARF.db] KeyEntities=rmwhen,AdvertiserKey OutputFields=AdvertiserKey:rAdvARF.AdvertiserKey,rmwhen:rAdvARF.RmWhen,mycol1:rAdvARF.ToDateUnknown,mycol2:rAdvARF.YearlyUnknown,mycol3:rAdvARF.MonthlyUnknown,mycol4:rAdvARF.WeeklyUnknown,mycol5:rAdvARF.DailyUnknown [rCamARF.db] KeyEntities=rmwhen,CampaignKey OutputFields=CampaignKey:rCamARF.CampaignKey,rmwhen:rCamARF.RmWhen,mycol1:rCamARF.ToDateUnknown,mycol2:rCamARF.YearlyUnknown,mycol3:rCamARF.MonthlyUnknown,mycol4:rCamARF.WeeklyUnknown,mycol5:rCamARF.DailyUnknown [rCamGrpARF.db] KeyEntities=rmwhen,CampaignGroupKey OutputFields=CampaignGroupKey:rCamGrpARF.CampaignGroupKey,rmwhen:rCamGrpARF.RmWhen,mycol1:rCamGrpARF.ToDateUnknown,mycol2:rCamGrpARF.YearlyUnknown,mycol3:rCamGrpARF.MonthlyUnknown,mycol4:rCamGrpARF.WeeklyUnknown,mycol5:rCamGrpARF.DailyUnknown [rSecARF.db] KeyEntities=rmwhen,SectionKey OutputFields=SectionKey:rSecARF.SectionKey,rmwhen:rSecARF.RmWhen,mycol1:rSecARF.ToDateUnknown,mycol2:rSecARF.YearlyUnknown,mycol3:rSecARF.MonthlyUnknown,mycol4:rSecARF.WeeklyUnknown,mycol5:rSecARF.DailyUnknown [rSitARF.db] KeyEntities=rmwhen,SiteKey OutputFields=SiteKey:rSitARF.SiteKey,rmwhen:rSitARF.RmWhen,mycol1:rSitARF.ToDateUnknown,mycol2:rSitARF.YearlyUnknown,mycol3:rSitARF.MonthlyUnknown,mycol4:rSitARF.WeeklyUnknown,mycol5:rSitARF.DailyUnknown [rSitGrpARF.db] KeyEntities=rmwhen,SiteGroupKey OutputFields=SiteGroupKey:rSitGrpARF.SiteGroupKey,rmwhen:rSitGrpARF.RmWhen,mycol1:rSitGrpARF.ToDateUnknown,mycol2:rSitGrpARF.YearlyUnknown,mycol3:rSitGrpARF.MonthlyUnknown,mycol4:rSitGrpARF.WeeklyUnknown,mycol5:rSitGrpARF.DailyUnknown [rAdvRF.db] KeyEntities=rmwhen,AdvertiserKey OutputFields=AdvertiserKey:rAdvRF.AdvertiserKey,rmwhen:rAdvRF.RmWhen,mycol1:rAdvRF.ToDateCount,mycol2:rAdvRF.ToDateNew,mycol3:rAdvRF.ToDateFreq1,mycol4:rAdvRF.ToDateFreq2,mycol5:rAdvRF.ToDateFreq3,mycol6:rAdvRF.ToDateFreq4,mycol7:rAdvRF.ToDateFreq5,mycol8:rAdvRF.ToDateFreq6,mycol9:rAdvRF.ToDateFreq7,mycol10:rAdvRF.ToDateFreq8,mycol11:rAdvRF.ToDateFreq9,mycol12:rAdvRF.ToDateFreq10,mycol13:rAdvRF.YearlyCount,mycol14:rAdvRF.YearlyNew,mycol15:rAdvRF.YearlyFreq1,mycol16:rAdvRF.YearlyFreq2,mycol17:rAdvRF.YearlyFreq3,mycol18:rAdvRF.YearlyFreq4,mycol19:rAdvRF.YearlyFreq5,mycol20:rAdvRF.YearlyFreq6,mycol21:rAdvRF.YearlyFreq7,mycol22:rAdvRF.YearlyFreq8,mycol23:rAdvRF.YearlyFreq9,mycol24:rAdvRF.YearlyFreq10,mycol25:rAdvRF.MonthlyCount,mycol26:rAdvRF.MonthlyNew,mycol27:rAdvRF.MonthlyFreq1,mycol28:rAdvRF.MonthlyFreq2,mycol29:rAdvRF.MonthlyFreq3,mycol30:rAdvRF.MonthlyFreq4,mycol31:rAdvRF.MonthlyFreq5,mycol32:rAdvRF.MonthlyFreq6,mycol33:rAdvRF.MonthlyFreq7,mycol34:rAdvRF.MonthlyFreq8,mycol35:rAdvRF.MonthlyFreq9,mycol36:rAdvRF.MonthlyFreq10,mycol37:rAdvRF.WeeklyCount,mycol38:rAdvRF.WeeklyNew,mycol39:rAdvRF.WeeklyFreq1,mycol40:rAdvRF.WeeklyFreq2,mycol41:rAdvRF.WeeklyFreq3,mycol42:rAdvRF.WeeklyFreq4,mycol43:rAdvRF.WeeklyFreq5,mycol44:rAdvRF.WeeklyFreq6,mycol45:rAdvRF.WeeklyFreq7,mycol46:rAdvRF.WeeklyFreq8,mycol47:rAdvRF.WeeklyFreq9,mycol48:rAdvRF.WeeklyFreq10,mycol49:rAdvRF.DailyCount,mycol50:rAdvRF.DailyNew,mycol51:rAdvRF.DailyFreq1,mycol52:rAdvRF.DailyFreq2,mycol53:rAdvRF.DailyFreq3,mycol54:rAdvRF.DailyFreq4,mycol55:rAdvRF.DailyFreq5,mycol56:rAdvRF.DailyFreq6,mycol57:rAdvRF.DailyFreq7,mycol58:rAdvRF.DailyFreq8,mycol59:rAdvRF.DailyFreq9,mycol60:rAdvRF.DailyFreq10 [rAdvSitRF.db] KeyEntities=rmwhen,AdvertiserKey,SiteKey OutputFields=AdvertiserKey:rAdvSitRF.AdvertiserKey,SiteKey:rAdvSitRF.SiteKey,rmwhen:rAdvSitRF.RmWhen,mycol1:rAdvSitRF.ToDateCount,mycol2:rAdvSitRF.ToDateNew,mycol3:rAdvSitRF.ToDateFreq1,mycol4:rAdvSitRF.ToDateFreq2,mycol5:rAdvSitRF.ToDateFreq3,mycol6:rAdvSitRF.ToDateFreq4,mycol7:rAdvSitRF.ToDateFreq5,mycol8:rAdvSitRF.ToDateFreq6,mycol9:rAdvSitRF.ToDateFreq7,mycol10:rAdvSitRF.ToDateFreq8,mycol11:rAdvSitRF.ToDateFreq9,mycol12:rAdvSitRF.ToDateFreq10,mycol13:rAdvSitRF.YearlyCount,mycol14:rAdvSitRF.YearlyNew,mycol15:rAdvSitRF.YearlyFreq1,mycol16:rAdvSitRF.YearlyFreq2,mycol17:rAdvSitRF.YearlyFreq3,mycol18:rAdvSitRF.YearlyFreq4,mycol19:rAdvSitRF.YearlyFreq5,mycol20:rAdvSitRF.YearlyFreq6,mycol21:rAdvSitRF.YearlyFreq7,mycol22:rAdvSitRF.YearlyFreq8,mycol23:rAdvSitRF.YearlyFreq9,mycol24:rAdvSitRF.YearlyFreq10,mycol25:rAdvSitRF.MonthlyCount,mycol26:rAdvSitRF.MonthlyNew,mycol27:rAdvSitRF.MonthlyFreq1,mycol28:rAdvSitRF.MonthlyFreq2,mycol29:rAdvSitRF.MonthlyFreq3,mycol30:rAdvSitRF.MonthlyFreq4,mycol31:rAdvSitRF.MonthlyFreq5,mycol32:rAdvSitRF.MonthlyFreq6,mycol33:rAdvSitRF.MonthlyFreq7,mycol34:rAdvSitRF.MonthlyFreq8,mycol35:rAdvSitRF.MonthlyFreq9,mycol36:rAdvSitRF.MonthlyFreq10,mycol37:rAdvSitRF.WeeklyCount,mycol38:rAdvSitRF.WeeklyNew,mycol39:rAdvSitRF.WeeklyFreq1,mycol40:rAdvSitRF.WeeklyFreq2,mycol41:rAdvSitRF.WeeklyFreq3,mycol42:rAdvSitRF.WeeklyFreq4,mycol43:rAdvSitRF.WeeklyFreq5,mycol44:rAdvSitRF.WeeklyFreq6,mycol45:rAdvSitRF.WeeklyFreq7,mycol46:rAdvSitRF.WeeklyFreq8,mycol47:rAdvSitRF.WeeklyFreq9,mycol48:rAdvSitRF.WeeklyFreq10,mycol49:rAdvSitRF.DailyCount,mycol50:rAdvSitRF.DailyNew,mycol51:rAdvSitRF.DailyFreq1,mycol52:rAdvSitRF.DailyFreq2,mycol53:rAdvSitRF.DailyFreq3,mycol54:rAdvSitRF.DailyFreq4,mycol55:rAdvSitRF.DailyFreq5,mycol56:rAdvSitRF.DailyFreq6,mycol57:rAdvSitRF.DailyFreq7,mycol58:rAdvSitRF.DailyFreq8,mycol59:rAdvSitRF.DailyFreq9,mycol60:rAdvSitRF.DailyFreq10 [rCamCamGrpRF.db] KeyEntities=rmwhen,CampaignKey,CampaignGroupKey OutputFields=CampaignKey:rCamCamGrpRF.CampaignKey,CampaignGroupKey:rCamCamGrpRF.CampaignGroupKey,rmwhen:rCamCamGrpRF.RmWhen,mycol1:rCamCamGrpRF.ToDateCount,mycol2:rCamCamGrpRF.ToDateNew,mycol3:rCamCamGrpRF.ToDateFreq1,mycol4:rCamCamGrpRF.ToDateFreq2,mycol5:rCamCamGrpRF.ToDateFreq3,mycol6:rCamCamGrpRF.ToDateFreq4,mycol7:rCamCamGrpRF.ToDateFreq5,mycol8:rCamCamGrpRF.ToDateFreq6,mycol9:rCamCamGrpRF.ToDateFreq7,mycol10:rCamCamGrpRF.ToDateFreq8,mycol11:rCamCamGrpRF.ToDateFreq9,mycol12:rCamCamGrpRF.ToDateFreq10,mycol13:rCamCamGrpRF.YearlyCount,mycol14:rCamCamGrpRF.YearlyNew,mycol15:rCamCamGrpRF.YearlyFreq1,mycol16:rCamCamGrpRF.YearlyFreq2,mycol17:rCamCamGrpRF.YearlyFreq3,mycol18:rCamCamGrpRF.YearlyFreq4,mycol19:rCamCamGrpRF.YearlyFreq5,mycol20:rCamCamGrpRF.YearlyFreq6,mycol21:rCamCamGrpRF.YearlyFreq7,mycol22:rCamCamGrpRF.YearlyFreq8,mycol23:rCamCamGrpRF.YearlyFreq9,mycol24:rCamCamGrpRF.YearlyFreq10,mycol25:rCamCamGrpRF.MonthlyCount,mycol26:rCamCamGrpRF.MonthlyNew,mycol27:rCamCamGrpRF.MonthlyFreq1,mycol28:rCamCamGrpRF.MonthlyFreq2,mycol29:rCamCamGrpRF.MonthlyFreq3,mycol30:rCamCamGrpRF.MonthlyFreq4,mycol31:rCamCamGrpRF.MonthlyFreq5,mycol32:rCamCamGrpRF.MonthlyFreq6,mycol33:rCamCamGrpRF.MonthlyFreq7,mycol34:rCamCamGrpRF.MonthlyFreq8,mycol35:rCamCamGrpRF.MonthlyFreq9,mycol36:rCamCamGrpRF.MonthlyFreq10,mycol37:rCamCamGrpRF.WeeklyCount,mycol38:rCamCamGrpRF.WeeklyNew,mycol39:rCamCamGrpRF.WeeklyFreq1,mycol40:rCamCamGrpRF.WeeklyFreq2,mycol41:rCamCamGrpRF.WeeklyFreq3,mycol42:rCamCamGrpRF.WeeklyFreq4,mycol43:rCamCamGrpRF.WeeklyFreq5,mycol44:rCamCamGrpRF.WeeklyFreq6,mycol45:rCamCamGrpRF.WeeklyFreq7,mycol46:rCamCamGrpRF.WeeklyFreq8,mycol47:rCamCamGrpRF.WeeklyFreq9,mycol48:rCamCamGrpRF.WeeklyFreq10,mycol49:rCamCamGrpRF.DailyCount,mycol50:rCamCamGrpRF.DailyNew,mycol51:rCamCamGrpRF.DailyFreq1,mycol52:rCamCamGrpRF.DailyFreq2,mycol53:rCamCamGrpRF.DailyFreq3,mycol54:rCamCamGrpRF.DailyFreq4,mycol55:rCamCamGrpRF.DailyFreq5,mycol56:rCamCamGrpRF.DailyFreq6,mycol57:rCamCamGrpRF.DailyFreq7,mycol58:rCamCamGrpRF.DailyFreq8,mycol59:rCamCamGrpRF.DailyFreq9,mycol60:rCamCamGrpRF.DailyFreq10 [rCamGrpRF.db] KeyEntities=rmwhen,CampaignGroupKey OutputFields=CampaignGroupKey:rCamGrpRF.CampaignGroupKey,rmwhen:rCamGrpRF.RmWhen,mycol1:rCamGrpRF.ToDateCount,mycol2:rCamGrpRF.ToDateNew,mycol3:rCamGrpRF.ToDateFreq1,mycol4:rCamGrpRF.ToDateFreq2,mycol5:rCamGrpRF.ToDateFreq3,mycol6:rCamGrpRF.ToDateFreq4,mycol7:rCamGrpRF.ToDateFreq5,mycol8:rCamGrpRF.ToDateFreq6,mycol9:rCamGrpRF.ToDateFreq7,mycol10:rCamGrpRF.ToDateFreq8,mycol11:rCamGrpRF.ToDateFreq9,mycol12:rCamGrpRF.ToDateFreq10,mycol13:rCamGrpRF.YearlyCount,mycol14:rCamGrpRF.YearlyNew,mycol15:rCamGrpRF.YearlyFreq1,mycol16:rCamGrpRF.YearlyFreq2,mycol17:rCamGrpRF.YearlyFreq3,mycol18:rCamGrpRF.YearlyFreq4,mycol19:rCamGrpRF.YearlyFreq5,mycol20:rCamGrpRF.YearlyFreq6,mycol21:rCamGrpRF.YearlyFreq7,mycol22:rCamGrpRF.YearlyFreq8,mycol23:rCamGrpRF.YearlyFreq9,mycol24:rCamGrpRF.YearlyFreq10,mycol25:rCamGrpRF.MonthlyCount,mycol26:rCamGrpRF.MonthlyNew,mycol27:rCamGrpRF.MonthlyFreq1,mycol28:rCamGrpRF.MonthlyFreq2,mycol29:rCamGrpRF.MonthlyFreq3,mycol30:rCamGrpRF.MonthlyFreq4,mycol31:rCamGrpRF.MonthlyFreq5,mycol32:rCamGrpRF.MonthlyFreq6,mycol33:rCamGrpRF.MonthlyFreq7,mycol34:rCamGrpRF.MonthlyFreq8,mycol35:rCamGrpRF.MonthlyFreq9,mycol36:rCamGrpRF.MonthlyFreq10,mycol37:rCamGrpRF.WeeklyCount,mycol38:rCamGrpRF.WeeklyNew,mycol39:rCamGrpRF.WeeklyFreq1,mycol40:rCamGrpRF.WeeklyFreq2,mycol41:rCamGrpRF.WeeklyFreq3,mycol42:rCamGrpRF.WeeklyFreq4,mycol43:rCamGrpRF.WeeklyFreq5,mycol44:rCamGrpRF.WeeklyFreq6,mycol45:rCamGrpRF.WeeklyFreq7,mycol46:rCamGrpRF.WeeklyFreq8,mycol47:rCamGrpRF.WeeklyFreq9,mycol48:rCamGrpRF.WeeklyFreq10,mycol49:rCamGrpRF.DailyCount,mycol50:rCamGrpRF.DailyNew,mycol51:rCamGrpRF.DailyFreq1,mycol52:rCamGrpRF.DailyFreq2,mycol53:rCamGrpRF.DailyFreq3,mycol54:rCamGrpRF.DailyFreq4,mycol55:rCamGrpRF.DailyFreq5,mycol56:rCamGrpRF.DailyFreq6,mycol57:rCamGrpRF.DailyFreq7,mycol58:rCamGrpRF.DailyFreq8,mycol59:rCamGrpRF.DailyFreq9,mycol60:rCamGrpRF.DailyFreq10 [rCamGrpSitRF.db] KeyEntities=rmwhen,CampaignGroupKey,SiteKey OutputFields=CampaignGroupKey:rCamGrpSitRF.CampaignGroupKey,SiteKey:rCamGrpSitRF.SiteKey,rmwhen:rCamGrpSitRF.RmWhen,mycol1:rCamGrpSitRF.ToDateCount,mycol2:rCamGrpSitRF.ToDateNew,mycol3:rCamGrpSitRF.ToDateFreq1,mycol4:rCamGrpSitRF.ToDateFreq2,mycol5:rCamGrpSitRF.ToDateFreq3,mycol6:rCamGrpSitRF.ToDateFreq4,mycol7:rCamGrpSitRF.ToDateFreq5,mycol8:rCamGrpSitRF.ToDateFreq6,mycol9:rCamGrpSitRF.ToDateFreq7,mycol10:rCamGrpSitRF.ToDateFreq8,mycol11:rCamGrpSitRF.ToDateFreq9,mycol12:rCamGrpSitRF.ToDateFreq10,mycol13:rCamGrpSitRF.YearlyCount,mycol14:rCamGrpSitRF.YearlyNew,mycol15:rCamGrpSitRF.YearlyFreq1,mycol16:rCamGrpSitRF.YearlyFreq2,mycol17:rCamGrpSitRF.YearlyFreq3,mycol18:rCamGrpSitRF.YearlyFreq4,mycol19:rCamGrpSitRF.YearlyFreq5,mycol20:rCamGrpSitRF.YearlyFreq6,mycol21:rCamGrpSitRF.YearlyFreq7,mycol22:rCamGrpSitRF.YearlyFreq8,mycol23:rCamGrpSitRF.YearlyFreq9,mycol24:rCamGrpSitRF.YearlyFreq10,mycol25:rCamGrpSitRF.MonthlyCount,mycol26:rCamGrpSitRF.MonthlyNew,mycol27:rCamGrpSitRF.MonthlyFreq1,mycol28:rCamGrpSitRF.MonthlyFreq2,mycol29:rCamGrpSitRF.MonthlyFreq3,mycol30:rCamGrpSitRF.MonthlyFreq4,mycol31:rCamGrpSitRF.MonthlyFreq5,mycol32:rCamGrpSitRF.MonthlyFreq6,mycol33:rCamGrpSitRF.MonthlyFreq7,mycol34:rCamGrpSitRF.MonthlyFreq8,mycol35:rCamGrpSitRF.MonthlyFreq9,mycol36:rCamGrpSitRF.MonthlyFreq10,mycol37:rCamGrpSitRF.WeeklyCount,mycol38:rCamGrpSitRF.WeeklyNew,mycol39:rCamGrpSitRF.WeeklyFreq1,mycol40:rCamGrpSitRF.WeeklyFreq2,mycol41:rCamGrpSitRF.WeeklyFreq3,mycol42:rCamGrpSitRF.WeeklyFreq4,mycol43:rCamGrpSitRF.WeeklyFreq5,mycol44:rCamGrpSitRF.WeeklyFreq6,mycol45:rCamGrpSitRF.WeeklyFreq7,mycol46:rCamGrpSitRF.WeeklyFreq8,mycol47:rCamGrpSitRF.WeeklyFreq9,mycol48:rCamGrpSitRF.WeeklyFreq10,mycol49:rCamGrpSitRF.DailyCount,mycol50:rCamGrpSitRF.DailyNew,mycol51:rCamGrpSitRF.DailyFreq1,mycol52:rCamGrpSitRF.DailyFreq2,mycol53:rCamGrpSitRF.DailyFreq3,mycol54:rCamGrpSitRF.DailyFreq4,mycol55:rCamGrpSitRF.DailyFreq5,mycol56:rCamGrpSitRF.DailyFreq6,mycol57:rCamGrpSitRF.DailyFreq7,mycol58:rCamGrpSitRF.DailyFreq8,mycol59:rCamGrpSitRF.DailyFreq9,mycol60:rCamGrpSitRF.DailyFreq10 [rCamRF.db] KeyEntities=rmwhen,CampaignKey OutputFields=CampaignKey:rCamRF.CampaignKey,rmwhen:rCamRF.RmWhen,mycol1:rCamRF.ToDateCount,mycol2:rCamRF.ToDateNew,mycol3:rCamRF.ToDateFreq1,mycol4:rCamRF.ToDateFreq2,mycol5:rCamRF.ToDateFreq3,mycol6:rCamRF.ToDateFreq4,mycol7:rCamRF.ToDateFreq5,mycol8:rCamRF.ToDateFreq6,mycol9:rCamRF.ToDateFreq7,mycol10:rCamRF.ToDateFreq8,mycol11:rCamRF.ToDateFreq9,mycol12:rCamRF.ToDateFreq10,mycol13:rCamRF.YearlyCount,mycol14:rCamRF.YearlyNew,mycol15:rCamRF.YearlyFreq1,mycol16:rCamRF.YearlyFreq2,mycol17:rCamRF.YearlyFreq3,mycol18:rCamRF.YearlyFreq4,mycol19:rCamRF.YearlyFreq5,mycol20:rCamRF.YearlyFreq6,mycol21:rCamRF.YearlyFreq7,mycol22:rCamRF.YearlyFreq8,mycol23:rCamRF.YearlyFreq9,mycol24:rCamRF.YearlyFreq10,mycol25:rCamRF.MonthlyCount,mycol26:rCamRF.MonthlyNew,mycol27:rCamRF.MonthlyFreq1,mycol28:rCamRF.MonthlyFreq2,mycol29:rCamRF.MonthlyFreq3,mycol30:rCamRF.MonthlyFreq4,mycol31:rCamRF.MonthlyFreq5,mycol32:rCamRF.MonthlyFreq6,mycol33:rCamRF.MonthlyFreq7,mycol34:rCamRF.MonthlyFreq8,mycol35:rCamRF.MonthlyFreq9,mycol36:rCamRF.MonthlyFreq10,mycol37:rCamRF.WeeklyCount,mycol38:rCamRF.WeeklyNew,mycol39:rCamRF.WeeklyFreq1,mycol40:rCamRF.WeeklyFreq2,mycol41:rCamRF.WeeklyFreq3,mycol42:rCamRF.WeeklyFreq4,mycol43:rCamRF.WeeklyFreq5,mycol44:rCamRF.WeeklyFreq6,mycol45:rCamRF.WeeklyFreq7,mycol46:rCamRF.WeeklyFreq8,mycol47:rCamRF.WeeklyFreq9,mycol48:rCamRF.WeeklyFreq10,mycol49:rCamRF.DailyCount,mycol50:rCamRF.DailyNew,mycol51:rCamRF.DailyFreq1,mycol52:rCamRF.DailyFreq2,mycol53:rCamRF.DailyFreq3,mycol54:rCamRF.DailyFreq4,mycol55:rCamRF.DailyFreq5,mycol56:rCamRF.DailyFreq6,mycol57:rCamRF.DailyFreq7,mycol58:rCamRF.DailyFreq8,mycol59:rCamRF.DailyFreq9,mycol60:rCamRF.DailyFreq10 [rCamSecRF.db] KeyEntities=rmwhen,CampaignKey,SectionKey OutputFields=CampaignKey:rCamSecRF.CampaignKey,SectionKey:rCamSecRF.SectionKey,rmwhen:rCamSecRF.RmWhen,mycol1:rCamSecRF.ToDateCount,mycol2:rCamSecRF.ToDateNew,mycol3:rCamSecRF.ToDateFreq1,mycol4:rCamSecRF.ToDateFreq2,mycol5:rCamSecRF.ToDateFreq3,mycol6:rCamSecRF.ToDateFreq4,mycol7:rCamSecRF.ToDateFreq5,mycol8:rCamSecRF.ToDateFreq6,mycol9:rCamSecRF.ToDateFreq7,mycol10:rCamSecRF.ToDateFreq8,mycol11:rCamSecRF.ToDateFreq9,mycol12:rCamSecRF.ToDateFreq10,mycol13:rCamSecRF.YearlyCount,mycol14:rCamSecRF.YearlyNew,mycol15:rCamSecRF.YearlyFreq1,mycol16:rCamSecRF.YearlyFreq2,mycol17:rCamSecRF.YearlyFreq3,mycol18:rCamSecRF.YearlyFreq4,mycol19:rCamSecRF.YearlyFreq5,mycol20:rCamSecRF.YearlyFreq6,mycol21:rCamSecRF.YearlyFreq7,mycol22:rCamSecRF.YearlyFreq8,mycol23:rCamSecRF.YearlyFreq9,mycol24:rCamSecRF.YearlyFreq10,mycol25:rCamSecRF.MonthlyCount,mycol26:rCamSecRF.MonthlyNew,mycol27:rCamSecRF.MonthlyFreq1,mycol28:rCamSecRF.MonthlyFreq2,mycol29:rCamSecRF.MonthlyFreq3,mycol30:rCamSecRF.MonthlyFreq4,mycol31:rCamSecRF.MonthlyFreq5,mycol32:rCamSecRF.MonthlyFreq6,mycol33:rCamSecRF.MonthlyFreq7,mycol34:rCamSecRF.MonthlyFreq8,mycol35:rCamSecRF.MonthlyFreq9,mycol36:rCamSecRF.MonthlyFreq10,mycol37:rCamSecRF.WeeklyCount,mycol38:rCamSecRF.WeeklyNew,mycol39:rCamSecRF.WeeklyFreq1,mycol40:rCamSecRF.WeeklyFreq2,mycol41:rCamSecRF.WeeklyFreq3,mycol42:rCamSecRF.WeeklyFreq4,mycol43:rCamSecRF.WeeklyFreq5,mycol44:rCamSecRF.WeeklyFreq6,mycol45:rCamSecRF.WeeklyFreq7,mycol46:rCamSecRF.WeeklyFreq8,mycol47:rCamSecRF.WeeklyFreq9,mycol48:rCamSecRF.WeeklyFreq10,mycol49:rCamSecRF.DailyCount,mycol50:rCamSecRF.DailyNew,mycol51:rCamSecRF.DailyFreq1,mycol52:rCamSecRF.DailyFreq2,mycol53:rCamSecRF.DailyFreq3,mycol54:rCamSecRF.DailyFreq4,mycol55:rCamSecRF.DailyFreq5,mycol56:rCamSecRF.DailyFreq6,mycol57:rCamSecRF.DailyFreq7,mycol58:rCamSecRF.DailyFreq8,mycol59:rCamSecRF.DailyFreq9,mycol60:rCamSecRF.DailyFreq10 [rCamSitGrpRF.db] KeyEntities=rmwhen,CampaignKey,SiteGroupKey OutputFields=CampaignKey:rCamSitGrpRF.CampaignKey,SiteGroupKey:rCamSitGrpRF.SiteGroupKey,rmwhen:rCamSitGrpRF.RmWhen,mycol1:rCamSitGrpRF.ToDateCount,mycol2:rCamSitGrpRF.ToDateNew,mycol3:rCamSitGrpRF.ToDateFreq1,mycol4:rCamSitGrpRF.ToDateFreq2,mycol5:rCamSitGrpRF.ToDateFreq3,mycol6:rCamSitGrpRF.ToDateFreq4,mycol7:rCamSitGrpRF.ToDateFreq5,mycol8:rCamSitGrpRF.ToDateFreq6,mycol9:rCamSitGrpRF.ToDateFreq7,mycol10:rCamSitGrpRF.ToDateFreq8,mycol11:rCamSitGrpRF.ToDateFreq9,mycol12:rCamSitGrpRF.ToDateFreq10,mycol13:rCamSitGrpRF.YearlyCount,mycol14:rCamSitGrpRF.YearlyNew,mycol15:rCamSitGrpRF.YearlyFreq1,mycol16:rCamSitGrpRF.YearlyFreq2,mycol17:rCamSitGrpRF.YearlyFreq3,mycol18:rCamSitGrpRF.YearlyFreq4,mycol19:rCamSitGrpRF.YearlyFreq5,mycol20:rCamSitGrpRF.YearlyFreq6,mycol21:rCamSitGrpRF.YearlyFreq7,mycol22:rCamSitGrpRF.YearlyFreq8,mycol23:rCamSitGrpRF.YearlyFreq9,mycol24:rCamSitGrpRF.YearlyFreq10,mycol25:rCamSitGrpRF.MonthlyCount,mycol26:rCamSitGrpRF.MonthlyNew,mycol27:rCamSitGrpRF.MonthlyFreq1,mycol28:rCamSitGrpRF.MonthlyFreq2,mycol29:rCamSitGrpRF.MonthlyFreq3,mycol30:rCamSitGrpRF.MonthlyFreq4,mycol31:rCamSitGrpRF.MonthlyFreq5,mycol32:rCamSitGrpRF.MonthlyFreq6,mycol33:rCamSitGrpRF.MonthlyFreq7,mycol34:rCamSitGrpRF.MonthlyFreq8,mycol35:rCamSitGrpRF.MonthlyFreq9,mycol36:rCamSitGrpRF.MonthlyFreq10,mycol37:rCamSitGrpRF.WeeklyCount,mycol38:rCamSitGrpRF.WeeklyNew,mycol39:rCamSitGrpRF.WeeklyFreq1,mycol40:rCamSitGrpRF.WeeklyFreq2,mycol41:rCamSitGrpRF.WeeklyFreq3,mycol42:rCamSitGrpRF.WeeklyFreq4,mycol43:rCamSitGrpRF.WeeklyFreq5,mycol44:rCamSitGrpRF.WeeklyFreq6,mycol45:rCamSitGrpRF.WeeklyFreq7,mycol46:rCamSitGrpRF.WeeklyFreq8,mycol47:rCamSitGrpRF.WeeklyFreq9,mycol48:rCamSitGrpRF.WeeklyFreq10,mycol49:rCamSitGrpRF.DailyCount,mycol50:rCamSitGrpRF.DailyNew,mycol51:rCamSitGrpRF.DailyFreq1,mycol52:rCamSitGrpRF.DailyFreq2,mycol53:rCamSitGrpRF.DailyFreq3,mycol54:rCamSitGrpRF.DailyFreq4,mycol55:rCamSitGrpRF.DailyFreq5,mycol56:rCamSitGrpRF.DailyFreq6,mycol57:rCamSitGrpRF.DailyFreq7,mycol58:rCamSitGrpRF.DailyFreq8,mycol59:rCamSitGrpRF.DailyFreq9,mycol60:rCamSitGrpRF.DailyFreq10 [rCamSitRF.db] KeyEntities=rmwhen,CampaignKey,SiteKey OutputFields=CampaignKey:rCamSitRF.CampaignKey,SiteKey:rCamSitRF.SiteKey,rmwhen:rCamSitRF.RmWhen,mycol1:rCamSitRF.ToDateCount,mycol2:rCamSitRF.ToDateNew,mycol3:rCamSitRF.ToDateFreq1,mycol4:rCamSitRF.ToDateFreq2,mycol5:rCamSitRF.ToDateFreq3,mycol6:rCamSitRF.ToDateFreq4,mycol7:rCamSitRF.ToDateFreq5,mycol8:rCamSitRF.ToDateFreq6,mycol9:rCamSitRF.ToDateFreq7,mycol10:rCamSitRF.ToDateFreq8,mycol11:rCamSitRF.ToDateFreq9,mycol12:rCamSitRF.ToDateFreq10,mycol13:rCamSitRF.YearlyCount,mycol14:rCamSitRF.YearlyNew,mycol15:rCamSitRF.YearlyFreq1,mycol16:rCamSitRF.YearlyFreq2,mycol17:rCamSitRF.YearlyFreq3,mycol18:rCamSitRF.YearlyFreq4,mycol19:rCamSitRF.YearlyFreq5,mycol20:rCamSitRF.YearlyFreq6,mycol21:rCamSitRF.YearlyFreq7,mycol22:rCamSitRF.YearlyFreq8,mycol23:rCamSitRF.YearlyFreq9,mycol24:rCamSitRF.YearlyFreq10,mycol25:rCamSitRF.MonthlyCount,mycol26:rCamSitRF.MonthlyNew,mycol27:rCamSitRF.MonthlyFreq1,mycol28:rCamSitRF.MonthlyFreq2,mycol29:rCamSitRF.MonthlyFreq3,mycol30:rCamSitRF.MonthlyFreq4,mycol31:rCamSitRF.MonthlyFreq5,mycol32:rCamSitRF.MonthlyFreq6,mycol33:rCamSitRF.MonthlyFreq7,mycol34:rCamSitRF.MonthlyFreq8,mycol35:rCamSitRF.MonthlyFreq9,mycol36:rCamSitRF.MonthlyFreq10,mycol37:rCamSitRF.WeeklyCount,mycol38:rCamSitRF.WeeklyNew,mycol39:rCamSitRF.WeeklyFreq1,mycol40:rCamSitRF.WeeklyFreq2,mycol41:rCamSitRF.WeeklyFreq3,mycol42:rCamSitRF.WeeklyFreq4,mycol43:rCamSitRF.WeeklyFreq5,mycol44:rCamSitRF.WeeklyFreq6,mycol45:rCamSitRF.WeeklyFreq7,mycol46:rCamSitRF.WeeklyFreq8,mycol47:rCamSitRF.WeeklyFreq9,mycol48:rCamSitRF.WeeklyFreq10,mycol49:rCamSitRF.DailyCount,mycol50:rCamSitRF.DailyNew,mycol51:rCamSitRF.DailyFreq1,mycol52:rCamSitRF.DailyFreq2,mycol53:rCamSitRF.DailyFreq3,mycol54:rCamSitRF.DailyFreq4,mycol55:rCamSitRF.DailyFreq5,mycol56:rCamSitRF.DailyFreq6,mycol57:rCamSitRF.DailyFreq7,mycol58:rCamSitRF.DailyFreq8,mycol59:rCamSitRF.DailyFreq9,mycol60:rCamSitRF.DailyFreq10 [rSecRF.db] KeyEntities=rmwhen,SectionKey OutputFields=SectionKey:rSecRF.SectionKey,rmwhen:rSecRF.RmWhen,mycol1:rSecRF.ToDateCount,mycol2:rSecRF.ToDateNew,mycol3:rSecRF.ToDateFreq1,mycol4:rSecRF.ToDateFreq2,mycol5:rSecRF.ToDateFreq3,mycol6:rSecRF.ToDateFreq4,mycol7:rSecRF.ToDateFreq5,mycol8:rSecRF.ToDateFreq6,mycol9:rSecRF.ToDateFreq7,mycol10:rSecRF.ToDateFreq8,mycol11:rSecRF.ToDateFreq9,mycol12:rSecRF.ToDateFreq10,mycol13:rSecRF.YearlyCount,mycol14:rSecRF.YearlyNew,mycol15:rSecRF.YearlyFreq1,mycol16:rSecRF.YearlyFreq2,mycol17:rSecRF.YearlyFreq3,mycol18:rSecRF.YearlyFreq4,mycol19:rSecRF.YearlyFreq5,mycol20:rSecRF.YearlyFreq6,mycol21:rSecRF.YearlyFreq7,mycol22:rSecRF.YearlyFreq8,mycol23:rSecRF.YearlyFreq9,mycol24:rSecRF.YearlyFreq10,mycol25:rSecRF.MonthlyCount,mycol26:rSecRF.MonthlyNew,mycol27:rSecRF.MonthlyFreq1,mycol28:rSecRF.MonthlyFreq2,mycol29:rSecRF.MonthlyFreq3,mycol30:rSecRF.MonthlyFreq4,mycol31:rSecRF.MonthlyFreq5,mycol32:rSecRF.MonthlyFreq6,mycol33:rSecRF.MonthlyFreq7,mycol34:rSecRF.MonthlyFreq8,mycol35:rSecRF.MonthlyFreq9,mycol36:rSecRF.MonthlyFreq10,mycol37:rSecRF.WeeklyCount,mycol38:rSecRF.WeeklyNew,mycol39:rSecRF.WeeklyFreq1,mycol40:rSecRF.WeeklyFreq2,mycol41:rSecRF.WeeklyFreq3,mycol42:rSecRF.WeeklyFreq4,mycol43:rSecRF.WeeklyFreq5,mycol44:rSecRF.WeeklyFreq6,mycol45:rSecRF.WeeklyFreq7,mycol46:rSecRF.WeeklyFreq8,mycol47:rSecRF.WeeklyFreq9,mycol48:rSecRF.WeeklyFreq10,mycol49:rSecRF.DailyCount,mycol50:rSecRF.DailyNew,mycol51:rSecRF.DailyFreq1,mycol52:rSecRF.DailyFreq2,mycol53:rSecRF.DailyFreq3,mycol54:rSecRF.DailyFreq4,mycol55:rSecRF.DailyFreq5,mycol56:rSecRF.DailyFreq6,mycol57:rSecRF.DailyFreq7,mycol58:rSecRF.DailyFreq8,mycol59:rSecRF.DailyFreq9,mycol60:rSecRF.DailyFreq10 [rSecSitRF.db] KeyEntities=rmwhen,SectionKey,SiteKey OutputFields=SectionKey:rSecSitRF.SectionKey,SiteKey:rSecSitRF.SiteKey,rmwhen:rSecSitRF.RmWhen,mycol1:rSecSitRF.ToDateCount,mycol2:rSecSitRF.ToDateNew,mycol3:rSecSitRF.ToDateFreq1,mycol4:rSecSitRF.ToDateFreq2,mycol5:rSecSitRF.ToDateFreq3,mycol6:rSecSitRF.ToDateFreq4,mycol7:rSecSitRF.ToDateFreq5,mycol8:rSecSitRF.ToDateFreq6,mycol9:rSecSitRF.ToDateFreq7,mycol10:rSecSitRF.ToDateFreq8,mycol11:rSecSitRF.ToDateFreq9,mycol12:rSecSitRF.ToDateFreq10,mycol13:rSecSitRF.YearlyCount,mycol14:rSecSitRF.YearlyNew,mycol15:rSecSitRF.YearlyFreq1,mycol16:rSecSitRF.YearlyFreq2,mycol17:rSecSitRF.YearlyFreq3,mycol18:rSecSitRF.YearlyFreq4,mycol19:rSecSitRF.YearlyFreq5,mycol20:rSecSitRF.YearlyFreq6,mycol21:rSecSitRF.YearlyFreq7,mycol22:rSecSitRF.YearlyFreq8,mycol23:rSecSitRF.YearlyFreq9,mycol24:rSecSitRF.YearlyFreq10,mycol25:rSecSitRF.MonthlyCount,mycol26:rSecSitRF.MonthlyNew,mycol27:rSecSitRF.MonthlyFreq1,mycol28:rSecSitRF.MonthlyFreq2,mycol29:rSecSitRF.MonthlyFreq3,mycol30:rSecSitRF.MonthlyFreq4,mycol31:rSecSitRF.MonthlyFreq5,mycol32:rSecSitRF.MonthlyFreq6,mycol33:rSecSitRF.MonthlyFreq7,mycol34:rSecSitRF.MonthlyFreq8,mycol35:rSecSitRF.MonthlyFreq9,mycol36:rSecSitRF.MonthlyFreq10,mycol37:rSecSitRF.WeeklyCount,mycol38:rSecSitRF.WeeklyNew,mycol39:rSecSitRF.WeeklyFreq1,mycol40:rSecSitRF.WeeklyFreq2,mycol41:rSecSitRF.WeeklyFreq3,mycol42:rSecSitRF.WeeklyFreq4,mycol43:rSecSitRF.WeeklyFreq5,mycol44:rSecSitRF.WeeklyFreq6,mycol45:rSecSitRF.WeeklyFreq7,mycol46:rSecSitRF.WeeklyFreq8,mycol47:rSecSitRF.WeeklyFreq9,mycol48:rSecSitRF.WeeklyFreq10,mycol49:rSecSitRF.DailyCount,mycol50:rSecSitRF.DailyNew,mycol51:rSecSitRF.DailyFreq1,mycol52:rSecSitRF.DailyFreq2,mycol53:rSecSitRF.DailyFreq3,mycol54:rSecSitRF.DailyFreq4,mycol55:rSecSitRF.DailyFreq5,mycol56:rSecSitRF.DailyFreq6,mycol57:rSecSitRF.DailyFreq7,mycol58:rSecSitRF.DailyFreq8,mycol59:rSecSitRF.DailyFreq9,mycol60:rSecSitRF.DailyFreq10 [rSitGrpRF.db] KeyEntities=rmwhen,SiteGroupKey OutputFields=SiteGroupKey:rSitGrpRF.SiteGroupKey,rmwhen:rSitGrpRF.RmWhen,mycol1:rSitGrpRF.ToDateCount,mycol2:rSitGrpRF.ToDateNew,mycol3:rSitGrpRF.ToDateFreq1,mycol4:rSitGrpRF.ToDateFreq2,mycol5:rSitGrpRF.ToDateFreq3,mycol6:rSitGrpRF.ToDateFreq4,mycol7:rSitGrpRF.ToDateFreq5,mycol8:rSitGrpRF.ToDateFreq6,mycol9:rSitGrpRF.ToDateFreq7,mycol10:rSitGrpRF.ToDateFreq8,mycol11:rSitGrpRF.ToDateFreq9,mycol12:rSitGrpRF.ToDateFreq10,mycol13:rSitGrpRF.YearlyCount,mycol14:rSitGrpRF.YearlyNew,mycol15:rSitGrpRF.YearlyFreq1,mycol16:rSitGrpRF.YearlyFreq2,mycol17:rSitGrpRF.YearlyFreq3,mycol18:rSitGrpRF.YearlyFreq4,mycol19:rSitGrpRF.YearlyFreq5,mycol20:rSitGrpRF.YearlyFreq6,mycol21:rSitGrpRF.YearlyFreq7,mycol22:rSitGrpRF.YearlyFreq8,mycol23:rSitGrpRF.YearlyFreq9,mycol24:rSitGrpRF.YearlyFreq10,mycol25:rSitGrpRF.MonthlyCount,mycol26:rSitGrpRF.MonthlyNew,mycol27:rSitGrpRF.MonthlyFreq1,mycol28:rSitGrpRF.MonthlyFreq2,mycol29:rSitGrpRF.MonthlyFreq3,mycol30:rSitGrpRF.MonthlyFreq4,mycol31:rSitGrpRF.MonthlyFreq5,mycol32:rSitGrpRF.MonthlyFreq6,mycol33:rSitGrpRF.MonthlyFreq7,mycol34:rSitGrpRF.MonthlyFreq8,mycol35:rSitGrpRF.MonthlyFreq9,mycol36:rSitGrpRF.MonthlyFreq10,mycol37:rSitGrpRF.WeeklyCount,mycol38:rSitGrpRF.WeeklyNew,mycol39:rSitGrpRF.WeeklyFreq1,mycol40:rSitGrpRF.WeeklyFreq2,mycol41:rSitGrpRF.WeeklyFreq3,mycol42:rSitGrpRF.WeeklyFreq4,mycol43:rSitGrpRF.WeeklyFreq5,mycol44:rSitGrpRF.WeeklyFreq6,mycol45:rSitGrpRF.WeeklyFreq7,mycol46:rSitGrpRF.WeeklyFreq8,mycol47:rSitGrpRF.WeeklyFreq9,mycol48:rSitGrpRF.WeeklyFreq10,mycol49:rSitGrpRF.DailyCount,mycol50:rSitGrpRF.DailyNew,mycol51:rSitGrpRF.DailyFreq1,mycol52:rSitGrpRF.DailyFreq2,mycol53:rSitGrpRF.DailyFreq3,mycol54:rSitGrpRF.DailyFreq4,mycol55:rSitGrpRF.DailyFreq5,mycol56:rSitGrpRF.DailyFreq6,mycol57:rSitGrpRF.DailyFreq7,mycol58:rSitGrpRF.DailyFreq8,mycol59:rSitGrpRF.DailyFreq9,mycol60:rSitGrpRF.DailyFreq10 [rSitGrpSitRF.db] KeyEntities=rmwhen,SiteGroupKey,SiteKey OutputFields=SiteGroupKey:rSitGrpSitRF.SiteGroupKey,SiteKey:rSitGrpSitRF.SiteKey,rmwhen:rSitGrpSitRF.RmWhen,mycol1:rSitGrpSitRF.ToDateCount,mycol2:rSitGrpSitRF.ToDateNew,mycol3:rSitGrpSitRF.ToDateFreq1,mycol4:rSitGrpSitRF.ToDateFreq2,mycol5:rSitGrpSitRF.ToDateFreq3,mycol6:rSitGrpSitRF.ToDateFreq4,mycol7:rSitGrpSitRF.ToDateFreq5,mycol8:rSitGrpSitRF.ToDateFreq6,mycol9:rSitGrpSitRF.ToDateFreq7,mycol10:rSitGrpSitRF.ToDateFreq8,mycol11:rSitGrpSitRF.ToDateFreq9,mycol12:rSitGrpSitRF.ToDateFreq10,mycol13:rSitGrpSitRF.YearlyCount,mycol14:rSitGrpSitRF.YearlyNew,mycol15:rSitGrpSitRF.YearlyFreq1,mycol16:rSitGrpSitRF.YearlyFreq2,mycol17:rSitGrpSitRF.YearlyFreq3,mycol18:rSitGrpSitRF.YearlyFreq4,mycol19:rSitGrpSitRF.YearlyFreq5,mycol20:rSitGrpSitRF.YearlyFreq6,mycol21:rSitGrpSitRF.YearlyFreq7,mycol22:rSitGrpSitRF.YearlyFreq8,mycol23:rSitGrpSitRF.YearlyFreq9,mycol24:rSitGrpSitRF.YearlyFreq10,mycol25:rSitGrpSitRF.MonthlyCount,mycol26:rSitGrpSitRF.MonthlyNew,mycol27:rSitGrpSitRF.MonthlyFreq1,mycol28:rSitGrpSitRF.MonthlyFreq2,mycol29:rSitGrpSitRF.MonthlyFreq3,mycol30:rSitGrpSitRF.MonthlyFreq4,mycol31:rSitGrpSitRF.MonthlyFreq5,mycol32:rSitGrpSitRF.MonthlyFreq6,mycol33:rSitGrpSitRF.MonthlyFreq7,mycol34:rSitGrpSitRF.MonthlyFreq8,mycol35:rSitGrpSitRF.MonthlyFreq9,mycol36:rSitGrpSitRF.MonthlyFreq10,mycol37:rSitGrpSitRF.WeeklyCount,mycol38:rSitGrpSitRF.WeeklyNew,mycol39:rSitGrpSitRF.WeeklyFreq1,mycol40:rSitGrpSitRF.WeeklyFreq2,mycol41:rSitGrpSitRF.WeeklyFreq3,mycol42:rSitGrpSitRF.WeeklyFreq4,mycol43:rSitGrpSitRF.WeeklyFreq5,mycol44:rSitGrpSitRF.WeeklyFreq6,mycol45:rSitGrpSitRF.WeeklyFreq7,mycol46:rSitGrpSitRF.WeeklyFreq8,mycol47:rSitGrpSitRF.WeeklyFreq9,mycol48:rSitGrpSitRF.WeeklyFreq10,mycol49:rSitGrpSitRF.DailyCount,mycol50:rSitGrpSitRF.DailyNew,mycol51:rSitGrpSitRF.DailyFreq1,mycol52:rSitGrpSitRF.DailyFreq2,mycol53:rSitGrpSitRF.DailyFreq3,mycol54:rSitGrpSitRF.DailyFreq4,mycol55:rSitGrpSitRF.DailyFreq5,mycol56:rSitGrpSitRF.DailyFreq6,mycol57:rSitGrpSitRF.DailyFreq7,mycol58:rSitGrpSitRF.DailyFreq8,mycol59:rSitGrpSitRF.DailyFreq9,mycol60:rSitGrpSitRF.DailyFreq10 [rSitRF.db] KeyEntities=rmwhen,SiteKey OutputFields=SiteKey:rSitRF.SiteKey,rmwhen:rSitRF.RmWhen,mycol1:rSitRF.ToDateCount,mycol2:rSitRF.ToDateNew,mycol3:rSitRF.ToDateFreq1,mycol4:rSitRF.ToDateFreq2,mycol5:rSitRF.ToDateFreq3,mycol6:rSitRF.ToDateFreq4,mycol7:rSitRF.ToDateFreq5,mycol8:rSitRF.ToDateFreq6,mycol9:rSitRF.ToDateFreq7,mycol10:rSitRF.ToDateFreq8,mycol11:rSitRF.ToDateFreq9,mycol12:rSitRF.ToDateFreq10,mycol13:rSitRF.YearlyCount,mycol14:rSitRF.YearlyNew,mycol15:rSitRF.YearlyFreq1,mycol16:rSitRF.YearlyFreq2,mycol17:rSitRF.YearlyFreq3,mycol18:rSitRF.YearlyFreq4,mycol19:rSitRF.YearlyFreq5,mycol20:rSitRF.YearlyFreq6,mycol21:rSitRF.YearlyFreq7,mycol22:rSitRF.YearlyFreq8,mycol23:rSitRF.YearlyFreq9,mycol24:rSitRF.YearlyFreq10,mycol25:rSitRF.MonthlyCount,mycol26:rSitRF.MonthlyNew,mycol27:rSitRF.MonthlyFreq1,mycol28:rSitRF.MonthlyFreq2,mycol29:rSitRF.MonthlyFreq3,mycol30:rSitRF.MonthlyFreq4,mycol31:rSitRF.MonthlyFreq5,mycol32:rSitRF.MonthlyFreq6,mycol33:rSitRF.MonthlyFreq7,mycol34:rSitRF.MonthlyFreq8,mycol35:rSitRF.MonthlyFreq9,mycol36:rSitRF.MonthlyFreq10,mycol37:rSitRF.WeeklyCount,mycol38:rSitRF.WeeklyNew,mycol39:rSitRF.WeeklyFreq1,mycol40:rSitRF.WeeklyFreq2,mycol41:rSitRF.WeeklyFreq3,mycol42:rSitRF.WeeklyFreq4,mycol43:rSitRF.WeeklyFreq5,mycol44:rSitRF.WeeklyFreq6,mycol45:rSitRF.WeeklyFreq7,mycol46:rSitRF.WeeklyFreq8,mycol47:rSitRF.WeeklyFreq9,mycol48:rSitRF.WeeklyFreq10,mycol49:rSitRF.DailyCount,mycol50:rSitRF.DailyNew,mycol51:rSitRF.DailyFreq1,mycol52:rSitRF.DailyFreq2,mycol53:rSitRF.DailyFreq3,mycol54:rSitRF.DailyFreq4,mycol55:rSitRF.DailyFreq5,mycol56:rSitRF.DailyFreq6,mycol57:rSitRF.DailyFreq7,mycol58:rSitRF.DailyFreq8,mycol59:rSitRF.DailyFreq9,mycol60:rSitRF.DailyFreq10 [rAdvSitSitRF.db] KeyEntities=rmwhen,AdvertiserKey,SiteXKey,SiteYKey OutputFields=AdvertiserKey:rAdvSitSitRF.AdvertiserKey,SiteXKey:rAdvSitSitRF.SiteXKey,SiteYKey:rAdvSitSitRF.SiteYKey,rmwhen:rAdvSitSitRF.RmWhen,mycol1:rAdvSitSitRF.Count [rCamCamGrpCamGrpRF.db] KeyEntities=rmwhen,CampaignKey,CampaignGroupXKey,CampaignGroupYKey OutputFields=CampaignKey:rCamCamGrpCamGrpRF.CampaignKey,CampaignGroupXKey:rCamCamGrpCamGrpRF.CampaignGroupXKey,CampaignGroupYKey:rCamCamGrpCamGrpRF.CampaignGroupYKey,rmwhen:rCamCamGrpCamGrpRF.RmWhen,mycol1:rCamCamGrpCamGrpRF.Count [rCamGrpSitSitRF.db] KeyEntities=rmwhen,CampaignGroupKey,SiteXKey,SiteYKey OutputFields=CampaignGroupKey:rCamGrpSitSitRF.CampaignGroupKey,SiteXKey:rCamGrpSitSitRF.SiteXKey,SiteYKey:rCamGrpSitSitRF.SiteYKey,rmwhen:rCamGrpSitSitRF.RmWhen,mycol1:rCamGrpSitSitRF.Count [rCamSecSecRF.db] KeyEntities=rmwhen,CampaignKey,SectionXKey,SectionYKey OutputFields=CampaignKey:rCamSecSecRF.CampaignKey,SectionXKey:rCamSecSecRF.SectionXKey,SectionYKey:rCamSecSecRF.SectionYKey,rmwhen:rCamSecSecRF.RmWhen,mycol1:rCamSecSecRF.Count [rCamSitGrpSitGrpRF.db] KeyEntities=rmwhen,CampaignKey,SiteGroupXKey,SiteGroupYKey OutputFields=CampaignKey:rCamSitGrpSitGrpRF.CampaignKey,SiteGroupXKey:rCamSitGrpSitGrpRF.SiteGroupXKey,SiteGroupYKey:rCamSitGrpSitGrpRF.SiteGroupYKey,rmwhen:rCamSitGrpSitGrpRF.RmWhen,mycol1:rCamSitGrpSitGrpRF.Count [rCamSitSitRF.db] KeyEntities=rmwhen,CampaignKey,SiteXKey,SiteYKey OutputFields=CampaignKey:rCamSitSitRF.CampaignKey,SiteXKey:rCamSitSitRF.SiteXKey,SiteYKey:rCamSitSitRF.SiteYKey,rmwhen:rCamSitSitRF.RmWhen,mycol1:rCamSitSitRF.Count [rSecSitSitRF.db] KeyEntities=rmwhen,SectionKey,SiteXKey,SiteYKey OutputFields=SectionKey:rSecSitSitRF.SectionKey,SiteXKey:rSecSitSitRF.SiteXKey,SiteYKey:rSecSitSitRF.SiteYKey,rmwhen:rSecSitSitRF.RmWhen,mycol1:rSecSitSitRF.Count [rSitGrpSitSitRF.db] KeyEntities=rmwhen,SiteGroupKey,SiteXKey,SiteYKey OutputFields=SiteGroupKey:rSitGrpSitSitRF.SiteGroupKey,SiteXKey:rSitGrpSitSitRF.SiteXKey,SiteYKey:rSitGrpSitSitRF.SiteYKey,rmwhen:rSitGrpSitSitRF.RmWhen,mycol1:rSitGrpSitSitRF.Count ############################################################################### # #DerivedEntities [accountkey] KeyEntities=account EntityToReplace=account FileName=Dictionary/accounts.txt NotFoundPolicy=Discard #Entity Filters [RobotFilter] Entity=x ExcludedContainValues=r [RobotOnlyFilter] Entity=x IncludedValues=r,rc # Search Term Processing definitions [tkeywords] SearchTermType=tkeyword SearchTermEntity=search FileName=Dictionary/targetedterms.txt [tnames] SearchTermType=tnamevalue SearchTermEntity=search FileName=Dictionary/targetedterms.txt NameValueSeparator== PairSeparator=& ValueSeparator=+ [names] SearchTermType=namevalue SearchTermEntity=search NameValueSeparator== PairSeparator=& ValueSeparator=+ [keywords] SearchTermType=keyword SearchTermEntity=search NameValueSeparator=& PairSeparator=& ValueSeparator=+ [keyelements] SearchTermType=keyelement SearchTermEntity=search NameValueSeparator== PairSeparator=& ValueSeparator=+