{"id":8184,"date":"2021-11-18T02:38:18","date_gmt":"2021-11-18T02:38:18","guid":{"rendered":"https:\/\/help.fromdoppler.com\/es\/?p=8184"},"modified":"2026-01-05T18:54:55","modified_gmt":"2026-01-05T18:54:55","slug":"integrar-doppler-bigquery","status":"publish","type":"post","link":"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery\/","title":{"rendered":"Integrate BigQuery and visualize personalized reports"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Thanks to this integration, information about <\/span><b>Campaigns sent from Doppler<\/b><span style=\"font-weight: 400;\"> goes to <\/span><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">BigQuery<\/span><\/a><span style=\"font-weight: 400;\"> (a Google cloud storage service). It travels from there to a Data Analytics tool to<\/span><span style=\"font-weight: 400;\">\u00a0<\/span><b>visualize personalized reports.\u00a0\u00a0<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The <\/span><b>main advantages<\/b><span style=\"font-weight: 400;\"> of this integration are:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The chance to obtain personalized reports about your Campaigns in a simple way.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The <\/span><b>data crossing<\/b><span style=\"font-weight: 400;\">, not only data about Doppler Campaigns but also information from other data sources.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The<\/span><b> identification of action items<\/b><span style=\"font-weight: 400;\"> to optimize your Email Marketing strategy and digital strategy in general.<\/span><\/li>\n<\/ul>\n<p><a href=\"https:\/\/app.fromdoppler.com\/signup?lang=en&amp;utm_source=direct&amp;page=reportes\" target=\"_blank\" rel=\"noopener\"><img class=\"aligncenter wp-image-8274 size-large\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-en-1024x432.png\" alt=\"Create an account\" width=\"1024\" height=\"432\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-en-1024x432.png 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-en-300x127.png 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-en-768x324.png 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-en.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><span style=\"font-weight: 400;\">To complete the integration, you must take action both in <\/span>Doppler <b>Integration section<\/b><span style=\"font-weight: 400;\">\u00a0and in <\/span><strong><a href=\"https:\/\/cloud.google.com\/\" target=\"_blank\" rel=\"noopener\">Google Cloud<\/a><\/strong><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Index:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery#accesses\" rel=\"noopener\">Give access permissions to BigQuery from Doppler<\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery?utm_source=direct#:~:text=your%20Doppler%20account.-,How%20to%20create%20a%20project%20and%20highlight%20it%20in%20Google%20Cloud,-1%2D%20Click%20the\">How to create a project and highlight it in Google Cloud<\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery#create-reports\" rel=\"noopener\">How to visualize your campaign reports in 3 data analytics tools<\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery#data-studio\" rel=\"noopener\">Connect Looker Studio with BigQuery<\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery#power-bi\" rel=\"noopener\">Connect Power BI with BigQuery<\/a><\/li>\n<li aria-level=\"1\"><a href=\"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery#tableau\" rel=\"noopener\">Connect Tableau with BigQuery<\/a><\/li>\n<\/ul>\n<h2 id=\"accesses\"><strong>How to give access permissions to BigQuery from Doppler<\/strong><\/h2>\n<p><strong>1 &#8211;<\/strong> Login to your <strong>Doppler account<\/strong>. From the <strong>Integrations<\/strong> section you will see the BigQuery <strong>icon<\/strong>.<\/p>\n<p><img class=\"aligncenter size-full wp-image-9329\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-1.png\" alt=\"\" width=\"1662\" height=\"929\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-1.png 1662w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-1-300x168.png 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-1-1024x572.png 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-1-768x429.png 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-1-1536x859.png 1536w\" sizes=\"(max-width: 1662px) 100vw, 1662px\" \/><\/p>\n<p><strong>2 &#8211;<\/strong> By clicking there you will be able to grant<strong> access permissions to BigQuery<\/strong> or to any Google account, either with Gmail domain or corporate accounts. Add an email account to give permission and press <strong>&#8220;Save&#8221;<\/strong>.<\/p>\n<p><img class=\"aligncenter size-full wp-image-9330\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-2.jpg\" alt=\"\" width=\"1231\" height=\"812\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-2.jpg 1231w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-2-300x198.jpg 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-2-1024x675.jpg 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-2-768x507.jpg 768w\" sizes=\"(max-width: 1231px) 100vw, 1231px\" \/><\/p>\n<h2>How to create a project and highlight it in Google Cloud<\/h2>\n<p><span style=\"font-weight: 400;\"><strong>1 &#8211;<\/strong> Enter to <a href=\"https:\/\/console.cloud.google.com\/home\/dashboard\"><strong>Google Cloud<\/strong><\/a>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>2 &#8211;<\/strong> If you are not logged in, you have to write your Google email address and password.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>3 &#8211;<\/strong> Now you are in the Google Cloud dashboard! Click <\/span><span style=\"font-weight: 400;\">on the left side of the screen<\/span><span style=\"font-weight: 400;\">\u00a0to create your own project and link up with Doppler\u2019s Project. At the right of the modal, click <b>&#8220;New project&#8221; and the &#8220;Open&#8221;.<\/b><\/span><\/p>\n<p><img class=\"aligncenter wp-image-9331 size-large\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-3-1024x574.jpg\" alt=\"\" width=\"1024\" height=\"574\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-3-1024x574.jpg 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-3-300x168.jpg 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-3-768x430.jpg 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-3.jpg 1488w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>4 &#8211;<\/strong> C<span style=\"font-weight: 400;\">hoose project&#8217;s name and configure the extra information. Then go to <strong>&#8220;Create&#8221;<\/strong>.<\/span><\/p>\n<p><img class=\"aligncenter size-full wp-image-9333\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-4.jpg\" alt=\"\" width=\"536\" height=\"541\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-4.jpg 536w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-4-297x300.jpg 297w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-4-150x150.jpg 150w\" sizes=\"(max-width: 536px) 100vw, 536px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">5 &#8211; Done! Your recent project will be shown on the left side of the screen.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Before going ahead, you have to <\/span><b>configure a credit card in the Billing Information section <\/b><span style=\"font-weight: 400;\">of Google Cloud Platform. This is because Google charges every information request that exceeds the daily maximum included.\u00a0<\/span><\/p>\n<p><b>If you don\u2019t do it, you cannot visualize information saved at BigQuery.<\/b> <strong><a href=\"https:\/\/cloud.google.com\/billing\/docs\/how-to\/manage-billing-account\" target=\"_blank\" rel=\"noopener\">Take a look at this Google article<\/a><\/strong><span style=\"font-weight: 400;\"> to configure the Billing section step by step.<\/span><\/p>\n<p><strong>6 &#8211;<\/strong> To link a new project with the Doppler project in BigQuery, you must first click on the &#8220;+Add&#8221; button<\/p>\n<p><img class=\"alignnone size-full wp-image-9850\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Screenshot_1-1.png\" alt=\"\" width=\"830\" height=\"390\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Screenshot_1-1.png 830w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Screenshot_1-1-300x141.png 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Screenshot_1-1-768x361.png 768w\" sizes=\"(max-width: 830px) 100vw, 830px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Then select the option: &#8220;Highlight a project by name&#8221;<\/span><\/p>\n<p><img class=\"alignnone size-full wp-image-9851\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Screenshot_2.png\" alt=\"\" width=\"826\" height=\"486\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Screenshot_2.png 826w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Screenshot_2-300x177.png 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Screenshot_2-768x452.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/p>\n<p>Then you will assign the specific name <strong>&#8220;doppler-291113&#8221;<\/strong> (since it is Doppler&#8217;s own for the integration to work correctly) and that&#8217;s it! Your new configuration will now be ready to start using.<\/p>\n<p><span style=\"font-weight: 400;\">We add as a detail, that if you already have the integration configured, you will be able to use it <a href=\"https:\/\/console.cloud.google.com\/bigquery?project=doppler-291113\">as you were doing.<\/a><\/span><\/p>\n<p style=\"text-align: center;\"><em>Art\u00edculos relacionados: <a href=\"https:\/\/help.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-detail\" target=\"_blank\" rel=\"noopener\">\u00bfQu\u00e9 significan los Campos de la tabla Campaign Detail?<\/a> y <a href=\"https:\/\/help.fromdoppler.com\/es\/integracion-doppler-bigquery-tabla-campaign-summary\/\" target=\"_blank\" rel=\"noopener\">\u00bfQu\u00e9 significan los Campos de la tabla Campaign Summary?<\/a><\/em><\/p>\n<p><span style=\"font-weight: 400;\">You\u2019ve just completed all the steps at those platforms, and now they\u2019re correctly matched. Information about Campaigns sent with Doppler will be <\/span><b>automatically updated in BigQuery every one hour.\u00a0<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Let\u2019s go ahead! We\u2019ll see how to use this information to generate personalized reports at three of the most popular<\/span><b> Data Analytics tools.<\/b><\/p>\n<h2 id=\"create-reports\"><strong>How to visualize your campaign reports in 3 data analytics tools<\/strong><\/h2>\n<p>It&#8217;s time to get the information about your campaigns reflected in a dashboard or data visualization tool so you can take advantage of it. There are many data analytics tools that you could use for that, but we will focus on three that are among the most popular on the market and are also easy to set up: <strong><a href=\"https:\/\/datastudio.google.com\/overview\" target=\"_blank\" rel=\"noopener\">Looker Studio<\/a>, <a href=\"https:\/\/powerbi.microsoft.com\/en-au\/\" target=\"_blank\" rel=\"noopener\">Power BI<\/a> and <a href=\"https:\/\/www.tableau.com\/\" target=\"_blank\" rel=\"noopener\">Tableau<\/a><\/strong>.<\/p>\n<h3>Connect BigQuery with Looker Studio<\/h3>\n<p>Looker Studio is a free tool from Google that uses a pre-designed dashboard with fields and metrics that will be displayed by default, and that you can edit to your liking.<\/p>\n<p><strong>1 &#8211;<\/strong> Go to<strong> <a href=\"https:\/\/datastudio.google.com\/u\/0\/reporting\/b76e8ca5-734d-4afb-9f95-bb7af4b60085\/page\/4KN0B\/preview\">this link<\/a> <\/strong>where you will find the Looker Studio dashboard template. Select <strong>&#8220;Use my own data&#8221;<\/strong> in the upper right margin of your screen.<\/p>\n<p><img class=\"aligncenter wp-image-9335 size-large\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-6-1024x463.jpg\" alt=\"\" width=\"1024\" height=\"463\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-6-1024x463.jpg 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-6-300x136.jpg 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-6-768x347.jpg 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-6-1536x695.jpg 1536w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-6.jpg 1736w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><strong>2 &#8211;<\/strong> Choose <strong>&#8220;Shared projects&#8221;<\/strong> and then in <strong>&#8220;Billing project&#8221;<\/strong> select your project, in this case ours was named <strong>&#8220;DopplerHelpTest&#8221;<\/strong>.<\/p>\n<p><img class=\"aligncenter size-full wp-image-9336\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-8.jpg\" alt=\"\" width=\"1841\" height=\"779\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-8.jpg 1841w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-8-300x127.jpg 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-8-1024x433.jpg 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-8-768x325.jpg 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-8-1536x650.jpg 1536w\" sizes=\"(max-width: 1841px) 100vw, 1841px\" \/><\/p>\n<p>Choosing the latter will enable the <strong>&#8220;Shared project name&#8221;<\/strong> column and that is where you must type this text without quotes <strong>&#8220;doppler-291113&#8221;<\/strong> to link to Doppler.<\/p>\n<p>Now you will see <strong>&#8220;doppler-reports&#8221;<\/strong> in the <strong>&#8220;Dataset&#8221;<\/strong> column, choose it and under <strong>&#8220;Table&#8221;<\/strong> you will have options. Find the tables you want to examine and continue with the <strong>&#8220;Add&#8221;<\/strong>\u00a0button.<\/p>\n<p><strong>3 &#8211;<\/strong> Wait a few minutes to display your account information in the <strong>Looker Studio<\/strong> dashboard.<\/p>\n<p><img class=\"aligncenter wp-image-9337 size-large\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9-1024x498.png\" alt=\"\" width=\"1024\" height=\"498\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9-1024x498.png 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9-300x146.png 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9-768x373.png 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9-1536x746.png 1536w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9.png 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>Watch all the process in this video.<\/p>\n<div style=\"width: 1920px;\" class=\"wp-video\"><video class=\"wp-video-shortcode\" id=\"video-8184-3\" width=\"1920\" height=\"928\" preload=\"metadata\" controls=\"controls\"><source type=\"video\/mp4\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/2022-11-02_15-07-02.mp4?_=3\" \/><a href=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/2022-11-02_15-07-02.mp4\">https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/2022-11-02_15-07-02.mp4<\/a><\/video><\/div>\n<p><strong>4 &#8211;<\/strong> Now it&#8217;s time to make a copy of your table so that the next time you want to view the report you don&#8217;t have to repeat all the steps. It&#8217;s very easy. Go to the <strong>&#8220;Edit and share&#8221;<\/strong> button, this will enable the edit mode.<\/p>\n<p><strong>5 &#8211;<\/strong> Place the cursor over the title and change it to another one. From now on it will be saved among your <strong>Looker Studio<\/strong> projects. Return with <strong>&#8220;View&#8221;<\/strong>.<\/p>\n<p><img class=\"aligncenter size-full wp-image-9339\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9.jpg\" alt=\"\" width=\"1669\" height=\"434\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9.jpg 1669w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9-300x78.jpg 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9-1024x266.jpg 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9-768x200.jpg 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-9-1536x399.jpg 1536w\" sizes=\"(max-width: 1669px) 100vw, 1669px\" \/><\/p>\n<p><strong>6 &#8211;<\/strong> You will see your new report from the main <strong>Looker Studio<\/strong> screen.<\/p>\n<p><img class=\"aligncenter size-full wp-image-9341\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-10-1.jpg\" alt=\"\" width=\"1240\" height=\"520\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-10-1.jpg 1240w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-10-1-300x126.jpg 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-10-1-1024x429.jpg 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/en-bigquery-10-1-768x322.jpg 768w\" sizes=\"(max-width: 1240px) 100vw, 1240px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3 id=\"power-bi\"><strong>Connect BigQuery with Power BI<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\"><strong>1 &#8211;<\/strong> To start, download and install <\/span><b>ODBC Driver for BigQuery <\/b><span style=\"font-weight: 400;\">from <\/span><strong><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/odbc-jdbc-drivers\" target=\"_blank\" rel=\"noopener\">this link<\/a><\/strong><span style=\"font-weight: 400;\">. Choose <\/span><b>32 or 64 bits<\/b><span style=\"font-weight: 400;\"> version.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>2 &#8211;<\/strong> Open the <\/span><b>ODBC Data Sources<\/b><span style=\"font-weight: 400;\"> admin and go to <\/span><b>SYSTEM DSN, <\/b><span style=\"font-weight: 400;\">identify <\/span><b>Google BigQuery<\/b><span style=\"font-weight: 400;\"> option and click <\/span><b>Configure<\/b><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<p><img class=\"aligncenter wp-image-8187 size-large\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-1-1024x406.png\" alt=\"\" width=\"1024\" height=\"406\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-1-1024x406.png 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-1-300x119.png 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-1-768x304.png 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-1.png 1174w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><span style=\"font-weight: 400;\"><strong>3 &#8211;<\/strong> In the <\/span><b>Authentication<\/b><span style=\"font-weight: 400;\"> section, choose <\/span><b>User Authentication. <\/b><span style=\"font-weight: 400;\">Then click<\/span><b> Sign in, <\/b><span style=\"font-weight: 400;\">you\u2019ll be redirected to the browser. Enter your Google user and password. A confirmation code will be shown: copy and paste it in ODBC admin.\u00a0\u00a0<\/span><\/p>\n<p><img class=\"aligncenter wp-image-8188 size-full\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-2.png\" alt=\"\" width=\"720\" height=\"753\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-2.png 720w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-2-287x300.png 287w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/p>\n<p><span style=\"font-weight: 400;\"><strong>4 &#8211;<\/strong> Click <\/span><b>Refresh token<\/b><span style=\"font-weight: 400;\">, so it will be autocompleted based on the code you\u2019ve pasted in the last step.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>5 &#8211;<\/strong> In the <\/span><b>Catalog (Project)<\/b><span style=\"font-weight: 400;\"> option, display it to see the project you\u2019ve created in Google Cloud Platform <\/span><em><span style=\"font-weight: 400;\">(<\/span><a href=\"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery?utm_source=direct#:~:text=your%20Doppler%20account.-,How%20to%20create%20a%20project%20and%20highlight%20it%20in%20Google%20Cloud,-1%2D%20Click%20the\">How to create a project and highlight it in Google Cloud<\/a><\/em><em><span style=\"font-weight: 400;\">)<\/span><\/em><span style=\"font-weight: 400;\">. Select it and click <\/span><b>Test <\/b><span style=\"font-weight: 400;\">to be sure that the connection is done.\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You are ready to complete the process from Power BI.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>6 &#8211;<\/strong> Open Power BI, go to <\/span><b>Get Data<\/b><span style=\"font-weight: 400;\"> and look for <\/span><b>ODCB<\/b><span style=\"font-weight: 400;\">.\u00a0\u00a0<\/span><\/p>\n<p><img class=\"aligncenter wp-image-8189 size-full\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-3.png\" alt=\"\" width=\"573\" height=\"255\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-3.png 573w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-3-300x134.png 300w\" sizes=\"(max-width: 573px) 100vw, 573px\" \/><\/p>\n<p><span style=\"font-weight: 400;\"><strong>7 &#8211;<\/strong> Select <\/span><b>Google BigQuery<\/b><span style=\"font-weight: 400;\"> and paste the following query at the <\/span><b>Advanced Options <\/b><span style=\"font-weight: 400;\">section:<\/span><\/p>\n<blockquote><p><span style=\"font-weight: 400;\">SELECT * FROM `doppler-291113.doppler_reports.CampaignSummary`<\/span><\/p><\/blockquote>\n<p><img class=\"aligncenter wp-image-8190 size-full\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-4.png\" alt=\"\" width=\"736\" height=\"540\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-4.png 736w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/powerbi-4-300x220.png 300w\" sizes=\"(max-width: 736px) 100vw, 736px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">To finish, click <\/span><b>OK<\/b><span style=\"font-weight: 400;\">. Next you\u2019ll see your Campaign data and start designing your dashboard.\u00a0<\/span><\/p>\n<h3 id=\"tableau\"><strong>Connect BigQuery with Tableau<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\"><strong>1 &#8211;<\/strong> Open Tableau. At the <\/span><b>Connect <\/b><span style=\"font-weight: 400;\">section, go to <\/span><b>To a Server<\/b><span style=\"font-weight: 400;\"> and choose <\/span><b>Google BigQuery.<\/b><\/p>\n<p><img class=\"aligncenter wp-image-8191 size-full\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-1.png\" alt=\"\" width=\"694\" height=\"975\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-1.png 694w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-1-214x300.png 214w\" sizes=\"(max-width: 694px) 100vw, 694px\" \/><\/p>\n<p><span style=\"font-weight: 400;\"><strong>2 &#8211;<\/strong> You\u2019ll be redirected to log in with the Google account that has permission at BigQuery. Once you enter your Email address and click <\/span><b>Continue<\/b><span style=\"font-weight: 400;\">, you will be able to return to Tableau if everything is OK.\u00a0<\/span><\/p>\n<p><img class=\"aligncenter wp-image-8192\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-2-300x128.png\" alt=\"\" width=\"599\" height=\"256\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-2-300x128.png 300w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-2-1024x438.png 1024w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-2-768x328.png 768w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-2.png 1062w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">3- Choose the project you\u2019ve created at Google Cloud Platform <\/span><i><span style=\"font-weight: 400;\">(<em><a href=\"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery?utm_source=direct#:~:text=your%20Doppler%20account.-,How%20to%20create%20a%20project%20and%20highlight%20it%20in%20Google%20Cloud,-1%2D%20Click%20the\">How to create a project and highlight it in Google Cloud<\/a><\/em><em>)<\/em><\/span><\/i><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">4- In the <\/span><b>Project <\/b><span style=\"font-weight: 400;\">section, display and choose <\/span><b>doppler-291113<\/b><span style=\"font-weight: 400;\">. If it doesn\u2019t appear, click <\/span><b>+<\/b><span style=\"font-weight: 400;\"> and write its name.\u00a0<\/span><\/p>\n<p><img class=\"aligncenter wp-image-8193 size-full\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-3.png\" alt=\"\" width=\"494\" height=\"579\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-3.png 494w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-3-256x300.png 256w\" sizes=\"(max-width: 494px) 100vw, 494px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">5- At the <\/span><b>Data Set<\/b><span style=\"font-weight: 400;\"> section, choose <\/span><b>doppler-reports<\/b><span style=\"font-weight: 400;\">. To finish, <\/span><b>drag the table<\/b><span style=\"font-weight: 400;\"> you want to use to prepare your report.<\/span><\/p>\n<p><img class=\"aligncenter wp-image-8194 size-full\" src=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-4.png\" alt=\"\" width=\"492\" height=\"354\" srcset=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-4.png 492w, https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Tableau-4-300x216.png 300w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">That was all. <\/span><b>Enjoy the integration!\u00a0<\/b><\/p>","protected":false},"excerpt":{"rendered":"<p>Thanks to this integration, information about Campaigns goes to BigQuery and it travels from there to a Data Analytics tool in order to visualize personalized reports.<br \/>\n\u00a0<\/p>\n","protected":false},"author":46,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[2,579,583,486],"tags":[762,763,765,761,767,768,766,764],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Integrate BigQuery and visualize personalized reports - Doppler Help Center<\/title>\n<meta name=\"description\" content=\"Integrar Doppler con BigQuery es el primer paso para visualizar reportes personalizados de tus Campa\u00f1as. Descubre c\u00f3mo hacerlo f\u00e1cilmente.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integrate BigQuery and visualize personalized reports - Doppler Help Center\" \/>\n<meta property=\"og:description\" content=\"Integrar Doppler con BigQuery es el primer paso para visualizar reportes personalizados de tus Campa\u00f1as. Descubre c\u00f3mo hacerlo f\u00e1cilmente.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery\/\" \/>\n<meta property=\"og:site_name\" content=\"Doppler Help Center\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-18T02:38:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-05T18:54:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-es-1024x432.png\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julia Vega\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#website\",\"url\":\"https:\/\/help.fromdoppler.com\/es\/\",\"name\":\"Doppler Help Center\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/help.fromdoppler.com\/es\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8184#primaryimage\",\"url\":\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-es.png\",\"contentUrl\":\"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-es.png\",\"width\":1200,\"height\":506,\"caption\":\"Crear una cuenta gratuita en Doppler\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8184#webpage\",\"url\":\"https:\/\/help.fromdoppler.com\/es\/?p=8184\",\"name\":\"[:es]C\u00f3mo integrar BigQuery para visualizar reportes personalizados[:en]Integrate BigQuery and visualize personalized reports[:] - Doppler Help Center\",\"isPartOf\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8184#primaryimage\"},\"datePublished\":\"2021-11-18T02:38:18+00:00\",\"dateModified\":\"2026-01-05T18:54:55+00:00\",\"author\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/4601c462076bfd085da406a299458a01\"},\"description\":\"Integrar Doppler con BigQuery es el primer paso para visualizar reportes personalizados de tus Campa\u00f1as. Descubre c\u00f3mo hacerlo f\u00e1cilmente.\",\"breadcrumb\":{\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8184#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/help.fromdoppler.com\/es\/?p=8184\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/?p=8184#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/help.fromdoppler.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00f3mo integrar BigQuery para visualizar reportes personalizados\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/4601c462076bfd085da406a299458a01\",\"name\":\"Julia Vega\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ab7463c808850ae2064cb93effed3a91?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ab7463c808850ae2064cb93effed3a91?s=96&d=mm&r=g\",\"caption\":\"Julia Vega\"},\"url\":\"https:\/\/help.fromdoppler.com\/en\/author\/julia-de-doppler\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Integrate BigQuery and visualize personalized reports - Doppler Help Center","description":"Integrar Doppler con BigQuery es el primer paso para visualizar reportes personalizados de tus Campa\u00f1as. Descubre c\u00f3mo hacerlo f\u00e1cilmente.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Integrate BigQuery and visualize personalized reports - Doppler Help Center","og_description":"Integrar Doppler con BigQuery es el primer paso para visualizar reportes personalizados de tus Campa\u00f1as. Descubre c\u00f3mo hacerlo f\u00e1cilmente.","og_url":"https:\/\/help.fromdoppler.com\/en\/integrate-doppler-bigquery\/","og_site_name":"Doppler Help Center","article_published_time":"2021-11-18T02:38:18+00:00","article_modified_time":"2026-01-05T18:54:55+00:00","og_image":[{"url":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-es-1024x432.png"}],"twitter_card":"summary","twitter_misc":{"Written by":"Julia Vega","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/help.fromdoppler.com\/es\/#website","url":"https:\/\/help.fromdoppler.com\/es\/","name":"Doppler Help Center","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/help.fromdoppler.com\/es\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/help.fromdoppler.com\/es\/?p=8184#primaryimage","url":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-es.png","contentUrl":"https:\/\/help.fromdoppler.com\/wp-content\/uploads\/2021\/11\/Help-BigQuery-es.png","width":1200,"height":506,"caption":"Crear una cuenta gratuita en Doppler"},{"@type":"WebPage","@id":"https:\/\/help.fromdoppler.com\/es\/?p=8184#webpage","url":"https:\/\/help.fromdoppler.com\/es\/?p=8184","name":"[:es]C\u00f3mo integrar BigQuery para visualizar reportes personalizados[:en]Integrate BigQuery and visualize personalized reports[:] - Doppler Help Center","isPartOf":{"@id":"https:\/\/help.fromdoppler.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/help.fromdoppler.com\/es\/?p=8184#primaryimage"},"datePublished":"2021-11-18T02:38:18+00:00","dateModified":"2026-01-05T18:54:55+00:00","author":{"@id":"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/4601c462076bfd085da406a299458a01"},"description":"Integrar Doppler con BigQuery es el primer paso para visualizar reportes personalizados de tus Campa\u00f1as. Descubre c\u00f3mo hacerlo f\u00e1cilmente.","breadcrumb":{"@id":"https:\/\/help.fromdoppler.com\/es\/?p=8184#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.fromdoppler.com\/es\/?p=8184"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/help.fromdoppler.com\/es\/?p=8184#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/help.fromdoppler.com\/es\/"},{"@type":"ListItem","position":2,"name":"C\u00f3mo integrar BigQuery para visualizar reportes personalizados"}]},{"@type":"Person","@id":"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/4601c462076bfd085da406a299458a01","name":"Julia Vega","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/help.fromdoppler.com\/es\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ab7463c808850ae2064cb93effed3a91?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab7463c808850ae2064cb93effed3a91?s=96&d=mm&r=g","caption":"Julia Vega"},"url":"https:\/\/help.fromdoppler.com\/en\/author\/julia-de-doppler\/"}]}},"_links":{"self":[{"href":"https:\/\/help.fromdoppler.com\/en\/wp-json\/wp\/v2\/posts\/8184"}],"collection":[{"href":"https:\/\/help.fromdoppler.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.fromdoppler.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.fromdoppler.com\/en\/wp-json\/wp\/v2\/users\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/help.fromdoppler.com\/en\/wp-json\/wp\/v2\/comments?post=8184"}],"version-history":[{"count":45,"href":"https:\/\/help.fromdoppler.com\/en\/wp-json\/wp\/v2\/posts\/8184\/revisions"}],"predecessor-version":[{"id":12601,"href":"https:\/\/help.fromdoppler.com\/en\/wp-json\/wp\/v2\/posts\/8184\/revisions\/12601"}],"wp:attachment":[{"href":"https:\/\/help.fromdoppler.com\/en\/wp-json\/wp\/v2\/media?parent=8184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.fromdoppler.com\/en\/wp-json\/wp\/v2\/categories?post=8184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.fromdoppler.com\/en\/wp-json\/wp\/v2\/tags?post=8184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}