As you probably already know, Supermetrics is a one-stop business software that allows marketers and analytics teams to pick up all their marketing data and bring it to their preferred analytics, reporting, or storage platform. In this post, I wanted to explore a lesser-known data integration products that Supermetrics offers, namely Microsoft Azure Storage. The Azure Storage integration allows users to store marketing data in a central location and enables them to connect/select data without tedious data extraction or scripting operations. Besides, it offers customizable template configurations to store data exactly the way you want it.
Before you begin creating your destination storage you need to configure the Azure container environment. Let us look at the prerequisites.
Time Needed : 15 minutes
A detailed step-by-step guide on how to configure Supermetrics for Azure Storage.
If you don’t have a Supermetrics account, you can always “Start free trial”.
This will enable you to log in with the Microsoft account that you have associated with Azure.
This is simple permission granting that applies to most integration products.
You can get an Azure account with 12 months of free services if you don’t have one as well.
The storage account name will be your container name in the Supermetrics portal. Finalize by clicking “Review + create”. The deployment might take a few minutes, but once finalized, you will get a prompt to “Go to resource”.
*If you cannot access this section then it means that you don’t have enough permissions. Contact your Azure admin to grant you access because you cannot connect without the connection string
You can confirm that your container authentication method is set as an “Access key” by clicking on the “Containers” option in the navigation menu. If the authentication method is not set as an access key then you will not be able to create a destination on the Supermetrics portal.
This will initiate the connection between Azure and Supermetrics.
8.1 Display name. Give it a unique name that will distinguish it from the other destinations.
8.2 Container name. This is the Azure Storage container name. You can get this from the Azure portal that you are going to link with Supermetrics.
8.3 Upload Path. This is the folder structure that you want to create in the Azure storage container. For example, if you specify a folder path like subfolder1/data then it will be created if it doesn’t exist yet in your container by the transfers.
8.4 Connection string. This is the access key that will allow you to authorize transfers from your Supermetrics portal. The connection string is available under access keys in the Azure storage account. Copy and paste to the configuration in the Supermetrics portal.
Now you can begin data transfer from any data source to Azure Storage.
Transfers are meant for transferring data into a data warehouse or cloud storage solution.
In this scenario, I will use Facebook Insights.
You can click “Save” and that should send your data source to the transfers’ dashboard. If the test fails, double-check all the information that you have entered and make sure it’s correct then run it again.
…and that is it! 🙂
This might not be necessary, but in case you want to remove a destination from your Supermetrics account, you can do the following:
If you want to change the destination path or container you can click on the edit icon and input new values.
You can get full access for 14 days for free without using your credit card. Once the 14 days are over then you will be charged according to the cost of the integration product. You can inquire and find out more about the pricing on the Supermetrics website.
All the connections in Supermetrics are handled and are encrypted by an SSL by default. Any attempt to connect via HTPP is automatically redirected to HTTPS. Users can revoke the access tokens for Supermetrics at any time. It is also compliant with both CCPA and GDPR policies.
Azure Cloud Storage is a great avenue for data analysts and marketers to store their marketing data. As usual, Supermetrics acts as the bridge between all your marketing platforms and Azure Cloud Storage. You can store your data in this central location with just a few clicks. Gone are the days where businesses had to write complex scripts for transferring data or doing manual transfers.
I hope this was helpful! If you have any questions, feel free to comment or check out some of the other Supermetrics articles that I have. Also, you get a 20% discount from a Supermetrics subscription via a special promo code (this applies to first-time purchases made from the website ONLY)!
Last but not least, if you are more of a video person, you can also see Supermetrics’ video walkthrough on the topic!
I've used Zapier for years to automate small tasks and create the lead generation system…
When I started creating custom GPTs for various tasks, one of the areas that I…
Over the past few months, I've had the opportunity to dive into Canva Magic Studio,…
In my nano tips series on ChatGPT so far, I've covered Data Storytelling and Visualization,…
It has been a while since my last post, but I finally managed to wrap-up…
Although cliché, the phrase "a picture is worth a thousand words" has never been more…
View Comments
Great article! I am a user of both but never thought about combining it. Thanks!
Hey Eduard, thanks! Great to here that you found the article useful! :)