LinkedIn Ads + Orcabase

What a LinkedIn lead really costs you.

Sync LinkedIn Ads through Fivetran and ask what each lead costs, who sees your ads, and which campaigns turn into deals, in plain words and next to your CRM.

  • Synced by Fivetran
  • Syncs every 6 hours
  • No Fivetran account needed
AgentLinkedIn Ads connected

What does a wholesale lead from LinkedIn cost us?

Reading your LinkedIn Ads data…

Wholesale leads from LinkedIn cost $86 each in August, and one in five became a deal.

  • Office managers respond best: $61 a lead.
  • The coffee-for-the-office carousel brought 58% of leads.
  • Each won deal cost about $430 in ads.

Cost per lead by month, $

MarAprMayJunJul86Aug
How I got this· 4 steps
  1. Looked at your LinkedIn campaigns and leads
  2. Divided spend by leads each month
  3. Matched leads to deals in your CRM
  4. Split cost per lead by job function

Example answer. Numbers are illustrative.

In plain words

How do I know if LinkedIn Ads are worth it?

LinkedIn tells you what a click or a lead cost. Whether it was worth it depends on what happened next, in your CRM. Orcabase syncs your LinkedIn campaigns through Fivetran into a database Orcabase hosts for you, next to your deals.

Ask “what did a won deal from LinkedIn cost us?” and get the answer, the chart and the steps behind it.

Ask in plain words

What you can ask about your LinkedIn Ads data

The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.

  • What does a lead from LinkedIn cost us?

  • Which campaigns bring leads that turn into deals?

  • Which job functions and industries respond to our ads?

  • How did cost per click change this quarter?

  • Which ads get the most clicks for the money?

  • How many leads did we get each week?

  • Which campaigns should we pause?

  • Show me spend, leads and deals by month.

What comes in

Your LinkedIn Ads data, ready to ask about.

A copy in a database Orcabase hosts for you, with its own folder for each app.

01

Campaigns and creatives

Campaign groups, campaigns, ads and their settings.
02

Spend and clicks

Daily spend, impressions, clicks and engagement.
03

Leads and conversions

Leads from LinkedIn’s forms and the conversions it recorded.
04

Who saw them

Results by job function, seniority, industry and company size, where LinkedIn reports them.

Numbers worth defining

Define them once. Every answer agrees.

Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your LinkedIn Ads data.

How metrics work

  • Cost per lead

    Ad spend divided by leads.

  • Lead-to-deal rate

    Share of LinkedIn leads that became deals in your CRM.

  • Cost per won deal

    Ad spend divided by the won deals it led to.

  • Click-through rate

    Clicks divided by impressions.

Dashboards to start with

Your LinkedIn Ads numbers at a glance.

Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.

LinkedIn Ads

4 charts
  • Spend by campaign
  • Cost per lead
  • Leads by week
  • Click-through rate

Pipeline

3 charts
  • Leads to deals
  • Cost per won deal
  • Deals by job function

About dashboards

Better together

Ask across LinkedIn Ads and the rest of your business.

The best questions need more than one app. The agent can pull from several sources for one answer.

How to connect

Connect LinkedIn Ads, step by step.

  1. 1

    Find it in Sync data

    In Orcabase, go to Sync data → Add source and search for LinkedIn Ads. Pick the database to sync into.

  2. 2

    Connect LinkedIn Ads on Fivetran’s page

    Fivetran’s page asks you to sign in to LinkedIn Ads, or for an API key. Your login goes to Fivetran, never to Orcabase.

  3. 3

    Choose what to sync

    Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.

  4. 4

    Ask away

    The first sync starts straight away. When it’s done, ask the agent about your LinkedIn Ads data.

What you’ll need

  • A LinkedIn login with access to your ad accounts in Campaign Manager.
  • The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
At a glance
How it connects
Synced by Fivetran
How fresh
Every 6 hours, as standard.
Where your data lives
A copy in a database Orcabase hosts for you, with its own folder for each app.
Who can set it up
An admin in your organization.
Your login
You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
Cost
Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.
Sync apps with FivetranStep-by-step, in the docs.

Questions

About LinkedIn Ads and Orcabase

More in the docs: Sync apps with Fivetran

Does it include our company page’s posts?
No, just your ad accounts. Organic company page posts are separate in LinkedIn.
Can Orcabase match LinkedIn leads to deals?
Yes, when your CRM is connected and records where each lead came from. The agent can then match leads to deals and work out what a won deal cost.
Do I need a Fivetran account?
No. Orcabase uses its own. You sign in to LinkedIn Ads on Fivetran’s page, and the data lands in a database Orcabase hosts for you, so there’s nothing else to set up or pay Fivetran for.
How fresh is my LinkedIn Ads data in Orcabase?
Fivetran syncs it every 6 hours as standard, and an admin can run a sync by hand at any time. The page for each source shows when it last synced and when it syncs next.
What does syncing cost?
Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard. Each distinct row that’s added or changed in a month counts once, however often it changes, and the first full copy is free. You choose which tables sync, so you only spend the allowance on what you need.

Your LinkedIn Ads data already has the answers.

Connect it, ask your first question, and pin the answers you want to see every week.