Using BigQuery to Measure Content Engagement and Performance by Article Topic

Gauging the performance of content presents more of a challenge than retail transactions or lead generation: for content, we’re measuring engagement levels rather than specific outcomes (such as purchases, lead generation, or signups), or we’re attempting to correlate pages and subjects with any specific outcomes that we are measuring.

Google Analytics, on its own, supports several ways to combine with other data sources and generate great reports. With native integration of Analytics 360 into BigQuery, Google has made it much easier to join Google Analytics with other data sources, perform sophisticated querying, and take advantage of Big Data’s vast opportunities for deep analysis and insight.

In a recent blog post, Getting Your Feet Wet in the Data Lake: Analytics 360 in BigQuery, we reviewed the benefits that BigQuery offers to data engineers, analysts, and marketers.

BigQuery’s Benefits to Data Engineers, Marketers, and Analysts

As a no-ops cloud-based solution, BigQuery offers data engineers tremendous operational advantages over platforms such as Hadoop and Spark by eliminating the need for on-premises resources to support hardware infrastructure and software updates.

Marketers and analysts, for their part, can take advantage of BigQuery to output results from ad hoc queries within minutes or seconds and begin to gain insight about online/offline attribution, user funnels, and long-term customer value.

To read more about how publishers can merge Google Analytics and CMS data in BigQuery for better content insights, download the whitepaper.


About the Author

Hazem Mahsoub
Data Engineering Manager
Hazem has a strong passion for technology and science. His long career allowed to shift focus two or three times. Now very passionate about data engineering and data science. With the ever-growing amount of data, extensive transformations and preparation are needed before analysis and reporting can occur to reveal insights, affecting decision making. That’s where Hazem and his data engineering team shine and provide top-notch solution design and implementation. He received a Bachelor of Science in Communications and Computer Engineering from Cairo University. Since then, he has been preferring industry certificates, the latest Professional Data Engineer from Google.