Free X Ads (Twitter Ads) to BigQuery Connector by OWOX: Automate Your Campaign Reporting Workflow

Running ads on X (formerly Twitter) is easy. Getting clean, structured campaign data from Twitter Ads to BigQuery? Not so much.

If you’ve ever tried exporting Twitter to Google BigQuery for analysis, you know the pain: manual CSV exports, rate limits, incomplete fields, and clunky integrations.

We believe it shouldn’t be this hard.

With this free, no-code Twitter to BigQuery connector from OWOX Data Marts (Community Apps Script Edition), you can automatically import and refresh raw performance data in minutes, not hours. And best of all? You keep full control and visibility into every metric, with the freedom to build your own BigQuery to Twitter reporting workflows.

Note: Twitter Ads has been rebranded to X Ads following the platform's name change in 2023. In this article, we use both terms interchangeably to help you familiarize yourself with either name.

Why We Made This Free Connector

At OWOX, we believe businesses shouldn’t have to rent access to their own data.

That’s why we built this Twitter Ads to BigQuery connector – and made it 100% free. No upgrades, no hidden fees, no locked features.

Driven by our mission to make data ownership simple and accessible, we want marketers and analysts to move away from black-box tools. You deserve transparency, flexibility, and control – and this Twitter to BigQuery connector gives you just that.

Whether you're a performance marketer, a startup founder, or a data analyst tired of repetitive workarounds, this tool helps you reclaim full access and control over your advertising data.

💡 Join the Open-Source Movement

We’re not just releasing a free connector – we’re inviting you to help shape the future of open marketing analytics tools.
At OWOX, we believe that data access and transparency should be a right, not a luxury. That’s why this connector is 100% open-source – giving you full control over how it works, what it does, and how far it can go.

If you like what we do, please ⭐ star our GitHub repo to show your support – it helps us reach more analysts and grow the number of available connectors.

Also, feel free to:

• Explore the code and customize it to fit your needs.
• Contribute to this data connectivity ecosystem: suggest new connectors, pull new connectors, and/or provide documentation to support the wider community.
• Join our community & share your feedback.

We’ve built the core, the foundation – now it’s your turn to take it further. 

Why Choose This Free Connector by OWOX 

Most tools that promise to move Twitter (X) Ads data into BigQuery come with trade-offs: paywalls, data limits, restricted access to fields, or black-box systems you can’t customize.

Some depend on third-party middleware. Others funnel your data through rigid pipelines or force you into fixed dashboards.

This connector avoids all that.

• 100% free and open-source – not a trial, not a stripped-down version. Full functionality from day one.
• Supports complete field selection – pick only the metrics and dimensions you need, as defined by the Twitter Ads API.
• Runs via Google Apps Script – no separate infrastructure, just a lightweight solution that works where your analysts already do.
• Fully transparent – inspect, customize, or extend the code anytime you want

If you’re frustrated by tools that charge per ad account, limit access, or obscure their process, this free Twitter to BigQuery connector from OWOX Data Marts (Community Apps Script Edition) is the simpler, cleaner choice.

Why Send Twitter Ads Data to BigQuery?

Twitter Ads Manager (X Ads) is great for launching campaigns, but falls short when it comes to custom reporting, large-scale data processing, or joining datasets across platforms.

❌ Reporting metrics are locked into pre-set views
❌ CSV exports expire quickly and don’t scale
❌ No native way to connect with GA4, CRM, or spend data

That’s why this free Twitter Ads to BigQuery connector exists.

✅ Send raw campaign and performance data from Twitter to Google BigQuery
✅ Combine it with other datasets to build end-to-end marketing analysis
✅ Structure your own attribution models, LTV analysis, and custom ROAS logic

With full control over schema, filters, and refresh logic in BigQuery, digital analysts and marketing teams get exactly the data they need, without compromise. 

Discover more free connectors:
Liking the freedom of custom reports? Take it further with these plug-and-play integrations:

‍Twitter Ads → Sheets
‍Facebook Ads → BigQuery
‍TikTok Ads → BigQuery
LinkedIn Ads → BigQuery

No fees, no code—only faster, smarter reporting across every ad channel.

Google BigQuery

Data sources

Free X Ads (Twitter Ads) Connector to Google BigQuery

Download template

How the Connector Works

