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?