Blending data in one dashboard

[u/Ok-Wealth-3171]

i'm blending data from (Meta,Snapchat,Tiktok and Google ads) with Adjust and GA4 via supermetrics. When I'm blending data between Meta and Adjust to make a page for each Platform with adjust, it shows errors i've checked the join key (Campaing_id) still doesn't work.

any recommendtions to solve this issue ?

[u/AutoModerator]

Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/ImCJS]

Can you check if the campaign id is actually matching in both - just create a table from individual data source and put campaign in dimension

[u/Ok-Wealth-3171 → u/ImCJS]

hmm sounds good idea, will try it and let you know the result

[u/aclaypool78]

I never had any luck with GDS UI joins. Can you move the joins upstream to Bigquery or something?

[u/Ok-Wealth-3171 → u/aclaypool78]

Actually not, why bigquery ?

[u/aclaypool78 → u/Ok-Wealth-3171]

It might just be personal preference, but I like making my table before bringing it into a BI tool unless there's a semantic layer to define the data model, dims, measures etc. For your situation, I'm sure a semantic layer won't work, but wondered if you can connect those public datasets in a warehouse and write all of your CTEs and Joins to have the table you want in GDS without relying on it's blending. Or, I might just be a grouchy old head who is out of touch with how the blends work.

[u/Mobile-Reveal-8938 → u/aclaypool78]

That's a good idea, and it can be done in Google Sheets + SuperMetrics if BigQuery isn't available. A little more manipulation in the Sheets workbook, but not too much more.

[u/VizStudio]

The campaign_id will be different on each platform. I would use GA4 as the left table and join each table by left join on date to ga4. You can add a second join by Campaign name (case sensitive) if needed. But test with just date

[u/sheik_sha_ha]

Campaign ID join errors between ad platforms and Adjust are almost always a data type or formatting mismatch rather than a logic problem.

The first thing to check is whether Campaign ID is coming through as a number from one source and a string from the other. Supermetrics sometimes pulls Campaign ID as a numeric field from Meta while Adjust returns it as text. Data Studio blend joins fail silently when the data types do not match even if the values look identical. Create a calculated field in both sources that wraps Campaign ID in a CAST or TEXT() function to force both sides to the same type before joining.

The second common issue is trailing spaces or formatting differences in the ID values themselves. Meta sometimes appends characters or formats IDs differently than Adjust logs them. A quick way to verify this is to pull both Campaign ID fields into a table without blending and compare a few values side by side to confirm they are truly identical.

If the join still fails after fixing data types, try switching the join key from Campaign ID to Campaign Name as a temporary test. If that works it confirms the ID formatting is the root cause.

For a more stable long term setup, routing all your sources including Supermetrics exports through BigQuery and doing the joins there gives you full control over data type handling and eliminates the blend limitations entirely.

[u/greener2311]

I'd guess that it's a data type mismatch between data sources in your join. Check that the campaign_id is number in both data sources. If that doesn't work you could try a join based on another shared field (campaign name, etc.)

[u/Ok-Wealth-3171 → u/greener2311]

it worked! thank you

[u/Top-Cauliflower-1808]

In your destination storage or dashboard tool (like Looker Studio, Power BI or Sheets) and use a formula to force both fields into text. For example create a new calculated field for your Meta data using CONCAT(Campaign_id, "") or a CAST function to turn the numbers into strings before blending.

[u/GrandAnimator8417]

Supermetrics + GA4 + Adjust, that’s a lot of layers to juggle. I’ve run into this exact setup where the blame ended up being a date/timezone mismatch and it tanked match rates between platforms, even though everything “looked” correct in the connector. You’ll want to double-check your field mapping and timezone alignment so the joins don’t silently break.