Local Marketing Blue Print

Marketing attribution is the assignment of credit for a sale or a sign-up to the advertisements, searches, emails and visits that preceded it, according to a rule called an attribution model, so that each channel's reported results reflect its share of the outcomes it helped cause.

Return on ad spend is the revenue a campaign produced divided by what it cost, expressed as a ratio or a percentage: five pounds of sales for every pound of advertising is a ROAS of 5, or 500 per cent, and the number only becomes a decision once it is compared with the margin on those sales.

Digital marketing is the trade name for every commercial activity that reaches a buyer through a screen, gathered under one heading because the work is bought, delivered and counted through the same few platforms rather than because the activities resemble one another.

ETL is the pattern for moving data from the systems that produce it into the one place it is analysed: extract the records from each source, transform them into a common, cleaned shape, and load them into a warehouse; ELT keeps the same three steps and runs the transformation inside the warehouse after loading.

A data warehouse is a database built for analysis rather than for running the business: it holds copies of records from many operational systems, integrated under one set of definitions, kept as history rather than overwritten, and arranged so that questions across years and departments run fast.

A data lake is a store that keeps data in its original form, files of any shape in cheap object storage, loaded before anyone has decided what questions will be asked of it, so that the structure is applied when the data is read rather than when it is written.