13.2. Bridge Fields: Filtering Multiple Data Sources - Advanced Looker Studio Tutorial
Vložit
- čas přidán 7. 05. 2023
- Fooling Looker Studio with Bridge Fields: In this lesson, we'll explore a workaround to overcome Looker Studio's limitation in filtering across different data sources. We'll use a concept called bridge fields to achieve this.
Looker Studio Certification:
When you're ready, take the final exam to test your knowledge and become a certified Looker Studio Expert →
lookerstudiomasterclass.com/l...
📩 lookerstudio.tips → Receive my weekly Looker Studio tips.
💬 lookerstudio.community → Get help with Looker Studio.
🔔 Subscribe and turn on notifications so you don't miss the future lessons!
Examining Fields and Field IDs
First, let's take a closer look at a data source and its fields. Each field has a name, type, default aggregation, and description. You can rename a field without affecting the reports because Looker Studio uses an internal field ID to recognize each field.
For built-in fields within a data source, you cannot see the value of the internal field ID. However, for custom fields you create, you can see and edit the field ID when you initially create the field.
Creating Bridge Fields
The idea behind bridge fields is to use Looker Studio's field ID functionality to make it believe that a field from one data source is the same as a field in another data source. To do this, you need to create a custom field in each data source with the same field ID.
For example, in a Google Sheet data source, create a new field called "Country-Bridge" and set the field ID to "country_bridge". Use the same values as the "country" field in this new field.
Next, create a similar field in your Google Analytics data source with a different name (e.g., "Country-Bridge_02") but with the same field ID ("country_bridge"). Again, use the same values as the "country" field.
Now, when you apply the bridge field to the dropdown control, both the Google Sheet and Google Analytics data sources will be affected when you filter by country.
Using Bridge Fields in Real-Life Scenarios
Bridge fields can be helpful when you have campaigns running on different platforms (e.g., Google Ads, Microsoft Ads, Facebook Ads) and want to filter data from all sources using a single dropdown menu. It's currently the only way to filter across different data sources in Looker Studio.
Remember that this is a workaround and might not always work as expected. Always test your reports thoroughly to ensure accuracy.
You have no idea how long I have been struggling with this for, thank you very much. I instantly subscribed because your Looker Studio skills are god-tier.
Excellent! Precisely what I was looking for! Many thanks!
This is gold, I have been searching for a solution for this for so long! Amazing work
This is awesome. I've been breaking my head over this in Looker. Thanks a ton!
This video needs more views.
Thank you for sharing!!~
Looking for this everywhere! You saved me ❤
Happy to hear that!
Great stuff, this will help us create one report level filter for more intuitive date filters. We've been doing small "buttons" for quarterly and yearly filters (using a bar graph that we make into a clickable button to filter out). We many databases build for various classes or business units in our breweries and this will help us streamline things.
Dude, what a hack. Amazing! Thanks a bunch.
You're that type of people I like to work with. Pushing the envelope, innovative solutions, hacking platforms, neat tricks... Well done
🙏🏻
amazing very clever thanks for sharing this
you are a genius mate
Thanks!
Well done! This is a brilliant solution.
Thanks!
Thanks! This is what I was looking for, could not find this. Not with bard or gpt... either.
uff.. man.. you took me out of the mud... i was so lost on this... thnks a lot
Glad it helped!
Vlw Siavash tmj hein!
Thanks, super usefull!
Thanks for feedback!
Hello,
Thanks a lot for this video. I have an issue while using this approach. I have two tables from two different data sources. When I create a control, it works perfectly well on the two tables and filters the value accordingly. When I try a filter action (clicking on a value) in one table it doesn't filter in the other table but it filters the control properly. Is there a way to use this more dynamically, allowing you to filter across data sources by clicking on a value?
Thanks in advance for your help
What if my bridge field is different from what I want to show in the drop down? Is this possible? Example using Spotify: I have a table of songs, but instead of a song control or genre control, I want to have a control of a person's playlists (many to many).
Great tutorials. Thank you so much. I've been applying your knowledge to my own sheets, but I got stuck with my filters.
I have set a filter for specific pages I want to review with ga4 as data source. But when I want to show more than 3 pages I they show all pages from ga4. Do you know how I can see only the pages I want to see?
Glad you found the videos useful!
For assistance and support with your specific questions and challenges in Looker Studio, please join Looker Studio Community: facebook.com/groups/lookerstudiocommunity/
It’s a great place to ask your technical questions and connect with other Looker Studio users and experts. While I may not be able to respond to every query, other community members may be able to assist you!
Hi Sir,i want to make a report for a online store. Here i want to show month wise sells for Individual customer purchased the product. So need to make a report Customer wise product purchased and total sells happened for the individual product in looker studio.Any guidance on this.Which Chart also i can use to show total sells happened by product category wise by individual customer purchased. Please guide me. I need help urgently on looker studio
For assistance and support with your questions and challenges in Looker Studio, please join Looker Studio Community: facebook.com/groups/lookerstudiocommunity/
It’s a great place to ask your technical questions and connect with other Looker Studio users and experts. While I may not be able to respond to every query, other community members may be able to assist you!
How we can do calculation between fields from different sources without blending them? E.g., I have a "sales" column in source A and a "Total" column in source B, and I'd like to add a "Remaining" column to my reporting table, so by filtering each product which has the "same filed ID" on both sources, I'd like to see the amount left in the inventory. Thanks
You can't bring calculations from multiple data sources in the same formula without blending data.
@@siavashkanani Thanks. I also tried to add a custom field in the Blended data source to create a conditional filter based on different sources but there wasn't an option in the Blended data source, unlike the single data sources. For example to exclude the rows that for example "OR(Column A and B in source 1) AND OR (Column C and D in Source2))" is true.