Skip to content

Queries Summary

Query Type Tables
Qry Budget Spend Totals by Marketing Campaign Select Principal, Principal Projects, Marketing Campaigns...
Qry Budget Spend Totals Select Qry Sum Marketing Spend, Qry Sum Marketing Budget Principal Project, Qry...
Qry Get Lead Types for Passed Panel Entrepreneurs Select Entrepreneurs, ProcessStatus, Lead Types
Qry Get Marketing Sub Campaign Expire 2 Days Select Marketing Campaigns, Principal Projects, Marketing Sub Campaigns...
Qry Lead Type List Select IndustryLookup, Principal Projects, Lead Types...
Qry Marketing Budget Non Principal Project List Select MarketingBudgetStatus, Marketing Budget Non Principal Project, Marketing
Qry Marketing Campaign List Other Select MarketingCampaignStatus, Qry Sum Total Spend by Principal Project, Marketing Campaigns...
Qry Marketing Campaign List Select MarketingCampaignStatus, Qry Sum Total Spend by Principal Project, Marketing Campaigns...
Qry Marketing Sub Campaign List Select Marketing Sub Campaigns, Marketing
Qry Principal Projects No Marketing Campaign Select Principal, Principal Projects, Marketing Campaigns...
Qry Report Lead Type to Principal Allocation Select SubQry Rpt Lead Type to Principal Allocation Criteria, SubQry
Qry Report Marketing EOI to Passed Panel Select Temp Lead Type for Lead Report, Temp, SubQry Rpt Marketing EOI to Passed Panel Count EOI...
Qry Report Marketing Leads Version Two Select SubQry Rpt Count Uncontacted Leads, SubQry Rpt Count Total Leads Generated, SubQry Rpt Count Qualified Leads...
Qry Report Marketing Pre-Unqualified Leads Select Entrepreneurs, UnqualifiedReason, ProcessStatus...
Qry Report Marketing Spend Current Principal Projects Select MarketingCampaignStatus, Marketing Campaigns, Principal Projects...
Qry Report Marketing Spend Past Principal Projects Select MarketingCampaignStatus, Marketing Campaigns, Principal Projects...
Qry Report Marketing Sub Campaign Expire 2 Days Select Marketing, Marketing Campaigns, Principal Projects...
Qry Report Marketing Sub Campaign Spend Select Marketing, Marketing Campaigns, Principal Projects...
Qry SubFrm Principal Project Pillar Supporting Documents Select Principal Project Pillars, Principal
Qry SubRpt Marketing Sub Campaign Lead Types Select Marketing Sub Campaign Lead Types, Marketing, Lead Types
Qry Sum Marketing Budget Non Principal Project Select Marketing Budget Non Principal Project, Marketing
Qry Sum Marketing Budget Principal Project Select Marketing, Principal Projects, Marketing Campaigns
Qry Sum Marketing Spend by Campaign Select Marketing Sub Campaigns, Marketing
Qry Sum Marketing Spend Select Marketing Sub Campaigns, Marketing, Marketing Campaigns
Qry Sum Total Spend by Principal Project Select Principal Project Pillars, Principal
qryLinkODBC Select zstblODBC_db, zstblODBC_tables
SubQry Rpt Count Followed Up Leads Select SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Count On Hold Leads Select SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Count Qualified Leads Select SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Count Terminated Leads Select SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Count Total Leads Generated Select SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Count Uncontacted Leads Select SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Count Unqualified Leads Select SubQry Rpt Marketing Leads Criteria, SubQry
SubQry Rpt Lead Type to Principal Allocation Criteria Select vwPurpleRptLeadTypetoPrincipalAllocationCriteria
SubQry Rpt Marketing EOI to Passed Panel Count EOI Select Entrepreneurs, Temp Lead Type for Lead Report, Temp
SubQry Rpt Marketing EOI to Passed Panel Count Passed Panel Select Entrepreneurs, Temp Lead Type for Lead Report, Temp
SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit Select Entrepreneurs, Temp Lead Type for Lead Report, Entrepreneur Status History...
SubQry Rpt Marketing EOI to Passed Panel Count Qualified Select SubQry Rpt Marketing EOI to Passed Panel Count Qualified Crit, SubQry
SubQry Rpt Marketing Leads Criteria Select Entrepreneurs, Entrepreneur Company, ProcessStatus...