<div class='ui dimmer modals page' style='display: none;'><div id='helpie-password-modal' class='pauple_helpie ui modal small' style='display: none;'><div class='ui header'><i class='circular lock icon'></i> Password Protected</div><div class='item-content'><br /><label for='password_check'>Enter Password : </label><p><input type='password' id='password_check' name='password_check' class='password' value='' required></p></div><div class='actions'><div class='ui black deny button'>Nope</div><div class='ui positive right labeled icon button'>Yep, that's right!<i class='checkmark icon'></i></div></div><div class='clear'></div></div></div>{"id":83875,"date":"2026-10-15T11:52:24","date_gmt":"2026-10-15T14:52:24","guid":{"rendered":"https:\/\/reportei.com\/central-de-ajuda\/reportei-sync-how-to-create-a-query\/"},"modified":"2026-10-15T11:52:24","modified_gmt":"2026-10-15T14:52:24","slug":"reportei-sync-how-to-create-a-query","status":"publish","type":"pauple_helpie","link":"https:\/\/reportei.com\/en\/central-de-ajuda\/reportei-sync-how-to-create-a-query\/","title":{"rendered":"Reportei Sync: how to create a query"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">To create a query, first open the Reportei Sync extension in Google Sheets and select the platform you want to retrieve data from.<\/p>\n\n\n<p class=\"wp-block-paragraph\">Then select the account, metrics, dimensions, campaigns, and analysis period you want to use.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"370\" height=\"1024\" alt=\"\" class=\"wp-image-63574\" src=\"https:\/\/reportei.com\/wp-content\/uploads\/2025\/12\/Captura-de-Tela-2025-12-31-a\u0300s-11.39.10-370x1024.png\" style=\"aspect-ratio:0.36114228306988577;width:290px;height:auto\" srcset=\"https:\/\/reportei.com\/wp-content\/uploads\/2025\/12\/Captura-de-Tela-2025-12-31-a\u0300s-11.39.10-370x1024.png 370w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/12\/Captura-de-Tela-2025-12-31-a\u0300s-11.39.10-108x300.png 108w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/12\/Captura-de-Tela-2025-12-31-a\u0300s-11.39.10-400x1108.png 400w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/12\/Captura-de-Tela-2025-12-31-a\u0300s-11.39.10.png 528w\" sizes=\"(max-width: 370px) 100vw, 370px\" \/><\/figure>\n\n\n<p class=\"wp-block-paragraph\">For example, suppose you want to see daily reach and impressions for your Meta Ads account. You would use these settings:<\/p>\n\n\n<ul class=\"wp-block-list\">\n<li>Dimension: Date<\/li>\n\n\n<li>Metrics: Impressions and Reach.<\/li>\n<\/ul>\n\n\n<p class=\"wp-block-paragraph\">This example would produce three columns\u2014Date, Reach, and Impressions\u2014with one row for each day in your selected analysis period.<\/p>\n\n\n<p class=\"wp-block-paragraph\">This video shows an example of creating a query and then setting up automation:<\/p>\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Como AUTOMATIZAR seus dados no GOOGLE SHEETS com o Reportei Sync\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/ozwEKcMu_24?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>To create a query, first open the Reportei Sync extension in Google Sheets and select the platform you want to retrieve data from. Then select the account, metrics, dimensions, campaigns, and analysis period you want to use. For example, suppose you want to see daily reach and impressions for your Meta Ads account. You would [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"helpdesk_category":[4485],"helpie_tag":[],"helpie_add_tag":[],"helpie_up_tag":[],"class_list":["post-83875","pauple_helpie","type-pauple_helpie","status-publish","format-standard","hentry","helpdesk_category-reportei-sync-en"],"_links":{"self":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/83875","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie"}],"about":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/types\/pauple_helpie"}],"author":[{"embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/comments?post=83875"}],"version-history":[{"count":1,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/83875\/revisions"}],"predecessor-version":[{"id":83876,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/83875\/revisions\/83876"}],"wp:attachment":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/media?parent=83875"}],"wp:term":[{"taxonomy":"helpdesk_category","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpdesk_category?post=83875"},{"taxonomy":"helpie_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_tag?post=83875"},{"taxonomy":"helpie_add_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_add_tag?post=83875"},{"taxonomy":"helpie_up_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_up_tag?post=83875"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}