I have imported a Facebook ads table and an Adwords table to my Elasticube, which both contain "Date", "Campaign" and "Campaign Type" (custom field) dimensions and "Clicks" and "Cost" facts/values.
One "Campaign Type" can correspond to many campaigns, and one Campaign can have "Click" and "Cost" values for many dates.
So far I have tried constructing custom dimension tables: one for the date, and a combined Campaign Type and Campaign table.
Unfortunately I am still unable to acheive my desired result: a single pivot table in the dashboard which combines data from the Facebook and Adwords sources.
Could someone please help me with this? I wasn't sure where to ask.
Please sign in to leave a comment.