Classify Tracking Code using Rule Builder

Well explained on Guide to Using UTM Parameters in Adobe Analytics

I used following code to capture Tracking code:

s.usePlugins=true;
s.doPlugins=function(s) {

if(s.Util.getQueryParam(‘utm_medium’)){
s.campaign=s.Util.getQueryParam(‘utm_medium’)+”:”+s.Util.getQueryParam(‘utm_source’)+”:”+s.Util.getQueryParam(‘utm_campaign’)+”:”+s.Util.getQueryParam(‘utm_content’)+”:”+s.Util.getQueryParam(‘utm_term’);
}
s.campaign=s.getValOnce(s.campaign,’s_campaign’,0);

}

Then I set up the calssification in Analytics

Below is the screen shot:

Then under classification rule builder I did following setup using regx ^(.+)\:(.+)\:(.+)\:(.+)\:(.+)$

Sample value:

search:google:christmas:article:gifts

The above regex will not accept value if any one of the field is missing like search:google:christmas::gifts or :google:christmas::gifts

To fix this we have to use : ^(.*)\:(.*)\:(.*)\:(.*)\:(.*)$

For reference check Adobe Doc

For testing, you can use https://rubular.com/

Adobe Analytics Interview Questions

  1. Difference b/w prop and evar
  2. What is the pathing report
  3. Explain segment comparison
  4. Explain the container in segments
  5. What is the use of calculated metric
  6. Analysis Workspace
  7. Visitor and visit concept
  8. Mid , experience cloud ID services
  9. Merchandizing evar
  10. Image request parsing
  11. Getqueryparam
  12. Data collection query parameters
  13. What is DTM?
  14. In how many ways you can implement analytics
  15. Difference b/w Google Analytics and Adobe Analytics
  16. Export and import tools
  17. Data sources
  18. Classification
  19. Processing rule
  20. Processing order
  21. Marketing channel
  22. Internal URL filter
  23. Reason of “other” in pages report
  24. S.t and s.tl implementation and syntax
  25. Difference b/w s.t and s.tl
  26. What is data range
  27. Virtual report suite
  28. Menu customization
  29. Experience cloud
  30. Report suite and rollup
  31. Multi suite tagging
  32. Difference b/w rollup and multisuite tagging
  33. What is the primary and secondary server call
  34. Key metrics
  35. First part cookie
  36. Tracking code
  37. Product string
  38. Plugin
  39. Visitor id identification method
  40. Data feed understanding
  41. Scenario-Based time spent on page.
  42. Scenario based segment configuration questions.
  43. Prop can correlate with (only prop or traffic sources)
  44. The difference in multi tagging and rollup report suite.
  45. Options available when on first screen of Report builder wizard when creating a request.
  46. who can create and share calculated metrics
  47. Total appears in report represents?
  48. Maximum number of line items that can appear on screen while running a report (answer:200)
  49. Recommended format to download or schedule file for 501 line items (csv)
  50. Data extract limitation (available only in csv format)
  51. when an alert is set on percentage change how it works
  52. Publishing list benefit
  53. How a non-admin user can share a report
  54. Definition of Report Acceleration
  55. variable character limit
  56. How total would be affected if we apply an advance filter on the reports
  57. what changes can be applied to a dashboard in one go which will affect all the reportlets
  58. If notes are added in any report who can view those notes
  59. definition of copy me, on menu, options available for dashboard
  60. When running page views or any other metrics report which are the default column that appears in report (4 week prior and 52 weeks prior).

Impression data to Audience Manager (AAM)

Is Ad Cloud able to pass display media exposure back to AA, and then have this forwarded via Server side ?

