{"id":96076,"date":"2025-02-18T20:13:35","date_gmt":"2025-02-18T20:13:35","guid":{"rendered":"https:\/\/peraltafinancing.com\/analytics\/enable-bigquery-export-for-google-analytics-app-web-properties\/"},"modified":"2025-02-18T20:13:35","modified_gmt":"2025-02-18T20:13:35","slug":"enable-bigquery-export-for-google-analytics-app-web-properties","status":"publish","type":"post","link":"https:\/\/fivemor.com\/?p=96076","title":{"rendered":"Enable BigQuery Export For Google Analytics: App + Web Properties"},"content":{"rendered":"<p> <br \/>\n<\/p>\n<div>\n<blockquote>\n<p><strong>Update 7 October 2020<\/strong>: BigQuery Export can now be configured via the property settings of Google Analytics: App + Web, so you don\u2019t need to follow the steps in this article. Check out <a href=\"https:\/\/www.charlesfarina.com\/new-bigquery-integration-for-app-web-properties\/\">Charles Farina\u2019s guide<\/a> for how to do this.<\/p>\n<\/blockquote>\n<p>Here\u2019s yet another article inspired by the <a href=\"https:\/\/www.blog.google\/products\/marketingplatform\/analytics\/new-way-unify-app-and-website-measurement-google-analytics\/\">fairly recent release<\/a> of <strong>Google Analytics: App + Web<\/strong> properties. This new property type surfaces <a href=\"https:\/\/firebase.google.com\/\">Firebase\u2019s<\/a> analytics capabilities for websites as well, when before they were restricted to mobile apps only (see my guides for <a href=\"https:\/\/www.simoahava.com\/analytics\/ios-quickstart-google-analytics-firebase-tag-manager\/\">iOS<\/a> and <a href=\"https:\/\/www.simoahava.com\/analytics\/android-quickstart-google-analytics-firebase-google-tag-manager\/\">Android<\/a>).<\/p>\n<p>Even though the feature set of Google Analytics for Firebase is still somewhat bare in the user interface, here\u2019s a perk which might push you over the edge and give the new measurement model a shot.<\/p>\n<p><strong>BigQuery export is available with no extra cost!<\/strong><\/p>\n<p>OK, there\u2019s one caveat: you will of course need to pay for <a href=\"https:\/\/cloud.google.com\/bigquery\/pricing\">BigQuery usage<\/a> and you\u2019ll need to upgrade to the <a href=\"https:\/\/firebase.google.com\/pricing\">Firebase Blaze plan<\/a>. But you won\u2019t have to dish out some $150K a year to have access to raw data, and the free tiers of Google Cloud are <em>extremely<\/em> generous, so you might end up not having to pay at all for this wonderful storage!<\/p>\n<div style=\"aspect-ratio: 1357 \/ 449;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/firebase-bigquery-export.jpg\" title=\"Firebase BigQuery export\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"449\" width=\"1357\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/firebase-bigquery-export.jpg#ZgotmplZ\" alt=\"Firebase BigQuery export\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<blockquote>\n<p><strong>Note!<\/strong> There\u2019s no saying this is a permanent state of affairs. Once Google Analytics: App + Web is out of beta, it\u2019s possible some sort of tiered pricing is introduced. But let\u2019s enjoy this while we can!<\/p>\n<\/blockquote>\n<p>The steps you\u2019ll need to take to enable the export are outlined in this article. Remember to check out the <a href=\"https:\/\/support.google.com\/firebase\/answer\/7029846?hl=en\">BigQuery Export Schema<\/a> for Firebase so you\u2019ll know how the data will be aligned in the BigQuery table.<\/p>\n<p>                <span class=\"simmer\"><br \/>\n  <span class=\"close\">X<\/span><\/p>\n<p>\n    <span class=\"fa fa-md fa-bell\"\/><br \/>\n    <strong>The Simmer Newsletter<\/strong>\n  <\/p>\n<p>\n    Subscribe to the <a href=\"https:\/\/www.simoahava.com\/newsletter\/\">Simmer newsletter<\/a> to get the latest news and content from Simo Ahava into your email inbox!\n  <\/p>\n<p>  <\/span><\/p>\n<h2 id=\"step-1-check-your-google-analytics-app--web-property\">Step 1: Check your Google Analytics: App + Web property<\/h2>\n<p>First step is obvious &#8211; you need a <strong>Google Analytics: App + Web property<\/strong> to be able to export data out of it to Firebase.<\/p>\n<p>If you haven\u2019t created one yet, <a href=\"https:\/\/www.kristaseiden.com\/step-by-step-setting-up-an-app-web-property\/\">follow these steps to do so<\/a>.<\/p>\n<p>To verify it\u2019s up and running and integrated to Firebase, go to <a href=\"https:\/\/console.firebase.google.com\/\">the Firebase console<\/a>, open your project, and go to <strong>Project Settings<\/strong>.<\/p>\n<div style=\"aspect-ratio: 539 \/ 277;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/firebase-project-settings.jpg\" title=\"Firebase project settings\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"277\" width=\"539\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/firebase-project-settings.jpg#ZgotmplZ\" alt=\"Firebase project settings\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Click over to <strong>Integrations<\/strong>. You should see Google Analytics in the <strong>Enabled<\/strong> state, but click <strong>Manage<\/strong> to verify.<\/p>\n<div style=\"aspect-ratio: 578 \/ 374;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/manage-ga-integration.jpg\" title=\"Manage GA integration\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"374\" width=\"578\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/manage-ga-integration.jpg#ZgotmplZ\" alt=\"Manage GA integration\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Here you should make sure all the details look correct. At this point, make a note of the <strong>Property ID<\/strong> in case you want to decide <strong>in which geographic location (e.g. US, EU) you want to create the BigQuery dataset in<\/strong>.<\/p>\n<div style=\"aspect-ratio: 980 \/ 179;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/property-id.jpg\" title=\"Property ID\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"179\" width=\"980\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/property-id.jpg#ZgotmplZ\" alt=\"Property ID\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Now, head back to the Firebase <strong>Project Overview<\/strong> dashboard.<\/p>\n<h2 id=\"step-2-create-a-dummy-app\">Step 2: Create a dummy app<\/h2>\n<p>This is kind of silly, but for the export to work, you need to create an <strong>app<\/strong> in the project. The app doesn\u2019t have to do anything, nor do you have to verify it or validate it, it just needs to exist.<\/p>\n<p>The reason for this is that the BigQuery export was created before the <em>web stream<\/em> concept was introduced with Google Analytics: App + Web, and in its current state, having just a web stream will not enable the export.<\/p>\n<p>I\u2019m certain this will change at some point in the future.<\/p>\n<p>In the dashboard, click the <strong>iOS<\/strong> button to create a new iOS app.<\/p>\n<div style=\"aspect-ratio: 448 \/ 267;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/create-dummy-ios-app.jpg\" title=\"Create dummy iOS app\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"267\" width=\"448\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/create-dummy-ios-app.jpg#ZgotmplZ\" alt=\"Create dummy iOS app\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Give the app some bundle ID &#8211; it can be anything you want. I used <code>com.example.dummyapp<\/code>. Click <strong>Register app<\/strong>.<\/p>\n<div style=\"aspect-ratio: 547 \/ 420;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/register-dummy-app.jpg\" title=\"Register dummy app\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"420\" width=\"547\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/register-dummy-app.jpg#ZgotmplZ\" alt=\"Register dummy app\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>You can now ignore all the instructions and just click the <strong>Next<\/strong> button until you reach the final step. Here, click the <strong>Skip this step<\/strong> link to create the app.<\/p>\n<div style=\"aspect-ratio: 792 \/ 497;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/skip-this-step.jpg\" title=\"Skip this step\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"497\" width=\"792\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/skip-this-step.jpg#ZgotmplZ\" alt=\"Skip this step\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Congratulations, you\u2019ve created an iOS app (har har).<\/p>\n<h2 id=\"step-3-upgrade-to-blaze-plan\">Step 3: Upgrade to Blaze plan<\/h2>\n<p>To be able to export the data to BigQuery, you\u2019ll need to upgrade your Firebase account to use the <strong>Blaze<\/strong> (pay as you go) plan.<\/p>\n<p>Click the <strong>Upgrade<\/strong> link in the bottom of your Firebase navigation.<\/p>\n<div style=\"aspect-ratio: 473 \/ 196;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/upgrade-firebase-blaze.jpg\" title=\"Firebase Blaze\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"196\" width=\"473\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/upgrade-firebase-blaze.jpg#ZgotmplZ\" alt=\"Firebase Blaze\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Next, click <strong>Select plan<\/strong> in the Blaze column.<\/p>\n<div style=\"aspect-ratio: 805 \/ 590;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/select-blaze-plan.jpg\" title=\"Select Blaze plan\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"590\" width=\"805\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/select-blaze-plan.jpg#ZgotmplZ\" alt=\"Select Blaze plan\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Now, you will need to choose a <strong>Billing Account<\/strong> configured for your Google Cloud organization \/ login. If you don\u2019t have one yet, you will be prompted to create it. You will need your credit card for this!<\/p>\n<div style=\"aspect-ratio: 518 \/ 512;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/select-billing-account.jpg\" title=\"Select billing account\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"512\" width=\"518\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/select-billing-account.jpg#ZgotmplZ\" alt=\"Select billing account\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Click <strong>Continue<\/strong> and <strong>Purchase<\/strong> to confirm that you will use the selected billing account for any charges incurred by your Firebase and BigQuery usage.<\/p>\n<h2 id=\"step-4-optional-create-the-bigquery-dataset\">Step 4: (Optional) Create the BigQuery dataset<\/h2>\n<p>In case you want to store the BigQuery data elsewhere than the United States, you can actually create the BigQuery dataset beforehand, choosing the data storage location that way.<\/p>\n<p>If this is what you want to do, you\u2019ll need to visit the BigQuery console for your project, so open <a href=\"https:\/\/console.cloud.google.com\/bigquery\/\">the console<\/a> in your browser.<\/p>\n<p>First, make sure you have the correct project selected from your project selector. The project should match the name of your Firebase project (<code>www-simoahava-com<\/code> in my case).<\/p>\n<div style=\"aspect-ratio: 593 \/ 213;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/cloud-project-selector.jpg\" title=\"GCP project selector\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"213\" width=\"593\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/cloud-project-selector.jpg#ZgotmplZ\" alt=\"GCP project selector\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>In the BigQuery project navigator you should find your project as well. The BigQuery project will have the same name as your Firebase project ID (<code>simoahava-com<\/code> for me).<\/p>\n<p>Click the project to open its datasets (there should be none).<\/p>\n<div style=\"aspect-ratio: 1391 \/ 436;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/simoahava-com-datasets.jpg\" title=\"datasets\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"436\" width=\"1391\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/simoahava-com-datasets.jpg#ZgotmplZ\" alt=\"datasets\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Now, click <strong>CREATE DATASET<\/strong> in the right-hand side of the dataset explorer.<\/p>\n<p>In the overlay that opens, you need to type in the <strong>Dataset ID<\/strong>. The Dataset ID <strong>must be named<\/strong> in the following format:<\/p>\n<p><code>analytics_<ga property=\"\" id=\"\"\/><\/code><\/p>\n<p>This is where the Property ID from <a href=\"#step-1-check-your-google-analytics-app-web-property\">step 1<\/a> comes into play, as you\u2019ll need to name the dataset accordingly.<\/p>\n<blockquote>\n<p>If you do not name the dataset correctly, the data will <strong>not<\/strong> flow into it, and another dataset (one named correctly) will be automatically created for you in the United States.<\/p>\n<\/blockquote>\n<p>Now you can also set the location to your liking.<\/p>\n<div style=\"aspect-ratio: 488 \/ 389;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/dataset-settings.jpg\" title=\"Dataset settings\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"389\" width=\"488\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/dataset-settings.jpg#ZgotmplZ\" alt=\"Dataset settings\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Click <strong>Create dataset<\/strong> at the bottom of the overlay when done.<\/p>\n<p>This is what you should see in the dataset explorer view:<\/p>\n<div style=\"aspect-ratio: 908 \/ 387;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/dataset-explorer.jpg\" title=\"Dataset explorer\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"387\" width=\"908\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/dataset-explorer.jpg#ZgotmplZ\" alt=\"Dataset explorer\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<h2 id=\"step-5-set-up-the-export\">Step 5: Set up the export<\/h2>\n<p>Finally, you can set up the export itself.<\/p>\n<p>In the Firebase console, head on over to <strong>Project Settings<\/strong> and click to <strong>Integrations<\/strong> again. This time, in the BigQuery box, click <strong>Link<\/strong>.<\/p>\n<div style=\"aspect-ratio: 1239 \/ 455;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/link-bigquery.jpg\" title=\"Link BigQuery\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"455\" width=\"1239\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/link-bigquery.jpg#ZgotmplZ\" alt=\"Link BigQuery\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>Make sure you read the fine print in the first step, and click <strong>Next<\/strong> when adequately enlightened.<\/p>\n<p>In the next step, you\u2019ll have an overview of what is included in the export. If you want to include \u201cadvertising identifiers\u201d in the export, be sure to check the box. It sounded nefarious to me so I chose not to do so.<\/p>\n<p>Click <strong>Link to BigQuery<\/strong> when ready.<\/p>\n<div style=\"aspect-ratio: 649 \/ 745;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/link-to-bigquery-done.jpg\" title=\"BigQuery link done\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"745\" width=\"649\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/link-to-bigquery-done.jpg#ZgotmplZ\" alt=\"BigQuery link done\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>The next view shows you that the link is now done. Make sure the <strong>toggle for your dummy app is ON<\/strong> in the <em>Analytics<\/em> card. This enables the data export from your web stream to BigQuery.<\/p>\n<div style=\"aspect-ratio: 672 \/ 508;\" class=\"figure nocaption\">\n<p>    <a href=\"https:\/\/www.simoahava.com\/images\/2019\/08\/link-toggle-on.jpg\" title=\"Link toggle on\"><\/p>\n<p>    <img decoding=\"async\" class=\"fig-img\" height=\"508\" width=\"672\" loading=\"lazy\" src=\"https:\/\/www.simoahava.com\/images\/2019\/08\/link-toggle-on.jpg#ZgotmplZ\" alt=\"Link toggle on\"\/><\/p>\n<p>    <\/a><\/p>\n<\/div>\n<p>And that\u2019s it! The day after creating this link, you should see a new table in the dataset prefixed with <code>events_<\/code>, which will contain all the data for each day of the export, and you can start running those sweet queries on your raw data in no time!<\/p>\n<h2 id=\"summary\">Summary<\/h2>\n<p>It\u2019s great that we have this \u201cfree\u201d BigQuery export available for our Firebase analytics projects. I really, really hope it won\u2019t be taken away from us. Ever.<\/p>\n<p>In its current state, the user interface and reporting capabilities of Google Analytics: App + Web leave quite a lot to be desired, but the BigQuery export pretty much makes up for the limitations of the UI. Being able to work with row-level data is <em>huge<\/em>, as it, for example, gives us access to event parameters beyond the 50 each project is allocated by default.<\/p>\n<p>Have fun playing around with BigQuery, and let me know if you had trouble with setting up the export!<\/p>\n<\/p><\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Update 7 October 2020: BigQuery Export can now be configured via the property settings of Google Analytics: App + Web, so you don\u2019t need to follow the steps in this article. Check out Charles Farina\u2019s guide for how to do this. Here\u2019s yet another article inspired by the fairly recent release of Google Analytics: App [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":96077,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12033],"tags":[12765,4364,28608,16445,21039,1531,20228,5393],"dealstore":[],"offerexpiration":[],"class_list":["post-96076","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","tag-analytics","tag-app","tag-bigquery","tag-enable","tag-export","tag-google","tag-properties","tag-web"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Enable BigQuery Export For Google Analytics: App + Web Properties - Som2ny Network<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fivemor.com\/?p=96076\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Enable BigQuery Export For Google Analytics: App + Web Properties - Som2ny Network\" \/>\n<meta property=\"og:description\" content=\"Update 7 October 2020: BigQuery Export can now be configured via the property settings of Google Analytics: App + Web, so you don\u2019t need to follow the steps in this article. Check out Charles Farina\u2019s guide for how to do this. Here\u2019s yet another article inspired by the fairly recent release of Google Analytics: App [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fivemor.com\/?p=96076\" \/>\n<meta property=\"og:site_name\" content=\"Som2ny Network\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-18T20:13:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/firebase-bigquery-export.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1357\" \/>\n\t<meta property=\"og:image:height\" content=\"449\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fivemor.com\/?p=96076#article\",\"isPartOf\":{\"@id\":\"https:\/\/fivemor.com\/?p=96076\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371\"},\"headline\":\"Enable BigQuery Export For Google Analytics: App + Web Properties\",\"datePublished\":\"2025-02-18T20:13:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fivemor.com\/?p=96076\"},\"wordCount\":1273,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fivemor.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/?p=96076#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/firebase-bigquery-export.jpg\",\"keywords\":[\"Analytics\",\"APP\",\"BigQuery\",\"Enable\",\"export\",\"Google\",\"Properties\",\"Web\"],\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fivemor.com\/?p=96076#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fivemor.com\/?p=96076\",\"url\":\"https:\/\/fivemor.com\/?p=96076\",\"name\":\"Enable BigQuery Export For Google Analytics: App + Web Properties - Som2ny Network\",\"isPartOf\":{\"@id\":\"https:\/\/fivemor.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fivemor.com\/?p=96076#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/?p=96076#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/firebase-bigquery-export.jpg\",\"datePublished\":\"2025-02-18T20:13:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fivemor.com\/?p=96076#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fivemor.com\/?p=96076\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/?p=96076#primaryimage\",\"url\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/firebase-bigquery-export.jpg\",\"contentUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/firebase-bigquery-export.jpg\",\"width\":1357,\"height\":449},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fivemor.com\/?p=96076#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/fivemor.com\/?bp_activities=1\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Enable BigQuery Export For Google Analytics: App + Web Properties\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fivemor.com\/#website\",\"url\":\"https:\/\/fivemor.com\/\",\"name\":\"Som2ny Network\",\"description\":\"Daily Deals\",\"publisher\":{\"@id\":\"https:\/\/fivemor.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fivemor.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/fivemor.com\/#organization\",\"name\":\"Som2ny Network\",\"url\":\"https:\/\/fivemor.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png\",\"contentUrl\":\"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png\",\"width\":300,\"height\":86,\"caption\":\"Som2ny Network\"},\"image\":{\"@id\":\"https:\/\/fivemor.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fivemor.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/fivemor.com\"],\"url\":\"https:\/\/fivemor.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Enable BigQuery Export For Google Analytics: App + Web Properties - Som2ny Network","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fivemor.com\/?p=96076","og_locale":"en_US","og_type":"article","og_title":"Enable BigQuery Export For Google Analytics: App + Web Properties - Som2ny Network","og_description":"Update 7 October 2020: BigQuery Export can now be configured via the property settings of Google Analytics: App + Web, so you don\u2019t need to follow the steps in this article. Check out Charles Farina\u2019s guide for how to do this. Here\u2019s yet another article inspired by the fairly recent release of Google Analytics: App [&hellip;]","og_url":"https:\/\/fivemor.com\/?p=96076","og_site_name":"Som2ny Network","article_published_time":"2025-02-18T20:13:35+00:00","og_image":[{"width":1357,"height":449,"url":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/firebase-bigquery-export.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fivemor.com\/?p=96076#article","isPartOf":{"@id":"https:\/\/fivemor.com\/?p=96076"},"author":{"name":"admin","@id":"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371"},"headline":"Enable BigQuery Export For Google Analytics: App + Web Properties","datePublished":"2025-02-18T20:13:35+00:00","mainEntityOfPage":{"@id":"https:\/\/fivemor.com\/?p=96076"},"wordCount":1273,"commentCount":0,"publisher":{"@id":"https:\/\/fivemor.com\/#organization"},"image":{"@id":"https:\/\/fivemor.com\/?p=96076#primaryimage"},"thumbnailUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/firebase-bigquery-export.jpg","keywords":["Analytics","APP","BigQuery","Enable","export","Google","Properties","Web"],"articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fivemor.com\/?p=96076#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fivemor.com\/?p=96076","url":"https:\/\/fivemor.com\/?p=96076","name":"Enable BigQuery Export For Google Analytics: App + Web Properties - Som2ny Network","isPartOf":{"@id":"https:\/\/fivemor.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fivemor.com\/?p=96076#primaryimage"},"image":{"@id":"https:\/\/fivemor.com\/?p=96076#primaryimage"},"thumbnailUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/firebase-bigquery-export.jpg","datePublished":"2025-02-18T20:13:35+00:00","breadcrumb":{"@id":"https:\/\/fivemor.com\/?p=96076#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fivemor.com\/?p=96076"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/?p=96076#primaryimage","url":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/firebase-bigquery-export.jpg","contentUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2025\/02\/firebase-bigquery-export.jpg","width":1357,"height":449},{"@type":"BreadcrumbList","@id":"https:\/\/fivemor.com\/?p=96076#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fivemor.com\/?bp_activities=1"},{"@type":"ListItem","position":2,"name":"Enable BigQuery Export For Google Analytics: App + Web Properties"}]},{"@type":"WebSite","@id":"https:\/\/fivemor.com\/#website","url":"https:\/\/fivemor.com\/","name":"Som2ny Network","description":"Daily Deals","publisher":{"@id":"https:\/\/fivemor.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fivemor.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/fivemor.com\/#organization","name":"Som2ny Network","url":"https:\/\/fivemor.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/#\/schema\/logo\/image\/","url":"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png","contentUrl":"https:\/\/fivemor.com\/wp-content\/uploads\/2026\/07\/4a0953c4-logo-300x86-1.png","width":300,"height":86,"caption":"Som2ny Network"},"image":{"@id":"https:\/\/fivemor.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/fivemor.com\/#\/schema\/person\/b85e3c3dc0e1daea076524dc8810c371","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fivemor.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/729ae85bf62b9917e93538db2f2688ca?s=96&r=g&default=https%3A%2F%2Ffivemor.com%2Fwp-content%2Fplugins%2Fbuddypress-first-letter-avatar%2Fimages%2Fdefault%2F96%2Flatin_a.png","caption":"admin"},"sameAs":["https:\/\/fivemor.com"],"url":"https:\/\/fivemor.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts\/96076","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=96076"}],"version-history":[{"count":0,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/posts\/96076\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=\/wp\/v2\/media\/96077"}],"wp:attachment":[{"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=96076"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=96076"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=96076"},{"taxonomy":"dealstore","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fdealstore&post=96076"},{"taxonomy":"offerexpiration","embeddable":true,"href":"https:\/\/fivemor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fofferexpiration&post=96076"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}