English
- Ja - 日本語
- English

Data Source - LINE Ads

16 Dec 2022

Print
Share
Dark
Light
PDF

Data Source - LINE Ads

Updated on 16 Dec 2022

Print
Share
Dark
Light
PDF

Article Summary

Share feedback

Thanks for sharing your feedback!

Note

This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.

summary

This page is a help page for setting up transferring LINE Ads (formerly Line Ads Platform) report data.

Data extraction using the LINE Ads API

The other day, LINE Corporation released a method for extracting advertising data using APIs.
In line with the above, trocco has newly started providing connectors using the LINE Ads API.

This article is a help page about connectors using the LINE Ads API.

Scraping connectors are no longer available

In response to the launch of connectors using the LINE Ads API, we have decided to discontinue the existing connectors using scraping.

Starting from December 2022, there will be a certain period of transition to connectors using the LINE Ads API.
During this transition period, both connectors are available temporarily.
The names of each connector are as follows.

Transfer from - LINE Ads: A new connector using the LINE Ads API
Transfer from - LINE Ads (deprecated): Connector using existing scraping

However, as mentioned above, existing scraping connectors will no longer be available.
If you want to create a new forwarding setting in the future, please use the forwarding source - LINE Ads.

Changes in acquired data due to changes in the method of extracting ad data

There are some differences in the data acquired between the above two connectors.
For details, please refer to the list of changes in acquired data due to changes in the data extraction method of the forwarding source LINE ADS.

Setting items

STEP1 Basic settings

Item nameRequired		content
LINE ad connection information	Yes	Select the connection information for LINE Ads. For details, see Connection information for LINE Ads.
Ad account ID	Yes	Go to the Ad Accounts tab of your LINE Ad Manager user interface and check and enter the ID of the ad account for which you want to retrieve data.
Download Type	Yes	Select either Performance Report or Master Data (Ads).

Performance Report

Item nameRequired		content
Report Type	Yes	Select the report type. Please refer to Data Type for an overview of each report, and Column Details for details on column units.
Data acquisition period	Yes	Enter the time period for which the`yyyy-MM-dd` report is extracted.
Custom conversions	No	If you have a custom conversion you'd like to get, enter it here. For more information about custom conversions, see Track website conversions.

What to ask when setting up custom conversions

If you've added, changed, or removed custom conversion settings from an existing transfer setup, go to "Select automatic settings" and select Perform automatic settings.

Master Data (Advertising)

Item nameRequired		content
Master Data Type	Yes	Select the master data type. Please refer to Data Type for an overview of each data, and column details for details on column units.

Data Type

Performance Report

Type	Report Content
Ad accounts	Get daily reports at the ad account level.
campaign	Get daily reports for the campaign level.
Ad groups	Get daily reports at the ad group level.
advertisement	Get daily reports for your ad level.

Master Data (Advertising)

Type	Report Content
campaign	You can get master data for your campaigns.
Ad groups	You can get master data for your ad groups.
advertisement	You can get master data for your ads.

Column Details

Columns not retrieved

The following columns included in data before May 2019 are not imported.

viewable impression
CVF Application

Performance Report

Details of each column

For more information about each column, see the LINE Ads API documentation.

		Column nameExample	content valueAd	accountcampaignad	groupads
day	date	2019-12-24	✓	✓	✓	✓
ad_account_name	Ad account name	Sample Report	✓	✓	✓	✓
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 groups: 201801151037	-	-	✓	✓
ad_group_id	Ad group ID	2230000000000	-	-	✓	✓
ad_name	Ad name	Advertisement : 201801151037	-	-	-	✓
ad_id	Advertising ID	3230000000000	-	-	-	✓
title	Ad Title	Sample Title	-	-	-	✓
description	Ad description	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 views started	0	✓	✓	✓	✓
3_second_video_views	Number of 3-second views	0	✓	✓	✓	✓
cost_per_3_second_playback	Cost per 3-second playback	0	✓	✓	✓	✓
video_watches_at_p25	25% views	0	✓	✓	✓	✓
video_watches_at_p50	50% views	0	✓	✓	✓	✓
video_watches_at_p75	75% views	0	✓	✓	✓	✓
video_watches_at_p95	95% views	0	✓	✓	✓	✓
video_completions	Number of video views completed	0	✓	✓	✓	✓
cost_per_complete_video_view	Cost per video view	0	✓	✓	✓	✓
installs_clicks	Number of installs (clicks)	0	✓	✓	✓	✓
installs_views	Installs (Views)	0	✓	✓	✓	✓
installs_clicks_and_views	Number of installs (click + view)	0	✓	✓	✓	✓
installs_sk_ad_network	Number of SKAdNetwork measurement installations	0	✓	✓	✓	-
install_rate_clicks	Install rate (click)	0.00	✓	✓	✓	✓
install_rate_sk_ad_network	Install rate of SKAdNetwork measurement	0.00	✓	✓	✓	-
cost_per_install_clicks	Cost per install (click)	0	✓	✓	✓	✓
cost_per_install_clicks_and_views	Cost per install (click + view)	0	✓	✓	✓	✓
cost_per_install_sk_ad_network	Cost per installation of SKAdNetwork measurement	0	✓	✓	✓	-
open	Number of app launches	0	✓	✓	✓	✓
open_rate	App open rate	0.00	✓	✓	✓	✓
cost_per_open	Cost per app launch	0	✓	✓	✓	✓
view_home_screen	Home Views	0	✓	✓	✓	✓
view_home_rate	Home Browsing Rate	0.00	✓	✓	✓	✓
cost_per_view_home	Cost per home visit	0	✓	✓	✓	✓
category_view	Category Views	0	✓	✓	✓	✓
category_view_rate	Category browsing rate	0.00	✓	✓	✓	✓
cost_per_view_category	Cost per category view	0	✓	✓	✓	✓
view_product	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	Number of additional carts	0	✓	✓	✓	✓
add_to_cart_rate	Cart add-to-add rate	0.00	✓	✓	✓	✓
cost_per_add_to_cart	Cost per cart addition	0	✓	✓	✓	✓
purchase	Number of purchases	0	✓	✓	✓	✓
purchase_rate	Purchase rate	0.00	✓	✓	✓	✓
cost_per_purchase	Cost per purchase	0	✓	✓	✓	✓
level_achieved	Number of levels achieved	0	✓	✓	✓	✓
level_achieved_rate	Level attainment rate	0.00	✓	✓	✓	✓
cost_per_level_achieved	Cost per level achieved	0	✓	✓	✓	✓
tutorial_complete	Number of tutorials completed	0	✓	✓	✓	✓
tutorial_percent_complete	Tutorial completion rate	0.00	✓	✓	✓	✓
cost_per_tutorial_completion	Cost per tutorial completion	0	✓	✓	✓	✓

