Datapipe
Paid media managers
Check spend and return by campaign every morning.
Read & reportOwner-approved writesBeta
Connect X (Twitter) Ads campaign performance and spend to your reports.
Track impressions, link clicks, media spend, and conversion rates across active campaigns.
- Spend, results and return by campaign in one sheet
- Find the campaigns that cost more than they return
- A fresh campaign report before your morning check
Sheets
Looker Studio
BigQuery
Drive
CSV
Claude
ChatGPTStart free Connect X (Twitter) Ads
Updated November 2026
| Campaign name | Status | Impressions |
|---|---|---|
| Q4 Enterprise Lead Gen | active | 94,200 |
| Retargeting | Pending | 8,240 |
| Brand search | Refunded | 3,110 |
- SetupPaste a key or token
- Reads11 metrics and 6 ways to split them
- Changes1 owner-approved action
- RefreshDaily to every 15 minutes
Who uses Datapipe with X (Twitter) Ads
Ecommerce owners
See which ads actually bring orders.
Agencies
Send each client a clear ad report every month, without exporting.
What you can do with X (Twitter) Ads
Read and report
Read campaign impressions, link clicks, media spend, and web conversion metrics using your X Ads API token and account ID.
- Campaign performance
- Line items and pacing
- Promoted post engagement
Change with owner approval
- Update campaign status or daily budget
The owner reviews the exact values and approves every proposed change before it is applied to X (Twitter) Ads.
Full read details
Spend reflects account currency.
Examples for your team
Review campaign delivery pacing and acquisition cost
Monitor daily media spend, click-through rates, and cost per click across promoted tweet campaigns.
- Scheduled refresh
- Latest X (Twitter) Ads data
- Updated report
Update campaign status or daily budget
A team member proposes pausing an underperforming campaign or adjusting its daily budget cap.
- Proposed
- Owner approves
- Applied and logged
Limit: The owner verifies the campaign ID and new parameters before approving.
Fix things in X (Twitter) Ads without opening it
Spot it, fix it
See the problem in your report, then propose the fix in Datapipe instead of opening X (Twitter) Ads, finding the record and retyping it.
More people can help
Teammates and AI tools can suggest changes without getting edit access to X (Twitter) Ads.
Nothing changes without your yes
You see the current and proposed value side by side, and every change is logged.
Jobs you can stop doing by hand in X (Twitter) Ads
Update campaign status or daily budget
Emergency pause on social advertising campaign exceeding target cost per acquisition
TodayLog in to X Ads Manager, locate campaign #tw_cmp_101, and toggle status to paused.
With DatapipeCatch spike in acquisition costs in your morning report, propose emergency pause, and media buyer approves after review.
Increase daily spend budget cap after high-converting promoted post launch
TodayOpen campaign settings in X Ads, edit daily budget field, and save changes.
With DatapipeIdentify positive conversion surge in your daily ads dashboard, propose increasing daily cap from $250 to $500, and media director approves after review.
Exactly what this can change
Updates the running state or daily budget cap of one X (Twitter) Ads campaign. Bidding strategy and targeting parameters are preserved. Every change requires owner approval.
Supported fields: Campaign status, Daily budget (in micros, e.g. 250000000 for $250.00).
Update campaign status or daily budgetCampaign · Q4 Enterprise Lead Gen (#tw_cmp_101) · proposed by Jordan Blake
| Field | Current value | Proposed value |
|---|---|---|
| Status | active | paused |
Every team member's change needs owner approval
- Owner turns on an action
- A teammate or AI tool proposes
- Check the current and proposed values, then approve that individual change
- Applied once and logged
Source changes use the separate Actions & approvals workflow in Datapipe. AI tools such as ChatGPT can propose changes but never approve them. Who can turn this on?
Provider rules and limits
Provider permissions still apply, and automations in X (Twitter) Ads may react to approved changes.
Only fields supported by an enabled action can be proposed; some actions also support individual owner-selected writable fields.
Before you connect
What you need
Enter your advertising account key and Account identifier.
Read and write
Read access for reports. The change action needs edit access in X (Twitter) Ads and stays off until the owner turns it on.
Limits and exclusions
Anything your connected account cannot see in X (Twitter) Ads.
Full details and limits
Promoted campaign performance, impressions, destination link clicks, media spend, and web conversion counts.
Reporting reads campaign metrics and promoted posts. Campaign status and daily budget cap updates require owner approval.
Reports you can build
3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
- Campaign performance
- Line items and pacing
- Promoted post engagement
What each dataset reports
- Campaign performance
Impressions, link clicks, media spend, conversions, CTR, and CPC.
- Line items and pacing
Ad line items, bidding amounts, daily budgets, and delivery status.
- Promoted post engagement
Promoted post impressions, reposts, likes, and destination URL clicks.
Metrics and dimensions
11 metrics and 6 ways to split them.
Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.
No fields match. Try another search or choose All.
Send X (Twitter) Ads data anywhere
Google SheetsA sheet that refreshes every morning.Looker StudioCharts that read the same numbers.BigQueryA warehouse table for the same columns.Excel / CSVA Drive file you can open in Excel.ClaudeAsk Claude about these numbers in a sentence.ChatGPTAsk ChatGPT about these numbers in a sentence.APIRead the same rows from your own tool.Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.Ask AI about your data
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
AI tools can also propose a X (Twitter) Ads change. Only the owner can approve it.
Which X Ads promoted campaigns had the lowest cost per conversion while maintaining click-through rate above 1.5%?
The Q4 Enterprise Lead Gen campaign achieved a $24.80 CPA with a 1.95% CTR ($80.00 average order values), delivering 68 total conversions.
Better than exporting by hand
- It refreshes on its own, so nobody pastes in a new export.
- Each campaign can be its own row.
Start from a goal
Campaign performance
Impressions, link clicks, media spend, conversions, CTR, and CPC.
Use this template →Line items and pacing
Ad line items, bidding amounts, daily budgets, and delivery status.
Use this template →Promoted post engagement
Promoted post impressions, reposts, likes, and destination URL clicks.
Use this template →How it works
Create a project and choose X Ads in Data sources.
Enter your advertising account key and Account identifier.
Pick where it goes. Choose campaign performance, line items, or promoted tweets and a destination.
Sample report
Sample range Oct 1–Oct 29. Each row is one campaign.
| Campaign name | Status | Impressions | Clicks | Media spend | Line item name | Campaign objective | Bid amount |
|---|---|---|---|---|---|---|---|
| Q4 Enterprise Lead Gen | active | 94,200 | 1,840 | $80.00 | 1,240 | Spring sale | $420.00 |
| Retargeting | Pending | 8,240 | 410 | $125.50 | 640 | Retargeting | $980.00 |
| Brand search | Refunded | 3,110 | 155 | $42.00 | 210 | Brand search | $160.00 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Works well with X (Twitter) Ads
Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.
X (Twitter) Ads + Shopify“Is ad spend rising faster than orders?”See Shopify →
X (Twitter) Ads + Google Analytics“Do ad clicks show up as site visits?”See Google Analytics →
X (Twitter) Ads + HubSpot“Did the new campaign bring more deals?”See HubSpot →
X (Twitter) Ads + Stripe“How does ad spend compare with the revenue you collected?”See Stripe →Questions
Free to start. Paid plans add more data sources and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.
No. Name a project, add a data source, then choose a report and destination.
Only the workspace owner. Writes start disabled. The owner enables permitted actions and eligible teammates: owner only, all project operators and managers, or selected teammates. The owner can change this at any time, and saving new settings cancels pending proposals.
No. Teammates propose in Datapipe, and approved changes are applied through the connected X (Twitter) Ads account. Nobody else gets a X (Twitter) Ads login from this.
They can propose a change through Datapipe, the same way a teammate can. They can never approve it. Only the owner approves, in Actions & approvals.
Datapipe sends each approved change once and logs the result. If it cannot confirm that X (Twitter) Ads received it, the request is marked Uncertain and is never retried automatically, so you can check X (Twitter) Ads first.
Yes. Datapipe reads the reports on this page and can make one kind of change: update campaign status or daily budget. Each one stays off until the owner turns it on, and every proposed change needs the owner's approval. Provider permissions still apply.
This page lists 11 metrics and 6 ways to split them. You pick the columns when you build the report.
Promoted campaign performance, impressions, destination link clicks, media spend, and web conversion counts. Account permissions and the records available from the provider determine which rows can be read.
One for each X (Twitter) Ads account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
Try X (Twitter) Ads with sample data first
Build the report first, then add X (Twitter) Ads when you are ready.