Ciugk

Clash Royale CLAN TAG #URR8PPP Connecting Column Based Time Partitioned BigQuery Table In Data Studio We have a real-time streaming column based time partitioned table in the big-query (with no _partitiontime pseudo-column) from which we wanted to build reports using Google data studio. _partitiontime When selecting the time-partitioned tables in the big query connector, it shows the following: When Use _PARTITIONTIME as time dimension is not checked: Use _PARTITIONTIME as time dimension The time-based query generated by data studio does a full-scan on big query table increasing our query costs. The same query auto-generated from data studio but using partitioning field manually in the WebUI as follows: In the big query data connector, when Use _PARTITIONTIME as time dimension is checked Use _PARTITIONTIME as time dimension It returns the following error for building charts: As of now, the reports are built using custom queries & views for limited timeframes. I understand the da...

Clash Royale CLAN TAG #URR8PPP Tracking #tag usage across the website I am implementing GA tracking for a big social content sharing platform, where users can use #tags for posts, comments etc. and I am looking for a way to correctly track how users use those tags across the website. Website owner wants to measure: amount of posts with certain #tags amount of #tag mentions in comments under posts (which may be related to other #tags) amount of upvotes/downvotes on posts related to certain #tags I was planning to use custom dimension "tag" and send its values whenever any tag-related action occurs, i.e. dim. value "bike" on a post where someone used a #bike tag. However there is a problem - most often actions that occur on the website are related to multiple tags simultaneously, i.e. a post with multiple tags, a pageview for one tag and a comment with another tag etc. Unfortunately, it is impossible to send multiple values for the same dimension at once. Looking for ...