data-warehouse-docs.newzip.com
Open in
urlscan Pro
199.36.158.100
Public Scan
Submitted URL: http://data-warehouse-docs.newzip.com/
Effective URL: https://data-warehouse-docs.newzip.com/
Submission Tags: @phish_report
Submission: On August 22 via api from FI — Scanned from AU
Effective URL: https://data-warehouse-docs.newzip.com/
Submission Tags: @phish_report
Submission: On August 22 via api from FI — Scanned from AU
Form analysis 1 forms found in the DOM
<form class="fields fields-flush launcher-hide-sidebar ng-pristine ng-valid" ng-class="{visible: filters_visible}" ng-submit="onUpdateSelector()">
<label class="field">
<div class="dropdown dropup" ng-class="{'open': isVisible('resource_types')}" data-form-type="resource_types">
<select data-toggle="dropdown" class="field-input form-control input-dark" ng-click="onSelectClick('resource_types')" ng-blur="onSelectBlur('resource_types')">
<option selected="" disabled="" hidden="" class="ng-binding"> All selected </option>
</select>
<ul class="dropdown-menu ng-hide" ng-show="isVisible('resource_types')">
<li ng-click="onSelectAll('resource_types', !allSelected, $event)">
<strong class="text-dark">Select All</strong>
<span ng-show="allSelected">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li>
<!-- ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Models <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Seeds <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Snapshots <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Sources <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Tests <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Analyses <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Exposures <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.resource_types" ng-click="onItemSelect('resource_types', item, $event)"> Metrics <span ng-show="isSelected('resource_types', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.resource_types -->
</ul>
<div class="field-label">resources</div>
</div>
</label>
<label class="field">
<div class="dropdown dropup" ng-class="{'open': isVisible('packages')}" data-form-type="packages">
<select data-toggle="dropdown" class="field-input form-control input-dark" ng-click="onSelectClick('packages')" ng-blur="onSelectBlur('packages')">
<option selected="" disabled="" hidden="" class="ng-binding"> dwellfulbi </option>
</select>
<ul class="dropdown-menu ng-hide" ng-show="isVisible('packages')">
<li ng-click="onSelectAll('packages', !allSelected, $event)">
<strong class="text-dark">Select All</strong>
<span ng-show="allSelected">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li>
<!-- ngRepeat: item in selectorService.options.packages -->
<li class="text-dark ng-binding ng-scope" ng-repeat="item in selectorService.options.packages" ng-click="onItemSelect('packages', item, $event)"> dwellfulbi <span ng-show="isSelected('packages', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.packages -->
</ul>
<div class="field-label">packages</div>
</div>
</label>
<label class="field">
<div class="dropdown dropup" ng-class="{'open': isVisible('tags')}" data-form-type="tags">
<select data-toggle="dropdown" class="field-input form-control input-dark" ng-click="onSelectClick('tags')" ng-blur="onSelectBlur('tags', $event)">
<option selected="" disabled="" hidden="" class="ng-binding"> All selected </option>
</select>
<ul class="dropdown-menu ng-hide" ng-show="isVisible('tags')">
<li ng-click="onSelectAll('tags', !allSelected, $event)">
<strong class="text-dark">Select All</strong>
<span ng-show="allSelected">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li>
<!-- ngRepeat: item in selectorService.options.tags -->
<li class="text-dark ng-scope" ng-repeat="item in selectorService.options.tags" ng-click="onItemSelect('tags', item, $event)">
<!-- ngIf: item == null -->
<!-- ngIf: item != null --><span ng-if="item != null" class="ng-binding ng-scope">cost</span><!-- end ngIf: item != null -->
<span ng-show="isSelected('tags', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.tags -->
<li class="text-dark ng-scope" ng-repeat="item in selectorService.options.tags" ng-click="onItemSelect('tags', item, $event)">
<!-- ngIf: item == null -->
<!-- ngIf: item != null --><span ng-if="item != null" class="ng-binding ng-scope">marketing</span><!-- end ngIf: item != null -->
<span ng-show="isSelected('tags', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.tags -->
<li class="text-dark ng-scope" ng-repeat="item in selectorService.options.tags" ng-click="onItemSelect('tags', item, $event)">
<!-- ngIf: item == null --><span ng-if="item == null" class="ng-scope">untagged</span><!-- end ngIf: item == null -->
<!-- ngIf: item != null -->
<span ng-show="isSelected('tags', item)">
<svg class="checked" xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24">
<path d="M20.285 2l-11.285 11.567-5.286-5.011-3.714 3.716 9 8.728 15-15.285z"></path>
</svg>
</span>
</li><!-- end ngRepeat: item in selectorService.options.tags -->
</ul>
<div class="field-label">tags</div>
</div>
</label>
<label class="field" style="flex: 4 0 160px">
<input type="text" class="field-input form-control input-dark ng-pristine ng-untouched ng-valid ng-empty" ng-model="selectorService.selection.dirty.include" placeholder="...">
<div class="field-label">--select</div>
</label>
<label class="field" style="flex: 4 0 160px">
<input type="text" class="field-input form-control input-dark ng-pristine ng-untouched ng-valid ng-empty" ng-model="selectorService.selection.dirty.exclude" placeholder="...">
<div class="field-label">--exclude</div>
</label>
<label class="field" style="flex: 0 0 80px">
<input type="submit" id="submit-graph-selection" class="field-input form-control input-dark" ng-class="{'dirty-submit': selectorService.isDirty()}" value="Update Graph">
<div class="field-label text-center" style="width: 100%"></div>
</label>
<label class="field" style="flex: 0 0 80px">
<button type="button" ng-click="closeGraph()" class="field-input form-control input-dark text-center"><svg class="icn icn-md">
<use xlink:href="#icn-close"></use>
</svg>
</button>
</label>
</form>Text Content
icons
LINEAGE GRAPH
All selected
* Select All
* Models
* Seeds
* Snapshots
* Sources
* Tests
* Analyses
* Exposures
* Metrics
resources
dwellfulbi
* Select All
* dwellfulbi
packages
All selected
* Select All
* cost
* marketing
* untagged
tags
--select
--exclude
* Overview
* Project
Database
* Sources
* adwords
* CAMPAIGN_PER FORMANCE_REPORT
* ads
* appdata
* 20210812_coldwell_banker_ realty_coverage
* 20210924_coldwell_banker_realt y_broker_id_map
* dash_user_info
* fastmatch_custom_state_city_br oker_assignment
* fastmatch_custom_zip_br oker_assignment
* fastmatch_in tel_median10kv2
* fa stmatch_network
* fastpath_log
* geo_st ate_city_to_zip
* geo_state_map
* geo_zip
* g eo_zip_distance
* g eo_zip_to_state
* hubspot_deleted
* le adbuys_api_keys
* leadbuys_log
* msi_agent _supported_zips
* s01_log
* scrape_realtorcom _median_history
* smar tmatch_api_keys
* smartmatch_log
* unqualification
* widget_e xcluded_session
* wi dget_insertions
* widget_log
* dbt_snapshots
* fct_crm_report_data_sla_comp liance_snapshot
* fct_crm_report_data_sla_complia nce_snapshot_ex
* dev_appdata
* 20210812_coldwell_banker_ realty_coverage
* 20210924_coldwell_banker_realt y_broker_id_map
* dash_user_info
* fastmatch_custom_state_city_br oker_assignment
* fastmatch_custom_zip_br oker_assignment
* fastmatch_in tel_median10kv2
* fa stmatch_network
* fastpath_log
* geo_st ate_city_to_zip
* geo_state_map
* geo_zip
* g eo_zip_distance
* g eo_zip_to_state
* hubspot_deleted
* le adbuys_api_keys
* leadbuys_log
* msi_agent _supported_zips
* s01_log
* scrape_realtorcom _median_history
* smar tmatch_api_keys
* smartmatch_log
* unqualification
* widget_e xcluded_session
* wi dget_insertions
* widget_log
* devsql
* agent_signup
* brand
* broker_ network_updates
* brokerage
* coverage
* dash_d eals_unreferred
* favorite_agent
* hubspot_co ntacts_override
* leadbuys
* location
* partner_r eference_config
* team
* widget_session_ legacy_mappings
* widget_sessions
* wid get_submissions
* facebook
* ads_insights
* ga
* web_traffic
* hubspot
* campaigns
* contacts
* deal_pipelines
* deals
* email_events
* engagements
* owners
* mysql
* agent_signup
* brand
* broker_ network_updates
* brokerage
* coverage
* dash_d eals_unreferred
* favorite_agent
* hubspot_co ntacts_override
* leadbuys
* location
* partner_r eference_config
* team
* widget_session_ legacy_mappings
* widget_sessions
* wid get_submissions
* prodsql
* agent_signup
* brand
* broker_ network_updates
* brokerage
* coverage
* dash_d eals_unreferred
* favorite_agent
* hubspot_co ntacts_override
* leadbuys
* location
* partner_r eference_config
* team
* widget_session_ legacy_mappings
* widget_sessions
* wid get_submissions
* sdc_ hubspot_sandbox
* campaigns
* contacts
* deal_pipelines
* deals
* email_events
* engagements
* owners
* sheets_cfg
* KPI_Targets
* Market ing_Cost_Config
* Operat ing_Cost_Config
* sheets_s01
* CMDeadLeads
* LeadsAPIData
* LendingTree
* Ownerly
* Qazzoo
* VerseU nqualifications
* Yardi
Exposures
* Application
* Hubspot Back Office (Google Apps Script) - CustomJobRunner
* Hubspot Back Office (Google Apps Script) - Da taSyncJobRunner
* Hubspot Back Office (Google Apps Script) - GoogleShe etsReportRunner
* Newzip API
* Dashboard
* Newz i KPI Dashboard
* Newzi p CRM Dashboard
Metrics
Projects
* dwellfulbi
* data
* seed_channel_campaign_sourc e_revenue_share
* see d_channel_group
* seed _cj_attribution
* seed_cm_termination_ unqualification
* seed_empl oyee_email_list
* se ed_holiday_list
* seed_hs_c all_disposition
* seed_hs_con tact_status_map
* seed_lendingtree_smartm atch_correction
* seed_manual _marketing_cost
* seed_ phone_area_code
* seed_ smartmatch_cost
* seed_web_tra ffic_adjustment
* macros
* convert_deal _dash_timestamp
* dat etime_hour_type
* intel_bogus_ median10k_limit
* normalize_expe cted_deal_state
* select_with_added_dat e_helper_fields
* summari ze_email_events
* to_local_date
* to _local_datetime
* models
* final
* fct_broker_regis tration_history
* fct_broker_registration_ history_monthly
* fct_contact_parsed_l ocation_mapping
* fct_contacts
* fct_crm_deals_associated_with_unreg istered_brokers
* fct_ crm_report_data
* fct_crm_report_data_ history_monthly
* fct_crm_report_data _history_weekly
* fct_crm_report_data _sla_compliance
* fct_crm_report_data_sl a_compliance_ex
* fct_crm_speed_to_action_n ew_report_daily
* fct_crm_speed_to_action_new_repor t_daily_lenders
* fct_crm_speed_to_action_new _report_monthly
* fct_crm_speed_to_action_ne w_report_weekly
* fc t_dash_contacts
* fct_dash_deals
* fct_dash _marketing_cost
* fct_dash_unqua lified_contacts
* fct_datastudio_coho rt_contact_deal
* fct_datastudio_cohort_marketi ng_contact_deal
* fct_datastudio_fin_marketi ng_contact_deal
* fct_datastudio_home advisor_metrics
* fct_datastudio_ website_traffic
* fct_deals
* fct_deals_for_revenu e_share_reports
* fct_deals_for_revenue_share_r eports_extended
* fct_forecast_va lidation_report
* fct_kpi_targets
* fct_last_l ocation_mapping
* fct_legacy_fm_custom_zip_br oker_assignment
* fct_ms i_api_referrals
* fct_newzip _broker_signups
* f ct_place_report
* fct_scrape_realtorco m_priority_list
* fct_sm artmatch_report
* fct_smartquali fication_report
* fct_sq_qualificati on_distribution
* intermediate
* int_api_a ctivity_summary
* int_aw_marketi ng_cost_summary
* in t_broker_agents
* int_broker_regis tration_history
* int_broker_registration_ history_monthly
* int_calculated_mar keting_cost_cpl
* int_calculated_marketing_ cost_smartmatch
* int_calculated_mark eting_cost_time
* int_calculated_oper ating_cost_time
* in t_channel_group
* int_collected_marketin g_cost_leadbuys
* int_contacts
* int_contacts_for_ partner_reports
* int_co verage_by_agent
* int_deals
* int_deals_for_ partner_reports
* int_fb_marketi ng_cost_summary
* int_fm_broker_n etwork_extended
* int_fm_custom_zip_br oker_assignment
* int_fm_in tel_median10kv2
* int_fm_z ip_coverage_map
* int_forecast_validat ion_report_data
* int_ga_web_ traffic_summary
* int_hs _contact_status
* int_hs_contacts
* int_hs_contacts_first_po st_sql_activity
* int_hs_contacts_ speed_to_action
* int_hs_contacts_sqls_with_no_ recent_activity
* in t_hs_dealstages
* int_hs_email _events_summary
* int_lb_contacts
* int_marketi ng_cost_summary
* int_scrape_realt orcom_completed
* int_scrape_ realtorcom_full
* int _smartmatch_log
* int_smar tmatch_log_flat
* int_smartmatch_lo g_flat_extended
* int_widget_author ized_insertions
* int_widget_ base_navigation
* int_wid get_base_report
* int_widget_c lean_navigation
* int_widget_i mpression_error
* int_wi dget_navigation
* int_widget_navigation_last_s tep_base_report
* int_widget_page init_navigation
* int_widget_sess ion_interaction
* int_widget_se ssion_rejection
* int_widget_submis sion_navigation
* snaps
* snp_c rm_report_final
* staging
* s tg_agent_signup
* stg_aw_campaign_per formance_report
* stg_dash _broker_network
* stg_dash_d eals_unreferred
* stg _dash_user_info
* stg_ devsql_leadbuys
* stg_devsql _widget_session
* stg_devsql_wi dget_submission
* stg_es timation_helper
* stg_ fb_ads_insights
* stg_fct_crm_report_data_sla_comp liance_snapshot
* stg_fct_crm_report_data_sla_complia nce_snapshot_ex
* stg_fm _broker_network
* stg_fm_broker_ network_updates
* stg_fm_custom_state_city_br oker_assignment
* stg_fm_in tel_median10kv2
* stg_fm_intel_median1 0kv2_realtorcom
* stg _ga_web_traffic
* stg_geo_st ate_city_to_zip
* stg_geo_zip
* stg_g eo_zip_distance
* stg_g eo_zip_to_state
* stg _gs_kpi_targets
* stg_gs_market ing_cost_config
* stg_gs_operat ing_cost_config
* s tg_hs_campaigns
* stg_hs_contacts
* stg_hs_c ontacts_deleted
* stg_hs_contact s_non_customers
* stg_hs_deals
* stg_h s_deals_deleted
* st g_hs_dealstages
* stg_hs_ema il_events_click
* stg_hs_email_e vents_delivered
* stg_hs_em ail_events_open
* stg_hs_em ail_events_sent
* stg _hs_engagements
* stg_hs_owners
* stg_lb_co ntacts_leadsapi
* stg_ lb_contacts_ltm
* stg_leadbuys
* stg_le adbuys_api_keys
* stg_leadbuys_disqu alified_summary
* s tg_leadbuys_log
* stg_leadbu ys_overview_jfq
* stg_leadbuys_ overview_lendgo
* stg_mysql_brand
* stg_ mysql_brokerage
* stg _mysql_coverage
* stg_mysql _favorite_agent
* stg _mysql_location
* stg_prodsql_hubspot_co ntacts_override
* stg_p rodsql_leadbuys
* stg_prodsql_partner_r eference_config
* s tg_prodsql_team
* stg_prodsql _widget_session
* stg_prodsql_wi dget_submission
* stg_raw _day_date_spine
* stg_s01_log
* stg_scrape_realtorcom _median_history
* stg_smar tmatch_api_keys
* stg _smartmatch_log
* stg_ unqualification
* stg_widget_author ized_insertions
* stg_widget_e xcluded_session
* stg_widget_log
* stg _widget_session
* stg_wi dget_submission
* support
* sup_api_activity _alert_snapshot
* sup_api_ activity_report
* sup_bad_replica tion_indicators
* sup_crm_contacts_with_ no_first_action
* sup_deal_ location_review
* sup_fm_broker_co verage_map_data
* sup_fm _broker_network
* sup_fm_broker_netw ork_json_export
* sup_fm_broker_netwo rk_mailing_list
* sup_fm_broker_network_mailing_ list_with_stats
* sup_fm_broker_network_p ipedrive_export
* sup_fm_broker_net work_statistics
* sup_fm_broker_net work_with_stats
* sup_fm_in tel_json_export
* sup_fm_intel_state_c ity_median10kv2
* sup_fm_intel_st ate_median10kv2
* sup_fm_intel_ zip_median10kv2
* sup_fm_state_city_br oker_assignment
* sup_fm_state_city_broker_ assignment_base
* sup_fm_zip_br oker_assignment
* sup_fm_zip_broker_ assignment_base
* sup_fm_zip_broker_ coverage_review
* sup_ geo_json_export
* sup_geo_zip_ range_state_map
* sup_hs_contacts_calc_e ngagement_score
* sup_hs_cont acts_eds_update
* sup_hs_contacts_ meescore_update
* sup_hs_contacts_speed_to_ action_failures
* sup_hs_deals_calc_e ngagement_score
* su p_hs_dealstages
* sup_hs_tasks _subject_update
* sup_hs_ unattended_sqls
* sup_le adbuys_leadsapi
* sup_leadbu ys_overview_jfq
* sup_leadbuys_ overview_lendgo
* sup_ leadbuys_review
* sup_month_names
* sup_ms i_api_referrals
* sup_mysql_hubspo t_contacts_full
* sup_mysql_hubspot_e ngagements_full
* sup_reven ue_share_report
* sup_scrape_realtorc om_data_quality
* sup_scrape_realtorcom_data_ quality_summary
* sup_scrape_r ealtorcom_queue
* sup_scrape_re altorcom_status
* sup_smartmat ch_overview_log
* sup_smartmatch_o verview_summary
* sup_sm artmatch_review
* sup_sq_ reaction_report
* sup_widget_navigation_last_step _summary_report
* sup_widget_nav igation_summary
* sup_widget _summary_report
* snapshots
* fct_crm_report_data_sla_comp liance_snapshot
* fct_crm_report_data_sla_complia nce_snapshot_ex
* tests
* assert_mcc_time_valid_c alculated_costs
* assert_mcc_ valid_start_end
* dbt_utils
* macros
* generic_tests
* default__test _accepted_range
* default__te st_at_least_one
* default__test_cardi nality_equality
* default__test _equal_rowcount
* default __test_equality
* default__test_exp ression_is_true
* default__test_ fewer_rows_than
* default__test_mutually_e xclusive_ranges
* default__test_not_ accepted_values
* default__te st_not_constant
* default__test_n ot_empty_string
* default__test_not_ null_proportion
* defaul t__test_recency
* default__test_rela tionships_where
* default__test_se quential_values
* default__test_unique_combina tion_of_columns
* test _accepted_range
* te st_at_least_one
* test_cardi nality_equality
* test _equal_rowcount
* test_equality
* test_exp ression_is_true
* test_ fewer_rows_than
* test_mutually_e xclusive_ranges
* test_not_ accepted_values
* te st_not_constant
* test_n ot_empty_string
* test_not_ null_proportion
* test_recency
* test_rela tionships_where
* test_se quential_values
* test_unique_combina tion_of_columns
* jinja_helpers
* _is_ephemeral
* _is_relation
* de fault__log_info
* default__pr etty_log_format
* defau lt__pretty_time
* log_info
* pr etty_log_format
* pretty_time
* slugify
* sql
* _bigquery__get_ma tching_schemata
* bigque ry__deduplicate
* bigquery__get_tables _by_pattern_sql
* bigquery__hav ersine_distance
* date_spine
* deduplicate
* defa ult__date_spine
* defau lt__deduplicate
* default__ generate_series
* default__generat e_surrogate_key
* default__ge t_column_values
* default__get_filtered_colu mns_in_relation
* default__get_in tervals_between
* default__ge t_powers_of_two
* default__get_query_ results_as_dict
* default__get_relat ions_by_pattern
* default__get_rela tions_by_prefix
* default__g et_single_value
* default__get_ table_types_sql
* default__get_tables _by_pattern_sql
* default__get_table s_by_prefix_sql
* de fault__group_by
* default__hav ersine_distance
* def ault__nullcheck
* default__ nullcheck_table
* default__pivot
* de fault__safe_add
* defau lt__safe_divide
* default__star
* default __surrogate_key
* default__ union_relations
* d efault__unpivot
* defaul t__width_bucket
* deg rees_to_radians
* generate_series
* generat e_surrogate_key
* ge t_column_values
* get_filtered_colu mns_in_relation
* get_in tervals_between
* ge t_powers_of_two
* get_query_ results_as_dict
* get_relat ions_by_pattern
* get_rela tions_by_prefix
* g et_single_value
* get_ table_types_sql
* get_tables _by_pattern_sql
* get_table s_by_prefix_sql
* group_by
* hav ersine_distance
* nullcheck
* nullcheck_table
* pivot
* postgr es__deduplicate
* postgres__get_ table_types_sql
* redshi ft__deduplicate
* redshif t__width_bucket
* safe_add
* safe_divide
* snowfla ke__deduplicate
* snowflak e__width_bucket
* star
* surrogate_key
* union_relations
* unpivot
* width_bucket
* web
* defaul t__get_url_host
* default__ge t_url_parameter
* defaul t__get_url_path
* get_url_host
* ge t_url_parameter
* get_url_path
* codegen
* macros
* gene rate_base_model
* gener ate_column_yaml
* generate_mo del_import_ctes
* gene rate_model_yaml
* generate_source
* get_t ables_in_schema
* helpers
* add_model_column_descr iptions_to_dict
* build_dict_colu mn_descriptions
* get_mod el_dependencies
* Tables and Views
* dwellfulbi
* appdata
* 20210812_coldwell_banker_ realty_coverage
* 20210924_coldwell_banker_realt y_broker_id_map
* dash_user_info
* fastmatch_custom_state_city_br oker_assignment
* fastmatch_custom_zip_br oker_assignment
* fastmatch_in tel_median10kv2
* fa stmatch_network
* fastpath_log
* geo_st ate_city_to_zip
* geo_state_map
* geo_zip
* g eo_zip_distance
* g eo_zip_to_state
* hubspot_deleted
* le adbuys_api_keys
* leadbuys_log
* msi_agent _supported_zips
* s01_log
* scrape_realtorcom _median_history
* smar tmatch_api_keys
* smartmatch_log
* unqualification
* widget_e xcluded_session
* wi dget_insertions
* widget_log
* dbt_analytics
* fct_broker_regis tration_history
* fct_broker_registration_ history_monthly
* fct_contact_parsed_l ocation_mapping
* fct_contacts
* fct_crm_deals_associated_with_unreg istered_brokers
* fct_ crm_report_data
* fct_crm_report_data_ history_monthly
* fct_crm_report_data _history_weekly
* fct_crm_report_data _sla_compliance
* fct_crm_report_data_sl a_compliance_ex
* fct_crm_speed_to_action_n ew_report_daily
* fct_crm_speed_to_action_new_repor t_daily_lenders
* fct_crm_speed_to_action_new _report_monthly
* fct_crm_speed_to_action_ne w_report_weekly
* fc t_dash_contacts
* fct_dash_deals
* fct_dash _marketing_cost
* fct_dash_unqua lified_contacts
* fct_datastudio_coho rt_contact_deal
* fct_datastudio_cohort_marketi ng_contact_deal
* fct_datastudio_fin_marketi ng_contact_deal
* fct_datastudio_home advisor_metrics
* fct_datastudio_ website_traffic
* fct_deals
* fct_deals_for_revenu e_share_reports
* fct_deals_for_revenue_share_r eports_extended
* fct_forecast_va lidation_report
* fct_kpi_targets
* fct_last_l ocation_mapping
* fct_legacy_fm_custom_zip_br oker_assignment
* fct_ms i_api_referrals
* fct_newzip _broker_signups
* f ct_place_report
* fct_scrape_realtorco m_priority_list
* fct_sm artmatch_report
* fct_smartquali fication_report
* fct_sq_qualificati on_distribution
* int_api_a ctivity_summary
* int_aw_marketi ng_cost_summary
* in t_broker_agents
* int_broker_regis tration_history
* int_broker_registration_ history_monthly
* int_calculated_mar keting_cost_cpl
* int_calculated_marketing_ cost_smartmatch
* int_calculated_mark eting_cost_time
* int_calculated_oper ating_cost_time
* in t_channel_group
* int_collected_marketin g_cost_leadbuys
* int_contacts
* int_contacts_for_ partner_reports
* int_co verage_by_agent
* int_deals
* int_deals_for_ partner_reports
* int_fb_marketi ng_cost_summary
* int_fm_broker_n etwork_extended
* int_fm_custom_zip_br oker_assignment
* int_fm_in tel_median10kv2
* int_fm_z ip_coverage_map
* int_forecast_validat ion_report_data
* int_ga_web_ traffic_summary
* int_hs _contact_status
* int_hs_contacts
* int_hs_contacts_first_po st_sql_activity
* int_hs_contacts_ speed_to_action
* int_hs_contacts_sqls_with_no_ recent_activity
* in t_hs_dealstages
* int_hs_email _events_summary
* int_lb_contacts
* int_marketi ng_cost_summary
* int_scrape_realt orcom_completed
* int_scrape_ realtorcom_full
* int _smartmatch_log
* int_smar tmatch_log_flat
* int_smartmatch_lo g_flat_extended
* int_widget_author ized_insertions
* int_widget_ base_navigation
* int_wid get_base_report
* int_widget_c lean_navigation
* int_widget_i mpression_error
* int_wi dget_navigation
* int_widget_navigation_last_s tep_base_report
* int_widget_page init_navigation
* int_widget_sess ion_interaction
* int_widget_se ssion_rejection
* int_widget_submis sion_navigation
* snp_c rm_report_final
* s tg_agent_signup
* stg_aw_campaign_per formance_report
* stg_dash _broker_network
* stg_dash_d eals_unreferred
* stg _dash_user_info
* stg_ devsql_leadbuys
* stg_devsql _widget_session
* stg_devsql_wi dget_submission
* stg_es timation_helper
* stg_ fb_ads_insights
* stg_fct_crm_report_data_sla_comp liance_snapshot
* stg_fct_crm_report_data_sla_complia nce_snapshot_ex
* stg_fm _broker_network
* stg_fm_broker_ network_updates
* stg_fm_custom_state_city_br oker_assignment
* stg_fm_in tel_median10kv2
* stg_fm_intel_median1 0kv2_realtorcom
* stg _ga_web_traffic
* stg_geo_st ate_city_to_zip
* stg_geo_zip
* stg_g eo_zip_distance
* stg_g eo_zip_to_state
* stg _gs_kpi_targets
* stg_gs_market ing_cost_config
* stg_gs_operat ing_cost_config
* s tg_hs_campaigns
* stg_hs_contacts
* stg_hs_c ontacts_deleted
* stg_hs_contact s_non_customers
* stg_hs_deals
* stg_h s_deals_deleted
* st g_hs_dealstages
* stg_hs_ema il_events_click
* stg_hs_email_e vents_delivered
* stg_hs_em ail_events_open
* stg_hs_em ail_events_sent
* stg _hs_engagements
* stg_hs_owners
* stg_lb_co ntacts_leadsapi
* stg_ lb_contacts_ltm
* stg_leadbuys
* stg_le adbuys_api_keys
* stg_leadbuys_disqu alified_summary
* s tg_leadbuys_log
* stg_leadbu ys_overview_jfq
* stg_leadbuys_ overview_lendgo
* stg_mysql_brand
* stg_ mysql_brokerage
* stg _mysql_coverage
* stg_mysql _favorite_agent
* stg _mysql_location
* stg_prodsql_hubspot_co ntacts_override
* stg_p rodsql_leadbuys
* stg_prodsql_partner_r eference_config
* s tg_prodsql_team
* stg_prodsql _widget_session
* stg_prodsql_wi dget_submission
* stg_raw _day_date_spine
* stg_s01_log
* stg_scrape_realtorcom _median_history
* stg_smar tmatch_api_keys
* stg _smartmatch_log
* stg_ unqualification
* stg_widget_author ized_insertions
* stg_widget_e xcluded_session
* stg_widget_log
* stg _widget_session
* stg_wi dget_submission
* sup_api_activity _alert_snapshot
* sup_api_ activity_report
* sup_bad_replica tion_indicators
* sup_crm_contacts_with_ no_first_action
* sup_deal_ location_review
* sup_fm_broker_co verage_map_data
* sup_fm _broker_network
* sup_fm_broker_netw ork_json_export
* sup_fm_broker_netwo rk_mailing_list
* sup_fm_broker_network_mailing_ list_with_stats
* sup_fm_broker_network_p ipedrive_export
* sup_fm_broker_net work_statistics
* sup_fm_broker_net work_with_stats
* sup_fm_in tel_json_export
* sup_fm_intel_state_c ity_median10kv2
* sup_fm_intel_st ate_median10kv2
* sup_fm_intel_ zip_median10kv2
* sup_fm_state_city_br oker_assignment
* sup_fm_state_city_broker_ assignment_base
* sup_fm_zip_br oker_assignment
* sup_fm_zip_broker_ assignment_base
* sup_fm_zip_broker_ coverage_review
* sup_ geo_json_export
* sup_geo_zip_ range_state_map
* sup_hs_contacts_calc_e ngagement_score
* sup_hs_cont acts_eds_update
* sup_hs_contacts_ meescore_update
* sup_hs_contacts_speed_to_ action_failures
* sup_hs_deals_calc_e ngagement_score
* su p_hs_dealstages
* sup_hs_tasks _subject_update
* sup_hs_ unattended_sqls
* sup_le adbuys_leadsapi
* sup_leadbu ys_overview_jfq
* sup_leadbuys_ overview_lendgo
* sup_ leadbuys_review
* sup_month_names
* sup_ms i_api_referrals
* sup_mysql_hubspo t_contacts_full
* sup_mysql_hubspot_e ngagements_full
* sup_reven ue_share_report
* sup_scrape_realtorc om_data_quality
* sup_scrape_realtorcom_data_ quality_summary
* sup_scrape_r ealtorcom_queue
* sup_scrape_re altorcom_status
* sup_smartmat ch_overview_log
* sup_smartmatch_o verview_summary
* sup_sm artmatch_review
* sup_sq_ reaction_report
* sup_widget_navigation_last_step _summary_report
* sup_widget_nav igation_summary
* sup_widget _summary_report
* dbt_anal ytics_seed_data
* seed_channel_campaign_sourc e_revenue_share
* see d_channel_group
* seed _cj_attribution
* seed_cm_termination_ unqualification
* seed_empl oyee_email_list
* se ed_holiday_list
* seed_hs_c all_disposition
* seed_hs_con tact_status_map
* seed_lendingtree_smartm atch_correction
* seed_manual _marketing_cost
* seed_ phone_area_code
* seed_ smartmatch_cost
* seed_web_tra ffic_adjustment
* dbt_snapshots
* fct_crm_report_data_sla_comp liance_snapshot
* fct_crm_report_data_sla_comp liance_snapshot
* fct_crm_report_data_sla_complia nce_snapshot_ex
* fct_crm_report_data_sla_complia nce_snapshot_ex
* dev_appdata
* 20210812_coldwell_banker_ realty_coverage
* 20210924_coldwell_banker_realt y_broker_id_map
* dash_user_info
* fastmatch_custom_state_city_br oker_assignment
* fastmatch_custom_zip_br oker_assignment
* fastmatch_in tel_median10kv2
* fa stmatch_network
* fastpath_log
* geo_st ate_city_to_zip
* geo_state_map
* geo_zip
* g eo_zip_distance
* g eo_zip_to_state
* hubspot_deleted
* le adbuys_api_keys
* leadbuys_log
* msi_agent _supported_zips
* s01_log
* scrape_realtorcom _median_history
* smar tmatch_api_keys
* smartmatch_log
* unqualification
* widget_e xcluded_session
* wi dget_insertions
* widget_log
* devsql
* dwellfuld ev_agent_signup
* dw ellfuldev_brand
* dwellfuldev_broker_ network_updates
* dwellf uldev_brokerage
* dwell fuldev_coverage
* dwellfuldev_d eals_unreferred
* dwellfuldev _favorite_agent
* dwellfuldev_hubspot_co ntacts_override
* dwellfuldev_leadb uys_stringified
* dwell fuldev_location
* dwellfuldev_partner_r eference_config
* d wellfuldev_team
* dwellfuldev_widget_session_ legacy_mappings
* dwellfuldev_ widget_sessions
* dwellfuldev_wid get_submissions
* facebook
* ads_insights
* googleads
* CAMPAIGN_PER FORMANCE_REPORT
* ads
* googleanalytics
* MQL_Sub missions_by_Day
* g ooglesheets_cfg
* KPI_Targets
* Market ing_Cost_Config
* Operat ing_Cost_Config
* g ooglesheets_s01
* CMDeadLeads
* LeadsAPIData
* LendingTree
* Ownerly
* Qazzoo
* VerseU nqualifications
* Yardi
* hubspot
* campaigns
* contacts
* deal_pipelines
* deals
* email_events
* engagements
* owners
* prodsql
* dwellf ul_agent_signup
* dwellf ul_agent_signup
* dwellful_brand
* dwellful_brand
* dwellful_broker_ network_updates
* dwellful_broker_ network_updates
* dwe llful_brokerage
* dwe llful_brokerage
* dw ellful_coverage
* dw ellful_coverage
* dwellful_d eals_unreferred
* dwellful_d eals_unreferred
* dwellful _favorite_agent
* dwellful _favorite_agent
* dwellful_hubspot_co ntacts_override
* dwellful_hubspot_co ntacts_override
* dwellful_leadb uys_stringified
* dwellful_leadb uys_stringified
* dw ellful_location
* dw ellful_location
* dwellful_partner_r eference_config
* dwellful_partner_r eference_config
* dwellful_team
* dwellful_team
* dwellful_widget_session_ legacy_mappings
* dwellful_widget_session_ legacy_mappings
* dwellful_ widget_sessions
* dwellful_ widget_sessions
* dwellful_wid get_submissions
* dwellful_wid get_submissions
* sdc_ hubspot_sandbox
* campaigns
* contacts
* deal_pipelines
* deals
* email_events
* engagements
* owners
WELCOME!
Welcome to the auto-generated documentation for your dbt project!
NAVIGATION
You can use the Project and Database navigation tabs on the left side of the
window to explore the models in your project.
PROJECT TAB
The Project tab mirrors the directory structure of your dbt project. In this
tab, you can see all of the models defined in your dbt project, as well as
models imported from dbt packages.
DATABASE TAB
The Database tab also exposes your models, but in a format that looks more like
a database explorer. This view shows relations (tables and views) grouped into
database schemas. Note that ephemeral models are not shown in this interface, as
they do not exist in the database.
GRAPH EXPLORATION
You can click the blue icon on the bottom-right corner of the page to view the
lineage graph of your models.
On model pages, you'll see the immediate parents and children of the model
you're exploring. By clicking the Expand button at the top-right of this lineage
pane, you'll be able to see all of the models that are used to build, or are
built from, the model you're exploring.
Once expanded, you'll be able to use the --select and --exclude model selection
syntax to filter the models in the graph. For more information on model
selection, check out the dbt docs.
Note that you can also right-click on models to interactively filter and explore
the graph.
--------------------------------------------------------------------------------
MORE INFORMATION
* What is dbt?
* Read the dbt viewpoint
* Installation
* Join the dbt Community for questions and discussion
481 SEARCH RESULTS
Name Description Column SQL Tags
FCT_LAST_LOCATION_MAPPING MODEL
Helper dataset identifying the specifics detected for a given location as
provided by a customer, as well as statistics about how often a given location
is used. sed to detect issues in data parsing, or gaps in our broker network
coverage
columns: last_location, last_location columns: type, type columns: zip, zip Show
4 more
SELECT last_location , matching_location.type , matching_location.zip ,
matching_location.state_city_lookup , use_count , first_seen , last_seen FROM (
SELECT last_location {% if target.name == 'dev' %} ,
`dwellfulbi.dev_appdata.extract_broker_matching_location`(last_location) AS
matching_location {% else %} ,
`dwellfulbi.appdata.extract_broker_matching_location`(last_location) AS
matching_location {% endif %} , use_count , first_seen , last_seen FROM ( SELECT
last_location , MIN(createdate) AS first_seen , MAX(createdate) AS last_seen ,
COUNT(*) AS use_count FROM {{ref('int_contacts')}} WHERE last_location IS NOT
NULL --AND createdate >= TIMESTAMP('2022-04-01') GROUP BY last_location ) )
WHERE matching_location.type IS NOT NULL
STG_MYSQL_LOCATION MODEL
columns: id, id columns: accuracy, accuracy columns: city, city Show 9 more
SELECT a.id AS id, a.accuracy AS accuracy, a.city AS city, a.county_name AS
county_name, a.lat AS lat, a.lon AS lon, a.state_city_lookup AS
state_city_lookup, a.state_code AS state_code, a.state AS `state`, a.zip AS
zip_code, TIMESTAMP_MILLIS(a.created) AS created, TIMESTAMP_MILLIS(a.modified)
AS modified, {% if target.name == 'dev' %} FROM {{source('devsql','location')}}
a {% else %} FROM {{source('prodsql','location')}} a {% endif %}
STG_GEO_ZIP_TO_STATE MODEL
Geographical dataset: mapping of zip code ranges to state codes
columns: start_zip, start_zip columns: end_zip, end_zip columns: state_code,
state_code Show 0 more
SELECT * {% if target.name == 'dev' %} FROM
{{source('dev_appdata','geo_zip_to_state')}} {% else %} FROM
{{source('appdata','geo_zip_to_state')}} {% endif %}
INT_SMARTMATCH_LOG_FLAT_EXTENDED MODEL
SmarMatch analytics: extended log (similar to int_smartmatch_log_flat) with
referral information (when available), including referral status
columns: date, date columns: source, source columns: location, location Show 26
more
WITH requests AS ( SELECT b.date , b.source , b.success , b.location , b.budget
, b.property_type , b.timeline , b.match_token , b.message , 1 AS match_requests
, CASE WHEN success = 'true' THEN 1 ELSE 0 END AS impressions , CASE WHEN
success = 'false' THEN 1 ELSE 0 END AS failed_match_requests , n.broker_id ,
b.ref FROM {{ref('int_smartmatch_log')}} b LEFT JOIN
{{ref('stg_fm_broker_network')}} n ON b.external_broker_id =
n.external_broker_id WHERE b.method = 'requestMatch' ), lendingtree_fix AS (
SELECT r.date , r.source , r.success , r.match_token , r.message , f.email , 1
AS clicks , 1 AS accepted_matches , 0 AS rejected_matches , r.ref , CAST(NULL AS
STRING) AS self_reported_credit , CAST(NULL AS INT64) AS downpayment FROM
requests r INNER JOIN {{ref('seed_lendingtree_smartmatch_correction')}} f ON
r.source = 'LendingTree' AND f.ref = r.ref ), accepts AS ( SELECT date , source
, success , match_token , message , email , 1 AS clicks , CASE WHEN success =
'true' THEN 1 ELSE 0 END AS accepted_matches , CASE WHEN success = 'false' THEN
1 ELSE 0 END AS rejected_matches , ref , self_reported_credit , downpayment FROM
{{ref('int_smartmatch_log')}} WHERE method = 'acceptMatch' UNION ALL SELECT *
FROM lendingtree_fix ), augmented_accepts AS ( SELECT b.* , CASE WHEN
c.lifecyclestage IN ('marketingqualifiedlead','salesqualifiedlead') THEN (CASE
WHEN c.hs_lead_status = 'UNQUALIFIED' THEN 'Lead: Unqualified' WHEN
c.hs_lead_status = 'Nurture' THEN 'Lead: Nurture' ELSE 'Lead: Pending Review'
END) WHEN c.lifecyclestage = 'opportunity' THEN (CASE WHEN c.hs_lead_status =
'UNQUALIFIED' THEN 'Referral: Unqualified' ELSE CONCAT('Referral: ',
IFNULL(d.deal_status, 'Other')) END) WHEN c.lifecyclestage = 'customer' THEN
'Customer' WHEN c.lifecyclestage IS NULL THEN NULL ELSE 'Other' END AS status ,
CASE WHEN c.lifecyclestage IN ('marketingqualifiedlead','salesqualifiedlead')
AND c.hs_lead_status IN ('NEW','OPEN','Review','Nurture') THEN 1 ELSE 0 END AS
pending_leads , CASE WHEN c.lifecyclestage = 'salesqualifiedlead' AND
c.hs_lead_status = 'UNQUALIFIED' THEN 1 ELSE 0 END AS rejected_leads , CASE WHEN
c.lifecyclestage IN ('opportunity','customer') AND d.dealid IS NOT NULL THEN 1
ELSE 0 END AS referrals , CASE WHEN c.lifecyclestage = 'opportunity' AND
c.hs_lead_status = 'UNQUALIFIED' AND d.dealid IS NOT NULL THEN 1 ELSE 0 END AS
lost_referrals , CASE WHEN c.lifecyclestage = 'opportunity' AND c.hs_lead_status
<> 'UNQUALIFIED' AND d.dealid IS NOT NULL THEN 1 ELSE 0 END AS active_referrals
, CASE WHEN c.lifecyclestage = 'customer' AND d.dealid IS NOT NULL THEN 1 ELSE 0
END AS won_referrals , CASE WHEN c.lifecyclestage IS NOT NULL AND
c.lifecyclestage NOT IN ('salesqualifiedlead','opportunity','customer') THEN 1
ELSE 0 END AS other_leads , CASE WHEN d.dealid IS NULL THEN NULL ELSE
d.referral_broker_id END AS referral_broker_id , c.vid , d.dealid , CASE WHEN
(CASE WHEN d.dealid IS NOT NULL THEN 'Qualified' ELSE c.qualification_status
END) = 'Qualified' THEN (CASE WHEN c.sq_step IN ('Qualified') THEN 1 ELSE 0 END)
ELSE NULL END AS confirmed , JSON_VALUE(d.automation_data_json,
'$.automated_referral_flag') = 'true' AS automated_referral_flag /* , CASE WHEN
c.is_employee = false -- Not an employee AND d.was_referred = true -- Was
referred AND NOT (d.dealstage = 'closedlost' AND d.lost_reason_group IN
('Referral Aborted','No Agent Coverage')) THEN 1 ELSE 0 END AS valid_referral */
FROM accepts b LEFT JOIN {{ref('int_hs_contacts')}} c ON b.success = 'true' AND
c.email = b.email LEFT JOIN {{ref('int_deals')}} d ON d.contact_vid = c.vid AND
c.is_employee = false -- Not an employee AND d.was_referred = true -- Was
referred AND NOT (d.dealstage = 'closedlost' AND d.lost_reason_group IN
('Referral Aborted','No Agent Coverage')) -- Remove deals that were never
referred (based on voluntary CRM flag) ) SELECT d.* , n.broker_name ,
COALESCE(dn.broker_name,n.broker_name) AS dash_broker_name FROM ( SELECT r.date
, r.source , r.location , r.budget , r.property_type , r.timeline ,
COALESCE(a.message,r.message) AS error , r.match_requests , r.impressions ,
r.failed_match_requests , IFNULL(a.clicks,0) AS clicks ,
IFNULL(a.accepted_matches,0) AS accepted_matches , IFNULL(a.rejected_matches,0)
AS rejected_matches , IFNULL(a.pending_leads,0) AS pending_leads ,
IFNULL(a.rejected_leads,0) AS rejected_leads , IFNULL(a.referrals,0) AS
referrals , IFNULL(a.lost_referrals,0) AS lost_referrals ,
IFNULL(a.active_referrals,0) AS active_referrals , IFNULL(a.won_referrals,0) AS
won_referrals , COALESCE(a.referral_broker_id,r.broker_id) AS broker_id ,
COALESCE(a.ref,r.ref) AS ref , a.vid AS dwellful_contactid , a.dealid AS
dwellful_dealid , IFNULL(a.confirmed,0) AS confirmed_matches ,
a.automated_referral_flag , a.self_reported_credit , a.downpayment --,
IFNULL(a.valid_referral,0) AS valid_referral FROM requests r LEFT JOIN
augmented_accepts a ON a.source = r.source AND a.match_token = r.match_token ) d
LEFT JOIN {{ref('stg_fm_broker_network')}} n ON n.broker_id = d.broker_id LEFT
JOIN {{ref('stg_fm_broker_network')}} dn ON dn.broker_id = n.dash_broker_id
FCT_DATASTUDIO_HOMEADVISOR_METRICS MODEL
This table has the data to produce the Home Advisor report in datastudio
allowing us to look at KPI's and effiicency metrics by each Home Advisor
columns: leads, leads columns: SQLs, SQLs columns: referrals, referrals Show 13
more
SELECT COUNT (c.vid) as leads ,sum (case when
hc.hs_lifecyclestage_salesqualifiedlead_date is not null then 1 else 0 end) as
SQLs --,count (d.dealid) as referrals ,sum (case when d.deal_stage_index IN
(1,2,3,4,5,6,7,8,9,10) then 1 else 0 end) as referrals ,sum (case when
d.deal_stage_index IN (6,7,9) then 1 else 0 end) as closings ,sum (case when
d.dealid is not null then d.forecasting_probability else 0 end) as
forecast_closings ,c.createdate --,FORMAT_DATE('%b %Y', DATE (c.createdate)) AS
monthyear ,DATE_TRUNC(c.createdate, MONTH) AS monthyear ,c.contact_status_index
,c.contact_status_ordered ,hc.hs_lead_status ,hc.workflow_priority
,hc.lifecyclestage , o.lastname as home_advisor ,d.deal_status_ordered
,cg.channel_group ,c.campaign_source FROM {{ref('fct_contacts')}} c LEFT JOIN
{{ref('stg_hs_contacts')}} hc on c.vid = hc.vid LEFT JOIN {{ref('fct_deals')}} d
ON c.vid = d.contact_vid LEFT JOIN {{ref('stg_hs_owners')}} o ON CAST
(o.owner_id as string ) = hc.hubspot_owner_id AND c.vid IS NOT NULL LEFT JOIN
{{ref('int_channel_group')}} cg ON cg.channel = hc.channel AND
cg.campaign_source = hc.campaign_source WHERE c.createdate >= '2022-11-01' and
c.contact_status_index <> 0 and cg.channel_group = 'Lender' GROUP BY
c.createdate ,c.contact_status_index ,c.contact_status_ordered
,hc.hs_lead_status ,hc.workflow_priority ,hc.lifecyclestage , o.lastname
,d.deal_status_ordered ,cg.channel_group ,c.campaign_source
SEED_CHANNEL_CAMPAIGN_SOURCE_REVENUE_SHARE SEED
TODO: Review this seed and dependencies: Things changed over time and a review
in Janury 2023 indicates this may no longer work as expected since the addition
of campaign source suffixes with :SQ and :AA. Experimental / partially
maintained data seed to help calculate revenue share amounts.
columns: channel, channel columns: campaign_source, campaign_source columns:
calculate, calculate Show 1 more
SEED_CM_TERMINATION_UNQUALIFICATION SEED
Data dump of all contacts held by Conversion Monster at the time we ended our
engagement and unqualified these contacts in Hubspot or our Leads dataset
columns: email, email Show -2 more
SEED_PHONE_AREA_CODE SEED
Mapping of area codes to states - not actually used (was originally planned for
task tagging from phone area code to timezone - we now instead us the expected
deal state to predict a contact's time zone)
columns: area_code, area_code columns: country, country columns: state_code,
state_code Show 0 more
SEED_HS_CONTACT_STATUS_MAP SEED
Mapping/translation for Hubspot contact lifecycle and statuses
columns: hs_lifecycle_stage, hs_lifecycle_stage columns: hs_lead_status,
hs_lead_status columns: lifecycle_sequence_index, lifecycle_sequence_index Show
2 more
SEED_CJ_ATTRIBUTION SEED
Archived Commission Junction attributions and associated fees
columns: cj_OID, cj_OID columns: event_date, event_date columns: cj_AID, cj_AID
Show 5 more
SEED_LENDINGTREE_SMARTMATCH_CORRECTION SEED
Missing SmartMatch leads from the smartmatch log, manually recovered to ensure
complete reporting of all LendingTree SmartMatch leads
columns: vid, vid columns: email, email columns: ref, ref Show 0 more
SEED_CHANNEL_GROUP SEED
This data seed is locked: new logic put in place allows the automatic detection
of Lenders vs Publishers based on API key configuration. Historical conversion
of (channel/campaign_source) to channel group for contacts imported prior to the
dynamic logic creation and DTC sources.
columns: channel, channel columns: campaign_source, campaign_source columns:
channel_group, channel_group Show 0 more
SEED_SMARTMATCH_COST SEED
Configuration of SMartMatch marketing cost over time. While the API key provide
for default costing details, and the partner may provide details in the API
calls, historical usage failed to match our needs and settings in this seed
dataset will override any API data. While the dataset is conceptually useful to
configure actual (upfront) lead costs by aggregating impressions, conversions,
etc., as well as revenue share calculations, confidence in the data is low as
engineering had to pro-actively ask the partnership team for update specific
when programs changed over time and may not always have been informed. Internal
consensus is that the data calculated through this dataset isn't reliead on
actively for any mission-critical decision support.
columns: channel, channel columns: campaign_source, campaign_source columns:
opportunity_cost, opportunity_cost Show 6 more
SEED_WEB_TRAFFIC_ADJUSTMENT SEED
Adjustment to bad data in Google Analytics due to some double counting in early
2020.
columns: date, date columns: sessions, sessions columns: conversions,
conversions Show 0 more
SEED_HOLIDAY_LIST SEED
Holiday dates in the US until 2031. Used to calculate work hours / off-hours for
CRM reports.
columns: holiday_date, holiday_date Show -2 more
SEED_EMPLOYEE_EMAIL_LIST SEED
List of personal email addresses for known employees that aren't in the standard
@dwellful.com or @newzip.com and excluded by the generic logic
columns: email, email Show -2 more
SEED_MANUAL_MARKETING_COST SEED
Data seed for miscellaneous marketign costs not tracked in the standard data
tables originally replicated through StitchData
columns: date, date columns: channel, channel columns: campaign_source,
campaign_source Show 1 more
SEED_HS_CALL_DISPOSITION SEED
List of phone call dispositions as reported from Hubspot (not available through
StitchData and instead extracted through a one-time API call). Used to report on
disposition in CRM reports.
columns: disposition, disposition columns: label, label columns: deleted,
deleted Show 0 more
FCT_CRM_REPORT_DATA_SLA_COMPLIANCE_SNAPSHOT SNAPSHOT
columns: snapshot_date_local, snapshot_date_local columns: sla_warning_count,
sla_warning_count columns: active_referral_count, active_referral_count Show 4
more
{{ config( target_schema='dbt_snapshots', strategy='check',
unique_key='snapshot_date_local', check_cols='all' ) }} select * from
{{ref('fct_crm_report_data_sla_compliance')}}
FCT_CRM_REPORT_DATA_SLA_COMPLIANCE_SNAPSHOT_EX SNAPSHOT
columns: id, id columns: snapshot_date_local, snapshot_date_local columns:
dealid, dealid Show 7 more
{{ config( target_schema='dbt_snapshots', strategy='check', unique_key='id',
check_cols='all' ) }} select * from
{{ref('fct_crm_report_data_sla_compliance_ex')}}
Show 461 more
Refocus on NodeView documentationHide this and parentsHide this and
childrenExport PNG