Exporting Yogi Data

Yogi offers a powerful set of easy-to-use tools which make uncovering meaningful insights possible. Have you ever thought “this is great, but can Yogi enable me to use my preferred analytics tool?” Yes we can! Whether you’re a BI software pro or you thrive on the simplicity of spreadsheets, we have you covered. In this article, you will learn about the process of exporting data from the Yogi.

How to Export

First, apply relevant Filters to select all the filters that you want applied. Any Search or Date filters can also be applied using the appropriate controls.

Once you've pared down your data using filters, you can export just that filtered data by clicking Save & Export in the top right corner of Charts, Feedback, or Keywords pages.

Finding your Exported Data

Within a few minutes, you will receive an email from Yogi with a link to download your requested data export CSV. The email will be sent to your Yogi user login email address. Make sure to check your spam folder if you are having trouble finding the email.

Explanation of CSV file

Use spreadsheet software such as Excel, Google Sheets, Open Office, or Numbers to open the CSV file emailed to you. Each row in the exported sheet either represents a sentence within a review OR a star rating-only review.

Column Header	Description
Yogi Dashboard	Identifies which Yogi Dashboard the data is sourced from.
Sentence ID	Unique identifier of each sentence from every review in the dataset. Each row of the data exports represents either (1) a unique star rating only review OR (2) a unique sentence within a review For (1) Sentence ID will be blank (null) since only star ratings have no text. For (2) the Sentence ID will always be unique for each row.
Sentence	The entire actual text of this particular sentence. For reviews originally written in a non-English language, you will see the translated text here.
Sentence Sentiment	Yogi uses AI models to determine how positive or negative the tone of each sentence is and assigns it a sentiment score between -0.9 and 0.9.
Sentence Sentiment Label	Based on the Sentence Sentiment score, Yogi labels sentiment score of -.9 to -.3 as "negative", -0.3 to 0.3 as "neutral" and 0.3 to .9 as "positive".
Sentence Keywords	Yogi uses AI models to identify the most important words that appear within the sentence.
Sentence Theme	Yogi's uses deep learning AI models to identify what the primary conversation "Theme" that each sentence is referring to. Most Yogi Dashboard have between 12 to 24 Sentence Themes. There are two unique Themes called: "Fans/Attractors": simple but unspecific positive feedback that indicates that customers are happy, would repurchase or would recommend the product to others. "Critics/Detractors"; simple but unspecific negative feedback that indicates that customers are upset, would not repurchase or would not recommend the product to others.
Sentence Count	A numerical identifier of each sentence within reviews with multiple sentences. . All star ratings-only reviews are labeled "1" in this column. Yogi Power User Tip: Filter this column for "1" for calculations requiring review-level output, this will de-duplicate any reviews with multiple sentences..
Review & Rating ID	Unique identifier of each review or rating in the dataset. Yogi Power User Tip: Since 1 review can have multiple sentences and each row has 1 unique sentence, there will be duplicate Review and Rating IDs within the dataset. This can be accounted for by using a "distinct count" formula to isolate the number of reviews and ratings.
Review & Rating Input ID	Identifier provided by the source (for rating and reviews data, the source is usually an eCommerce retailer.
Date	Date that the sentence and review was written or the rating was posted.
Rating Only	"True" = The post only had a star rating but no written review (and thus sentence). "False" = The review has text. Yogi Power User Tip: Ratings-only reviews can add noise to the dataset and make it more difficult to identify insights. Keep this filtered at "Rating Only" = "False" to isolate reviews with text
Review Title	Title of the review, if it exists.
Review Body	The entire original text of the review that the row's sentence comes from. Yogi Power User Tip: This column will have duplicates for reviews with more than one sentence. Therefore, apply a filter to "Sentence Count" = "1" to deduplicate this column’s data.
Promotion	Yogi’s AI NLP engine identifies a variety of review incentive programs. "Null" = The review was written "organically", without any incentive. "True" = The review was collected as part of a promotion i.e. incentivized in some way. "Discounted" = The reviewer received a discount in return for the review. "Amazon Vine" = The review was written by a member of Amazon’s invitation-only "Vine Voices" program. Yogi Power User Tip: Set this as "Null" to remove any noise from incentivized customer feedback and focus on "organic" feedback.
Username	Username of author of the review, if it exists.
Location	Location of customer provided by the source in the format they use.
Country	Identifies either the country where the customer posted their review from or the country that the source (retailer) is based.
Rating	1 to 5 star rating given by the reviewer. Yogi Power User Tip: Since 1 review can have multiple sentences and each row represents 1 unique sentence, the Rating in this column may be duplicated. A formula or filter deduplicating this data should be used to obtain an accurate average star rating figure.
URL	The URL of the review or rating if provided by the source (retailer). May be blank in some cases such as with syndicated reviews.
Review Word Count	The # of words within the entire review.
Source Title	Detailed description of the review source.
Source Type	The online retailer that the review originally came from (eg. Amazon, Target, Walmart). If the review was cross-posted then this will not specify the source retailer but rather be labeled "Syndicated".
Product	Name of the product that the sentence/review is referring to.
Brand	Brand of the product the sentence/review is referring to.
Recommended	"True" = the reviewer indicated that they would "recommend this product to others". "False" = the reviewer indicated that they would not "recommend this product to others". "Null" (blank) = The retailer normally does not offer that information or the review author did not make a selection.
Syndicated On	If the review was syndicated, this column indicates where that syndicated review was originally posted
Verified	"True” = The review was marked as a "verified" purchase. "False"= The review was not marked as a "verified" purchase. "Null" (blank) = The retailer normally does not offer information about verified reviews.

Exported Yogi Data Column Explanations.docx

18.1 KB