Is there a way to get the number of unique visitors who visited at least once/week during a given month from Google Analytics?
If we had a SQL table to representing
visits with at least the following fields:
+-------------+ | visits | +-------------+ | visitorId | | monthOfYear | | weekOfYear | +-------------+
The SQL might look something like this:
select count(*) as 'regular visitors' from ( select count(*) as 'visitor' from visits where monthOfYear = month(now()) group by visitorId having count(distinct weekOfYear) >= 4 ) bt
Can something similar be accomplished in Analytics?
ADDENDUM: We're tracking a user GUID in Custom Variable 1. If we can use that for grouping in some way, that would be ideal.