Skip to main content
Skip table of contents

Offline Conversions in Data Library 2.0

Overview

This guide walks through the data flows of the offline metrics so that users can better understand how the metrics flow from datasources into Data Library 2.0.

Current available offline metrics for all enabled platform reporting clients:

  • TikTok Ads

    • offline_complete_payment

    • offline_complete_payment_value

  • Snapchat Ads

    • offline_purchase_conversions

    • offline_purchase_conversions_value

To enable other offline conversions within the models, users can also utilize pass-through metrics to add the metrics by themselves (instructions can be found here: How to Add Pass-Through Metrics into ADL 2.0 Models)


Data Flow

Update Datasources

The offline metrics have been added and backfilled to the Alli datasources for clients (see How to find your Data Library datasources in Alli Data)

Platform

Datasources

Column Names

TikTok Ads

tiktok_insights_ad

  • Total Complete Payment (Offline)

  • Total Complete Payment Value (Offline)

Snapchat Ads

snapchat_insights_ad

  • Conversion Purchases (Offline)

  • Conversion Purchases Value (Offline)

For TikTok datasource,

image-20240612-141620.png

The two columns will be available as offline_shopping_events and offline_shopping_events_value when querying

SQL
select *
from {alli_client_slug}.tiktok_insights_ad

For Snapchat datasource,

image-20240612-141422.png

The two columns will be available as conversion_purchases_offline and conversion_purchases_value_offline when querying

SQL
select *
from {alli_client_slug}.snapchat_insights_ad

Build and Refresh a Data Library Report

The above offline metrics have been added to Data Library 2.0 dbt projects via code changes. After updating the datasources, offline metrics will be available as a result of running Alli Data Library 2.0 Refresh Marketplace Apps.

ADL2.0 Apps with (ALL REPORTS) in the name, or apps with the setting Historical Load = True need to be run first, otherwise the apps will error out with an "unrecognized name" error.

Then, offline metrics will be available within platform models. They will not be available within core models like ad_performance, as they’re not standard metrics across all platforms.

Platform

Platform Models

Column Names in Models

TikTok Ads

tiktok__account_performance

tiktok__campaign_performance

tiktok__adgroup_performance

tiktok__ad_performance

  • offline_complete_payment

  • offline_complete_payment_value

Snapchat Ads

snapchatads__account_performance

snapchatads__campaign_performance

snapchatads__adgroup_performance

snapchatads__ad_performance

  • offline_purchase_conversions

  • offline_purchase_conversions_value

Now, it’s good to use the columns!

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.