The Twitter to BigQuery integration is built using open-source Google Apps Script, no third-party platforms, no code required, and no hidden limits.

Here’s how it works:

• Connects directly to the X Ads (formerly Twitter Ads) API and sends structured data into your BigQuery project.
• Supports custom selections of fields, metrics, dimensions, and time ranges, including control over data aggregation and time zones.
• Data lands directly in your BigQuery tables, ready for querying, blending, and modeling.

Whether you're managing in-house analytics, building marketing dashboards, or powering campaign insights with SQL, this Twitter to Google BigQuery connector helps you:

• Skip the vendor lock-in and API complexity
• Automate data collection from X Ads at scale
• Enable clean, flexible reporting in BigQuery

You control the connector, your BigQuery dataset, and your Twitter ads data from start to finish.

Step-by-Step: Import Twitter Ads Data to BigQuery

This is where things get powerful. In just minutes, your Twitter (X) Ads data can start flowing into BigQuery, no code, no blockers, just clean, structured data ready for analysis and reporting.

Let’s walk through the setup process step by step.

Step 1: Copy the BigQuery Template 

Start by using our pre-built BigQuery template – no need to set everything up manually.

1. Access the Template
   Open the “X Ads → BigQuery” template provided by OWOX.
2. Make Your Own Copy
   Go to File → Make a copy to save it directly to your own Google Drive.

‍

Master Twitter Ads → BigQuery Reporting With Our Free Template!

Say goodbye to CSV exports and complex APIs – this plug-and-play BigQuery template lets you pull Twitter Ads data effortlessly.

Download your FREE template today!

Step 2: Configure the Source (~1 min)

Configure your import parameters in the “Config” sheet to control what data you bring in and from when.

1. Set the Start Date

• Select how far back you'd like to retrieve data.
  Tip: Using a shorter date range helps avoid timeouts during import.

2. Add Your Account ID(s)

• Log in to https://ads.x.com.
• The account ID is in the URL after /campaign_form/.
  Example: https://ads.x.com/campaign_form/18ce55in6wt/campaign/new
  Account ID = 18ce55in6wt 

3. Choose Your Data Field

Go to the “Fields” tab and check the boxes of all the fields you want to import based on your reporting needs.  

4. Configure the BigQuery destination fields:

• Destination Dataset ID in the format: projectid.datasetid
• Destination Location matching your BigQuery region (e.g., US, EU)

If the dataset doesn’t already exist, it will be created automatically during the import process.

Further, specify the following parameters in the sheet:

• ReimportLookbackWindow: Days to look back when reimporting data (default: 2)
• MaxFetchingDays: Max number of days to fetch per run (default: 31)

Step 3: Get a Twitter Ads Access Token (~30 seconds)

To link the template with your Twitter (X) Ads account, you’ll need four credentials: API Key, API Secret, Access Token, and Access Token Secret. Here's how to generate them safely.

1. Visit the Twitter Developer Portal

• Sign in to developer.x.com. 

• A default app is created for you automatically. 

Note:  If prompted to upgrade your account, choose the Free tier to proceed without charges.

 2. Request Ads API Access

You’ll need to request access to the X (Twitter) Ads API before using the connector.

• Fill out the official X Ads API Access Request Form.
• Alternatively, you can message @AdsSupport for assistance. 
• Provide your App ID (found on your app’s detail page).

• In the form, describe how you’ll use the API. For example:
  

“We are advertisers looking to connect with the X Ads API to access campaign data for analysis and optimization. The data will be pulled via the OWOX Data Marts platform and used to support strategic decision-making across our marketing efforts.”

• For “What level of Ads API access do you need?”, choose: Standard Ads API access. 

• After submitting, monitor your email inbox for approval. You’ll receive a confirmation once your X Ads API access is granted.

       3. Configure Your App

• Navigate to the app’s User Authentication Settings.
• Click Edit.

• Under App Permissions, select: Read and write.

• Set Callback URI to: http://localhost.
• Leave all other fields as default.
• Click Save.

4. Generate API Keys
Navigate to the “Keys and Tokens” tab:

• Click “Regenerate” under API Key and API Secret, then save both values.
  These are your Consumer Key and Consumer Secret 

5. Get Request Token (via OAuth 1.0)

Using a tool like Postman:

