--- title: Google Data Processing Delay Workaround description: In this article we will show you how to avoid Google data processing delay with Dataddo. Get fresh Google Analytics 4 data easily, securely, and quickly. image: https://blog.dataddo.com/hubfs/google%20data%20processing%20delay%20workaround%20(1)-min.png --- [![Dataddo Blog](https://blog.dataddo.com/hs-fs/hubfs/blog-logo.png?width=180&name=blog-logo.png)](https://blog.dataddo.com) ** [Get Dataddo Free](https://www.dataddo.com/signup?hsLang=en) [![Start for Free](https://no-cache.hubspot.com/cta/default/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/42e092dc-d403-4ac3-bd34-06dc490bf6d9) # Google Data Processing Delay Workaround By My Linh Phung | 5 min read ![](https://blog.dataddo.com/hubfs/google%20data%20processing%20delay%20workaround%20(1)-min.png) - ** - ** - ** When working with data, getting updates in real time can be very beneficial for timely and fact-based decision-making. Unfortunately, when it comes to services provided by Google, there is often a processing delay ranging from 24 to 72 hours. Most Google services will show a “no data available” message for the past two to three days. Google Analytics, Google My Business, or YouTube all have up to 48 hours of data delay. In the case of Google Search Console, data from up to 72 hours ago might not be available. As for Google Analytics 4, although the data from the past 48 hours is being processed, you can still access it. It is, however, necessary to keep in mind that this data is not finalized and will most likely change as it continues to update. In this article, we will show you how you can extract fresh Google Analytics 4 data to your [warehouse](https://blog.dataddo.com/google-data-processing-delay-workaround#dwh) or [dashboard](https://blog.dataddo.com/google-data-processing-delay-workaround#dashboard) with the help of a data integration tool (in this case, Dataddo). - [Dashboard with Most Recent Data](https://blog.dataddo.com/google-data-processing-delay-workaround#dashboard) - [Historical Data Source](https://blog.dataddo.com/google-data-processing-delay-workaround#dashboard-1) - [Fresh Data Source](https://blog.dataddo.com/google-data-processing-delay-workaround#dashboard-2) - [Add Both Sources to the Same Flow](https://blog.dataddo.com/google-data-processing-delay-workaround#dashboard-3) - [Store Fresh Data in Your Data Warehouse](https://blog.dataddo.com/google-data-processing-delay-workaround#dwh) - [Conclusion: Why the Dataddo Connector?](https://blog.dataddo.com/google-data-processing-delay-workaround#conclusion) ## Dashboard with Most Recent Data To get fresh data to your dashboard, we will need to create two sources, one for historical data and one for fresh data. The second source will be a running window of fresh data which will keep updating with the most recent values which might not be the final version. ### Historical Data Source First, [set up your sources](https://docs.dataddo.com/docs/google-analytics-4#how-to-create-a-google-analytics-4-data-source). After you’ve created your first source, you can simply clone it to make sure both have identical metrics and attributes selected. In your list of [Sources](https://app.dataddo.com/sources), select the source for historical data. Make sure the snapshot keeping policy is **Append**. ![2 GA 4 to Dashboard - Historical source - snapshotting](https://blog.dataddo.com/hs-fs/hubfs/2%20GA%204%20to%20Dashboard%20-%20Historical%20source%20-%20snapshotting.png?width=2066&height=1091&name=2%20GA%204%20to%20Dashboard%20-%20Historical%20source%20-%20snapshotting.png) Next, go to the **Advanced Settings** tab and change the **Date_range_expression** to **4d4** (or older). ![3 GA 4 to Dashboard - Historical source - date range](https://blog.dataddo.com/hs-fs/hubfs/3%20GA%204%20to%20Dashboard%20-%20Historical%20source%20-%20date%20range.png?width=2066&height=1091&name=3%20GA%204%20to%20Dashboard%20-%20Historical%20source%20-%20date%20range.png) In short, this source will be adding the most recently finalized data to your table every day. ### Fresh Data Source In your list of [Sources](https://app.dataddo.com/sources), select the source for fresh data. For this source, we want the snapshotting policy to be **Replace**. ![4 GA 4 to Dashboard - Fresh source - snapshotting](https://blog.dataddo.com/hs-fs/hubfs/4%20GA%204%20to%20Dashboard%20-%20Fresh%20source%20-%20snapshotting.png?width=2066&height=1091&name=4%20GA%204%20to%20Dashboard%20-%20Fresh%20source%20-%20snapshotting.png) In the **Advanced Settings** tab, change the date range to **3d1** (data up until yesterday) or **3d0** (including today’s data). ![5 GA 4 to Dashboard - Fresh source - date range](https://blog.dataddo.com/hs-fs/hubfs/5%20GA%204%20to%20Dashboard%20-%20Fresh%20source%20-%20date%20range.png?width=2066&height=1091&name=5%20GA%204%20to%20Dashboard%20-%20Fresh%20source%20-%20date%20range.png) This source will be the running window with your fresh data. Every day, the last three days’ worth of data will be replaced. ### Add Both Sources to the Same Flow Go to the [Flows](https://app.dataddo.com/flows) page and click on **Create Flow** to add a source and destination. As both sources have the same metrics and attributes, both can be added to the same flow and sent to your dashboarding tool. ![6 GA 4 to Dashbpard - Flow creation](https://blog.dataddo.com/hs-fs/hubfs/6%20GA%204%20to%20Dashbpard%20-%20Flow%20creation.png?width=2066&height=1091&name=6%20GA%204%20to%20Dashbpard%20-%20Flow%20creation.png) ## Store Fresh Data in Your Data Warehouse When setting up your source, choose your **Date Range** to be **Three days ago**. You can also edit the date range by going to [Sources](https://app.dataddo.com/sources) > three dots at your source > Edit > Advanced Tab > Date_range_expression: 3d0. ![A GA 4 to DWH - snapshotting](https://blog.dataddo.com/hs-fs/hubfs/A%20GA%204%20to%20DWH%20-%20snapshotting.png?width=2066&height=1091&name=A%20GA%204%20to%20DWH%20-%20snapshotting.png) Authorize and create your [Destination](https://app.dataddo.com/destinations) by following the prompts provided by Dataddo. Next, head to [Flows](https://app.dataddo.com/flows). Add your newly created source and destination. If your warehouse allows **deduplication**, choose **Upsert** as your write mode. Upsert, however, is limited to 4 unique columns.  ![B GA 4 to DWH - flow configuration](https://blog.dataddo.com/hs-fs/hubfs/B%20GA%204%20to%20DWH%20-%20flow%20configuration.png?width=2066&height=1091&name=B%20GA%204%20to%20DWH%20-%20flow%20configuration.png) In case you need more than 4 unique columns, you can instead deduplicate in your own storage using **dataddo_extraction_timestamp**. ## Conclusion Although we used Dataddo for this specific problem, the most important part is the logic behind the process. Of course, manually setting this up should also be possible but quite honestly not advisable. Due to multiple days’ worth of data changing very frequently, you would have to keep extracting, adding, and replacing data daily. This could easily lead to mistakes that are not noticed until much later, thus compromising your data integrity. Moreover, Dataddo’s free tier lets you connect up to 3 data flows to dashboards. So, there is pretty much no need for you to set this up by yourself. No matter what approach you choose, all that’s left now is for you to start working with your data insights. Just don’t forget that you’re working with data that might still be subject to change!   |   **Get your fresh Google Analytics 4 Data today** Extract your fresh Google Analytics 4 data quickly and securely. [![Get fresh Google Analytics 4 data](https://no-cache.hubspot.com/cta/default/7885580/061d3851-606f-4abd-90d2-823126e1925a.png)](https://cta-redirect.hubspot.com/cta/redirect/7885580/061d3851-606f-4abd-90d2-823126e1925a) | | --- | Category: [Tools](https://blog.dataddo.com/tag/tools), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ### Related Articles** ## [Never Lose a Byte: When and Why to Use Full Data Re-Sync](https://blog.dataddo.com/never-lose-a-byte-when-and-why-to-use-full-data-re-sync?hsLang=en) *(5 min read )* Topics: [Tools](https://blog.dataddo.com/tag/tools), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ## [The Dataddo Community Forum: A Place for Support, Feedback, Resources](https://blog.dataddo.com/the-dataddo-community-forum-a-place-for-support-feedback-resources?hsLang=en) *(5 min read )* Topics: [Tools](https://blog.dataddo.com/tag/tools), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ## [Easy Kafka Data Pipelines to Databases and Apps: Real-Time Streaming](https://blog.dataddo.com/easy-kafka-data-pipelines-to-databases-and-apps-real-time-streaming?hsLang=en) *(5 min read )* Topics: [Tools](https://blog.dataddo.com/tag/tools), [tips-tricks](https://blog.dataddo.com/tag/tips-tricks) ### Subscribe to The Chronicles of Marketing Newsletter ## Comments ## Subscribe to Our Blog Stay up to date with the latest marketing, sales, and service tips and news. ![subscribe](https://blog.dataddo.com/hubfs/Illustrations/subscribe.svg) - [****](https://www.linkedin.com/company/dataddo) - © Dataddo, Inc. All Rights Reserved ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "My Linh Phung", "url" : "https://blog.dataddo.com/author/my-linh-phung" }, "dateModified" : "2024-05-23T15:37:12.345Z", "datePublished" : "2022-12-21T15:30:44.000Z", "headline" : "Google Data Processing Delay Workaround", "image" : [ "https://blog.dataddo.com/hubfs/google%20data%20processing%20delay%20workaround%20(1)-min.png" ], "mainEntityOfPage" : { "@id" : "https://blog.dataddo.com/google-data-processing-delay-workaround", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.dataddo.com/hubfs/Dark%20logo@3x-1.png" }, "name" : "Dataddo, Inc." } } ```