---
title: "Reddit Ads Insights to Email | OWOX"
canonical: "https://www.owox.com/connectors/reddit-ads-insights-to-email"
updated: "2026-11-03"
---

# Email Reddit Ads reports to your team on a schedule

Load Reddit Ads into your data warehouse first, link it to the rest of your data with SQL keys, then send daily spend and clicks, in the inbox of the owner of the community budget. The email comes from your source of truth, not from a hand-built export.

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Reddit Ads · Connected · Ad Account · Ad Account User · Ad Groups · Ad Performance

Data Mart · Published · one definition

![](https://cdn.owox.com/www/portfolio-management-data-destination/email/logo/2.svg/public)Email · Date · Spend · ClicksDaily 09:00

Refreshed on a schedule. No exports, no copy-paste.

[Get Started Free](https://www.owox.com/app-signup)

## Endpoints

## Reddit Ads Endpoints

[Documentation](https://docs.owox.com/packages/connectors/src/sources/reddit-ads/readme/)

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 fields](/data-sources/reddit#schema-ad-account)

*   [Ad Account User The authenticated Reddit Ads user — identity and contact details. 7 fields](/data-sources/reddit#schema-ad-account-user)

*   [Ad Groups Ad groups within your campaigns — bid strategy, goal, targeting, and schedule. 27 fields](/data-sources/reddit#schema-ad-groups)

*   [Ad Performance Daily ad performance — impressions, clicks, spend, conversions, and ROAS. 55 fields · Time series](/data-sources/reddit#schema-ad-performance)

*   [Ad Performance by Account Daily ad performance broken down by ad account. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-account)

*   [Ad Performance by Ad Group Daily ad performance broken down by ad group. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-ad-group)

*   [Ad Performance by Campaign Daily ad performance broken down by campaign. 57 fields · Time series](/data-sources/reddit#schema-ad-performance-by-campaign)

*   [Ad Performance by Community Daily ad performance broken down by subreddit (community). 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-community)

*   [Ad Performance by Country Daily ad performance broken down by user country. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-country)

*   [Ad Performance by DMA Daily ad performance broken down by Designated Market Area (DMA). 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-dma)

*   [Ad Performance by Interest Daily ad performance broken down by user interest targeting. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-interest)

*   [Ad Performance by Keyword Daily ad performance broken down by keyword. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-keyword)

*   [Ad Performance by Placement Daily ad performance broken down by ad placement. 56 fields · Time series](/data-sources/reddit#schema-ad-performance-by-placement)

*   [Ads Individual ads — type, status, and links to their campaigns and posts. 23 fields](/data-sources/reddit#schema-ads)

*   [Campaigns Your campaigns — objective, status, spend cap, and account association. 15 fields](/data-sources/reddit#schema-campaigns)

*   [Custom Audiences Custom audiences built from your user lists — type, status, and size estimates. 9 fields](/data-sources/reddit#schema-custom-audiences)

*   [Funding Instruments Payment methods linked to your campaigns — credit limits and current outstanding balance. 9 fields](/data-sources/reddit#schema-funding-instruments)

*   [Lead Gen Forms Lead generation forms shown in your ads — prompt text and creation details. 8 fields](/data-sources/reddit#schema-lead-gen-forms)

## S00 · Why

## Why Reddit Ads does not go straight to email

Reddit Ads reports spend and clicks by community, not which orders those clicks led to. An email built straight from the source sends the source's own numbers to an inbox with nothing to check them against; a scheduled export is no better, because it does not tie them to the rest of the business reliably, at scale or business-ready, so the join happens in a [data warehouse](/data-storages) first.

*   Spend and clicks stay in Reddit Ads, with no order from your shop beside them
*   The data analyst links the tables by SQL keys and controls what an email may say
*   Recipients get one readable message instead of a CSV to open

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Reddit Ads · Community spend

![](https://cdn.owox.com/www/portfolio-management-data-destination/email/logo/2.svg/public)Email

No link to orders

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2048%2048%22%20fill%3D%22none%22%3E%3Cpath%20d%3D%22M10.6842%2044.2221L0.419465%2026.278C-0.139822%2025.3001%20-0.139822%2023.6999%200.419465%2022.722L10.6842%204.77786C11.2435%203.79993%2012.6166%203%2013.7355%203H34.265C35.3838%203%2036.7567%203.79993%2037.3163%204.77786L47.5801%2022.722C48.14%2023.6999%2048.14%2025.3001%2047.5801%2026.278L37.3163%2044.2221C36.7567%2045.2001%2035.3838%2046%2034.265%2046H13.7355C12.6166%2046%2011.2435%2045.2001%2010.6842%2044.2221Z%22%20fill%3D%22%234486FA%22%2F%3E%3Cpath%20d%3D%22M30.6154%2018.3848L43.6923%2032.8463L37.3828%2043.85C36.8268%2044.8118%2035.4628%2045.5986%2034.3511%2045.5986L17.5385%2030.0771L30.6154%2018.3848Z%22%20fill%3D%22%233778ED%22%2F%3E%3Cpath%20d%3D%22M24.1539%2033.1537C28.997%2033.1537%2032.9231%2029.2276%2032.9231%2024.3845C32.9231%2019.5414%2028.997%2015.6152%2024.1539%2015.6152C19.3108%2015.6152%2015.3846%2019.5414%2015.3846%2024.3845C15.3846%2029.2276%2019.3108%2033.1537%2024.1539%2033.1537Z%22%20fill%3D%22white%22%2F%3E%3Cpath%20d%3D%22M31.2681%2029.2331L34.3825%2032.3476C34.7428%2032.7079%2034.7428%2033.2925%2034.3825%2033.6528L33.7296%2034.3057C33.3693%2034.666%2032.7847%2034.666%2032.4244%2034.3057L29.3099%2031.1913C28.9496%2030.831%2028.9496%2030.2464%2029.3099%2029.886L29.9628%2029.2331C30.3231%2028.8728%2030.9077%2028.8728%2031.2681%2029.2331Z%22%20fill%3D%22white%22%2F%3E%3Cpath%20d%3D%22M24.1538%2031.0003C27.8074%2031.0003%2030.7692%2028.0385%2030.7692%2024.3849C30.7692%2020.7313%2027.8074%2017.7695%2024.1538%2017.7695C20.5003%2017.7695%2017.5385%2020.7313%2017.5385%2024.3849C17.5385%2028.0385%2020.5003%2031.0003%2024.1538%2031.0003Z%22%20fill%3D%22%234486FA%22%2F%3E%3Cpath%20d%3D%22M24.1538%2029.4615C26.9577%2029.4615%2029.2308%2027.1884%2029.2308%2024.3845C29.2308%2021.5806%2026.9577%2019.3076%2024.1538%2019.3076C21.3499%2019.3076%2019.0769%2021.5806%2019.0769%2024.3845C19.0769%2027.1884%2021.3499%2029.4615%2024.1538%2029.4615Z%22%20fill%3D%22%234486FA%22%2F%3E%3Cpath%20fill-rule%3D%22evenodd%22%20clip-rule%3D%22evenodd%22%20d%3D%22M23.3846%2021.4619H25.2308V29.4619H23.3846V21.4619ZM26.4615%2024.8465H28.3077V28.5388H26.4615V24.8465ZM21.8462%2023.6158H20V28.5388H21.8462V23.6158Z%22%20fill%3D%22white%22%2F%3E%3C%2Fsvg%3E%0A)Data warehouse · Joined by id

Web analytics · Visits, sign-ups

Orders · Revenue

## S01 · Step 1

## Step 1: Load Reddit Ads into your data warehouse first

Create a Data Mart with Reddit Ads as the [data source](/data-sources) 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

[Google BigQuery](/connectors/free-reddit-ads-connector-to-google-bigquery)

[AWS Athena](/connectors/free-reddit-ads-connector-to-aws-athena)

[Snowflake](/connectors/free-reddit-ads-connector-to-snowflake)

[AWS Redshift](/connectors/free-reddit-ads-connector-to-aws-redshift)

[Databricks](/connectors/free-reddit-ads-connector-to-databricks)

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Reddit Ads · Data Mart

Your data warehouse · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2048%2048%22%20fill%3D%22none%22%3E%3Cpath%20d%3D%22M10.6842%2044.2221L0.419465%2026.278C-0.139822%2025.3001%20-0.139822%2023.6999%200.419465%2022.722L10.6842%204.77786C11.2435%203.79993%2012.6166%203%2013.7355%203H34.265C35.3838%203%2036.7567%203.79993%2037.3163%204.77786L47.5801%2022.722C48.14%2023.6999%2048.14%2025.3001%2047.5801%2026.278L37.3163%2044.2221C36.7567%2045.2001%2035.3838%2046%2034.265%2046H13.7355C12.6166%2046%2011.2435%2045.2001%2010.6842%2044.2221Z%22%20fill%3D%22%234486FA%22%2F%3E%3Cpath%20d%3D%22M30.6154%2018.3848L43.6923%2032.8463L37.3828%2043.85C36.8268%2044.8118%2035.4628%2045.5986%2034.3511%2045.5986L17.5385%2030.0771L30.6154%2018.3848Z%22%20fill%3D%22%233778ED%22%2F%3E%3Cpath%20d%3D%22M24.1539%2033.1537C28.997%2033.1537%2032.9231%2029.2276%2032.9231%2024.3845C32.9231%2019.5414%2028.997%2015.6152%2024.1539%2015.6152C19.3108%2015.6152%2015.3846%2019.5414%2015.3846%2024.3845C15.3846%2029.2276%2019.3108%2033.1537%2024.1539%2033.1537Z%22%20fill%3D%22white%22%2F%3E%3Cpath%20d%3D%22M31.2681%2029.2331L34.3825%2032.3476C34.7428%2032.7079%2034.7428%2033.2925%2034.3825%2033.6528L33.7296%2034.3057C33.3693%2034.666%2032.7847%2034.666%2032.4244%2034.3057L29.3099%2031.1913C28.9496%2030.831%2028.9496%2030.2464%2029.3099%2029.886L29.9628%2029.2331C30.3231%2028.8728%2030.9077%2028.8728%2031.2681%2029.2331Z%22%20fill%3D%22white%22%2F%3E%3Cpath%20d%3D%22M24.1538%2031.0003C27.8074%2031.0003%2030.7692%2028.0385%2030.7692%2024.3849C30.7692%2020.7313%2027.8074%2017.7695%2024.1538%2017.7695C20.5003%2017.7695%2017.5385%2020.7313%2017.5385%2024.3849C17.5385%2028.0385%2020.5003%2031.0003%2024.1538%2031.0003Z%22%20fill%3D%22%234486FA%22%2F%3E%3Cpath%20d%3D%22M24.1538%2029.4615C26.9577%2029.4615%2029.2308%2027.1884%2029.2308%2024.3845C29.2308%2021.5806%2026.9577%2019.3076%2024.1538%2019.3076C21.3499%2019.3076%2019.0769%2021.5806%2019.0769%2024.3845C19.0769%2027.1884%2021.3499%2029.4615%2024.1538%2029.4615Z%22%20fill%3D%22%234486FA%22%2F%3E%3Cpath%20fill-rule%3D%22evenodd%22%20clip-rule%3D%22evenodd%22%20d%3D%22M23.3846%2021.4619H25.2308V29.4619H23.3846V21.4619ZM26.4615%2024.8465H28.3077V28.5388H26.4615V24.8465ZM21.8462%2023.6158H20V28.5388H21.8462V23.6158Z%22%20fill%3D%22white%22%2F%3E%3C%2Fsvg%3E%0A)Google BigQuery · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2048%2048%22%20fill%3D%22none%22%3E%3Cpath%20d%3D%22M48%2029.0142L24%2026.0256L0%2029.0142L24%2048L48%2029.0142Z%22%20fill%3D%22%23FCBF92%22%2F%3E%3Cpath%20d%3D%22M0%2029.0142L24%2036.2676V48L0%2035.8398V29.0142Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M48%2029.0142L24%2036.2676V48L48%2035.8398V29.0142Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M3.099%2018.7008H0V25.5978L3.099%2026.1684L6.5436%2022.4742L3.099%2018.7014V18.7008Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M6.54421%2025.8828L3.09961%2026.1678V18.7008H6.54421V25.8828Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M8.86613%2010.0992L4.78613%2010.8768V26.5248L8.86613%2027.3804L12.6005%2018.7002L8.86613%2010.0986V10.0992Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M12.6%2026.9526L8.86621%2027.3804V10.0992L12.6%2010.527V26.9526Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M16.8213%2013.5798L11.1885%2014.1504V27.873L16.8213%2029.0142L22.8003%2021.261L16.8213%2013.5798Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M20.6187%2028.3722L16.8213%2029.0142V13.5798L20.6187%2013.8648V28.3722Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M23.9995%201.134L20.2021%202.3466V29.6562L23.9995%2030.4332L27.7969%2015.7836L23.9995%201.134Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M27.5156%2028.3722L31.1792%2029.0142L36.812%2018.7008L31.1792%208.4588L27.5156%209.0294V28.3722Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M35.3281%2026.9532L39.1327%2027.381L43.2127%2014.3646L39.1327%201.4196L35.3281%202.3466V26.9532Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M41.4551%2025.8828L44.8997%2026.1678L47.9987%2013.2948L44.8997%200L41.4551%200.8556V25.8828Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M24%201.134L27.7974%202.3466V29.6562L24%2030.4332V1.134ZM36.8118%209.6L31.179%208.4588V29.0142L36.8118%2027.873V9.6ZM43.2144%203.06L39.1344%201.4196V27.381L43.2144%2026.5248V3.06ZM48%201.5618L44.901%200V26.1684L48%2025.5978V1.5618Z%22%20fill%3D%22%23F58534%22%2F%3E%3C%2Fsvg%3E%0A)AWS Athena · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2048%2048%22%20fill%3D%22%2329B5E8%22%3E%3Cpath%20d%3D%22M41.1492%2036.5821L31.017%2030.7288C29.5935%2029.9092%2027.7733%2030.3966%2026.9494%2031.8201C26.6302%2032.3808%2026.5051%2032.9976%2026.5655%2033.5972V45.0365C26.5655%2046.6712%2027.894%2047.9998%2029.5331%2047.9998C31.1679%2047.9998%2032.4965%2046.6712%2032.4965%2045.0365V38.4585L38.173%2041.7367C39.5964%2042.5605%2041.421%2042.0688%2042.2405%2040.6454C43.0644%2039.2219%2042.577%2037.4017%2041.1492%2036.5821Z%22%2F%3E%3Cpath%20d%3D%22M15.949%2024.039C15.9663%2022.9822%2015.4099%2021.9987%2014.4954%2021.4682L4.36313%2015.6192C3.92316%2015.3647%203.41849%2015.231%202.91381%2015.231C1.87427%2015.231%200.908061%2015.7874%200.390448%2016.6846C-0.411852%2018.0735%200.0669408%2019.855%201.45587%2020.6573L7.29627%2024.0261L1.45587%2027.3992C0.782972%2027.7874%200.299866%2028.4128%200.101448%2029.1634C-0.101284%2029.9139%200.00223886%2030.699%200.390448%2031.3719C0.908061%2032.2691%201.87427%2032.8255%202.9095%2032.8255C3.41849%2032.8255%203.92316%2032.6918%204.36313%2032.4373L14.4954%2026.5883C15.4012%2026.062%2015.9577%2025.0872%2015.949%2024.039Z%22%2F%3E%3Cpath%20d%3D%22M6.6628%2011.4738L16.7951%2017.3228C17.977%2018.0086%2019.4349%2017.7843%2020.3666%2016.8742C20.9576%2016.3307%2021.3242%2015.5543%2021.3242%2014.6916V2.96765C21.3242%201.32854%2019.9957%200%2018.3609%200C16.7217%200%2015.3932%201.32854%2015.3932%202.96765V9.64054L9.63907%206.31919C8.21564%205.49532%206.39536%205.98274%205.5715%207.40618C4.74763%208.82962%205.23936%2010.6499%206.6628%2011.4738Z%22%2F%3E%3Cpath%20d%3D%22M29.4459%2024.5131C29.4459%2024.7374%2029.3165%2025.048%2029.1569%2025.2119L25.1411%2029.2277C24.9815%2029.3873%2024.6666%2029.5167%2024.4423%2029.5167H23.42C23.1957%2029.5167%2022.8808%2029.3873%2022.7212%2029.2277L18.7011%2025.2119C18.5415%2025.048%2018.4121%2024.7374%2018.4121%2024.5131V23.4908C18.4121%2023.2622%2018.5415%2022.9516%2018.7011%2022.792L22.7212%2018.7719C22.8808%2018.6123%2023.1957%2018.4829%2023.42%2018.4829H24.4423C24.6666%2018.4829%2024.9815%2018.6123%2025.1411%2018.7719L29.1569%2022.792C29.3165%2022.9516%2029.4459%2023.2622%2029.4459%2023.4908V24.5131ZM25.8614%2024.0214V23.9782C25.8614%2023.8143%2025.7665%2023.5857%2025.6501%2023.4649L24.4639%2022.2831C24.3474%2022.1623%2024.1188%2022.0674%2023.9506%2022.0674H23.9074C23.7435%2022.0674%2023.5149%2022.1623%2023.3941%2022.2831L22.2123%2023.4649C22.0958%2023.5814%2022.0009%2023.81%2022.0009%2023.9782V24.0214C22.0009%2024.1896%2022.0958%2024.4182%2022.2123%2024.5347L23.3941%2025.7209C23.5149%2025.8373%2023.7435%2025.9322%2023.9074%2025.9322H23.9506C24.1188%2025.9322%2024.3474%2025.8373%2024.4639%2025.7209L25.6501%2024.5347C25.7665%2024.4182%2025.8614%2024.1896%2025.8614%2024.0214Z%22%2F%3E%3Cpath%20d%3D%22M31.0158%2017.3228L41.1481%2011.4738C42.5715%2010.6542%2043.0632%208.82962%2042.2394%207.40618C41.4155%205.98274%2039.5952%205.49532%2038.1718%206.31919L32.4953%209.59741V2.96765C32.4953%201.32854%2031.1667%200%2029.532%200C27.8928%200%2026.5643%201.32854%2026.5643%202.96765V14.4587C26.5082%2015.0539%2026.6247%2015.675%2026.9482%2016.2358C27.7721%2017.6592%2029.5923%2018.1467%2031.0158%2017.3228Z%22%2F%3E%3Cpath%20d%3D%22M18.8267%2030.3841C18.1538%2030.2546%2017.4335%2030.3625%2016.7951%2030.7291L6.6628%2036.5825C5.23936%2037.402%204.74763%2039.2223%205.5715%2040.6457C6.39536%2042.0735%208.21564%2042.5609%209.63907%2041.737L15.3932%2038.4157V45.0368C15.3932%2046.6716%2016.7217%2048.0002%2018.3609%2048.0002C19.9957%2048.0002%2021.3242%2046.6716%2021.3242%2045.0368V33.3129C21.3242%2031.8334%2020.2415%2030.6083%2018.8267%2030.3841Z%22%2F%3E%3Cpath%20d%3D%22M47.4814%2016.6501C46.6618%2015.2223%2044.8372%2014.7349%2043.4138%2015.5588L33.2815%2021.4078C32.311%2021.9685%2031.7761%2022.9951%2031.7934%2024.039C31.7847%2025.0785%2032.3196%2026.0922%2033.2815%2026.6443L43.4138%2032.4977C44.8372%2033.3172%2046.6575%2032.8298%2047.4814%2031.4064C48.3052%2029.9829%2047.8135%2028.1626%2046.3901%2027.3388L40.6532%2024.0261L46.3901%2020.7133C47.8178%2019.8938%2048.3052%2018.0735%2047.4814%2016.6501Z%22%2F%3E%3C%2Fsvg%3E%0A)Snowflake · ![](data:image/svg+xml;utf8,%3Csvg%20viewBox%3D%220%200%2048%2048%22%20fill%3D%22none%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%3E%20%3Cpath%20d%3D%22M2%208.48783L5.5122%207.02441V40.9756L2%2039.5122V8.48783Z%22%20fill%3D%22%23205B98%22%20%2F%3E%20%3Cpath%20d%3D%22M5.51172%207.02441L12.2434%208.48783V39.5122L5.51172%2040.9756V7.02441Z%22%20fill%3D%22%235294CF%22%20%2F%3E%20%3Cpath%20d%3D%22M12.2441%203.5122L18%200V48L12.2441%2044.4878V3.5122Z%22%20fill%3D%22%23205B98%22%20%2F%3E%20%3Cpath%20d%3D%22M18%200H30V48H18V0Z%22%20fill%3D%22%232D72B8%22%20%2F%3E%20%3Cpath%20d%3D%22M35.3665%203.5122L30%200V48L35.3665%2044.4878V3.5122Z%22%20fill%3D%22%235294CF%22%20%2F%3E%20%3Cpath%20d%3D%22M45.6099%208.48783L42.0977%207.02441V40.9756L45.6099%2039.5122V8.48783Z%22%20fill%3D%22%235294CF%22%20%2F%3E%20%3Cpath%20d%3D%22M42.0969%207.02441L35.3652%208.48783V39.5122L42.0969%2040.9756V7.02441Z%22%20fill%3D%22%23205B98%22%20%2F%3E%20%3C%2Fsvg%3E%0A)AWS Redshift · ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2048%2048%22%20fill%3D%22none%22%3E%3Cpath%20d%3D%22M45.8905%2035.0619V26.9571L45.0149%2026.4095L24%2037.9095L4.0796%2026.9571V22.2476L24%2033.0905L46%2021.1524V13.1571L45.1244%2012.6095L24%2024.219L4.84577%2013.7048L24%203.19048L39.4328%2011.6238L40.6368%2010.9667V10.0905L24%201L2%2012.9381V14.1429L24%2026.1905L43.9204%2015.2381V20.0571L24%2031.0095L2.87562%2019.4L2%2019.9476V28.0524L24%2039.9905L43.9204%2029.1476V33.8571L24%2044.8095L2.87562%2033.3095L2%2033.8571V35.0619L24%2047L45.8905%2035.0619Z%22%20fill%3D%22%23FF3621%22%2F%3E%3C%2Fsvg%3E%0A)Databricks

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2048%2048%22%20fill%3D%22none%22%3E%3Cpath%20d%3D%22M10.6842%2044.2221L0.419465%2026.278C-0.139822%2025.3001%20-0.139822%2023.6999%200.419465%2022.722L10.6842%204.77786C11.2435%203.79993%2012.6166%203%2013.7355%203H34.265C35.3838%203%2036.7567%203.79993%2037.3163%204.77786L47.5801%2022.722C48.14%2023.6999%2048.14%2025.3001%2047.5801%2026.278L37.3163%2044.2221C36.7567%2045.2001%2035.3838%2046%2034.265%2046H13.7355C12.6166%2046%2011.2435%2045.2001%2010.6842%2044.2221Z%22%20fill%3D%22%234486FA%22%2F%3E%3Cpath%20d%3D%22M30.6154%2018.3848L43.6923%2032.8463L37.3828%2043.85C36.8268%2044.8118%2035.4628%2045.5986%2034.3511%2045.5986L17.5385%2030.0771L30.6154%2018.3848Z%22%20fill%3D%22%233778ED%22%2F%3E%3Cpath%20d%3D%22M24.1539%2033.1537C28.997%2033.1537%2032.9231%2029.2276%2032.9231%2024.3845C32.9231%2019.5414%2028.997%2015.6152%2024.1539%2015.6152C19.3108%2015.6152%2015.3846%2019.5414%2015.3846%2024.3845C15.3846%2029.2276%2019.3108%2033.1537%2024.1539%2033.1537Z%22%20fill%3D%22white%22%2F%3E%3Cpath%20d%3D%22M31.2681%2029.2331L34.3825%2032.3476C34.7428%2032.7079%2034.7428%2033.2925%2034.3825%2033.6528L33.7296%2034.3057C33.3693%2034.666%2032.7847%2034.666%2032.4244%2034.3057L29.3099%2031.1913C28.9496%2030.831%2028.9496%2030.2464%2029.3099%2029.886L29.9628%2029.2331C30.3231%2028.8728%2030.9077%2028.8728%2031.2681%2029.2331Z%22%20fill%3D%22white%22%2F%3E%3Cpath%20d%3D%22M24.1538%2031.0003C27.8074%2031.0003%2030.7692%2028.0385%2030.7692%2024.3849C30.7692%2020.7313%2027.8074%2017.7695%2024.1538%2017.7695C20.5003%2017.7695%2017.5385%2020.7313%2017.5385%2024.3849C17.5385%2028.0385%2020.5003%2031.0003%2024.1538%2031.0003Z%22%20fill%3D%22%234486FA%22%2F%3E%3Cpath%20d%3D%22M24.1538%2029.4615C26.9577%2029.4615%2029.2308%2027.1884%2029.2308%2024.3845C29.2308%2021.5806%2026.9577%2019.3076%2024.1538%2019.3076C21.3499%2019.3076%2019.0769%2021.5806%2019.0769%2024.3845C19.0769%2027.1884%2021.3499%2029.4615%2024.1538%2029.4615Z%22%20fill%3D%22%234486FA%22%2F%3E%3Cpath%20fill-rule%3D%22evenodd%22%20clip-rule%3D%22evenodd%22%20d%3D%22M23.3846%2021.4619H25.2308V29.4619H23.3846V21.4619ZM26.4615%2024.8465H28.3077V28.5388H26.4615V24.8465ZM21.8462%2023.6158H20V28.5388H21.8462V23.6158Z%22%20fill%3D%22white%22%2F%3E%3C%2Fsvg%3E%0A)reddit\_ads.report

## S02 · Step 2

## Step 2: Put Reddit Ads next to your other channels

In your data warehouse the [data model](/product/data-modeling) 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

Industry · E-commerce · SaaS

![](https://cdn.owox.com/www/webflow/679a01adc065220435d26849_328.svg/public)Reddit Ads · Ad Performance

![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2024%2024%22%3E%3Cpath%20fill%3D%22%230866FF%22%20d%3D%22M24%2012.073c0-6.627-5.373-12-12-12s-12%205.373-12%2012c0%205.99%204.388%2010.954%2010.125%2011.854v-8.385H7.078v-3.47h3.047V9.43c0-3.007%201.792-4.669%204.533-4.669%201.312%200%202.686.235%202.686.235v2.953H15.83c-1.491%200-1.956.925-1.956%201.874v2.25h3.328l-.532%203.47h-2.796v8.385C19.612%2023.027%2024%2018.062%2024%2012.073z%22%2F%3E%3C%2Fsvg%3E%0A)Facebook Ads · Ad spend

![](data:image/svg+xml;utf8,%3Csvg%20viewBox%3D%220%200%2048%2048%22%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20fill%3D%22none%22%3E%3Cpath%20fill%3D%22%230A66C2%22%20d%3D%22M40.8983%2040.8992h-7.1121V29.761c0-2.656-.0474-6.0751-3.699-6.0751-3.7043%200-4.271%202.8938-4.271%205.8817v11.3309h-7.1121V17.9938h6.8276v3.1302h.0956c.6833-1.1684%201.6706-2.1295%202.8569-2.781%201.1863-.6516%202.5271-.9691%203.8796-.9189%207.2084%200%208.5375%204.7415%208.5375%2010.91l-.003%2012.5651Zm-30.219-26.0363c-.81634.0001-1.61436-.2418-2.29316-.6952-.67881-.4534-1.20788-1.0979-1.5204-1.852-.31252-.7542-.39442-1.584-.23531-2.38469.15911-.80066.55207-1.53616%201.12917-2.11349.5771-.57732%201.31244-.97055%202.11302-1.12995.80058-.1594%201.63038-.07781%202.38468.23444.7542.31226%201.3988.84116%201.8525%201.51982.4536.67866.6958%201.47661.696%202.29297.0001.542-.1066%201.0787-.3139%201.5795-.2074.5008-.5113.9558-.8944%201.3392-.3832.3833-.8382.6874-1.3389.8949-.5007.2075-1.0374.3144-1.5793.3145Zm3.556%2026.0363H7.11579V17.9938h7.11951v22.9054ZM44.444.00327032H3.54198C2.61362-.00720657%201.71904.351327%201.05488%201.00008.390724%201.64884.0113301%202.53475%200%203.46313V44.5362c.0109423.9288.390114%201.8153%201.05425%202.4647.66413.6495%201.55891%201.0087%202.48773.9988H44.444c.9306.0117%201.8279-.3465%202.4947-.9959.6667-.6494%201.0484-1.537%201.0613-2.4676V3.46017c-.0133-.93023-.3952-1.81714-1.062-2.465882-.6668-.648742-1.5638-1.0062509-2.494-.99398236%22%2F%3E%3C%2Fsvg%3E)LinkedIn Ads · Ad spend

Unified Ad Spend · Merged ad spend

Sessions

Measures · platform\_roas · platform\_cpa

·

Marketing Spend · Merged ad spend

Subscription

Measures · cac · quick\_ratio

## S03 · Step 3

## Step 3: Email Reddit Ads reports to your recipients

Add an email destination with the recipients' addresses, separated by commas, semicolons or new lines, and attach a report of the Reddit Ads Data Mart. The subject and the body are Markdown, and a table placeholder drops the rows into the body.

*   The table carries date, spend, impressions and clicks
*   Allow-list the sending address insights@e.owox.com so the message reaches inboxes
*   Run it once with Create & Run report to see the email before the schedule starts

![](https://cdn.owox.com/www/portfolio-management-data-destination/email/logo/2.svg/public)Email · Weekly · Reddit Ads spend, week in review · date · spend · impressions · clicks

## S04 · Step 4

## Step 4: Schedule the Reddit Ads email and add a short analysis

Add a trigger in the report's Automate Report Runs section or on the Data Mart's Triggers tab, for example every weekday morning or Monday and Wednesday at a set hour in your time zone. Write the reading under the table.

*   Send always, only when the result is not empty, or only when it is empty
*   The reading is drawn from the report's fields and says only what the data shows
*   Attach a pre-built Insight instead of plain text when you want it written for you

![](https://cdn.owox.com/www/portfolio-management-data-destination/email/logo/2.svg/public)Email · Reddit Ads spend, week in review · date · spend · impressions · clicks · Analysis · Reddit Ads spend by day, with impressions and clicks. · Clicks against impressions show how well the ads land. · Check the currency column before you add days together.

## S05 · Step 5

## Step 5: Reuse Reddit Ads inside OWOX MCP

The Data Mart behind your email report also works in OWOX MCP, your [AI assistant](/product/ai-assistants) 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
*   A Reddit Ads question worth repeating becomes the next scheduled email

OWOX MCP · Compare platform\_roas by paid channel · platform\_roas

![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets · Open

![](https://cdn.owox.com/www/portfolio-management-data-destination/microsoft-excel/logo/1.svg/public)Excel · Open

## Related connectors

[Reddit Ads to AWS Athena](/connectors/free-reddit-ads-connector-to-aws-athena)[Reddit Ads to AWS Redshift](/connectors/free-reddit-ads-connector-to-aws-redshift)[Reddit Ads to Databricks](/connectors/free-reddit-ads-connector-to-databricks)[Reddit Ads to Google BigQuery](/connectors/free-reddit-ads-connector-to-google-bigquery)[Reddit Ads to Google Sheets](/connectors/free-reddit-ads-connector-to-google-sheets)[Reddit Ads to Data Studio](/connectors/free-reddit-ads-connector-to-looker-studio)[Reddit Ads to Snowflake](/connectors/free-reddit-ads-connector-to-snowflake)[Reddit Ads to API](/connectors/reddit-ads-connector-to-api)[Reddit Ads to ChatGPT](/connectors/reddit-ads-connector-to-chatgpt) · Show 6 more · Show fewer

## Recent updates

*   [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog/#compare-linkedin-ads-results-across-markets-spend-by-country-region-and-county-0430)
*   [0.43.0 · The Sheet link of a Google Sheets source opens the imported tab, not the first one](https://docs.owox.com/docs/changelog/#the-sheet-link-of-a-google-sheets-source-opens-the-imported-tab-not-the-first-one-0430)
*   [0.43.0 · Connect a Google Sheets plan with one Google sign-in](https://docs.owox.com/docs/changelog/#connect-a-google-sheets-plan-with-one-google-sign-in-0430)
*   [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410)
*   [0.41.0 · Rotating a connector key is one change: Sources share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-connector-key-is-one-change-sources-share-reusable-credentials-0410)

## Why OWOX

## Why OWOX for Reddit Ads by email

Scheduled exports and hand-mailed screenshots put numbers in an inbox. OWOX also keeps the data yours, linked and ready to model.

*   **You own the data.** Reddit Ads lands in your own data warehouse, in tables you control.
*   **Community spend, no login.** The owner of the community budget reads spend and clicks by email, without opening Reddit Ads.
*   **Nothing to open.** Recipients read the table and the analysis in the message, with no login to a dashboard or to OWOX.
*   **Same numbers everywhere.** The Reddit Ads Data Mart behind the email also feeds your reports and your AI assistant.
*   **You set the rule.** A report sends always, only when it has rows, or only when it is empty, so a quiet week does not fill inboxes.

[Book a call](/book-a-call)

[Get Started Free](https://www.owox.com/app-signup)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Get Started Free](https://www.owox.com/app-signup)
- [Documentation](https://docs.owox.com/packages/connectors/src/sources/reddit-ads/readme)
- [Ad AccountYour ad account settings — currency, attribution windows, and account type.17 fields](https://www.owox.com/data-sources/reddit) — /data-sources/reddit.md
- [data warehouse](https://www.owox.com/data-storages) — /data-storages.md
- [data source](https://www.owox.com/data-sources) — /data-sources.md
- [Google BigQuery](https://www.owox.com/connectors/free-reddit-ads-connector-to-google-bigquery) — /connectors/free-reddit-ads-connector-to-google-bigquery.md
- [AWS Athena](https://www.owox.com/connectors/free-reddit-ads-connector-to-aws-athena) — /connectors/free-reddit-ads-connector-to-aws-athena.md
- [Snowflake](https://www.owox.com/connectors/free-reddit-ads-connector-to-snowflake) — /connectors/free-reddit-ads-connector-to-snowflake.md
- [AWS Redshift](https://www.owox.com/connectors/free-reddit-ads-connector-to-aws-redshift) — /connectors/free-reddit-ads-connector-to-aws-redshift.md
- [Databricks](https://www.owox.com/connectors/free-reddit-ads-connector-to-databricks) — /connectors/free-reddit-ads-connector-to-databricks.md
- [data model](https://www.owox.com/product/data-modeling) — /product/data-modeling.md
- [AI assistant](https://www.owox.com/product/ai-assistants) — /product/ai-assistants.md
- [Reddit Ads to Google Sheets](https://www.owox.com/connectors/free-reddit-ads-connector-to-google-sheets) — /connectors/free-reddit-ads-connector-to-google-sheets.md
- [Reddit Ads to Data Studio](https://www.owox.com/connectors/free-reddit-ads-connector-to-looker-studio) — /connectors/free-reddit-ads-connector-to-looker-studio.md
- [Reddit Ads to API](https://www.owox.com/connectors/reddit-ads-connector-to-api) — /connectors/reddit-ads-connector-to-api.md
- [Reddit Ads to ChatGPT](https://www.owox.com/connectors/reddit-ads-connector-to-chatgpt) — /connectors/reddit-ads-connector-to-chatgpt.md
- [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog)
- [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md
