Problem Yet another customer approached me to solve their reporting needs when it comes to digital marketing campaigns. The customer wanted to aggregate these sources: Google Ads (ad group level) Microsoft Advertising (ad group level) Ringba (call tracking and routing system) A few reference tables in Google Sheets The expected outcome was a nice Power […]
Category: BigQuery
Make.com Case Study: Loose Match Search with OpenAI and Some Boring Text Generation
Problem A customer needed to quickly understand the most common technical issues affecting particular car models on the US market. While NHTSA publishes these issues on daily basis for each car model, it’s not user friendly to work with. The requirement was to simply “ask” via email while providing the car model and get a […]
Make/Integromat Case Study: Web App to Simplify Management of PPC Shopping Feed
Problem A client needed to simplify the management of their massive Google Ads shopping feed. The client is running this setup: They have around 300,000 unique items in their feed. In reality, there are “only” around 12,000 unique physical products spread over 23 different combinations of e-shop domains and countries. The client needs to frequently […]
Case Study: Solving Digital Marketing Agency Reporting in 2 Weeks
Problem A client approached me with an evergreen problem: “My agency reporting sucks, can you help?”. Oh, I so had not heard that one before! (Actually I had). This was the client’s situation: Digital marketing agency is servicing around 20 customers. All reporting used to be done in standalone Excel files on client level. First […]
New BigQuery UI is Just Bad!
I would never believe I’d say something like this but Snowflake’s UI is terrible but Google is now far worse. Well done, Google! Here are several reasons why I think the new UI is just bad: It’s slow. Far slower than the previous UI. There is like 0.1s lag when you are typing your query. […]
Jak Stáhnout Sklik Data do BigQuery
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** Pro Sklik existuje řada skriptů (především od Standy Jílka), které umožňují stahovat data z Skliku do Google Sheetů. Nebudu tedy nosit dříví do lesa a raději zkusím stáhnout data o výkonu kampaní z Skliku rovnou do […]
Dealing with Cookie Apocalypse: Data ETL and Performance Reporting
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** The ongoing advertising cookie sunset poses serious challenges to reporting your campaign results. If your site does not use any sneaky cookie consent designs, you can expect to lose around 60-90% of advertising cookies. This means […]
Make/Integromat in the BI World: Will It Work?
***Please note that Integromat evolved into Make in February 2022. All content for Integromat is also valid for Make.*** I’ve always wondered whether you can use Integromat for making your life easier in the BI/analytics world where I am partially coming from. As I’ve been becoming more familiar with Integromat ecosystem I can say “yes“. […]
How to Get Data from BigQuery to Google Sheets?
As BigQuery becomes more popular many of you are asking a simple question: How does a person get data from BigQuery to Google Sheets on a regular basis? There are a couple options so let’s look at them on by one. Native Connector from Google If you are running “Enterprise Plus” or “G Suite Enterprise […]
Persistent User Defined Functions Now Supported in BigQuery!
Finally, BigQuery users have option to save their custom functions so they can be re-used across the project. Up until now, you could only create a UDF function within a query but you could not save the query as a view for example. Luckily, the times are changing now. But why should you care?