Are you struggling with manual downloads of your Amazon MWS reports? Is your reporting platform Power BI? If the answer to both of these questions is yes, what follows next is going to save you a lot of time. We’ll show how to connect Amazon MWS reports into Power BI with an always-on data feed.…
Is Power BI the main tool in your reporting stack? If you need to get your HubSpot data connected, this is the right place to start. This article will guide you how you get your HubSpot data into Power BI for further analysis. You’ll have access to all HubSpot data and the whole process should…
Comprehensive Power BI Facebook Ads Marketing Report Exploring a wide range of Facebook Ads metrics was always a challenge. Now, with this .pbix template, you can go deep into the data and discover the relationships between different conversion metrics. When you connect your data and apply your API Key, you can start analyzing your data.…
Try our Facebook Ads ROAS Power BI Desktop Report This .pibx template will let you explore the data once you connect your data and apply your API Key. If you are an advanced Power BI user, using this format, you can explore the data in more detail. This Facebook Ads ROAS Power BI Report template…
Are you a marketer living in Google Sheets? Connecting Facebook Ads to Google Sheets allows you to create reports, transform and blend data or pass them on to other platforms like Google Data Studio. This article covers getting automatically refreshed Facebook Ads data into Google Sheets. This includes but is not limited conversion metrics (including…
Having fresh Facebook Ads in Power BI is very useful. Especially in case you are investing heavily into Facebook and Power BI is your central reporting platform. In this article we’ll explain how to get both platforms connected. The whole process should not take more than 5 minutes and you can choose between >200 different…
This Excel Google Search Report Dashboard Template is ideal for Business owners, SEO specialists, and marketers alike. If you are focused on online marketing, Search Console will monitor your website traffic so that you can optimize your ranking and make decisions about the appearance of your site’s search results. Using the Excel Google Search Report…
To effectively use any platform and LinkedIn Ads, you need first to understand your marketing goals and then understand the data, by using this LinkedIn Ads Overview Report template. You should know each measured quantity and how they interact with each other. Using the simple LinkedIn Ads overview Report Template, you can start to study…
For visualizing your Microsoft Bing Ads, you can now use the Excel Bing Ads Overview Report Template. Using the Bing Ads Overview Report template, you can create charts for the Bing Ads in Excel in just a few clicks. In this template, we are using these metrics: Source Campaign Clicks Impressions Spend CPC CMP,…
If Excel is your preferred reporting tool, do check out the Excel Facebook Ads Overview Report Template. This Facebook Ads Overview Report template helps you to visualise your Facebook Ads into Excel in a few clicks. Dimensions and metrics visualised in this report are Source Campaign Adset Name Clicks Impressions Spend Cost per conversion as…
This Power BI LinkedIn Ads Report Dashboard Template helps you to visualise your LinkedIn Ads into Power BI in a few clicks. Dimensions and metrics visualised in this report are Campaign Clicks Impressions Spend CPC CPM Likes Reactions Total Engagements It queries the data through our connector and makes it available in real-time. Follow the…
This Bing Ads Power BI Report Dashboard Template helps you to visualise your Bing Ads into Power BI in a few clicks. Dimensions and metrics visualised in this report are Source Campaign Clicks Impressions Spend CPC CPM It queries the data through our connector and makes it available in real time. Follow the steps outlined…
This Facebook Ads Overview Report template helps you to visualise your Facebook Ads into Power BI in a few clicks. Dimensions and metrics visualised in this report are Source Campaign Adset Name Clicks Impressions Spend Cost per conversion There is a list of close to 300 metrics and dimensions available once you start customising the…
Let’s make decisions based on data. Your own very specific data. Getting standard fields, dimensions, metrics, columns, … from your marketing platforms is not a simple feat. Once you get there you will often find out that your north-star metric you report on seems to be missing. Especially when you copy an existing report…
Do you have many returns or cancellations on your ecommerce transactions? This is a very common pattern in most of Europe and parts of Asia. Your ecommerce platform (Shopify, Magento, …) will likely tell you a different story than Google Analytics Ecommerce. You are not alone with this challenge. We receive many questions on…
Is BigQuery part of your data stack? If yes, this tutorial will guide you on how to set up your automated data pipelines. Google has great support for it’s own products but in 99% of all cases, you have other platforms on your marketing stack. In this article/youtube tutorial we will guide you how to…
Do you want to get all your performance marketing, CRM and analytics data visualised in Excel? To get there without spending too much of your time copy/pasting data, the instructions below will help you to set up your automated data-pipelines. You can connect to all the most commonly used platforms on the market Google…
This Google Search Console Report template helps you to visualise your Search Console (formerly known as Google Webmaster Tools) into Power BI in a few clicks. Dimensions and metrics available are Date Site Page Query Impressions Clicks CTR Average position It queries the data through our connector and makes it available in real time. Follow…
This Media Overview Report dashboard template fetches all of your advertising data and then visualises it in a single view. This Web Multichannel Attribution dashboard helps you to integrate all your performance marketing data into one place. By default it connects to your analytics data set (Google Analytics) and connects them with your media data.…
In case you have not tried it yet, Calendly has a great Google Analytics integration. It does the job well for basic goal tracking requirements. The setup is pretty much one click. While working with a client who is using our attribution platform I discovered that attribution is quite hard to do with this…
Google Analytics does not allow you to store any personally identifiable information. CRM systems often allow last-click tracking using UTM or their own parameters. This situation leaves marketers with siloed data. On one hand side, Google Analytics, which contains web analytics data, on the other side CRM data. CRM data contains the key to analysing…
With the Stripe connector you can easily import and match all your revenue data and understand the impact of your marketing spend to revenue and customer lifetime value To get started you will need to follow the steps below: Create a token in Stripe Log in to your Stripe account, head to Developers > API…
This Web Multichannel Attribution dashboard helps you to integrate all your performance marketing data into one place. By default it connects to your analytics data set (Google Analytics) and connects them with your media data from: Facebook Ads Google Ads LinkedIn Ads Bing (Microsoft) Ads Once it’s all connected you can then get an understanding…
GCLID’s by default are not available in Google Analytics. We had many clients wanting to store GCLID’s into a custom dimensions in Google Analytics. There are multiple ways of doing this but the easiest way is using Google Tag Manager. Check out our how to and learn how to do it in 5 minutes. Using…
If you’re looking to adjust your media buys it pays out to simulate outcomes. This Google Sheets PPC Planning Template can help you with your media planning. Simply connect your marketing sources and get started. This template focuses on ROAS based outcomes. During the current crisis many media buyers have to adjust media buys…
Tableau is widely used for data visualization. To get your Google Analytics, Facebook Ads, Google Ads, Bing Ads, LinkedIn Ads to Tableau is easy. Depending on your set up you work with a set of spreadsheets or database tables. Using a service like what I describe below is a good alternative to get started fast…
If Excel is your preferred reporting tool, do check out the Excel Marketing Reporting Template. If you’re buying media across channels, this template connects all of your data together into a single report. The standard template covers the most common channels and metrics. Modifying it to add additional channels is straightforward and doesn’t take you…
Trying to stay on top of all your marketing spendings can be a daunting task. Especially when you advertise on many channels it often involves manual work. This Google Sheets Budget Pacing Template will help you save a lot of time. You can easily connect data from any platform we support and see what requires…
Our Multichannel Attribution dashboard provides simple insights about paid and non-paid media performance. You can see top-level data from all your channels Google Ads Facebook Ads LinkedIn Ads Bing Ads Twitter Ads and understand their contribution to your marketings goals. It includes reporting on all channels on a Channel Groupings level to make it easy…
Data integration and multi-touch attribution is clearly a topic that is often talked about but hardly ever implemented. This introduction should help you to understand what steps you will need to take to get started in less than 10 minutes on your own: Integrate your analytics data from Google Analytics Integrate your costs data Google…
When and why the lead forms integration is needed A lead form is a form that allows a customer to provide his/her contact information to the advertiser. The form contains a few fields that are filled in by the customer, and a button to apply for a product/service, book a follow-up call/email, get a price…