Master Data (Advertising)

Details of each column

For more information about each column, see the pages in the LINE Ads API documentation.

campaign

value

	Example of column	name content
id	Campaign ID	9086311996634
name	Campaign name	Website conversion: 202009231306
campaign_objective	Campaign objective	WEBSITE_CONVERSION
configured_status	Campaign status	PAUSED
spending_limit_type	Types of spending limits	MONTHLY
spending_limit_micro	Micro spending limits	10000000000
start_date	Start date and time	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	Bid strategy	SET_MAX
daily_budget_micro	Daily budgets for budget optimization	120000000000
delivery_status	Ad serving status	PAUSED
delivery_status_reasons	Ad serving status reasons	[{'code': 'CAMPAIGN_PAUSED'}]
created_date	Created	2020-09-23T13:06:19+09:00
modified_date	Modified	2021-04-14T08:20:33+09:00
removed_date	Deletion date and time	2021-12-22T19:39:03+09:00

Ad groups

value

	Example of column	name content
id	Ad group ID	8390071699113
campaign_id	Campaign IDs that are parent to the ad group	3149071698613
name	Ad group name	Ad groups: 201912201044
media_app	Ad 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 learning information	{'learningStatus': 'LEARNING', 'learningStatusCode': 110, 'lastLearningStartTs': 1617843000, 'lastLearningEndTs': 1577589600, 'targetReachRatio': 0.325, 'hasLearningCompletionHistory': True}
bid_type	Types of bids	CPC
bid_amount_micro	Micro bid	200000000
bid_strategy	Bid strategy	SET_MAX
daily_budget_micro	Daily budgets for budget optimization	500000000
auto_bid_type	Types of automated bidding	CLICK
auto_bid_conversion_id	Custom conversion ID
first_auto_bid_conversion_id	First custom conversion set up in an ad group
targeting	Ad group eligibility	{'country': 'JP', 'ssps': ['1', '2'], 'includeAdvancedTargetings': [{'interests': ['4']}]}
dpa_destination_type	Types of DPA destinations	APP_STORE_URL
dpa_destination_url	DPA destination URL
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	Whether or not you have in-stream ads	False
delivery_status	Ad serving status	NOT_DELIVERING
delivery_status_reasons	Ad serving status reasons	[{'code': 'CAMPAIGN_ENDED'}, {'code': 'CAMPAIGN_PAUSED'}, {'code': 'ACTIVE_ad_group_learning'}]
created_date	Created	2019-12-20T10:45:30+09:00
modified_date	Modified	2021-04-12T15:33:35+09:00
removed_date	Deletion date and time	2021-04-12T15:33:35+09:00

value

	Example of column	name content
id	Advertising ID	6165682099767
ad_account_id	Ad-parent ad account ID	A41527163126
ad_group_id	Ad group ID whose parent is the ad	8390071699113
name	Ad name	Advertisement: 201912201045
creative	Ad creatives	{'id': 5165682099767, 'creativeFormat': 'IMAGE', 'title': 'trocco', 'description': 'Full Data Integration Automation Service',}
configured_status	Ad status	ACTIVE
imp_track_url	Impression tracking URL
view_track_url	View-through conversion tracking URL
delivery_status	Ad serving status	NOT_DELIVERING
delivery_status_reasons	Ad serving status reasons	[{'code': 'CAMPAIGN_ENDED'}, {'code': 'CAMPAIGN_PAUSED'}, {'code': 'ACTIVE_ad_group_learning'}]
created_date	Created	2021-04-08T16:28:07+09:00
modified_date	Modified	2021-04-08T16:28:07+09:00
removed_date	Deletion date and time	2021-04-08T16:28:07+09:00

Was this article helpful?

What's Next

Data Source - SQL Server

Table of contents

summary
Setting items
Data Type
Column Details

Data Source - LINE Ads

summary

Setting items

STEP1 Basic settings

Performance Report

Master Data (Advertising)

Data Type

Performance Report

Master Data (Advertising)

Column Details

Performance Report

Master Data (Advertising)

campaign

Ad groups

advertisement

What's Next