What is it about
The Microsoft advertising connector extracts data directly from the Microsoft advertising reporting API and makes it available for use in your BigQuery environment.
To set up this connector, please watch the video guide or follow the step-by-step explanation below.
To start working with a connector, follow these steps:
Go to Home → Data and reporting → Connectors.
Click the button 'Create new connector'.
Give your connector a name.
Step 1: Choose a data source type and account
Select the data source type 'Microsoft advertising'.
Choose an account for Microsoft advertising. If no Microsoft advertising account is yet connected to Alvie, you will be prompted to connect this data source to Alvie first. To do so, simply follow this guide.
Step 2. Choose a report type
You can select one of the pre-defined reports or create your own report by choosing the user-defined report option.
There are some specifics based on the report type you choose:
Step 3: Select a date range
Select the date range to be applied to the connector. For more details, check the guide here.
Step 4: Set up data targets
Set up data targets to ensure your data is placed correctly. Follow the guide here on how to do this properly.
Step 5: Check advanced settings and activate your connector
Once you are ready, you can activate the connector and start it immediately. It is also possible to save the connector without activating it and return to it later.