VIEW: AMS.AMS_ACT_METRICS_ALL_DENORM#

Source

View Text - Preformatted

select ACT_METRICS_DENORM_ID ACT_METRICS_DENORM_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, METRIC_COLLECTION_DATE METRIC_COLLECTION_DATE, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, LEADS LEADS, TOP_LEADS TOP_LEADS, TOP_LEADS_RATIO TOP_LEADS_RATIO, LEADS_ACCEPTED LEADS_ACCEPTED, LEAD_ACCEPTANCE_RATE LEAD_ACCEPTANCE_RATE, DEAD_LEADS DEAD_LEADS, DEAD_LEADS_RATIO DEAD_LEADS_RATIO, OPPORTUNITIES OPPORTUNITIES, OPPORTUNITIES_AMOUNT OPPORTUNITIES_AMOUNT, LEADS_TO_OPPORTUNITY_RATE LEADS_TO_OPPORTUNITY_RATE, QUOTES QUOTES, QUOTES_AMOUNT QUOTES_AMOUNT, ORDERS ORDERS, ORDERS_AMOUNT ORDERS_AMOUNT, BOOKED_REVENUE BOOKED_REVENUE, INVOICED_REVENUE INVOICED_REVENUE, BOOKED_REVENUE_PER_LEAD BOOKED_REVENUE_PER_LEAD, INVOICED_REVENUE_PER_LEAD INVOICED_REVENUE_PER_LEAD, COST COST, COST_PER_LEAD COST_PER_LEAD, BOOKED_ROI BOOKED_ROI, INVOICED_ROI INVOICED_ROI, TARGET_GROUP_SIZE TARGET_GROUP_SIZE, RESPONSES RESPONSES, CONTACT_GROUP_SIZE CONTACT_GROUP_SIZE, LEADS_FORECAST LEADS_FORECAST, TOP_LEADS_FORECAST TOP_LEADS_FORECAST, TOP_LEADS_RATIO_FORECAST TOP_LEADS_RATIO_FORECAST, LEADS_ACCEPTED_FORECAST LEADS_ACCEPTED_FORECAST, LEADS_ACCEPTED_RATIO_FORECAST LEADS_ACCEPTED_RATIO_FORECAST, DEAD_LEADS_FORECAST DEAD_LEADS_FORECAST, DEAD_LEADS_RATIO_FORECAST DEAD_LEADS_RATIO_FORECAST, OPPORTUNITIES_FORECAST OPPORTUNITIES_FORECAST, OPPORTUNITIES_AMOUNT_FORECAST OPPORTUNITIES_AMOUNT_FORECAST, LEAD_OPPORTUNITY_RATE_FORECAST LEAD_OPPORTUNITY_RATE_FORECAST, QUOTES_FORECAST QUOTES_FORECAST, QUOTES_AMOUNT_FORECAST QUOTES_AMOUNT_FORECAST, ORDERS_FORECAST ORDERS_FORECAST, ORDERS_AMOUNT_FORECAST ORDERS_AMOUNT_FORECAST, BOOKED_REVENUE_FORECAST BOOKED_REVENUE_FORECAST, INVOICED_REVENUE_FORECAST INVOICED_REVENUE_FORECAST, BOOKED_REV_PER_LEAD_FORECAST BOOKED_REV_PER_LEAD_FORECAST, INVOICED_REV_PER_LEAD_FORECAST INVOICED_REV_PER_LEAD_FORECAST, COST_FORECAST COST_FORECAST, COST_PER_LEAD_FORECAST COST_PER_LEAD_FORECAST, INVOICED_ROI_FORECAST INVOICED_ROI_FORECAST, BOOKED_ROI_FORECAST BOOKED_ROI_FORECAST, TARGET_GROUP_SIZE_FORECAST TARGET_GROUP_SIZE_FORECAST, RESPONSES_FORECAST RESPONSES_FORECAST, CONTACT_GROUP_SIZE_FORECAST CONTACT_GROUP_SIZE_FORECAST from "AMS"."AMS_ACT_METRICS_ALL_DENORM"

View Text - HTML Formatted