Advertising Cloud is able to pass data in Analytics via Adobe server to server integration for Adobe to understand if the ad impacted the consumer to visit the website. For example, Adobe can capture view-through data and understand if someone saw the display ad (delivered via Advertising Cloud) and then went to the advertisers’ web page a few days later (via the Analytics pixel on the web-page), we can capture that as a view-through conversion and say the ad contributed to the person visiting the website. From there, Analytics can understand other ways users are interacting with the web page (bounce rate, page views etc.) to help create audiences to re-target, or build look-a-likes (via pushing Analytics segments into Audience Manager). Additionally, we can create audiences via Analytics data and push those audience segments into Audience Manager through server to server integration to house all segments in one place for organization.

You have the option to push audiences straight from Analytics into Advertising Cloud to target, or can push the audiences into Audience Manager for organization and then push from AAM to Ad Cloud to target.

The benefits of using all three products together are:

– Capture audience and website behavior and use it to build segments of in-market intenders

– Create a single view of the customer form your unified data, enriched and added data

– Deliver a personalized ad to an audience at the right time whenever they are in an authentic and relevant experience

– Continue to personalize through analysis, reporting & optimization

Mobile carrier reports and it’s behavior in Adobe Analytics

I am sure most of you must be aware of the “Mobile carrier” reports and it’s behavior in site catalyst.

Still, I would like to share a few inputs which I came across, and thought some people might not be aware of the same.

It’s a Visitor’s profile report that comes under Technology i.e Visitor’s profile à Technology à Mobile carrier

It helps identifying the traffic ( mobile visitors)  by carrier i.e  the mobile operators and shows the wireless service provider.

The third party : NetAcquity  is the one which sources the data for us.

It is calculated as taking the unique key calculated by taking the combination of  ISP + Domain. Hope this little information may help in understanding.

How To Connect S3 Buckets

What is Amazon S3?

Amazon S3 or Amazon Simple Storage Service is a “simple storage service” offered by Amazon Web Services that provides object storage through a web service interface. Amazon S3 uses the same scalable storage infrastructure that Amazon.com uses to run its global e-commerce network.

Reference :Wikipedia

There is situation when data is stored in S3 and we need to connect it.

We can use a freeware called Cloudberry. You can install it by going to the following link:

http://www.cloudberrylab.com/free-amazon-s3-explorer-cloudfront-IAM.aspx

Once installed you will come to the following pop up where you just need to put access key and secret key along with the connection name that you can put.

After this you will come to the following screen. You will have to replace “root” with the bucket name under the S3 source location.

This is a great tool to test the connection with the different S3 also to confirm the bucket names.

Other is http://s3browser.com/

Complete List of Country & Dialing Codes

