Expected Google ECommerce data

After your Google ECommerce account is successfully connected to Commerce Intelligence, the system will start importing data into a table titled ecommerce. This table records a data row for each transaction. This includes the following order-level data columns:

Column Name
Description
\_id
This column is the primary key.
accountId
This column contains the account ID associated with your Google Analytics eCommerce account.
profileName
This column contains your Google Analytics profile name.
profileId
This column contains your Google Analytics profile ID.
socialNetwork
This column contains the name of the social network (for example, Facebook, or YouTube)
campaign
This column contains the campaign name (for example, utm\_campaign).
medium
This column contains the medium name (for example, utm\_medium)
source
This column contains the source name. (for example, utm\_source)
keyword
This column contains the keyword description (for example, utm\_term)
transactionId
This column contains the order ID. This is used to join the referral data back to your orders data.
updated\_at
This column contains the last time that the data row was updated.
recommendation-more-help
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc