XPO comes with its built-in reporting and visualization capabilities. You may want to export the reporting data from XPO via email, FTP and also Google's Looker Studio (formerly, Google Data Studio) to slice and dice the data further in different visualization tools. Here's how you can export data into Looker Studio.
Step 1: Create a Looker Studio account (OPTIONAL)
Sign up and create a Looker Studio (LS) account , if you do not have one.
Step 2: Schedule a report in XPO
- After signing up for a LS account, go to XPO dashboard.
- To create a report to be delivered at your preferred schedule, click
- If you are using Account Dashboard: click Reports > Scheduled Reports
- If you are using Partner Dashboard: click Utility > Scheduled Reports
- Under recipient, type in your LS account email which you used to sign up or log in to LS to link your LS account with XPO.
Step 3: Link LS Account and XPO Account
Email email@example.com with the subject "Enable Data Studio" with the following details:
(a) your LS account email
(b) the URL to your XPO account (how to get XPO Account Link)
Access your account dashboard and copy the XPO account link from your browser address.
Once you have emailed, our client success team will enable the linking between your LS account and XPO account.
Step 4: Create Report and Add Tables in LS
Here, we will create a report and add the list of tables as data sources for the report. These tables are based on what you have selected in XPO (see Step2.2 above).
- Create a report on LS: click Create >> Report to create a new report.
- You should see this pop-up Add data to report.
Otherwise, click edit to enter into edit mode. Then, click on Add Data.
- From the Add data to report pop-up, click on Google Big Query.
- Click Authorize to enable LS to connect to XPO data using Google Big Query.
- Search for the project knorex-gds.
- Select the project knorex-gds > available dataset > the table you wish to use. (More about the table)
More About The Table
- The selected project is the same for all users.
- Each account is linked to only one dataset.
- The tables are based on the fields selected when creating the scheduled report in step 2.
Naming format of a table: <additional grouping>_<report name>_<scheduling deliver option>.
A table is created for each field selected under Additional Grouping. Each table contains all the fields selected under Report Metrics, Service Cost and Attribution Window.
For example, category_Test_DAILY table is created because the category field was selected under Additional Grouping. The other fields selected in the report metrics will appear as fields within the same table.
- Click Add to add the table to the report. The report will be used for creating charts and other presentations and visualizations in Step 5 (see below).
- Click Add to report.
- To add another table to the final report, repeat step 2 to 9.
Step 5: Configure Data Type
Here, you would need to configure the data types of the fields in each of the tables added in step 4.
- While in Edit mode, click Resource menu > Manage added data sources.
All the data tables that you have added in Step 4 will be listed.
- For each Click into one of the data tables to configure the data. Under Actions column, click Edit.
A list of all the fields in the table will be shown.
- Change the data type of the data fields accordingly. (view XPO report fields and data types)
What are the fields and their data types?
Data Type Additional Information
Create a new field to change the data type to Date
E.g., Ad Space ID
E.g., Age, Gender, Geo
E.g., Browser, Carrier, Device
E.g., Extension, Keywords
Create a new calculated field to use the "Percent" data type
Click the drop down and select the correct data type.
- Select the field name to change the name.
- Once completed, click Done. You will be presented with a list of tables.
- Once you have finished configuring the fields, click Close.
Step 6: View Report (Sample)
A sample report is provided here. You can easily create all sorts of charts and visualizations in LS.
Please sign in to leave a comment.