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, us_region_4, state, country, timezone, go_live_date, created_at_datetime |
dim_employees | employee_id (PK), email, first_name, last_name, created_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, reward_amount, payment_status, 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, interactions_count, chat_interactions_count, transactions_count, transaction_subtotal_amt, unique_customers_count, most_popular_item_id |