LinkedIn Ads Query authentication guide

This is a step-by-step guide to acquiring credentials for authorizing the LinkedIn Ads Query component for use in Matillion ETL. The LinkedIn Ads Query connector uses an OAuth for third-party authentication. While connector properties may differ between cloud data warehouses, the authentication process remains the same.

---

Prerequisites

Begin by creating an OAuth entry in Matillion ETL, as described in Manage OAuth. You should then configure this OAuth entry using LinkedIn credentials, obtained as described below.

---

Acquiring third-party credentials

1. Navigate to the LinkedIn Developers site, click My apps, and enter valid login credentials.
2. Once logged in, the browser will show the My apps page, which will display tiles for any apps you have previously created. Click Create app.
3. On the Create an app page, complete the following:
   • App name: A name for the app.
   • LinkedIn Page: Your company's LinkedIn page URL or name. The page you select will associate your company with the app. The company associated with the app can't be changed at a later stage.
   • Privacy Policy URL: The URL to your company's privacy policy. This is optional.
   • App logo: Upload a logo to be displayed to users when authorizing with the app.
4. Read the API Terms of Use, and then click I have read and agree to these terms.

5. Click Create app.

   Note

   Once the app has been created, it will require company verification, which can be initiated by clicking Verify in the Settings tab and following the on-screen instructions. However, this can be done at a later stage.

6. Click the Auth tab, then copy the codes from both the Client ID and Primary Client Secret fields, as they will be required to authorize in Matillion ETL.

   Note

   • Click the Show icon next to the Primary Client Secret field to make the secret visible before copying.
   • Make sure to copy the client secret before leaving the page, as it will appear only once.
   • When copying these credentials, some browsers may add a space to the end of the code. Watch out for this as it will cause the credentials to fail.

7. Scroll down to the OAuth 2.0 settings section. Click the edit icon (pencil) next to Authorized redirect URLs for your app, then click + Add redirect URL.

8. Paste the Callback URL (copied from the Manage OAuth dialog in Matillion ETL) into the field, then click Update.

   Note

   The callback URL—and therefore the Matillion ETL instance—must be HTTPS, not HTTP.

9. Click the Products tab at the top, and click Select next to the product that will be used by the OAuth app.

   Note

   Some products will require LinkedIn approval before they are added. In this case, you will need to click Request access, complete an Access Request Form, and wait for a response from LinkedIn.

10. In the Add ... dialog, read the Legal Agreement before clicking I have read and agree to these terms, then click Add product.

11. The products you have selected will now be displayed under the Added products section of the Products tab. If you see the products here, you can return to Matillion ETL and complete the authorization process.
12. In addition to the Client ID and Client Secret, you will need to specify the following scopes in the Permissions field of the Configure OAuth dialog in Matillion ETL. Paste the text exactly as shown here:

r_emailaddress, r_ads, w_organization_social, rw_ads, r_basicprofile, r_liteprofile, r_ads_reporting, r_organization_social, r_member_social, rw_organization_admin, w_member_social, r_1st_connections_size, r_marketing_leadgen_automation