Send Reddit Ads data to Google Sheets
Load Reddit Ads into your data warehouse first, put community-led spend next to the other paid channels, then send the answers to Google Sheets on a schedule. The sheet stays tied to your source of truth, not to an API token.
The Reddit Ads tab in the team's sheet is pasted from the ad account and stale by Tuesday.
Paste this into your AI assistant. It loads Reddit Ads into your data warehouse with OWOX Data Marts, puts it next to your other paid channels, and sends a sheet that refreshes on a schedule.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/free-reddit-ads-connector-to-google-sheets.md. The task: send a Google Sheets report of Reddit Ads spend, clicks and conversions by campaign and week, next to my other paid channels, refreshed every Monday from the Data Mart in my data warehouse. Tag the links you give me with utm_campaign=ai-task and utm_term=m4. Use what you know about my context and goals
Reddit Ads Endpoints
18 Reddit Ads endpoints you can import. Each lands in its own table in your data warehouse.
Ad Account
Your ad account settings — currency, attribution windows, and account type.
17 fieldsAd Account User
The authenticated Reddit Ads user — identity and contact details.
7 fieldsAd Groups
Ad groups within your campaigns — bid strategy, goal, targeting, and schedule.
27 fieldsAd Performance
Daily ad performance — impressions, clicks, spend, conversions, and ROAS.
55 fieldsTime seriesAd Performance by Account
Daily ad performance broken down by ad account.
56 fieldsTime seriesAd Performance by Ad Group
Daily ad performance broken down by ad group.
56 fieldsTime seriesAd Performance by Campaign
Daily ad performance broken down by campaign.
57 fieldsTime seriesAd Performance by Community
Daily ad performance broken down by subreddit (community).
56 fieldsTime seriesAd Performance by Country
Daily ad performance broken down by user country.
56 fieldsTime seriesAd Performance by DMA
Daily ad performance broken down by Designated Market Area (DMA).
56 fieldsTime seriesAd Performance by Interest
Daily ad performance broken down by user interest targeting.
56 fieldsTime seriesAd Performance by Keyword
Daily ad performance broken down by keyword.
56 fieldsTime seriesAd Performance by Placement
Daily ad performance broken down by ad placement.
56 fieldsTime seriesAds
Individual ads — type, status, and links to their campaigns and posts.
24 fieldsCampaigns
Your campaigns — objective, status, spend cap, and account association.
15 fieldsCustom Audiences
Custom audiences built from your user lists — type, status, and size estimates.
9 fieldsFunding Instruments
Payment methods linked to your campaigns — credit limits and current outstanding balance.
9 fieldsLead Gen Forms
Lead generation forms shown in your ads — prompt text and creation details.
8 fields
Why Reddit Ads does not go straight to Google Sheets
A direct link gives you a copy of the ad account in a sheet. It shows what Reddit Ads spent, not how that spend compares with your other channels or which visits turned into customers. A sheet is not built to join them reliably, at scale or business-ready, so the join happens in a warehouse first.
- Reddit Ads reports what a community campaign cost, not what it brought in
- The data analyst puts Reddit Ads next to the other ad platforms and links it to web analytics by SQL keys
- Stakeholders keep the sheet they like, now tied to your source of truth
Step 1: Load Reddit Ads into your data warehouse first
Create a Data Mart with Reddit Ads as the source and choose where the data lands. It works with any popular data warehouse.
- 18 endpoints and 675 fields to choose from, each endpoint in its own table
- Reports by campaign, community, keyword, interest and more
- Open the Reddit Ads connector for your data warehouse below
Step 2: Put Reddit Ads next to your other channels
In your data warehouse the model merges Reddit Ads with your other ad platforms, then joins web analytics by a campaign key. Pick an industry to see the shape of its model.
- Community-led spend sits in the same table as the larger paid channels
- Sessions, orders and subscriptions join by SQL keys, not VLOOKUP
- Measures such as platform_roas are defined once
Step 3: Send Reddit Ads data to Google Sheets
Connect a Sheets report to the Data Mart. Aliases and field descriptions arrive as notes in the column headers, so everyone reads spend, impressions and clicks the same way.
- The sheet reads your data warehouse, not the Reddit Ads API
- Hover a header to see what the field means
Step 4: Refresh your Reddit Ads sheet on a schedule
Set a scheduled refresh once. Daily is the usual choice and hourly is possible when you need it.
- Every refresh is logged in Run History
- Stakeholders open a sheet that is already up to date
Step 5: Reuse Reddit Ads inside OWOX MCP
The same Data Mart works in OWOX MCP, your assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.
- Ask in plain words; the answer comes from your data warehouse
- Define the numbers once and every report reads them
- 0.44.0Connector Data Marts set up through MCP no longer fail their first run because of the table path
- 0.44.0Backfill a catalog for any period in one run, and follow a long backfill as parts of one operation
- 0.41.0Rotating a connector key is one change: Sources share reusable Credentials
- 0.41.0Reuse one Google Sheets or Google Chat key across Destinations
- 0.40.0Warnings when a Count reads a joined Data Mart
Why OWOX for Reddit Ads in Google Sheets
Pulling Reddit Ads into a sheet shows what a community campaign cost. OWOX also keeps that data yours, next to every other paid channel and ready to model.
- You own the data. It lands in your own data warehouse, in tables you control.
- Answers about the whole business. Reddit Ads, the other ad platforms, web analytics and orders are linked, not copied from an ad account.
- Sheets stay in sync. Notes in the headers, a schedule you set once, no API token to fix in the sheet.
- Maintained for you. No scripts to fix when Reddit changes its API.
- Community spend in context. Reddit Ads performance by campaign, community and keyword sits next to every other paid channel in one model.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.



