AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Analytics
3.9K members online now
3.9K 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