> ## Documentation Index
> Fetch the complete documentation index at: https://docs.topsort.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Room

> How our Data Room works

export const LastUpdated = ({date, lang = "en"}) => {
  const translations = {
    en: "Last updated:",
    es: "Última actualización:",
    pt: "Última atualização:",
    fr: "Dernière mise à jour:",
    de: "Zuletzt aktualisiert:"
  };
  const label = translations[lang] || translations.en;
  return <>
<style>{`
.last-updated-component {
display: inline-flex;
align-items: center;
gap: 8px;
padding: 10px 16px;
border-radius: 8px;
margin-top: 12px;
margin-bottom: 16px;
font-size: 14px;
background-color: rgba(0, 0, 0, 0.05);
border: 1px solid rgba(0, 0, 0, 0.12);
color: rgba(0, 0, 0, 0.75);
line-height: 1;
}

        .last-updated-component svg {
          flex-shrink: 0;
          vertical-align: middle;
        }

        .last-updated-component span {
          display: inline-flex !important;
          align-items: center !important;
          line-height: 1 !important;
        }

        [data-theme="dark"] .last-updated-component {
          background-color: #3a3a3a;
          border: 2px solid #888888;
          color: #ffffff;
        }

        [data-theme="dark"] .last-updated-component svg {
          stroke: #ffffff;
        }
      `}</style>
      <div className="last-updated-component">
        <svg width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round">
          <circle cx="12" cy="12" r="10" />
          <polyline points="12 6 12 12 16 14" />
        </svg>
        <span>
          <strong style={{
    fontWeight: 600
  }}>{label}</strong> 
          <time dateTime={date}>{date}</time>
        </span>
      </div>
    </>;
};

<Note>
  This is an add-on. If you'd like to have access to it, speak with your Topsort
  contact to learn more.
</Note>

<div style={{ textAlign: "justify", marginBottom: "1.5rem" }}>
  Data Room is like having the keys to the castle that allows you to access your
  own data that lives within Topsort Database and create custom queries to get
  whatever information you want, displayed according to your preferences. There
  are two ways of leveraging Topsort's Data Room.
</div>

## Option 1. Via Topsort UI

<div style={{ textAlign: "justify", marginBottom: "1.5rem" }}>
  We support embedded analytics in our platform. In your admin dashboard, you
  can find the Data Room tab and access the Data Room UI directly from our
  application. This allows you to create your custom visualizations and combine
  them into dashboards, using a friendly non-technical tool called "Questions"
  or running SQL queries directly.
</div>

<Frame>
  <img src="https://mintcdn.com/topsort/JfdWUceY7Se3NW-0/images/knowledge-base/ad-platform-reporting-and-analytics-data-room.webp?fit=max&auto=format&n=JfdWUceY7Se3NW-0&q=85&s=9a7e18dc8553928b54649b140bfb88c5" alt="Screenshot of data room functionality." width="1339" height="695" data-path="images/knowledge-base/ad-platform-reporting-and-analytics-data-room.webp" />
</Frame>

<div style={{ textAlign: "justify", marginBottom: "1.5rem" }}>
  These are the tables that can be made available in the Data Room:
</div>

* Ad Inventory
* Attributed Purchases
* Auctions Won Summary
* Behavior Summary By Hour
* Campaigns
* Vendor Balances
* Vendor Transactions
* Fill Rate Search
* Auction Zero Winners
* Slots Fill Rate

## Option 2. Via Datasource Connection

<div style={{ textAlign: "justify", marginBottom: "1.5rem" }}>
  You can access the same database that powers the UI mentioned above directly,
  so you can link it to your existing Data Lake, create custom ETL reports that
  read from Topsort's data, or to combine data from multiple sources while still
  using your business intelligence tool of preference.
</div>

<div style={{ textAlign: "justify", marginBottom: "1.5rem" }}>
  After having your Snowflake account created by the Topsort team, you should be
  able to connect to Snowflake using your credentials. In case you need
  additional support on how to connect or use Snowflake, please check the links
  below:
</div>

* [Connecting your snowflake account](https://docs.snowflake.com/en/user-guide/connecting)
* [Introduction to Snowflake](https://docs.snowflake.com/en/user-guide-intro)
* [Querying from snowflake](https://docs.snowflake.com/en/guides-overview-queries)

***

<LastUpdated date="2025-11-18" />