{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Request settings","Mailing","Case","Blog Post","Landing Page","Webform","Pop-up","A-B Testing","SEO Internal pages","Competitors Research","SEA Search Network","SEA Display Network","YouTube Ad","Facebook Campaign","Twitter Campaign","LinkedIn Campaign","x"],"not_rendered":{"charts":0,"images":112,"macros":1,"external_links":0,"defined_names":34,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Request settings","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,3,37,3],[29,1,29,2],[0,1,0,2],[3,1,3,2],[11,1,11,2],[22,1,26,1],[28,1,28,2],[18,1,21,1]]}
[null,"Request settings"]
[]
[]
[null,"Requester Information"]
["*","Business Unit","Corporate"]
["*","Office","Materialise HQ"]
["*","Responsible","Eirini Ieremia"]
["*","Stakeholders","Valerie Vervueren"]
["*","Back up responsible","Liesbeth Kemel"]
[]
[]
[null,"Project Information"]
[null,"Goal / Purpose of the project","Increase traffic to amace page + conversions"]
[null,"Target Audience","Orthopedic Surgeons"]
[null,"Type of Campaign","Lead"]
[null,"Target Product","aMace"]
[null,"CRM campaign link"]
[null,"Project KPIs"]
[null,"Promotion channels"]
[null,null,"Social Networks:"]
[null,null,"SEA:"]
[null,null,"Other: "]
[null,"Insert existing sources links"]
[]
[]
[]
[]
[]
[null,"All the content should be approved by Central Communication Unit"]
[null,"What do you want to request?",null,"Selecting the item will open extra tab in this excel workbook with all the fields for request details\nPlease fill it in"]

{"sheet":"Mailing","index":1,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":true,"merged":[[0,1,0,2],[4,1,4,2],[14,1,14,2],[27,1,27,2],[31,1,31,2],[3,1,3,2],[21,1,21,2],[35,3,36,3],[39,1,39,2],[59,1,59,2],[60,1,60,2],[33,3,34,3],[35,1,36,1]]}
[null,"Mailing Campaign"]
[]
[]
[null,"I have read the SOP document on email campaign processing"]
[null,"Campaign information"]
["*","Send out date",{"$f":"TODAY()+3","v":"2018-04-08"},"Only 4 campaigns in one day possible. Check calendar load"]
["*","Business Unit"]
["*","Office"]
["*","Campaign Title"]
["*","CRM campaign name",null,"Every mailing campaign should be connected to CRM campaign "]
["*","Updating preferences options",null,"The options are TBD"]
["*","Campaign type"]
[]
[]
[null,"MailChimp campaign settings"]
["*","MailChimp campaign name",{"$f":"CONCATENATE(TEXT(C6,\"YYYY-MM-DD\"),\" |\",C7,IF(AND(COUNTA(C7),COUNTA(C8)),\" \",\"\"),C8,\"| \",C9)","v":"YYYY-04-08 || "},"Copy generated value to Campaign Name field in MailChimp. This will help to search campaign easily"]
["*","Subject",null,"Check your subject here"]
["*","Preview text"]
["*","Sender name"]
["*","Sender email address"]
[]
[null,"A/B test campaign settings"]
[null,"What will you test?"]
[null,"Variable value 2"]
[null,"What % of your recipients list will receive test combinations?"]
[]
[]
[null,"Google Analytics campaign settings"]
["*","GA campaign title",{"$f":"LEFT(CONCATENATE(TEXT(C6,\"YYYYMMDD\"),\"_\",C7,IF(AND(COUNTA(C7),COUNTA(C8)),\"_\",\"\"),C8,\"_\",SUBSTITUTE(C9,\" \",\"_\")),50)","v":"YYYY0408__"},"Copy generated value to GA campaign title field in MailChimp"]
[]
[]
[null,"Content"]
["*","Briefing folder link",null,"Tips & tricks on mailing structuring"]
[null,"Focus CTA text"]
[null,"Focus CTA link"]
[null,"Mail languages",null,"Indicate mail languages. Translations will be requested by Mailing Engineer"]
[null,null,"English"]
[]
[]
[null,"Extra Information"]
[null,"Previous campaign link\n(from same series)"]
[null,"Campaign goal",null,"E.g. get new registrants, informational mailing, product release announcment"]
[]
[]
[null,"Recipients list"]
["*","Origin"]
[null,"Previous campaign link"]
[null,"Lists storage link"]
[]
[]
[null,"Personalised settings"]
[null,"Indicate the fields of personalization",null,"E.g. First name, Last name"]
[]
[]
[null,"Pre-populated fields for webform"]
[null,"Webform link"]
[null,"Indicate the fields for pre-filling",null,"E.g. First name, Last name, Company, Email address"]
[]
[]
[null,"Comments"]

{"sheet":"Case","index":2,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":true,"merged":[[27,0,31,0],[27,1,31,1],[27,4,31,4],[40,4,42,4],[37,1,37,3],[38,2,38,3],[39,2,39,3],[40,1,42,1],[34,2,34,3],[32,1,33,1],[32,2,33,3],[44,1,48,1],[44,2,44,3],[18,4,20,4],[20,2,20,3],[21,2,21,3],[25,2,25,3],[26,2,26,3],[18,2,18,3],[19,2,19,3],[24,1,24,3],[18,1,20,1],[45,4,48,4],[46,2,46,3],[47,2,47,3],[48,2,48,3],[43,2,43,3],[52,1,52,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[0,1,0,3],[3,1,3,3],[4,2,4,3],[5,2,5,3],[8,2,8,3],[7,2,7,3],[14,1,14,3],[15,2,15,3],[51,1,51,3],[45,2,45,3],[16,2,16,3],[17,2,17,3]]}
[null,"Case"]
[]
[]
[null,"General Info"]
["*","Title"]
["*","Publish date",{"$f":"TODAY()+1","v":"2018-04-06"}]
["*","Available languages",null,"English","Check the available languages in the dropdown and click Save"]
[null,"Preferred URL structure"]
["*","Owner Channel"]
[null,"Related Channels"]
[null,"Industry"]
["*","Keywords",null,null,"The full list of keywords"]
[null,null,null,null,"To request more keywords discuss this with CCU (Sarah Verhaeghe)"]
[]
[null,"Content"]
["*","Teaser Description"]
["*","Briefing folder link"]
[null,"Mockup example"]
[null,"Image(s)",null,null,"Links to Media Library (Bynder) images"]
[]
[]
[null,"Video"]
[]
[]
[null,"Meta Information (SEO, social networks)"]
[null,"Preferred meta title"]
[null,"Preferred meta description"]
["*","Images alt texts","Image file name","Alt text","Provide alternative texts for all content images on the page. Not applicable for background images "]
[]
[]
[]
[]
[null,"Meta Keywords",null,null,"More information about keywords"]
[null,null,null,null,"Keyword generator"]
[null,"Open Graph Image"]
[]
[]
[null,"Extra Information",null,null,"Case layout example"]
[null,"Challenge"]
[null,"Solution"]
[null,"Software used","Product name","Webpage link","Names of products and links to their pages"]
[]
[]
[null,"Insight"]
[null,"Related cases","Dynamic selection"]
[null,null,null,null,"If Manual Selection: Insert related cases links (max. 4) "]
[]
[]
[]
[]
[]
[null,"Comments"]

{"sheet":"Blog Post","index":3,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":true,"merged":[[28,2,28,3],[29,2,29,3],[30,0,34,0],[30,1,34,1],[40,1,40,3],[37,2,37,3],[35,2,36,3],[35,1,36,1],[41,2,41,3],[42,2,42,3],[49,1,49,3],[50,1,50,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[43,1,46,1],[44,4,46,4],[21,1,23,1],[14,2,14,3],[13,2,13,3],[12,2,12,3],[30,4,34,4],[21,4,23,4],[17,1,17,3],[18,2,18,3],[19,2,19,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[20,2,20,3],[27,1,27,3],[4,2,4,3],[3,1,3,3],[5,2,5,3],[11,2,11,3],[10,2,10,3],[9,2,9,3],[8,2,8,3],[7,2,7,3]]}
[null,"Blog Post"]
[]
[]
[null,"General Info"]
["*","Title"]
["*","Publish date",{"$f":"TODAY()+2","v":"2018-04-07"}]
["*","Available languages",null,"English","Check the available languages in the dropdown and click Save"]
[null,"Preferred URL structure",null,null," "]
["*","Author's name"]
["*","Author's email address"]
["*","Owner Channel","Corporate"]
[null,"Related Channels"]
[null,"Industries"]
["*","Categories",null,null,"To request more categories and keywords discuss this with CCU (Sarah Verhaeghe)"]
["*","Keywords",null,null,"The full list of keywords"]
[]
[]
[null,"Content"]
["*","Teaser Description"]
["*","Briefing folder"]
[null,"Mockup example"]
[null,"Image(s)",null,null,"Links to Media Library (Bynder) images"]
[]
[]
[null,"Video"]
[]
[]
[null,"Meta Information (SEO, social networks)"]
[null,"Preferred meta title"]
[null,"Preferred meta description"]
["*","Images alt texts","Image file name","Alt text","Provide alternative texts for all content images on the page. Not applicable for background images "]
[]
[]
[]
[]
[null,"Meta Keywords",null,null,"More information about keywords"]
[null,null,null,null,"Keyword generator"]
[null,"Open Graph Image",null,null,"By default the teaser image will be used"]
[]
[]
[null,"Extra Information"]
[null,"Focus CTA text"]
[null,"Focus CTA link"]
[null,"Related blog posts","Dynamic selection"]
[null,null,null,null,"If Manual Selection: Insert related blog posts links (max. 3) "]
[]
[]
[]
[]
[null,"Comments"]

{"sheet":"Landing Page","index":4,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":true,"merged":[[16,0,17,0],[10,2,10,3],[11,2,11,3],[12,2,12,3],[15,1,15,3],[20,4,22,4],[21,2,21,3],[22,2,22,3],[3,1,3,3],[5,2,5,3],[6,2,6,3],[9,2,9,3],[4,2,4,3],[16,1,17,1],[16,4,17,4],[31,0,35,0],[31,1,35,1],[18,2,18,3],[19,2,19,3],[20,1,22,1],[20,2,20,3],[51,1,51,3],[24,2,24,3],[25,2,25,3],[31,4,35,4],[38,2,38,3],[41,1,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[28,1,28,3],[29,2,29,3],[30,2,30,3],[36,1,37,1],[36,2,37,3],[0,1,0,3],[7,2,7,3],[47,2,47,3],[46,2,46,3],[50,1,50,3],[23,2,23,3]]}
[null,"Landing Page"]
[]
[]
[null,"General Info"]
["*","Title"]
["*","Goal / Purpose"]
["*","Publish date",{"$f":"TODAY()+2","v":"2018-04-07"}]
[null,"End date"]
["*","Available languages",null,"English","Check the available languages in the dropdown and click Save"]
[null,"Preferred URL structure",null,null," "]
["*","Owner Channel","Corporate"]
[null,"Industry"]
[null,"Keywords",null,null,"The full list of keywords"]
[null,null,null,null,"To request more keywords discuss this with CCU (Sarah Verhaeghe)"]
[]
[null,"Content"]
["*","Page type",null,null,"If the landing page is dedicated to some event it's possible to use Event page template"]
[null,null,"Example","Example"]
["*","Briefing folder"]
[null,"Mockup example"]
[null,"Image(s)",null,null,"Links to Media Library (Bynder) images"]
[]
[]
[null,"Video"]
[null,"Metroblock example"]
[null,"About Materialise section"]
[]
[]
[null,"Meta Information (SEO, social networks)"]
[null,"Preferred meta title"]
[null,"Preferred meta description"]
["*","Images alt texts","Image file name","Alt text","Provide alternative texts for all content images on the page. Not applicable for background images "]
[]
[]
[]
[]
[null,"Meta Keywords",null,null,"More information about keywords"]
[null,null,null,null,"Keyword generator"]
[null,"Open Graph Image"]
[]
[]
[null,"Extra Information"]
[null,"Focus CTA text"]
[null,"Focus CTA link"]
[null,"Hide main navigation"]
[null,"Hide standard footer"]
[null,"Expiration behavior"]
[null,"Redirect URL on expiration date",null,null,"E.g. http://www.materialise.com/en/event-missed"]
[]
[]
[null,"Comments"]

{"sheet":"Webform","index":5,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":true,"merged":[[63,1,63,3],[64,1,64,3],[18,2,18,3],[17,2,17,3],[23,2,23,3],[22,1,23,1],[19,2,19,3],[20,2,20,3],[22,2,22,3],[30,2,30,3],[31,2,31,3],[21,2,21,3],[28,2,28,3],[27,2,27,3],[26,1,26,3],[47,1,47,5],[0,1,0,3],[8,2,8,3],[12,1,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[4,2,4,3],[16,2,16,3],[19,1,21,1],[3,1,3,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[10,2,10,3],[41,2,41,3],[42,2,42,3],[42,1,43,1],[43,2,43,3],[39,2,39,3],[40,2,40,3],[29,2,29,3],[32,2,33,3],[37,2,37,3],[38,2,38,3],[36,1,36,3],[32,1,33,1]]}
[null,"Webform"]
[]
[]
[null,"General Info"]
[null,"Purpose"]
["*","Webform location"]
[null,"Page url"]
["*","Publish date",{"$f":"TODAY()+2","v":"2018-04-07"}]
[null,"Close date or condition",null,null,"E.g. close after 20 submissions"]
["*","Languages",null,"English"]
[null,null,"Check the languages in the dropdown and click Save"]
[]
[null,"CRM Connection"]
["*","CRM Campaign name "]
["*","Business Unit"]
["*","Response type"]
[null,"Priority status","Normal "]
[null,"Subject"]
["*","Owning user / Owning team"]
[null,"Interest value(s)"]
[]
[]
[null,"Send email alerts to:"]
[]
[]
[]
[null,"Dedicated page content"]
["*","Page title"]
["*","Intro text"]
[null,"Page redirect url after form is closed"]
[null,"Preferred meta title"]
[null,"Preferred meta description"]
[null,"Meta Keywords",null,null,"More information about keywords"]
[null,null,null,null,"Keyword generator"]
[]
[]
[null,"Webform settings"]
["*","Submit button title","Submit"]
["*","Post submit behavior"]
["*","Thank you message"]
[null,"Post submit page url"]
[null,"Webform closed message"]
[null,"Send auto mail to user after submission?"]
[null,null,null,null,"Insert mail briefing url"]
[]
[]
[null,"If webform has several languages insert field translations by adding column at the end"]
[null,"Webform fields"]
[null,"Field title","Field type","Mandatory","Prefilled (default value)","Field Options\n(for checkboxes, radio buttons, select boxes)","Extra conditions \n(visibility, limitations)","Field title translation \nlanguage: ____"]
[null,"First name","Text field"]
[null,"Last name","Text field"]
[null,"Email","Business email (validated)"]
[null,"Company","Text field"]
[null,"What software do you use?","Checkboxes"]
[null,"Commercial newsletter subscription","Checkbox"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Comments"]

{"sheet":"Pop-up","index":6,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[[21,1,21,2],[29,1,29,2],[30,1,30,2],[5,0,8,0],[0,1,0,2],[3,1,3,2],[5,1,8,1],[5,3,8,3],[14,1,14,2]]}
[null,"Pop-up"]
[]
[]
[null,"General information"]
["*","Pop-up purpose"]
["*","Page Url(s)",null,"E.g. http://www.materialise.com/en/medical/software/materialise-mimics-inprint"]
[]
[]
[]
["*","Start date",{"$f":"TODAY() + 1","v":"2018-04-06"}]
[null,"End date or condition",null,"E.g. 20 submissions received in pop-up form"]
[]
[]
[]
[null,"Behavior and tracking"]
["*","Trigger",null,"E.g. Appear on Page after X seconds, Appear on Page when certain action happened, Appear for certain visitors sergment"]
["*","Pop-up main action",null,"E.g. click on button leads to http://www.materialise.com/en/events/medical, submit Blog Subscription Form and refresh the current page"]
["*","KPI",null,"E.g. Blog registrations, Download Requests, Page Visits, Time Spent on Page"]
["*","Desired result",null,"E.g. Blog subscriptions conversion rate increased by 5%, get 20 webinar registrations"]
[]
[]
[null,"Pop-up Layout",null,"Check layout options in styleguide"]
[null,"Theme",null,"Tip: Use transparent theme for video pop-up"]
[null,"Vertical position"]
[null,"Window size"]
[null,"Background image"]
[null,"Closing option"]
[]
[]
[null,"Comments"]

{"sheet":"A-B Testing","index":7,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,1,0,2],[3,1,3,2],[6,1,9,1],[21,1,21,2],[15,1,15,2],[6,0,9,0],[22,1,24,1],[22,3,24,3],[28,1,28,2],[29,1,29,2],[6,3,9,3]]}
[null,"A/B Testing"]
[]
[]
[null,"General information"]
["*","Hypothesis ",null,"E.g. Changing CTA button to \"Download Mimics\" will boost conversion rate for Mimics Software"]
[null,"\"Master\" Page"]
["*","Active Url(s)",null,"E.g.\n- certain url(s)\n- all medical blog posts + medical blog feed\n- sitewide"]
[]
[]
[]
[null,"Segmentation","All Visitors","E.g. include/exclude specific visitor segments (chrome users, mobile and tablet visitors)"]
["*","Start date",{"$f":"TODAY() + 1","v":"2018-04-06"}]
["*","End date or condition",null,"The experiment can be finished when a winner is determined with certain probability."]
[null,null,null,"Calculate the A/B experiment duration"]
[]
[null,"A/B variations"]
["*","Version A"]
["*","Version B"]
[null,"Extra conditions"]
[]
[]
[null,"Experiment results"]
["*","KPI(s)",null,"1 primary GA goal is required.\nUp to 2 additional GA goals can be set"]
[]
[]
[null,"Desired result",null,"E.g. the winner is defined with 85% probability"]
[]
[]
[null,"Comments"]

{"sheet":"SEO Internal pages","index":8,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":true,"merged":[[33,1,33,3],[34,1,34,3],[3,1,3,3],[15,1,15,3],[20,1,25,1],[10,2,10,3],[11,2,11,3],[12,2,12,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[26,0,30,0],[0,1,0,3],[7,2,7,3],[7,1,9,1],[7,4,9,4],[20,0,25,0],[7,0,9,0],[8,2,8,3],[9,2,9,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[20,4,25,4],[26,1,30,1],[26,4,30,4],[19,2,19,3]]}
[null," SEO for internal pages"]
[]
[]
[null,"General information"]
["*","Campaign name",null,null,"E.g. materialise.com/en/manufacturing/materialise-onsite page optimization"]
["*","Goal",null,null,"E.g. improve page SEO quality score, …"]
["*","Key message / topic",null,null,"E.g. maximize traffic, number of leads, revenue from organic channel, ..."]
["*","Page Url(s)"]
[]
[]
["*","Estimated keywords ",null,null,"Useful information: http://ultimatekeywordhunter.com/, http://lsigraph.com/"]
[null,"Сompetitors "]
["*","KPIs",null,null,"E.g. SERPs, organic traffic, conversions / transaction through organic channel"]
[]
[]
[null,"Page settings"]
["*","Preferred meta title"]
["*","Preferred meta description"]
[null,"Preferred URL structure"]
[null,"Content optimization",null,null,"Page should have minimum 150-200 words of content, no exceptions.\nCheck improvements tutorial\nhttp://searchengineland.com/complete-guide-optimizing-content-seo-checklist-269884"]
[null,"Internal crosslinking","CTA / link text","Link url","Add links to other related pages. Paste one link in one cell"]
[]
[]
[]
[]
[]
[null,"Images alt texts","Image file name","Alt text","Provide alternative texts for all content images on the page. Not applicable for background images "]
[]
[]
[]
[]
[]
[]
[null,"Comments"]

{"sheet":"Competitors Research","index":9,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,1,0,2],[3,1,3,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[7,3,9,3],[7,0,9,0],[7,1,9,1],[20,1,20,2],[21,1,21,2],[16,1,16,2],[17,1,17,2]]}
[null,"SEO / SEA Competitors  Research"]
[]
[]
[null,"General information"]
["*","Research type"]
["*","Competitor name",null,"E.g. 3dhubs.com"]
["*","Goal",null,"E.g. check stats on our competitor, find best practice and reuse them"]
["*","Competitor Url(s)"]
[]
[]
["*","Estimated keywords "]
[null,"Target country"]
[]
[null,"Research checkpoints"]
[]
[]
[]
[]
[]
[]
[null,"Comments"]

{"sheet":"SEA Search Network","index":10,"n_rows":108,"n_cols":4,"rows_kept":108,"cut":false,"hidden":false,"merged":[[101,1,101,2],[94,1,94,2],[95,1,95,2],[98,1,98,2],[99,1,99,2],[19,3,20,3],[91,1,91,2],[92,1,92,2],[26,1,26,2],[37,1,37,2],[45,1,45,2],[53,1,53,2],[63,1,63,2],[71,1,71,2],[76,1,76,2],[81,1,81,2],[87,1,87,2],[88,1,88,2],[0,1,0,2],[25,1,25,2],[29,1,29,2],[62,1,62,2],[66,1,66,2],[3,1,3,2],[19,1,20,1]]}
[null,"SEA Search Network"]
[]
[]
[null,"General Info"]
["*","Campaign name","aMace ","E.g. Mimics InPrint Spring Sale Offer Campaign"]
["*","Start date","2018-04-15"]
["*","End date","2018-08-15"]
[null,"Scheduling","always","E.g. business hours, working days, …"]
["*","Campaign goal","drive traffic to the aMace page","E.g. drive traffic to the InPrint page, test CTA with price"]
[null,"Key message / topic",null,"E.g. Limited offer: Try InPrint for a month"]
["*","Destination URL","http://www.materialise.com/en/medical/patient-specific-implants/patient-specific-acetabular-implants-amace"]
["*","Total Budget",1500]
["*","KPI","10 contact requests","E.g. 10 session registrations"]
[null,"Registration Value",null,"E.g. 100 EUR per registration"]
[]
[]
["*","Networks"]
["*","Devices",null,"The page should have devices adapted design"]
["*","Target countries","Germany, Austria, Switzerland, France, UK, Ireland, BE, Netherlands, Luxembourg, Denmark, Sweden, Finland, Norway, Poland, South-Africa, Australia\n"]
[null,"Target languages",null,"Select languages from the list or specify your value in the cell below\nBy default: all languages"]
[null,null,"All languages"]
["*","Initial keywords","https://home.materialise.net/sites/staff/marketing/onlinemarketing/_layouts/15/xlviewer.aspx?id=/sites/staff/marketing/onlinemarketing/Digital%20Projects%20Briefings/Medical/aMace%20Adwords%20Campaign/Keywords%20longlist%20aMace%20EN%20analysis.xlsx&Source=https%3A%2F%2Fhome%2Ematerialise%2Enet%2Fsites%2Fstaff%2Fmarketing%2Fonlinemarketing%2FDigital%2520Projects%2520Briefings%2FForms%2FAllItems%2Easpx%3FRootFolder%3D%252Fsites%252Fstaff%252Fmarketing%252Fonlinemarketing%252FDigital%2520Projects%2520Briefings%252FMedical%252FaMace%2520Adwords%2520Campaign%26FolderCTID%3D0x012000F8E4482BCFE21C4A960ADDEB033FF0DF%26View%3D%257B48DFA586%252DF662%252D457D%252D9328%252DDF502BE870F6%257D","E.g. additive manufacturing, rapid prototyping"]
[null,"Remarketing list rules","All ortho page website visitors","E.g. Remarketing List for Search Ads"]
[]
[]
[null,"Text ads"]
[null,"After keyword research is done by SEA Engineer provide at least 3-4 ad variations to rotate them and use for different ad groups."]
[null,"Read more here:","https://support.google.com/adwords/answer/1704389?hl=en"]
[]
["*","Text ad #1"]
[null,"Headline 1","Complex Hip Surgery"]
[null,"Headline 2","Custom Hip Replacement"]
[null,"Description","You can count on us, our 7+ years of expertise & several 100+ of hip implants."]
[null,"Path Level 1","hip_replacement"]
[null,"Path Level 2","custom_implants"]
[null,"Display URL",{"$f":"CONCATENATE(\"materialise.com / \",C34,IF(COUNTA(C35),\" / \",\"\"),C35)","v":"materialise.com / hip_replacement / custom_implants"},"This is how the Ad Url/Breadcrubms steps will be displayed"]
[]
["*","Text ad #2"]
[null,"Headline 1","Complex Hip Arthroplasty"]
[null,"Headline 2","Implants You Can Count On"]
[null,"Description","Tap into over 7 years of expertise in creating patient-specific hip implants."]
[null,"Path Level 1","hip_replacement"]
[null,"Path Level 2","implants"]
[null,"Display URL",{"$f":"CONCATENATE(\"materialise.com / \",C42,IF(COUNTA(C43),\" / \",\"\"),C43)","v":"materialise.com / hip_replacement / implants"},"This is how the Ad Url/Breadcrubms steps will be displayed"]
[]
["*","Text ad #3"]
[null,"Headline 1","Total Hip Arthroplasty"]
[null,"Headline 2","Patient-Specific Hip Implants"]
[null,"Description","Together, we create custom hip replacement devices based on CT scans."]
[null,"Path Level 1","hip_replacement"]
[null,"Path Level 2","devices"]
[null,"Display URL",{"$f":"CONCATENATE(\"materialise.com / \",C50,IF(COUNTA(C51),\" / \",\"\"),C51)","v":"materialise.com / hip_replacement / devices"},"This is how the Ad Url/Breadcrubms steps will be displayed"]
[]
[null,"Text ad #4"]
[null,"Headline 1","Full Hip Replacement Surgery"]
[null,"Headline 2","Create Custom Implants"]
[null,"Description","Always there to enable long-term hip replacements (arthroplasty) for everyone."]
[null,"Path Level 1","hip_implants"]
[null,"Path Level 2","arthroplasty"]
[null,"Display URL",{"$f":"CONCATENATE(\"materialise.com / \",C58,IF(COUNTA(C59),\" / \",\"\"),C59)","v":"materialise.com / hip_implants / arthroplasty"},"This is how the Ad Url/Breadcrubms steps will be displayed"]
[]
[]
[null,"Site link extensions"]
[null,"Optional, but can boost potential CTR.\nMinimum of 4 sitelinks must be loaded in order to be eligible to display"]
[null,"Read more here:","https://support.google.com/adwords/answer/2375416?hl=en"]
[]
["*","Site link #1"]
["*","Site link URL"]
["*","Site link title"]
[null,"Description"]
[null,"Contact us","http://www.materialise.com/en/medical/patient-specific-implants/hip-implants/contact-us"]
["*","Site link #2"]
["*","Site link URL"]
["*","Site link title"]
[null,"Description"]
[null,"Frequently asked questions","http://www.materialise.com/en/medical/patient-specific-guides/learning-support#FAQ"]
["*","Site link #3"]
["*","Site link URL"]
["*","Site link title"]
[null,"Description"]
[null,"Learn more","http://www.materialise.com/en/medical/patient-specific-implants/hip-implants/contact-us"]
["*","Site link #4"]
["*","Site link URL"]
["*","Site link title"]
[null,"Description"]
[null,"Subscribe to newsletter","http://www.materialise.com/en/medical/patient-specific-implants/patient-specific-acetabular-implants-amace"]
[]
[null,"Callout extensions"]
[null,"Optional, but can boost potential CTR.\nMinimum of 2 callouts must be loaded in order to be eligible to display"]
[null,"Read more here:","https://support.google.com/adwords/answer/6079510?hl=en"]
[]
[null,"Callout #1"]
[]
[]
[null,"Callout #2"]
[]
[]
[]
[null,"Comments"]
[]
[]
[null,"Text ad #5"]
[null,"Headline 1","Total Hip Arthroplasty  "]
[null,"Headline 2","Premium Trabecular Metal"]
[null,"Description","Always there, from total hip implants to complex acetubalar revisions."]
[null,"Path Level 1","hip_implants"]
[null,"Path Level 2","acetabular"]
[null,"Display URL",{"$f":"CONCATENATE(\"materialise.com / \",C106,IF(COUNTA(C107),\" / \",\"\"),C107)","v":"materialise.com / hip_implants / acetabular"}]

{"sheet":"SEA Display Network","index":11,"n_rows":76,"n_cols":4,"rows_kept":76,"cut":false,"hidden":true,"merged":[[71,1,71,2],[75,1,75,2],[76,1,76,2],[24,1,24,2],[0,1,0,2],[26,1,29,1],[46,1,46,2],[47,1,47,2],[50,1,50,2],[58,1,58,2],[38,1,38,2],[37,1,37,2],[39,1,39,2],[67,1,67,2],[68,1,68,2],[42,1,42,2],[26,3,29,3],[31,1,33,1],[31,3,33,3],[3,1,3,2],[18,1,19,1],[18,3,19,3]]}
[null,"SEA Display Network"]
[]
[]
[null,"General Info"]
["*","Campaign name",null,"E.g. Mimics InPrint Spring Sale Offer Campaign"]
["*","Start date",{"$f":"TODAY() + 1","v":"2018-04-06"}]
["*","End date"]
[null,"Scheduling",null,"E.g. business hours, working days, …"]
["*","Campaign goal",null,"E.g. drive traffic to the InPrint page, test CTA with price"]
[null,"Key message / topic",null,"E.g. Limited offer: Try InPrint for a month"]
["*","Destination URL"]
["*","Total Budget"]
["*","KPI",null,"E.g. 10 session registrations"]
[null,"Registration Value",null,"E.g. 100 EUR per registration"]
[]
[]
["*","Devices",null,"The page should have devices adapted design"]
["*","Target countries"]
[null,"Target languages",null,"Select languages from the list or specify your value in the cell below\nBy default: all languages"]
[null,null,"All languages"]
[null,"Bid Strategy","CPM","E.g. CPM, CPA, CPM"]
[null,"Frequency capping",null,"E.g. 5 ad views per day "]
[]
[]
[null,"Targeting",null,"At least one should be filled"]
["*","Display Keywords",null,"E.g. 3d printing, additive manufacturing, rapid prototyping"]
[null,"Manual placements URLs",null,"E.g. www.futuremedicine.com, 3dprinting-blog.com"]
[]
[]
[]
[null,"Topics & Interests",null,"Full list of topics https://support.google.com/adwords/answer/156178?hl=en\nE.g. Arts & Entertainment > Comics & Animation > Anime & Manga"]
[null,"Remarkteting audience",null,"E.g. \nhttp://www.materialise.com/en/medical/software/ page visitors, \nMWS Healthcare session visitors (but not buyers)"]
[]
[]
[null,"Target emails list"]
[]
[]
[null,"Image Ads"]
[null,"Image ads are used in most cases for Display Network"]
[null,"Requirements:\nFormats - GIF, JPG, PNG, SWF, ZIP\nMax. size - 150KB\n300 × 250, 120 × 600, 728 × 90, 250 × 250 - most popular sizes"]
[null,"Read more here:","https://support.google.com/adwords/answer/1704389?hl=en"]
[]
[null,"Image Ads"]
["*","Link to folder with images"]
[]
[]
[null,"Text ads"]
[null,"Text ads are not the best format for Display ads, but we can do it"]
[null,"Read more here:","https://support.google.com/adwords/answer/1704389?hl=en"]
[]
[null,"Text ad #1"]
[null,"Headline 1"]
[null,"Headline 2"]
[null,"Description"]
[null,"Path Level 1"]
[null,"Path Level 2"]
[null,"Display URL",{"$f":"CONCATENATE(\"materialise.com / \",C55,IF(COUNTA(C56),\" / \",\"\"),C56)","v":"materialise.com / "},"This is how the Ad Url/Breadcrubms steps will be displayed"]
[]
[null,"Text ad #2"]
[null,"Headline 1"]
[null,"Headline 2"]
[null,"Description"]
[null,"Path Level 1"]
[null,"Path Level 2"]
[null,"Display URL",{"$f":"CONCATENATE(\"materialise.com / \",C63,IF(COUNTA(C64),\" / \",\"\"),C64)","v":"materialise.com / "},"This is how the Ad Url/Breadcrubms steps will be displayed"]
[]
[]
[null,"Rich Media Ads"]
[null,"Examples https://www.richmediagallery.com/"]
[null,"Read more here:","https://support.google.com/adwords/answer/1704389?hl=en"]
[]
[null,"Rich Media Ad"]
[null,"Describe ads",null,"E.g. Ad with a moving carousel of products, \nAd with animated layers that move into place"]
[]
[]
[null,"Comments"]

{"sheet":"YouTube Ad","index":12,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":true,"merged":[[43,3,44,3],[36,1,37,1],[36,3,37,3],[19,3,20,3],[24,1,24,2],[25,1,25,2],[26,1,26,2],[48,1,48,2],[53,1,53,2],[0,1,0,2],[29,1,29,2],[41,1,41,2],[52,1,52,2],[3,1,3,2],[19,1,20,1],[34,1,34,2],[43,1,44,1]]}
[null,"YouTube Ad"]
[]
[]
[null,"General Information"]
["*","Campaign name",null,"E.g. Mimics InPrint Spring Sale Offer Campaign"]
["*","Start date",{"$f":"TODAY() + 1","v":"2018-04-06"}]
["*","End date"]
[null,"Scheduling",null,"E.g. business hours, working days, …"]
["*","Campaign goal",null,"E.g. drive traffic to the InPrint page, test CTA with price"]
[null,"Key message / topic",null,"E.g. Limited offer: Try InPrint for a month"]
["*","Destination URL"]
["*","Total Budget"]
["*","KPI",null,"E.g. 10 session registrations"]
[null,"Registration Value",null,"E.g. 100 EUR per registration"]
[]
[]
["*","Networks",null,"More info on video ad types https://support.google.com/adwords/answer/2375464"]
["*","Devices"]
["*","Target countries"]
[null,"Target languages",null,"Select languages from the list or specify your value in the cell below\nBy default: all languages"]
[null,null,"All languages"]
[null,"Frequency capping",null,"E.g. 5 ad views per day"]
[]
[]
[null,"YouTube Ad Types"]
[null,"Choose the YouTube ad type and fill in the relevant fields below."]
[null,"Video requirements:\nMust allow embedding, \nMust be public or unlisted\nTrue streaming is not allowed\nMinimum video length: 12 seconds recommended (in order for public viewcounts to be incremented)\nMaximum video length: Less than 3 minutes recommended"]
[]
[]
[null,"TrueView in-stream ad"]
["*","YouTube video URL"]
["*","Companion image file",null,"300x60 JPG, static GIF or PNG, 150 KB (50KB max for non-skippable video) "]
["*","Display URL"]
[]
[null,"TrueView video in-display ad",null,"Optional, but can boost potential CTR"]
["*","YouTube video URL"]
[null,"Image",null,"Select an option for image. If custom image: insert information about image in the cell below"]
[]
["*","Headline text"]
["*","Description "]
[]
[null,"Overlay in-video ad",null,"Optional, but can boost potential CTR"]
["*","YouTube video URL"]
[null,"Image",null,"Select an option for image. If custom image: insert information about image in the cell below"]
[]
["*","Headline text"]
["*","Description "]
[]
[null,"Display ad"]
["*","Link to folder with images",null,"Formats: GIF, JPG, PNG, SWF, ZIP\nMax. size: 150KB\nMost popular sizes: 300 × 250, 120 × 600, 728 × 90, 250 × 250"]
[]
[]
[null,"Comments"]

{"sheet":"Facebook Campaign","index":13,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":true,"merged":[[0,1,0,2],[3,1,3,2],[20,1,21,1],[20,3,21,3],[32,1,32,2],[57,1,57,2],[58,1,58,2],[16,1,16,2],[24,1,27,1],[33,1,33,2],[42,1,42,2],[49,1,49,2],[35,1,35,2]]}
[null,"Facebook Campaign"]
[]
[]
[null,"General Information"]
["*","Campaign name"]
["*","Start date",{"$f":"TODAY() + 1","v":"2018-04-06"}]
["*","End date"]
["*","Campaign goal"]
[null,"Campaign type",null,"E.g. Lead campaign, awareness campaign"]
[null,"Key message / topic"]
["*","Destination URL"]
["*","Total Budget"]
["*","KPI"]
[null,"Registration Value"]
[]
[]
[null,"Target"]
[null,"Platforms"]
[null,"Devices",null,"The page should have devices adapted design"]
["*","Target countries"]
[null,"Target languages",null,"Select languages from the list or specify your value in the cell below\nBy default: English"]
[null,null,"English"]
["*","Keywords"]
["*","Interests, target audience"]
[null,"Competitors FB profiles links"]
[]
[]
[]
[null,"Remarketing audience",null,"E.g. FB page visitors"]
[null,"Customer emails list"]
[]
[]
[null,"Ad Variations"]
[null,"For each campaign 2-3 versions of ad are required for better CTR"]
[]
["*","Variation #1"]
["*","Image",null,"Recommended image size: 1,200 x 628 pixels. Image should include minimal text."]
[null,"Image ratio","1.9:1"]
["*","Text "]
["*","Headline "]
[null,"Link description "]
[]
["*","Variation #2"]
["*","Image",null,"Recommended image size: 1,200 x 628 pixels. Image should include minimal text."]
[null,"Image ratio","1.9:1"]
["*","Text "]
["*","Headline "]
[null,"Link description "]
[]
[null,"Variation #3"]
["*","Image",null,"Recommended image size: 1,200 x 628 pixels. Image should include minimal text."]
[null,"Image ratio","1.9:1"]
["*","Text "]
["*","Headline "]
[null,"Link description "]
[]
[]
[null,"Comments"]

{"sheet":"Twitter Campaign","index":14,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,1,0,2],[3,1,3,2],[16,1,16,2],[20,1,21,1],[20,3,21,3],[62,1,62,2],[23,1,30,1],[36,1,36,2],[37,1,37,2],[39,1,39,2],[46,1,46,2],[53,1,53,2],[61,1,61,2]]}
[null,"Twitter Campaign"]
[]
[]
[null,"General Information"]
["*","Campaign name"]
["*","Start date",{"$f":"TODAY() + 1","v":"2018-04-06"}]
["*","End date"]
["*","Campaign goal"]
[null,"Campaign type",null,"E.g. Lead campaign, awareness campaign"]
[null,"Key message / topic"]
["*","Destination URL"]
["*","Total Budget"]
["*","KPI"]
[null,"Registration Value"]
[]
[]
[null,"Target"]
[null,"Platforms"]
[null,"Devices",null,"Mobile includes iOS, Android, Blackberry"]
["*","Target countries"]
[null,"Target languages",null,"Select languages from the list or specify your value in the cell below\nBy default: English"]
[null,null,"English"]
["*","Keywords"]
[null,"Followers and competitors twitter profile links"]
[]
[]
[]
[]
[]
[]
[]
[null,"Include Materailise followers"]
[null,"Remarketing audience"]
[null,"Customer emails list"]
[]
[]
[null,"Tweet Variations"]
[null,"For each campaign 2-3 versions of tweet are required for better CTR"]
[]
["*","Variation #1"]
["*","Type"]
["*","Image",null,"For image type: 1024x612 px \nFor website card: 240x96 px"]
["*","Text "]
[null,"Headline "]
[null,"Url"]
[]
["*","Variation #2"]
["*","Type"]
["*","Image",null,"For image type: 1024x612 px \nFor website card: 240x96 px"]
["*","Text "]
[null,"Headline "]
[null,"Url"]
[]
[null,"Variation #3"]
["*","Type"]
["*","Image",null,"For image type: 1024x612 px \nFor website card: 240x96 px"]
["*","Text "]
[null,"Headline "]
[null,"Url"]
[]
[]
[null,"Comments"]

{"sheet":"LinkedIn Campaign","index":15,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":true,"merged":[[47,1,47,2],[26,3,32,3],[35,1,35,2],[37,1,37,2],[46,1,46,2],[0,1,0,2],[3,1,3,2],[16,1,16,2],[20,1,23,1]]}
[null,"LinkedIn Campaign"]
[]
[]
[null,"General Information"]
["*","Campaign name"]
["*","Start date",{"$f":"TODAY() + 1","v":"2018-04-06"}]
["*","End date"]
["*","Campaign goal"]
[null,"Campaign type",null,"E.g. Lead campaign, awareness campaign"]
[null,"Key message / topic"]
["*","Destination URL"]
["*","Total Budget"]
["*","KPI"]
[null,"Registration Value"]
[]
[]
[null,"Target"]
["*","Target countries"]
["*","Industries ",null,"Choose existing Linkedin industries to target"]
[null,"Industries codes",null,"https://developer.linkedin.com/docs/reference/industry-codes#"]
[null,"Companies profile links"]
[]
[]
[]
[null,"Job titles"]
[null,"Skills"]
[null,"Company Size",null,"Optional targeting"]
[null,"Fields of Study"]
[null,"Degrees"]
[null,"Member Groups"]
[null,"Member Gender"]
[null,"Member Age"]
[null,"Years of Experience"]
[]
[]
[null,"Ads"]
[]
[null,"Ad information"]
["*","New ad / Existing ad ?"]
["*","Link"]
["*","Image",null,"Recommended image size: 1200x627 px"]
[null,"Image ratio","1.91:1","Thumbnail image displayed on mobile"]
["*","Text ",null,"Introductury text can hold approximately 600 characters max, but text is truncated around 150 characters and displays \"...read more\" to expand text."]
["*","Title"]
[]
[]
[null,"Comments"]

{"sheet":"x","index":16,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[]
[null,"System utilities",null,"Expandable lists"]
[]
[null,"yes_no",null,"industries",null,"languages",null,"channels",null,"mail_offices",null,"preferences_groups",null,"mail_business_units",null,"categories"]
[null,"Yes",null,"Aerospace & Aeronautics",null,"English",null,"Corporate",null,"HQ",null,null,null,"CCU",null,"Corporate"]
[null,"No",null,"Architecture",null,"German",null,"Software",null,"USA",null,null,null,"SAM",null," - Materialise World Summit 2017"]
[null,"Not applicable",null,"Art & Fashion",null,"French",null,"Manufacturing",null,"MAL",null,null,null,"AMS",null," - Materialise Around the World"]
[null,null,null,"Automotive",null,"Italian",null,"Medical",null,"JAP",null,null,null,"MED",null," - Materialise Culture"]
[null,null,null,"Consumer Goods",null,"Chinese",null,null,null,"KOR",null,null,null,"RapidFit",null," - Materialise Events"]
[null,"ad_scheduling",null,"Corporate",null,"Japanese",null,null,null,"COL",null,null,null,"i.mat",null," - Materialise World Conference 2015"]
[null,"Business Hours",null,"Eyewear",null,"Korean",null,null,null,"CH",null,null,null,"OnSite",null," - Social Engagement"]
[null,"Working Days",null,"Healthcare",null,"Spanish",null,null,null,"AUS",null,null,null,null,null,"Manufacturing"]
[null,null,null,"Machinery & Equipment",null,"Portuguese",null,null,null,"GER",null,null,null,null,null," - 3D Printing Materials"]
[null,null,null,"Service Bureaus & Contract Manufacturers",null,"Polish",null,null,null,"UK",null,null,null,null,null," - 3D Printing Technologies"]
[null,"manual_dynamic",null,"Software",null,"Czech",null,null,null,null,null,null,null,null,null," - Additive Manufacturing"]
[null,"Dynamic selection",null,null,null,null,null,null,null,null,null,null,null,null,null," - Rapid Prototyping"]
[null,"Manual selection",null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical"]
[null,"Not applicable",null,null,null,null,null,null,null,null,null,null,null,null,null," - Academic Research"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Anatomy Printing"]
[null,"devices",null,"popup_themes",null,"popup_vpositions",null,"popup_window_sizes",null,"popup_close_options",null,"mail_offices",null,"business_units",null," - Biomedical Engineering"]
[null,"Desktop",null,"Light theme with dark close icon",null,"Top",null,"Middle",null,"Click on overlay",null,"Materialise HQ",null,"Corporate",null," - Clinical"]
[null,"Mobile",null,"Dark theme with light close icon",null,"Middle",null,"Large",null,"Close icon + click on overlay",null,"Materialise Czech Republic",null,"Software",null," - Cardiovascular"]
[null,"Tablet",null,"Transparent theme",null,"Bottom",null,"Full screen",null,"Close icon only",null,"Materialise China",null,"Manufacturing",null," - Cranio-Maxillofacial"]
[null,null,null,null,null,null,null,null,null,null,null,"Materialise Colombia",null,"Medical",null," - Medical Events"]
[null,null,null,null,null,null,null,null,null,null,null,"Materialise France",null,"RapidFit",null," - Neurosurgery"]
[null,"crm_response_type",null,"crm_priority_status",null,"subfooter_options",null,null,null,null,null,"Materialise Germany",null,"i.materialise",null," - Oncology"]
[null,"Gave contact details",null,"Low",null,"Yes, default BU subfooter",null,null,null,null,null,"Materialise Japan",null,"OnSite",null," - Orthopedic"]
[null,"Received shared content",null,"Normal ",null,"Yes, custom",null,null,null,null,null,"Materialise Italy",null,null,null," - Radiology"]
[null,"Contact request",null,"High",null,"No",null,null,null,null,null,"Materialise Malaysia",null,null,null," - Research & Development"]
[null,"Attended panel/training",null,null,null,null,null,null,null,null,null,"Materialise Poland",null,null,null," - Urology"]
[null,"Attended",null,null,null,null,null,null,null,null,null,"Materialise UK",null,null,null,"Software"]
[null,"Scheduled meeting",null,"webform_field_types",null,"mailing_ab_test_options",null,null,null,null,null,"Materialise Ukraine",null,null,null," - 3D Design Software"]
[null,"Visited booth",null,"Text field",null,"Subject line",null,null,null,null,null,"Materialise USA",null,null,null," - 3D File Preparation Software"]
[null,"Download white paper",null,"Email",null,"From name",null,null,null,null,null,null,null,null,null," - 3D Printing Machine Communication Software"]
[null,"Download brochure",null,"Business email (validated)",null,"Content",null,null,null,null,null,null,null,null,null," - 3D Printing Process Management"]
[null,"Download marketing collateral",null,"Checkboxes",null,"Send time"]
[null,"Download request",null,"Radio buttons"]
[null,"Email clicked",null,"Text area"]
[null,"Email opened",null,"Checkbox"]
[null,"Email unsubscribed",null,"Select dropdown"]
[null,"Quote request"]
[null,"Support request"]
[null,"Registered"]
[null,"Watched recording"]
[null,"Interested"]