Birdie Data Schema

How to prepare your data for ingestion at Birdie

P
Written by Product Team
Updated over a week ago

Birdie will handle different data structures to support feedback analysis.

Feedback:

Feedback are records containing one piece of comment, usually associated to a score or rating. Ex.: NPS and CSAT Responses, Reviews, etc.

All feedback sources will potentially have the following Core fields and, depending on the Feedback kind, they may have additional ones, as described:

Core fields - For all Feedback kinds

  • feedback_id

This is a unique identifier for the feedback record. It's an important piece of data to avoid duplication once you need to reprocess a record to incorporate additional fields, for example.

  • author_id

This is consistent identifier for the user, author of the feedback. This field will be used to match feedback records with customer records when importing. customers and users profile and behavior data.

  • account_id

This is consistent identifier for the account associated to the author of the feedback. This field will be used to match feedback records with customer records when importing. customers and users profile and behavior data.

  • text

This is the main field. The feedback comment itself. This field will be processed and enriched along the AI pipeline

  • title

This is an eventual title of the feedback. Some kinds as Reviews allows the user to publish a title and a main comment.

  • rating

This is the score associated to the feedback. It will assume different formats and calculations depending on the feedback kind. Ex.: Review records will calculate this Rating field as a Star Rating (avg 1 to 5 stars), NPS records will calculate this Rating as an NPS Score (%promoters - %detractors)

  • posted_at

This is the publishing date. It will be used to place a feedback record in a timeline for analysis.

NPS or CSAT

  • author_name

Name of the user (optional)

  • survey_title

Name of the Survey

Conversation:

Conversation are records containing a collection of comments between two or more participants. It's a common format in Support tickets, Issue reports or Social Forums and Posts.

All conversation kinds will potentially have the following Core fields and, depending on the Conversation kind, they may have additional ones, as described:

Core fields - For all Conversation kinds

  • conversation_id

This is consistent identifier for the conversation. It typically groups individual messages within a conversation. Ex.: Ticket ID, Forum thread, etc

  • message_id

This is consistent identifier for the unique comment within the conversation. It's important to avoid duplication as you reprocess the conversation.

  • account_id

This is consistent identifier for the account associated to the author of the feedback. This field will be used to match feedback records with customer records when importing. customers and users profile and behavior data.

  • author_id

This is consistent identifier for the user, author of the feedback. This field will be used to match feedback records with customer records when importing. customers and users profile and behavior data.

  • text

This is the main field. The feedback comment itself. This field will be processed and enriched along the AI pipeline

  • posted_at

This is the publishing date. It will be used to place a feedback record in a timeline for analysis.

Support tickets fields

  • subject

Subject of the ticket

  • status

Status of the ticket

  • priority

Priority of the ticket

  • channel

Channel of the ticket (ex.: email, chat, phone, etc)

  • author_name

Name of the user

  • author_type

Type of the user. This is used to split customers, support agents or bots

Issue report fields

  • title

Issue title

  • project_id

Id of project or product

  • project_name

Name of the project or product

  • status

Status of the Issue report

  • author_name

Name of the user

Social Media Post

  • title

Post title

  • channel

Channel of the Post

  • owners

Owner of the Post

  • tags

Tag collection, associated to the Post

  • category

Category of the Post

  • url

URL to the Post

  • author_name

Name of the user

  • author_type

Type of the user

  • upvotes

Number of interactions (likes, upvotes, depending on the platform)


โ€‹

Did this answer your question?