SELECT ACT_METRICS_DENORM_ID ACT_METRICS_DENORM_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, METRIC_COLLECTION_DATE METRIC_COLLECTION_DATE
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, LEADS LEADS
, TOP_LEADS TOP_LEADS
, TOP_LEADS_RATIO TOP_LEADS_RATIO
, LEADS_ACCEPTED LEADS_ACCEPTED
, LEAD_ACCEPTANCE_RATE LEAD_ACCEPTANCE_RATE
, DEAD_LEADS DEAD_LEADS
, DEAD_LEADS_RATIO DEAD_LEADS_RATIO
, OPPORTUNITIES OPPORTUNITIES
, OPPORTUNITIES_AMOUNT OPPORTUNITIES_AMOUNT
, LEADS_TO_OPPORTUNITY_RATE LEADS_TO_OPPORTUNITY_RATE
, QUOTES QUOTES
, QUOTES_AMOUNT QUOTES_AMOUNT
, ORDERS ORDERS
, ORDERS_AMOUNT ORDERS_AMOUNT
, BOOKED_REVENUE BOOKED_REVENUE
, INVOICED_REVENUE INVOICED_REVENUE
, BOOKED_REVENUE_PER_LEAD BOOKED_REVENUE_PER_LEAD
, INVOICED_REVENUE_PER_LEAD INVOICED_REVENUE_PER_LEAD
, COST COST
, COST_PER_LEAD COST_PER_LEAD
, BOOKED_ROI BOOKED_ROI
, INVOICED_ROI INVOICED_ROI
, TARGET_GROUP_SIZE TARGET_GROUP_SIZE
, RESPONSES RESPONSES
, CONTACT_GROUP_SIZE CONTACT_GROUP_SIZE
, LEADS_FORECAST LEADS_FORECAST
, TOP_LEADS_FORECAST TOP_LEADS_FORECAST
, TOP_LEADS_RATIO_FORECAST TOP_LEADS_RATIO_FORECAST
, LEADS_ACCEPTED_FORECAST LEADS_ACCEPTED_FORECAST
, LEADS_ACCEPTED_RATIO_FORECAST LEADS_ACCEPTED_RATIO_FORECAST
, DEAD_LEADS_FORECAST DEAD_LEADS_FORECAST
, DEAD_LEADS_RATIO_FORECAST DEAD_LEADS_RATIO_FORECAST
, OPPORTUNITIES_FORECAST OPPORTUNITIES_FORECAST
, OPPORTUNITIES_AMOUNT_FORECAST OPPORTUNITIES_AMOUNT_FORECAST
, LEAD_OPPORTUNITY_RATE_FORECAST LEAD_OPPORTUNITY_RATE_FORECAST
, QUOTES_FORECAST QUOTES_FORECAST
, QUOTES_AMOUNT_FORECAST QUOTES_AMOUNT_FORECAST
, ORDERS_FORECAST ORDERS_FORECAST
, ORDERS_AMOUNT_FORECAST ORDERS_AMOUNT_FORECAST
, BOOKED_REVENUE_FORECAST BOOKED_REVENUE_FORECAST
, INVOICED_REVENUE_FORECAST INVOICED_REVENUE_FORECAST
, BOOKED_REV_PER_LEAD_FORECAST BOOKED_REV_PER_LEAD_FORECAST
, INVOICED_REV_PER_LEAD_FORECAST INVOICED_REV_PER_LEAD_FORECAST
, COST_FORECAST COST_FORECAST
, COST_PER_LEAD_FORECAST COST_PER_LEAD_FORECAST
, INVOICED_ROI_FORECAST INVOICED_ROI_FORECAST
, BOOKED_ROI_FORECAST BOOKED_ROI_FORECAST
, TARGET_GROUP_SIZE_FORECAST TARGET_GROUP_SIZE_FORECAST
, RESPONSES_FORECAST RESPONSES_FORECAST
, CONTACT_GROUP_SIZE_FORECAST CONTACT_GROUP_SIZE_FORECAST
FROM "AMS"."AMS_ACT_METRICS_ALL_DENORM"