LinkedIn Ads
LinkedIn Ads отдаёт один отчёт со статистикой и три снимка метаданных. Отчёт со статистикой содержит дневные показатели каждого объявления: показы, клики, расход, лиды, конверсии, вовлечённость, видео- и карусельные метрики. Отчёты с метаданными возвращают текущие атрибуты объявлений, кампаний и подключённого рекламного аккаунта.
Renta выгружает любой из четырёх в хранилище данных. Готовый шаблон загружает таблицы статистики и метаданных вместе.
Аутентификация
Renta использует OAuth для аутентификации в LinkedIn. Вы будете перенаправлены в LinkedIn, чтобы предоставить Renta ограниченный доступ к аккаунту LinkedIn Ads.
Подключение источника LinkedIn Ads
Перейдите в каталогStep 1
- Откройте раздел Connections > Catalog в левом меню.
- Откройте категорию Advertising и нажмите карточку LinkedIn Ads.
Авторизуйте подключениеStep 2
Нажмите Log in to your LinkedIn Ads account. Вы будете перенаправлены в LinkedIn, чтобы войти и подтвердить права, которые запрашивает Renta. Если в браузере уже есть авторизованная сессия LinkedIn, подтверждение проходит сразу, и вы возвращаетесь в Renta.
Назовите подключение и сохранитеStep 3
Завершите настройку:
- Source name.
Укажите имя источника данных. Оно используется то лько в интерфейсе Renta. - Access granted.
Убедитесь, что аккаунт подключён успешно. Подключённый аккаунт носит имя вашего профиля LinkedIn.
Нажмите Save, чтобы завершить.
Источник созданStep 4
Новый источник появится в списке Sources со статусом Active. Теперь его можно использовать в пайплайнах.
Создание пайплайна LinkedIn Ads
Выберите LinkedIn Ads как источникStep 1
В левом меню нажмите New pipeline. На шаге Source выберите LinkedIn Ads в разделе Already connected и нажмите Next step.
Выберите подключение LinkedIn AdsStep 2
Выберите созданное ранее подключение LinkedIn Ads и нажмите Next step.
Выберите назначениеStep 3
На шаге Destination выберите назначение (например, Google BigQuery) и нажмите Next step.
Выберите подключение назначенияStep 4
Выберите подключение назначения, в которое хотите загружать данные, и нажмите Next step.
Настройка пайплайна
На последнем шаге выберите, какие данные LinkedIn Ads выгружать и как Renta будет их загружать.
Тип интеграции
Выберите способ настройки пайплайна: собрать отчёт самостоятельно или начать с шаблона.
| Тип интеграции | Описание |
|---|---|
| Custom report | Вы сами выби раете тип отчёта, поля и настройки загрузки. Дальше в статье описан именно этот путь. |
| Pre-built templates | Предопределённый набор пайплайнов с фиксированным набором полей. Вы выбираете только рекламный аккаунт и шаблон. |
Renta предлагает один шаблон: LinkedIn Ads Performance report. Он создаёт сразу три пайплайна: дневной Ad statistics report с полями date, Creative ID и 19 метриками расходов, конверсий и вовлечённости, а также снимки Campaign metadata report и Ad metadata report.
Пайплайн статистики создаётся с периодом перезаписи Last 7 days. Таблицы в назначении получают префикс la_.
Настройка отчёта
Выберите рекламный аккаунт и тип отчёта. Тип отчёта определяет набор полей, доступных в списке Parameters.
-
Ad accounts Список содержит все рекламные аккаунты, доступные авторизованному профилю LinkedIn. Для выгрузки статистики достаточно роли Viewer на аккаунте. Пайплайн выгружает данные одного аккаунта, поэтому для нескольких аккаунтов создайте по пайплайну на каждый.
-
Report Types Выберите тип отчёта для выгрузки.
Тип отчёта Описание Ad statistics report Дневная статистика по каждому объявлению: показы, клики, расход, конверсии, лиды, вовлечённость, метрики видео, каруселей и документов. Ad metadata report Текущие атрибуты каждого объявления: имя, идентификаторы кампании и аккаунта, статус модерации, статус показа, даты создания и изменения. Campaign metadata report Текущие атрибуты каждой кампании: имя, статус, цель, формат, тип оплаты, бюджет, расписание и флаги настроек. Account metadata report Текущие атрибут ы подключённого рекламного аккаунта: имя, идентификатор, тип, статус и валюта.
Ad statistics report всегда группируется по объявлению и дню. Итоги по кампаниям и аккаунту считаются агрегацией выгруженных строк в хранилище. Отчёты метаданных присоединяются по идентификаторам кампании и аккаунта.
Параметры
Выберите поля, которые войдут в таблицу назначения. Схема вашего датасета определяется выбранными здесь параметрами.
| Название | Имя в API | Описание |
|---|---|---|
Creative ID text | creative_id | Creative ID |
date date | date | Interaction date |
actionClicks int | action_clicks | The count of clicks on the action button of the Sponsored Messaging ad. |
adUnitClicks int | ad_unit_clicks | The count of clicks on the ad unit displayed alongside the Sponsored Messaging ad. |
approximateMemberReach int | approximate_member_reach | Non-demographic pivots only (i.e. not MEMBER_). The estimated number of unique member accounts with at least one impression. This metric is an updated and more accurate version of legacy metric approximateUniqueImpressions. This metric is only available when the number of days in the date range is less than or equal to 92 days. This metric is fully launched in Jan 2024. |
averageDwellTime int | average_dwell_time | Average user dwell time (in seconds). It measures the duration for which more than 50% of the ad's pixels remain visible in the viewport. Note: The averageDwellTime field is only supported from API version 202411 onwards. |
audiencePenetration float | audience_penetration | The approximate number of unique members reached by the advertiser divided by the approximate total target audience size. The field will be null if the date range has more than 92 days. This metric only supports the CAMPAIGN pivot. Note: The audiencePenetration field is only supported from API version 202411 onwards. |
cardClicks int | card_clicks | Non-demographic pivots only (i.e. not MEMBER_). The number of clicks for each card of a carousel ad. The first card click of the carousel ad results in an immediate cardClick and click, whereas scrolling to other cards and clicking will count as additional cardClick. |
cardImpressions int | card_impressions | Non-demographic pivots only (i.e. not MEMBER_). The number of impressions shown for each card of a carousel ad. The first card of the carousel ad results in an immediate cardImpression and impression, whereas scrolling to other cards will count as additional cardImpressions. |
clicks int | clicks | The count of chargeable clicks. Despite not charging for clicks for CPM campaigns, this field still represents those clicks for which we would otherwise charge advertisers based on objective (for example, clicks to view the landing page or company page). |
commentLikes int | comment_likes | The count of likes of a comment. Sponsored Content only. |
comments int | comments | The count of comments. Sponsored Content only. |
companyPageClicks int | company_page_clicks | The count of clicks to view the company page. |
conversionValueInLocalCurrency float | conversion_value_in_local_currency | Non-demographic pivots only (i.e. not MEMBER_). Value of the conversions in the account's local currency based on rules defined by the advertiser. Conversion value is set by the advertiser at a per conversion level, and aggregated across the query time range. |
costInLocalCurrency float | cost_in_local_currency | Cost in the account's local currency based on the pivot and timeGranularity. For example, this would be spend by member company size per month if the pivot is MEMBER_COMPANY_SIZE and timeGranularity is MONTHLY. Cost is not adjusted for over delivery when a member professional demographic pivot is specified in the request. |
costInUsd float | cost_in_usd | Cost in USD based on the pivot and timeGranularity. For example, this would be spend by campaign on a given day if the pivot is CAMPAIGN and timeGranularity is DAILY. Cost is not adjusted for over delivery when a member professional demographic pivot is specified in the request. |
costPerQualifiedLead float | cost_per_qualified_lead | How much money was spent per qualified lead. Ratio is costInLocalCurrency / qualifiedLeads. |
documentCompletions int | document_completions | The number of times users reached 100% of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions. |
documentFirstQuartileCompletions int | document_first_quartile_completions | The number of times users reached the first quartile of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions. |
documentMidpointCompletions int | document_midpoint_completions | The number of times users reached the second quartile of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions. |
documentThirdQuartileCompletions int | document_third_quartile_completions | The number of times users reached the third quartile of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions. |
downloadClicks int | download_clicks | The number of times users have indicated the intent to download the media in an ad by clicking the download icon. This may or may not result in an actual download (e.g. if the user rejects a browser download prompt). This metric is only available for ad formats supporting media downloads. |
externalWebsiteConversions int | external_website_conversions | Total number of times users took a desired action after clicking on or seeing your ad. When conversions cannot be attributed to individual users, group level attribution or estimation may be used. |
externalWebsitePostClickConversions int | external_website_post_click_conversions | Total number of times users took a desired action after clicking on your ad. When conversions cannot be attributed to individual users, group level attribution or estimation may be used. |
externalWebsitePostViewConversions int | external_website_post_view_conversions | Total number of times users took a desired action after seeing your ad. When conversions cannot be attributed to individual users, group level attribution or estimation may be used. |
follows int | follows | The count of follows. Sponsored Content and Follower ads only. |
fullScreenPlays int | full_screen_plays | Number of times members click on the full screen button or on the video(mobile only) to go into full screen mode. |
headlineClicks int | headline_clicks | The number of times members clicked on the headline of conversation ads. |
headlineImpressions int | headline_impressions | The number of times members were shown the headline of conversation ads. |
impressions int | impressions | This is the count of "impressions" for Sponsored Content and "sends" for Sponsored Messaging. |
jobApplications float | job_applications | The number of times a member completed a job application after viewing or clicking on an ad. Currently, this metric is broken down into postViewJobApplications (if the member applied after viewing the ad) and postClickJobApplications (if the member applied after clicking the ad). |
jobApplyClicks float | job_apply_clicks | The number of times a member clicked on the job’s apply button on an LinkedIn jobs page after viewing or clicking on an ad which has a LinkedIn job landing page. Currently, this metric is broken down into postViewJobApplyClicks (if the member performed the action after viewing the ad) and postClickJobApplyClicks (if the member performed the action after clicking the ad). |
landingPageClicks int | landing_page_clicks | The count of clicks which take the user to the creative landing page. |
leadGenerationMailContactInfoShares int | lead_generation_mail_contact_info_shares | The number of times users shared contact info through the One Click Lead Gen for Sponsored Messaging ads. |
leadGenerationMailInterestedClicks int | lead_generation_mail_interested_clicks | The count of Sponsored Messaging ad recipients who clicked to demonstrate interest. |
likes int | likes | The count of likes. Sponsored Content only. |
oneClickLeadFormOpens int | one_click_lead_form_opens | The count of times users opened the lead form for a One Click Lead Gen campaign. |
oneClickLeads int | one_click_leads | The count of leads generated through One Click Lead Gen. |
opens int | opens | The count of opens of Sponsored Messaging ads. |
otherEngagements int | other_engagements | The count of user interactions with the ad unit that do not fit into any other more specific category. |
postClickJobApplications float | post_click_job_applications | The number of times a member completed a job application after clicking on an ad. See also jobApplications. |
postClickJobApplyClicks float | post_click_job_apply_clicks | The number of times a member clicked on the job’s apply button on an LinkedIn jobs page after clicking on an ad which has a LinkedIn job landing page. See also jobApplyClicks. |
postClickRegistrations float | post_click_registrations | The number of times a member has registered for an event or seminar after clicking on an ad which has a LinkedIn landing page. This includes gross registrations and does not account for a user unregistering. |
postViewJobApplications float | post_view_job_applications | The number of times a member completed a job application after viewing an ad. See also jobApplications. |
postViewJobApplyClicks float | post_view_job_apply_clicks | The number of times a member clicked on the job’s apply button on an LinkedIn jobs page after clicking an ad which has a LinkedIn job landing page. See also jobApplyClicks. |
postViewRegistrations float | post_view_registrations | The number of times a member has registered for an event or seminar after viewing an ad which has a LinkedIn event landing page. This includes gross registrations and does not account for a user unregistering. See also registrations. |
qualifiedLeads int | qualified_leads | The count of qualified leads shared by the advertiser. Qualified lead is a lead that has been deemed more likely to become a customer compared to other leads, based on their engagement and fit. |
reactions int | reactions | The count of positive reactions on Sponsored Content which can capture, like, interest, praise, and other responses. |
registrations float | registrations | The number of times a member has registered for an event or seminar after viewing or clicking on an ad which has a LinkedIn event landing page. This includes gross registrations and does not account for a user unregistering. |
sends int | sends | The count of sends of Sponsored Messaging ads. |
shares int | shares | The count of shares. Sponsored Content only. |
subscriptionClicks int | subscription_clicks | The count of clicks to subscribe to a series, such as a Newsletter. |
talentLeads int | talent_leads | Number of leads captured through a talent media campaign. |
textUrlClicks int | text_url_clicks | The count of clicks on any links (anchor tags) that were included in the body of the Sponsored Messaging ad. |
totalEngagements int | total_engagements | The count of all user interactions with the ad unit. |
validWorkEmailLeads int | valid_work_email_leads | The count of leads with a valid work email that does not use an established free or personal email domain. |
videoCompletions int | video_completions | The count of video ads that played 97-100% of the video. This includes watches that skipped to this point if the serving location is ON_SITE. |
videoFirstQuartileCompletions int | video_first_quartile_completions | The count of video ads that played through the first quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE. |
videoMidpointCompletions int | video_midpoint_completions | The count of video ads that played through the midpoint of the video. This includes watches that skipped to this point if the serving location is ON_SITE. |
videoStarts int | video_starts | The count of video ads that were started by users. |
videoThirdQuartileCompletions int | video_third_quartile_completions | The count of video ads that played through the third quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE. |
videoViews int | video_views | A video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to fullscreen mode) does not count as a view. |
viralCardClicks int | viral_card_clicks | Non-demographic pivots only (i.e. not MEMBER_). The number of viralClicks for each card of a carousel ad. The first viralCardClick of the carousel ad results in an immediate viralCardClick and viralClick, whereas scrolling to other cards and clicking will count as additional viralCardClick. |
viralCardImpressions int | viral_card_impressions | Non-demographic pivots only (i.e. not MEMBER_). The number of viralImpressions shown for each card of a carousel ad. The first card of the carousel ad results in an immediate viralCardImpression and viralImpression, whereas scrolling to other cards will count as additional viralCardImpressions. |
viralClicks int | viral_clicks | The count of clicks on viral impressions. See viral impressions definition. Sponsored Content only. |
viralCommentLikes int | viral_comment_likes | The count of likes on comments from viral impressions for this activity. See viral impressions definition. Sponsored Content only. |
viralComments int | viral_comments | The count of comments from viral impressions for this activity. See viral impressions definition. Sponsored Content only. |
viralCompanyPageClicks int | viral_company_page_clicks | The count of clicks to view the company page from viral impressions for this activity. See viral impressions definition. Sponsored Content only. |
viralDocumentCompletions int | viral_document_completions | The number of times users reached 100% of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads. |
viralDocumentFirstQuartileCompletions int | viral_document_first_quartile_completions | The number of times users reached the first quartile of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads. |
viralDocumentMidpointCompletions int | viral_document_midpoint_completions | The number of times users reached the second quartile of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads. |
| Название | Имя в API | Описание |
|---|---|---|
Serving Hold Reasons array_string | serving_hold_reasons | A list of reasons why the creative is on hold. |
Last Modified At int | last_modified_at | The timestamp of the last modification. |
Last Modified By text | last_modified_by | The URN of the user or system that last modified the campaign. |
Content Reference text | content_reference | The URN reference to the associated content. |
Created At int | created_at | The timestamp when the campaign was created. |
Datetime Created At datetime | datetime_created_at | The datetime when the ad creative was created. |
Date Created At date | date_created_at | The date when the ad creative was created. |
Is Test bool | is_test | Indicates whether the creative is a test campaign. |
Created By text | created_by | The URN of the user who created the campaign. |
Review Rejection Reasons array_string | review_rejection_reasons | A list of reasons why the campaign was rejected. |
Review Status text | review_status | The review status of the campaign. |
Is Serving bool | is_serving | Indicates whether the campaign is currently serving. |
Creative Name text | creative_name | The name of the campaign. |
Campaign ID text | campaign_id | The ID of the campaign. |
Creative ID text | creative_id | The ID of the sponsored creative. |
Intended Status text | intended_status | The intended status of the campaign. |
Account ID text | account_id | The ID of the advertising account. |
| Название | Имя в API | Описание |
|---|---|---|
campaign id text | campaign_id | The unique identifier for the campaign. |
campaign name text | campaign_name | The name of the campaign. |
Is test campaign? bool | test | Indicates if this is a test campaign. |
storyDeliveryEnabled bool | story_delivery_enabled | Whether story delivery is enabled for this campaign. |
format text | format | The format of the ad unit. |
servingStatuses array_string | serving_statuses | The current serving statuses of the campaign. |
connectedTelevisionOnly bool | connected_television_only | Indicates whether the campaign is limited to connected television only. |
localeCountry text | locale_country | The country locale setting for the campaign. |
localeLanguage text | locale_language | The language locale setting for the campaign. |
type text | type | The type of ad campaign. |
versionTag text | version_tag | The version tag for tracking campaign updates. |
objectiveType text | objective_type | The marketing objective type for the campaign. |
associatedEntity text | associated_entity | The entity associated with this campaign (e.g., an organization). |
optimizationTargetType text | optimization_target_type | The optimization target type for the campaign. |
runScheduleStart int | run_schedule_start | The campaign start time in epoch milliseconds. |
createdBy text | change_audit_stamps_created_actor | The actor who created this campaign. |
createdTime int | change_audit_stamps_created_time | The timestamp of when the campaign was created. |
lastModifiedBy text | change_audit_stamps_last_modified_actor | The actor who last modified this campaign. |
lastModifiedTime int | change_audit_stamps_last_modified_time | The timestamp of when the campaign was last modified. |
campaignGroupId text | campaign_group_id | The campaign group identifier. |
costType text | cost_type | The pricing model used in the campaign (CPC, CPM, etc.). |
creativeSelection text | creative_selection | The method for selecting creatives in the campaign. |
unitCostCurrency text | unit_cost_currency_code | The currency used for campaign cost. |
unitCostAmount float | unit_cost_amount | The unit cost amount for the campaign. |
offsiteDeliveryEnabled bool | offsite_delivery_enabled | Indicates whether offsite delivery is enabled. |
audienceExpansionEnabled bool | audience_expansion_enabled | Whether audience expansion is enabled for broader reach. |
account id text | account_id | The LinkedIn ad account associated with this campaign. |
status text | status | The current status of the campaign (DRAFT, ACTIVE, etc.). |
| Название | Имя в API | Описание |
|---|---|---|
Currency text | currency | The currency associated with the account. |
Account ID text | account_id | The unique identifier for the account. |
Account Name text | account_name | The name of the account. |
Notified On Campaign Optimization bool | notified_on_campaign_optimization | Indicates if the account is notified of campaign optimization. |
Notified On Creative Approval bool | notified_on_creative_approval | Indicates if the account is notified of creative approval. |
Notified On Creative Rejection bool | notified_on_creative_rejection | Indicates if the account is notified of creative rejection. |
Notified On End Of Campaign bool | notified_on_end_of_campaign | Indicates if the account is notified when a campaign ends. |
Notified On New Features Enabled bool | notified_on_new_features_enabled | Indicates if the account is notified when new features are enabled. |
Reference text | reference | The URN reference associated with the account. |
Serving Statuses array_string | serving_statuses | A list of serving statuses for the account. |
Status text | status | The current status of the account. |
Is Test Account bool | test | Indicates whether the account is a test account. |
Account Type text | type | The type of the account. |
Каждая строка списка показывает имя поля, а под ним имя колонки в таблице назначения: actionClicks становится колонкой action_clicks.
Отметьте поля для выгрузки и проверьте выбор на вкладке Selected.
Ad statistics report содержит расход в двух полях: cost_in_local_currency (валюта рекламного аккаунта) и cost_in_usd.
Идентификаторы вроде Creative ID и Campaign ID выгружаются простыми числами, поэтому таблица статистики соединяется с таблицами метаданных напрямую.
Имя таблицы
Назовите пайплайн и таблицу назначения.
- Integration name.
Имя пайплайна. Оно используется только в интерфейсе Renta. - Table name.
Имя таблицы назначения. Можно оставить автоматически сгенерированное имя или задать своё.
Диапазон дат
Задайте исторический период загрузки. По умолчанию Date start равен первому дню текущего месяца, а Date end установлен в Today.
- Date start.
Первая дата периода выгрузки. - Date end.
Последняя дата периода выгрузки. Можно выбрать фиксированную дату или относительный вариант, например Today.
Период перезаписи
Период перезаписи определяет, сколько последних дней Renta перезагружает при каждом запуске. Настройка появляется, когда выбран параметр date.
При каждом запуске Renta заново запрашив ает данные начиная с даты последнего успешного запуска минус период перезаписи. Затронутые дни удаляются из таблицы назначения и вставляются заново, а более старые данные остаются нетронутыми.
Варианты: от Without overwrite data до Overwrite all data. По умолчанию выбран Last 3 days.
Расписание
Выберите, как часто запускается пайплайн.
| Тип расписания | Описание |
|---|---|
| Manual | Пайплайн запускается только вручную через интерфейс или по API. |
| Daily | Пайплайн запускается раз в день в указанное время обновления. |
| Interval | Пайплайн запускается через заданные интервалы времени. |
| Cron Expression | Пайплайн запускается по расписанию, заданному cron-выражением. |
Для расписания Daily задайте Update time (точное время запуска), затем нажмите Create pipeline.
Новый пайплайн появится в разделе Pipelines на вкладке ETL, где можно отслеживать запуски, прогресс и имя таблицы назначения.
Ограничения
API отчё тности LinkedIn задаёт рамки, которые действуют для каждого пайплайна на этом источнике.
| Ограничение | Описание |
|---|---|
| Полей в отчёте | API возвращает не больше 20 полей за запрос. На практике в Ad statistics report помещаются date, Creative ID и до 19 полей с метриками. |
| Глубина дневной статистики | LinkedIn хранит статистику с дневной детализацией примерно за последние шесть месяцев. Более ранний Date start ничего не вернёт за ту часть диапазона, которая выходит за это окно. |
| Гранулярность статистики | Ad statistics report всегда группируется по объявлению с дневной детализацией. Итоги по кампаниям и аккаунту агрегируются в хранилище. |
| Нет истории в отчётах метаданных | Ad metadata report, Campaign metadata report и Account metadata report возвращают текущее состояние объектов, без истории изменений. |
Стратегия синхронизации
Стратегия синхронизации зависит от типа отчёта и от того, включён ли в отчёт параметр date.
| Стратегия | Поддерживаемые типы отчётов | Описание |
|---|---|---|
| Инкрементальное обновление | Ad statistics report (с выбранным параметром date) | Каждая строка несёт свою дату, и таблица назначения партиционируется по колонке date. При каждом запуске Renta запрашивает окно от последнего успешного запуска минус период перезаписи: затронутые дневные партиции удаляются и вставляются заново, а более старые остаются нетронутыми. |
| Полная перезагрузка | Ad statistics report (без параметра date) | В таблице нет колонки даты для партиционирования, поэтому Renta запрашивает статистику за весь настроенный диапазон дат и заменяет датасет при каждом запуске. |
| Полная перезагрузка | Ad metadata report, Campaign metadata report, Account metadata report | Эти отчёты возвращают текущее состояние объявлений, кампаний и аккаунта и не имеют поля даты, поэтому Renta перезагружает весь датасет при каждом запуске. |
Часто задаваемые вопросы
Ready to get started?
Build your data pipeline today or get a personalized demo. Start free!
Need help?
Get expert support to ensure your project succeeds. We're here to help!
Feature requests?
Help shape our product! Share your ideas for new features and integrations.