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-rep...
https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/d...
Thanks!
Solved! Go to Solution.
Views
Replies
Total Likes
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
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....
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-rep...
Thanks!
Views
Replies
Total Likes
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.....
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
Hi @Jennifer_Dungan,
You really are the best Adobe Analytics Guru. Adobe should be paying you for your wisdom. This link on managing marketing channels helped me: https://experienceleague.adobe.com/en/docs/analytics/admin/admin-tools/manage-report-suites/edit-rep...
I got the average variance per channel to be about 1.5%! I used the va_closer_id field and that seemed to do it! Wondering if I can ever get an exact match though...
Hey! That's good progress.
And you have added in the logic about exclude_hit I assume?
This:
Yes... that can be an easy one to miss (especially if some forgets to add it to your Raw Data feed)
Views
Replies
Total Likes
Views
Likes
Replies