Facebook Ads Connector to Power BI

Meta Power BI connector service by VIDI helps solve these problems:

1. Extract and combine all of your Facebook Ads data in a single place
2. Automate data flow from Facebook Ads into Looker Studio, Power BI or any other data consumption tool of your choice
3. Save you money long term by replacing subscription-based software with our scripts
4. Customize/Enhance the data format based on your requirements

Here is what we offer:

• Create a serverless job on any cloud of your choice to fetch the data on a regular basis
• Store the data in the database or data warehouse of your choice. If you have a live database, we can use it. Alternatively we can create a new one for you. It can be any SQL database of warehouse for example SQL Server, Postgresq, Mysql, BigQuery, etc.
• Tailored data format customizations while ingesting the data to the database. This includes any transformations that are to be performed to match with your organization’s standards
• Our help identifying the data tables you need inside of Facebook Ads. Feel free to tell us about your data needs and we will confirm which tables are needed to satisfy them.
• Limit the extracted data to the specified list of regions if needed

This is a lightweight solution which drastically reduces the cost compared to the standard connectors like Supermetrics. Since this is a service-based solution, it offers a lot of customization opportunities which are not available in software-based solutions.

Below are the list of tables that will be generated for providing insights on ads_report & analysis by gender & age

Facebook Ads Report

Below is the table for facebook_ads insights data reporting

Column Name	Description
ACCOUNT_ID	Facebook account Id
DATE_START	Start date of the metric
DATE_STOP	End date of the metric
CAMPAIGN_ID	Campaign Id
ADSET_ID	Adset Id
AD_ID	Ad Id
CAMPAIGN_NAME	Name of the Campaign
ADSET_NAME	Name of the Adset
AD_NAME	Name of the Ad
CLICKS	Total number of clicks on the Ad during the period
INLINE_LINK_CLICKS	Total number of inline link clicks on the Ad during the period
SPEND	Total spend on the Ad during the period
IMPRESSIONS	Total number of impressions on the Ad during the period
ACTIONS	Different types of actions, including 1_day & 7_day views & clicks. Link_click, post, video_view, landing_page_view, post_engagement, page_engagement, omni_complete_registration, omni_purchase, omni_view_content, complete_registration, purchase, view_content etc.,
ACTION_VALUES	Different types of action_values including 1_day & 7_day views & clicks. omni_purchase, omni_view_content, complete_registration, purchase, view_content etc.,

We can customize the above report by adding more breakdowns like age & gender.

We can add more columns to the table, which gives more information about the performance  of the AD, which includes

Column Name	Description
CPC	Cost per Acquisition
CPM	Cost per Mille
CTR	Click Through Rate
Reach	Number of people who viewed the AD at least once

We can also fetch Facebook ADCreative data if required. Below if the AdCreative table

Facebook AdCreative

Column Name	Description
ID	Unique ID for an ad creative, numeric string
Name	Name of the Creative
AccountID	Ad account ID for the account this ad creative belongs to
ObjectStorySpec	The Page ID and the content to create a new unpublished page post
ActorID	Actor ID(Page ID) of the creative
ImageURL	A URL for the image for this creative
ThumbnailURL	A URL for a thumbnail image for this ad creative
Status	Status of the Ad Creative
LinkURL	A specific landing tab on your Facebook page by the page tab’s URL
ObjectURL	URL that opens when someone click on your link on a link ad
EffectiveInstagramStoryId	Used for instagram ads. ID of an instagram post to display as an instagram ad
AssetFeedSpec	Specifies and asset feed with multiple images

We can also fetch the data based on specific presets like

1. Yesterday spends
2. Last 3 days spends
3. Last 7 days spends
4. Last month spends

We can also fetch other tables based on your requirement for example

1. Ad Accounts
2. Ad previews

Ready to use our Meta Power BI connector?