Site­Cat­a­lyst 15 brings with it sev­eral excit­ing changes for Data Ware­house cus­tomers. Many of these changes were sug­gested by cus­tomers on the Idea Exchange, so I am very pleased today to share with you some details about these data ware­house improvements.

Dupli­cate a pre­vi­ous request

In the past there has been no easy way to reuse an exist­ing data ware­house request as the basis for a new report. That makes dupli­cat­ing data ware­house requests time con­sum­ing and prone to mis­takes. No more! With Site­Cat­a­lyst 15 you can dupli­cate any data ware­house request by click­ing a link in the Data Ware­house Request Manager:


Click­ing this link will build a dupli­cate data ware­house request which you can then mod­ify as nec­es­sary and resub­mit, thus sav­ing you time and mak­ing life eas­ier. Cool, eh?

Improved sta­tus information

Have you ever sub­mit­ted a Data Ware­house request, waited for a while, and then won­dered just how far along the request has pro­gressed and how much longer it might take? With Site­Cat­a­lyst 15 we have improved Data Ware­house sta­tus mes­sag­ing by includ­ing infor­ma­tion that helps you answer these ques­tions. In the Request Man­ager, click on the Report Name for any data ware­house request. If the report is cur­rently pro­cess­ing you’ll see some­thing like this in the popup window:


If the report date range cov­ers 30 days and Data Ware­house is cur­rently pro­cess­ing day #2, you know the job is just begin­ning. If the sta­tus says you are on day #15, you know the pro­cess­ing is about halfway done.

New dimen­sions and metrics

Data Ware­house now sup­ports a sev­eral new dimen­sions (a.k.a. break­downs) and metrics:

  • Test&Target. Cus­tomers who have imple­mented the Test&Target inte­gra­tion to Site­Cat­a­lyst can now pull cam­paign and recipe reports via Data Ware­house, and cre­ate seg­ments based on cam­paign and recipe.
  • Sur­vey. Cus­tomers who have imple­mented the Sur­vey inte­gra­tion to Site­Cat­a­lyst can now pull sur­vey, ques­tion, and response reports via Data Ware­house, and cre­ate seg­ments based on these breakdowns.
  • List vari­ables. Data Ware­house now sup­ports report­ing and seg­men­ta­tion based on the new Site­Cat­a­lyst 15 List Variables.
  • “Vis­its — All Vis­i­tors” met­ric. Data Ware­house now sup­ports two Vis­its met­rics: “Vis­its” and “Vis­its — All Vis­i­tors.” “Vis­its” is the legacy ver­sion and, like Site­Cat­a­lyst 14, excludes vis­i­tors who reject cook­ies. “Vis­its — All Vis­i­tors” is a new met­ric which matches Site­Cat­a­lyst 15 and Dis­cover busi­ness rules and includes vis­i­tors who reject cook­ies. Yes, you can have it both ways.

“Same-As-SiteCatalyst” VISTA processing

In the past, VISTA has been applied to Site­Cat­a­lyst reports in a slightly dif­fer­ent man­ner than Data Ware­house reports. With Site­Cat­a­lyst (all ver­sions), VISTA rules are applied to data real-time as data is being processed. With Data Ware­house though, VISTA rules are (gen­er­ally) applied at report run time rather than at data col­lec­tion time. (There are nuances I won’t bore you with now, but for the most part VISTA is applied to Data Ware­house at the time you run the report.) The end result is nor­mally the same, but pro­cess­ing VISTA at report run time intro­duces a few issues as described below.

Start­ing with Site­Cat­a­lyst 15, Data Ware­house works a dif­fer­ent way. VISTA is applied to Data Ware­house data at data pro­cess­ing time just like Site­Cat­a­lyst. We gave this func­tion­al­ity a fancy name: “Same-as-SiteCatalyst” VISTA pro­cess­ing. ;) Think of it as hav­ing VISTA rules “baked into” the data before you run reports, rather than being applied to the data later.

So why should you care? Three rea­sons:

  • Report speed. Data Ware­house reports using VISTA will run much faster.
  • Bet­ter data con­sis­tency between Site­Cat­a­lyst and Data Ware­house. Same-as-SiteCatalyst VISTA pro­cess­ing helps ensure VISTA is applied in exactly the same way in both Site­Cat­a­lyst and Data Warehouse.
  • Site­Cat­a­lyst 15 Pro­cess­ing Rules. It is impor­tant to note that Site­Cat­a­lyst 15 Pro­cess­ing Rules, like VISTA, are applied to Site­Cat­a­lyst and Data Ware­house data at data pro­cess­ing time. This ensures all VISTA and Pro­cess­ing Rules are reflected prop­erly in your reports.


Well, that’s it. These are the improve­ments we have made to Data Ware­house with Site­Cat­a­lyst 15. I hope you find this infor­ma­tion use­ful. If you have any ques­tions or com­ments, please feel free to leave a note in the Com­ment box below. And thanks, as always, for shar­ing your ideas on the Ideas Exchange.


I wish I could delete the cruft that's built up in our Data Warehouse Request Manager. It's really a mess in there.