Attached is a sample of my table structure currently.
My data source is from Google Campaign manager. When I extract the different tables as indicated in the sheet, I get a difference in figures(I am taking over from a person who did the initial design). E.g Impressions might be one figure in my “fact table” and another figure somewhere else.
Problem is, there are no primary keys and also tying the tables to one another is also difficult, link might be between dates. The database is Google Bigquery.
Do you have any idea how to do a proper data design with this type of marketing data and does it need to be denormalised? From research I gathered, Bigquery data design is best as denormalised.
I would also like to move away from spreadsheets, I believe this is also part of the chaos.
I believe CM360 Data Platform is my fact table.