Bucketing mis-matched campaigns

Tenjin's Bucketing Tool syncs data from 3rd party attribution providers and ad networks to calculate ROI within its dashboards and DataVault. Customers can use this tool on their own to "clean" their siloed datasets.

Overview

To illustrate what the Bucketing Tool solves, Tenjin can be configured to receive campaign data from ad networks and 3rd party attribution providers. The campaign data Tenjin receives have properties that make each campaign seem unique even though they represent the same campaign.

Tying these "different" campaigns together is critical to report on ROI from a specific channel.

Below is an example of how an ad network and attribution provider might see things differently in their reporting. These three campaigns are in fact “identical”, but both ad network and attribution provider see them as separate campaigns.

Campaign reported_installs tracked_installs spend LTV ROI
US - WS 20 $30 -100%
US - WordSearch 10 $100 -100%
WordSearch - US 32 $30

Using the Tenjin Campaign Bucketing tool, Tenjin customers can "sync" both silo'd ad network and attribution campaign data sets together as shown in the result below.

(After campaign buckets)

Campaign reported_installs tracked_installs spend LTV ROI
US - WordSearch 30 32 $130 $30 -70%

This data is now "cleaned" so that everything is tied to a single campaign ID and can be accessed through Tenjin's various APIs and also DataVault.

Process

  1. We pull a list of campaigns from ad-network API and create those campaigns automatically on Tenjin.
  2. We receive real-time attribution callbacks from 3rd party attribution providers and create a network as a custom channel. The campaigns under the channel are automatically created for the attribution provider. Regarding how to set up a real-time callback, please refer here.
  3. On the Channels page you will see custom channels from 3rd party attribution providers show up as below. This channel name is from 3rd party attribution, so it could be any name you choose on their dashboards. Tenjin will merge those custom channels into the proper channels you initially created on Tenjin dashboard through the ad network APIs.

  4. Once 3rd party attribution channels are merged with Ad Network API channels, you can bucket campaigns as described above. Go to the Campaign Buckets page to do that. You'll see a list of campaigns that need to be bucketed for each app and network.

    In the example above, you can see those campaigns. Click the blue arrow to edit the campaign bucket.

    • 2 Reported campaigns and 1 tracked campaign for Word Search iOS, Facebook
    • 2 Reported campaigns and 1 tracked campaign for Word Search Android, Facebook
    • 4 Reported campaigns and 3 tracked campaigns for Word Search iOS, Pinterest

On the top, you can filter the campaigns by app and channel and select lookback days(from 1 to 30). We show all the tracked and reported installs within the lookback period. This is useful to gauge how similar the attribution and ad network campaigns are.

In the middle, you can see a list of raw campaigns that need to be bucketed. If the campaign comes from ad-network reporting API, we show remote_campaign_id, reported_installs, and spend. If the campaign comes from 3rd party attribution tool, we show only tracked_installs

Then you can check each campaign you want to bucket, and click "Unify Campaigns". In the example below, "Word Search iOS - US" campaign has 16 reported_isntalls and 16 tracked_installs, so you can easily see those are the same campaign. You can also type Unified Campaign Name manually, if you want to change the name that appears on the dashboard.

Once you bucket the campaigns, you can see the bucketed campaign under "Unified Campaigns".

  • You can bucket "unified campaign" and "raw campaigns" together
  • If you want to un-bucket the unified campaigns (because you made a mistake), click the red trash button on the right side of each unified campaign.

How long does it take for data to appear after bucketing?

This depends on the number of campaigns you are currently running. Once all campaigns are bucketed, DataVault will be updated in 3 hours. Currently, the dashboard will be updated only after the weekend data refresh.

Networks which don’t require campaign buckets

Some networks have a definite campaign structure, so campaign buckets happen automatically. This is a list of networks which don’t require campaign buckets manually.

  • Adjust
    • Facebook
    • Twitter
    • Yahoo
    • Snapchat
    • Apple Search
    • Google UAC
    • Chartboost
  • AppsFlyer
    • Facebook
    • Apple Search
    • Snapchat
  • Kochava
    • Facebook

Tenjin campaign ID

If you don’t want to handle campaign buckets manually, follow the instructions below. You don't need to do this if you are using the Campaign Buckets tool.

  1. Add channels on Tenjin dashboard. Tenjin will pull a list of campaigns you are currently running with your ad network providers.

  2. For each campaign tracking URL, you generate in your attribution service, add that attribution service’s custom parameter(list below) to the tracking URL with the value of that campaign’s tenjin_campaign_id.

You can find your campaign’s tenjin_campaign_id in the dashboard under the Campaigns tab for that campaign.

Here is the list of custom parameters. Some attribution providers have multiple parameters, so you can pick one of them.

  • Adjust
    • label
  • AppsFlyer
    • af_sub1, af_sub2, af_sub3, af_sub4, af_sub5
  • TUNE
    • publisher_sub1, publisher_sub2, publisher_sub3, publisher_sub4, publisher_sub5
  • Kochava
    • kc_sub
  • Apsalar/Singular

    • ap_sub

      For example, if your adjust tracking link is this, and your Tenjin camapign ID for a campaign is djlCLxU69D41CI4WIu4Ghq,

      https://app.adjust.com/aaaaaa?campaign={CAMPAIGN_NAME}&adgroup={APP_ID}&creative={AD_NAME}&idfa={IDFA}&country={CC}&gps_adid={IDFA}&device_type={DEVICE_TYPE}&tracker_limit=100000&applovin_click_id={DID}&android_id_lower_sha1={HADID}

      Updated tracking url is below:

      https://app.adjust.com/aaaaaa?campaign={CAMPAIGN_NAME}&adgroup={APP_ID}&creative={AD_NAME}&idfa={IDFA}&country={CC}&gps_adid={IDFA}&device_type={DEVICE_TYPE}&tracker_limit=100000&applovin_click_id={DID}&android_id_lower_sha1={HADID}&label=djlCLxU69D41CI4WIu4Ghq

  • Set up real-time callbacks on 3rd party attribution dashboard as described in here.

results matching ""

    No results matching ""