+
Introduction to Windsor.ai connector
Windsor.ai connector provides access to analytics and ad data from various advertising platforms. The connector exposes over a hundred Metrics and Dimensions. It also enables multi-touch data-driven attributed conversion and revenue data.
Users can easily log into the Windsor.ai connector and select the metrics and dimensions on which they want to create a report. Windsor.ai also gives you access to CRM data, allowing you to monitor offline cancellations or conversions and returns.
Steps to Connect
Step 1: Choose a data source
In this case, your data source will be Twitter Ads. Once selected, you need to Grant Access to Windsor.ai.
Step 2: Select Looker Studio as your destination
Navigate to “Select Destination” and click Looker Studio.
Step 3: Connect and authorize access to Twitter Ads
Click on the options on the right and then Google Data studio Destination. Once done, connect and authorize access to your data source.
Create your Twitter Ads Dashboard on Looker Studio
Once on the Windsor.ai connector, use your Gmail account to sign up and create your Looker Studio Dashboard. This way, you can create visualizations and analyze your Twitter ads data on Looker Studio. Here’s how to go about it.
The first thing to do is connect your data. You’ll need a Twitter Ads connector like Windsor.ai. It offers a 30-day free trial with all features, which means you’ll have more than enough time to explore every possibility.
Winsor.ai comes with templates to help you get started. You can use, adapt, and rebrand these templates to create your Twitter Ads Dashboard. This connector makes integrating and extracting Twitter ads data easy.
Dashboard Overview
The dashboard is where you view your Twitter Ads and contains lots of metrics and information. It provides you with valuable insights into the performance of your content and paid campaigns. You choose what to add to your report on your dashboard and what you shouldn’t.
Your reports and dashboards serve your audience like other marketing initiatives. It helps to consider who you’re reporting to and the types of information that are relevant to them when creating a dashboard.
Steps to create your own charts
Twitter is an excellent social media for multi-purpose content. Insights from Twitter ads go a long way to help you improve engagement with your consumers.
Here are the steps to follow when creating your charts:
Step 1: Open Looker Studio
The first thing to do is launch the Looker Studio on edit mode.
Step 2: Add a chart
Navigate to the menu and click Add a Chart or Insert.
Step 3: Select a chart type
You can choose a chart type from many options, including bar charts, scorecards, tables, time series, pie charts, and more. Ensure that the chart is connected with Windsor.ai.
Step 4: Choose a combination of metrics and dimensions
Whatever you choose here will depend on the chart.
Most Important Twitter Ads metrics and their definition
Impressions
Impressions refer to how many times users have viewed your ads. It could be on search results or their feeds.
Clicks
Clicks refer to the number of times users clicked on your ads.
Link clicks
Link clicks refer to how often users clicked the links on your ads.
Click-through rate
The Click-through rate is the ratio of total clicks to total impressions. It reflects the quality of your ads. A high CTR means that your ads are relevant to your audience.
Conversions metrics
Conversions metrics refer to the actions users take after viewing your ads. With conversions, you can tell if your landing page works. The metrics may differ from what you see on Google Analytics.
However, you can get a more comprehensive analysis of your campaigns by comparing data from the conversion metrics and Google Analytics data to see what users do after viewing your ads.
Cost-per-acquisition (CPA)
CPA is the amount you’re paying for the conversions on your website. It provides valuable insights for optimizing your budget. Let’s say you discover a campaign that drives a lot of conversions at a low price. You can choose to spend more money on it or create similar campaigns.
Conversion rate
Conversion rate is the ratio of total conversions to total clicks.
Cost
Cost refers to the total amount you have spent.
Cost-per-click (CPC)
CPC is the amount you pay for each click on your ads. It is the ratio of total spending to total clicks.
Cost-per-impressions (Cost per 1k Impressions – Aka CPM)
CPM is the amount you pay for every thousand impressions. This metric is handy when running a brand awareness campaign.
Try Windsor.ai today
Access all your data from your favorite sources in one place.
Get started for free with a 30 - day trial.
Twitter Ads metrics and dimensions
Label | Description | Name | Type | Data Type | Tables |
Account Name | The name of the account. | configName | DIMENSION | STRING
|
|
Account ID | Unique identifier of an account | accountId | DIMENSION | STRING
| · Account · tweets · tweets_organic |
Account Status Favorite Count | Indicates approximately how many times Twitter users have liked this status. | status_favorite_count | METRIC | NUMBER
|
|
Account Status Text | The actual text of the status update. | status_text | DIMENSION | STRING |
|
Account Status Retweet Count | The number of times this status has been retweeted. | status_retweet_count | METRIC
| NUMBER |
|
Author ID | The integer representation of the unique identifier for this user. | author_id | DIMENSION | STRING
|
|
All Media | Represents media elements uploaded with the Tweet. | all_media | DIMENSION | STRING
|
|
Date | The dimension that determines how date-based data in a chart is handled. | date_actual | DIMENSION | STRING
|
|
Data Source | Data source title. | dataSource | DIMENSION | STRING
|
|
Data Freshness |
| dataFreshness | DIMENSION | STRING |
|
Date And Time | The dimension that determines how date-based data in a chart is handled (the time dimension). | date | DIMENSION | STRING
|
|
Day Of Week | The dimension that determines how date-based data in a chart is handled. | day_of_week | DIMENSION | STRING
|
|
Day Of Month | The dimension that determines how date-based data in a chart is handled. | day_of_month | DIMENSION | STRING
|
|
Friends Count | The number of users this account is following (AKA their “followings”). Under certain conditions of duress, this field will temporarily indicate 0. | friends_count | METRIC | NUMBER
|
|
Followers Count | The number of followers this account currently has. Under certain conditions of duress, this field will temporarily indicate 0. | followers_count | METRIC | NUMBER
|
|
Hour | The dimension that determines how date-based data in a chart is handled. | hour | DIMENSION | STRING
|
|
Listed Count | The number of public lists that this user is a member of. | listed_count | METRIC | NUMBER
| · account |
Month | The dimension that determines how date-based data in a chart is handled. | month_only | DIMENSION | STRING
|
|
Main Media URL | An http:// URL pointing directly to the uploaded media | file.main_media_url | DIMENSION | STRING | · tweets |
Month Day | The dimension that determines how date-based data in a chart is handled. | month_day | DIMENSION | STRING
|
· tweets_organic |
PMA Is Interpolated? | Used by Power My Analytics to indicate whether lifetime data might be interpolated | isInterpolated |
| BOOLEAN |
|
Name | The name of the user, as they’ve defined it. Not necessarily a person’s name. Typically capped at 50 characters but subject to change. | name | DIMENSION | STRING
|
|
PMA Maximum Cached Data Date | Used by Power My Analytics to indicate maximum cached data date. | MaxDate | DIMENSION | STRING
|
· tweets_organic |
PMA Payment URL | Used by Power My Analytics to provide a URL to activate your account or to see the billing information. | Payment |
| STRING
|
|
PMA Minimum Cached | Data DateUsed by Power My Analytics to indicate minimum cached data date. | MinDate | DIMENSION | STRING
|
|
PMA Trial Status | Used by Power My Analytics to show trial as Active, Expired, or the number of days remaining. | Trial |
| STRING
|
|
PMA Subscription ID | Used by Power My Analytics for billing and user-identification with our support staff. | Subscription |
| STRING
|
|
Statuses Count | The number of Tweets (including retweets) issued by the user. | statuses_count | METRIC | NUMBER |
|
Screen Name | The screen name, handle, or alias that this user identifies themselves with. screen_names are unique but subject to change. | screen_name | DIMENSION | STRING
|
|
Quarter | The dimension that determines how date-based data in a chart is handled. | quarter | DIMENSION | STRING |
|
Tweet ID | The integer representation of the unique identifier for this Tweet. | tweet_id | DIMENSION | STRING |
|
Tweet Retweet Count | The number of times this Tweet has been retweeted. | retweet_count | METRIC | NUMBER
|
|
Tweet Like Count | Indicates approximately how many times this Tweet has been liked by Twitter users. | favorite_count | METRIC | NUMBER
|
|
Tweet Text | The actual Tweet text. | text | DIMENSION | STRING
|
|
User Favourites Count | The number of Tweets this user has liked in the account’s lifetime. British spelling used in the field name for historical reasons. | favourites_count | METRIC | NUMBER
|
|
URL |
| url | DIMENSION | STRING |
|
Week | The dimension that determines how date-based data in a chart is handled. | week | DIMENSION | STRING
|
|
Year Month | The dimension that determines how date-based data in a chart is handled. | month | DIMENSION | STRING |
· tweets_organic |
Year | The dimension that determines how date-based data in a chart is handled. | year | DIMENSION | STRING
|
|
Year Quarter | The dimension that determines how date-based data in a chart is handled. | year_quarter | DIMENSION | STRING
|
|
Year Week | The dimension that determines how date-based data in a chart is handled. | year_week | DIMENSION | STRING
|
|
Twitter Ads report insights
Twitter ads report provides insights such as mentions, profile visits, top tweets, video content performance, conversion tracking, and follower growth. These insights help you improve your ad campaign and get better results.
Let’s elaborate!
Profile visits
You’ll find the number of Twitter profile visits on the top of your analytics dashboard. Your profile visits are measured over 28 days and updated every day. The report tells you how this number compares to the previous 28-day period.
A mini graph displays this data over time. With this data, you can tell if your visitors are increasing or decreasing on your profile. This way, you’ll plan and adjust your tweets as required.
Mentions
Like the profile visits metric, mentions also reflect data for 28 days and over time. This metric also displays your top mention each month, depending on the engagement. You’ll also have access to a link leading to the tweet for additional context.
Top Tweets
Top Tweet and top media Tweet depending on impressions are available each month on your main analytics dashboard. For a more detailed analysis, click on “View Tweet activity.” You’ll see the engagement broken down by profile clicks, link clicks, detail expands, and more.
Follower growth
Your dashboard has a follower section where you can monitor how many people follow you each day and how your following has changed in the last 30 days. Notice the days in which you gained or lost followers.
You can determine why you lost or gained followers on a particular day by checking what you tweeted that day.
Video content performance
If your content strategy involves videos, you can monitor your video views. You’ll also see how users are responding to the videos you post. The video content performance metric lets you know if people watch your videos to completion.
Conversion tracking
Followers can use their mobile phones to engage on your Twitter ads and then convert or buy a product with their laptops. When this happens, conversion tracking will correctly attribute it to your Twitter ad.
With this data, you can measure your return on ad spend. All you need to do is track what people do after viewing or engaging with your Twitter ads.
Twitter Ads report additional hacks
Keep the objectives in mind before providing insights. You want your campaigns to produce results that meet your expectations.
Otherwise, you must consider the segmentation, creatives, or bidding type. Discover any creative that is producing better results in terms of efficiency and/or cost.
Make sure your creative team is engaging with content.
Video metrics are handy when dealing with quartile analysis. Video View Rate (View-through rate) calculated by dividing video views by the Video Ads Impressions, video length, and completion rate are important metrics when running video ads.
To win on Twitter, you must engage your followers. If your engagement is low, you must reevaluate your call to action. Resources such as threads or polls can also help to increase the interaction.
Share your report
Looker Studio enables seamless sharing of reports to your clients or colleagues. It only takes a few steps. Firstly, you’ll need to click the “Share” button at the top right of your screen.
Once done, add the email address of the person with whom you want to share your report.
Conclusion
Looker Studio can automatically integrate with many different data sources online. By pulling analytics data from Twitter into Looker Studio, you can create helpful social media reports for your business.
The steps to getting Twitter ads data in Looker Studio are straightforward. You’ll need a powerful connector like Windsor.ai. Once you complete the setup, you’ll have access to helpful Twitter ads insights to improve your business.
Windsor.ai Connector allows seamless Looker Studio Twitter Ads integration. You’ll track your ad spend and only pay when you achieve your marketing goals. What’s more? Windsor.ai offers a 30-day free trial period with all features, allowing you to explore all the possibilities.
FAQ
How do I add Twitter to my Google Studio?
Firstly, you must create a Windsor.ai account and sign in with your Twitter account. Then authorize Windsor.ai Connector to pull data from your account API and start reporting on Looker Studio. Once done, you’ll need to choose the data sources to report and pull data.
Mark the options to pull your data and click the “Add” button. That’s all! You can now create scorecards and charts for your Twitter Ads campaigns on Looker Studio.
How to show Twitter on Looker Studio
Start by signing up with Google and Twitter Ads. Select the data sources to pull your data. Mark the options to pull your data and click the “Add” button.
You Might also Like to read:
Connect Your Data to Looker Studio
Looker Studio Twitter Ads Overview Report
7 Examples of Looker Studio Marketing Dashboards for Paid Campaigns
Templates for Twitter Ads and Looker Studio
Easy and safe Looker Studio + Twitter Ads integration with Windsor.ai
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.