跳到主要內容 跳至補充內容

Spotify Ads 

Spotify Ads is a digital audio advertising platform.

Supported update methods

For more information, see 目標更新方法概述.

  • Change data capture (CDC)

  • Reload and compare

  • Change data capture (CDC) using Change Tables

  • Full load

  • Change data capture (CDC)

  • Reload

Preparing for authentication

To access your Spotify Ads data, you need to authenticate the connection with your account credentials.

資訊備註Make sure that the account you use has read access to the tables you want to fetch.

To get your client ID and secret:

  1. Create an application on Spotify for Developers.

  2. Click Edit Settings.
  3. Set the redirect URI to https://connector.qlik.com/auth/oauth/v3.htm. Your client ID and secret are displayed. Your client ID must be in the allowlist.
  4. To add your client ID to the allowlist, contact the ADS Studio API support: ads-api-solutions@spotify.com.

Creating the connection

For more information, see 連線到 SaaS 應用程式.

  1. Click Authenticate when you have filled in the required connection settings.

    You may be asked to log in to the source application.

    A window is displayed with an authentication code.

  2. Copy the code to the clipboard and return to the connection dialog.

  3. Paste the code in Complete authentication with the code provided by the source and click Verify.

    提示備註You may need to scroll down to see this field.

    When status is Verified,the authentication is verified.

  4. Provide a name for the connection in Connection name.

  5. Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
Setting Description
Data gateway

如您的使用情況有需要,選取 資料移動閘道

資訊備註

此欄位無法用於 Qlik Talend Cloud 啟動器 訂閱,因為不支援 資料移動閘道。若您有另一個訂閱層級且不想使用 資料移動閘道,選取

如需關於 資料移動閘道 福利的資訊以及需要此項的使用案例,請參閱 Qlik 資料閘道 - 資料移動

Client Id

Client ID.

Client Secret

Client secret.

Custom Report Dimensions One

Dimensions of the custom report one in uppercase, quotation marks and separated by commas.

The supported values are: CAMPAIGN, AD_SET, AD, ADVERTISER, YEAR, MONTH, DAY, HOUR, COUNTRY, REGION, DMA, PLATFORM, CURRENCY, COST_TYPE.

Example: "CAMPAIGN","MONTH".

Custom Report Metrics One

Metrics of the custom one in uppercase, quotation marks and separated by commas.

The supported values are: FETCHES, STARTS, FIRST_QUARTILES, MIDPOINTS, THIRD_QUARTILES, COMPLETES, IMPRESSIONS, CLICKS, SKIPS, ERRORS, SERVES, PAID_LISTEN_REACH, SERVE_REACH, SERVE_FREQ, PAID_LISTENS, PAID_LISTEN_FREQ, COMPLETION_RATE, SPEND, CTR, RENDER_RATIO, FETCH_REACH, STREAMS, NEW_LISTENER_STREAMS, LISTENERS, NEW_LISTENERS, INTENT_RATE, CONVERSION_RATE, NEW_LISTENER_CONVERSION_RATE, STREAMS_PER_NEW_LISTENER, STREAMS_PER_USER, OFF_SPOTIFY_IMPRESSIONS.

Example: "FETCHES","FIRST_QUARTILES","SPEND".

Custom Report Dimensions Two

Dimensions of the custom report two in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Two

Metrics of the custom report two in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Three

Dimensions of the custom report three in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Three

Metrics of the custom report three in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Four

Dimensions of the custom report four in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Four

Metrics of the custom report four in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Five

Dimensions of the custom report five in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Five

Metrics of the custom report four in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Six

Dimensions of the custom report six in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Six

Metrics of the custom report two in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Seven

Dimensions of the custom report seven in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Seven

Metrics of the custom report seven in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Eight

Dimensions of the custom report eight in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Eight

Metrics of the custom report eight in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Nine

Dimensions of the custom report nine in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Nine

Metrics of the custom report nine in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

Custom Report Dimensions Ten

Dimensions of the custom report ten in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Dimensions One field.

Custom Report Metrics Ten

Metrics of the custom report ten in uppercase, quotation marks and separated by commas.

See the list of the supported values and an example in the Custom Report Metrics One field.

此頁面是否對您有幫助?

若您發現此頁面或其內容有任何問題——錯字、遺漏步驟或技術錯誤——請告知我們可以如何改善!