Analyze Twitter X Ads Report Data in Seconds
When you need to analyze Twitter X Ads report data, the exports arrive as CSV files with campaign performance, spend data, and engagement metrics across multiple date ranges and ad formats. The column structure changes depending on which report type you download—promoted tweets use different fields than follower campaigns, and the billing export is separate from performance data. DataMimi reads these exports and prepares them for analysis in under a minute.
Upload your Twitter X Ads CSV and get clean data ready for pivot tables, with all campaigns reconciled and metrics converted to numbers—no formulas required.
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| Campaign name |
| Ad group name |
| Tweet ID |
| Impressions |
| Engagements |
| Spend (USD) |
| Results |
| Cost per result |
| Engagement rate |
| Video views |
| Link clicks |
| Follows |
| Date |
Common questions
How do I analyze a Twitter X Ads report with multiple campaigns?
Upload the CSV and the tool separates performance by campaign automatically, handling renamed campaigns by matching on campaign ID rather than name. It converts currency and percentage columns to numbers so you can sum spend and average engagement rates without formula errors.
Why do my Twitter Ads totals not match the dashboard?
The CSV export rounds decimals differently than the web interface, and if you renamed campaigns mid-flight, Excel counts them twice. The tool reconciles campaign IDs to group renamed campaigns together and preserves full decimal precision from the export.
Can I compare performance across different date ranges?
Yes. Upload exports from different periods and the tool tags each row with its download date, then lets you filter or group by time period. It handles overlapping date ranges without double-counting campaigns that appear in both files.
How do I calculate true cost per engagement across all ad groups?
The tool converts text percentages and currency strings to numbers, then calculates total spend divided by total engagements. It excludes rows where engagements are zero to avoid divide-by-zero errors that stop Excel formulas.
What if my export includes video view data and link click data in the same file?
Different ad formats populate different result columns—video ads fill 'Video views' while link ads fill 'Link clicks'. The tool identifies which result type each row represents and calculates cost per result using the correct column for that ad format.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file