LinkedIn Ads

LinkedIn Ads exposes one statistics report and three metadata snapshots. The statistics report carries daily figures for every ad: impressions, clicks, cost, leads, conversions, engagement, video, and carousel metrics. The metadata reports return the current attributes of ads, campaigns, and the connected ad account.

Renta exports any of the four to your data warehouse. A pre-built template loads the statistics and metadata tables together.

Authentication

Renta uses OAuth to authenticate with LinkedIn. You will be redirected to LinkedIn to grant Renta limited access to your LinkedIn Ads account.

Connect LinkedIn Ads source

Follow these steps to add LinkedIn Ads as a source in Renta using OAuth authentication.

Go to the CatalogStep 1

1. Navigate to the Connections > Catalog section in the left sidebar.
2. Open the Advertising category and click the LinkedIn Ads card.

Authorize connectionStep 2

Click Log in to your LinkedIn Ads account. You will be redirected to LinkedIn to sign in and confirm the permissions Renta requests. If the browser already holds an authorized LinkedIn session, the confirmation resolves right away and you return to Renta.

Name the connection and saveStep 3

Finish the setup:

1. Source name.
   Specify a name for this data source. This is used exclusively in the Renta interface.
2. Access granted.
   Verify that the account is connected successfully. The connected account carries the name of your LinkedIn profile.

Click Save to finish.

If your LinkedIn authorization later changes (for example, after a password change), click Re-authorize on this source. The connection refreshes in place and every pipeline built on it keeps running.

Source createdStep 4

The new source appears in the Sources list with the Active status. You can now use it in pipelines.

Create a pipeline

Once the source is connected, create a pipeline to sync your LinkedIn Ads data into your destination.

Create a LinkedIn Ads pipeline

Link your LinkedIn Ads source to a destination and configure the pipeline.

Select LinkedIn Ads as the sourceStep 1

In the left sidebar, click New pipeline. On the Source step, select LinkedIn Ads under Already connected and click Next step.

Select your LinkedIn Ads connectionStep 2

Choose the LinkedIn Ads connection you created earlier and click Next step.

Select a destinationStep 3

On the Destination step, select your destination (for example, Google BigQuery) and click Next step.

Select the destination connectionStep 4

Choose the destination connection you want to load data into and click Next step.

Pipeline configuration

On the final step, choose which LinkedIn Ads data to export and how Renta loads it.

Integration type

Choose how to configure the pipeline: assemble the report yourself or start from a template.

Renta offers one template, LinkedIn Ads Performance report. It creates three pipelines at once: a daily Ad statistics report with date, Creative ID, and 19 cost, conversion, and engagement metrics, plus Campaign metadata report and Ad metadata report snapshots.

The statistics pipeline is created with the overwrite period set to Last 7 days. The destination tables get the la_ prefix.

Report configuration

Pick the ad account and the report type. The report type defines the set of fields available in the Parameters picker.

1. Ad accounts The dropdown lists every ad account available to the authorized LinkedIn profile. The Viewer role on the account is enough for exporting statistics. A pipeline exports data for one account. To load several accounts, create a pipeline for each.

2. Report Types Select the type of report to export.

   Report type	Description
   Ad statistics report	Daily performance statistics for each ad: impressions, clicks, cost, conversions, leads, engagement, video, carousel, and document metrics.
   Ad metadata report	Current attributes of each ad: name, campaign and account identifiers, review status, serving status, creation and modification dates.
   Campaign metadata report	Current attributes of each campaign: name, status, objective, format, cost type, budget, schedule, and feature flags.
   Account metadata report	Current attributes of the connected ad account: name, identifier, type, status, and currency.

The Ad statistics report is always grouped by ad and day. To get campaign or account totals, aggregate the exported rows in the warehouse and join the metadata reports by the campaign and account identifiers.

Parameters

Select the fields to include in the destination table. Your dataset schema is defined by the parameters you choose here.

Every row in the picker shows the field name with the destination column name below it: actionClicks becomes the action_clicks column.

Check the fields to export, use the search to find a field by name, and review the choice on the Selected tab. The Selected Parameters list below the picker lets you remove a field.

The Ad statistics report carries cost in two fields: cost_in_local_currency (the currency of the ad account) and cost_in_usd.

Identifiers such as Creative ID and Campaign ID are exported as plain numbers, so the statistics table joins the metadata tables directly.

Table name

Name the pipeline and the destination table.

1. Integration name.
   The name of the pipeline. It is used exclusively in the Renta interface.
2. Table name.
   The destination table name. You can keep the auto-generated name or enter your own.

Date range

Set the historical period to load. By default, Date start is the first day of the current month and Date end is Today.

1. Date start.
   The first date of the extraction period.
2. Date end.
   The last date of the extraction period. You can pick a fixed date or a relative option such as Today.

Overwrite period

The overwrite period defines how many recent days Renta reloads on every run. The setting appears once the date parameter is selected.

On each run, Renta re-fetches the data starting from the date of the last successful run minus the overwrite period. The affected days are deleted from the destination table and inserted again, while older data stays untouched.

The options range from Without overwrite data to Overwrite all data. The default is Last 3 days.

Schedule

Choose how often the pipeline runs.

For Daily schedules, set the Update time, the exact time each run starts, then click Create pipeline.

The new pipeline appears in the Pipelines section under the ETL tab, where you can track its runs, progress, and the destination table name.

Limitations

The LinkedIn reporting API sets boundaries that apply to every pipeline built on this source.

Sync strategy

The synchronization strategy depends on the report type and on whether the report includes the date parameter.