# SEO Revenue Attribution
# Introduction
If you have a sales-based business, this report is for you! Find out which channels and campaigns generate the best revenue Below you can familiarize yourself with the results of the work of our tool, such as the report SEO Revenue Attribution
# What opportunities does this report offer you?
- Ability to combine 100% operational data with marketing cost data
- A report with all the dates for the morning coffee
- Time savings due to automatic processes
- Transparent form of data presentation
- We automatically convert currencies from different accounts to a common currency
- The ability to share with other colleagues in the organization
- Adding your own calculation fields
- You’ll see what you lose and what you gain
# What do you find in this report?
- Answers to important questions tailored to your company
- Information on the current and historical performance of the company
- Information about user behaviour in different marketing channels
- Information on the effectiveness of marketing campaigns
Below you can see what your report might look like!
To help you better understand what you can do with our report and what you can find in it, we have prepared a detailed guide for you:
Demo Report link (opens new window) which will allow you to test our report against the data you are interested in at a time you specify.
Blog link (opens new window), here you will find a detailed description of the report along with examples and instructions on how to calculate the metrics you are interested in.
# List of necessary and optional collectors to create a report.
Required to create the report:
- Google Search Console link (opens new window)
Optional collectors:
- Google Analytics link (opens new window)
- Google Analytics 360 link (opens new window)
- Witcloud Stream
# Data schema
List of metrics and dimensions in the table
Expand to view the data schema
| name | type | dataStudio/description |
|---|---|---|
| date | STRING | Date |
| device | STRING | Device |
| query | STRING | Query |
| page | STRING | Landing Page |
| clicks | STRING | Clicks |
| impressions | STRING | Impressions |
| revenue_attr | STRING | Attributed revenue to page and device |
| transactions_attr | STRING | Attributed transactions to page and device |
| position | STRING | Position |
# Instructions for configuring the report
To create a report, you must first:
- Register on our platform Witcloud (opens new window)
TIP
If you don’t have a WitCloud account yet or need information on how to log in, you can find the instructions here (opens new window).
- After logging in, select the button Smart Data in the left pane.
- Select Reports from the drop-down list. You will be taken to a section where you can create a new report.
- To do so, click on the button “Add new report” at the top left, which will take you to a page with a list of available reports. Select the report SEO Revenue Attribution
- To create your report, you must have created the necessary Collect and then click on the “Create your own report” button. If you receive the following message, you have not set up the required collectu. You have to create it.
In the next step, you will be taken to a section where the following fields are required to be completed:
Report name - under this name you will find your report in our platform.
After filling in the above fields, click on the Next button
In the next step, you specify the period for which the historical data should be downloaded. Click on the “create” button to complete the creation of your report.
# Visualization
To get the visualization of the data in our proposed Data Studio tool, select the button “Link to template” in the Report Draft section, which will take you to the Studio date where you need to enter your login data for Witcloud.
The first step is to select your project Witcloud.
After clicking on “Next”, select your report.
To complete the configuration of the data visualization in the upper right corner, click the “Connect” button and then “Create Report” button. The data for the period you set is loaded into a table in BigQuery, which is updated every hour. Read more about this in the [Autoworkflow] section.
If you want to visualize the collected data in a tool other than Data Studio, you have the option. You can do this with a program of your choice, provided it connects to BigQuery. To do this, select the “Link to table” button in the Draft Report section, which will take you to the table in BigQuery.