Skip to main content

How to Transfer Using Snowflake

Understand the data transfer options available through Snowflake Share

DIRECTV Ads Manager gives customers flexible options to access and analyze campaign data in the way that best fits their reporting, attribution and BI workflows. Customers can either configure custom aggregate reports directly in the platform, or set up dynamic data transfers via Snowflake Share.

What types of data transfers are available?

There are three main types of data transfer:

  • Aggregate — Grouped and summarized views of campaign performance across chosen dimensions. May or may not include attribution.

  • Log-Level Delivery (Snowflake Share only) — Granular, impression-level reporting showing every ad delivered. Can be used to calculate metrics such as household reach and frequency.

  • Log-Level Attribution (Snowflake Share only) — Granular conversion-focused reporting that ties conversions back to attributed impressions.

What types of reporting are available?

  • Direct Download (aggregate reports only) — Accessible directly from DIRECTV Ads Manager's reporting interface. Best for ad hoc or smaller-scale exports.

  • Custom Reports (emailed, aggregates only) — Reports can be sent directly to customer inboxes. Exports with more than 100k rows are not supported by email export.

  • Snowflake Share — Aggregate & Log-Level options. Data delivered directly into the customer's Snowflake environment. Eliminates file transfers and enables near-real-time access.

How often are the reports sent?

Custom Reports: Daily, Weekly, or Monthly. Snowflake Share: Dynamic / Real-Time.

Exports are recommended to be delivered during off-peak hours to capture completed activity from the prior period, and/or account for attribution which processes daily between 5:00–7:00 AM Eastern Time.

Understanding export types

Aggregate export

Use cases include high-level campaign performance reporting, executive-friendly views, and flexible grouping by dimensions such as date, campaign, line, publisher, product, etc.

Available dimensions: Date, Campaign Name, Line Item Name, Media Name (Publisher), Product Type, Creative Name, Zip Code, DMA Name, DMA Code, Screen Type.

Available metrics: Spend, Impressions, IP Reach (1-day and 7-day), Frequency, Quartiles 1–4, Completed Views, VCR, Clicks, Conversions, Responses, and any pixel events.

Log-Level Delivery export

Granular impression-level data for customers with internal BI or data science resources. Enables full flexibility in slicing, filtering, and modeling performance data. Required for brands that want to dynamically calculate reach across any permutation of dimensions.

Log-Level Attribution export

Detailed conversion-level reporting for validation and attribution analysis. Supports both Last-Touch Attribution (LTA) and Multi-Touch Attribution (MTA) methodologies. LTA ties each conversion to a single impression; MTA lists all contributing impressions.

Did this answer your question?