The eve of August 2024

🔥 What's New ?

👉 Google cancels its plan to delete 1st party cookies for advertisers. What is the proposed solution?

By working on its solution: "The Privacy Sandbox", which aims to strike a balance between the needs of businesses and the protection of user data. Google realized that the transition and deletion of 1st party cookies would require "significant work from many participants" and would have an impact on publishers, advertisers and virtually everyone involved in online advertising.

In its article released on July 22, Google announced that it will give users the opportunity to make an informed choice that applies to all their web browsing, and they will be able to change that choice at any time without giving any details about how.

📖 Read the full article: A new path for Privacy Sandbox on the web In this July 2024 announcement, the Privacy Sandbox team shares an important update regarding third-party cookies in Chrome.

👉 Session-level traffic source at last click has been made available in Google BigQuery, a nice update for analysts.

The new field session_traffic_source_last_click provides session-level traffic source information, based on the last click.

This data corresponds to the last-click allocation visible in the GA4 user interface.

Registration session_traffic_source_last_click complements existing traffic source data in the BigQuery schema.

This update provides access to last-click attribution data for session-level traffic sources via BigQuery exports.

☝ This update improves traffic source analysis via last-click attribution in BigQuery, aligning exports with the GA4 interface. Analysts should, however, be prepared to explain discrepancies between different attribution models.

📖 F or more details on the GA4 export schema on BigQuery : [GA4] BigQuery Export schema - Analytics Help This article explains the format and schema of the Google Analytics 4 property data and the Google Analytics for Firebase data that is exported to BigQuery. Datasets For each Google Analytics 4 prop

👉 Stape.io now supports GTM Tools, which were originally designed, created, tested and owned exclusively by Simo Ahava.

The platform GTM Tools offers robust capabilities for managing containers, workspaces, tags, triggers and variables in Google Tag Manager, including:

• Centralized management of all GTM assets: create, update and organize efficiently.

• Track changes, review versions and maintain a clear audit trail.

💡 Tip of the month

Our "Tip of the month" section shares practical tips used daily at Starfox Analytics. These tips cover various Web Analytics tools to optimize your work. Don't hesitate to try them out and share them with your colleagues.

Activate mode Publish on Looker Studio:

As with Tableau or Power BI, Looker Studio's 'Publish' mode can be activated. This feature allows you to make changes to your dashboard in 'Draft' mode, without the viewer seeing the changes. The published version remains intact until the modifications are published.

It doesn't get any easier than this: On your dashboard, in edit mode, click on File > Publication parameters > Toggle on.

📖 F ind Looker Studio documentation: Report publishing - Looker Studio Help

🤩 Inside Starfox

🎉 Starfox Analytics increases its share capital to €100,000

This step strengthens our commitment to customers, partners and employees, supporting their long-term success. Our partners will benefit from higher value-added collaborations, while our employees will be supported by a growing company...

📖 Sharing Is Caring

Every month, our "Sharing is Caring" column presents an in-depth article on a current topic in Web Analytics. Our experts use their know-how and online resources to explore these topics in detail.

This month, discover our article on Consent Mode, a topic of growing interest in Web Analytics. Written by Oussama and Daniel from Starfox Analytics, this article sheds light on the specifics of Consent Mode. → ‣

❤️ Best articles of the moment

• Ingestion-time partitioning in BigQuery Have you ever used ingestion-time partitioning in BigQuery? It's a separate type of partitioning that distributes rows into partitions based on the time they land in BQ. Once such a table is defined, you can query the pseudocolumns PARTITIONDATE ...
• BigQuery WINDOW Functions | Advanced Techniques for Data Professionals A complete guide for maximizing the potential of BigQuery WINDOW functions to manipulate and transform data.
• ‍The recent announcement of the session traffic source in the Google... | 19 comments: The recent announcement of the session traffic source in the Google Analytics BigQuery export allows for additional explorations. Google Analytics 4 uses the... | 19 comments on LinkedIn