Source files

One page per source file: a view, a model or a dashboard. Each starts with what it does, why it exists and where it breaks.

advertising-marketing-small: views 4

Source file campaign clicks and conversions Two views hold a stored click_interactions_by_ip_for_useable_campaigns.count per IP, one for clicks and one... 3 views2 warnings Source file geo_pid_facts Reads four columns from a pre-built table: geo, pid, ip_count and a stored count. It adds a row-count measu... view2 warnings Source file ip cluster views Four views over clustering output. ip_2_cluster.class and ip_3_cluster.class label each IP. The model views... 4 views3 warnings Source file other_browser_os_impressions Exposes raw ad impression rows with browser, OS, user agent, IP, geography, subid, campaign, creative and b... view4 warnings

advertising-marketing-small: dashboards 1

Source file default (Unusual UAs) Eight tiles over the other_browser_os_impressions explore: browser and OS mix, rare user agents, top PIDs a... dashboard3 warnings

dating-platform: views 14

Source file bookings Reads one row per booking: offer and version, promo, subscription, quantity, price_paid, status, surprise a... view3 warnings Source file churn Unions four counts per site, source and calendar day: new users as leads, downgrades, upgrades and renewals... view3 warnings Source file events A derived table over events_atomic with page, referer, structured event and ecommerce columns. It defines e... view4 warnings Source file experiments and buckets experiments.name, start and end dates, experiments.num_buckets and experiments.winning_bucket describe each... 2 views4 warnings Source file messages Reads one row per message with sender, recipient, thread, proposition, type, state and reply flags, plus a ... view3 warnings Source file proposition_templates Reads proposition templates: category, location, featured and official flags, created, expires and deleted ... view3 warnings Source file propositions Builds one row per proposition from propositions, joined to response counts per message type and to the tem... view3 warnings Source file sessions One derived table that stitches session basics, geo, landing page, exit page, source and technology into a ... 2 views4 warnings Source file subscriptions Reads one row per subscription from public.subscriptions: status, auto_renew, trial_days, renewal period an... view3 warnings Source file transaction_items Order lines from transaction_item events: order id, category, SKU, name, price and quantity. Measures are i... view3 warnings Source file transactions Builds web orders from transaction events: order id, affiliation, total, tax, city, state, country and the ... view3 warnings Source file user_score Reads one row per user from public.user_score: score, score_pre_signup, demographic_quality, expected_ltv a... view3 warnings Source file user_tenure_metrics Cross joins users with a numbers table for tenure 1, 3 and 7, then sums 30-day lifecycle metrics (photos, d... view3 warnings Source file visitors One row per cookie visitor with first and last touch, lifetime events, pages and sessions, plus the landing... view4 warnings

dating-platform: models 2

Source file enterprise Declares six explores on project_connection: churn, transactions, messages, propositions, date_ideas and te... model4 warnings Source file event_tracker Six explores on project_connection: events joined to sessions and visitors, sessions joined to visitors, pl... model3 warnings

dating-platform: dashboards 2

Source file business dashboards Business overview (7 tiles), Conversion Rates (3 tiles) and Maps (3 tiles). They chart revenue, transaction... 3 dashboards4 warnings Source file traffic_pulse Twelve tiles on the sessions explore: new vs returning split, sessions by referer medium, country and landi... dashboard3 warnings