| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /:user_id/:repository |
| route-controller | files |
| route-action | disambiguate |
| fetch-nonce | v2:48a07644-329a-c441-afea-bfc83bb8fe02 |
| current-catalog-service-hash | f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb |
| request-id | BBEA:1F8F10:165086:1E6373:6AFE056F |
| html-safe-nonce | 42e3bc9ae88374d21f80f3eeb259d543fcb87f1e15a18115912a882a13e4b0d0 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCQkVBOjFGOEYxMDoxNjUwODY6MUU2MzczOjZBRkUwNTZGIiwidmlzaXRvcl9pZCI6IjM4ODc4Nzc2Nzg4NjYyMzY3ODMiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 136cad057bf43dc81ee8bc01a632b1104d38772cc0b57bd2cb99daa8a57543e8 |
| hovercard-subject-tag | repository:326181042 |
| github-keyboard-shortcuts | repository,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | // |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/fserrey/google-analytics-sql |
| twitter:image | https://opengraph.githubassets.com/fab54a16da4233fb071a160376006be40b764a01562b8194a5a7cdc3c8ee152b/fserrey/google-analytics-sql |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/fab54a16da4233fb071a160376006be40b764a01562b8194a5a7cdc3c8ee152b/fserrey/google-analytics-sql |
| og:image:alt | Useful scripts to get basic ecommerce KPIs querying GA360 BigQuery export - fserrey/google-analytics-sql |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| hostname | github.com |
| expected-hostname | github.com |
| None | 86d46ece7c3d9b0562692f81a135cb55ad6a1c82c93ab1ac874d2f1b46b28958 |
| turbo-cache-control | no-cache |
| go-import | github.com/fserrey/google-analytics-sql git https://github.com/fserrey/google-analytics-sql.git |
| octolytics-dimension-user_id | 37710964 |
| octolytics-dimension-user_login | fserrey |
| octolytics-dimension-repository_id | 326181042 |
| octolytics-dimension-repository_nwo | fserrey/google-analytics-sql |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 326181042 |
| octolytics-dimension-repository_network_root_nwo | fserrey/google-analytics-sql |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 5c18e6799976b7bc2f21178024289bb98edbcc85 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| Skip to content | https://github.com/fserrey/google-analytics-sql#start-of-content |
| https://github.com/ |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffserrey%2Fgoogle-analytics-sql |
| GitHubRepository hosting, code review, and collaboration | https://github.com/platform |
| CopilotAI coding agent for tasks, projects, and automated work | https://github.com/features/copilot |
| ActionsCI/CD and automation | https://github.com/features/actions |
| Code QualityQuality analysis, fixes, and enforcement | https://github.com/features/code-quality |
| CodespacesCloud development environments | https://github.com/features/codespaces |
| Code SecurityVulnerability detection and remediation | https://github.com/security/advanced-security/code-security |
| Secret ProtectionSecret scanning and leak prevention | https://github.com/security/advanced-security/secret-protection |
| All Features | https://github.com/features |
| Documentation | https://docs.github.com/en |
| Training | https://learn.github.com/skills |
| Certifications | https://learn.github.com/credentials |
| Build with Copilot | https://github.com/features/ai |
| Customize Copilot | https://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview |
| Integrations | https://github.com/marketplace |
| Trending repos | https://github.com/trending |
| GitHub Sponsors | https://github.com/open-source/sponsors |
| Developer articles | https://github.com/resources/articles |
| ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place. | https://github.blog/changelog/ |
| Enterprises | https://github.com/enterprise |
| Team | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| Healthcare | https://github.com/solutions/industry/healthcare |
| Financial services | https://github.com/solutions/industry/financial-services |
| Manufacturing | https://github.com/solutions/industry/manufacturing |
| Government | https://github.com/solutions/industry/government |
| See all industries | https://github.com/solutions/industry |
| Why GitHub | https://github.com/why-github |
| Customer Stories | https://github.com/customer-stories |
| Business insights | https://github.com/solutions/executive-insights |
| Trust Center | https://github.com/trust-center |
| GitHub Advanced SecurityEnterprise-grade code security | https://github.com/security/advanced-security |
| Copilot for businessEnterprise-grade AI features | https://github.com/features/copilot/copilot-business |
| Premium SupportEnterprise-grade 24/7 support | https://github.com/enterprise/premium-support |
| Documentation | https://docs.github.com/en |
| Resource center | https://github.com/resources |
| Blog | https://github.blog/ |
| Events & webinars | https://github.com/resources/events |
| Community Forum | https://github.com/orgs/community/discussions |
| Customer Stories | https://github.com/customer-stories |
| Integrations | https://github.com/marketplace |
| Customer support | https://help.github.com/ |
| Training | https://learn.github.com/skills |
| GitHub Status | https://www.githubstatus.com/ |
| About | https://github.com/about |
| Partners | https://github.com/partners |
| Changelog | https://github.blog/changelog/ |
| GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub. | https://githubuniverse.com/ |
| Pricing | https://github.com/pricing |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Ffserrey%2Fgoogle-analytics-sql |
| Sign up | https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=fserrey%2Fgoogle-analytics-sql |
| Reload | https://github.com/fserrey/google-analytics-sql |
| Reload | https://github.com/fserrey/google-analytics-sql |
| Reload | https://github.com/fserrey/google-analytics-sql |
| fserrey | https://github.com/fserrey |
| google-analytics-sql | https://github.com/fserrey/google-analytics-sql |
| Code | https://github.com/fserrey/google-analytics-sql |
| Issues | https://github.com/fserrey/google-analytics-sql/issues |
| Pull requests | https://github.com/fserrey/google-analytics-sql/pulls |
| Actions | https://github.com/fserrey/google-analytics-sql/actions |
| Projects | https://github.com/fserrey/google-analytics-sql/projects |
| Security and quality | https://github.com/fserrey/google-analytics-sql/security |
| Insights | https://github.com/fserrey/google-analytics-sql/pulse |
| https://github.com/fserrey/google-analytics-sql |
| google-analytics-sql | https://github.com/fserrey/google-analytics-sql |
| Notifications | https://github.com/login?return_to=%2Ffserrey%2Fgoogle-analytics-sql |
| Fork0 (0) | https://github.com/login?return_to=%2Ffserrey%2Fgoogle-analytics-sql |
| Star1 (1) | https://github.com/login?return_to=%2Ffserrey%2Fgoogle-analytics-sql |
| Readme | https://github.com/fserrey/google-analytics-sql#readme-ov-file |
| Apache-2.0 license | https://github.com/fserrey/google-analytics-sql#Apache-2.0-1-ov-file |
| Activity | https://github.com/fserrey/google-analytics-sql/activity |
| 0 forks | https://github.com/fserrey/google-analytics-sql/forks |
| Report repository | https://github.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Ffserrey%2Fgoogle-analytics-sql&report=fserrey+%28user%29 |
| Branches | https://github.com/fserrey/google-analytics-sql/branches |
| Tags | https://github.com/fserrey/google-analytics-sql/tags |
| https://github.com/fserrey/google-analytics-sql/branches |
| https://github.com/fserrey/google-analytics-sql/tags |
| 4 Commits | https://github.com/fserrey/google-analytics-sql/commits/main/ |
| https://github.com/fserrey/google-analytics-sql/commits/main/ |
| queries | https://github.com/fserrey/google-analytics-sql/tree/main/queries |
| queries | https://github.com/fserrey/google-analytics-sql/tree/main/queries |
| LICENSE | https://github.com/fserrey/google-analytics-sql/blob/main/LICENSE |
| LICENSE | https://github.com/fserrey/google-analytics-sql/blob/main/LICENSE |
| README.md | https://github.com/fserrey/google-analytics-sql/blob/main/README.md |
| README.md | https://github.com/fserrey/google-analytics-sql/blob/main/README.md |
| README | https://github.com/fserrey/google-analytics-sql |
| Apache-2.0 license | https://github.com/fserrey/google-analytics-sql |
| https://github.com/fserrey/google-analytics-sql#google-analytics-sql |
| https://github.com/Naereen/badges/ |
| https://github.com/fserrey/google-analytics-sql#useful-scripts-to-get-basic-ecommerce-kpis-querying-ga-360-bigquery-export |
| https://github.com/fserrey/google-analytics-sql#description |
| https://github.com/fserrey/google-analytics-sql#some-context |
| (source) | https://www.bounteous.com/insights/2016/02/11/querying-google-analytics-data-bigquery/?ns=l |
| https://github.com/fserrey/google-analytics-sql#how-to-access-nested-fields |
| https://camo.githubusercontent.com/10bf8d025a17ece2635cc4ef2fcb64c3bca27fd7607e47f2b06c786ad6c15122/68747470733a2f2f7777772e676f6f676c652e636f6d2f75726c3f73613d692675726c3d6874747073253341253246253246737461636b6f766572666c6f772e636f6d2532467175657374696f6e732532463238333139373134253246686f772d746f2d636f6e766572742d746869732d6e65737465642d6a736f6e2d696e2d636f6c756d6e61722d666f726d2d696e746f2d70616e6461732d646174616672616d6526707369673d414f765661773133495f626b3045336e774a74634f4851346b52754d267573743d3136313332313231323532393730303026736f757263653d696d616765732663643d766665267665643d30434149516a52787146776f54434d43496c4e4f52354f344346514141414141644141414141424144 |
| Here you can see an animated example of how the nested fields are structured in the GA schema | https://www.notion.so/Formaci-n-BQ-37b95b2cfedf4b1a9ea39940a32ff5df#b183b5becf1846b898489a5ef2aa42ce |
| https://github.com/fserrey/google-analytics-sql#here-you-can-see-an-animated-example-of-how-the-nested-fields-are-structured-in-the-ga-schema |
| here | https://medium.com/firebase-developers/using-the-unnest-function-in-bigquery-to-analyze-event-parameters-in-analytics-fb828f890b42 |
| How to query and calculate Google Analytics data in BigQuery | https://towardsdatascience.com/how-to-query-and-calculate-google-analytics-data-in-bigquery-cab8fc4f396#3be4 |
| ga4bigquery.com | https://www.ga4bigquery.com/ |
| Readme | https://github.com/fserrey/google-analytics-sql#readme-ov-file |
| Apache-2.0 license | https://github.com/fserrey/google-analytics-sql#Apache-2.0-1-ov-file |
| Activity | https://github.com/fserrey/google-analytics-sql/activity |
| 0 forks | https://github.com/fserrey/google-analytics-sql/forks |
| Report repository | https://github.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Ffserrey%2Fgoogle-analytics-sql&report=fserrey+%28user%29 |
|
| https://github.com |
| Terms | https://docs.github.com/site-policy/github-terms/github-terms-of-service |
| Privacy | https://docs.github.com/site-policy/privacy-policies/github-privacy-statement |
| Security | https://github.com/security |
| Status | https://www.githubstatus.com/ |
| Community | https://github.community/ |
| Docs | https://docs.github.com/ |
| Contact | https://support.github.com?tags=dotcom-footer |