I'm trying to build a dashboard for Linkedin data, and the data connector isn't very intuitive. I've been using the 'Ad Analytics' report because that seems to be the only one that shows spend and clicks.
So far, I've built 3 separate tables for Accounts, Campaign Groups, and Campaigns. The only field that seems to display a unique key is "pivotValues" which will give me either the account, campaign group or campaign depending on what I selected on the connector.
However, there doesn't seem to be a way to pull in all three into the same table and there's no key that would link the three independent tables together.
I could potentially build my own Excel table that shows how each account is related to each campaign group and campaign, but that seems like a lot of extra work and maintenance for something that should automatically be pulled in from the connector.