SQL queries for the retention report

sql_queries_retention_report

Top 10 CPC keywords
===================
select client_id, store_id, keyword, visits from g5a_keywords where medium='cpc' group by client_id, store_id, keyword order by client_id, store_id, visits DESC;


Top 10 Organic Keywords
======================
select client_id, store_id, keyword, visits from g5a_keywords where medium='organic' group by client_id, store_id, keyword order by client_id, store_id, visits DESC;


Visits per month
====================
select SUM(visits), SUM(new_visits), SUBSTRING(day,6,2) from g5a_traffic_sources where client_id=1122 and store_id=4266 group by SUBSTRING(day,6,2) ;