Before R and Python and machine learning and even pivot tables, there was the ANSI standard language for relational database management systems. This is where you start with everything you need to know as a marketing professional or a digital analyst.
In this full day hands-on workshop, you will learn the fundamentals of database and SQL that marketers and marketing analysts need to conduct deeper analysis on the customer and marketing data.
1. How to combine data from various sources such email, CRM etc.
2. Score your customers based on their purchase behavior
3. Categories your customers based on various criteria stored in
4. Conduct cohort analysis
5. Find your most profitable customer
6. Find loyal customers
7. Find customers at risk of churn so that you can proactively engage them
8. Find attributes for various customers types so that you can focus on marketing to find or avoid similar customers.
9. Use this data to augment your Google Analytics or Adobe Analytics data.
10. Combine offline and online data to create remarketing lists in Google Ads
Anil is a seasoned Digital Marketing and Analytics professional with 15 years of experience. He has worked with companies ranging from Fortune 50 to startups and has helped them improve marketing results. His customers include Microsoft, SmartMoney, ESPN, T-Mobile, Hoovers, RealNetworks, Starbucks, and TheStreet. He holds a B. Tech in Electronics and Communication Engineering from India and an MBA from University of Washington, Seattle.
Anil has taught and trained several Marketing and Analytics folks in past nine years of teaching at UBC, University of Washington and Bellevue College, and speaking engagements at various conferences as well as his blog. He teaches Digital Marketing, Digital Analytics, Google Analytics, Tableau and Social Media courses. He also served on the Board of Digital Analytics Association (DAA) and was instrumental in starting the DAA Symposiums.
Anil is the founder of Global Analytics Academy and Optizent, a Digital Marketing and Analytics consulting company.
What are cookies?
Cookies, among other things, help to make your visit to our website simpler, more pleasant and more logically structured. Cookies are information data which your web browser automatically stores on your computer’s hard disc when you visit our website. Cookies do not do any damage to your computer’s hard disc and they do not transmit any of your personal data to us.
We use the web analysis service Google Analytics to continuously streamline and optimise our sites for users. For this purpose, pseudonymised user profiles are created and small text files are used that are stored on your computer (‘cookies’). The information produced by the cookie about your use of this website, such as
is transmitted to servers of Google Inc. in the USA and stored there. This information is used to evaluate the use of our website, to compile reports on website activities and to provide other services connected with the use of the website and Internet use for purposes of market research and to enable these Internet sites to be made more user-friendly. If necessary, this information is also transmitted to third parties to the extent that this is prescribed by law or if third parties process the data for us. In no event is the IP address ever brought into association with other data relating to the user. IP addresses are anonymised to prevent them from being matched (IP masking).
Users may configure their browsers to prevent cookies from being installed. However, we would point out that in this case it may not be possible to use all of the functions of this website to the full extent
You can find more information about the web analysis service we use on the website of Google Analytics. You can find instructions for preventing your data being processed by the web analysis service at http://tools.google.com/dlpage/gaoptout?hl=en.
Unsere Websites verwendet sogenannte Re-Targeting-Technologien. Wir nutzen diese Technologien, um für Sie das Internetangebot interessanter zu gestalten. Diese Technik ermöglicht es, Internetnutzer, die sich bereits für unsere Dienstleistungen und Produkte interessiert haben, auf den Websites unserer Partner mit Werbung anzusprechen. Wir sind davon überzeugt, dass die Einblendung einer personalisierten, interessenbezogenen Werbung in der Regel für den Internetnutzer interessanter ist als Werbung, die keinen solchen persönlichen Bezug hat. Die Einblendung dieser Werbemittel auf den Seiten unserer Partner erfolgt auf Basis einer Cookie-Technologie und einer Analyse des vorherigen Nutzungsverhaltens. Diese Form der Werbung erfolgt vollkommen anonym. Es werden keine personenbezogenen Daten gespeichert und es werden auch keine Nutzungsprofile mit Ihren personenbezogenen Daten zusammengeführt. Sie können die Verwendung von Cookies durch Google deaktivieren, indem sie die Seite zur Deaktivierung von Google-Werbung aufrufen. Alternativ können Sie die Verwendung von Cookies durch Drittanbieter deaktivieren, indem sie die Deaktivierungsseite der Netzwerkwerbeinitiative aufrufen.