I'm investigating ways to get Marketing Cloud tracking information into Analytics Cloud. Marketing Cloud Connect is installed, but all Marketing Activity is initiated and takes place in Marketing Cloud. Very little action happening in Sales Cloud.
In general, the client wants data to flow from outside sources -> Sales Cloud -> Analytics Cloud. So dataflow is being used to bring it into Analytics Cloud, and middleware to get it into Sales Cloud.
In the past, Ive successfully used Jitterbit to bring the data directly in Analytics Cloud. But for arguments sake, let's say that bringing it into Sales Cloud is required this time.
What would be the least resource expensive way to bring in the tracking data? The client is going to want to do analyses and drill into results in Wave, but adding almost 500K rows of data per month into Sales Cloud seems like an unsustainable path (am I incorrect in thinking that?).
My thinking is that I should bring in the Account Sends, Opens, Bounces, Unsubs data, and create some corresponding custom objects with lookups to the contact and each other. The account sends should have some of the higher level data, and the others can be reflected at the contact level.
Is this approach sustainable? Is there a problem with it that I'm not anticipating? Is there a far better way to do this?