I have a request to create using data explorer dashboards at Category level with certain key metrics that will be automated via automation every month, going to Category moderators so that they can be aware of performance, make business decisions off the back of it. Sentiment analysis - this has be…

[изображение] SStrong: one called target_id but no idea what that refers to I think this is dependant on the target_type column. For instance, if it’s got a target_type of ‘post’ then the target_id is a post_id

Thanks, that helps a lot. So just to check—if target_type is ‘post’, then I should join classification_results.target_id to posts.id, right? And if the target_type is something else, like ‘comment’, then I’d join it to the comments table instead? Just want to make sure I’m joining to the right tab…

[изображение] Michael12: And if the target_type is something else, like ‘comment’, then I’d join it to the comments table instead? I’m not sure comments are processed by AI sentiment. :thinking: Is this a target_type you’re seeing in your data? I think it may currently be post only, but with…

[изображение] JammyDodger: SELECT target_type FROM classification_results GROUP BY 1 I can only see post as a target_type. Am I correct in thinking that a post is a multiple of types in it’s on right as well. For example, one topic can have 10 posts in total. So does that mean that the senti…

The sentiment analysis is applied at the post level, so each post would have its own record in the classification_results table. Each post would also have a separate record for every model applied to it as well, so depending on which results you’re interested in you’d want to filter out those specif…

Overall sentiment code is not working, I get no results at all but the fronn=t end sentiment analysis is showing for users

Hmm. :thinking: I’ve just given it a test and it works for me. Maybe a little basic, but just to check, did you adjust the date range parameters to something more recent than the default ones?

Запрос поддержки: соединение таблицы classification_results с другими таблицами

Создание сообщества Данные и отчетность

JammyDodger 25.Июнь.2025 16:33:07 2

Думаю, это зависит от столбца target_type. Например, если в нём указано target_type со значением ‘post’, то target_id — это post_id.

Тема		Ответов	Просм.
Community Sentiment and Toxicity queries Data & reporting ai , sql-query	14	1182	13.11.2024
Adding visuals to Sentiment Analysis Feature ai , ai-sentiment	14	794	15.12.2023
Dashboard Report - Overall Sentiment Data & reporting dashboard-reports , sql-query , dashboard-sql , ai , ai-sentiment	3	805	03.07.2025
Dashboard Report - Post Emotion Data & reporting dashboard-reports , sql-query , dashboard-sql , ai-sentiment , ai	0	482	16.02.2024
AI sentiment and emotion analysis reports Data & reporting sql-query , ai , ai-sentiment	0	155	15.07.2025

Запрос поддержки: соединение таблицы classification_results с другими таблицами

Связанные темы