Skip to main content

Offline Sales Attribution

Measure advertising influences in-store purchases and other offline conversions

By connecting offline transaction data to digital advertising exposure, Jamloop helps advertisers better understand campaign performance beyond online-only activity.

How It Works

1. Upload Offline Conversion Data

Advertisers provide offline sales or CRM data to Clean Room in a secure format.

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

*Template for Offline Sales data is available in the Clean Room

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

2. Convert Offline Transactions into Digital Events

Jamloop works with trusted identity resolution partners to translate offline transaction data into digital identifiers such as:

  • Household IDs

  • IP-based identifiers

This process allows offline sales to be represented as digital conversion events that can be measured against advertising exposure.

3. Measure Advertising Impact

Once converted into digital events, offline conversions are processed through Jamloop’s attribution system and matched against campaign exposure data.

This enables advertisers to evaluate:

  • Offline conversions

  • Revenue and ROAS

  • Campaign effectiveness

  • Cross-channel performance trends

Data Formatting Best Practices

To improve attribution quality and reporting accuracy, follow these best practices when preparing offline conversion files.

1) 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

  • 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

  • One set of customer identifiers

2) Include Strong Customer Identifiers

Providing multiple customer identifiers improves match quality.

Recommended identifiers include:

  • Email address

  • Full name

  • Postal address

3) 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 & Expectations

Offline conversion files are processed twice per month:

  • The 4th

  • The 18th

*Customers should upload files at least 1-2 days before these processing dates to avoid delays in reporting.

After submission:

  1. Files are sent to processed for identity resolution and resolved to digital IDs

  2. Matched records are typically returned within 48 hours

  3. Results are then incorporated into our standard attribution processing workflow

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

Historical Data

The timing above may vary when uploaded files include conversions more than 7 days old.


Jamloop's standard attribution process evaluates recent conversions (7 days old or less) daily. Older conversion data is reprocessed once per week, on Sundays, with updated results typically available Monday morning.

As a result, when uploading historical data, such as year-to-date sales, you may begin seeing attributed sales within a few days of the scheduled processing date, but these initial results may not represent the complete attribution of the file. Historical conversions will be more fully reflected after the next weekly processing cycle.

For example, if a year-to-date sales file is processed mid-week, some attributed sales may appear later that week. Additional historical attribution may then appear following Sunday's processing run.

Reporting & Insights

Offline Sales Attribution reporting is available within the Jamloop platform and can be integrated into external reporting or BI 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?