How to generate and submit Contentsquare Data Comparison Files

Create Table #1:

1. To create Table #1, log in to your Adobe Analytics Reporting Suite. 

2. From the main landing page, click on the 'Projects' tab > 'Create Project' in the upper-right-hand corner of the screen.

3. From the modal that appears, select 'Blank workspace project' as the Project type.

4. You should now have a blank Panel and empty Freeform table.

Note: If you do not see this blank panel, or it is accidentally deleted, you can add a new one using the 'Menu Nav' > 'Insert' > 'Freeform table'.

5. Before you begin, input the set the date range in the upper-right hand corner of the Panel provided by your Contentsquare Implementation Manager. 

6. Using the left-hand vertical nav bar, open the 'Components' tab and drag-and-drop the following Dimension to the Freeform table:

• Day

7. From left-to-right, in this specific order, add the following Metrics to the table:

• Visits
• Page Views
• Orders
• Revenue 

8. Now add the following Dimension as a Breakdown of "Day", for each of the five days in your table:

• Mobile Device Type

9. Save the Project and give it a meaningful name such as, “Contentsquare Data Comparison”.

Sample Image of Table #1

Create Table #2:

1. After completing Table #1, using the left-hand vertical nav bar, open the 'Components' tab and drag-and-drop the following Dimension to the Freeform table: 

• Page

2. From left to right, in this specific order, add the following Metrics to the table:

• Visits
• Page Views
• Orders
• Revenue 

3. Ensure the 'Rows limit' on the Dimension being used is set to:

• 100

4. Save the Project.

Sample image of Table #2

Export a CSV of both tables: 

1. From your saved “Contentsquare Data Comparison” Project, navigate to the menu bar.

2. Click on 'Project' > 'Download CSV'

3. Retrieve the .csv file from its download location and share it with your Contentsquare Implementation Manager.

Create a free form exploration and import dimensions:

1. Navigate and log in to your Google Analytics property.

2. From the main landing page, click on the 'Explore' tab on the left-hand nav bar and then select the 'Blank' template from the top row of the screen. You should now have an empty Free form Exploration and blank/empty Free form table.

3. First, filter your date range to the same time period specified by your Contentsquare Implementation Manager.

4. Next, within the 'Variables' tab, click the '+' button next to the Dimensions section, search for and select the following Dimensions for import into your Exploration:

• Date
• Hostname
• Page path and screen class
• Device category

5. After selecting all Dimensions, click the 'Import' button in the upper right corner to proceed.

6. Now, within the same 'Variables' tab, click the '+' button next to the Metrics section, search for and select the following Metrics for import into your Exploration:

• Sessions
• Views
• Transactions
• Ecommerce revenue

7. After selecting all Metrics, click the 'Import' button in the upper right corner to proceed.

Create Free form Table #1:

1. Now, from top to bottom, in the same order as listed below, select the following Dimensions as Rows to create your first table:

• Hostname
• Page path and screen class

2. From top to bottom in the same order as listed below, add the following Metrics as Values to your table:

• Sessions
• Views
• Transactions
• Ecommerce revenue
• Event name

3. Under the 'Tab settings' column, scroll to the bottom 'Filters' section. Create a new filter on 'Event name' with the criteria “matches exactly” and the value “page_view”.

4. Next to the label of the current table/tab, click the down-arrow button and Duplicate the tab. Rename the tab 'Tab 2' or something similar to differentiate it from the first.

Create Free form Table #2:

1. Using 'Tab 2' you created in the previous step, manually clear all Rows in the table by clicking the 'X' button on each label.

2. Now, from top to bottom in the same order as listed below, select the following Dimensions as Rows to create your first table:

• Date
• Device category

3.From top to bottom in the same order as listed below, confirm the following Metrics as Values to your table:

• Sessions
• Views
• Transactions
• Ecommerce revenue

Export a CSV of both tables: 

1. For each of 'Tab 1' and 'Tab 2', click the 'Export data' button in the upper right-hand corner of the table and select 'CSV' from the drop-down menu. This will save the currently selected table as a .csv file in your Downloads folder.

2. Share the downloaded files with your Contentsquare Implementation Manager.

Create a new Custom Report & configure Tab #1: 

1. Navigate and log in to your Google Analytics property.

2. From the main landing page, click on the 'Customization' button on the left-hand nav bar and then select the 'Custom Reports' section. Click the '+ New Custom Report' button on the center of the screen. This will take you to the configuration screen for your Custom Report.

Note: Ensure that all Dimensions and Metrics you select below are in the same order as shown in the example screenshot.

3. Within the 'Report Content' section, click on '+ add report tab' and rename the new tab 'Tab 1'

4. Within the 'Report Content' section, from left to right, in this specific order, click on '+ add dimension' and select each of the following Dimensions:

• Hostname
• Page

5. From left to right, in this specific order, add the following Metrics:

• Sessions
• Pageviews
• Transactions
• Revenue

6. Under the 'Filters' section, create a new filter on 'Event Action' with the criteria 'Include' and 'Exact' and the value “page_view”.

Sample Image of Tab #1

Create Tab #2: 

Note: Ensure that all Dimensions and Metrics you select below are in the same order as shown in the example screenshot.

1. Create a second report tab by first clicking on '+ add report tab' and rename the new tab 'Tab 2'.

2. Within the 'Report Content' section, from left to right, in this specific order, click on '+ add dimension' and select each of the following Dimensions:

• Date
• Device Category

3. From left to right, in this specific order, add the following Metrics:

• Sessions
• Pageviews
• Transactions 
• Revenue

Sample Image of Tab #2

Download each tab as a CSV

1. In the upper right corner, set your date range of the report to the five-day period specified by your Contentsquare Implementation Manager.

2. For each of 'Tab 1' and 'Tab 2', click the 'Export' button in the upper right of the table and select 'CSV' from the drop-down menu. This will save the currently selected table as a CSV file in your Downloads folder.

3. Share the downloaded files with your Contentsquare Implementation Manager.