Add functionality to filter by campaign, ad set, and ad name.

[dennis-adsviewer]

We should add functionality to filter by campaign name, ad set name and ad name. This was one of the 1-30 day improvements we committed to with Versuni.

Generally this should require:

• update channel-meta / channel-linkedin / channel-tiktok ingress to include adset_id, adset_name, campaign_id, campaign_name and store in BE
• expose fields to frontend in a way where a user can filter on either of these values through a regex / contains / other wildcard setup, it should not be exclusive but complementary, ie. user can write multiple contains queries on campaign_name level

[trixobird]

should this take priority over integrating with stripe?

[dennis-adsviewer]

yes I think it should, re. Versuni it will be more impactful vs. Stripe right now.

On Fri, 6 Sept 2024 at 13:07, Giorgos Trichopoulos @.***> wrote:

should this take priority over integrating with stripe?

— Reply to this email directly, view it on GitHub https://github.com/adsviewer/turboviewer/issues/501#issuecomment-2333818860, or unsubscribe https://github.com/notifications/unsubscribe-auth/AY4X4RW7ZZPHZUO7RBTTMDDZVGEH3AVCNFSM6AAAAABNYKQBWSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGMZTHAYTQOBWGA . You are receiving this because you authored the thread.Message ID: @.***>

-- Dennis Kreeft Founder

[trixobird]

    const response = await Tiktok.tikTokFetch(integration.accessToken, `${baseUrl}/report/task/create`, {
      method: 'POST',
      body: JSON.stringify({
        ...tikTokTimeRange,
        advertiser_id: externalId,
        data_level: 'AUCTION_AD',
        dimensions: ['ad_id', 'placement', 'stat_time_day'],
        report_type: 'AUDIENCE',
        metrics: ['campaign_name','campaign_id','adgroup_name','adgroup_id','ad_name', 'ad_id', 'placement_type', 'impressions', 'spend','clicks'],
      }),
    });

extra dimensions and fields for that call are available here: https://business-api.tiktok.com/portal/docs?id=1751454162042882

[trixobird]

Hi @dennis-adsviewer , can you let me know the fields that we need for LinkedIn?

Currently I am getting 'clicks,impressions,pivotValues,costInLocalCurrency,dateRange' and I using pivotValues to determine the creativeId which I am treating as adId. We are not saving any ad names for LinkedIn.

I am assuming that I am doing something wrong :)