COUNTRYA2 (ISO)A3 (UN)NUM (UN)DIALING CODE
AfghanistanAFAFG493
AlbaniaALALB8355
AlgeriaDZDZA12213
American SamoaASASM161-684
AndorraADAND20376
AngolaAOAGO24244
AnguillaAIAIA6601-264
AntarcticaAQATA10672
Antigua and BarbudaAGATG281-268
ArgentinaARARG3254
ArmeniaAMARM51374
ArubaAWABW533297
AustraliaAUAUS3661
AustriaATAUT4043
AzerbaijanAZAZE31994
BahamasBSBHS441-242
BahrainBHBHR48973
BangladeshBDBGD50880
BarbadosBBBRB521-246
BelarusBYBLR112375
BelgiumBEBEL5632
BelizeBZBLZ84501
BeninBJBEN204229
BermudaBMBMU601-441
BhutanBTBTN64975
BoliviaBOBOL68591
BonaireBQBES535599
Bosnia and HerzegovinaBABIH70387
BotswanaBWBWA72267
Bouvet IslandBVBVT7447
BrazilBRBRA7655
British Indian Ocean TerritoryIOIOT86246
Brunei DarussalamBNBRN96673
BulgariaBGBGR100359
Burkina FasoBFBFA854226
BurundiBIBDI108257
CambodiaKHKHM116855
CameroonCMCMR120237
CanadaCACAN1241
Cape VerdeCVCPV132238
Cayman IslandsKYCYM1361-345
Central African RepublicCFCAF140236
ChadTDTCD148235
ChileCLCHL15256
ChinaCNCHN15686
Christmas IslandCXCXR16261
Cocos (Keeling) IslandsCCCCK16661
ColombiaCOCOL17057
ComorosKMCOM174269
CongoCGCOG178242
Democratic Republic of the CongoCDCOD180243
Cook IslandsCKCOK184682
Costa RicaCRCRI188506
CroatiaHRHRV191385
CubaCUCUB19253
CuracaoCWCUW531599
CyprusCYCYP196357
Czech RepublicCZCZE203420
Cote d’IvoireCICIV384225
DenmarkDKDNK20845
DjiboutiDJDJI262253
DominicaDMDMA2121-767
Dominican RepublicDODOM2141-809,1-829,1-849
EcuadorECECU218593
EgyptEGEGY81820
El SalvadorSVSLV222503
Equatorial GuineaGQGNQ226240
EritreaERERI232291
EstoniaEEEST233372
EthiopiaETETH231251
Falkland Islands (Malvinas)FKFLK238500
Faroe IslandsFOFRO234298
FijiFJFJI242679
FinlandFIFIN246358
FranceFRFRA25033
French GuianaGFGUF254594
French PolynesiaPFPYF258689
French Southern TerritoriesTFATF260262
GabonGAGAB266241
GambiaGMGMB270220
GeorgiaGEGEO268995
GermanyDEDEU27649
GhanaGHGHA288233
GibraltarGIGIB292350
GreeceGRGRC30030
GreenlandGLGRL304299
GrenadaGDGRD3081-473
GuadeloupeGPGLP312590
GuamGUGUM3161-671
GuatemalaGTGTM320502
GuernseyGGGGY83144
GuineaGNGIN324224
Guinea-BissauGWGNB624245
GuyanaGYGUY328592
HaitiHTHTI332509
Heard Island and McDonald IslandsHMHMD334672
Holy See (Vatican City State)VAVAT336379
HondurasHNHND340504
Hong KongHKHKG344852
HungaryHUHUN34836
IcelandISISL352354
IndiaININD35691
IndonesiaIDIDN36062
Iran, Islamic Republic ofIRIRN36498
IraqIQIRQ368964
IrelandIEIRL372353
Isle of ManIMIMN83344
IsraelILISR376972
ItalyITITA38039
JamaicaJMJAM3881-876
JapanJPJPN39281
JerseyJEJEY83244
JordanJOJOR400962
KazakhstanKZKAZ3987
KenyaKEKEN404254
KiribatiKIKIR296686
Korea, Democratic People’s Republic ofKPPRK408850
Korea, Republic ofKRKOR41082
KuwaitKWKWT414965
KyrgyzstanKGKGZ417996
Lao People’s Democratic RepublicLALAO418856
LatviaLVLVA428371
LebanonLBLBN422961
LesothoLSLSO426266
LiberiaLRLBR430231
LibyaLYLBY434218
LiechtensteinLILIE438423
LithuaniaLTLTU440370
LuxembourgLULUX442352
MacaoMOMAC446853
Macedonia, the Former Yugoslav Republic ofMKMKD807389
MadagascarMGMDG450261
MalawiMWMWI454265
MalaysiaMYMYS45860
MaldivesMVMDV462960
MaliMLMLI466223
MaltaMTMLT470356
Marshall IslandsMHMHL584692
MartiniqueMQMTQ474596
MauritaniaMRMRT478222
MauritiusMUMUS480230
MayotteYTMYT175262
MexicoMXMEX48452
Micronesia, Federated States ofFMFSM583691
Moldova, Republic ofMDMDA498373
MonacoMCMCO492377
MongoliaMNMNG496976
MontenegroMEMNE499382
MontserratMSMSR5001-664
MoroccoMAMAR504212
MozambiqueMZMOZ508258
MyanmarMMMMR10495
NamibiaNANAM516264
NauruNRNRU520674
NepalNPNPL524977
NetherlandsNLNLD52831
New CaledoniaNCNCL540687
New ZealandNZNZL55464
NicaraguaNINIC558505
NigerNENER562227
NigeriaNGNGA566234
NiueNUNIU570683
Norfolk IslandNFNFK574672
Northern Mariana IslandsMPMNP5801-670
NorwayNONOR57847
OmanOMOMN512968
PakistanPKPAK58692
PalauPWPLW585680
Palestine, State ofPSPSE275970
PanamaPAPAN591507
Papua New GuineaPGPNG598675
ParaguayPYPRY600595
PeruPEPER60451
PhilippinesPHPHL60863
PitcairnPNPCN612870
PolandPLPOL61648
PortugalPTPRT620351
Puerto RicoPRPRI6301
QatarQAQAT634974
RomaniaROROU64240
Russian FederationRURUS6437
RwandaRWRWA646250
ReunionREREU638262
Saint BarthelemyBLBLM652590
Saint HelenaSHSHN654290
Saint Kitts and NevisKNKNA6591-869
Saint LuciaLCLCA6621-758
Saint Martin (French part)MFMAF663590
Saint Pierre and MiquelonPMSPM666508
Saint Vincent and the GrenadinesVCVCT6701-784
SamoaWSWSM882685
San MarinoSMSMR674378
Sao Tome and PrincipeSTSTP678239
Saudi ArabiaSASAU682966
SenegalSNSEN686221
SerbiaRSSRB688381
SeychellesSCSYC690248
Sierra LeoneSLSLE694232
SingaporeSGSGP70265
Sint Maarten (Dutch part)SXSXM5341-721
SlovakiaSKSVK703421
SloveniaSISVN705386
Solomon IslandsSBSLB90677
SomaliaSOSOM706252
South AfricaZAZAF71027
South Georgia and the South Sandwich IslandsGSSGS239500
South SudanSSSSD728211
SpainESESP72434
Sri LankaLKLKA14494
SudanSDSDN729249
SurinameSRSUR740597
Svalbard and Jan MayenSJSJM74447
SwazilandSZSWZ748268
SwedenSESWE75246
SwitzerlandCHCHE75641
Syrian Arab RepublicSYSYR760963
TaiwanTWTWN158886
TajikistanTJTJK762992
United Republic of TanzaniaTZTZA834255
ThailandTHTHA76466
Timor-LesteTLTLS626670
TogoTGTGO768228
TokelauTKTKL772690
TongaTOTON776676
Trinidad and TobagoTTTTO7801-868
TunisiaTNTUN788216
TurkeyTRTUR79290
TurkmenistanTMTKM795993
Turks and Caicos IslandsTCTCA7961-649
TuvaluTVTUV798688
UgandaUGUGA800256
UkraineUAUKR804380
United Arab EmiratesAEARE784971
United KingdomGBGBR82644
United StatesUSUSA8401
United States Minor Outlying IslandsUMUMI5811
UruguayUYURY858598
UzbekistanUZUZB860998
VanuatuVUVUT548678
VenezuelaVEVEN86258
Viet NamVNVNM70484
British Virgin IslandsVGVGB921-284
US Virgin IslandsVIVIR8501-340
Wallis and FutunaWFWLF876681
Western SaharaEHESH732212
YemenYEYEM887967
ZambiaZMZMB894260
ZimbabweZWZWE716263

