How to Sync LinkedIn Ads to BigQuery and Google Sheets

Manually exporting LinkedIn Ads data can be tedious and error-prone for marketers. Fortunately, SyncRange automates this process by connecting your LinkedIn Ads to Google Sheets or BigQuery. With SyncRange, your ad metrics will automatically sync into Google, providing fresh data for reporting without requiring any manual work.

This guide shows how you can set up the connections and create an export so that your LinkedIn campaigns, performance, and audience data are delivered to your Google destination on a schedule.

Connect Your LinkedIn and Google Accounts

First, authorize SyncRange to access your LinkedIn Ads account and your Google account. In SyncRange, go to Connections → LinkedIn and click Connect LinkedIn Ads Account. You’ll be redirected to LinkedIn to log in and grant permission. After authorizing, select the LinkedIn advertising account you want to sync. You must have admin access to your LinkedIn Campaign Manager account for this to work.Next, connect your Google account in SyncRange under Connections → Google. This gives SyncRange permission to create spreadsheets and write data to BigQuery on your behalf. If you plan to use Google Sheets, choose the Google account that owns the spreadsheets you’ll use. If using BigQuery, choose the Google account with access to your Google Cloud project. SyncRange makes this setup easy – it connects in just a few clicks with no coding or API keys needed.

Exporting LinkedIn Ads Data

With accounts connected, you can begin setting up your destinations:

• Google Sheets: In SyncRange, go to Google Integrations → Google Sheets and click Add Sheet. You can create a new spreadsheet or select an existing one. Choose the destination spreadsheet and worksheet where your data will be stored. Keep in mind Google Sheets has a size limit (10 million cells), so this is best for moderate-sized exports.
• Google BigQuery: In Google Integrations → BigQuery, click Add BigQuery Destination. Choose your Google Cloud project and select or create a BigQuery dataset to hold your LinkedIn Ads data. BigQuery is ideal for large or complex data sets and lets you easily query or combine LinkedIn data at scale.

Once your Sheet or BigQuery destination is added, go to the Export Builder in SyncRange and click Create New Export. Give the export a name (for example, “LinkedIn Ads to Google”), then select LinkedIn as the data source. Choose your connected LinkedIn Ads account. For the destination, pick the spreadsheet or BigQuery dataset you just added.On the configuration page, you’ll see multiple data tabs for LinkedIn, such as Campaigns, Creatives, Audience, Conversions, etc. Each tab corresponds to a type of LinkedIn Ads data. Enable the tabs you want to export. For each tab, you can select which specific columns (metrics and dimensions) to include. For example, in a Campaigns tab you might choose columns like Campaign Name, Impressions, Clicks, Spend, and Conversions.Decide how much data to fetch by setting the Date Range and choose whether to Append or Replace data on each run. The default is to replace data, but if you want to build up a historical dataset over time, select Append. (Appending adds new rows on each run, while replacing overwrites with fresh data.) For ongoing reporting, append is usually best so you accumulate all past performance in one place.Save the export when you’re done. SyncRange will now run the export on the schedule you set (for example, daily or weekly). Each run will pull the latest LinkedIn Ads metrics and either append them to your Google Sheet or load them into your BigQuery tables. By automating this sync, you avoid manual CSV downloads and keep your data up-to-date effortlessly.

BigQuery vs Google Sheets

SyncRange supports both Google Sheets and BigQuery as destinations. Use Google Sheets if you have a relatively small dataset or need a quick spreadsheet report. It’s great for simple analysis and sharing but has a limit of 10 million cells per spreadsheet. Use BigQuery when you have large or complex data volumes and need powerful querying or BI integrations. BigQuery can handle millions of rows and integrates with tools like Looker Studio. In general, for large-scale LinkedIn Ads reporting, BigQuery is recommended, whereas Sheets works for smaller, quick-start exports.

Benefits of Syncing with SyncRange

By using SyncRange to automate LinkedIn Ads exports, you save hours of manual work. There’s no need to log into Campaign Manager and copy data into spreadsheets. SyncRange runs in the background, making the API calls and keeping your Google data sources current. This means your LinkedIn Ads data is always fresh for reporting and analysis. SyncRange is a no-code solution so you can set up LinkedIn exports in just a few minutes without any technical skills. Plus, SyncRange offers a free plan so you can start automating your data immediately.