Analytics
4.4K members online now
4.4K members online now
Dive into multiple domain (Cross/Sub) tracking, implementing Ecommerce and Enhanced Ecommerce, setting up Event tracking, and Universal Analytics code.
 
Guide Me
star_border
Reply

Why Does a Web Analyst need to know SQL?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have noticed that a few of the web analyst job postings say they want someone who knows SQL. Can anyone tell me when does a web analyst need to use SQL?

 

Thanks,

Daphne

1 Expert replyverified_user

Why Does a Web Analyst need to know SQL?

Rising Star
# 2
Rising Star

Some companies export Google Analytics data via the api to SQL databases like MySQL to get around sampling.  You also export to get around Google's restrictions on personally-identifiable information (PII).  For example, you may only have the customer ID in your GA for your e-commerce company.  You export the GA data to your own DB or CRM so you can mix in all the customer-specific data to do analysis.

_________________________________________________________________________
Director of Marketing | Nehmedia | Partner Profile