• Make a POST request to: https://api.twitter.com/oauth/request_token
• Use OAuth 1.0 in the Authorization tab:
  
  
  • Signature Method: HMAC-SHA1
  • Consumer Key 
  • Consumer Secret 
  • Callback URL: http://localhost

• Click Send.

The response will look like: 

oauth_token=E4MQKQAAAAAB1yCFAAABl2OHH80&oauth_token_secret=UlDQaqOoJHj1VvLQ8fQH6Iq686rEFww2&oauth_callback_confirmed=true

• From the response, copy the oauth_token  (E4MQKQAAAAAB1yCFAAABl2OHH80 )  and insert it into:
  https://api.twitter.com/oauth/authorize?oauth_token=YOUR_OAUTH_TOKEN

• Open this URL in your browser and click Authorize App.

• You’ll be redirected to a new URL containing:
  
  • oauth_token
  • oauth_verifier

6. Get Permanent Access Token

Back in Postman:

• Make a POST request to: https://api.twitter.com/oauth/access_token
  
  
• Use OAuth 1.0 with the following:
  
  • Consumer Key: your API Key
  • Consumer Secret:  your API Secret
  • Access Token: oauth_token
  • Access Token Secret: oauth_token_secret
  • Verifier: oauth_verifier 
  • Callback URL: http://localhost 

• Click Send. 
• You’ll get a response containing your final credentials.
  
  • oauth_token=1534231826281152515-kDGnM70as1fh6xoYWK9HvlwtDHHqe8&
  • oauth_token_secret=KiXVKSyHifVoVm7vq3iC7zjclE1ocqvgpouS95RuLXM61&user_id=1534231826281152213&screen_name=examplename

You now have all the required credentials:

• Consumer Key (API Key)
• Consumer Secret (API Secret)
• Access Token (oauth_token)
• Access Token Secret (oauth_token_secret)

Step 4: Input Access Token into the Template ( ~10 seconds)

Connect your template to X Ads using the credentials you created earlier.

1. Open the Credentials Panel

• In your copied BigQuery template, navigate to the top menu and select: OWOX → Manage Credentials.

2. Authorize the App Script

When prompted:

• Click "OK" to allow the Apps Script to authorize and access your Google Sheet.
• This enables the connector to fetch and insert data. 

3. Add Your Token Details

• Paste your Access Token and Access Token Secret into the form.

• Click Save.
  
  

This step activates the connector with the correct credentials.

Step 5: Run the Connector & Import Your Data ( ~1 min)

Now, you're all set to load your data.

1. Start the Import

• From the spreadsheet menu, go to: OWOX → Import New Data.

• The connector will start pulling data from your specified X Ads account(s).

2. Once the process completes, look for the message “Import is finished” in the Logs sheet. 

Using this Google BigQuery template, the imported data will be stored in the dataset you defined earlier in the configuration settings. 

📊 Real-Time Reporting with OWOX Reports

Want to go beyond raw Twitter Ads data in BigQuery?

Use the OWOX Reports Extension for Google Sheets to turn your Twitter to Google BigQuery data into actionable, visual reports – without writing SQL or setting up Looker Studio.

With OWOX Reports, you can:
📥 Seamlessly pull Twitter Ads data from BigQuery into Google Sheets
📊 Create refreshable dashboards your team can actually use
✅ Give stakeholders real-time access to performance metrics that matter

No manual exports, no code, no delays. Just fast, reliable reporting built for marketing and data teams.

What’s Next?

This free Twitter to BigQuery connector from OWOX Data Marts (Community Apps Script Edition) brings us one step closer to making data ownership straightforward, transparent, and accessible for everyone, without costly tools or complex engineering.

Check out the additional resources below:
🔗 More free connectors – including Microsoft Ads, Reddit Ads Connector for BigQuery, so you can centralize all your paid media data in BigQuery without switching tools.
🎥 Step-by-step video tutorials – designed to walk you through setup and usage, whether you’re a beginner or a seasoned analyst.
📊 Prebuilt dashboards – so you can plug your Twitter Ads data into proven reporting templates and get campaign insights faster.

Explore our GitHub repo, leave us a ⭐ star, and join us in building a more open, analyst-friendly data stack.

Google BigQuery

Data sources

Free X Ads (Twitter Ads) Connector to Google BigQuery

Download template