# X Analytics (Twitter) Data Connector User Guide

> **Note:** X Analytics (formerly Twitter Analytics) is a powerful data source that provides valuable insights into your X account's performance, audience engagement, and tweet activity. This guide will walk you through the process of setting up X Analytics as a data source in Power My Analytics, creating reports, and understanding key metrics and limitations.

![](https://knowledge.powermyanalytics.com/application/sources/images/twitter-analytics-data-connector-user-guide-1.png)

## Prerequisites

- An [X Ads account](https://business.x.com/en/help/account-setup/ads-account-creation) is required to connect your X Analytics account to Power My Analytics
- Your account with X Ads must have an [active X Premium subscription](https://help.x.com/en/managing-your-account/about-x-verified-accounts) (blue checkmark)

To create an X Ads account:

1. Go to [ads.x.com](https://ads.x.com/) and click **Sign in**.

    ![](https://knowledge.powermyanalytics.com/application/sources/images/twitter-analytics-data-connector-user-guide-2.png)
2. Log in to your X account.

> **Note:** Individual tweet data will only be accessible starting from the date your ad account was created.

## Adding X Analytics as a Data Source

1. Make sure you are logged in to the X account you want to connect as a data source.
2. Navigate to your Hub and select **Sources** from the menu.
3. Click **\+ Add new source** and choose X Analytics from the gallery.
4. Sign in to your X account to authenticate and authorize Power My Analytics to access your account.

    - If the X authorization popup shows an X account other than the one you want to connect, log out of that account and log into the X account you're trying to connect.

## Creating a Data Studio Report

Follow these steps to create a Data Studio report using your X Analytics data:

1. After adding X Analytics as a data source in the PMA hub, navigate to **Reports > Data Studio**
2. Select X Analytics under Create Data Studio Report (this will open the official Data Studio application in a new window)
3. Google Data Studio Configuration:

    - Step 1:

        - Name your data source (e.g., "X Analytics - Organization Name")
        - Choose your Power My Analytics hub from the dropdown
        - Optional: Leave "Use report template for new reports" checked to use the PMA demo template
        - Click **Next**
    - Step 2:

        - User Account: Select your X Analytics account (real data) or "Sample Account" (sample data)
        - Click **Next**
    - Step 3:

        - Click **Connect** (top right) to complete the data source configuration
    - Step 4:

        - Click **Create Report** (top right)
        - Include "today" in your report's date range to begin historical data storage

For a quick start, use our pre-built [X Analytics demo template](https://lookerstudio.google.com/reporting/bd6dcf46-d254-4623-9547-48e6b1d8686f).

## Key Reports and Fields

Here are some popular X Analytics metrics you can use in your reports:

- **Account metrics (lifetime totals):** Followers Count, Friends Count (accounts you follow), Statuses Count (posts), Listed Count, User Favourites Count (posts the account has liked)
- **Post metrics (Tweets table, running total per post):** Tweet Like Count, Tweet Retweet Count
- **Organic post metrics (Tweets Organic table, per post per day):** Impressions, Engagements, Clicks, Link Clicks, Likes, Reposts, Replies, Follows, Unfollows, Card Engagements, Poll Votes
- **Organic video metrics (Tweets Organic table, per post per day):** Video Views, Video Starts, Video Played 25%, Video Played 50%, Video Played 75%, Video Completions, 3s/100% Video Views

For a complete list of available X Analytics fields in Power My Analytics, refer to the [Schema Explorer](https://hub.powermyanalytics.com/resources/schema/twitter_analytics).

## Limitations and Important Considerations

- **Cached Data Requests with Unique Metrics and Date Dimension:** When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For more information, please see [Understanding Cached and Live Data Requests](https://knowledge.powermyanalytics.com/support/faq/understanding-cached-and-live-data-requests/#a-special-case-unique-metrics-paired-with-the-date-dimension).
- Backfilling: An initial backfill of 24 months of data will be performed when you first connect your X Analytics account as a data source. The Tweets Organic metrics load up to one year (see **Organic post metrics** below).

- **Lifetime metrics:** The account-level fields Followers, Following, Likes (posts the account has liked), Tweets, and Lists are lifetime values and cannot be backfilled.
- **Ad account creation date:** Individual tweet data is only available starting from the date your X Ads account was created.
- **Organic post metrics:** The Tweets Organic metrics are collected every day for each post during its first 90 days after it's published. Each row is one post on one day, dated in your X Ads account's time zone; a day on which a post had no activity has no row. When you first connect X Analytics, this table loads up to one year of history. To load older dates for a source you connected earlier, run a manual backfill from your Hub.
- **Organic activity only:** The Tweets Organic metrics count organic activity. If you also promoted a post, its paid impressions and engagements are in the [X Ads (Twitter) connector](https://knowledge.powermyanalytics.com/application/sources/twitter-ads-data-connector-user-guide/).
- **Daily counts and running totals:** Likes, Reposts, and Replies count the activity a post received each day. Tweet Like Count and Tweet Retweet Count are each post's running totals, dated by the day the post was published, so a date range selects the posts published in that range rather than the activity that happened in it. To report likes or reposts received within a date range, use Likes and Reposts.
- **Link Clicks:** Link Clicks matches the link clicks figure in X Analytics. X doesn't provide URL clicks for organic posts.
- **Rate metrics:** Engagement rate and other rates aren't available as fields. You can create them in Data Studio as calculated fields, for example `SUM(Engagements) / SUM(Impressions)`.

### Unavailable Data

- URL clicks for organic posts (use Link Clicks)
- Bookmarks, shares, and video watch time
- Separate counts of profile clicks, hashtag clicks, and detail expands (these are included in Clicks)
- Reply Count and Quote Count (X doesn't return these counts to Power My Analytics; for replies, use Replies)
- Realtime data
- Custom fields

## Troubleshooting

See our article [Basic Troubleshooting](https://knowledge.powermyanalytics.com/application/troubleshooting/basic-troubleshooting/) for information on issues that may affect the X Analytics connector.
