Xero
connector for Google Looker Studio
Connect your Xero data to report on it using Googles Looker Studio, visualise data from your Xero workspace including revenue, spend, invoicing, forecasts etc…
s.i.m.b.a Google Xero Connector includes
68 Dimensions &
18 Metrics
Get started with a 14 day free trial
Sign up to s.i.m.b.a by logging in with your Google account or registering an account from the login page. Or simply add the connector directly in Googles Looker Studio and we will create a free trial for you
Get one of our templates
Your can use one of our existing templates to get started visualising your Xero data Immediately
- LookerSTUDIO CONNECTOR
How to add s.i.m.b.a Xero connector using Looker Studio
- field definitions
Dimensions and Metrics included in the scope
| Field Name | Type | Description |
|---|---|---|
| Contact ID | dimension | Unique identifier for the contact |
| Company Number | dimension | Company number associated with the contact |
| Account Number | dimension | Account number associated with the contact |
| Contact Status | dimension | Status of the contact |
| Name | dimension | Full name of the contact |
| First Name | dimension | First name of the contact |
| Last Name | dimension | Last name of the contact |
| Email Address | dimension | Email address of the contact |
| Bank Account Details | dimension | Bank account details of the contact |
| Tax Number | dimension | Tax number associated with the contact |
| Updated Date | dimension | Date the record was last updated |
| Contact Groups | dimension | Groups the contact belongs to |
| Is Supplier | dimension | Indicates if the contact is a supplier |
| Is Customer | dimension | Indicates if the contact is a customer |
| Website | dimension | Website of the contact |
| Contact Persons | dimension | Persons associated with the contact |
| Has Attachments | dimension | Indicates if the contact has attachments |
| Has Validation Errors | dimension | Indicates if there are validation errors |
| tenant Id | dimension | Tenant ID associated with the contact |
| Balances Accounts Receivable Outstanding | metric | Outstanding accounts receivable balance |
| Balances Accounts Receivable Overdue | metric | Overdue accounts receivable balance |
| Balances Accounts Payable Outstanding | metric | Outstanding accounts payable balance |
| Balances Accounts Payable Overdue | metric | Overdue accounts payable balance |
| Payment Terms Sales Day | metric | Payment terms for sales in days |
| Payment Terms Sales Type | dimension | Type of payment terms for sales |
| Xero Network Key | dimension | Xero network key associated with the contact |
| simba report | dimension | Report data from Simba integration |
| Account ID | dimension | Unique identifier for the account |
| Name | dimension | Full name of the account |
| Status | dimension | Status of the account |
| Type | dimension | Type of the account |
| Tax Type | dimension | Tax type associated with the account |
| Class | dimension | Class of the account |
| Enable Payments To Account | dimension | Indicates if payments are enabled to the account |
| Show In Expense Claims | dimension | Indicates if the account is shown in expense claims |
| Bank Account Number | dimension | Bank account number associated with the account |
| Bank Account Type | dimension | Type of the bank account |
| Currency Code | dimension | Currency code associated with the account |
| Reporting Code | dimension | Reporting code associated with the account |
| Reporting Code Name | dimension | Name of the reporting code |
| Has Attachments | dimension | Indicates if the account has attachments |
| Updated Date | dimension | Date the record was last updated |
| Add To Watchlist | dimension | Indicates if the account is added to the watchlist |
| Code | dimension | Code associated with the account |
| Description | dimension | Description of the account |
| System Account | dimension | Indicates if the account is a system account |
| Type | dimension | Type of the account |
| Invoice ID | dimension | Unique identifier for the invoice |
| Invoice Number | dimension | Invoice number |
| Amount Due | metric | Amount due for the invoice |
| Amount Paid | metric | Amount paid for the invoice |
| Amount Credited | metric | Amount credited for the invoice |
| URL | dimension | URL associated with the invoice |
| Currency Rate | metric | Currency rate applied to the invoice |
| Has Attachments | dimension | Indicates if the invoice has attachments |
| Has Errors | dimension | Indicates if the invoice has errors |
| Date | dimension | Date of the invoice |
| Due Date | dimension | Due date of the invoice |
| Branding Theme ID | dimension | ID of the branding theme |
| Status | dimension | Status of the invoice |
| Line Amount Types | dimension | Types of line amounts on the invoice |
| Sub Total | metric | Subtotal amount of the invoice |
| Total Tax | metric | Total tax amount on the invoice |
| Total | metric | Total amount of the invoice |
| Updated Date | dimension | Date the invoice was last updated |
| Currency Code | dimension | Currency code associated with the invoice |
| Contact ID | dimension | Unique identifier for the contact |
| Contact Name | dimension | Name of the contact |
| Fully Paid On Date | dimension | Date when the invoice was fully paid |
| Invoice ID | dimension | Unique identifier for the invoice |
| Contact ID | dimension | Unique identifier for the contact |
| tenant ID | dimension | Tenant ID associated with the contact |
| Status | dimension | Status of the invoice |
| Currency Code | dimension | Currency code associated with the invoice |
| Description | dimension | Description of the invoice |
| Unit Amount | metric | Unit amount on the invoice |
| Tax Type | dimension | Tax type applied to the invoice |
| Tax Amount | metric | Tax amount on the invoice |
| Line Amount | metric | Line amount on the invoice |
| Account Code | dimension | Account code associated with the invoice |
| Quantity | metric | Quantity on the invoice |
| Line Item ID | dimension | Unique identifier for the line item |
| Account ID | dimension | Unique identifier for the account |
| Discount Rate | metric | Discount rate applied to the invoice |
- Why choose us
s.i.m.b.a. is fast, easy, convenient and accurate
- Proven Expertise: Our solution is trusted by businesses in various industries, enabling them to boost marketing performance and ROI.
- User-Friendly: You don't need to be a data scientist to use our platform. It's designed to be intuitive and accessible for marketing professionals at all levels.
- Dedicated Support: We're not just a software provider; we're your partner in success. Our support team is here to assist you every step of the way.
- Affordable: Achieving real-time insights shouldn't break the bank. Our solution is cost-effective, making it accessible to businesses of all sizes.
Real-Time Data
Our system pulls data from all your marketing channels, ensuring that you have access to real-time analytics, enabling you to make informed decisions on the fly.
Customization
Tailor your reports to focus on the metrics and KPIs that matter most to your business. No more sifting through irrelevant data.
Time Savings
Free up your team’s time by automating the tedious task of report generation. Let your team focus on what they do best – optimizing your marketing campaigns.
Comprehensive Insights
Gain a 360-degree view of your marketing efforts, making it easy to track ROI and make data-driven adjustments.
- TAILORMADE SOLUTIONS
Affordable Pricing Tailored for Your Needs
We believe in making marketing report automation accessible to businesses of all sizes. Our pricing structure is designed to be flexible and transparent, ensuring you get the best value for your investment.
Get Started Today
Don’t let outdated reports hinder your marketing strategy any longer. It’s time to automate your integrated marketing reports and gain the competitive edge with real-time insights into your Return on Marketing Investment.
Register today to learn more about our solution and how we can help you make data-driven decisions for your business’s success.
Contact the s.i.m.b.a. support team
Can’t find the information you need on the site? Just fill in the form and we’ll get back to you as soon as possible!