One row is
one review
Delivery
Rewritten daily
Columns
19
Where it lands
snapshot_date= partition only, and check for _SUCCESS before you do, as
described in bucket layout.
Columns
Internal warehouse key. Not stable between deliveries — join on
conversation_feedback_id instead.Join key. Conversation being reviewed. Matches
cloudchat_id on claudia_conversation.Whether the reviewer thought the conversation should have been escalated but was not. Rows with
true are the missed-escalation cases.Whether the reviewer thought the agent could have resolved it without escalating. The mirror of
conversation_should_scaled_to_n2_flag.The tag the reviewer says should have been used. Populated when
is_tag_correct_flag is false.When the datamart last wrote this row. Use it to spot reviews added or edited since your previous load.