Paid Search Detection Rules Downstream | Community
Skip to main content
skatofiabah
skatofiabah
Level 5
October 9, 2024
Solved

Paid Search Detection Rules Downstream

  • October 9, 2024
  • 1 reply
  • 1614 views

Hi,

 

I'm trying to write SQL Code on our Adobe Daily Web Traffic Source Table. I want to match our page views from Adobe Workspace to our Database downstream query based on the Marketing Channel Processing Rules. Our first rule is Paid Search and it's based on the Paid Search Detection Rules. How do I mimic this downstream? How do I get a list of all the possible referrers/Search Engines that constitute as Paid Search? Do I need to write out an entire list for the POST_REFERRER column with all these hundreds of search engines?

 

Some helpful links I've referenced:

https://experienceleague.adobe.com/en/docs/analytics/admin/admin-tools/manage-report-suites/edit-report-suite/report-suite-general/paid-search-detection/paid-search-detection

https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/datafeeds-reference

Thanks!


This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

Hi @jennifer_dungan,

 

Got it. Yea I'll have to create a support ticket because I tried that and we get like 100,000 UVs more in Adobe Workspace vs. Downstream Data Feed. It's tricky with knowing exactly which fields to try to tie out with the marketing channel processing rules.


Ouch.. that is not a small difference!

 

Is there a reason you aren't just using the Marketing Channel fields in the Data Feed (sorry, I just though of this now).

 

va_closer_id is the Last Touch Channel

va_closer_detail is the Last Touch Channel Detail

 

You can also get the First Touch values using:

va_finder_id and va_finder_detail

 

And the Marketing Channel Instance is va_instance_event

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 10, 2024

There is a field in the Raw Data for paid search detection: paid_search

 

That can at least help you see what Adobe detected... but as for replicating the rules on your own, I don't know if that is possible... referrers are determined to be search engines changes constantly as new variants are discovered... I don't think you will every be able to stay on top of that to keep it aligned....

    skatofiabah
    skatofiabahAuthor
    Level 5
    October 10, 2024

    Hi @jennifer_dungan,

     

    Thank you so much for this. I found that I can just filter where paid_search = 1 and also where our Full URL contains "cid" since that's how our paid search detection rule is set up. Is there a way to do this for Natural Search as well? The articles claim it's just the opposite of Paid Search. Natural Search is like our 12th processing rule thought whereas Paid Search is #1.

    https://experienceleague.adobe.com/en/docs/analytics/admin/admin-tools/manage-report-suites/edit-report-suite/marketing-channels/c-rules#natural-search

    Thanks!

    Jennifer_Dungan
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    October 10, 2024

    Hmm well... paid_search=1... that's kind of useless...  Though you might be able to find "Natural Search" by looking at paid_search = 0 AND ref_type = 3 (search engine).

     

    In Marketing Rules, you're right, they are opposites of one another.. so Adobe must be adding in logic about the referrer type for Search Engines, then adding a flag for the "paid" sub-set.

     

    This should make it so you don't get ALL the referrals for everything else (direct, social, etc) coming back when you don't have the paid search flag..... 

      Terms & ConditionsAccessibility statement

      Loading footer...