Hello, your video is very instructive, congratulations! Is it possible to apply this BigQuery date concept using the NATIVE_DIMENSION function in Looker Studio? For example, calculating business days between two dates?"
Thank you for your comments! Not for 100%. Syntacsys and a number of supporting formulas are different in BQ and LS. I always check support articles for that. For example - support.google.com/looker-studio/topic/7583292?sjid=1691447405445381925-EU
Is it possible to connect Bigquery +Search Console + Sheets For Marketers Google Sheet & fetch all the search console data in the Sheet connected to search console ? Pls reply 🙏🙏
Hello, your video is very instructive, congratulations! Is it possible to apply this BigQuery date concept using the NATIVE_DIMENSION function in Looker Studio? For example, calculating business days between two dates?"
Thank you for your comments! Not for 100%. Syntacsys and a number of supporting formulas are different in BQ and LS. I always check support articles for that. For example - support.google.com/looker-studio/topic/7583292?sjid=1691447405445381925-EU
@@gaillereports I need to check the engagement rate of each search term. The data is not showing when I blend the data of GA4 and GSC
Is it possible to connect Bigquery +Search Console + Sheets For Marketers Google Sheet & fetch all the search console data in the Sheet connected to search console ? Pls reply 🙏🙏
You can import Search Console data to BigQuery, and connect Google Sheets to BigQuery and make all caclulations there. It it helps