The above shows three important kinds of interaction at locations during an investigation: collecting testimony, collecting other evidence, and exchanging information within the group. For the rest of the adventure, each player can use only information their character knows, making communication and information sharing between players important here. Many people say noticing individual pieces of evidence is as important as social interaction in an investigative adventure. They account neither for sharing information among player characters, which also draws on their social skills, nor for the many social skills and abilities involved in establishing motive, profiling, and related investigative steps.
An interesting case is one of Call of Cthulhu's most important skills, Library Use, which we use in many investigative adventures. Searching even an enormous library may take only a few seconds of playing time, while the conversations and requests for favors leading to the roll may require much longer interaction. Most important is interaction built on information sharing among PCs, followed by questioning witnesses and then calling in favors. On that basis, I feel a predominance of social activity is a justified consideration. Naturally, you will roll for other things too.
Here I must draw attention to a problem discussed a thousand times. When considering game balance, we can identify which skill helped solve the adventure. But being the star for a ten-second skill test does not necessarily equal receiving the spotlight in many longer scenes. That is why I often say that when a slower combat system produces relatively long combat scenes in which someone can become a star through tactics, we gradually reach a point where everyone wants a larger, preferably equal, share of the spotlight precisely there, while combat gradually pushes other areas into the background. Fortunately, Call of Cthulhu did not take that path, but running an investigative adventure in Pathfinder, for example, would be harder.
In Call of Cthulhu, many rulebooks call the player characters investigators, influencing which skills receive greater emphasis during play. In an investigative adventure set in a fantasy world, the emphasis could readily shift.
Whenever a player character discusses information they personally discovered, it is worth noting that they shared it with the others, allowing the other PCs to discover further information and ask questions based on it. You therefore need to take notes during play as GM, but must also allow and indeed encourage your players to do so.
As the above shows, questioning witnesses and comparing testimony with evidence often matter most. Forget the stereotype that social situations involve only social expertise. Keep a copy of every player's character sheet and do not tell them what a roll is for or exactly when you will use it. Asking for “everyone's next test, whatever it is and whenever it happens” prevents the roll from giving information away. A combat skill or scientific skill, for example, may be what lets a particular PC spot a lie.
Characters' differing aptitudes can appear in this way too, and if it matters to your group you can still seek relative balance. Often the relevant test belongs not to the person asking but to someone hearing the answer who has a chance to recognize the NPC's mistake, lie, or prejudice. Such recognition can let the group acquire much information and react to it earlier, with fewer return visits and less time taken from NPCs. These rolls also work when a PC is speaking and the others can supplement or question what was said on the basis of their own skills.
During the group's information exchange, additions beginning “You didn't notice at the time, but now that ... mentions it, you remember...” can expand earlier descriptions, making interaction between characters a useful information source too. This may require some rolls. If players become accustomed to gaining new information and rewards by playing out information sharing, with later effects on character advancement too, and that extra information often helps them survive an adventure, they learn it is better than metagaming information known only by another character into their own play. That generally improves their roleplaying.