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. |
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
The following columns included in data prior to May 2019 will not be captured.
- viewable impression
- CVF Application
Performance Report
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)
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 |