Data blending Join Properties | match key fields and data type

Data blending Join Properties: Importance of same data type for match key fields

When creating data blends with Looker Studio the match key fields have to be the same data type. (also known as the join fields)

In the example below, you would need to  change the data type of customFieldId (Deal Custom Field Values) from Number to Text as per the screenshot below.

This will allow the  Deal Custom Field Values and Deal Custom Fields to be blended as in second screenshot.

18405492_1617228804JRuimage.png

18405555_1617228998nP9image.png

In addition, there are some helpful videos you can watch on our YouTube channel. 


    • Related Articles

    • Looker Studio: Speed up your dashboards

      Have you been in meeting or presentation and wanted to be able to share insight on Looker Studio but were hesitant because you never know how long you will be waiting your dashboard to render? If the answer to to that question is yes. Have you tried ...

    • ActiveCampaign: Creating your first Looker Studio data source to build your custom Dashboard

      Build Your Report Adding and authorising Find My Insight ActiveCampaign Connector in Google Data Studio. This guide shows you how to use a Find My Insight Connector for Data Studio, It's pretty simple, just add and then authorize the connector. This ...

    • Looker Studio: Creating a date dimension from a datetimestamp

      Often when building a dashboard you will want to group activities (metrics) by a datetime dimension. This could be day, week, month, year etc. Looker studio lets you select any of those attributes once you have dragged this into the chart. However, ...

    • ActiveCampaign: Using the Ecomm Integration resources for Shopify

      The ActiveCampaign data connector includes three ecommerce resources that you are able to connect to. (For a full description of the resources you can refer to the resource document from page 14 onwards) These are ecomCustomers ecomOrderProducts ...

    • ActiveCampaign: Managing large datasets with parameters

      If you have see this error "You are trying to retrieve more than 30000 data at one data source which will exceed Google quota", it means you have exceeded the Google quota for a script runtime. We recommend adding as many parameters as possible to ...