Hello could someone help me I m using Tap TikTok and I need Meltano #plugins-general

Hello, could someone help me? I'm using Tap-TikTok...

Felipe Solera Bosso

08/29/2025, 4:42 PM

Hello, could someone help me? I'm using Tap-TikTok and I need metrics for spend, impressions, clicks, and complete views. But I can't get them. I'm pulling multiple streams and still have no luck. Does anyone know exactly how I can get them?

Andy Carter

09/01/2025, 7:24 AM

Are you using

gthesheep

variant (Gary James)?

Andy Carter

09/01/2025, 7:28 AM

The

campaigns_basic_data_metrics_by_day

stream should give you what you need. What streams are you seeing returned? Happy to help if you can share your

meltano.yml

too.

Felipe Solera Bosso

09/01/2025, 2:52 PM

Copy code

Yes, I'm using this variant.
The stream fields are created in BigQuery, but they arrive empty. The ads fields arrive normally. My problem is exclusively with the metrics. In Airbyte, it works perfectly only with the ads_reports_daily stream.

My meltano.yml:

- name: tap-tiktok
variant: gthesheep
pip_url: git+<https://github.com/gthesheep/tap-tiktok.git>
config:
start_date: '2025-01-01'
select:
- ads.*
- ads_basic_data_metrics_by_day
- ads_video_play_metrics_by_day
- campaigns_basic_data_metrics_by_day

Edgar Ramírez (Arch.dev)

09/02/2025, 2:47 AM

@Felipe Solera Bosso have you tried adding

.*

to the other patterns?

Felipe Solera Bosso

09/02/2025, 1:30 PM

Copy code

yes, I tried and nothing worked, is there anything I can do to solve this? or does anyone have a real example of this tap absorbing metric data

Andy Carter

09/02/2025, 1:34 PM

I use this tap daily and works fine. Do you see any error messages? Or just no data whatsoever? Can you try

meltano invoke tap-tiktok

and see if if the tap is an issue or your target? What meltano command are you running?

Felipe Solera Bosso

09/02/2025, 1:39 PM

I ran

meltano invoke tap-tiktok

and it works — it successfully connects and returns data. But right now it’s only returning the ads
stream, which contains ad metadata (IDs, names, campaign/adgroup references, landing page URL, etc.), not performance metrics. That’s why I don’t see fields like

spend

impressions

clicks

, or

complete_views

Andy Carter

09/02/2025, 2:11 PM

Can you remove the

select

block from your meltano.yml completely for this tap and run again?

Felipe Solera Bosso

09/02/2025, 2:37 PM

"I ran the tap-tiktok invoke without --select and it returned all streams and records, but no data appeared in BigQuery. It seems like tap is extracting the data, but it's not reaching the target. Example of what appeared in the terminal: {"type": "RECORD", "stream": "campaigns", "record": {"advertiser_id": "7483174745081790480", "create_time": "2025-08-14 202150", "objective": "LANDING_PAGE", "budget": 57000.0, "objective_type": "REACH", "deep_bid_type": null, "modify_time": "2025-08-28 121227", "is_new_structure": true, "campaign_name": "PER00055_colecao-ago_pace_tiktok_alcance_cpm", "budget_mode": "BUDGET_MODE_TOTAL", "roas_bid": 0.0, "campaign_id": "1840458814058594", "campaign_type": "REGULAR_CAMPAIGN"}, "time_extracted": "2025-09-02T141647.895413Z"} E isso se repetiu para todas as streams de métricas.”

Felipe Solera Bosso

09/02/2025, 2:43 PM

Correcting me, this is campaign data, it worked and went to BigQuery, but metric data such as spend and clicks were not marked in the invoke, even though I removed the field from the select

Andy Carter

09/02/2025, 2:58 PM

OK, that's good and helps narrow down. Next assuming you are on a *nix platform try

meltano invoke tap-tiktok > output.jsonl

and see if the desired stream is in the output file

Andy Carter

09/02/2025, 2:59 PM

