Connect pipeline health and LinkedIn engagement to decide your next prospecting move

Summary

As a sales leader, it’s difficult to recommend clear next steps when pipeline performance appears steady. Looking back four months at deal creation and total pipeline value shows trends hovering at similar levels, with no meaningful upward movement. When performance is flat, leadership conversations shift from reporting results to justifying what should change – and without broader context, decisions often default to more cold outreach.

This example connects pipeline trends with LinkedIn engagement data – total likes, total comments, and daily activity patterns – to evaluate whether there is untapped opportunity within an already active audience. By analyzing both revenue signals and ecosystem activity together, the leader can confidently propose supplementing cold prospecting with outreach to people already interacting with the brand, organizing team effort around real engagement signals instead of assumptions.

Prompt

Look into HubSpot CRM data for these months: [Insert Months]

For each month, return:

Pipeline value (total deal amount for deals created in that month)

Number of deals created in that month

Compare the months and report the month-over-month differences for both metrics, and clearly state which months are trending upward vs downward.

Then look into the LinkedIn Company Page data source for the same months [Insert Months]

For each month, return:

Total likes on posts published in that month

Total comments on posts published in that month

Compare the months and report the month-over-month differences for likes and comments, and clearly state which months are trending upward vs downward.

Finally, build a dashboard with:

Bar chart 1: monthly HubSpot pipeline value [Insert Months]

Bar chart 2: monthly HubSpot deals created [Insert Months]

Bar chart 3: monthly LinkedIn total likes [Insert Months]

Bar chart 4: monthly LinkedIn total comments [Insert Months]

Use the months in chronological order and label each chart clearly. Set the bar-chart to show weekly changes, not daily.

Andrej’s tips and best practices

“When performance is flat, that’s your signal to supplement.” 

If pipeline volume and value are hovering at the same level month after month, growth won’t happen by repeating the same activities. Flat trends are not neutral – they’re a cue to test a complementary motion.

“Validate new ideas against multiple signals.”

Before expanding prospecting, compare core revenue metrics with audience engagement. If engagement is strong but pipeline is stagnant, the issue may not be awareness – it may be activation.

“Organize your team’s time around daily activity patterns”

Monthly trends show direction. Daily engagement reveals timing. When you understand when comments and interactions spike, you can align outreach to moments when prospects are already active.

“Always be ready to answer: What are the next steps?

Analysis should lead to action. Leaders should be able to explain not only what is happening, but what will change because of it.