aoTheComputer Twitter Analysis
Jose Pena
2025-04-29
Summary Table
| total_tweets | avg_likes | avg_comments | avg_impressions | avg_engagement |
|---|---|---|---|---|
| 461 | 3028.2 | 81.4 | 310141.9 | 347 |
Top Keywords (March 2025)
TF-IDF by Post Type (March 2025)
Time-Based Analysis (March 2025)
Engagement Analysis
Likes Analysis
Impressions Analysis
TF-IDF by Week (Optional)
TF-IDF by Month (March vs. April)
# Average Engagement by Day and Hour (Log Scale)
## [1] "C"
# Top 10 Best Times to Post – Engagement Rate
| day | hour | mean_engagement |
|---|---|---|
| Thursday | 12 | 20015.51 |
| Friday | 8 | 5000.08 |
| Thursday | 19 | 575.71 |
| Friday | 14 | 251.22 |
| Friday | 18 | 81.21 |
| Thursday | 10 | 7.03 |
| Monday | 13 | 5.20 |
| Friday | 11 | 4.93 |
| Sunday | 10 | 4.57 |
| Thursday | 8 | 4.38 |
Engagement by Hour and Post Type
Top 10 Words Most Positively Correlated with Engagement Rate
# Top 10 Words Most Negatively Correlated with Engagement Rate
Top 10 Bigrams Most Positively Correlated with Engagement
Top 10 Bigrams Most Negatively Correlated with Engagement
Top Hashtags by Engagement Rate
Engagement Rate Distribution by Post Type
# Top 30 Words Most Positively Correlated with Each Other
| word_a | word_b | correlation |
|---|---|---|
| episode | office | 0.96 |
| hour | office | 0.84 |
| episode | hour | 0.80 |
| comments | episode | 0.78 |
| episode | reminder | 0.78 |
| episode | guest | 0.75 |
| comments | office | 0.74 |
| office | reminder | 0.74 |
| guest | office | 0.71 |
| contracts | smart | 0.71 |
| guest | space | 0.71 |
| guest | reminder | 0.71 |
| cluster | free | 0.70 |
| comments | questions | 0.70 |
| focus | running | 0.70 |
| index | pi | 0.68 |
| beta | private | 0.68 |
| endowment | storage | 0.68 |
| fair | launch | 0.67 |
| index | permaweb | 0.66 |
Top Correlated Words with Key Blockchain Terms
# Top 20 Distinctive Keywords by Engagement Tier
Sentiment Analysis
Emotion Analysis
Comments Analysis