Even still after checking this out, I'm not convinced of the value that these specific analytics would give me... the metrics themselves are quite top level and not sure they'd provide much in terms of learnings
@shashwatpradhan Nope. If you took look at the link… :)
"*chat.db, where a user's messages are stored, can be found in 2 ways:
Where Messages.app (Apple's official Messages.app - iMessage for Mac) stores its data
Where the iPhone's chat.db database is stored after a backup to the computer"
See how often people message you, your word frequencies, and overall messages and words sent! Works with the iMessage database on your computer or from your phone.
Graphs and charts
Line graph of messages with that person since your first message
---Allows for zooming in on specific date ranges
---Data can be changed to show messages with that person compared to all other messages sent during that time period
---Your sent vs received messages with that person over time
---Your sent vs received words with that person over time
Pie Chart
---Sent messages vs received messages with person
---Sent words vs received words with that person
---Total messages with person vs all other messages in inbox
Bar Chart
---Sent vs received messages per hour of day --> When y'all talk the most
---Sent vs received words per hour of day --> When y'all talk the most
---Percentage of total messages with person per hour of day vs percentage of all other messages with other people per hour of day --> When y'all talk the most in comparison to when you mainly talk to everyone else
Makerpad
iMessage Analyzer
Instant - Website Time Tracker
Bee