The 2-letter codes shown below are supplied by the ISO ( International Organization for Standardization). It bases its list of country names and abbreviations on the list of names published by the United Nations. The UN also uses 3-letter codes, and numerical codes to identify nations, and those are shown below.

Adobe follow A3 (UN) notation for geo_country column.If visit has to be matched to Analytics reports for a specific country then the query is as follows:

select count(distinct(concat(post_visid_high,post_visid_low,visit_num))),
pagename, page_event, post_event_list from test12345 where exclude_hit = ‘0’ and geo_country = ‘bra’ and hit_source = ‘1’ and bot_id = ‘0’;

For Visit following is the query:

select count(distinct(concat(post_visid_high,post_visid_low,visit_num))),
pagename, page_event, post_event_list from test12345 where exclude_hit = ‘0’ and hit_source = ‘1’ and bot_id = ‘0’;

Dynamically Populate Value In dataLayer

While checking about dataLayer I came across: https://www.optimizesmart.com/google-tag-manager-data-layer-explained-like-never/

Example of dataLayer

On any web page test yourself by pasting the code

1.Paste the following code

<script>

  var dataLayer = {

‘pageName’: document.title,

‘pageURL’: document.URL

                                };

</script>

You can check these in console via

  • dataLayer.PageName
  • datLayer.pageURL

