Summarize this blog post with:
You’re running Reddit Ads for multiple clients, but when someone asks for a quick performance update, you end up opening Reddit Ads Manager, exporting CSVs, and manually putting everything together.
And if you want to compare Reddit ads performance with Google or Meta, it becomes even messier.
The problem is that Reddit’s native dashboard has limitations. It’s difficult to build custom reports, track trends properly, or share a clean dashboard with clients.
By connecting Reddit Ads to Google Sheets using Two Minute Reports, your campaign data updates automatically in one place, making reporting and analysis easier. Let’s get started.
How to Connect Reddit Ads to Google Sheets?
You can connect Reddit Ads data to Google Sheets through the Two Minute Reports Hub. It is your centralized workspace for managing all your connectors, clients, and destinations. Here’s how to get started:
Step 1: Creating a Connection
1. Go to hub.twominutereports.com and click Add a Connection → Create Connection.
Note: If you're a first-time user, you'll see an Add a Connection button on the Hub homepage. If you already have connections set up, go to Connections → New Connection instead. Either way, the rest of the steps are the same.
2. Inside the dialog box, complete these three steps:
- Select the Reddit Ads connector from the list of available platforms.
- Enter the name for your connection and authorize it by logging in with your credentials.
- Enable the Reddit ads accounts for which you want to measure performance. Please note that you can’t query the disabled accounts.
Note: With Speedboost, you can handle high-volume Reddit Ads datasets and create blazing-fast reports without any delays. This is a proprietary technology of Two Minute Reports built to scale client reporting.
3. Once done, navigate to the Hub homepage and click Google Sheets → Connect to Google Sheets.
4. Click Use Template and follow the instructions to launch the Two Minute Reports add-on in your sheet.
Step 2: Configure and Run Your Query
1. Once you’ve installed the add-on, navigate to Menu → Data Queries and click Add.
2. Select your desired Reddit Ads account(s) from the sidebar.
3. Alternatively, go to Clients → Manage Clients, map the account details and click Save & Close.
4. Choose your Reddit ads metrics and dimensions and select your date range.
5. Click Run query to pull the data into your chosen sheet and cell.
Pro Tip: You can set up custom refresh schedules to automate daily, weekly and monthly Reddit ads performance reporting to your clients. Choose your preferred format – PDF, Excel or Spreadsheet and keep reports updated automatically without manually exporting data every time.
Prefer to work directly inside Google Sheets? You can also connect Reddit Ads by installing the Two Minute Reports add-on from the Google Workspace Marketplace, following the steps below:
- Launch the add-on from Extensions → Two Minute Reports → Launch.
- Click Menu → Connections → Add and select the Reddit Ads connector.
- Authorize your account and enable the toggle for the accounts you want to query.
- Click Refresh Connections to confirm your accounts appear in the sidebar.
Once connected, follow the same query steps above to start pulling your Reddit Ads data into your Google Sheets directly.
How to Analyze Reddit Ads data in Google Sheets?
Once your Reddit Ads data is connected to Google Sheets via Two Minute Reports, you're not just looking at a raw export; you're working with a wide range of metrics and dimensions that you can combine to build meaningful analysis. Here are the most valuable analyses you can run:
1. Campaign Performance Breakdown By Objective
Metrics: Impressions, Clicks, Amount Spent, CTR, CPC, eCPM
Dimensions: Campaign Name, Campaign Objective, Campaign Status, Date
Analysis: Aggregate spend and click data by Campaign Objective to understand which campaign types, such as awareness, traffic, or conversion, are delivering the best efficiency. Pair this with the Date dimension to track performance trends over time and quickly spot which objectives are pacing well against budget.
2. Video Creative Analysis by Engagement Depth
Metrics: Video Views, Full Video Views, Watches at 25% / 50% / 75% / 95% / 100%, Video Completion Rate, CPV, Plays with Sound.
Dimensions: Ad Name, Ad ID, Campaign Name, Date
Analysis: Break down video performance by ad to see exactly where viewers are dropping off. By comparing Watches at 25% vs.100%, you can identify whether your creative loses attention early or holds it all the way through. CPV, alongside Video Completion Rate, tells you whether you're paying for views that actually count.
3. Conversion Funnel Analysis by Action Type
Metrics: Click: Purchase, Click: Add to Cart, Click: Lead, Click: Sign Up, eCPA: Purchase, eCPA: Lead, Total Value: Purchase, Average Value: Purchase, Cart Size: Purchase.
Dimensions: Campaign Name, Ad Group Name, Ad Name, Date
Analysis: Map the full conversion funnel – from add-to-cart to purchase, using click-attributed conversion metrics. Compare eCPA across conversion types to understand your cost at each stage of the funnel, and use Total Value and Average Value: Purchase to calculate ROAS at the campaign or ad level.
4. Audience and Subreddit Segmentation
Metrics: Impressions, Clicks, CTR, Amount Spent, eCPM
Dimensions: Community Name / Gender
Analysis: The Community Name dimension lets you see which subreddits are driving the most engagement – a unique Reddit insight that helps you target the right audience within the platform.
5. Ad-level creative performance and status audit
Metrics: Impressions, Clicks, CTR, CPC, Amount Spent
Dimensions: Ad Name, Ad Status, Ad Configured Status, Ad Rejection Reason, Ad Click URL, Campaign Name.
Analysis: Pull a full ad-level report combining status and performance metrics to audit which ads are live, paused, or rejected and why. The Ad Rejection Reason dimension surfaces moderation issues directly in your sheet, saving you from checking Reddit Ads Manager manually.
Get Reddit Ads in Looker Studio
Connect Reddit Ads to Looker Studio and build detailed visual dashboards for your clients. The no-code integration syncs your Reddit campaign metrics automatically, so you can build branded, client-ready dashboards within minutes. It's the ideal solution for agencies that need polished visuals alongside the flexibility of Google Sheets. Explore the Reddit Ads Looker Studio dashboard to get started.
Ready to Connect Reddit Ads to Google Sheets?
You've seen what's possible – from subreddit-level engagement breakdowns to full conversion funnel analysis, all inside a Google Sheet that refreshes itself.
Two Minute Reports gives you access to all 100+ Reddit Ads fields, works alongside your other PPC platforms, and takes minutes to set up, whether you're managing 10 or 100+ accounts simultaneously.
Try Two Minute Reports free for 14 days and see how smarter and faster Reddit Ads reporting can be.
Frequently Asked Questions
Using Two Minute Reports, you can pull a wide range of Reddit Ads metrics, including impressions, CTR, spend, CPM, CPC, conversions, CPA, and video completion rate. You can also segment data by campaign, ad group, ad, date, subreddits, placements and audience. This gives you granular control over how your data is structured in Google Sheets so that you can build reports tailored to your specific client goals.
Once you've connected Reddit Ads and configured your queries, you can set up automated refresh schedules from the sidebar by selecting Menu → Schedule refresh. Choose daily, weekly, or monthly refresh intervals, preferred timezone and your updated reports will be sent automatically to multiple clients instantly.
Yes. Two Minute Reports supports data blending, which means you can connect and compare Reddit Ads data into the same Google Sheet with Google Ads, Meta Ads, LinkedIn Ads, and more. This makes it easy to build a unified cross-channel marketing report where you can compare spend, performance, and ROI across multiple platforms in one place.
Two Minute Reports is designed with agencies in mind. You can create separate connections for each client's Reddit Ads account, map them through the Clients panel, and run queries per account within a shared reporting workspace. Scheduled refreshes keep every client's data current, and you can use pre-built templates to spin up new client reports quickly without starting from scratch each time.
Yes. You can connect your Reddit ads account to Two Minute Reports by signing up for the 14-day free trial. You can explore all available features and functionalities without any upfront cost.
Meet the Author
Shalini MuruganShalini is driven by ideas that create a tangible impact. At Two Minute Reports, she specializes in content that helps marketers optimize their reporting workflows. When she's not transforming complex data into meaningful insights, you might find her lost in a book, jotting down ideas in her notebook, or connecting the dots others overlook.
