Skip to main content
Three rules change which touches receive credit. Each section names the table it applies to. The general validity rules are in the MTA overview.

Email and SMS

Rule: In obt_purchase_journeys_with_mta_models, email and SMS touches never receive first-touch or linear credit in the marketing channel, ad, campaign, or ad group dimensions. They receive last-touch credit in those dimensions only when it is turned on for your account. It is off by default, and turning it on is a custom change today. Ask your SourceMedium contact if you want it. A customer must already know your brand to be on your list, so a message is rarely the true first touch. Frequent sends would also take a large share of linear credit away from the channels that brought the customer in. What this means for the numbers:
  • First touch goes to the earliest valid touch that is not email or SMS.
  • Linear credit is split only among the touches that are not email or SMS.
  • A journey whose only touches are email or SMS is not attributable in these dimensions. It shows as non-attributable in the dashboard.
Email and SMS get their own dimension, email_sms, with first-touch, last-touch, and linear credit computed on email and SMS touches alone. The landing page dimension also credits email and SMS visits. The dimension value is formatted [Email][Flow] Welcome Series or [SMS][Campaign] Flash Sale. It combines the channel, whether the message is a flow or a campaign, and a name. The name comes from utm_campaign, unless that is one of flow, campaign, email, or sms. Then it comes from utm_content, unless that is only digits. After that it comes from utm_term, then utm_id. Messages that appear in the most purchase journeys, with their last-touch revenue in the email/SMS dimension:

Brand campaigns

Rule: In rpt_ad_attribution_performance_daily, a campaign whose campaign tactic is Brand receives zero attributed revenue and zero attributed conversions in every model. Its spend, impressions, clicks, and platform-reported conversions are still reported in full. A campaign is Brand when its campaign tactic is Brand. The tactic comes from the campaign type first. Performance Max campaigns are Automatic Targeting, whatever their name. So are campaigns whose name marks them Advantage+ or Smart Performance, such as “Advantage+”, “Advantage Plus”, “SPC” or “Smart Campaign”, even if the name also says brand. Otherwise a name containing the whole word “brand”, “branded”, or “branding” is Brand, unless it also contains “non-brand”. A name such as “brandname” does not match, so renaming a campaign does not always change its tactic. Brand search captures demand that already exists. Crediting it would inflate its return and move budget away from the channels that create demand. obt_purchase_journeys_with_mta_models credits touches, not campaigns, so it does not zero a Brand campaign. It handles brand search visits instead. These are visits that map to the brand_search channel, such as a click on a Google Brand campaign:
  • A brand search visit is never a valid touch in the marketing channel dimension.
  • In the ad, campaign, and ad group dimensions it receives no first-touch or linear credit, so that credit moves to the other touches in the journey.
  • In the ad, campaign, and ad group dimensions it can still receive last-touch credit.
Brand and non-brand spend side by side. The brand row always shows zero attributed revenue:

Channel-level rows

Rule: In rpt_ad_attribution_performance_daily, every row belongs to one waterfall_level: ad_level, ad_group_level, campaign_level, or channel_level. Spend lands at the most granular level the ad platform reported. A channel_level row holds spend, impressions, and clicks that the platform did not tie to any ad, ad group, or campaign. Those rows never carry attributed revenue, because there is no ad entity for a touch to match. Two consequences:
  • Spend and attributed revenue per platform add up without double counting. Totals per platform and day match rpt_ad_performance_daily.
  • This table only credits ad entities. Credit for organic search, referrals, and other non-ad channels lives only in the marketing channel dimension of obt_purchase_journeys_with_mta_models.
Credit is also limited to rows whose sm_channel (the sales channel of the ad) is Online DTC. Spend and linear revenue by ad platform and level. A high share of channel_level spend means the platform is not reporting ad-level detail: