Skip to main content

Add Offline Sales to Reporting

Connect offline sales to your reporting to see how your TV campaign influenced real-world actions

See how your TV campaign influenced real-world customer actions by uploading your store sales or other offline conversions. Connecting this offline data to your advertising reporting gives you a complete view of your campaign's impact — not just what happened online.


​

How it works

Upload offline sales conversion data

Step 1: Click on Settings in the left-side menu and select Clean Room.


​

Step 2: Ensure that your payment details have been entered.


​

Step 3: Select Upload Type and upload your files.


​

Common examples include:

  • In-store purchase records

  • Loyalty or membership transactions

  • Lead or CRM events

  • Call center sales

Recommended fields include:

  • Transaction ID

  • Transaction timestamp

  • Revenue or purchase amount

  • Customer identifiers such as: email address, first and last name, mailing address

Not sure how to set up your file? A template is available in the Clean Room page.


​

Note: The more complete the customer data, the higher the likelihood of successful matching.


​

Measure advertising impact

Once you've uploaded your offline sales, each event is processed and matched against campaign exposure data. This will enable you to evaluate:

  • Offline conversions

  • Revenue and ROAS

  • Campaign effectiveness

  • Cross-channel performance trends


​

Data formatting best practices

Use one row per transaction

Each uploaded row should represent a single completed transaction. Do not upload separate rows for individual products within the same purchase, separate tax or fee rows, or separate promotional or discount rows.


​

Instead, aggregate all related line items into a single transaction record that includes one transaction ID, one total purchase amount, one timestamp, and one set of customer identifiers.


​

Include strong customer identifiers

Providing multiple customer identifiers improves match quality. Recommended identifiers include email address, full name, and postal address.


​

Include accurate timestamps

Transaction timestamps should reflect the actual time of purchase whenever possible. Consistent timestamp formatting helps improve attribution accuracy and reporting consistency.


​

Processing timeline and expectations

Offline conversion files are processed twice per month: the 4th and the 15th. Customers should upload files at least 1–2 days before these processing dates.


​

After submission:

  • Files are sent to DIRECTV Ads Manager's identity resolution partner for matching

  • Matched records are typically returned within 48 hours

  • Results are then incorporated into DIRECTV Ads Manager's standard reporting processing workflow

In most cases, customers should expect offline sales to begin appearing within a few days after a scheduled processing date.


​

Reporting and insights

Offline sales reporting within the DIRECTV Ads Manager can be integrated into external reporting environments. Available metrics may include:

  • Offline conversions

  • Revenue attribution

  • Return on ad spend (ROAS)

  • Campaign performance trends

These insights can help advertisers optimize media strategy, budget allocation, and overall campaign performance.

Did this answer your question?