Twitter ads are primarily used to engage a broad audience with real-time conversations and trending topics. By leveraging Twitter’s dynamic platform, businesses can reach users who are actively discussing news, events, and various interests. Posting ads on Twitter can drive significant user engagement, especially for campaigns focused on brand awareness, product launches, and timely promotions. With its extensive reach and active user base, Twitter offers a powerful tool for businesses to capture the attention of potential customers and followers.
If you haven’t installed Two Minute Reports yet, click on the link to learn how to install. Using Two Minute Reports (TMR) you can get your ads insight immediately to Google Sheets.
You get to view all of these ad insights without a single piece of code and that’s the best and easiest part of it. Just select your required metrics data to be shown and boom! You get the raw data in your sheet within a minute.
Step 1: Install and Launch Two Minute Reports
Install Two Minute Reports, if you have not done so already.
Sign in to any Google Sheet and go to Add-ons -> Get add-ons.
Search for Two Minute Reports and select Install.
Review and accept the permissions necessary to run Two Minute Reports. Two Minute Reports will be installed for you with the e-mail you are signing in to Google Sheets.
Open Google Sheets and go to Extensions -> Two Minute Reports -> Launch.
Step 2: Connect Your X (Twitter) Ad Account
- Go to the Data Source section in Two Minute Reports.
- Select X (Twitter) Ads from the drop-down or type it in the search bar.
- Click login with X (Twitter) and add your X (Twitter) Ad account as Data Source.
Step 3: Getting X (Twitter) Ads Performance Data in Google Sheets
To start getting your ad-relevant data into Google Sheets, you need to start creating queries. To add a new Data Query, click on Data Queries and click on Add new.
And now you can start creating your own Data Query using the drop-downs below. Create a name for your Data Query, and add the account of your choice. Add the date as well.
Select metrics that consist of vital data from X (Twitter) like Impressions, Top ads, Swipes, Swipe Rate, etc. Once you select your required Metrics, select dimensions according to your added Metrics.
Dimensions are used to group your Metrics in a particular aspect like Account Name, Ad ID, Account ID, etc. After selecting the dimension you need to select the date range for the data to be displayed. Once you select the date range, you can run the query and the query data will be displayed in the given location.
Once you get the data in your Google sheet, you can customize your data by adding Pivot tables, VLOOKUP(), Charts, and Graphs. By adding these you can create your personalized Dashboard.
Once your report is created you can create a Schedule in Google Sheets to automatically update your sheets and keep your data up-to-date. This feature is handy to send emails, or just refresh your spreadsheets with live data and use it as a Dashboard.
Step 4: (Optional) Schedule Automatic data Refresh and email
Once you have fetched data, you might want to get new data from your database at periodic intervals. You can do this by creating a new schedule under the “Schedule Reports” section. You can schedule updates hourly, daily, weekly, or monthly based on your needs.
You could also create a report and ask Two Minute Reports to email that report with updated data automatically. Under the email section enter the email ID of the recipients and save your new schedule.
When the time comes, Two Minute Reports will automatically fetch new data from your queries, and email your report to the said recipients. You have freed a lot of your time from mundane reporting tasks.
There are other features with the Two Minute Report’s schedule refresh or data refresh feature. You may read our guide How to Refresh Data Automatically in Google Sheets.
We hope you found this article helpful on how to get X (Twitter) ads in Google Sheets using Two Minute Reports. If you have any questions please feel free to comment below or contact our support team at support@twominutereports.com.