Then search the file for the

campaigns_basic_data_metrics_by_day

stream

Andy Carter

09/02/2025, 2:59 PM

THese are the streams the tap will produce by default:

Copy code

ad_accounts
ad_groups
ads
ads_attribute_metrics
ads_attribution_metrics_by_day
ads_basic_data_metrics_by_day
ads_engagement_metrics_by_day
ads_in_app_event_metrics_by_day
ads_page_event_metrics_by_day
ads_video_play_metrics_by_day
campaigns
campaigns_attribute_metrics
campaigns_attribution_metrics_by_day
campaigns_basic_data_metrics_by_day
campaigns_engagement_metrics_by_day
campaigns_in_app_event_metrics_by_day
campaigns_page_event_metrics_by_day
campaigns_video_play_metrics_by_day

Felipe Solera Bosso

09/02/2025, 5:33 PM

I ran

meltano invoke tap-tiktok > output.jsonl

as suggested and then searched for the

campaigns_basic_data_metrics_by_day

stream. Here's what I found: {"type": "SCHEMA", "stream": "campaigns_basic_data_metrics_by_day", "schema": {...}} {"type": "STATE", "value": {"bookmarks": {"campaigns_basic_data_metrics_by_day": {}}}} The Stream exists, the SCHEMA section shows the fields that

campaigns_basic_data_metrics_by_day

would have (spend, cpc, impressions, clicks, conversions, etc.). No actual metric records were extracted — all the STATE bookmarks are empty, meaning no data was pulled.

✅ 1

Andy Carter

09/03/2025, 7:39 AM

You got me looking at my data but we haven't run any ads live for 2 months. So you will only get metrics if you are actively running ads now, or have been in the past. Is it only the ``campaigns_basic_data_metrics_by_day` that is empty? Are all the other metrics by day streams empty? If you can logon to ads account online can you see what is running? Have these ads all been recently created?

Andy Carter

09/03/2025, 7:41 AM

If you have historical data make sure that 'start_date' is sufficiently far back to get this

Felipe Solera Bosso

09/03/2025, 2:00 PM

Thanks for getting back to me. We actually did have active campaigns in the past 2 months, so we expected metrics like spend, impressions, clicks, and complete views to already be available. The

ads

stream is bringing ad metadata correctly, but the

ads_basic_data_metrics_by_day

stream (and possibly other daily metric streams) is still returning empty. I’ve also reviewed the

start_date

parameter to ensure it covers the correct period. Could you confirm if there is any specific limitation in the API or additional configuration required for these metric streams to return data?

Felipe Solera Bosso

09/03/2025, 3:20 PM

Copy code

I checked the start date and the save status, we currently have airbyte active and it is resulting in data normally

Andy Carter

09/03/2025, 8:16 PM

Sorry you're experiencing this. I didn't do any extra config to retrieve the metrics streams - they arrived automatically with the basic tap setup.

Andy Carter

09/03/2025, 8:19 PM

I'm assuming you are using exactly the same advertiser ID and credentials for airbyte as your are for meltano? The only other thing I could suggest is making a rest call replicating the settings for that stream via postman or similar and seeing if any data is returned.

Andy Carter

09/03/2025, 8:26 PM

Given that you say the airbyte stream

AdsReportsDaily

returns data, can you see any metrics in the

ads_basic_data_metrics_by_day

meltano stream? That would be the equivalent in the meltano tap.

Andy Carter

09/03/2025, 8:28 PM

Have you also tried a run with the

--full-refresh

flag to reset the state? Try setting the

lookback

in the config to

to see if that has an effect. https://github.com/GtheSheep/tap-tiktok/blob/653e286c1d68e2883caf836202e639b8f175ae8b/tap_tiktok/tap.py#L79

Felipe Solera Bosso

09/05/2025, 6:54 PM

not worked, I tried to make the request with requests without meltano and apparently to have the metrics data I need the auth token, in meltano too?

3 Views

Open in Slack

Previous Next