twitter ads Field Reference logo

+

 

 

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.

Start Free Trial

Twitter Ads metrics and dimensions

Label

Description

Name

Type

Data Type

Tables

Account Name

The name of the account.

configName

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

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

 

Account Status Text

The actual text of the status update.

status_text

DIMENSION

STRING

  • account

 

Account Status Retweet Count

The number of times this status has been retweeted.

status_retweet_count

METRIC

 

NUMBER

  • account

 

Author ID

The integer representation of the unique identifier for this user.

author_id

DIMENSION

STRING

 

  • tweets

All Media

Represents media elements uploaded with the Tweet.

all_media

DIMENSION

STRING

 

  • tweets

Date

The dimension that determines how date-based data in a chart is handled.

date_actual

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

Data Source

Data source title.

dataSource

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

Data Freshness

 

dataFreshness

DIMENSION

STRING

  • account
  • tweets
  • tweets_organic

Date And Time

The dimension that determines how date-based data in a chart is handled (the time dimension).

date

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

 

Day Of Week

The dimension that determines how date-based data in a chart is handled.

day_of_week

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

Day Of Month

The dimension that determines how date-based data in a chart is handled.

day_of_month

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

 

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

 

  • account

 

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

 

  • account

 

Hour

The dimension that determines how date-based data in a chart is handled.

hour

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

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

 

  • account
  • tweets
  • tweets_organic

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

 

  • account
  • tweets

·         tweets_organic

PMA Is Interpolated?

Used by Power My Analytics to indicate whether lifetime data might be interpolated

isInterpolated

 

BOOLEAN

  • account
  • tweets
  • tweets_organic

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

 

  • account

 

PMA Maximum Cached Data Date

Used by Power My Analytics to indicate maximum cached data date.

MaxDate

DIMENSION

STRING

 

  • account
  • tweets

·         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

 

  • account
  • tweets
  • tweets_organic

 

PMA Minimum Cached

Data DateUsed by Power My Analytics to indicate minimum cached data date.

MinDate

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

PMA Trial Status

Used by Power My Analytics to show trial as Active, Expired, or the number of days remaining.

Trial

 

STRING

 

  • account
  • tweets
  • tweets_organic

 

PMA Subscription ID

Used by Power My Analytics for billing and user-identification with our support staff.

Subscription

 

STRING

 

  • account
  • tweets
  • tweets_organic

 

Statuses Count

The number of Tweets (including retweets) issued by the user.

statuses_count

METRIC

NUMBER

  • account

 

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

 

  • account

 

Quarter

The dimension that determines how date-based data in a chart is handled.

quarter

DIMENSION

STRING

  • account
  • tweets
  • tweets_organic

Tweet ID

The integer representation of the unique identifier for this Tweet.

tweet_id

DIMENSION

STRING

  • tweets
  • tweets_organic

 

Tweet Retweet Count

The number of times this Tweet has been retweeted.

retweet_count

METRIC

NUMBER

 

  • tweets

 

Tweet Like Count

Indicates approximately how many times this Tweet has been liked by Twitter users.

favorite_count

METRIC

NUMBER

 

  • tweets

 

Tweet Text

The actual Tweet text.

text

DIMENSION

STRING

 

  • tweets

 

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

 

  • account

 

URL

 

url

DIMENSION

STRING

  • tweets

Week

The dimension that determines how date-based data in a chart is handled.

week

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

Year Month

The dimension that determines how date-based data in a chart is handled.

month

DIMENSION

STRING

  • account
  • tweets

·         tweets_organic

Year

The dimension that determines how date-based data in a chart is handled.

year

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

Year Quarter

The dimension that determines how date-based data in a chart is handled.

year_quarter

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

Year Week

The dimension that determines how date-based data in a chart is handled.

year_week

DIMENSION

STRING

 

  • account
  • tweets
  • tweets_organic

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.

Sign up for Windsor.ai today!

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

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.