Data Source - LINE Ads
- Print
- PDF
Data Source - LINE Ads
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback!
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. |
| Ad Account ID | Yes | From the Ad Accounts tab of the LINE Ads Manager administration screen, confirm the Ad Account ID for which data is to be acquired and enter it. |
| 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 for an overview of each report and Column Detail 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. |
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".
Master Data (Advertisement)
| item name | indispensable | Contents |
|---|---|---|
| master data type | Yes | Select the master data type. See Data Type for an overview of each data type and Column Details 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.
| 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
| 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 |
Was this article helpful?