WitCloud Docs

# All in one report

# Introduction

If you use multiple systems and want to have all your business data in one place, this report is for you!

# 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
  • Useful business indicators include ERS, ROAS
  • 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 some screenshots of what your report might look like!

image alt text

image alt text

image alt text

To make it even easier for you to understand what options you have using our report and what you can find in it, we have prepared a detailed instruction manual with you in mind:
Demo Report (opens new window), which will allow you to test our report against the data you are interested in at a time you specify.
Blog (opens new window) here you will find a detailed description of the report with examples and instructions on how to calculate the indicators of interest to you.

# List of modules to create a report

# Data schema

  1. List of metrics and dimensions in the table
Hide out for the data schema
name type dataStudio/description
data_source_type STRING Data Source Type
data_source_subtype STRING Data Source Subtype
data_source_name STRING Data Source name
date STRING Date
ga_sessions INTEGER GA Sessions
ga_revenue FLOAT GA Revenue
ga_original_revenue FLOAT GA Original Revenue
ga_source STRING GA Source
ga_medium STRING GA Medium
ga_campaign STRING GA Campaign
ga_ad_content STRING GA Ad Content
ga_keyword STRING GA Keyword
cost FLOAT Cost
original_cost FLOAT Original Cost
clicks INTEGER Clicks
impressions INTEGER Impressions
ad_system_conversions FLOAT Ad Systems Conversions
ad_system_conversion_value FLOAT Ad Systems Conversions Value
original_ad_system_conversion_value FLOAT Ad Systems Conversions Value original
account_id STRING Account ID
account_name STRING Account Name
campaign_id STRING Campaign ID
campaign_name STRING Campaign Name
adgroup_id STRING AdGroup ID
adgroup_name STRING AdGroup Name
ad_id STRING Ad ID
ad_name STRING Ad Name
publisher_id STRING Publisher ID
publisher_name STRING Publisher Name
placement STRING Placement
currency STRING Currency
report_currency STRING Report Currency
shop_id STRING Shop ID
shop_name STRING Shop Name
order_id STRING Order ID
order_status STRING Order Status
order_delivery_name STRING Order Delivery Name
order_payment_name STRING Order Payment Name
order_city STRING Order City
order_region STRING Order Region
order_country STRING Order Country
product_id STRING Product ID
product_name STRING Product Name
product_code STRING Product Code
product_option STRING Product Option
product_quantity INTEGER Product Quantity
product_revenue_incl_tax FLOAT Product Revenue Incl. Tax
original_product_revenue_incl_tax FLOAT Original Product Revenue Incl. Tax
product_revenue_excl_tax FLOAT Product Revenue Excl. Tax
original_product_revenue_excl_tax FLOAT Original Product Revenue Excl. Tax
shipping_revenue_incl_tax FLOAT Shipping Revenue Incl. Tax
original_shipping_revenue_incl_tax FLOAT Original Shipping Revenue Incl. Tax
shipping_revenue_excl_tax FLOAT Shipping Revenue Excl. Tax
original_shipping_revenue_excl_tax FLOAT Original Shipping Revenue Excl. Tax
discount_value_incl_tax FLOAT Discount Value Incl. Tax
original_discount_value_incl_tax FLOAT Original Discount Value Incl. Tax
discount_value_excl_tax FLOAT Discount Value Excl. Tax
original_discount_value_excl_tax FLOAT Original Discount Value Excl. Tax

:::

# Instructions for configuring the report

To create a report, you must first:

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 All in one
  • 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.

image alt text

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 image alt text

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.

image alt text

# 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.

image alt text

The first step is to select your project Witcloud.

image alt text

After clicking on “Next”, select your report.

image alt text

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.

Last updated: 2022-08-18T12:43:03.000Z

← Analytics Source/medium + Ad Cost →