LinkedIn Pages & Google Sheets: how to integrate your data

Welcome to our step-by-step guide aimed at helping marketers harness the power of LinkedIn Page metrics by connecting them with Google Sheets via Catchr. By the end of this tutorial, you'll have a comprehensive understanding of how to seamlessly integrate LinkedIn Page data into Google Sheets for enhanced marketing analytics and decision-making capabilities.

How to connect your LinkedIn Pages account to Google Sheets

Add a source on Catchr

To begin, navigate to the Catchr homepage and locate the Source option in the left-side menu. Once there, click on Add a Source located at the top right corner of your screen. Choose LinkedIn Pages as your platform and proceed with the authentication steps to link Catchr with LinkedIn Pages.

Create a New Query

Launch Google Sheets and access the Catchr feature from the menu bar. Click on New Query to initiate the process of importing your LinkedIn Pages data.

Select Your Data Source

In the query creator, you'll have the option to select LinkedIn Pages as your data source. If it isn't already listed, you can easily add it by selecting the "+" icon.

Select Your Account(s)

Move to the Select account(s) section and pick the LinkedIn Pages account(s) whose data you wish to analyze.

Choose Metrics and Dimensions

Continue to the Metrics and Dimensions section to select the specific data points you are interested in. Below are examples of metrics and dimensions you might find valuable:

Metrics:

• Page Views: The total times your LinkedIn page was viewed.
• Unique Page Views: How many unique users visited your LinkedIn page.
• Total Follower Gain: Net increase in followers over a specified period.

Dimensions:

• Country: Visitor's country of origin.
• Device Type: Device used for accessing your page (e.g., desktop, mobile).
• Follower Industry: Industry classification of your followers.

Always select metrics and dimensions that align with your analytics and reporting goals.

Set Date Range

After choosing your metrics and dimensions, proceed to the Date Range option. Here, you can pick from predefined date ranges like "Last month" or set custom start and end dates for your analysis.

Apply Filters

To refine your data, utilize filters in the Filters tab. For example:

• Field: Country
• Operator: Equals
• Value: United States

This filter setup will ensure that only data for visitors from the United States is included in your query.

Schedule & Customize Data Refreshness

Lastly, utilize the Options tab to schedule your data to refresh automatically. Additionally, you can enable features such as "Append rows" to add new data at the end of your selected range, or "Combine rows" for comprehensive updates.

This concludes the basic steps required to connect your LinkedIn Pages data to Google Sheets using Catchr. With this connection, you're now equipped to automate data extraction and enhance your analysis efficiency.

Example of Google Sheets you can create to use with LinkedIn Pages source

With LinkedIn Pages data at your fingertips in Google Sheets, the possibilities for advanced analytics and informed decision-making are virtually limitless. Here are some examples of practical Google Sheets you can create:

• Content Performance Dashboard: By importing metrics like Post Engagement, Post Impressions Count, and Post Clicks, you can craft a detailed overview of how your content resonates with your audience.
• Follower Growth Analysis: Utilize metrics such as Total Follower Gain, Organic Follower Gain, and Paid Follower Gain alongside dimensions like Time (e.g., Month, Quarter) to track and visualize your follower growth trends over time.
• Recruitment Insights: For companies using LinkedIn Pages as part of their recruiting efforts, metrics on Careers Page Views and specific actions (e.g., Careers Page Jobs Clicks) can be invaluable in understanding potential candidate engagement.
• Industry Benchmarking: By comparing your page's performance metrics against those of similar organizations in your industry, you can identify areas for improvement and craft strategies to enhance your page's impact.

Each of these examples leverages specific metrics and dimensions tailored to a particular aspect of LinkedIn Pages management and analytics. By integrating LinkedIn data with Google Sheets, marketing professionals can streamline processes, uncover insightful trends, and make data-driven decisions to boost their organization's online presence.

‍