Connect LINE to Google Data Studio with Windsor.ai
Directly connect LINE to Google Data Studio, in minutes, and in an easy-to-use format.
All your marketing data in one place, just in a few clicks.
Automate and save time.
Use all your data where and when you need it.
About LINE
LINE is a popular instant messaging and social media application that was launched in 2011. The app is available on multiple platforms, including iOS, Android, Windows, and macOS, and has more than 182 million monthly active users worldwide while mostly popular in Asia. LINE Official Accounts is a service that allows businesses to contact users while blending into their daily lives just like using LINE to communicate with friends and family. These accounts can be used to share information about products, services, promotions, and events as well as provide customer service and support.
Learn more about LINE
About Google Data Studio
Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.
Learn more about Google Data Studio
About the LINE Google Data Studio Connector
The Line Google Data Studio connector pulls metrics and dimensions from Line. The insights are retrieved at the account and message level.
Once the user successfully logs into the connector it’s possible to choose the metrics and dimensions to create a report.
Prerequisites
To set up the connector, the user should have:
- A Line API key (Visit our privacy policy and terms of use)
- Google account for Line to Google Data Studio integration.
- A Windsor account. Start your free trial now.
How to connect LINE to Google Data Studio?
You need to select Line as a Data Source and grant access to Windsor.ai. You need a LINE API key in order to use this connector.
Select the fields on the right to later use in your data source. For example, you can include metrics such as Followers, Targeted Reach, or Welcome Response.
Go to “Select Destination” and choose Google Data Studio.
Once done, select “connect” and authorize access to your data source.
Windsor.ai: All your marketing data in one place
Power up your marketing performance with result-driven marketing solutions
- Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
- The setup is done in minutes. No coding is required.
- Currently, we support more than 3000 dimensions and metrics.
- See the value and return on every marketing touchpoint.
- Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.
Google Data Studio Templates for LINE
Do you plan to connect and visualize LINE data in Google Data Studio?
These free and customizable Google Data Studio Line templates will assist you in visualizing your data for easy reporting and analysis.
Google Data Studio Tutorials for LINE
Would you like to take your Google Data Studio LINE dashboards to the next level?
Here are some of our favorite tutorials to help you:
Available LINE Metrics and Dimensions
| Name | Type | Description |
|---|---|---|
| account id | TEXT | Same as channel_id |
| account name | TEXT | Same as channel_id |
| basicId | TEXT | Bot's basic ID |
| channel id | TEXT | Unique identifier for the channel |
| Date | DATE | The Date |
| display name | TEXT | Bot's display name |
| blocks | NUMERIC | The number of users blocking the account as of the specified date. The number decreases when a user unblocks the account. |
| followers | NUMERIC | The number of times, as of the specified date, that a user added this LINE Official Account as a friend for the first time. The number doesn't decrease even if a user later blocks the account or when they delete their LINE account. |
| insight_followers_status | TEXT | Status of the counting process of number of followers. One of: ready, unready, out_of_service |
| targeted_reaches | NUMERIC | The number of users, as of the specified date, that the LINE Official Account can reach through targeted messages based on gender, age, and/or region. This number only includes users who are active on LINE or LINE services and whose demographics have a high level of certainty. |
| api_broadcast | NUMERIC | Number of broadcast messages sent with the Send broadcast message Messaging API operation. |
| api_multicast | NUMERIC | Number of multicast messages sent with the Send multicast message Messaging API operation. |
| api_narrowcast | NUMERIC | Number of narrowcast messages sent with the Send narrowcast message Messaging API operation. |
| api_push | NUMERIC | Number of push messages sent with the Send push message Messaging API operation. |
| api_reply | NUMERIC | Number of replies sent with the Send reply message Messaging API operation. |
| auto_response | NUMERIC | Number of auto-response messages sent. |
| broadcast | NUMERIC | Number of messages sent to all of this LINE Official Account's friends (broadcast messages). |
| chat | NUMERIC | Number of messages sent from LINE Official Account Manager Chat screen. |
| insight_message_delivery_status | TEXT | Status of the counting process of message deliveries. One of: ready, unready, out_of_service |
| targeting | NUMERIC | Number of messages sent to some of this LINE Official Account's friends, based on specific attributes (targeted messages). |
| welcome_response | NUMERIC | Number of greeting messages sent. |