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.

Line
+
google data studio log
data integration

All your marketing data in one place, just in a few clicks.

In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.

Automate and save time.

No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.
Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!
Data Automation
data warehouse

Use all your data where and when you need it.

We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).

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:

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.

Windsor.ai LINE Onboarding Screen

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.

select fields on the right

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

NameTypeDescription
account idTEXTSame as channel_id
account nameTEXTSame as channel_id
basicIdTEXTBot's basic ID
channel idTEXTUnique identifier for the channel
DateDATEThe Date
display nameTEXTBot's display name
blocksNUMERICThe number of users blocking the account as of the specified date. The number decreases when a user unblocks the account.
followersNUMERICThe 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_statusTEXTStatus of the counting process of number of followers. One of: ready, unready, out_of_service
targeted_reachesNUMERICThe 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_broadcastNUMERICNumber of broadcast messages sent with the Send broadcast message Messaging API operation.
api_multicastNUMERICNumber of multicast messages sent with the Send multicast message Messaging API operation.
api_narrowcastNUMERICNumber of narrowcast messages sent with the Send narrowcast message Messaging API operation.
api_pushNUMERICNumber of push messages sent with the Send push message Messaging API operation.
api_replyNUMERICNumber of replies sent with the Send reply message Messaging API operation.
auto_responseNUMERICNumber of auto-response messages sent.
broadcastNUMERICNumber of messages sent to all of this LINE Official Account's friends (broadcast messages).
chatNUMERICNumber of messages sent from LINE Official Account Manager Chat screen.
insight_message_delivery_statusTEXTStatus of the counting process of message deliveries. One of: ready, unready, out_of_service
targetingNUMERICNumber of messages sent to some of this LINE Official Account's friends, based on specific attributes (targeted messages).
welcome_responseNUMERICNumber of greeting messages sent.