Hi
I am studying a path to conversion report that highlights each marketing campaign (e.g. PPC, affiliate, direct to site etc...) that a user interacts with before making a transaction on our website.
The report features one column for the Order ID our system generates, then another column for the Campaigns that were involved with each Order ID. There can be more than one Campaign associated with an Order ID.
The layout means that for each order ID the associated Campaigns are each listed vertically in an individual cell.
I would like to see what the most common combination of Campaigns clearly - there are over 1800 records in total!
The data is organised along the vertical axis - I think I've attached a screenshot of spreadsheet to make it clearer.
In column 'A' we have a list of Conversion IDs that are repeated as many times as there are associated Campaigns.
In column 'B' we have the corresponding Campaigns listed vertically.
So we need to keep the association between A and B so that each path is correctly grouped together.
An example scenario would be:
Order W32456 has campaigns PPC, Affiliate, Direct to Site
Order W32457 has campaigns Affiliate, PPC, Social
Order W32458 has campaigns PPC, Affiliate, Direct to Site
I would like to easily show that 2 order used the path PPC, Affiliate, Direct to Site and that 1 order used the path Affiliate, PPC, Social.
How do I do this?
I am studying a path to conversion report that highlights each marketing campaign (e.g. PPC, affiliate, direct to site etc...) that a user interacts with before making a transaction on our website.
The report features one column for the Order ID our system generates, then another column for the Campaigns that were involved with each Order ID. There can be more than one Campaign associated with an Order ID.
The layout means that for each order ID the associated Campaigns are each listed vertically in an individual cell.
I would like to see what the most common combination of Campaigns clearly - there are over 1800 records in total!
The data is organised along the vertical axis - I think I've attached a screenshot of spreadsheet to make it clearer.
In column 'A' we have a list of Conversion IDs that are repeated as many times as there are associated Campaigns.
In column 'B' we have the corresponding Campaigns listed vertically.
So we need to keep the association between A and B so that each path is correctly grouped together.
An example scenario would be:
Order W32456 has campaigns PPC, Affiliate, Direct to Site
Order W32457 has campaigns Affiliate, PPC, Social
Order W32458 has campaigns PPC, Affiliate, Direct to Site
I would like to easily show that 2 order used the path PPC, Affiliate, Direct to Site and that 1 order used the path Affiliate, PPC, Social.
How do I do this?
