--- title: "Data Source - LINE Ads" slug: "data-source-line-ad-api" updated: 2024-09-19T08:14:00Z published: 2024-09-19T08:14:00Z canonical: "documents.trocco.io/data-source-line-ad-api" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Data Source - LINE Ads ## summary This is the help page for ETL Configuration of Report Data Settings for LINE Ads (formerly Line Ads Platform). ## Setting items ### STEP1 Basic settings | item name | indispensable | Contents | | --- | --- | --- | | LINE Ads Connection Configuration | Yes | Select Connection Configuration for LINE Ads. For more information, please refer to the [Connection Configuration for LINE Ads](/docs/connection-configuration-line-ad-api). | | Ad Account ID | Yes | From the **Ad Accounts** tab of the [LINE Ads Manager](https://account.line.biz/login) administration screen, confirm the **Ad Account ID for** which data is to be acquired and enter it. ![image.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-source-line-ad-api-2024-08-29-21-43-0.png) | | Download Type | Yes | Select either **Performance Report** or **Master Data (Ads)**. | #### Performance Report | item name | indispensable | Contents | | --- | --- | --- | | Report Type | Yes | Select the report type. See [Data Type](/docs/data-source-line-ad-api#%E3%83%87%E3%83%BC%E3%82%BF%E7%A8%AE%E5%88%A5) for an overview of each report and [Column Detail](/docs/data-source-line-ad-api#%E3%82%AB%E3%83%A9%E3%83%A0%E8%A9%B3%E7%B4%B0) for column-by-column details. | | Data acquisition period | Yes | Enter the period for which the report is to be extracted in `yyyy-MM-dd` format. | | custom conversion | No | If you have custom conversions you would like to capture, please enter them here. For more information on custom conversions, see [Measuring Website Conversions](https://www.linebiz.com/jp/manual/line-ads/tracking_016/). | Requests when setting up custom conversions If you have added, modified, or deleted a Custom Conversion setting for an existing ETL Configuration, please select **Run Automatic Data Setting** under "Select Automatic Data Setting". ![image](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-source-line-ad-api-2024-08-29-21-43-1.png) #### Master Data (Advertisement) | item name | indispensable | Contents | | --- | --- | --- | | master data type | Yes | Select the master data type. See [Data Type](/docs/data-source-line-ad-api#%E3%83%87%E3%83%BC%E3%82%BF%E7%A8%AE%E5%88%A5) for an overview of each data [type](/docs/data-source-line-ad-api#%E3%83%87%E3%83%BC%E3%82%BF%E7%A8%AE%E5%88%A5) and [Column Details](/docs/data-source-line-ad-api#%E3%82%AB%E3%83%A9%E3%83%A0%E8%A9%B3%E7%B4%B0) for details on column units. | ## data type ### Performance Report | classification | Report Contents | | --- | --- | | Advertising Accounts | You can get daily reports by ad account. | | campaign | You can get daily reports by campaign. | | advertising group | You can get daily reports by ad group. | | advertisement | You can get daily reports by ad unit. | ### Master Data (Advertisement) | classification | Report Contents | | --- | --- | | campaign | You can retrieve the master data of the campaign. | | advertising group | Master data for ad groups can be retrieved. | | advertisement | Master data for ads can be retrieved. | ## Column Details Columns not to be retrieved The following columns included in data prior to May 2019 will not be captured. - viewable impression - CVF Application ### Performance Report Details of each column For more information on each column, please refer to [the LINE Ads API documentation](https://ads.line.me/public-docs/v3/3.9.1/certificated-ad-tech-general-partner#_report_fields_by_each_report_level). | column name | content | example values | ad account | campaign | ad group | ad | ad | --------------------------------- | ---------------------------------------------- | --------------------------- | --------- | -------- | ------- | --- | | day | date | 2019-12-24 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ad_account_name | ad_account_name | Sample Report | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ad_account_id | ad_account_id | ad_account_id | A12345678900 | ✓ | ✓ | ✓ | ✓ | ✓ | campaign_name | campaign_name | Sample Campaign 3 | - | ✓ | ✓ | ✓ | ✓ | campaign_id | campaign_id | 1230000000000 | - | ✓ | ✓ | ✓ | ✓ | campaign_objective | campaign_objective | VISIT_MY_WEBSITE | - | ✓ | ✓ | ✓ | ✓ | ad_group_name | ad_group_name | ad_group_name | ad_group_name 201801151037 | - | - | ✓ | ✓ | | ad_group_id | ad_group_id | ad_group_id | 2230000000000 | - | - | ✓ | ✓ | ✓ | ad_name | ad_name | ad_name | ad_name 201801151037 | - | - | - | ✓ | | ad_id | ad_id | ad_id | 3230000000000 | - | - | | ✓ | | title | Ad Title | Sample Title | - - - - - | ✓ | | description | Description of the ad | Sample Description | - - - - | ✓ | | impressions | impressions | 56 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | cpm | CPM(Cost Per Mille) | 0 | ✓ | ✓ | ✓ | ✓ | | clicks | clicks | 1 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ctr | CTR (Click Through Rate) | 1.79 | ✓ | ✓ | ✓ | ✓ | ✓ | cpc | CPC(Cost Per Click) | 24000 | ✓ | ✓ | ✓ | ✓ | | cv | CV(Conversion) | 0 | ✓ | ✓ | ✓ | ✓ | | cvr | CVR(Conversion Rate) | 0.00 | ✓ | ✓ | ✓ | ✓ | | cpa | CPA(Cost Per Acquisition) | 0 | ✓ | ✓ | ✓ | ✓ | | cost | cost | 24000 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | currency | currency | JPY | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | reach_estimated | reach_estimated | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | video_starts | number of video starts | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | 3_second_video_views | Number of times played in 3 seconds | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_3_second_playback | cost per 3 second playback | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | video_watches_at_p25 | 25% played | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | video_watches_at_p50 | 50% played | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | video_watches_at_p75 | 75% played | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | video_watches_at_p95 | 95% played | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | video_completions | number of completed video views | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_complete_video_view | cost per completed video view | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | installs_clicks | installs (clicks) | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | installs_views | installs (views) | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | installs_clicks_and_views | installs (clicks + views) | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | installs_sk_ad_network | Number of SKAdNetwork measurements installed | 0 | ✓ | ✓ | ✓ | ✓ | - | | install_rate_clicks | install_rate_clicks | 0.00 | ✓ | ✓ | ✓ | ✓ | ✓ | install_rate_sk_ad_network | install rate of SKAdNetwork measurement | 0.00 | ✓ | ✓ | ✓ | ✓ | - | | cost_per_install_clicks | cost per install (clicks) | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_install_clicks_and_views | cost per install (clicks + views) | 0 | ✓ | ✓ | ✓ | ✓ | cost_per_install_sk_ad_network | cost per installation of SKAdNetwork measurement | 0 | ✓ | ✓ | ✓ | ✓ | - | | open | number of apps launched | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | open_rate | app_startup_rate | 0.00 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_open | cost per app launch | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | view_home_screen | home_views | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | view_home_rate | home_view_rate | 0.00 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_view_home | cost per home view | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | category_view | category views | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | category_view_rate | category view rate | 0.00 | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_view_category | cost per category view | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | view_product | number of product views | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | product_view_rate | product_view_rate | 0.00 | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_view_product | cost per product view | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | search | number of searches | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | search_rate | search_rate | 0.00 | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_search | cost per search | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | add_to_cart | add_to_cart_number | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | add_to_cart_rate | add_to_cart_rate | 0.00 | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_add_to_cart | cost per add_to_cart | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | purchase | number of purchases | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | purchase_rate | purchase_rate | 0.00 | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_purchase | cost per purchase | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | level_achieved | level_achieved | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | level_achieved_rate | level achieved rate | 0.00 | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_level_achieved | cost per level achieved | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | tutorial_complete | number of completed tutorials | 0 | ✓ | ✓ | ✓ | ✓ | ✓ | tutorial_percent_complete | tutorial_percent_complete | 0.00 | ✓ | ✓ | ✓ | ✓ | ✓ | cost_per_tutorial_completion | cost per tutorial completion | 0 | ✓ | ✓ | ✓ | ✓ | ✓ ### Master Data (Advertisement) Details of each column For more information on each column, please refer to the respective pages of the LINE Ads API documentation. - [campaign](https://ads.line.me/public-docs/v3/3.9.1/certificated-ad-tech-general-partner#_campaign) - [advertising group](https://ads.line.me/public-docs/v3/3.9.1/certificated-ad-tech-general-partner#_adgroup) - [advertisement](https://ads.line.me/public-docs/v3/3.9.1/certificated-ad-tech-general-partner#_ad) #### campaign | column name | Contents | Value Example | | --- | --- | --- | | id | campaign ID | 9086311996634 | | name | Campaign Name | Website Conversions:. 202009231306 | | campaign_objective | Campaign Objectives | WEBSITE_CONVERSION | | configured_status | Campaign Status | PAUSED | | spending_limit_type | Type of spending limit | MONTHLY | | spending_limit_micro | Micro spending limits | 10000000000 | | start_date | Start Date | 2020-09-23T13:06:00+09:00 | | end_date | End date and time | 1970-01-01T00:00:00Z | | active_cbo | Campaign Budget Optimization | False | | bid_strategy | Bidding Strategy | SET_MAX | | daily_budget_micro | Daily budget for budget optimization | 120000000000 | | delivery_status | State of Ad Delivery | PAUSED | | delivery_status_reasons | Reasons for ad serving status | [{'code': 'CAMPAIGN_PAUSED'}] | | created_date | Creation Date | 2020-09-23T13:06:19+09:00 | | modified_date | Update Date | 2021-04-14T08:20:33+09:00 | | removed_date | Deletion Date | 2021-12-22T19:39:03+09:00 | #### advertising group | column name | Contents | Value Example | | --- | --- | --- | | id | advertising group ID | 8390071699113 | | campaign_id | Campaign ID with ad group as parent | 3149071698613 | | name | Ad group name | Ad Groups:. 201912201044 | | media_app | Advertising Group App Media | {"id": 100, "name": "hoge", ..., "removedDate": "2021-12-22T19:39:03+09:00"} | | configured_status | Ad Group Status | ACTIVE | | ad_group_learning | Ad Group Study Information | {'learningStatus': 'LEARNING', 'learningStatusCode': 110, 'lastLearningStartTs':. 1617843000, 'lastLearningEndTs':. 1577589600, 'targetReachRatio': 0.325, 'hasLearningCompletionHistory':. True} | | bid_type | Type of Bid | CPC | | bid_amount_micro | Micro bids | 200000000 | | bid_strategy | Bidding Strategy | SET_MAX | | daily_budget_micro | Daily budget for budget optimization | 500000000 | | auto_bid_type | Types of automatic bidding | CLICK | | auto_bid_conversion_id | Custom Conversion ID | | | first_auto_bid_conversion_id | First custom conversion set for the ad group | | | targeting | Subject of ad group | {'country': 'JP', 'ssps': ['1', '2'], 'includeAdvancedTargetings': [{'interests': ['4']}]} | | dpa_destination_type | Type of DPA destination | APP_STORE_URL | | dpa_destination_url | URL of DPA destination | | | rnf_start_date | Reach start date and time | 2021-11-28T04:28:14+09:00 | | rnf_end_date | Reach end date and time | 2021-11-28T04:28:14+09:00 | | rnf_frequency | Reach Frequency | 2 | | in_stream_video_included | In-stream advertising availability | False | | delivery_status | State of Ad Delivery | NOT_DELIVERING | | delivery_status_reasons | Reasons for ad serving status | [{'code': 'CAMPAIGN_ENDED'}, {'code': 'CAMPAIGN_PAUSED'}, {'code': 'ACTIVE_ad_group_learning'}] | | created_date | Creation Date | 2019-12-20T10:45:30+09:00 | | modified_date | Update Date | 2021-04-12T15:33:35+09:00 | | removed_date | Deletion Date | 2021-04-12T15:33:35+09:00 | #### advertisement | column name | Contents | Value Example | | --- | --- | --- | | id | Ad ID | 6165682099767 | | ad_account_id | Ad account ID that parented the ad | A41527163126 | | ad_group_id | Ad group ID that parented the ad | 8390071699113 | | name | Advertisement Name | Ads:. 201912201045 | | creative | Advertising Creative | {'id': 5165682099767, 'creativeFormat': 'IMAGE', 'title': 'TROCCO', 'description': 'Fully automated data integration services',} | | configured_status | Advertisement Status | ACTIVE | | imp_track_url | Impression Tracking URL | | | view_track_url | view-through conversion tracking URL | | | small_delivery | Advertising with CreativeFormat | false | | delivery_status | State of Ad Delivery | NOT_DELIVERING | | delivery_status_reasons | Reasons for ad serving status | [{'code': 'CAMPAIGN_ENDED'}, {'code': 'CAMPAIGN_PAUSED'}, {'code': 'ACTIVE_ad_group_learning'}] | | created_date | Creation Date | 2021-04-08T16:28:07+09:00 | | modified_date | Update Date | 2021-04-08T16:28:07+09:00 | | removed_date | Deletion Date | 2021-04-08T16:28:07+09:00 |