dim_dates | date_id (PK), year, quarter, month, week, day_name, month_name, is_weekend |
dim_locations | location_id (PK), account_id, brand, name, active, internal, us_region_4, us_region_9, state, country, timezone, go_live_date, created_at_datetime, google_reviews_pre_go_live, google_rating_pre_go_live |
dim_employees | employee_id (PK), email, first_name, last_name, ingested_at_datetime |
fact_customers_saved | customer_id, location_id, account_id, brand, saved_revenue, saved_visits, created_at_datetime |
fact_employee_mentions | mention_id (PK), location_id, account_id, brand, employee_id, review_id, platform, rating, manual_review_requested, created_at_datetime |
fact_interactions | interaction_id (PK), location_id, account_id, brand, customer_id, interaction_type, associated_review_gate, review_gate_sentiment, messages_inbound_count, messages_outbound_count, resolved, resolved_date, first_response_minutes, created_at_datetime |
fact_messages | message_id (PK), location_id, account_id, brand, interaction_id, customer_id, message_type, sender_type, message_origin, message_read, interaction_resolved, review_gate_sentiment, shown_in_chat, created_at_datetime |
fact_reviews | review_id (PK), location_id, account_id, brand, first_version_datetime, last_version_datetime, platform, rating, author, endorsed, endorsed_datetime |
fact_review_versions | review_version_id (PK), review_id, location_id, account_id, brand, version_datetime, platform, rating, author, endorsed, endorsed_datetime |
fact_transactions | transaction_id (PK), location_id, account_id, brand, customer_id, pos_transaction_id, transaction_datetime, transaction_item_count, transaction_subtotal |
fact_transaction_items | transaction_item_id (PK), transaction_id, location_id, account_id, brand, customer_id, item_id, item_product_type, item_price, item_quantity, item_subtotal |
fact_location_daily_stats | id (PK), location_id, account_id, brand, date_id, review_gate_count, avg_review_gate_rating, reviews_count, avg_review_rating_last_month, avg_review_rating_last_quarter, avg_review_rating_last_year, avg_review_rating_all_time, review_versions_count, interactions_count, chat_interactions_count, outbound_messages_count, inbound_messages_count, avg_first_response_minutes, employee_mentions_count, transactions_count, transaction_items_count, transaction_subtotal_amt, unique_customers_count, most_popular_item_id |