Excel做的标签生成器的范本.xlsVIP

Banner - SAMPLE formula input Methodology Variable Name Description 1. Enter Base URL for LP (SA CM) 2. Enter Campaign Name (SA CM) 3. Enter Tactic Code (SA CM) 8 digit alphanumeric code 4. Enter Media (SurfAid) e.g. banner, psearch, print 5. Enter Media Delivery Format (CM) e.g. b,k,p geocountry_progthemelpname-yyyymmdd Directions ? Fill in All Cells that are shaded with Yellow backgrounds (Refer to Methodology tab for Help) ? Take the generated URLs and paste them as values in column D, so that they can be easily transferred elsewhere High Level Information (Fill in Once) Info to Fill In (*all letters must be lower case*) b Generated URLs Paste Generated URLs as Values Here Detailed Information (for By Referring Domain Analysis) 7. Enter Specific Referring Domain with no spaces (e.g. websitename, searchkeyword) BANNER URL Generation Sheet Methodology ? The information below describes the referral tagging methodology for both SurfAid Coremetrics, and the steps necessary to correctly fill in the URL generation sheet SurfAid Tagging Overview ? In order for results to be recorded and displayed properly by SurfAid, the URLs generated for tracking by referring media source must be encoded with the correct parameters detailed below: ? Base URL?ca=valueme=valuemet=valuere=values_tact=value ? ca = campaign name ? me = media ? banner, psearch, ibm, print, tv, synd, etc. ? met = media type ? re= referring domain ? For banners it’s the website name, for search it’s the individual keyword, for print its 0 (unless you have different URLs per publication) ? s_tact = tactic code ? 8 digit alpha-numeric code ? Example: Coremetrics Tagging Overview ? In addition to tagging for SurfAid, all campaigns at this time should also be tagged for Coremetrics tracking (to provide historical data for when SurfAid is shut down) ? This requires the cm_mmc parameter that contains four values: ? cm_mmc= TacticCode-_-MediaDeliveryFormat-_-Placement-_-CampaignName-yyyymmdd ? Tactic code