Calculator Inputs
Example Data Table
| Brand | Positive | Neutral | Negative | Verified | Engagement % | Response Hours | Resolved / Issues | Credibility | Fake Risk |
|---|---|---|---|---|---|---|---|---|---|
| NovaMart | 860 | 310 | 140 | 410 | 7.8 | 3.5 | 46 / 50 | 84 | 18 |
| UrbanNest | 520 | 260 | 210 | 180 | 5.2 | 11.0 | 28 / 44 | 71 | 31 |
| BrightMode | 940 | 390 | 120 | 530 | 9.4 | 2.2 | 63 / 66 | 91 | 12 |
Formula Used
1) Net Sentiment Balance
Net Sentiment % = ((Positive Mentions − Negative Mentions) ÷ Total Mentions) × 100
2) Sentiment Score Conversion
Sentiment Score = ((Net Sentiment % + 100) ÷ 2)
3) Verified Ratio
Verified Ratio % = (Verified Mentions ÷ Total Mentions) × 100
4) Issue Resolution Rate
Issue Resolution % = (Resolved Issues ÷ Total Issues) × 100
5) Response Time Score
Response Time Score = 100 − min((Response Hours ÷ 48) × 100, 100)
6) Engagement Score
Engagement Score = min((Engagement Rate ÷ 15) × 100, 100)
7) Trust Sentiment Index
TSI = [ (Sentiment × 0.28) + (Credibility × 0.14) + (Verified Ratio × 0.10) + (Engagement × 0.12) + (Resolution × 0.12) + (Response Speed × 0.08) + (Review Share × 0.08) + (Advocacy × 0.08) ] − (Fake Risk × 0.10), then multiplied by Campaign Weight.
How to Use This Calculator
- Enter the brand or campaign name and reporting period.
- Provide positive, neutral, and negative mention counts.
- Add verified-source mentions to strengthen confidence analysis.
- Enter engagement rate and average response time.
- Fill in resolved issues and total issues reported.
- Score credibility and fake engagement risk on a 0–100 scale.
- Enter positive review share and customer advocacy rate.
- Adjust campaign weight if this period deserves more influence.
- Click the calculate button to show results above the form.
- Use CSV or PDF export to save your output.
8 FAQs
1. What does the Trust Sentiment Index measure?
It combines sentiment, credibility, verified participation, engagement, customer care, and fake-risk signals into one social trust score. It helps compare campaigns and track reputation changes over time.
2. Why include verified mentions?
Verified or trusted-source mentions usually carry more influence and lower manipulation risk. Including them improves confidence in the sentiment picture and strengthens authenticity analysis.
3. How does fake engagement risk affect the score?
Fake engagement risk acts as a penalty. High suspicious activity can make raw engagement look strong while real audience trust remains weak, so the model deducts value from the final index.
4. What is a good Trust Sentiment Index?
Scores above 70 usually indicate strong trust conditions. Scores from 55 to 69 suggest moderate stability, while anything below 40 often signals urgent reputation and service concerns.
5. Can I use percentages and counts together?
Yes. Counts are used for mention and issue volumes, while percentages represent engagement, reviews, advocacy, and derived ratios. This mix gives a broader trust view than sentiment alone.
6. Why does response time matter in trust analysis?
Fast responses usually show accountability and care, especially during complaints or confusion. Slower response times can damage brand confidence even when sentiment volume looks acceptable.
7. What should I do if total mentions are blank?
Leave total mentions empty when you only know positive, neutral, and negative values. The calculator will automatically sum those three fields and use that total.
8. Is this score useful for campaign benchmarking?
Yes. Use the same scoring method across campaigns, periods, or competitors. Consistent inputs make trend analysis, performance benchmarking, and trust recovery planning much easier.