X Analytics (Twitter) Data Connector User Guide

X Analytics (Twitter) Data Connector User Guide

Info
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.


Prerequisites

  1. A free X Ads account is required to connect your X Analytics account to Power My Analytics
To create an X Ads account:
  1. Go to ads.x.com and click Sign in.



  2. Log in to your X account.
Notes
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 + New Data 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.
    1. 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 Looker Studio Report

Follow these steps to create a Looker Studio report using your X Analytics data:
  1. After adding X Analytics as a data source in the PMA hub, navigate to Reports > Looker Studio
  2. Select X Analytics under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
  3. Google Looker Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g., "X Analytics - Organization Name")
      2. Choose your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select your X Analytics account (real data) or "Sample Account" (sample data)
      2. Click Next
    3. Step 3:
      1. Click Connect (top right) to complete the data source configuration
    4. Step 4:
      1. Click Create Report (top right)
      2. 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.

Key Reports and Fields

Here are some popular X Analytics metrics you can use in your reports:
  • Key Performance Metrics: Tweets, Likes, Retweets, Followers, Tweet Like Count, Tweet Retweet count
  • Tweet Metrics: Tweet Like Count, Tweet Retweet count
For a complete list of available X Analytics fields in Power My Analytics, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Backfilling: Up to 2 years for non-lifetime data, with an initial backfill of 13 months when you first connect your X Analytics account as a data source.
  2. Lifetime metrics: The fields Followers, Following, Likes, Tweets, and Lists are lifetime values and cannot be backfilled.
  3. Ad account creation date: Individual tweet data is only available starting from the date your X Ads account was created.
  4. Organic metrics: Organic metrics are only accurate if they are less than 30 days old. After 30 days, no new data will be collected for these fields.

Unavailable Data

  1. Impressions
  2. Replies
  3. Clicks
  4. Realtime data
  5. Custom fields

Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the X Analytics connector.

    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • X Ads (Twitter) Data Connector User Guide

        X Ads (formerly Twitter Ads) is a powerful advertising platform that allows marketers to reach their target audience on one of the world's most popular social media networks. This guide will walk you through the process of connecting your X Ads ...

      • Pinterest Analytics Data Connector User Guide

        Pinterest Analytics provides valuable insights into your Pinterest account's performance, audience engagement, and content effectiveness. This guide will walk you through the process of setting up and utilizing Pinterest Analytics as a data source in ...

      • YouTube Analytics Data Connector User Guide

        YouTube Analytics provides valuable insights into your channel's performance, audience engagement, and content effectiveness. This guide will walk you through the process of connecting YouTube Analytics to Power My Analytics, creating reports, and ...

      • Mailchimp Data Connector User Guide

        Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...

      • GA4 Data Connector User Guide

        Google Analytics 4 (GA4) is a powerful web analytics platform that provides valuable insights into your website and app performance. This guide will walk you through the process of connecting GA4 to Power My Analytics, creating reports in Looker ...