Conectar Google Analytics Con Supermetrics Page
=QUERY(Supermetrics data, "SELECT A, B, C WHERE B IS NOT NULL ORDER BY C DESC LIMIT 10")
- Users by country - Device breakdown (Mobile/Desktop/Tablet) - Browser performance GA4 vs Universal Analytics: // GA4 configuration Property type: GA4 Metrics: totalUsers, sessions, eventCount Dimensions: pageLocation, sessionSource // Universal Analytics Property type: UA Metrics: ga:users, ga:sessions, ga:pageviews Dimensions: ga:sourceMedium, ga:landingPagePath Multi-Property Reporting: Query 1: Property A → Sheet "Property_A" Query 2: Property B → Sheet "Property_B" Combined sheet: =Property_A!A1:F30; Property_B!A2:F30 Step 7: Data Validation Check data consistency: conectar google analytics con supermetrics
- Total users (vs previous period) - Conversion rate - Top traffic sources - Trend charts =QUERY(Supermetrics data, "SELECT A, B, C WHERE B
Top 20 landing pages - Pageviews - Avg. time on page - Exit rate - Bounce rate eventCount Dimensions: pageLocation
// Run query Supermetrics.runQuery(query);