Strategize, Track, and Optimize to Build Valuable Long-Term Relationships
Core to this resource is our Google Sheet Tracking Template — included with the download that you can request by filling out the form to the right. This spreadsheet template provides an approach to systematically track the LinkedIn connection requests you send, analyzing their acceptance rates, and optimizing the language that you use in your messaging.
This guide provides a clear, step-by-step approach to building a long-term LinkedIn connection strategy. It is designed to help professionals systematically expand their network in a way that creates enduring value.
Importance of Long-Term Relationship Building
Building meaningful professional relationships takes time and intention. A well-curated LinkedIn network offers opportunities for knowledge sharing, career growth, and collaboration over the years. Strong relationships can be invaluable assets in your professional journey.
Not for Short-Term Gains
This strategy is not intended for immediate results, such as quick sales or rapid job searches. Instead, it focuses on cultivating connections that are mutually beneficial and can yield dividends in the future. Patience and consistency are key.
Table of Contents:
- Identifying Valuable Relationships for the Long Term
- Categorizing Affinity Groups
Step 2: Create Your Target List
- Developing a Filter for Your Target Profiles
- Tools and Methods for Building a List
- Organizing the List in a Google Sheet
Step 3: Write Connection Request Messages
- Crafting Personalized and Non-Salesy Messages
- Examples of Effective Connection Requests
- Testing and Iterating on Message Variations
Step 4: Send Connection Requests
- Starting Small and Gradually Increasing Volume
- Recommended Daily and Weekly Limits
- Best Practices for Timing Requests
Step 5: Track and Analyze Results
- Using a Connection Tracker in Google Sheets
- Monitoring Acceptance Rates by Group and Message Type
- Adjusting Strategy Based on Performance
Step 6: Maintain and Engage Connections
- Avoiding Immediate Asks Post-Acceptance
- Strategies for Starting Conversations (e.g., Questions, Events)
- Leveraging Consistency Bias for Ongoing Engagement
Step 7: Optimize Your LinkedIn Profile
- Enhancing Profile Appeal for Higher Acceptance Rates
- Tips on Headlines, Photos, and Banners
- Avoiding Off-Putting Elements
- Using Screening Criteria
- A/B Testing Messages for Better Results
- Handling LinkedIn Restrictions
- Tracking Conversations Beyond Initial Requests
- Transitioning from Google Sheets to a CRM System
Outsourcing Administrative Aspects of this Program
- Tasks to Delegate
- Ongoing Involvement
Orientation to the Sample Data in the Connection Request Tracking Sheet
- Key Tabs and Their Functions
- Sample Data Overview
- Preparing the Tracker for Your Data
- Tips for Effective Use
- Optimizing Your LinkedIn Profile
- Using a CRM System for Relationship Management
Step 1: Define Your Strategy
Identifying Valuable Relationships for the Long Term
Start by determining which professional relationships will be valuable to you over the long term. Think about your career goals and areas where relationships can provide opportunities, knowledge, or mutual support. Focus on connections that align with your long-term professional aspirations rather than short-term needs.
Categorizing Affinity Groups
Organize your target connections into meaningful categories based on shared affinities. Examples of categories include:
- Education: Alumni from your college, business school, or other academic programs.
- Firms: Current or former colleagues from organizations where you’ve worked.
- Titles: Professionals with similar roles or responsibilities (e.g., “Directors of Data Analytics”).
- Events: Participants in conferences or industry events you’ve attended or plan to attend.
By defining clear categories, you can tailor your outreach and track your progress effectively.
Step 2: Create Your Target List
Developing a Filter for Your Target Profiles
Start by defining the specific criteria for the people you want to connect with. Consider factors such as:
- Professional Affiliation: Alumni of your previous employers or industry-specific peers.
- Educational Background: Classmates from college, graduate school, or professional programs.
- Geographic Location: Professionals in your city or region.
- Job Titles: Individuals holding specific roles, such as Directors of Data Analytics.
- Event Participation: Attendees of conferences or industry events you’re involved with.
Tools and Methods for Building a List
Once your target profiles are clear, use these methods to build your list:
- Manual LinkedIn Search: Use LinkedIn’s filters to find potential connections.
- Conference Lists: Gather attendee rosters from events.
- Third-Party Tools: Platforms like ZoomInfo can help identify potential contacts.
- Outsourcing: Consider hiring someone to compile the list based on your specifications, especially for large-scale efforts.
Organizing the List in a Google Sheet
Create a Google Sheet to store and track your connection efforts. Use the following columns:
- Group Name: Label the affinity group (e.g., “HBS Class of 2012” or “Deloitte NYC Alumni”).
- Name: The contact’s full name.
- LinkedIn URL: Direct link to their profile.
- Additional Details (Optional): Job title, company, or location.
Structure the sheet for flexibility by using separate tabs for each group or including a column to designate groups within one master list. This organization ensures clarity as you scale your outreach efforts.
Step 3: Write Connection Request Messages
Crafting Personalized and Non-Salesy Messages
When sending connection requests, always include a custom note to make your message stand out. Avoid generic or sales-oriented language that might make recipients feel they’re being targeted for a pitch. Instead, focus on shared affinities or mutual interests to establish rapport.
Key principles for crafting messages:
- Be concise: Keep your note brief and to the point.
- Highlight commonality: Mention shared affiliations, such as school, work experience, or industry.
- Avoid pitches: Focus on the relationship, not immediate transactions.
Examples of Effective Connection Requests
Here are some examples based on different contexts:
- Alumni Connection:
“Hi [First Name], I’m also an alumnus of [University/Program] and thought it might be valuable for us to connect. Best regards, [Your Name].” - Professional Peer:
“Hi [First Name], I noticed we both work in [Industry/Function]. As a [Your Title], I’d love to connect and exchange insights. Best regards, [Your Name].” - Event-Based Connection:
“Hi [First Name], I saw you’re attending [Event Name]. I’m attending too, and it would be great to connect before the event.”
Testing and Iterating on Message Variations
To improve your acceptance rate, experiment with different message formats. Use a systematic approach:
- Write multiple versions of your message for each target group. Example: For Deloitte alumni, create “Deloitte-NYC-FinServ-1” and “Deloitte-NYC-FinServ-2” variations.
- Track performance by noting the acceptance rate for each variation in your connection tracker.
- Analyze results: If one version performs better, refine and use it. If not, test new approaches.
Step 4: Send Connection Requests
Starting Small and Gradually Increasing Volume
Begin your outreach by sending a few connection requests per day and increase the volume over several weeks. This gradual approach prevents LinkedIn from flagging your activity as unusual and helps you establish consistent behavior on the platform.
- Week 1: Start with 5 requests per day.
- Week 2: Increase to 10 requests per day.
- Subsequent Weeks: Gradually add 5 requests per day each week, up to a maximum of 200 per week if you’re a LinkedIn Premium user.
Recommended Daily and Weekly Limits
- Daily Limit: Avoid sending more than 40 connection requests per day, even at your peak volume.
- Weekly Limit: Keep your total to around 200 requests per week to stay within LinkedIn’s unofficial threshold.
- Built-in Buffer: Reserve 5–10 daily requests for ad-hoc connections (e.g., new clients or people you meet).
Best Practices for Timing Requests
The timing of your connection requests can influence their acceptance rate:
- Send During Work Hours: Most professionals are active on LinkedIn during their workday. Send requests aligned with their time zone to increase visibility.
- Avoid Off-Hours: Requests sent late at night or early in the morning may be overlooked or buried in the recipient’s queue.
- Adapt for Global Connections: For international outreach, consider the recipient’s local work hours to maximize engagement.
By following these best practices, you can optimize your connection-building efforts and maintain steady progress in growing your LinkedIn network.
Step 5: Track and Analyze Results
Using a Connection Tracker in Google Sheets
Maintain a structured Google Sheet to track your connection requests and their outcomes. We provide a Google Sheet Template you can copy to use in our guide that you can download.
Key columns to include:
- Group Name: The target affinity group (e.g., “HBS Class of 2012”).
- Name: Full name of the contact.
- LinkedIn URL: Direct link to the profile.
- Date Sent: The date you sent the connection request.
- Date Accepted: The date the request was accepted (if applicable).
Optionally, include columns for additional details, such as the text variation used and any notes about the recipient. This tracker serves as a central tool to monitor and manage your outreach.
Monitoring Acceptance Rates by Group and Message Type
Use your tracker to calculate the acceptance rate for each group and message variation. Set up a pivot table to generate insights, such as the acceptance rate by project ID or text variation.
- Overall Acceptance Rate: Total accepted requests ÷ total sent requests.
- Group-Level Analysis: Compare acceptance rates across target groups to identify which groups are most receptive.
- Message-Level Analysis: Track which message variations perform best by comparing their acceptance rates.
Adjusting Strategy Based on Performance
Regularly analyze your data and refine your approach:
- Low Acceptance Rates: If a group or message variation has an acceptance rate below 20%, pause and reassess.
- Test New Messages: Create new message variations and test them systematically.
- Refocus Targeting: If certain groups consistently underperform, shift focus to groups with stronger affinity.
- Optimize Profile: Ensure your LinkedIn profile is appealing to the people you’re targeting (e.g., professional photo, clear headline).
Step 6: Maintain and Engage Connections
Avoiding Immediate Asks Post-Acceptance
Once your connection request is accepted, resist the urge to immediately message the person with an ask, such as pitching your services or requesting a call. This can make the connection feel transactional and may alienate your new contact. Instead, let the connection settle for a few weeks to avoid coming across as overly aggressive or self-serving.
Strategies for Starting Conversations
Engaging your connections thoughtfully over time builds trust and lays the groundwork for a meaningful relationship. Use these approaches:
- Ask Simple Questions: Pose questions that require minimal effort to answer, such as:
- “Have you ever attended [specific event]? I’m considering going.”
- “What’s your favorite tool for [specific task]?”
- Leverage Shared Experiences: Reference commonalities like attending the same school or working in the same industry.
- Discuss Events: Mention events relevant to their professional interests and ask if they are attending or have attended in the past.
- Seek Advice: Request insights on topics they are knowledgeable about, such as “How have you approached [specific challenge]?”
The goal is to create a natural and low-pressure conversation that encourages them to respond.
Leveraging Consistency Bias for Ongoing Engagement
Once someone has engaged with you, they are more likely to continue interacting due to consistency bias. Build on this initial engagement by:
- Following up with relevant questions or comments.
- Sharing helpful resources, such as articles or tools, that align with their interests.
- Gradually transitioning to deeper conversations, such as discussing potential collaborations or professional opportunities.
By maintaining a steady, value-driven engagement, you can strengthen your professional relationships and position yourself as a trusted contact in their network.
Step 7: Optimize Your LinkedIn Profile
Enhancing Profile Appeal for Higher Acceptance Rates
Your LinkedIn profile is often the first impression potential connections have of you. Ensure it reflects professionalism and aligns with the audience you’re targeting. A polished profile significantly increases the likelihood of your connection requests being accepted.
Tips on Headlines, Photos, and Banners
- Headline: Write a clear and compelling headline that highlights your professional expertise or role. Avoid overly salesy language.
- Example: “Director of Data Analytics | Helping Organizations Leverage Insights for Growth”
- Photo: Use a high-quality, professional headshot. A friendly, approachable expression works best.
- Banner: Include a relevant and visually appealing banner that reflects your professional background, industry, or personal branding.
Avoiding Off-Putting Elements
- Overly Sales-Oriented Language: Avoid headlines or summaries that make you appear as though you are primarily seeking to sell something.
- Example to Avoid: “Helping Businesses Scale Through My Coaching Programs”
- Incomplete Profile: Fill out key sections, including experience, education, and skills, to show credibility.
- Outdated or Poor-Quality Images: Use modern and professional visuals for your profile photo and banner.
A well-optimized LinkedIn profile projects professionalism and trustworthiness, making it more likely that potential connections will accept your requests.
Additional Umbrex Resource: LinkedIn Best Practices to Optimize Your Profile
Advanced Tips
Using Screening Criteria (e.g., 500+ Connections)
Target individuals with more than 500 LinkedIn connections. This serves as a practical filter to identify active users who are more likely to respond.
- Why 500+?: Professionals with fewer connections may be less active on LinkedIn or more selective about who they connect with.
- Exceptions: If the individual is a client, someone you’ve met, or part of a niche group, you can still reach out regardless of their connection count.
A/B Testing Messages for Better Results
Improve your acceptance rate by systematically testing different message variations.
- Create Variations: Write multiple versions of your connection request for each target group.
- Test in Batches: Send out a minimum of 100 requests per variation to gather meaningful data.
- Analyze Results: Use your connection tracker to calculate the acceptance rate for each variation.
- Example: Variation A achieves a 24% acceptance rate, while Variation B achieves 18%. Focus on refining Variation A.
Handling LinkedIn Restrictions
Avoid triggering LinkedIn’s restrictions by adhering to best practices:
- Gradual Scaling: Build up your activity slowly, as outlined in Step 4, to avoid sudden spikes in behavior.
- Monitor Connection Requests: If LinkedIn starts asking for email addresses or blocks requests, reduce your daily volume and wait a few days before resuming.
- Respect Weekly Limits: Keep connection requests below 200 per week for Premium users to stay within LinkedIn’s guidelines.
- Optimize Acceptance Rate: Maintain an acceptance rate above 20%. If your rate is consistently low, reevaluate your targeting, message text, or LinkedIn profile.
By applying these advanced tips, you can refine your approach, maximize results, and avoid issues that might hinder your connection-building efforts.
Integrating with CRM Tools
Tracking Conversations Beyond Initial Requests
Once your connections are established, use a Customer Relationship Management (CRM) system to manage ongoing interactions effectively. A CRM can help you:
- Log Communication: Record details of messages, meetings, or notes from conversations.
- Set Follow-Up Reminders: Schedule reminders to re-engage with contacts after a certain period.
- Track Engagement: Monitor how relationships evolve over time, such as transitioning from an initial connection to a meaningful professional relationship.
Transitioning from Google Sheets to a CRM System
While a Google Sheet is ideal for tracking connection requests initially, a CRM system offers greater functionality as your network grows.
- Choose the Right CRM: Select a tool that aligns with your needs, such as Salesforce, HubSpot, or Zoho. Many have free tiers suitable for individual users.
- Import Your Data: Export your Google Sheet and import it into the CRM. Ensure columns like name, LinkedIn URL, and group affiliation are mapped correctly.
- Customize Fields: Add custom fields in the CRM to track group names, affinity details, and any notes from your connection tracker.
- Automate Processes: Use CRM features like automated follow-up reminders and email templates to streamline engagement.
By integrating a CRM system, you can move beyond initial connections and systematically nurture relationships, ensuring that your efforts yield long-term professional value.
Additional Umbrex Resource: Guide to CRM Software for Consultants
Outsourcing the Administrative Aspect of this Program
You should personally define the parameters for your connection strategy, determining the groups or profiles of individuals you want to connect with. This includes identifying target affinity groups and writing the text of your connection requests. Beyond this strategic oversight, much of the administrative work involved in this program can be outsourced to an assistant.
Tasks to Delegate
- List-Building: Sourcing names and LinkedIn URLs requires significant upfront effort.
- How to Delegate: Provide clear search parameters and outsource the research to a third party. You can hire a lead generation assistant via platforms like Upwork or request support from Umbrex.
- Does Not Require LinkedIn Access: This task can be completed without granting access to your LinkedIn account.
- Daily Connection Requests: Sending connection requests and tracking their acceptance requires about 30 minutes per day.
- How to Delegate: Assign the task of sending 40 requests per day and updating the connection tracker to an assistant with access to your LinkedIn account.
- Access Considerations: Carefully vet anyone with access to your LinkedIn account to ensure security and confidentiality.
Ongoing Involvement
While much of the day-to-day execution can be outsourced, your involvement is still essential:
- Strategy and Planning: Develop the LinkedIn connection request strategy, including target groups and message variations.
- Regular Analysis: Review the tracker and pivot table weekly to evaluate performance and identify necessary adjustments.
- Monitoring Acceptance Rates: Instruct your assistant to monitor the acceptance rates daily. If the acceptance rate falls below 20%, they should pause outreach and notify you for a review.
By delegating the operational aspects of this program, you can focus on the strategic elements while ensuring that the process is efficiently managed.
Additional Umbrex Resource: How to Hire a Virtual Assistant
Orientation to the Sample Data in the Connection Request Tracking Sheet
The LinkedIn Connection Request Tracker is a Google Sheet template designed to help you systematically manage and analyze your connection-building efforts. We provide a this template in our guide that you can download.
Below is a summary of its structure and how to use it effectively.
Key Tabs and Their Functions:
Planner Tab
- Purpose: Helps you plan daily connection requests by project.
- Structure:
- Column A: Day/Date.
- Column B: Day of the week (calculated).
- Columns C–F: Project names with planned connection requests per day.
- Usage: Useful for scheduling outreach, especially if delegating tasks to an assistant.
Planner tab: Used to plan out how many connection requests for each project, per day, in advance.
List of Names Tab
- Purpose: Primary working tab to record and track connection requests.
- Structure:
- Column A: Name of the person (optional, but helpful).
- Column B: LinkedIn URL (required).
- Column C: Project ID (e.g., “Biology,” “Chemistry”).
- Column D: Text variation used for the request.
- Column E: Date the connection request was sent.
- Column F: Date the request was accepted (if applicable).
- Column G: Acceptance status (calculated field: “Accepted” or “Not Accepted”)
- Usage:
- Populate names, LinkedIn URLs, and relevant project IDs.
- Enter the date sent in column E and update column F when requests are accepted.
- Avoid editing formulas in column G.
List of Names tab: This tab keeps detailed tracking on each name, LinkedIn URL, date the CR was sent and whether it was accepted.
Analysis Tab
- Purpose: Provides insights into the effectiveness of your outreach using a pivot table.
- Structure:
- Displays acceptance rates by project and text variation.
- Highlights overall acceptance rates for all requests.
- Usage:
- View metrics like acceptance rate per text variation and project.
- Use insights to refine message content and targeting strategy.
Text Used Tab
Tracks the specific language used for each connection request. It has been pre-populated with a few templates.
Text Used tab: Tracks the specific language used for each connection request.
Sample Data Overview
The sample data includes two projects, “Biology” and “Chemistry,” with 90 total rows of connection requests.
- Biology Project:
- Two text variations (“Biology-1” and “Biology-2”).
- Acceptance rates: 15% for “Biology-1” and 22.58% for “Biology-2.”
- Chemistry Project:
- One text variation (“Chemistry-1”).
- Acceptance rate: 23.8%.
- Overall Acceptance Rate: 19.75%.
Preparing the Tracker for Your Data
- Delete sample data in columns A–F from row 2 onward.
- Retain formulas in column G.
- Alternatively, append your data below the sample data and adjust filters in the pivot table to include your projects.
Tips for Effective Use
- Update the List of Names tab daily to track new connections.
- Regularly review the Analysis Tab to identify trends and improve your outreach strategy.
- Customize the pivot table filters as you add more projects.
This structured approach ensures you can manage your connection requests efficiently and measure results systematically.
Additional Resources
Optimizing Your LinkedIn Profile
For detailed guidance on creating a professional and appealing LinkedIn profile, refer to our LinkedIn Profile Optimization Guide. This resource covers:
- Crafting an effective headline.
- Selecting the right profile photo and banner.
- Enhancing your profile summary and experience sections to attract your target audience.
Using a CRM System for Relationship Management
To learn more about transitioning from spreadsheets to a CRM system, explore our CRM Implementation and Usage Guide. This resource includes:
- How to select the right CRM tool for your needs.
- Steps to import and organize your LinkedIn connections.
- Best practices for tracking and managing ongoing professional relationships.
These resources provide additional tools and techniques to complement the strategies outlined in this guide, ensuring your long-term networking efforts are both effective and sustainable.