2.If you paste the following:

<script>

dataLayer = [{

‘pageCategory’: ‘Statistics’,

‘visitorType’: ‘high-value’

}];

</script>

You can check these in console via

  • dataLayer[0].pageCategory
  • dataLayer[0].visitorType

3.If you paste the following :

<script>

dataLayer = [{

‘pageCategory’: ‘Statistics’,

‘visitorType’: ‘high-value’

},

{‘nameA’:’salena’,

‘nameB’:’gomes’

}];

</script>

You can check these in console via

  • dataLayer[0].pageCategory
  • dataLayer[0].visitorType
  • dataLayer[1].nameA
  • dataLayer[1].nameB

4.

5.

digitalData.page = {};

digitalData.page.pageInfo = {};

digitalData.page.pageInfo.pageName = “Electronics>Computers>MacbookPro:ProductDetails”;

6.

digitalData.page={

       pageInfo:{

             pageName:”HomePage”,

       },

       category:{

             pageType:”Home”,

             primaryCategory:”Home”,

             subCategory1:”n/a”,

             subCategory2:”n/a”

       }

}

Please let me know if you have any question by your comment in the comment section.

How to Capture multiple query parameters in the s.util.getQueryparam

Requirement : Want to capture the multiple query parameters in s.campaign variable of Adobe Analytics.

URL:www.example.com?cmpid=hhhh&source=ssss&medium=dddd

Use the following code:

s.campaign = s.Util.getQueryParam(‘cmpid’)+”:”+s.Util.getQueryParam(‘source’)+”:”+s.Util.getQueryParam (‘medium’);

Result: s.campaign =hhhh:ssss:dddd

How to track survey score through Adobe Analytics?

Almost all the companies have surveyed and want to keep track of it for the holistic view of customer satisfaction.

In a survey the possible outcome of a score that can be any of the following numbers- 0,1,2,3,4,5,6,7,8,9,10

The business question can be that what is the best way to capture this score to then be able to calculate the average score through Adobe Analytics.

In Adobe Analytics there is no predefined formula that it can be implemented.

While solving this business problem I came up with two methods.

Method 1:

Step 1 : Take an eVar with the following setting

Step 2: Take an event with the following settings

Step 3: Create a calculate metric

Final Report:

Method 2:

  1. Take an eVar which capture the score
  2. Take counter event which captures the score
  3. Take numeric event to capture the score in the numeric format
  4. Create a calculated metric with the following settings.

 

Final Report:

Please let me know if you have any doubt through comment section, will be happy to reply on it.

Why segment is missing in Data Connector?

Data Connector is formerly known as Genesis. Adobe Data Connectors provide a complete development ecosystem to help Data Connectors partners integrate their products and services into the Adobe Experience Cloud.

Segment created in Adobe Analytics can be reused in Data Connector as Remarketing Segment.
Sometimes the segment is not available in Data Connector. There can be multiple reasons for it like

1. Data Connector owner does not have access to segment
2.The segment is not shared to owner

The major point often get missed, is the compatibility.If the segment is not compatible to Data Warehouse then it will not be available under Data Connector for re-marketing segment.